Posts: 130
Joined: Jun 2014
Reputation:
0
Ok I think I have something screwed up here in MySQL database...
For artwork, I select against my art table and I see multiple locations, some point to my server and some point to image.tmdb.com (which is my preference)...
How do I go about refreshing all these images to point to TMDB so that I can get rid of these local files?
Posts: 130
Joined: Jun 2014
Reputation:
0
Also, can someone tell me the relationship between the MySQL database and the cached images that reside on the local boxes?
For instance, I do a quick search in the actors table and I see a URL that points to TMDB...
However when I browse the userdata folder, I see actor images...is this where the images are being stored from the TMDB URL?
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
I believe that they are cached in .xbmc/userdata/Thumbnails/
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
You will need to use path substitution.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 195
Joined: Dec 2012
Reputation:
1
poplap
Senior Member
Posts: 195
Thanks, so it would be like this right? :
<advancedsettings>
<pathsubstitution>
<substitute>
<from>SMB://192.168.1.19/Movies/</from>
<to>/Volumes/G-Drive/Movies</to>
</substitute>
</pathsubstitution>
</advancedsettings>
I would do this before setting up the sources or just before adding them to the library??
Thanks again
Raspberry Pi Model B 2 1024MB @ 1.0Ghz w/OSMC
--Decommissioned-- Raspberry Pi Model B 512MB @ 1.0Ghz w/ 3TB USB Drive Running Open Media Vault
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
You don't need to set up any sources on the second machine, nor do you need to scan/scrape.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 195
Joined: Dec 2012
Reputation:
1
poplap
Senior Member
Posts: 195
Oh I was talking about the Server. For simplicity I wanted the DB to have the smb share and sub the server's path that way its just easier to manage. The wiki seams to lack some information on how this works, does it sub in the DB only and I just tell the server to connect locally or is it substituting for all interactions with the source. Also it would probably flipped in both cases:
<to>/Volumes/G-Drive/Movies</to>
<from>SMB://192.168.1.19/Movies/</from>
Raspberry Pi Model B 2 1024MB @ 1.0Ghz w/OSMC
--Decommissioned-- Raspberry Pi Model B 512MB @ 1.0Ghz w/ 3TB USB Drive Running Open Media Vault
Posts: 3,895
Joined: Sep 2013
Reputation:
358
You don't need to copy the sources.xml between machines, unless you intend on editing stuff on them. The paths are all in the MySQL database anyway. The only time you really need the sources.xml duplicated is if you want to edit art or something. Without the sources.xml, the client won't have the paths to be able to do it.
I have my xbmc setup like this on purpose, so my kids can't change anything !!
Learning Linux the hard way !!
Posts: 2,838
Joined: Dec 2006
Reputation:
2
One question about mysql. Can I use uniform server (uniformserver.com) instead of mysql.com? I would prefer not to install additional software of possible.
Server: Asus Sabertooth Z77 | Intel Core i5 3.4 GHz | 16 GB DDR3 | 128 GB SSD, 82 TB (9 x 6 TB, 7 x 4 TB)
HTPC 1: Raspberry Pi 2 | HTPC 2: Raspberry Pi 2 | HTPC 3: Raspberry Pi