[mythtvnz] Problems connecting to database

james at booths.net.nz james at booths.net.nz
Sat Jul 11 01:48:47 BST 2009 

I run a combined frontend/backend and a remote frontend as well. I  
have upgraded to JYA's latest release for MythTV, and now my frontends  
cannot connect to the MySQL database. All connection settings seem  
correct, mysqld is running, backend is running, etc - I can't see  
anything obviously wrong, but it jut will not connect. Can anyone make  
some suggestions on what else I could check? Below is the output when  
running mythfrontend -v all

2009-07-11 12:46:38.389 Using runtime prefix = /usr
2009-07-11 12:46:38.390 UPnp - Constructor
2009-07-11 12:46:38.390 MediaRenderer::Begin
2009-07-11 12:46:38.390 Configuration::Load - Error parsing:  
/home/james/.mythtv/config.xml at line: 1  column: 1
2009-07-11 12:46:38.390 Configuration::Load - Error Msg: unexpected  
end of file
2009-07-11 12:46:38.390 ThreadPool:AddWorkerThread - HTTP_WorkerThread
2009-07-11 12:46:38.391 HttpServer( 6547 ) - SharePath = /usr/share/mythtv/
2009-07-11 12:46:38.391 UPnp::Initialize - Begin
2009-07-11 12:46:38.391 UPnp::Initialize - Starting TaskQueue
2009-07-11 12:46:38.391 UPnp::Initialize - Creating SSDP Thread at port 6547
2009-07-11 12:46:38.391 UPnp::Initialize - End
2009-07-11 12:46:38.391 MediaRenderer::Creating UPnp Description
2009-07-11 12:46:38.391 MediaRenderer::Registering CMGR Service.
2009-07-11 12:46:38.391 UPnp::Start - Starting SSDP Thread (Multicast)
2009-07-11 12:46:38.391 UPnp::Start - Enabling Notifications
2009-07-11 12:46:38.392 SSDP::EnableNotifications() - creating new task
2009-07-11 12:46:38.392 SSDP::EnableNotifications() - sending NTS_byebye
2009-07-11 12:46:38.392  
LookupUDN(urn:schemas-upnp-org:device:MediaRenderer:1)  
sName=UPnP/UDN/MediaRenderer, sUDN=
2009-07-11 12:46:38.392 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:38.393 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:byebye
NT     =upnp:rootdevice
USN    =uuid:48a0a86b-f00d-410e-b452-a098e73ab349::upnp:rootdevice
Cache  =max-age=3600
2009-07-11 12:46:38.437 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:38.438 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:byebye
NT     =upnp:rootdevice
USN    =uuid:48a0a86b-f00d-410e-b452-a098e73ab349::upnp:rootdevice
Cache  =max-age=3600
2009-07-11 12:46:38.438 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:38.438 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:byebye
NT     =uuid:48a0a86b-f00d-410e-b452-a098e73ab349
USN    =uuid:48a0a86b-f00d-410e-b452-a098e73ab349
Cache  =max-age=3600
2009-07-11 12:46:38.477 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:38.477 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:byebye
NT     =uuid:48a0a86b-f00d-410e-b452-a098e73ab349
USN    =uuid:48a0a86b-f00d-410e-b452-a098e73ab349
Cache  =max-age=3600
2009-07-11 12:46:38.477 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:38.478 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:byebye
NT     =urn:schemas-upnp-org:device:MediaRenderer:1
USN     
=uuid:48a0a86b-f00d-410e-b452-a098e73ab349::urn:schemas-upnp-org:device:MediaRenderer:1
Cache  =max-age=3600
2009-07-11 12:46:38.606 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:38.606 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:byebye
NT     =urn:schemas-upnp-org:device:MediaRenderer:1
USN     
=uuid:48a0a86b-f00d-410e-b452-a098e73ab349::urn:schemas-upnp-org:device:MediaRenderer:1
Cache  =max-age=3600
2009-07-11 12:46:38.606 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:38.607 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:byebye
NT     =urn:schemas-upnp-org:service:ConnectionManager:1
USN     
=uuid:48a0a86b-f00d-410e-b452-a098e73ab349::urn:schemas-upnp-org:service:ConnectionManager:1
Cache  =max-age=3600
2009-07-11 12:46:38.749 SSDP::EnableNotifications() - sending NTS_alive
2009-07-11 12:46:38.749 SSDP::EnableNotifications() - Task added to UPnP queue
2009-07-11 12:46:38.749 UPnp::Start - Returning
2009-07-11 12:46:38.749 MediaRenderer::End
2009-07-11 12:46:38.750 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:38.751 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:byebye
NT     =urn:schemas-upnp-org:service:ConnectionManager:1
USN     
=uuid:48a0a86b-f00d-410e-b452-a098e73ab349::urn:schemas-upnp-org:service:ConnectionManager:1
Cache  =max-age=3600
2009-07-11 12:46:38.767 XScreenSaver support enabled
2009-07-11 12:46:38.767 DPMS is active.
2009-07-11 12:46:38.768 Empty LocalHostName.
2009-07-11 12:46:38.768 Using localhost value of mythtv
2009-07-11 12:46:38.768 Configuration::Load - Error parsing:  
/home/james/.mythtv/config.xml at line: 1  column: 1
2009-07-11 12:46:38.768 Configuration::Load - Error Msg: unexpected  
end of file
2009-07-11 12:46:38.768 MCP::DefaultUPnP() - No default UPnP backend
2009-07-11 12:46:38.781 New DB connection, total: 1
2009-07-11 12:46:38.782 Unable to connect to database!
2009-07-11 12:46:38.782 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.1.249' (111)

QSqlQuery::exec: database not open
2009-07-11 12:46:38.792 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:38.792 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:alive
NT     =upnp:rootdevice
USN    =uuid:48a0a86b-f00d-410e-b452-a098e73ab349::upnp:rootdevice
Cache  =max-age=3600
QSqlQuery::exec: database not open
2009-07-11 12:46:38.833 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2009-07-11 12:46:38.884 SSDP::ProcessData - requestLine: M-SEARCH * HTTP/1.1
2009-07-11 12:46:38.884 SSDP::ProcessSearchrequest :  
[urn:schemas-mythtv-org:device:MasterMediaServer:1] MX=0
2009-07-11 12:46:38.957 SSDP::ProcessData - requestLine: M-SEARCH * HTTP/1.1
2009-07-11 12:46:38.957 SSDP::ProcessSearchrequest :  
[urn:schemas-mythtv-org:device:MasterMediaServer:1] MX=0
...2009-07-11 12:46:39.012 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:39.013 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:alive
NT     =upnp:rootdevice
USN    =uuid:48a0a86b-f00d-410e-b452-a098e73ab349::upnp:rootdevice
Cache  =max-age=3600
2009-07-11 12:46:39.013 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:39.013 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:alive
NT     =uuid:48a0a86b-f00d-410e-b452-a098e73ab349
USN    =uuid:48a0a86b-f00d-410e-b452-a098e73ab349
Cache  =max-age=3600
..2009-07-11 12:46:39.075 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:39.075 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:alive
NT     =uuid:48a0a86b-f00d-410e-b452-a098e73ab349
USN    =uuid:48a0a86b-f00d-410e-b452-a098e73ab349
Cache  =max-age=3600
2009-07-11 12:46:39.075 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:39.075 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:alive
NT     =urn:schemas-upnp-org:device:MediaRenderer:1
USN     
=uuid:48a0a86b-f00d-410e-b452-a098e73ab349::urn:schemas-upnp-org:device:MediaRenderer:1
Cache  =max-age=3600
.......2009-07-11 12:46:39.243 SSDP::ProcessData - requestLine: NOTIFY  
* HTTP/1.1
2009-07-11 12:46:39.243 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:alive
NT     =urn:schemas-upnp-org:device:MediaRenderer:1
USN     
=uuid:48a0a86b-f00d-410e-b452-a098e73ab349::urn:schemas-upnp-org:device:MediaRenderer:1
Cache  =max-age=3600
2009-07-11 12:46:39.243 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:39.244 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:alive
NT     =urn:schemas-upnp-org:service:ConnectionManager:1
USN     
=uuid:48a0a86b-f00d-410e-b452-a098e73ab349::urn:schemas-upnp-org:service:ConnectionManager:1
Cache  =max-age=3600
....2009-07-11 12:46:39.355 SSDP::ProcessData - requestLine: NOTIFY * HTTP/1.1
2009-07-11 12:46:39.355 SSDP::ProcessNotify
DescURL=http://192.168.1.249:6547/getDeviceDesc
NTS    =ssdp:alive
NT     =urn:schemas-upnp-org:service:ConnectionManager:1
USN     
=uuid:48a0a86b-f00d-410e-b452-a098e73ab349::urn:schemas-upnp-org:service:ConnectionManager:1
Cache  =max-age=3600

More information about the mythtvnz mailing list