About MYSQL and shared thumbnails
#16
I have a different solution to this issue which I thought I'd share.

I use a MySQL DB for my movies and music library, and I run three XBMC clients that all access this DB server. If a client is set to scan and update the library, it will download the thumbnails and update the DB. All other clients see the DB update, but not those local thumbnails. They actually generate their own thumbnails of random image pulls from the video, not the good ones you just downloaded. (Just restating the issue).

So, I put together a little Dropbox solution that fixes it all for me. I'm using Win7 on all clients, just fyi. I use a free Dropbox account and the sync application to keep all XBMC clients synched with the thumbnails. Just grab a gmail account and set a dedicated Dropbox account for this. It's free and easy.

For each client, I do the following:
(1) Install Dropbox Application for Win7 on each client. This app does auto-sync in the background on folders of your choosing, to a destination of your choosing.

(2) Set the destination of Dropbox to C:\Dropbox. You can make this what you want, but make it the same for all clients for consistency. You can't explicitly map the Dropbox sync to the userdata/thumbails folder, otherwise I would just do that. When you pick the destination folder, Dropbox automatically makes a "Dropbox" folder, then the synced folders go inside that. So this means your thumbnails live somewhere other than the default location.

(3) Use the path substitution XML code mentioned earlier (in the advancedsettings.xml) to re-map the thumbails to the Dropbox location

FROM: special://masterprofiles/thumbnails/
TO: C:\dropbox\thumbnails\

Done!

See, this way, the thumbnails are stored locally on your computer's drive, which makes it faster to load.
All clients running this configuration stay in sync.
And whenever a library update is called, the thumbnail changes and gets synced up to Dropbox, then down to all clients. The newest one wins, which can't be anything other than the one you scanned into the library.

This may seem like a bit of a sledgehammer approach, but once I set it up a while back, I actually forgot about it and everything has been pretty seamless since.

Reply
#17
(2012-09-20, 01:03)h1r0pr07ag0n1st Wrote: I have a different solution to this issue which I thought I'd share.

I use a MySQL DB for my movies and music library, and I run three XBMC clients that all access this DB server. If a client is set to scan and update the library, it will download the thumbnails and update the DB. All other clients see the DB update, but not those local thumbnails. They actually generate their own thumbnails of random image pulls from the video, not the good ones you just downloaded. (Just restating the issue).

So, I put together a little Dropbox solution that fixes it all for me. I'm using Win7 on all clients, just fyi. I use a free Dropbox account and the sync application to keep all XBMC clients synched with the thumbnails. Just grab a gmail account and set a dedicated Dropbox account for this. It's free and easy.

<snip>

Wow... while technically cool, that is really overkill and a lot of work.

I have 5 XBMC installs (4 @ win7, 1 @ iPad)

I make sure that I update my main machine, select my preferred artwork and that's that.

All the other machines DO NOT have anything defined as a source. As a result, everything comes from the MySQL database.

Update once on one machine, done. Works for +2500 movies.

(no gmail, no dropbox)

v.


PS... HEY JONATHAN !! Did the Music part get done yet? Just checking. OK Thx. Bie.
Reply
#18
Yes, music art is done. There's a few issues with it (bugs) but they're completely unrelated to the automatic thumb stuff.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply

Logout Mark Read Team Forum Stats Members Help
About MYSQL and shared thumbnails1