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

Marc drayson at net1plus.com
Sun Jan 20 13:46:59 UTC 2008


> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> bounces at mythtv.org] On Behalf Of Piers Kittel
> Sent: Sunday, January 20, 2008 6:40 AM
> To: Discussion mythtv about
> Subject: [mythtv-users] MythTV start up problems (permissions)
> 
> 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

Piers,

Do this for me. 
First, tell me what user you are logged into the system as when you start
mythbackend by hand.

Next connect to mysql at the command line.
At the mysql> type the following
USE mysql;
Then type
SELECT Host, User FROM user;
Then respond back with the results.

Then post the entire startup script that Debian uses for myth. I use Gentoo
so I don't have an example of this.

I should then be able to identify the issue. I hope.

Marc




More information about the mythtv-users mailing list