[Techtalk] mythtv issue

[Gretchen Dziengel]

On Fri, Dec 17, 2004 at 04:34:22PM -0600 or thereabouts, Christine Bussman wrote:
> Last week I set up a box to run MythTV, and it was working great.  
> However, Wednesday night I made some changes so that I could connect 
> with the frontend on another computer, and since then the backend has 
> been really unstable.  It seems to crash every half hour or so, whether 
> or not I'm running the frontend.  I've tried to put things back in the 
> state they were before I made changes, but I don't know how to.  When 
> the backend dies, it just disappears, but the init script still believes 
> it is running.  I've checked the logs for both mythtv and mysql and can 
> find nothing.  I tried running mythbackend at the console to look for 
> interesting messages, but the only thing that looks at all wrong is the 
> last line which simply tells me it died.

Did you change anything else?  I've changed the permissions on my mythtv
database to allow me to connect from another computer and that didn't
make the backend lock up at all.  I've found that automatic commercial
detection will crash my backend without fail.  What version are you
running?  I had the commercial detection crash on both 0.16 and CVS.
 
> changes I made:
> commented out the bind-address line in /etc/mysql/my.cnf
> altered the permissions on mythconverg (the database used for mythtv) so 
> that I could access it from other machines also
> 
> I can revert the first change, but I don't know how to fix what I did to 
> the database.  I used several commands similar to grant all on 
> mythconverg.* to <user>@<various things went here> identified by 
> <password here>. 

I think the command you want is REVOKE instead of grant.
> 
> 

I compiled my MythTV from source so I haven't even got the backend to
run on boot.  Sorry I can't help with that...I'd like it to restart
automatically too.

I run it with 
mythbackend -l /var/log/mythbackend.log

Check a few lines back and see if anything besides a recording starting
happened.

Good Luck!
Gretchen