+- 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: Solved MySQL (MariaDB) not working after reboot (/showthread.php?tid=357748)
MySQL (MariaDB) not working after reboot - Panja0 - 2020-10-16
I have setup my Kodi (17.6) device to use MySQL. On the backend I'm running MariaDB 10.
Created a Kodi user and gave full access from anywhere.
Creating my first video source on Kodi is working and I see the database gets created on the backend side.
Everything is fine untill I reboot the Kodi device. The video source cannot read anything any more.
What could be the issue?
advancedsettings.xml
xml:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>ip_of_mariadb</host>
<port>3307</port>
<user>kodi</user>
<pass>Test12345!</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>ip_of_mariadb</host>
<port>3307</port>
<user>kodi</user>
<pass>Test12345!</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
<cleanonupdate>false</cleanonupdate>
</videolibrary>
<musiclibrary>
<backgroundupdate>true</backgroundupdate>
</musiclibrary>
<video>
<ignorepercentatend>10</ignorepercentatend>
<playcountminimumpercent>90</playcountminimumpercent>
<ignoresecondsatstart>60</ignoresecondsatstart>
</video>
</advancedsettings>
RE: MySQL (MariaDB) not working after reboot - Klojum - 2020-10-16
(2020-10-16, 16:45)Panja0 Wrote: I have setup my Kodi (17.6) device to use MySQL
What kind of device is that, and which OS is it running?
RE: MySQL (MariaDB) not working after reboot - Panja0 - 2020-10-16
Mecool M8s Pro running Libreelec.
I have been using it for the past 2 years with PlexKodiConnect but wanted to run natively now.
RE: MySQL (MariaDB) not working after reboot - Klojum - 2020-10-16
Did you enable the "Wait for network" option in the LibreELEC Settings Add-on?
Kodi itself can start kinda fast.
RE: MySQL (MariaDB) not working after reboot - Panja0 - 2020-10-16
(2020-10-16, 17:10)Klojum Wrote: Did you enable the "Wait for network" option in the LibreELEC Settings Add-on?
Kodi itself can start kinda fast.
Nope I did not...
Gonna give it a try this weekend! Many thanks for pointing out.
RE: MySQL (MariaDB) not working after reboot - Panja0 - 2020-10-19
@Klojum
You hit the jackpot!
After setting the option "wait for network" it works a charm.
Many thanks again!
MySQL (MariaDB) not working after reboot - Klojum - 2020-10-19
Thread marked solved.