[mythtv-users] Can't schedule recordings

Dave M G martin at autotelic.com
Sat Feb 3 13:33:16 UTC 2007


Nick,

Thank you for responding. I have followed through on your advice in 
order to investigate the problem more thoroughly.

I'm stuck at a certain point, however.

I checked the logs in /var/log/mythtv/

Immediately it was obvious that there was a problem accessing the database:

dave at homebase:/var/log/mythtv$ more mythbackend.log
2007-02-03 22:07:33.534 Using runtime prefix = /usr
2007-02-03 22:07:34.068 New DB connection, total: 1
2007-02-03 22:07:34.142 Unable to connect to database!
2007-02-03 22:07:34.149 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
2007-02-03 22:07:34.707 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2007-02-03 22:07:34.763 Failed to init MythContext, exiting.


I checked to make sure there was a valid user called "mythtv" on my 
MySQL server:

dave at homebase:/var/log/mythtv$ mysql -u mythtv -p
Enter password: (mythtv)
Welcome to the MySQL monitor.

I looked up "Driver error was [1/1045]" on Google and came across this 
web site:
http://ubuntuforums.org/showthread.php?t=124994

Even though it's for a remote computer, and my Mythtv backend, database, 
and frontend are all running on the same computer, the error seemed to 
be the same.

So following the advice that worked for the poster in that forum, I 
logged in as root to MySQL and made sure that the "mythtv" user had 
proper privileges:
grant all on mythconverg.* to mythtv@"%" identified by "mythtv";

I then rebooted to make sure the Mythtv back and end the MySQL server 
and anything else were restarted.

However, checking the mythtv log files again showed the same error 
again, and I still can't schedule a recording.

At this point I feel a little stuck.

Did I make a mistake somewhere in pursuing this problem?

What avenue should I try next?


--
Dave M G
Ubuntu 6.10 Edgy Eft
Kernel 2.6.17.7
Pentium D Dual Core Processor
PHP 5, MySQL 5, Apache 2


More information about the mythtv-users mailing list