59
« on: January 31, 2008, 05:57:38 am »
No luck from the LMCE interface either, I don't see any error, but I don't see anything at all. It asks me if I want to run mythfilldatabase, I say yes and it brings me back to the main screen and that's it.
Not sure where to check for error on that one.
I tried to run it manually again from a console and now I get this.
gaffney@dcerouter:/var/log/mythtv$ sudo mythfilldatabase
2008-01-30 22:54:01.981 Using runtime prefix = /usr
2008-01-30 22:54:02.017 New DB connection, total: 1
2008-01-30 22:54:02.026 Unable to connect to database!
2008-01-30 22:54:02.027 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-01-30 22:54:02.085 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2008-01-30 22:54:02.140 Failed to init MythContext, exiting.
2008-01-30 22:54:02.145 DataDirect: Deleting temporary files
gaffney@dcerouter:/var/log/mythtv$
My SQL skill are not good, but maybe this will help (I'm probably not doing this right)
I took a look at the existing mysql dbs by doing this
mysql mysql
SHOW DATABASES;
I see this
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| asterisk |
| asteriskcdrdb |
| mysql |
| mythconverg |
| pluto_main |
| pluto_media |
| pluto_myth |
| pluto_security |
| pluto_telecom |
+--------------------+
10 rows in set (0.00 sec)
I am assuming the mythfilldatabase command is trying to loginto the "pluto_myth" DB.
So I tried this command to manually log into the pluto_myth DB as user mythtv (based on the error).
"mysql -u mythtv -p pluto_myth"
It prompts for a password, I've tried the only password I have and it fails with the same
"Access denied for user 'mythtv'@'localhost"
I've also tried no password.
I no nothing about mysql, but maybe the password for the mythtv user needs to be reset? But how do I know what it's suppose to be?
Or maybe I'm way off base here....