I use a synology nas with phpMyAdmin and MariaDB to create a database for my music and videos.
LibreELEC (8.0.2) is installed on a raspberry pi 3. The “wait for network delay” is set to 10 seconds.
After updating to MariaDB 10 the sync didn’t work any longer.
The only thing i’ve additionally changed was the port to 3307.
Here is my advancedsettings.xml:
Code
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>IP from nas</host>
<port>3307</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>IP from nas</host>
<port>3307</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
Display More
I've tried this advancedsettings.xml on an windows pc with Kodi and it works without problems.