Can't get OSMC to load database from mysql server

Help and Support Raspberry Pi
1

I’ve been using XBMC/Kodi for a while now with two installations pulling the library data from a mysql database. I recently upgraded to a Raspberry Pi 2 and OSMC. I copied over the same old advancedsettings.xml file I’ve always used and rebooted. However, OSMC isn’t loading any of the Movie or TV Show library data. I went in and manually mapped the share and can play the files, it’s just not loading the library.

I looked in the Kodi.log file and it said the following:

21:38:43 T:1957101568  NOTICE: Loaded settings file from special://xbmc/system/advancedsettings.xml
21:38:43 T:1957101568  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
21:38:43 T:1957101568  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.10</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.1.10</host>
                                                <port>3306</port>
                                                <user>xbmc</user>
                                                <pass>xbmc</pass>
                                              </musicdatabase>
                                              <videolibrary>
                                                <importwatchedstate>true</importwatchedstate>
                                                <importresumepoint>true</importresumepoint>
                                              </videolibrary>
                                            </advancedsettings>
21:38:43 T:1957101568 WARNING: VIDEO database configuration is experimental.

Any idea what could be wrong?

2

I had this problem once before and my SQL server wasn’t running. Check to make sure it’s turned on if nothing else has changed. I always add advancedsettings.xml along with sources.xml and mediasources.xml but don’t forget passwords.xml if it applies

1 Like
3

I get the same here from time to time. Restarting kodi usually helps.