[mythtv-users] My MySql hell :-)

Damian Surr damian at gingermagic.co.uk
Fri Mar 9 19:59:47 UTC 2007


Hello all,

I've been here before, somehow got past it, now I'm here again.

I'm running Ubuntu and have followed this guide:
    https://help.ubuntu.com/community/MythTV_Edgy_Backend_Frontend_Desktop

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.

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:

SELECT NULL;
No error type from QSqlError?  Strange...
2007-03-09 19:25:42.847 Database not open while trying to load setting:
GuiResolution
2007-03-09 19:25:42.979 Unable to connect to database!
2007-03-09 19:25:42.980 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-03-09 19:25:43.071 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2007-03-09 19:25:43.131 Database not open while trying to load setting:
GuiWidth
2007-03-09 19:25:43.192 Unable to connect to database!
2007-03-09 19:25:43.192 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-03-09 19:25:43.303 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2007-03-09 19:25:43.355 Database not open while trying to load setting:
GuiHeight
2007-03-09 19:25:43.832 Unable to connect to database!
2007-03-09 19:25:43.832 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)

etc etc
there's loads of this.

Here's what I've checked:
/home/'myuser'/.mythtv/mysql.txt contains:
DBHostName=192.168.0.2
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3

/home/mythtv/.mythtv/mysql.txt contains:
DBHostName=192.168.0.2
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3

/etc/mythtv/mysql.txt contains:
DBHostName=localhost
DBUserName=mythtv
DBName=mythconverg
DBPassword=mythtv

although
/etc/mythtv/mysql.txt~ contains:
DBHostName=localhost
DBUserName=mythtv
DBName=mythconverg
DBPassword=
but I assume that's an older unused file.

The password when I go into mythtv-setup (after all the errors) is set to
mythtv.

I've just changed /etc/mythtv/mysql.txt to say DBHostName=192.168.0.2, 
but myhtv-setup is still giving me the same problems.

$ mysql -u root mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)

but

$ mysql -u mythtv -p mythconverg
Enter password: <mythtv>
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 132 to server version: 5.0.24a-Debian_9-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

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.

Please help. I just want a media centre :-)

Damian



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070309/4232180a/attachment-0001.htm 


More information about the mythtv-users mailing list