No More MySQL Connection?
#1
Noticed that my MySQL database was gone after updating to the nightly build d6058ae-master for Windows. No problem, I expected this. Removed advancedsettings and restarted, then re-added my shares, exported the library.

I then decided to be safe and go back and totally erase and start from scratch with my MySQL database. I erased the video and music tables and re-created them from scratch.

Added advancedsettings.xml back in, restarted XBMC waiting for the import, and the program totally froze. Seems that this build is having trouble connecting to MySQL. Debug log is here:

http://pastebin.com/zTbSyHeG

Did I need to do something different or is this build just MySQL-averse?

My windows machine is my host and determines the version of XBMC I use in all other rooms of the house (with the DB changes they all have to be synced up) so it all starts here.

Thanks.
Reply
#2
Code:
13:40:52 T:2400 M:3042873344   ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on 'localhost' (10061))
13:40:52 T:2400 M:3042873344   ERROR: Unable to open database xbmc_video
13:40:53 T:2400 M:3041091584   ERROR: Unable to open database: xbmc_music [2003](Can't connect to MySQL server on 'localhost' (10061))
13:40:53 T:2400 M:3041091584   ERROR: Unable to open database xbmc_music

Silly question, but is the MySQL instance on the same computer as this XBMC installation? It seems like either you have the wrong host in the advancedsettings.xml file, or the MySQL daemon isn't running on that computer.
Living Room: ASUS Chromebox / OpeneElec 5 / Kodi 14.2
Bedroom: Amazon FireTV Stick / Kodi 14.2
Home Office: Amazon FireTV Stick / Kodi 14.2
Windows Server: Intel Core i3-2100T / 8GB Ram / 48TB / MySQL / StableBit DrivePool on Server 2012 R2 Standard
Reply
#3
Found the solution. Don't use localhost, use the actual IP in advancedsettings.xml.

Used to not have to do this in 10.1, when the nightlies started, it looks like it now requires an actual IP in there and no more localhost or hostnames.
Reply

Logout Mark Read Team Forum Stats Members Help
No More MySQL Connection?0