[mythtv-users] MythTV start up problems (permissions)

Piers Kittel mailing at biased.org
Sun Jan 20 11:39:33 UTC 2008


Hello all,

Have been using Myth TV for a while.  My current setup uses Debian and  
MythTV  precompiled binaries downloaded from debian-multimedia.org.   
The startup scripts never works so I just use screen and start up the  
process manually.  Recently though, the backend keep seg faulting, and  
I don't have time to sort that out right now, so I have been looking  
at scripts that restarts the backend automatically but they require  
the backend to start up automatically.  The issue here is if I start  
the backend as root manually, it works:

-----------------------------------------------
destiny:/var/log/mythtv# mythbackend
2008-01-20 11:33:35.692 Using runtime prefix = /usr
2008-01-20 11:33:35.813 New DB connection, total: 1
2008-01-20 11:33:35.833 Connected to database 'mythconverg' at host:  
localhost
2008-01-20 11:33:35.893 Current Schema Version: 1160
Starting up as the master server.
<snip>
-----------------------------------------------

No problems here.

On the other hand, when trying to use the provided scripts, here's  
what happens:

-----------------------------------------------
destiny:/var/log/mythtv# ps aux | grep myth
root      2807  0.0  0.1   2848   700 pts/0    R+   11:34   0:00 grep  
myth
destiny:/var/log/mythtv# /etc/init.d/mythtv-backend start
mythbackend already running, use restart instead.
destiny:/var/log/mythtv# ps aux | grep myth
root      2818  0.0  0.1   2848   704 pts/0    R+   11:34   0:00 grep  
myth
destiny:/var/log/mythtv# /etc/init.d/mythtv-backend restart
Restarting MythTV server: mythbackend No /usr/bin/mythbackend found  
running; none killed.
.
.
destiny:/var/log/mythtv# ps aux | grep myth
root      2830  0.0  0.1   2848   700 pts/0    R+   11:34   0:00 grep  
myth
destiny:/var/log/mythtv#
-----------------------------------------------

The scripts fails to start the backend, so I look into the logs:

-----------------------------------------------
2008-01-20 11:34:39.882 Using runtime prefix = /usr
2008-01-20 11:34:39.985 New DB connection, total: 1
2008-01-20 11:34:40.005 Unable to connect to database!
2008-01-20 11:34:40.006 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-20 11:34:40.083 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-01-20 11:34:40.147 Failed to init MythContext, exiting.
-----------------------------------------------

The problem is obvious, it's a permissions problem with the database.   
So what am I doing wrong and how do I fix this?

Thanks very much for your time in advance!

Regards - Piers


More information about the mythtv-users mailing list