Help with Mysql and Kodi setup

[rgc121]

Well I have tried again with a new install of Kodi on a raspberry pi. The advancedsettings .xml file has "kodi" username and "kodi" password. I import the movie files from the Qnap into the library ,then export them singularly as instructed on kodi website but there appears to be no connection between the pi and mysql.. In phpmyadmin I have user "kodi" and password"kodi"but it just doesnt work. I am completely lost now I'm afraid. phpmyadmin logs me in as root automatically and user Kodi is there but I don't know how to change it . There appears no method to remove it or change it

[Trexx]

I would recommend posting a picture from phpMyAdmin showing your accounts. Typically if you can access KODI Db from 1 external device (rasberry pi, etc. ) you should be able to access from any of them.

[rgc121]

Thanks for all the help.Finally got it working but not sure how. Suddenly the database appeared and have been able to populate it.
All help much appreciated .

[ensignvorik]

Glad you got it working. Bit perplexed as to why you're doing importing and exporting! But if it's working you might want to just leave it as is for now. If it breaks, this is how I do it. It might be some of these (like the passwords file) might not be needed anymore. I've had this setup for about 5 years and just always copied and pasted it across whenever I do a new Kodi build.

Not sure what version you've got on your Pi, I'm using Librelec, and I have the following files in my userdata folder and Kodi just immediately fills the DB (or populates itself from the DB). You might just have to edit your media sources in Kodi to tell it that movies/tv shows are in the folders in question.

Obviously make changes to point to the correct IP address.ports/user accounts on your QNAP

advancedsettings.xml

Code: Select all

<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>192.168.0.3</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </videodatabase> 
    <musicdatabase>
        <type>mysql</type>
        <host>192.168.0.3</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </musicdatabase>
	<pathsubstitution>
     <substitute>
      <from>special://masterprofile/Thumbnails/</from>
      <to>smb://192.168.0.3/Multimedia/Thumbnails/</to>
     </substitute>
    </pathsubstitution>
</advancedsettings>

sources.xml (note I'm using smb here for simplicity, you can use AFP or NFS also)

Code: Select all

<sources>
    <programs>
        <default pathversion="1"></default>
    </programs>
    <video>
        <default pathversion="1"></default>
        <source>
            <name>Videos</name>
            <path pathversion="1">/storage/videos/</path>
        </source>
        <source>
            <name>TV Shows</name>
            <path pathversion="1">smb://192.168.0.3/Multimedia/tv series/</path>
        </source>
        <source>
            <name>Movies</name>
            <path pathversion="1">smb://192.168.0.3/Multimedia/movies/</path>
        </source>
    </video>
    <music>
        <default pathversion="1"></default>
        <source>
            <name>Music</name>
            <path pathversion="1">smb://192.168.0.3/Multimedia/Music/</path>
        </source>
    </music>
    <pictures>
        <default pathversion="1"></default>
        <source>
            <name>Pictures</name>
            <path pathversion="1">/storage/pictures/</path>
        </source>
    </pictures>
    <files>
        <default pathversion="1"></default>
        <source>
            <name>ensignvorik</name>
            <path pathversion="1">smb://192.168.0.3/ensignvorik/</path>
        </source>
        <source>
            <name>downloads</name>
            <path pathversion="1">/storage/downloads/</path>
        </source>
        <source>
            <name>backup</name>
            <path pathversion="1">/storage/backup/</path>
        </source>
    </files>
</sources>

passwords.xml (change username:password to a user/password that resides on your QNAP and that can access all of the shares listed above)

Code: Select all

<passwords>
    <path>
        <from pathversion="1">smb://192.168.0.3/</from>
        <to pathversion="1">smb://username:password@192.168.0.3/</to>
    </path>
</passwords>

[AlchimistaKumo]

good day, i have a problem with qnap kodi 17.1 and mysql.
i hope to be in the right place .
i ve installed mysql and phpmyadmin and i ve created a db.
i ve change advantsettings on my smartphone kodi and i've seen that was created myvideo107 and mymusic60. and works.
after i ve do the advantsettings change in the qnap kodi, kodi start but dont refresh the libraries and dont set the contents type. i set it on the source but dont apply the change.
Someone has an idea of ​​what happened?
Thankyou to all

[ensignvorik]

good day, i have a problem with qnap kodi 17.1 and mysql.
i hope to be in the right place .
i ve installed mysql and phpmyadmin and i ve created a db.
i ve change advantsettings on my smartphone kodi and i've seen that was created myvideo107 and mymusic60. and works.
after i ve do the advantsettings change in the qnap kodi, kodi start but dont refresh the libraries and dont set the contents type. i set it on the source but dont apply the change.
Someone has an idea of ​​what happened?
Thankyou to all

What's the kodi.log file say, this will give you the biggest clue as to what's going wrong.

[AlchimistaKumo]

thankyou ensignvorik, i've find the log. there are some errors with th db.

20:27:46.437 T:140203063899904 ERROR: Unable to open database: MyMusic60 [1045](Access denied for user 'kodi'@'CasaNas' (using password: YES))
20:27:46.462 T:140203063899904 ERROR: Unable to open database: MyVideos107 [1045](Access denied for user 'kodi'@'CasaNas' (using password: YES))

there are 20/30 attemps to open databases with differents numbers MyMusicxx MyVideosxx

[AlchimistaKumo]

i solved.
in phpmyadmin i ve add the user kodi and the host CasaNas