Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[PC_Arcade]

I'm attempting to use MySQL as the database for Kodi on my 320L - I've successfully ( I believe) installed MySQL using FFP but neither MyPHPAdmin nor xbmc seem to be able to see it.

I've set up kodi as a user on the database, but I don't think it's allowing access from anywhere other that 127.0.0.1 and myPHPadmin doesn't work at all, but it's not asked me WHERE the database is so I'm not sure where it's attepting to connect to.

I'm a total noob when it comes to setting this up (and to Linux generally) so any help would be appreciated!

Thank in adavance!

[masterxilef]

Are you using ffp for anything more than mysql?, because if not, I would recommend uninstalling ffp, and just using the phpmyadmin addon which enables mysql and it's easier to setup for Kodi.

[PC_Arcade]

Thanks for your help so far, I'm, connected and  should be good to go now

[philphil61]

After reading this thread (and several previous threads on similar topic of Kodi and mysql) I decided to have another go

pfffft

I got phpMyAdmin installdd and actually running....yippeeee
I got Kodi With advancedsettings.xml to create a database.....yippeee

And then... wtf am I doing wrong?

I have Kodi (main) on pc
I have Kodi an a tablet and android smart tv box

I was hoping that if I watched something on one of the devices they'd be removed in all the devices once powered up and Kodi is started and scanned for updates.

Basically the database (mysql) is pointless - below is my advancedsettings.xml

<advancedsettings>
     <videolibrary>
       <importwatchedstate>true</importwatchedstate>
     </videolibrary>
     <videodatabase>
       <type>mysql</type>
       <host>192.xxx.x.x</host>
       <port>3306</port>
       <user>xbmc</user>
       <pass>xbmc</pass>
       <name>xbmc_video</name>
    </videodatabase>
    <musicdatabase>
       <type>mysql</type>
       <host>192.xxx.x.x</host>
       <port>3306</port>
       <user>xbmc</user>
       <pass>xbmc</pass>
       <name>xbmc_music</name>
    </musicdatabase>
</advancedsettings>

What I want/wish is to have one location for media with Kodi seeing any updates (new files/watched)

Anybody help please

[laomai]

Hi Philip

I just did this for my Kodi on raspberry pi recently and was successful.
I installed the myphpadmin package for v1.02 for DNS320L and followed the instructions at http://kodi.wiki/view/MySQL
Did you do an export and import of your library? Also your advanced settings look a bit different.

[philphil61]

Fixed
Several issues
advancedsettings.xml
the first bit needs moving to the end but read as follows
<videolibrary>
       <importwatchedstate>true</importwatchedstate>
       <importresumepoint>true</importresumepoint>
     </videolibrary>
     <pathsubstitution>
       <substitute>
          <from>special://profile/Thumbnails/</from>
          <to>smb://"name of nas"/Volume_1/Thumbs</to>
       </substitute>
     </pathsubstitution>
Create folder Thumbs on NAS and copy contents of Thumbnails folder (userdata) to new folder

Also more importantly make sure all versions of kodi are the same and dont update - this is because phpmyadmin will shown different databases for different versions of kodi