[mythtv-users] 0.21-0.22 upgrade, can't make mysql/db connection

Bobby Gill bobbygill at rogers.com
Sat Nov 21 23:51:39 UTC 2009


Just did ye ol' upgrade:

> sudo tail -f mythbox.err
091121 18:29:38 [Note] /usr/sbin/mysqld: Shutdown complete

091121 18:29:38 mysqld_safe mysqld from pid file /var/lib/mysql/mythbox.pid
ended
091121 18:30:51 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
091121 18:30:53 [Note] Plugin 'FEDERATED' is disabled.
091121 18:30:53 [Note] Plugin 'ndbcluster' is disabled.
091121 18:30:54  InnoDB: Started; log sequence number 0 193508
091121 18:30:55 [Note] Event Scheduler: Loaded 0 events
091121 18:30:55 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Source
distribution

No errors from mysql after some db checking and upgrading (and was all OKs
from that).

2009-11-21 18:39:52.271 Testing network connectivity to '192.168.1.100'
2009-11-21 18:39:52.278 Closing DB connection named 'DBManager0'
2009-11-21 18:39:52.279 Unable to connect to database!
2009-11-21 18:39:52.279 Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.1.100' (111)

2009-11-21 18:39:52.279 Cannot login to database?


I keep getting this, and mythbackend.log shows nothing helpful, just proper
log entries/no errors or anything. My /etc/mysql/my.cnf is here if of any
use: http://pastebin.ca/1681585

I do have some other web apps using mysql that are functioning properly, so
I'm pretty sure it's not mysql (?).

Thanks for any help,
Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20091121/957ffd76/attachment.htm>


More information about the mythtv-users mailing list