On 11/12/06, <b class="gmail_sendername">Tom Purl</b> <<a href="mailto:tom@tompurl.com">tom@tompurl.com</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi, I used to run a mythtv 0.20 system on Ubuntu, but I recently<br>switched to Gentoo. After setting everything up and installing<br>mythtv, I ran the following command to restore my old DB:<br><br> mysql -u root -h localhost < /home/foo/backups/mythdb_061102.bak
<br><br>I then added the 'mythtv' user to mysql (5.0.26-log) by using the<br>following command from the mysql prompt:<br><br> grant all on mythdb.* to 'mythtv'@'localhost' identified by 'somepass';<br><br>I can then log into mysql as the mythtv user and create a test table,
<br>proving that I have the proper security access.<br><br>I also have a mysql.txt file in the following directories:<br><br>-rwxr----- 1 mythtv root 957 Nov 12 08:28 /etc/mythtv/mysql.txt<br>-rwxrw---- 1 foo foo 957 Sep 23 09:09 /home/foo/.mythtv/mysql.txt
<br><br>In tha tfile, I have the following text:<br><br> DBHostName=localhost<br> DBUserName=mythtv<br> DBPassword=somepass<br> DBName=mythdb<br> DBType=QMYSQL3<br><br>Here's my problem: when I try and start mythbackend
<br>(sudo /etc/init.d/mythbackend start) , I get the following error messasge<br>in /var/log/mythtv/mythbackend.log:<br><br> QSqlQuery::exec: database not open<br> QSqlQuery::exec: database not open<br><br>mysql is running, so I don't understand why I'm getting this error.
<br>Can anyone else see why this may be happening?<br><br>Thanks a ton in advance!<br><br>Tom Purl</blockquote><div><br>So you can "mysql -u mythtv -p mythconverg"?<br><br>Try using your real IP address instead of localhost. Something along the lines of
<a href="http://192.168.1.2">192.168.1.2</a>. Use that in mythtv-setup instead of localhost. <br></div><br></div>