MySQL Database: Multiple XBMC HTPC's with 1 Shared Library

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
nickr Online
Donor
Posts: 8,052
Joined: May 2009
Reputation: 141
Location: Christchurch NZ
Post: #316
debug log

If I have helped you or increased your knowledge, click the plus button and increase my reputation :)
find quote
tschi Offline
Junior Member
Posts: 7
Joined: Dec 2009
Reputation: 0
Post: #317
Hello
I have some issue using xbmc 13.1 on win7 and MySQL 5.5.36 on freebsd 9.2 on network.
When the scrapper doesn't find the film, I choose Manual, I fill the correct name, press OK, the scrapper find the film, I choose the film but XBMC doesn't update the database with the scrapper information.
I made the same test without MySQL database (default db) and there is no issue.
I test with differents scrappers and MySQL and the probleme exists for all
Here a debug log : http://pastebin.com/B4aVRcN9

The only update on movie table done by XBMC is
Code:
DEBUG: Mysql execute: update movie set c11=7095 where idFile=9324 and c11=''
So there is no name, description ... for the film in is case.

Thanks for your consideration
find quote
jmhenry5150 Offline
Junior Member
Posts: 14
Joined: Jun 2014
Reputation: 0
Post: #318
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?
find quote
jmhenry5150 Offline
Junior Member
Posts: 14
Joined: Jun 2014
Reputation: 0
Post: #319
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?
find quote
nickr Online
Donor
Posts: 8,052
Joined: May 2009
Reputation: 141
Location: Christchurch NZ
Post: #320
I believe that they are cached in .xbmc/userdata/Thumbnails/

If I have helped you or increased your knowledge, click the plus button and increase my reputation :)
find quote
poplap Offline
Senior Member
Posts: 106
Joined: Dec 2012
Reputation: 1
Location: The Underworld
Post: #321
I have a quick question, I am setting up a MySQL database for the parents on an old macbook that I have turned into a "Server," it holds their movies and hopefully the MySQL DB. My Question is I want to run XBMC on there server too, for traveling and populating the DB for the first time, and I was wondering if the source address matters, for example XBMC@Server connects locally, XBMC@FTV connects over SMB/AFP. What I want to know is if the DB stores the file URL for the movie instance, which if it does I'd imagine that would stop this from working.

Thanks
find quote
nickr Online
Donor
Posts: 8,052
Joined: May 2009
Reputation: 141
Location: Christchurch NZ
Post: #322
You will need to use path substitution.

If I have helped you or increased your knowledge, click the plus button and increase my reputation :)
find quote
poplap Offline
Senior Member
Posts: 106
Joined: Dec 2012
Reputation: 1
Location: The Underworld
Post: #323
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

[Image: all-thin-banner.jpg]

Raspberry Pi Model B 512MB @ 1.1Ghz w/ USB Storage
FreeNAS Server w/ 2TB of Moves/TV Shows
find quote
nickr Online
Donor
Posts: 8,052
Joined: May 2009
Reputation: 141
Location: Christchurch NZ
Post: #324
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 plus button and increase my reputation :)
find quote
poplap Offline
Senior Member
Posts: 106
Joined: Dec 2012
Reputation: 1
Location: The Underworld
Post: #325
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>

[Image: all-thin-banner.jpg]

Raspberry Pi Model B 512MB @ 1.1Ghz w/ USB Storage
FreeNAS Server w/ 2TB of Moves/TV Shows
find quote
hosko Offline
Junior Member
Posts: 15
Joined: Nov 2013
Reputation: 2
Post: #326
If you don't already have a library and starting from scratch best practice is to not use local connection on the server but connect via network share. That way the in SQL all the video paths are the correct network addresses. This is in the wiki. I use a windows 8 HTPC as my server, I created an SMB share of my video folder and then added the SMB share to XBMC. After adding my SQL info to the advancedsettings.xml I added it aswell as my sources.xml and passwords.xml to all my other devices (PC, rasp pi's and Nexus 7) and then there is no other setup needed on the other devices.

Just follow the step by step guide in the wiki and you shouldn't have any problems.
find quote
black_eagle Offline
Fan
Posts: 617
Joined: Sep 2013
Reputation: 10
Post: #327
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 !!
find quote
hosko Offline
Junior Member
Posts: 15
Joined: Nov 2013
Reputation: 2
Post: #328
(2014-06-27 15:57)black_eagle Wrote:  I have my xbmc setup like this on purpose, so my kids can't change anything !!

Nice tip, my lack of kids means I like having full control everywhere but I can see where a locked down solution might be a good idea.
find quote
poplap Offline
Senior Member
Posts: 106
Joined: Dec 2012
Reputation: 1
Location: The Underworld
Post: #329
(2014-06-27 15:38)hosko Wrote:  If you don't already have a library and starting from scratch best practice is to not use local connection on the server but connect via network share. That way the in SQL all the video paths are the correct network addresses. This is in the wiki. I use a windows 8 HTPC as my server, I created an SMB share of my video folder and then added the SMB share to XBMC. After adding my SQL info to the advancedsettings.xml I added it aswell as my sources.xml and passwords.xml to all my other devices (PC, rasp pi's and Nexus 7) and then there is no other setup needed on the other devices.

Just follow the step by step guide in the wiki and you shouldn't have any problems.

Ya I was fallowing the wiki for MySQL and have it all setup. My question now is when and how to use path substitution sense the wiki is a little unclear about it. See they will be moving and plan to take the server (a macbook) with them to bring all the movies but they will also have other devices after moving so you see I can't have it connect remotely to access the media sense it will be on the move. What I was hoping that I could use path substitution to by pass the network and connect locally when they are on the move. But from the looks of it would have to effect both sources and the DB for it to work. I might just use profiles and export the DB once its fully populated but I need to do more research.

Thanks

[Image: all-thin-banner.jpg]

Raspberry Pi Model B 512MB @ 1.1Ghz w/ USB Storage
FreeNAS Server w/ 2TB of Moves/TV Shows
find quote
Post Reply