Kodi Community Forum
MySQL Connection Failure - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: MySQL Connection Failure (/showthread.php?tid=202812)



MySQL Connection Failure - smitopher - 2014-08-24

I'm running Amahi Home Server 7.1 (Linux Fedora 19) which also installs Mariadb (MySQL "drop in replacement").

Following the wiki, I have setup 2 OpenElec 4.1.4 boxes to use Mariadb on my server.

My issue is that most times, when booting the OpenElec boxes, they fail to connect to the database on the server. Several OpenElec reboots will eventually succeed and the shared database works as expected.

The XBMC log shows messages with MySQL connection failures when OpenElec boots and does not connect to MySQL (Mariadb as it were).

Any suggestions as to why the failures to connect to MySQL on boot?
The server is also hosting the Media Library and using the files path, my media files are visible and available.


RE: MySQL Connection Failure - nickr - 2014-08-24

Yes, most likely XBMC is starting before your network interface is ready.

Enable OpenELEC's option to wait for the network before starting.

Specifically in OpenELEC settings, Network Tab. I have mine max out at 10 s but it never takes that long.


RE: MySQL Connection Failure - smitopher - 2014-08-25

That appears to be the ticket.

I had to set the max wait time to 25 seconds as my friends units were taking 8-15 seconds to finish waiting on the Network to start. My friend is connecting to his server with a wireless connection (and aggressively rejecting my suggestion to use wired Ethernet).


RE: MySQL Connection Failure - nickr - 2014-08-25

Yeah wireless takes even longer. Sneak a cable in there and see if he notices the difference!