[mythtv-users] Can't schedule recordings

[Nick Morrott]

On 03/02/07, Dave M G <martin at autotelic.com> wrote:
> 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,

The MythTV wiki and docs contain some useful pointers -
http://mythtv.org/wiki/index.php/Mysql and
http://mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2.

We may need to check which users have passwords set in mysql, and
whether these passwords match for the same user connecting from a
different host. We can do this (don't worry, actual passwords will not
be displayed, only their hashes) with:

# mysql -u root mysql
(enter password)

mysql>select Host,User,Password from user;

You should see a table listing of hostnames, mysql users, and password
hashes. For all users called 'mythtv', do their password hashes match?
Are there any mythtv users with missing passwords?

Nick
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin