[mythtv-users] Backend won't start automatically on boot

[Daniel Arfsten]

Hi there,
I am guessing it's the user that is trying to start mythtv that's the problem. When you
manually start mythtv-backend, do you use sudo in your command? What user do you log in
with? Also, how does your hosts file look? What ip do you have in the mythtv-setup?
I am not entirely sure how to help but it sounds like the user that is being used to 
start mythtv when the machine starts up isn't allowed to connect to the database
but when you use sudo, that works because root can access anything. I think? Sorry
I couldn't be more help.

Daniel

[Hello,
[    I have a remote backend running on ubuntu 7.10.  I have the
[mythtv-backend service set to start on boot, but it never gets started
[so I have to manually sudo /etc/init.d/mythtv-backend anytime the
[computer is rebooted, and it connects fine.  I just took a look at the
[logs and it appears that the backend is starting at boot but failing
[to connect to the database on the master.  I have the right hostname
[and mysql password in /etc/mythtv/mysql.txt.   Any suggestions?  Here
[is what my log looks like:
[#this is from the startup
[2007-12-03 09:22:52.672 Using runtime prefix = /usr
[2007-12-03 09:22:53.466 New DB connection, total: 1
[2007-12-03 09:22:56.726 Unable to connect to database!
[2007-12-03 09:22:56.741 Driver error was [1/2003]:
[QMYSQL3: Unable to connect
[Database error was:
[Can't connect to MySQL server on 'Pvt-Hudson' (113)
[ 
[QSqlQuery::exec: database not open
[QSqlQuery::exec: database not open
[2007-12-03 09:23:02.831 DB Error (KickDatabase):
[Query was:
[SELECT NULL;
[No error type from QSqlError?  Strange...
[2007-12-03 09:23:02.882 Failed to init MythContext, exiting.
[ 
[#this is after restarting the service manually.
[2007-12-03 09:29:46.175 Using runtime prefix = /usr
[2007-12-03 09:29:46.191 New DB connection, total: 1
[2007-12-03 09:29:46.250 Connected to database 'mythconverg' at host: Pvt-Hudson
[2007-12-03 09:29:46.261 Current Schema Version: 1160
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071203/3b1b0115/attachment.htm