[mythtv-users] Can't start Mythbackend
Paul Harrison
mythtv at dsl.pipex.com
Sun Nov 4 17:40:22 UTC 2007
Eric Robinson wrote:
> Before I get into stuff, I'll give some background to my situation.
>
> Last Wednesday evening I installed the packages required for MythDVD
> to be able to import properly. Things went slowly but I eventually
> got it to work.
>
> Thursday comes around and all of a sudden the Frontends started
> hanging. I went downstairs and found a crazy set of error messages in
> the terminal running mythbackend. Some huge block of MYSQL selections
> and such that came up in an error surrounded by fairly normal reports.
>
> It turns out that the Mythtv error logs had gotten to be several
> gigabytes in size and actually filled the filesystem, making booting
> and any actual operation a chore for the system. After deleting the
> files, the system returned to its peppy self.
>
> [The error logs contained seemingly endless copies of the same report:
> some error from libdvdread (or something) saying it couldn't access
> the drive.]
>
> I ran mythtv-setup while the computer was in that filled up state and
> screwed up the mysql settings. After I made room on the drive I ran
> it again and filled all the settings with the standard affair. My
> /etc/mythtv/mysql.txt file now contains the following:
>
> DBHostName=localhost
> DBUserName=mythtv
> DBName=mythconverg
> DBPassword=mythtv
>
>
> However, I still cannot log into mythbackend. Here's the sequence I
> now try to follow without any results:
>
> 1. mysql -u root mythconverg
> 1. grant all on mythconverg.* to mythtv@" 192.168.10.%"
> identified by "mythtv";
> 2. flush privileges;
> 2. mythtv-setup
> 1. all settings default (this was what I used to set up the
> computer initially and had everything running smoothly).
> 2. Snipped terminal output sample (from mythtv-setup):
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2007-11-04 12:04:53.365 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError? Strange...
> 2007-11-04 12:04:53.419 Unable to connect to database!
> 2007-11-04 12:04:53.420 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-11-04 12:04:53.474 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError? Strange...
> 2007-11-04 12:04: 53.528 Database not open while trying to
> load setting: Language
> 3. mythbackend
> 1. Terminal output:
> 2007-11-04 12:07:51.453 Using runtime prefix = /usr
> 2007-11-04 12:07:51.460 New DB connection, total: 1
> 2007-11-04 12:07:51.464 Unable to connect to database!
> 2007-11-04 12:07:51.464 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-11-04 12:07:51.518 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError? Strange...
> 2007-11-04 12:07: 51.573 Failed to init MythContext, exiting.
>
> Anyone have any idea why I'm unable to connect? Anyone have any ideas?
>
> I tried changing the "Host" value in mythtv-setup but that change
> wasn't reflected in /etc/mythtv/mysql.txt. Is that expected?
>
> Thanks!
>
> - Eric
>
Check you haven't got other mysql.txt files in other locations with
different settings. ~/.mythtv/mysql.txt and
'/usr/share/mythtv/.mysql.txt are common locations. Not sure if
/etc/mythtv/mysql.txt is even one of the locations searched?
Paul H.
More information about the mythtv-users
mailing list