HOW-TO:Share libraries using MySQL: Wiki Edition
(2015-02-17, 08:55)RamboUnchained Wrote: I lost my TV and Movie tab on the homescreen due to a corrupted DB. Currently rescraping nfo. I forgot to backup my DB before running MySQL for the first time Sad. I have a username and password setup on Kodi, so is:

Code:
<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.3</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </videodatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
  </advancedsettings>

Or should I use:

Code:
<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.3</host>
    <port>3306</port>
    <user>RamboUnchained</user>
    <pass>personalpassword</pass>
  </videodatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
</advancedsettings>

I'm on 14.1 Helix stable. My Armada Mach 8 Android box comes in the mail tomorrow and will be running the same version. My MySQL version is 5.6.23.

ok, I think I might have found a bug in 14.1 and 14.2 beta to do with this..
Been testing it all day..
So far this is my setup.. which has worked on Gotham and previous builds up until the move to Helix builds..

1: Synology on DSM 5.1 MySQL lastest MariaDB version.

Machines: Win64 HTPC - Main machine running H14.1
fresh install will not write to the database.. will only write to the internal database, V90 and M48..
Android H14.1 - all will write and see central db

Tested via fresh installs and deletion of databases in the Synology and also within the internal install on videos..
Win64 machine..
Will not write a new database to central server.. tried install and uninstalls, cleans and will only update to internal DB..
the following is as same as posts above for the Advancedsettlings.xml

Code:
<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>10.1.1.10</host>
        <port>3306</port>
        <user>kodi</user>
        <pass>kodi</pass>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>10.1.1.10</host>
        <port>3306</port>
        <user>kodi</user>
        <pass>kodi</pass>
    </musicdatabase>
    
    <pathsubstitution>
     <substitute>
      <from>special://masterprofile/Thumbnails/</from>
      <to>smb://10.1.1.10/Thumbs/</to>
     </substitute>
    </pathsubstitution>
    
     <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
  
</advancedsettings>
<!-- Mine --->

Also tried to change it to "
webserver name' but no dice..

But ...
As soon as I kick on the Android version with same advanced setting.. no drama..
Android 14.1 will write a new Database to server and will populate... go figure?

on the win machine I have advancedsettings where it should be.. *\appdata\roaming\kodi\userdata

so it should be picking it up and running with it..

Any clues on how to bet this one?
Thanks in advance..
will post a log from the machine in question as looks like something in it might be making it not look in the right folder for the advancedsettings.xml

Code:
Log File is located: C:\Users\DG-Home\AppData\Roaming\Kodi\kodi.log
17:31:15 T:4828  NOTICE: -----------------------------------------------------------------------
17:31:15 T:4828  NOTICE: load settings...
17:31:15 T:4828 WARNING: CSettingString: unknown options filler "timezonecountries" of "locale.timezonecountry"
17:31:15 T:4828 WARNING: CSettingString: unknown options filler "timezones" of "locale.timezone"
17:31:15 T:4828  NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
17:31:15 T:4828   ERROR: Error loading special://profile/advancedsettings.xml, Line 54
                                            Error reading end tag.

This line.. " No settings file to load (special://xbmc/system/advancedsettings.xml)"
seems to be a problem.. why is it looking in there?
When it should be looking in... "*\AppData\Roaming\Kodi\userdata ?
Am I barking up the wrong tree with this?
But it does seem not to be calling the file in question..
For good measure I have the file in two places..
C:\Users\DG-Home\AppData\Roaming\Kodi\userdata
F:\xbmc\Kodi\userdata
but is not picking it up..
Reply


Messages In This Thread
Re: RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - by dgcruzing - 2015-02-20, 09:52


Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition2
This forum uses Lukasz Tkacz MyBB addons.