D-Link Forums

The Graveyard - Products No Longer Supported => D-Link Storage => DNS-320L => Topic started by: PC_Arcade on October 10, 2015, 10:57:27 AM

Title: Please help! MySQL and KODI
Post by: PC_Arcade on October 10, 2015, 10:57:27 AM

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!

Title: Re: Please help! MySQL and KODI
Post by: masterxilef on October 10, 2015, 06:14:49 PM

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.

Title: Re: Please help! MySQL and KODI
Post by: PC_Arcade on October 11, 2015, 02:44:41 AM

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

Title: Re: Please help! MySQL and KODI
Post by: philphil61 on November 02, 2015, 10:21:45 AM

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

Quote

<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

Title: Re: Please help! MySQL and KODI
Post by: laomai on November 03, 2015, 09:59:47 PM

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.

Title: Re: Please help! MySQL and KODI
Post by: philphil61 on November 05, 2015, 09:42:33 PM

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