SOLVED Central management of video/music
#1
Hey Forum
I would like to get all my Videos ands music managed one central place ( MySQL) in my setup.
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 ?
Code:
<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

EDIT - Just clean the libary and try once again - that worked
Reply

Logout Mark Read Team Forum Stats Members Help
SOLVED Central management of video/music0