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

[Phil Bridges]

On Dec 3, 2007 12:38 PM,  <mythmail at gmail.com> wrote:
> 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

Has your network started by the time mythbackend attempts to start?