Hi All.
I have run Kodi on a Rasperry Pi 1 for the past 8 years and this week have decided to replace it with a new 2GB Pi4.
My media is stored on a Synology NAS (a DS210j originally and then, following a recent upgrade, a DS218+) and is accessed using NFS.
Because the Kodi implementation I have used previously (OSMC) does not yet support Pi4 I have decided to move to LibreELEC, downloading the Pi4 image of 9.2.0. At the same time I thought I would also consider creating a central library using MySQL so that I can add more LibreELEC installations in future and run all from the same library.
I do not consider myself to be an expert, but I am able to follow instructions without too much difficulty. I installed MySQL server onto another old Pi1 (also used for couple of other basic jobs) and have been able to test a remote connection from a Windows machine (the same machine I am using to type this) using an application called HeidiSQL to confirm that I could connect to the MySQL installation and that the username/password I had created for Kodi to use also worked.
I then found on the Kodi Wiki how to create the file advancedsettings.xml and that this file should be placed in the .kodi/userdata folder. I also copied the sources.xml file from my old Kodi installation so that I did not need to create the media sources from scratch.
In the LibreELEC settings (Network --> Advanced Network Settings) I have enabled "Wait for network before starting Kodi" and set the Maximum Wait Time value to 30 seconds (probably longer than needed even though I am using WiFi).
My advancedsettings.xml file looks like this:-
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>10.x.x.6</host>
<port>3306</port>
<user>kodi</user>
<pass>password</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>10.x.x.6</host>
<port>3306</port>
<user>kodi</user>
<pass>password</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importvatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
Display More
I restarted so that it could re-read the copied sources.xml file. With this all in place, I then went to Settings --> Media --> Videos... right-clicked on Movies source to configure the scraper settings. Once done, Kodi then prompts me to refresh the information. I select Yes and the system then proceeed to build the library.
I then did the same for my TV media source and left the system to build that library.
From a Kodi perspective the content is all present. I can select any entry from the library and it begins to play (I haven't tested a full programme/movie as my old Pi is still in place but from a basic playback perspective the new installation seems to be working).
However, when I log into MySQL database and run "show databases;" there is no sign of the new database I would expect to find (just the 3 default databases).
I can only assume therefore that the library has been created locally, but I am unsure why it has not connected to the MySQL server and created the library database there. I have looked at .kodi/temp/kodi.log and can find no references to 'mysql' or the IP address of the other Pi running MySQL to indicate an error.
Can anyone advise if any of the steps I have carried our were not correct or let me know if there are any additional logs I can check (and where to find them) to see if I can find out if this LibreELEC/Kodi installation is even trying to connect to MySQL.
Many thanks in advance.
-Phil.