<html>
<body>
<font size=3>Any ideas?<br><br>
-- Mache<br><br>
At 12:54 PM 8/28/2010, Mache Creeger wrote:<br>
<blockquote type=cite class=cite cite="">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.<br><br>
Below are the logs<br><br>
Any help will be most appreciated.<br><br>
-- Mache<br><br>
# uname -r<br>
2.6.32.19-163.fc12.i686<br><br>
# rpm -qa | grep mythtv-backend<br>
mythtv-backend-0.23.1-236.fc12.i686<br><br>
# mysql -u mythtv -p<br>
Enter password: <mythtv><br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 12<br>
Server version: 5.1.47 Source distribution<br><br>
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights
reserved.<br>
This software comes with ABSOLUTELY NO WARRANTY. This is free
software,<br>
and you are welcome to modify and redistribute it under the GPL v2
license<br><br>
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.<br><br>
mysql><br><br>
<br>
/var/log/mythtv/mythbackend.log<br><br>
2010-08-28 12:39:06.687 mythbackend version:
branches/release-0-23-fixes/mythtv/ [25469]
<a href="http://www.mythtv.org/" eudora="autourl">www.mythtv.org</a><br>
2010-08-28 12:39:06.688 Using runtime prefix = /usr<br>
2010-08-28 12:39:06.691 Read conf dir = /var/lib/mythtv<br>
2010-08-28 12:39:06.691 Using configuration directory =
/var/lib/mythtv<br>
2010-08-28 12:39:06.692 Empty LocalHostName.<br>
2010-08-28 12:39:06.692 Using localhost value of XXX.YYY.COM<br>
2010-08-28 12:39:06.721 New DB connection, total: 1<br>
2010-08-28 12:39:06.726 Unable to connect to database!<br>
2010-08-28 12:39:06.727 Driver error was [1/1045]:<br>
QMYSQL: Unable to connect<br>
Database error was:<br>
Access denied for user 'mythtv'@'XXX.YYY.COM' (using password:
YES)<br><br>
................................................................................<br>
2010-08-28 12:39:09.286 UPnPautoconf() - No UPnP backends found<br>
2010-08-28 12:39:09.287 No UPnP backends found<br><br>
No UPnP backends found<br><br>
Would you like to configure the database connection now? [no]<br>
[console is not interactive, using default 'no']<br>
2010-08-28 12:39:09.288 Deleting UPnP client...<br>
2010-08-28 12:39:09.900 Failed to init MythContext, exiting.<br><br>
/var/log/mysqld.log<br><br>
100828 12:35:24 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql<br>
100828 12:35:24 [Warning] option 'net_buffer_length': unsigned value
8388608 adjusted to 1048576<br>
100828 12:35:24 [Note] Plugin 'ndbcluster' is disabled.<br>
100828 12:35:24 InnoDB: Started; log sequence number 0 59095<br>
100828 12:35:24 [Note] Event Scheduler: Loaded 0 events<br>
100828 12:35:24 [Note] /usr/libexec/mysqld: ready for connections.<br>
Version: '5.1.47' socket: '/var/lib/mysql/mysql.sock' port:
3306 Source distribution<br>
100828 12:35:26 [Note] /usr/libexec/mysqld: Normal shutdown<br><br>
100828 12:35:26 [Note] Event Scheduler: Purging the queue. 0 events<br>
100828 12:35:26 InnoDB: Starting shutdown...<br>
100828 12:35:30 InnoDB: Shutdown completed; log sequence number 0
59095<br>
100828 12:35:30 [Note] /usr/libexec/mysqld: Shutdown complete<br><br>
100828 12:35:30 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended<br>
100828 12:35:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql<br>
100828 12:35:30 [Warning] option 'net_buffer_length': unsigned value
8388608 adjusted to 1048576<br>
100828 12:35:30 [Note] Plugin 'ndbcluster' is disabled.<br>
100828 12:35:30 InnoDB: Started; log sequence number 0 59095<br>
100828 12:35:30 [Note] Event Scheduler: Loaded 0 events<br>
100828 12:35:30 [Note] /usr/libexec/mysqld: ready for connections.<br>
Version: '5.1.47' socket: '/var/lib/mysql/mysql.sock' port:
3306 Source distribution<br><br>
$ mythtv-setup<br>
2010-08-28 12:46:03.692 Using runtime prefix = /usr<br>
2010-08-28 12:46:03.692 Using configuration directory =
/home/mythtv/.mythtv<br>
2010-08-28 12:46:03.694 Empty LocalHostName.<br>
2010-08-28 12:46:03.694 Using localhost value of DIGIT.CREEGER.COM<br>
2010-08-28 12:46:03.703 New DB connection, total: 1<br>
2010-08-28 12:46:03.708 Unable to connect to database!<br>
2010-08-28 12:46:03.708 Driver error was [1/1045]:<br>
QMYSQL: Unable to connect<br>
Database error was:<br>
Access denied for user 'mythtv'@'DIGIT.CREEGER.COM' (using password:
YES)<br><br>
................................................................................<br>
2010-08-28 12:46:06.306 UPnPautoconf() - No UPnP backends found<br>
2010-08-28 12:46:06.306 No UPnP backends found<br>
2010-08-28 12:46:06.308 Primary screen: 0.<br>
2010-08-28 12:46:06.308 Using screen 0, 1024x768 at 0,0<br>
2010-08-28 12:46:06.308 Could not find theme: - Switching to
Terra<br>
2010-08-28 12:46:06.309 Using theme base resolution of 1280x720<br>
2010-08-28 12:46:06.327 Desktop video mode: 1024x768 120.077 Hz<br>
2010-08-28 12:46:06.346 get_ip: Name or service not known<br>
2010-08-28 12:46:06.346 LIRC, Error: Failed to parse IP address ''<br>
2010-08-28 12:46:06.347 JoystickMenuThread Error: Joystick disabled -
Failed to read /home/mythtv/.mythtv/joystickmenurc<br>
2010-08-28 12:46:06.361 Using Frameless Window<br>
2010-08-28 12:46:06.361 Using Full Screen Window<br>
2010-08-28 12:46:06.379 Using the Qt painter<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
2010-08-28 12:46:12.708 User cancelled database configuration<br>
2010-08-28 12:46:12.723 Deleting UPnP client...<br>
^[2010-08-28 12:46:12.992 Failed to init MythContext, exiting<br><br>
# cat ~mythtv/.mythtv/mysql.txt<br>
DBHostName=XXX.YYY.COM<br><br>
# By default, Myth tries to ping the DB host to see if it exists.<br>
# If your DB host or network doesn't accept pings, set this to no:<br>
#<br>
#DBHostPing=no<br><br>
DBUserName=mythtv<br>
DBPassword=mythtv<br>
DBName=mythconverg<br>
DBType=QMYSQL3<br><br>
# Set the following if you want to use something other than this<br>
# machine's real hostname for identifying settings in the database.<br>
# This is useful if your hostname changes often, as otherwise you<br>
# will need to reconfigure mythtv every time.<br>
# NO TWO HOSTS MAY USE THE SAME VALUE<br>
#<br>
#LocalHostName=my-unique-identifier-goes-here<br><br>
# If you want your frontend to be able to wake your MySQL server<br>
# using WakeOnLan, have a look at the following settings:<br>
#<br>
#<br>
# The time the frontend waits (in seconds) between reconnect tries.<br>
# This should be the rough time your MySQL server needs for startup<br>
#<br>
#WOLsqlReconnectWaitTime=0<br>
#<br>
#<br>
# This is the number of retries to wake the MySQL server<br>
# until the frontend gives up<br>
#<br>
#WOLsqlConnectRetry=5<br>
#<br>
#<br>
# This is the command executed to wake your MySQL server.<br>
#<br>
#WOLsqlCommand=echo 'WOLsqlServerCommand not set'<br><br>
# cat /etc/my.cnf<br>
[mysqld]<br>
datadir=/var/lib/mysql<br>
socket=/var/lib/mysql/mysql.sock<br>
user=mysql<br>
# user=mythtv<br>
# Default to using old password format for compatibility with mysql
3.x<br>
# clients (those using the mysqlclient10 compatibility package).<br>
old_passwords=1<br>
key_buffer = 48M<br>
max_allowed_packet = 8M<br>
table_cache = 128<br>
sort_buffer_size = 48M<br>
net_buffer_length = 8M<br>
thread_cache_size = 4<br>
query_cache_type = 1<br>
myisam_sort_buffer_size = 8M<br>
query_cache_size = 16M<br><br>
[mysqld_safe]<br>
log-error=/var/log/mysqld.log<br>
pid-file=/var/run/mysqld/mysqld.pid<br><br>
_______________________________________________<br>
mythtv-users mailing list<br>
mythtv-users@mythtv.org<br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" eudora="autourl">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a></font>
</blockquote></body>
</html>