[mythtv-users] mythbackend on MBE Crashes When mythfrontend Attempts to Connect

Sat Aug 28 19:54:25 UTC 2010

Still working on getting my MBE back up and myth working for my 
family. When mythfrontend tries to connect to mythbackend on the MBE. 
It crashes mythbackend and leaves mythfrontend looking for it. Note 
mysql loads up just fine with mythtv for both user and password.

Below are the logs

Any help will be most appreciated.

-- Mache

# uname -r
2.6.32.19-163.fc12.i686

# rpm -qa | grep mythtv-backend
mythtv-backend-0.23.1-236.fc12.i686

# mysql -u mythtv -p
Enter password: <mythtv>
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.1.47 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

/var/log/mythtv/mythbackend.log

2010-08-28 12:39:06.687 mythbackend version: 
branches/release-0-23-fixes/mythtv/ [25469] www.mythtv.org
2010-08-28 12:39:06.688 Using runtime prefix = /usr
2010-08-28 12:39:06.691 Read conf dir = /var/lib/mythtv
2010-08-28 12:39:06.691 Using configuration directory = /var/lib/mythtv
2010-08-28 12:39:06.692 Empty LocalHostName.
2010-08-28 12:39:06.692 Using localhost value of XXX.YYY.COM
2010-08-28 12:39:06.721 New DB connection, total: 1
2010-08-28 12:39:06.726 Unable to connect to database!
2010-08-28 12:39:06.727 Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'XXX.YYY.COM' (using password: YES)

................................................................................
2010-08-28 12:39:09.286 UPnPautoconf() - No UPnP backends found
2010-08-28 12:39:09.287 No UPnP backends found

No UPnP backends found

Would you like to configure the database connection now? [no]
[console is not interactive, using default 'no']
2010-08-28 12:39:09.288 Deleting UPnP client...
2010-08-28 12:39:09.900 Failed to init MythContext, exiting.

/var/log/mysqld.log

100828 12:35:24 mysqld_safe Starting mysqld daemon with databases 
from /var/lib/mysql
100828 12:35:24 [Warning] option 'net_buffer_length': unsigned value 
8388608 adjusted to 1048576
100828 12:35:24 [Note] Plugin 'ndbcluster' is disabled.
100828 12:35:24  InnoDB: Started; log sequence number 0 59095
100828 12:35:24 [Note] Event Scheduler: Loaded 0 events
100828 12:35:24 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.47'  socket: '/var/lib/mysql/mysql.sock'  port: 
3306  Source distribution
100828 12:35:26 [Note] /usr/libexec/mysqld: Normal shutdown

100828 12:35:26 [Note] Event Scheduler: Purging the queue. 0 events
100828 12:35:26  InnoDB: Starting shutdown...
100828 12:35:30  InnoDB: Shutdown completed; log sequence number 0 59095
100828 12:35:30 [Note] /usr/libexec/mysqld: Shutdown complete

100828 12:35:30 mysqld_safe mysqld from pid file 
/var/run/mysqld/mysqld.pid ended
100828 12:35:30 mysqld_safe Starting mysqld daemon with databases 
from /var/lib/mysql
100828 12:35:30 [Warning] option 'net_buffer_length': unsigned value 
8388608 adjusted to 1048576
100828 12:35:30 [Note] Plugin 'ndbcluster' is disabled.
100828 12:35:30  InnoDB: Started; log sequence number 0 59095
100828 12:35:30 [Note] Event Scheduler: Loaded 0 events
100828 12:35:30 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.47'  socket: '/var/lib/mysql/mysql.sock'  port: 
3306  Source distribution

$ mythtv-setup
2010-08-28 12:46:03.692 Using runtime prefix = /usr
2010-08-28 12:46:03.692 Using configuration directory = /home/mythtv/.mythtv
2010-08-28 12:46:03.694 Empty LocalHostName.
2010-08-28 12:46:03.694 Using localhost value of DIGIT.CREEGER.COM
2010-08-28 12:46:03.703 New DB connection, total: 1
2010-08-28 12:46:03.708 Unable to connect to database!
2010-08-28 12:46:03.708 Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'DIGIT.CREEGER.COM' (using password: YES)

................................................................................
2010-08-28 12:46:06.306 UPnPautoconf() - No UPnP backends found
2010-08-28 12:46:06.306 No UPnP backends found
2010-08-28 12:46:06.308 Primary screen: 0.
2010-08-28 12:46:06.308 Using screen 0, 1024x768 at 0,0
2010-08-28 12:46:06.308 Could not find theme:  - Switching to Terra
2010-08-28 12:46:06.309 Using theme base resolution of 1280x720
2010-08-28 12:46:06.327 Desktop video mode: 1024x768 120.077 Hz
2010-08-28 12:46:06.346 get_ip: Name or service not known
2010-08-28 12:46:06.346 LIRC, Error: Failed to parse IP address ''
2010-08-28 12:46:06.347 JoystickMenuThread Error: Joystick disabled - 
Failed to read /home/mythtv/.mythtv/joystickmenurc
2010-08-28 12:46:06.361 Using Frameless Window
2010-08-28 12:46:06.361 Using Full Screen Window
2010-08-28 12:46:06.379 Using the Qt painter
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
2010-08-28 12:46:12.708 User cancelled database configuration
2010-08-28 12:46:12.723 Deleting UPnP client...
^[2010-08-28 12:46:12.992 Failed to init MythContext, exiting

# cat ~mythtv/.mythtv/mysql.txt
DBHostName=XXX.YYY.COM

# By default, Myth tries to ping the DB host to see if it exists.
# If your DB host or network doesn't accept pings, set this to no:
#
#DBHostPing=no

DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3

# Set the following if you want to use something other than this
# machine's real hostname for identifying settings in the database.
# This is useful if your hostname changes often, as otherwise you
# will need to reconfigure mythtv every time.
# NO TWO HOSTS MAY USE THE SAME VALUE
#
#LocalHostName=my-unique-identifier-goes-here

# If you want your frontend to be able to wake your MySQL server
# using WakeOnLan, have a look at the following settings:
#
#
# The time the frontend waits (in seconds) between reconnect tries.
# This should be the rough time your MySQL server needs for startup
#
#WOLsqlReconnectWaitTime=0
#
#
# This is the number of retries to wake the MySQL server
# until the frontend gives up
#
#WOLsqlConnectRetry=5
#
#
# This is the command executed to wake your MySQL server.
#
#WOLsqlCommand=echo 'WOLsqlServerCommand not set'

# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# user=mythtv
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
key_buffer = 48M
max_allowed_packet = 8M
table_cache = 128
sort_buffer_size = 48M
net_buffer_length = 8M
thread_cache_size = 4
query_cache_type = 1
myisam_sort_buffer_size = 8M
query_cache_size = 16M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid