2015-05-31, 18:30
Hello forum,
I tried now for 8 hours straight to get KODI (openelec @ RPI) to use a central DB. I have to give up.
There must be an error in my config, I just don't know where to look for it.
Please give me a hint or help where to look or what is wrong. The /storage/.kodi/temp/kodi.log tells me nothing with SQL or Thumbnails.
I think my source.xml is working.
Even if I delete the source in KODI, push the source.xml (via SFTP/SSH) on the RPI and do a reboot, the littel thing knows where to look for movies and tv shows.
Also working seems to be the passwords.xml
I'm not asked to give any kind of password or user, the RPI just runs the scrapper and fills in the informations.
But this stuff is not working:
- creat a central mysql DB so both RPIs can use them
- use a server for all the thumbnails
I can map the shared folder smb://192.168.178.100/xbmc_thumbs using the credentials xbmc:xbmc (user:password).
There is no DB created on my MySQL server - according to phpMyAdmin.
The RPI creates a local DB at /storage/.kodi/userdata/Database/MyVideos90.db
edit: Do I have to delete the local DB in order to force it to use a MySQL DB?
This is my advancedsettings.xml
This is my MySQL user creation code
I tried now for 8 hours straight to get KODI (openelec @ RPI) to use a central DB. I have to give up.
There must be an error in my config, I just don't know where to look for it.
Please give me a hint or help where to look or what is wrong. The /storage/.kodi/temp/kodi.log tells me nothing with SQL or Thumbnails.
I think my source.xml is working.
Even if I delete the source in KODI, push the source.xml (via SFTP/SSH) on the RPI and do a reboot, the littel thing knows where to look for movies and tv shows.
Also working seems to be the passwords.xml
I'm not asked to give any kind of password or user, the RPI just runs the scrapper and fills in the informations.
But this stuff is not working:
- creat a central mysql DB so both RPIs can use them
- use a server for all the thumbnails
I can map the shared folder smb://192.168.178.100/xbmc_thumbs using the credentials xbmc:xbmc (user:password).
There is no DB created on my MySQL server - according to phpMyAdmin.
The RPI creates a local DB at /storage/.kodi/userdata/Database/MyVideos90.db
edit: Do I have to delete the local DB in order to force it to use a MySQL DB?
This is my advancedsettings.xml
Code:
<advancedsettings>
<useddsfanart>true</useddsfanart>
<samba>
<clienttimeout>30</clienttimeout>
</samba>
<network>
<disableipv6>true</disableipv6>
</network>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails</from>
<to>smb://xbmc:[email protected]/xbmc_thumbs</to>
</substitute>
</pathsubstitute>
<videodatabase>
<type>mysql</type>
<host>192.168.178.100</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.178.100/host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
This is my MySQL user creation code
Code:
CREATE USER 'xbmc'@'%' IDENTIFIED BY '***';
GRANT ALL PRIVILEGES ON * . * TO 'xbmc'@'%' IDENTIFIED BY '***' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
GRANT ALL PRIVILEGES ON `xbmc\_%` . * TO 'xbmc'@'%';