LinHES Forums http://forums.linhes.org/ |
|
Can't connect to MySQL server on... After R5B7 upg [SOLVED] http://forums.linhes.org/viewtopic.php?f=1&t=9073 |
Page 1 of 1 |
Author: | ethernut [ Sat Mar 18, 2006 11:24 pm ] |
Post subject: | Can't connect to MySQL server on... After R5B7 upg [SOLVED] |
Aww buggers. I did the upgrade to R5B7 and everything went fairly smooth. I accidentally chose the wrong IP and subnet during the setup, but mythfrontend came up ok anyway. I went into /etc/network/interfaces and made the change to the correct the IP info, I then changed /etc/mythtv/mysql.txt so that DBHostName=192.168.2.11 (my internal IP), and I ran mythtv-setup and told it that 192.168.2.11 was my database location. Now (after reboot) the database isnt coming up. Running mythfilldatabase nets this error: root@mythtv:/etc/mythtv# mythfilldatabase 2006-03-19 00:15:19.620 Using runtime prefix = /usr 2006-03-19 00:15:19.653 New DB connection, total: 1 2006-03-19 00:15:19.656 Unable to connect to database! 2006-03-19 00:15:19.656 Driver error was [1/2003]: QMYSQL3: Unable to connect Database error was: Can't connect to MySQL server on '192.168.2.11' (111) QSqlQuery::exec: database not open QSqlQuery::exec: database not open 2006-03-19 00:15:19.711 DB Error (KickDatabase): Query was: SELECT NULL; No error type from QSqlError? Strange... 2006-03-19 00:15:19.764 Failed to init MythContext, exiting. tail /var/log/mythtv/mythbackend.log gives: 2006-03-19 00:00:37.318 Using runtime prefix = /usr 2006-03-19 00:00:37.525 New DB connection, total: 1 2006-03-19 00:00:37.550 Unable to connect to database! 2006-03-19 00:00:37.553 Driver error was [1/2003]: QMYSQL3: Unable to connect Database error was: Can't connect to MySQL server on '192.168.2.11' (111) QSqlQuery::exec: database not open QSqlQuery::exec: database not open 2006-03-19 00:00:37.648 DB Error (KickDatabase): Query was: SELECT NULL; No error type from QSqlError? Strange... 2006-03-19 00:00:37.702 Failed to init MythContext, exiting. Netstat -an gives: Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN tcp6 0 0 :::22 :::* LISTEN udp 0 0 0.0.0.0:111 0.0.0.0:* udp 0 0 192.168.2.11:123 0.0.0.0:* udp 0 0 127.0.0.1:123 0.0.0.0:* udp 0 0 0.0.0.0:123 0.0.0.0:* Mysql is running as I can issue a "mysql" then issue "use mythconverge". But thats about it. Help! EtherNut |
Author: | ethernut [ Sun Mar 19, 2006 1:52 am ] |
Post subject: | |
Ok, I feel like a moron. Problem Solved.. I had to comment out the "skip-networking" line in /etc/mysql/my.cnf Duh |
Page 1 of 1 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |