<div class="gmail_quote">On Sat, May 8, 2010 at 10:11 AM, Andrew <span dir="ltr"><<a href="mailto:mythtv@heathsworld.com">mythtv@heathsworld.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I just upgraded to JYA .23 and now when I start mythfront is tells me it cannot connect to the database. What I found is the backend is showing the error below (BE and FE on same machine). As it turns out, when the system tries to start the back end it gets permission denied when trying to access the database. Yet if i start it as a user or root using "mythbackend" command it connects just fine. Did the configuration file location get changed or something? Obviously /.myth doesn't exist and show below.<br>
<br>Would you like to configure the database connection now? [no] <br>[console is not interactive, using default 'no']<br>2010-05-08 10:04:39.354 Deleting UPnP client...<br>2010-05-08 10:04:39.942 Failed to init MythContext, exiting.<br>
2010-05-08 10:04:40.032 mythbackend version: branches/release-0-23-fixes [24473] <a href="http://www.mythtv.org" target="_blank">www.mythtv.org</a><br>2010-05-08 10:04:40.032 Using runtime prefix = /usr<br>2010-05-08 10:04:40.032 Using configuration directory = /.mythtv<br>
2010-05-08 10:04:40.033 Unable to read configuration file mysql.txt<br>2010-05-08 10:04:40.033 Empty LocalHostName.<br>2010-05-08 10:04:40.033 Using localhost value of myth<br>2010-05-08 10:04:40.037 New DB connection, total: 1<br>
2010-05-08 10:04:40.042 Unable to connect to database!<br>2010-05-08 10:04:40.043 Driver error was [1/1045]:<br>QMYSQL: Unable to connect<br>Database error was:<br>Access denied for user 'mythtv'@'localhost' (using password: YES)<br>
<br>To summarize, only using the upscript to start the backend fails. Any starting with the mythbackend command from the terminal and it works fine.<br><br>
</blockquote></div><br>Oddly enough, ps -aux shows the upscript running as root.<br><br>root 18020 0.5 0.6 287324 39032 ? D 11:45 0:00 /usr/bin/mythbackend --logfile /var/log/mythtv/mythbackend.log<br><br>
but it cannot access the database. Why would running it directly from a root terminal work, but the upstart script running as root not work? What happened with .23 that may have changed this and what did it change?<br>