[pflanze]

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

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'@'%';

[Milhouse]

To save everyone a lot of time, upload your debug log (wiki) - no debug log, no problem.

Read the contents of the orange box which explains why path substitution is a bad idea, and most likely one of the reasons why you're having a problem. Just don't do with path substitution what you're doing with path substitution.

You haven't even got the closing <pathsubstitution> xml tag correct, so it won't be working anyway, and may explain why your as.xml is not working (a debug log (wiki) would confirm this).

Also <useddsfanart> isn't supported on the RPi, and the database <name> tag is also discouraged.

It seems you've been following some very outdated, and incorrect, guides.

[pflanze]

To save everyone a lot of time, upload your debug log (wiki) - no debug log, no problem.

here is the log file
http://pastebin.com/5yRnzka2

this is my new xml

Code:

<advancedsettings>
    <samba>
        <clienttimeout>30</clienttimeout>
    </samba>
    <network>
        <disableipv6>true</disableipv6>
    </network>
<videodatabase>
    <type>mysql</type>
    <host>192.168.178.100</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </videodatabase>
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.178.100/host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
</advancedsettings>

[Milhouse]

Code:

03:32:45 T:1969405952   ERROR: Error loading special://profile/advancedsettings.xml, Line 21
                                            Error reading end tag.

because in <musicdatabase> you have...

Code:

<host>192.168.178.100/host>

Fix the closing tag (missing "<").

[pflanze]

because in <musicdatabase> you have...

Code:

<host>192.168.178.100/host>

Fix the closing tag (missing "<").

stupid mistake made by me copy-pasting several codes together
Thank you for fast help.
It is working.