Kodi Community Forum
HOW-TO:Share libraries using MySQL: Wiki Edition - Printable Version

Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Tips, tricks, and step by step guides (https://forum.kodi.tv/forumdisplay.php?fid=110)
--- Thread: HOW-TO:Share libraries using MySQL: Wiki Edition (/showthread.php?tid=157572)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - RamboUnchained - 2015-02-22

(2015-02-22, 06:29)Milhouse Wrote:
(2015-02-22, 06:14)RamboUnchained Wrote: Deleting textures13.db didn't do anything. It was only a 36kb file when I deleted it.

Unless you'd already deleted it recently, it doesn't sound like you're deleting the correct file - Textures13.db should contain one row for every Thumbnail file, and would normally be several megabytes in size for a reasonable number of thumbnails.

If your current client is referencing a different Textures13.db that remains populated with cached artwork, that would explain why no new artwork is being added to the cache.

I'm pretty sure that was the issue. I decided to go the external USB route in the end. I ended up reformatting a LinuxLive USB 3.0 drive that I would use for troubleshooting at work. I'll just get another flash drive for that. I think 8GB will be more than enough with

Code:
<imageres>720</imageres>
<fanartres>1080</fanartres>

in my XML. I've scanned a couple of shows with 50+ episodes that gave me a crapload of thumbs in return. 144 files and 37 folders, but only 6.58mb of storage have been used. I should be fine. I appreciate you taking time out of your day to assist me with this.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - spankeds10 - 2015-02-22

ok soo... had everything working pretty good, had a computer failure and had to start all over again. my main machine is working and picking up the mysql db. the others are seeing the library but when i chose something it says file no longer available. the database shows the library count, sharing thru smb and copied sources.xml. Im missing a step somewhere and cant figure out which one lol.


http://xbmclogs.com/p1komdq7l

any help is appreciated. Thanks


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - spankeds10 - 2015-02-22

ok nevermind. figured it out. settings with homegroup and some file sharing setting werent set.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - DruTheFu - 2015-03-06

Having everything configured on the 'Master' device, with libraries being scrapped and all the metadata/media file info being present, will the second 'Client' device require ANY library scrapping to be configured to show artwork/thumbnails? I'm assuming the Master device will handle all of the scrapping and populate the MySQL Db. On a similar thought, will the Client device require any local fanart/thumbnail/extrafanart/artwork settings configured, or Addons configured, in order to display/mirror the same artwork as the Master?


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - Raytestrak - 2015-03-06

(2015-03-06, 17:27)DruTheFu Wrote: Having everything configured on the 'Master' device, with libraries being scrapped and all the metadata/media file info being present, will the second 'Client' device require ANY library scrapping to be configured to show artwork/thumbnails? I'm assuming the Master device will handle all of the scrapping and populate the MySQL Db. On a similar thought, will the Client device require any local fanart/thumbnail/extrafanart/artwork settings configured, or Addons configured, in order to display/mirror the same artwork as the Master?

I have only one master instance, which does all the scraping, and all my clients have the same info and fanart without any additional scraping, so no.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - flhthemi - 2015-03-06

Same here...I do notice that if you change the artwork from any one of the clients it will change it on all the clients and the master as well. Nice! but be warned, as I have done in the past, you can also end up deleting the database from any client as well as the master!


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - DruTheFu - 2015-03-06

So only the Master should be configured to do the scraping? I.e. Setting content and subsequent scraping should only be performed on the Master and not a Client?

Sorry for rehashing this topic and adding any confusion, but I've noticed different statements spread through various posts on this topic.

This would bea good subject to confirm for a FAQ on this forum for sharing libraries and configuring shared libraries among multiple clients.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - Dilligaf - 2015-03-06

There is no "master" and"client" Kodi installs, they should all be equal. The only "master" is the MySql server. I have anywhere from 5 to 10 xbmc installs (mixture of Windows and various flavors of Linux) at any one time and any of them can scrape and update the MySql database without creating errors or duplicates.

The key is to configure one instance where all sources are remote shares and NOT local C:\******* D:\**** paths. If the media files are on the local machine then still use the network path to them (it will work and find them) . Once you have one install working then COPY sources.xml, passwords.xml and advancedsettings.xml to the /userdata folders of all other installs, at this point everything should work.

One issue is passwords and Windows vs Linux installs when using Windows/Samba shares. When a Windows share is shared with "Everyone" it is NOT shared with "Anyone" only accounts/machines that are known to it. Linux machines need a user/pass known to Windows to access Windows shares, the easiest way to do this is to set up the initial sources.xml on a Linux machine, provide a user/pass known to Windows and check on save credentials when prompted. This will create entries in passwords.xml to store the user/pass and will work for Windows, Linux and Apple installs If the initial sources.xml is created from a Windows install you should manually create passwords.xml (wiki) before performing your initial library scan.

As the wiki doesn't seem to have much about passwords.xml it looks like this you can also look at path substitution (wiki)
Code:
<passwords>
    <path>
        <from pathversion="1">smb://192.168.1.10/</from>
        <to pathversion="1">smb://User:[email protected]10/</to>
    </path>
    <path>
        <from pathversion="1">smb://192.168.1.10/Movies</from>
        <to pathversion="1">smb://User:[email protected]/Movies/</to>
    </path>
</passwords>

In the above example the second entry is redundant as it is covered by the first entry. I highly recommend the use of IP address over names as long as the shares have a static IP


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - DruTheFu - 2015-03-06

Thanks for the clarification @Dilligaf [thumbs up]

In my original Kodi implementation onto my two AFTV boxes, I was leveraging SMB sources (i.e. smb://username:[email protected]_Address/directory/) housed on my Windows 8.1 machine that does not have a Kodi install. This machine was my media 'server' housing my media files. So the Kodi installs on the AFTV's always referenced network shared sources, and shared common libraries via MySQL installed on the Win8.1 machine.

The SMB sources were great for the sharing of media and libraries, but when it came to write access to these sources for things like the Backup addon and other Kodi related writing to shares (see AFTV: Cannot Write to Windows SMB share ), SMB was not the ultimate means for connecting to my shared network sources. To overcome this, I had to connect via the NFS route by installing haneWIN NFS Server on my Win8.1 machine. I'm a total noob with NFS, but it was my understanding that NFS does not use passwords when connecting, rather some sort of session mount ID to establish connection. With using NFS mounted shares, I've deleted the passwords.xml, and have not seen any negative impact (as of yet). Sorry for this tangent...

I only mention this because both instances of Kodi on my AFTV's reference remote shared sources, not local sources. I say this, because with my noobness of sharing libraries, I was under the impression that with both of my AFTV's in essence being remote clients to the sources, I thought only one of the devices should be configured to do the actual media scraping. I did not know that both devices could do the scraping without a resulting duplicate of the file being injected into the MySQL Db. This new-to-me confirmation that you've just outlined above will be a HUGE help with getting my Kodi implementations successfully working. I was dreading having to spend the time to duplicate my configuration efforts on my second AFTV. Now it appears that a simple backup of one, and restore to the other device will result in a mirror image the other device with any negative result of dupes in the libraries. I hope I'm now understanding this correctly.

I tried to dabble in path substitution for the Thumbnails directory to help manage the limited storage space native to the AFTV, but I wasn't having much success. Once I get the two AFTV's configured correctly (now) and things are running smoothly, I will start back up and continue to explore the path substitution concept.

Touche Dilligaf, thanks for the help and clarifications.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - Raytestrak - 2015-03-07

(2015-03-06, 21:45)Dilligaf Wrote: There is no "master" and"client" Kodi installs, they should all be equal. The only "master" is the MySql server. I have anywhere from 5 to 10 xbmc installs (mixture of Windows and various flavors of Linux) at any one time and any of them can scrape and update the MySql database without creating errors or duplicates.

True, what I meant by master is that I have only one instance that does all the scraping. It's on my host machine and it does automatic scrapping on interval and my clients are set up to NOT do any scraping, since this saves (some) startup time.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - Dilligaf - 2015-03-12

(2015-03-06, 22:23)DruTheFu Wrote: Thanks for the clarification @Dilligaf [thumbs up]

To overcome this, I had to connect via the NFS route by installing haneWIN NFS Server on my Win8.1 machine. I'm a total noob with NFS, but it was my understanding that NFS does not use passwords when connecting, rather some sort of session mount ID to establish connection. With using NFS mounted shares, I've deleted the passwords.xml, and have not seen any negative impact (as of yet). Sorry for this tangent...

Just now noticed that you replied to this. If you do install Kodi to the Window machine then copying sources.xml and advancedsettings.xml from one of the other installs to it will work. The nfs connection will "loopback" and connect to the shares even though they are on the same machine. This "loopback" principle seems the hardest for people to understand as they always want to use the local path to files on the machine which screws everything up


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - jl88 - 2015-03-17

I tried to set up the MySQL Database as described by kodi wiki.
Kodi created the Database successfully, and after videodatabase import all my shows were written in the tables.
After a reboot of my openelec system the kodi videodatabase is empty.

The Log gives me this information (extracts):

[..]
Code:
17:46:00 T:140608596715392  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.0.27</host>
                                                <port>3306</port>
                                                <user>kodi</user>
                                                <pass>kodi</pass>
                                                <name>MyVideos90</name>
                                              </videodatabase>
                                              <videolibrary>
                                                <importwatchedstate>true</importwatchedstate>
                                                <importresumepoint>true</importresumepoint>
                                              </videolibrary>
                                            </advancedsettings>
[..]
Code:
17:46:02 T:140608596715392  NOTICE: Running database version Addons16
17:46:02 T:140608596715392  NOTICE: Running database version ViewModes6
17:46:02 T:140608596715392  NOTICE: Running database version Textures13
17:46:02 T:140608596715392  NOTICE: Running database version MyMusic48
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9090 [1049](Unknown database 'MyVideos9090')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9089 [1049](Unknown database 'MyVideos9089')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9088 [1049](Unknown database 'MyVideos9088')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9087 [1049](Unknown database 'MyVideos9087')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9086 [1049](Unknown database 'MyVideos9086')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9085 [1049](Unknown database 'MyVideos9085')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9084 [1049](Unknown database 'MyVideos9084')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9083 [1049](Unknown database 'MyVideos9083')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9082 [1049](Unknown database 'MyVideos9082')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9081 [1049](Unknown database 'MyVideos9081')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9080 [1049](Unknown database 'MyVideos9080')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9079 [1049](Unknown database 'MyVideos9079')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9078 [1049](Unknown database 'MyVideos9078')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9077 [1049](Unknown database 'MyVideos9077')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9076 [1049](Unknown database 'MyVideos9076')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9075 [1049](Unknown database 'MyVideos9075')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9074 [1049](Unknown database 'MyVideos9074')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9073 [1049](Unknown database 'MyVideos9073')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9072 [1049](Unknown database 'MyVideos9072')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9071 [1049](Unknown database 'MyVideos9071')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9070 [1049](Unknown database 'MyVideos9070')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9069 [1049](Unknown database 'MyVideos9069')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9068 [1049](Unknown database 'MyVideos9068')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9067 [1049](Unknown database 'MyVideos9067')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9066 [1049](Unknown database 'MyVideos9066')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9065 [1049](Unknown database 'MyVideos9065')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9064 [1049](Unknown database 'MyVideos9064')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9063 [1049](Unknown database 'MyVideos9063')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9062 [1049](Unknown database 'MyVideos9062')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9061 [1049](Unknown database 'MyVideos9061')
17:46:02 T:140608596715392   ERROR: Unable to open database: MyVideos9060 [1049](Unknown database 'MyVideos9060')
17:46:04 T:140608596715392  NOTICE: Running database version TV26
17:46:04 T:140608596715392  NOTICE: Running database version Epg8
17:46:04 T:140608596715392  NOTICE: start dvd mediatype detection
17:46:04 T:140608572327680  NOTICE: Thread DetectDVDMedia start, auto delete: false

I can't figure it out, why kodi is trying to connect to the Database MyVideos9090, etc.
The Name of the Database is just MyVideos90.
Any Ideas/Suggestions?


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - Dilligaf - 2015-03-17

Delete the name line from advancedsettings, Kodi adds the 90 as the database version automatically. The <name> field only causes problems and is only needed if you run multiple databases


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - jl88 - 2015-03-17

(2015-03-17, 19:16)Dilligaf Wrote: Delete the name line from advancedsettings, Kodi adds the 90 as the database version automatically. The <name> field only causes problems and is only needed if you run multiple databases

At first shot I tried it without the name tag, didn't work so far. I didn't looked up the logfiles at the first shot.
Now that i removed the name tag, everything is working.

Whatever, thanks for your help Smile


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - lowbee - 2015-03-20

(2015-02-21, 00:28)RamboUnchained Wrote: The pause/resume feature doesn't seem to be working either.

Searching this thread, the above is the latest MySQL reference to the subject of resume points.
Has anyone got resume points for TV shows to work between multiple Kodi machines on .strm since then ?

I tried the T**** add-on but it doesn't sync resume points for TV shows between machine either. I so wish there is a solution for this.


This forum uses Lukasz Tkacz MyBB addons.