[KeithLM]

I've been using a common database for quite some time, and using it from multiple instances without trouble. Tonight I'm setting up a new system with XBMCbuntu and XBMC 13 beta 1 and it wouldn't connect with the following errors.

Code:

23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video78 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video77 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video76 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video75 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video74 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video73 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video72 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video71 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video70 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video69 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video68 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video67 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video66 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video65 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video64 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video63 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video62 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video61 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video60 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to open database: xbmc_video78 [2003](Can't connect to MySQL server on '192.168.0.202' (101))
23:24:06 T:3038108096   ERROR: Unable to create new database

I couldn't figure out what was wrong for quite some time, and I still don't really know why this happened, but I did get it fixed. I decided to configure my PVR client, cmyth, and see if that would connect. I figured they're both using mysql, maybe that would tell me something. What I found was TVHeadEnd was setup and enabled for some odd reason. I saw some errors pertaining to TVHeadEnd in the logs so I tried to uninstall it at first. This caused XBMC to crash, and on restart it connected to the database. TVHeadEnd was still running, so I disabled it, then I was able to enable cmyth and then the PVR stuff showed up as expected.

I started with a brand new system tonight, performed a standard install of XBMCbuntu 12.2 on it, then followed the instructions to change repos and installed the beta before I did any configuration on the system. Then I copied my sources.xml and advancedsettings.xml from a similar XBMCbuntu install. I didn't touch any settings, including PVR settings, initially as I tried to work out what the problem was. There were no log messages on the server side indicating it was rejecting any connections or even seeing anything at all from the new system.

Seems to me that there's some issue with either XBMCbuntu or beta 1 that is enabling TVHeadEnd by default, and if that isn't configured it's colliding with the remote database access.

[nickr]

Let me guess, your mysql settings in advancedsettings.xml wrongly include the <name> tag?

[KeithLM]

Let me guess, your mysql settings in advancedsettings.xml wrongly include the <name> tag?

Well at the time I set it up that wasn't wrong. How was I to know that was wrong until I found a problem? Was that in the 13 release notes? Or was it 12? And as long as every system has the name tag, isn't that just fine? But regardless, that doesn't seem related to this bug. After all, with the TVHeadEnd plug-in disabled it still works.