<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Helvetica, Arial, sans-serif">Hello all,<br>
<br>
I've been here before, somehow got past it, now I'm here again.<br>
<br>
I'm running Ubuntu and have followed this guide:<br>
<a class="moz-txt-link-freetext" href="https://help.ubuntu.com/community/MythTV_Edgy_Backend_Frontend_Desktop">https://help.ubuntu.com/community/MythTV_Edgy_Backend_Frontend_Desktop</a><br>
<br>
I did this a couple of weeks ago, then got stuck. Intended to come
straight back to it, but family and work life have been hectic. Anyway,
I'm back to it now.<br>
<br>
All seems to go fine until I get to running mythtv-setup, where it
seems I can't connect to any database. I'm having this problem whether
I log into Ubuntu as 'mythtv' or my own user account. Here's the output
from mythtv-setup:<br>
<br>
SELECT NULL;<br>
No error type from QSqlError? Strange...<br>
2007-03-09 19:25:42.847 Database not open while trying to load setting:
<br>
GuiResolution<br>
2007-03-09 19:25:42.979 Unable to connect to database!<br>
2007-03-09 19:25:42.980 Driver error was [1/1045]:<br>
QMYSQL3: Unable to connect<br>
Database error was:<br>
Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)<br>
<br>
QSqlQuery::exec: database not open<br>
QSqlQuery::exec: database not open<br>
2007-03-09 19:25:43.071 DB Error (KickDatabase):<br>
Query was:<br>
SELECT NULL;<br>
No error type from QSqlError? Strange...<br>
2007-03-09 19:25:43.131 Database not open while trying to load setting:
<br>
GuiWidth<br>
2007-03-09 19:25:43.192 Unable to connect to database!<br>
2007-03-09 19:25:43.192 Driver error was [1/1045]:<br>
QMYSQL3: Unable to connect<br>
Database error was:<br>
Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)<br>
<br>
QSqlQuery::exec: database not open<br>
QSqlQuery::exec: database not open<br>
2007-03-09 19:25:43.303 DB Error (KickDatabase):<br>
Query was:<br>
SELECT NULL;<br>
No error type from QSqlError? Strange...<br>
2007-03-09 19:25:43.355 Database not open while trying to load setting:
<br>
GuiHeight<br>
2007-03-09 19:25:43.832 Unable to connect to database!<br>
2007-03-09 19:25:43.832 Driver error was [1/1045]:<br>
QMYSQL3: Unable to connect<br>
Database error was:<br>
Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)<br>
<br>
etc etc<br>
there's loads of this.<br>
<br>
Here's what I've checked:<br>
/home/'myuser'/.mythtv/mysql.txt contains:<br>
DBHostName=192.168.0.2<br>
DBUserName=mythtv<br>
DBPassword=mythtv<br>
DBName=mythconverg<br>
DBType=QMYSQL3<br>
<br>
/home/mythtv/.mythtv/mysql.txt contains:<br>
DBHostName=192.168.0.2<br>
DBUserName=mythtv<br>
DBPassword=mythtv<br>
DBName=mythconverg<br>
DBType=QMYSQL3<br>
<br>
/etc/mythtv/mysql.txt contains:<br>
DBHostName=localhost<br>
DBUserName=mythtv<br>
DBName=mythconverg<br>
DBPassword=mythtv<br>
<br>
although<br>
/etc/mythtv/mysql.txt~ contains:<br>
DBHostName=localhost<br>
DBUserName=mythtv<br>
DBName=mythconverg<br>
DBPassword=<br>
but I assume that's an older unused file.<br>
<br>
The password when I go into mythtv-setup (after all the errors) is set
to <br>
mythtv.<br>
<br>
I've just changed /etc/mythtv/mysql.txt to say </font><font
face="Helvetica, Arial, sans-serif">DBHostName=</font><font
face="Helvetica, Arial, sans-serif">192.168.0.2, but myhtv-setup is
still giving me the same problems.<br>
<br>
$ mysql -u root mysql<br>
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using <br>
password: NO)<br>
<br>
but<br>
<br>
$ mysql -u mythtv -p mythconverg<br>
Enter password: <mythtv><br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 132 to server version: 5.0.24a-Debian_9-log<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>
<br>
mysql><br>
<br>
What should I do now? Should I try to remove things entirely and start
yet again? I wouldn't mind doing that if I thought things would be
different next time, but this is the second time I've been here.<br>
<br>
Please help. I just want a media centre :-)<br>
<br>
Damian<br>
<br>
<br>
<br>
</font>
</body>
</html>