<br><div class="gmail_quote">On Tue, Jun 1, 2010 at 10:19 AM, Nasa <span dir="ltr"><<a href="mailto:nasa01@comcast.net">nasa01@comcast.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im"><br>
----- "Jack Perveiler" <<a href="mailto:perveilerj@gmail.com">perveilerj@gmail.com</a>> wrote:<br>
<br>
> ><br>
> ><br>
</div><div><div></div><div class="h5">> > > > But if I run the same command again<br>
> > ><br>
> > > Here's what I noted as a problem. The 'R' option updates only the<br>
> > > reference number -- it doesn't download anything. The next<br>
> > > run should have been without the 'R'.<br>
> > ><br>
> > ><br>
> > ><br>
> > ><br>
> > > Yeah, I thought of that too. Oddly, if I run with -I<br>
> (interactive)<br>
> > > instead of -R I get prompted for the missing entries like with -R<br>
> > > except it also pulls the fanart, etc from <a href="http://themoviedb.org" target="_blank">themoviedb.org</a> . The<br>
> > files<br>
> > > are sitting in the right place on my system. The inetref is still<br>
> > all<br>
> > > 0's though. If I run in maintenance mode after that (after -I or<br>
> > -R,<br>
> > > doesn't matter) I get a message telling me that X-Men has no<br>
> inetref<br>
> > > so it won't fetch anything.<br>
> > > <br>
> > ><br>
> > ><br>
> > > > I get the same prompting for X-Men<br>
> > > > again. Thinking this was odd, I checked the database after the<br>
> > run:<br>
> > > ><br>
> > > > mysql> select title,inetref from videometadata where title like<br>
> > > > "X-Men";<br>
> > > > +-------+----------+<br>
> > > > | title | inetref |<br>
> > > > +-------+----------+<br>
> > > > | X-Men | 00000000 |<br>
> > > > +-------+----------+<br>
> > > ><br>
> > ><br>
> > > Yeah, This seems odd. Jamu shouldn't have done anything, as file<br>
> > > was already in database with a inetref number.<br>
> > ><br>
> > ><br>
> ><br>
> > I was thinking about this.... Could you set the inetref number to<br>
> > NULL?<br>
> > That's what the db defaults that field too. Then try again with the<br>
> > 'R'<br>
> > option and see what happens.<br>
> ><br>
> ><br>
> ><br>
> ><br>
> > Hmm, that is wierd. According to mysql the default value for<br>
> inetref<br>
> > IS NULL, but immediately following a mythvideo rescan (delete all<br>
> > entries from videometadata and rescan upon entering mythvideo) it is<br>
> > populated with the 8 0's. If I jam in NULL instead with:<br>
> ><br>
> > mysql> update videometadata set inetref=NULL where title="X-Men";<br>
> > Query OK, 1 row affected, 1 warning (0.00 sec)<br>
> > Rows matched: 1 Changed: 1 Warnings: 1<br>
> ><br>
> > mysql> select title,inetref from videometadata where title =<br>
> "X-Men";<br>
> > +-------+---------+<br>
> > | title | inetref |<br>
> > +-------+---------+<br>
> > | X-Men | |<br>
> > +-------+---------+<br>
> ><br>
> ><br>
> > and then run jamu with -r again I get the same results (ie inetref<br>
> not<br>
> > updated, only now it's still NULL instead of all 0's)<br>
> ><br>
> ><br>
> ><br>
><br>
> While from reading your messages this seems unlikely, but I figured I<br>
> would<br>
> ask just to make sure... You are editing the database with the same<br>
> user<br>
> that is running Jamu? Or stated another way, all users who interact<br>
> with<br>
> the database have write access to it..<br>
><br>
><br>
><br>
> Correct. I run jamu as part of a cron job as user mythtv. As user<br>
> mythtv I can use mysql to modify the inetref manually. I run<br>
> mythfrontend as user perveil. I can also update the inetref manually<br>
> via mysql as this user. Running jamu as user perveil has the same<br>
> results as running as user mythtv (ie inetref isn't updated).<br>
><br>
> Basically, both users can modify the fields using mysql, neither user<br>
> can modify the fields using jamu.<br>
<br>
</div></div>The more I read over this, the more I want to make sure permissions aren't<br>
a cause for it... When you log into your database using mysql how do you<br>
log in?<br>
<br>
ie something like this: mysql -u mythtv -pmythtv mythconverg?<br></blockquote><div><br>Yes, just like that (except I leave the passwd out after the '-p' and type it when prompted). I use the same username and password as is specified by <DBUserName> and <DBPassword> in /home/perveil/.mythtv/config.xml (which incidentally has the same username and password as /home/mythtv/.mythtv/config.xml).<br>
<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
You also mentioned starting the frontend via user perveil, what users starts<br>
mythbackend?<br>
<br>
Again, I maybe picking at straws -- but the needle must be in there somewhere....<br>
<div><div></div><div class="h5"><br></div></div></blockquote></div><br>Mythbackend is started as user mythtv, just like the cron jamu run.<br><br>