[mythtv-users] Can't start Mythbackend

Eric Robinson ryunokokoro at gmail.com
Sun Nov 4 17:15:37 UTC 2007


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071104/a9475440/attachment.htm 


More information about the mythtv-users mailing list