[mythtv-users] DB Connection Error Ubuntu 9.10 JYA 0.23

James Crow crow.jamesm at gmail.com
Mon Apr 19 12:13:48 UTC 2010


Hi all,

  Yesterday I upgraded my MBE running Ubuntu 9.10 to 0.23 from JYA's repo. I
had been using his repo the entire time I had 0.22 installed. I simply added
testing to the end of the deb line and did an apt-get update, apt-get
upgrade.

  The problem now is that mythbackend is unable to connect to the MySQL
server if started from the /etc/init.d/mythtv-backend script. If I start the
backend from a console with sudo mythbackend it starts and connects fine. In
fact I left it running from a console all night and it recorded and I was
able to watch recordings. Everything appears to be working well, except
starting from the /etc/init.d script. The line that gets run when starting
from the init script is:
/usr/bin/mythbackend --logfile /var/log/mythtv/mythbackend.log --user mythtv

Here is the log file from a startup attempt:
2010-04-18 15:28:47.206 mythbackend version: branches/release-0-23-fixes
[24158] www.mythtv.org
2010-04-18 15:28:47.223 Using runtime prefix = /usr
2010-04-18 15:28:47.239 Using configuration directory = /.mythtv
2010-04-18 15:28:47.256 Unable to read configuration file mysql.txt
2010-04-18 15:28:47.273 Empty LocalHostName.
2010-04-18 15:28:47.290 Using localhost value of james-desktop
2010-04-18 15:28:47.320 New DB connection, total: 1
2010-04-18 15:28:47.364 Unable to connect to database!
2010-04-18 15:28:47.389 Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)

................................................................................
2010-04-18 15:28:49.970 UPnPautoconf() - No UPnP backends found
2010-04-18 15:28:49.988 No UPnP backends found

No UPnP backends found

Would you like to configure the database connection now? [no]
[console is not interactive, using default 'no']
2010-04-18 15:28:50.090 Deleting UPnP client...


The thing that appears odd to me is the "Using configuration directory =
/.mythtv" I think it should be /home/mythtv/.mythtv. The users mythtv exists
and has its home directory set to /home/mythtv. The /home/mythtv/.mythtv
directory exists and has links to the /etc/mythtv config files.

Any idea why starting from the init script (actually an upstart job) does
not pull in the correct user environment?

Thanks,
James
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100419/87f794e7/attachment.htm>


More information about the mythtv-users mailing list