[mythtv-users] 0.19 almost working (port or password problems?)

[Mark Knecht]

Hi,
   OK, with the Gentoo-WIKI back up I've made some good progress. I've
got MythTV installed, have the database installed (I THINK), can run
mythtv-setup, have the cards configured and hooked up in Myth, and can
run mythfilldatabase to get listings. So far I cannot, though, do
anything real as it appears I'm not communicating with the backend.

   At this point both mysql and mythbackend appear to be running:

dragonfly ~ # /etc/init.d/mysql status
 * status:  started

dragonfly ~ # ps aux | grep mysql
mysql    27328  0.2  7.5 137216 37640 ?        Ssl  05:49   0:38
/usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock

dragonfly ~ # /etc/init.d/mythbackend status
 * status:  started
dragonfly ~ #

However, when I try stopping mythbackend I get a complaint which is
not a good sign:

dragonfly ~ # /etc/init.d/mythbackend stop
  * Stopping MythTV Backend ...
start-stop-daemon: warning: failed to kill 28401: No such process
             [ !! ]dragonfly ~ #

   When I look in the backend log I get only this message repeated a few times:

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open

so clearly there is a problem. I tried Googling on that message and
found absolutely no matches and don't know how to proceed.

   I do wonder about port and socket configuration. In
/etc/mysql/my.cnf I have this:

dragonfly ~ # cat /etc/mysql/my.cnf
# /etc/mysql/my.cnf: The global mysql configuration file.
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1,v 1.3
2006/05/05 19:51:40 chtekk Exp $

# The following options will be passed to all MySQL clients
[client]
#password                                       = your_password
port                                            = 3306
socket                                          = /var/run/mysqld/mysqld.sock

while in mythtv-setup I see port 6543 listed.

   Everything that follows from here on is really for background
reading and complete disclosure/documentation only..

   I am able to bring the frontend GUI up and, interestingly, can see
correct program listings even though I cannot connect to the backend.
Here's what I see running the frontend.

mark at dragonfly ~ $ mythfrontend
2006-07-18 10:41:14.417 Using runtime prefix = /usr
2006-07-18 10:41:14.428 XScreenSaver support enabled
2006-07-18 10:41:14.450 New DB connection, total: 1
2006-07-18 10:41:14.458 Connected to database 'mythconverg' at host: localhost
2006-07-18 10:41:14.460 Total desktop dim: 1280x1024, with 1 screen[s].
2006-07-18 10:41:14.471 Using screen 0, 1280x1024 at 0,0
2006-07-18 10:41:14.474 Current Schema Version: 1123
2006-07-18 10:41:14.474 mythfrontend version: 0.19.20060121-2 www.mythtv.org
2006-07-18 10:41:14.474 Enabled verbose msgs:  important general
2006-07-18 10:41:14.704 lang0: eng
2006-07-18 10:41:14.704 lang: eng
2006-07-18 10:41:14.713 lang1: eng
2006-07-18 10:41:14.713 lang: eng
2006-07-18 10:41:14.770 Total desktop dim: 1280x1024, with 1 screen[s].
2006-07-18 10:41:14.772 Using screen 0, 1280x1024 at 0,0
2006-07-18 10:41:14.772 Switching to square mode (blue)
2006-07-18 10:41:15.139 Registering Internal as a media playback plugin.
2006-07-18 10:41:20.210 Connecting to backend server:
192.168.1.55:6543 (try 1 of 5)
2006-07-18 10:41:20.211 Connection timed out.
                        You probably should modify the Master Server
                        settings in the setup program and set the
                        proper IP address.
2006-07-18 10:41:21.252 ProgramList::FromScheduler(): Error querying master.
2006-07-18 10:41:37.574 Connecting to backend server:
192.168.1.55:6543 (try 1 of 5)
2006-07-18 10:41:37.574 Connection timed out.
                        You probably should modify the Master Server
                        settings in the setup program and set the
                        proper IP address.
mark at dragonfly ~ $


At the command line I can log into mysql:

mark at dragonfly ~ $ mysqladmin -u root processlist -p
Enter password:
+-----+------+-----------+----+---------+------+-------+------------------+
| Id  | User | Host      | db | Command | Time | State | Info             |
+-----+------+-----------+----+---------+------+-------+------------------+
| 106 | root | localhost |    | Query   | 0    |       | show processlist |
+-----+------+-----------+----+---------+------+-------+------------------+
mark at dragonfly ~ $

and also:

mark at dragonfly ~ $ mysqladmin -u root -h dragonfly processlist -p
Enter password:
+-----+------+-----------------+----+---------+------+-------+------------------+
| Id  | User | Host            | db | Command | Time | State | Info
         |
+-----+------+-----------------+----+---------+------+-------+------------------+
| 107 | root | Dragonfly:36579 |    | Query   | 0    |       | show
processlist |
+-----+------+-----------------+----+---------+------+-------+------------------+
mark at dragonfly ~ $

and from another machine I can log in as mythtv but not as root, which
is I think by design:

mark at lightning ~ $  mysqladmin -u root -h dragonfly processlist -p
Enter password:
mysqladmin: connect to server at 'dragonfly' failed
error: 'Access denied for user 'root'@'Lightning' (using password: YES)'
mark at lightning ~ $  mysqladmin -u mythtv -h dragonfly processlist -p
Enter password:
+-----+--------+-----------------+----+---------+------+-------+------------------+
| Id  | User   | Host            | db | Command | Time | State | Info
           |
+-----+--------+-----------------+----+---------+------+-------+------------------+
| 109 | mythtv | Lightning:49023 |    | Query   | 0    |       | show
processlist |
+-----+--------+-----------------+----+---------+------+-------+------------------+
mark at lightning ~ $


Thanks,
Mark