[mythtv-users] MySQL Connection Problems
Jonathan Black
jblack2 at smartertek.net
Wed Aug 23 09:50:41 UTC 2006
Will Constable wrote:
>Thanks a lot-- this mostly worked to fix my problem, although my mythweb is
>broken. Do you know if there are any special changes that need to be made
>for mythweb?
>
>Will
>
>
>-----Original Message-----
>From: mythtv-users-bounces at mythtv.org
>[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Kevin Kuphal
>Sent: Sunday, August 20, 2006 5:17 PM
>To: Discussion about mythtv
>Subject: Re: [mythtv-users] MySQL Connection Problems
>
>Will Constable wrote:
>
>
>>I have a single machine setup and yet I have managed to cause
>>connection problems. Today I decided to change my hostname from
>>default (localhost.localdomain) to the hostname I'm used to my file
>>server being. This way I can map network shares from windows computers
>>using hostname instead of ip address, which keeps changing.
>>
>>Upon changing my hostname, mythtv broke. I thought it would be an easy
>>fix of changing ~/.mythtv/mysql.txt to reflect the new hostname. After
>>tinkering with both root's and the user 'myth' who autologons and
>>autoruns the frontend, it still does not work. I have tried playing
>>with granting privileges on mysql after reading other peoples
>>problems, but im not sure if this is actually the problem, but if it
>>is I don't know enough about mysql commands to figure it out.
>>
>>Mythtvsetup runs but does not seem to reflect my previous settings,
>>suggesting it does not connect to the DB. It does seem to have
>>connected though, so hopefully that doesn't mean it trashed the
>>contents of the DB.
>>
>>Essentially, I have a crippled system and after a few hours of
>>attempts I can't really be sure what values various settings had
>>earlier and how to get things working again. As a last resort I could
>>delete the database and reset the whole thing, but I really want to
>>preserve it. Any suggestions?
>>
>>
>>
>http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.15
>
>Kevin
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>.
>
>
>
Will,
Check your apache config. Mine contains the line 'setenv
db_server "localhost"' ---- You'll need to change that.
Jonathan
More information about the mythtv-users
mailing list