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

Sun Aug 29 17:48:57 UTC 2010

Any ideas?

-- Mache

At 12:54 PM 8/28/2010, Mache Creeger wrote:
>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
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100829/c8ae5b0a/attachment-0001.htm>