Arch Linux

colbert

Member

Registered: 2007-12-16

Posts: 809

[SOLVED] MySQL working w/all but myth (can't connect to DB)

Just did ye ol' upgrade and

> sudo tail -f /var/lib/mysql/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). Mythfrontend output:

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

Last edited by colbert (2009-11-22 03:21:49)

colbert

Member

Registered: 2007-12-16

Posts: 809

Re: [SOLVED] MySQL working w/all but myth (can't connect to DB)

Got it! Just edit your /etc/mysql/my.cnf and find the line

skip-networking

Comment the line out and it connects just fine from a remote FE