I have five raspberry pies running OSMC kodi 17.6. I also have a couple of Android devices (phone/ tablet) and a MAC OS X running kodi 18.1. They are all running Kodi with a shared MySQL database.
Somehow, one or more of the nodes has created a new separate video and music databases even though the DB was started from scratch and identical XML configs copied to all participating nodes and all nodes rebooted as per kodi mysql docs. The MySQL instance runs on a Western Digital ext2 NAS device on the same home network. Here is the advancedsettings.xml that all nodes use:
<?xml version=“1.0” encoding=“utf-8”?> <advancedsettings> <videodatabase> <host>192.168.0.151</host> <user>kodi</user> <pass>kodi</pass> <type>mysql</type> <port>3306</port> </videodatabase> <musicdatabase> <host>192.168.0.151</host> <user>kodi</user> <pass>kodi</pass> <type>mysql</type> <port>3306</port> </musicdatabase> <videolibrary> <importwatchedstate>true</importwatchedstate> <importresumepoint>true</importresumepoint> </videolibrary> </advancedsettings>
Can you provide any guidance on why new DBs are being created? Different schemas between kodi 17 and 18? Any help would be much appreciated. I love what OSMC/kodi has done and I’m close to getting my wife to join the cable cutting revolution.
Thank you kindly,