[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