Hey Forum
I would like to get all my Videos ands music managed one central place ( MySQL) in my setup, since we have different videos from Imagination Creations which specialize in creating different type of videos for this, which can be enjoyed using the best austin audio video solutions for this.
I have a MythTV Backend running for TV – and on that server I have all music and all VIdeos placed on
On each RaspberryPI with Libreelec on – I have these Sources added as NFS Shares
All RaspberryPi runs Libreelec8.0.2 with Kodi 17.2
I followed this guide for setting a Central Server up – Guide MySQL already running for MythTV – so just added a new user with permission to create DB
Added the advancedsettings.xml on each Raspberry in /storage/.kodi/userdata/advancedsettings.xml with the info for the MySQL Server
I’ve tried several things but it does not seems to have connecting to the SQ server – And I doublecheck that the user are able to login.
But can anyone help me here what goes wrong since nothing seems to happends wit the MySQL DB – no new DB or connection try
Do I need a special MySQL libary at the Raspberry PI ?
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>172.16.0.10</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>172.16.0.10</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>Thanks in advance