futeko.com FORUM

Product Support => HiMedia Q10 Pro, Q5 Pro => Topic started by: tetar on October 10, 2016, 05:23:35 PM

Title: Mysql access on Q5media Pro
Post by: tetar on October 10, 2016, 05:23:35 PM

Hello,

I have a mysql server on a nas and i would like to know if it's possible to use kodi on q5Pro it with the xml file advancedsettings.xml like this for example :

<advancedsettings>
     <videodatabase>
       <type>mysql</type>
       <host>192.168.x.x</host>
       <port>3306</port>
       <user>xbmc</user>
       <pass>xxxx</pass>
       <name>xbmc_video</name>
    </videodatabase>
    <musicdatabase>
       <type>mysql</type>o
       <host>192.168.x.x</host>
       <port>3306</port>
       <user>xbmc</user>
       <pass>xxxx</pass>
       <name>xbmc_music</name>
    </musicdatabase>
</network >

</advancedsettings>

This is my setup with rapsberry pi2 and kodi and i want to use the same db with my future box Q5media Pro.

Thx in advance for your advice or informations  ;)

Title: Re: Mysql access on Q5media Pro
Post by: siempo2000 on October 10, 2016, 05:43:55 PM

Hi tetar,

I can confirm this setup is working.
Have been using the same for 2 months now.

Title: Re: Mysql access on Q5media Pro
Post by: tetar on October 10, 2016, 05:58:03 PM

Thx a lot for this fast reply siempo2000 !

Another question, do you use the directory thumbnails in local or use a mount point to your nas to access this directory (on my pi2 i use a symbolic link to a mount point to my nas) ?

Title: Re: Mysql access on Q5media Pro
Post by: tetar on October 10, 2016, 06:18:02 PM

for Thumbnails, i will try a thing like  that : (saw it on kodi wiki)

<advancedsettings>
 <pathsubstitution>
  <substitute>
    <from>special://profile/Thumbnails/</from>
    <to>PROTOCOL://YOUR_NETWORK_SHARE/Kodi/userdata/Thumbnails/</to>
  </substitute>
 </pathsubstitution>
</advancedsettings>

Title: Re: Mysql access on Q5media Pro
Post by: siempo2000 on October 10, 2016, 06:49:51 PM

Hi tetar,

I personally do not use storing thumbnails on a shared media  because it will slow down the loading of these thumbnails in kodi.

Title: Re: Mysql access on Q5media Pro
Post by: tetar on October 10, 2016, 07:54:39 PM

i agree, i must think about that ! may be this would be better for me too ...

Title: Re: Mysql access on Q5media Pro
Post by: looun on October 10, 2016, 10:12:07 PM

yes work with kodi and spmc, Have been using the same for 6 months now.

Title: Re: Mysql access on Q5media Pro
Post by: tetar on October 10, 2016, 10:25:19 PM

thx looun, i will test that soon  8)