Kodi Community Forum

Full Version: MySQL (MariaDB) not working after reboot
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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>
(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?
Mecool M8s Pro running Libreelec.
I have been using it for the past 2 years with PlexKodiConnect but wanted to run natively now.
Did you enable the "Wait for network" option in the LibreELEC Settings Add-on?
Kodi itself can start kinda fast.
(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.
@Klojum 

You hit the jackpot!
After setting the option "wait for network" it works a charm.

Many thanks again!
Thread marked solved.