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

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

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library (/showthread.php?tid=85654)

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

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - asturnauta - 2012-11-18

(2012-11-18, 11:46)Ned Scott Wrote: You can either pathsub them like that example or copy the sources.xml file between XBMC boxes. It's not really required for a smooth set up, but is a convenience thing.

Hi

I configured my advancedsettings.xml with this:

Code:
<substitute>

        <from>special://masterprofile/sources.xml</from>

        <to>NFS://192.168.1.50/MyFolder/xbmc/userdata/sources.xml</to>

    </substitute>

    <substitute>

        <from>special://masterprofile/mediasources.xml</from>

        <to>NFS://192.168.1.50/MyFolder/xbmc/userdata/mediasources.xml</to>

    </substitute>

I execute xbmc but sources.xml and mediasources.xml have not been copied to my NAS (192.168.1.50/MyFolder/xbmc/userdata)

What am i doing wrong?

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Ned Scott - 2012-11-19

Post a debug log (wiki) so we can see if the advancedsettings.xml file loaded correctly.

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - asturnauta - 2012-11-19

(2012-11-19, 02:43)Ned Scott Wrote: Post a debug log (wiki) so we can see if the advancedsettings.xml file loaded correctly.

Hi, my debul log is here:

http://xbmclogs.com/show.php?id=14997

All my video sources are NFS shares and i can reproduce them very well.

Have i to copy manually the sources.xml to NFS share or the xbmc do it autotamically?

Thanks.

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Ned Scott - 2012-11-19

Ah, yes, you have to actually copy them to the NFS share for it to work.

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - asturnauta - 2012-11-19

(2012-11-19, 13:27)Ned Scott Wrote: Ah, yes, you have to actually copy them to the NFS share for it to work.

Thank you so much.

I have copied xml files to NAS and if i add new sources the changes are saved to xml on the NAS.

Last question, Have i to remove original xml files on the local computer?

And, In wich folder of the NAS are saved the thumbnails and fanart?

Thanks.

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Styxiak - 2012-12-04

Hi,

Why if i use <name> of database in advancedsettings.xml xbmc still want to follow tha name with number?

It is not usable on database providers where you havent control on database name. Sad

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Ned Scott - 2012-12-04

Database providers? A MySQL setup is really only meant to be used via a local network. Using it via an internet server will make it really slow to load.

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - thaJack - 2012-12-06

For those who don't know (and if it's been mentioned, sorry), you can also create symlinks to files, not just directories. My keymap, advanced settings, etc files are also stored on the server and a symlink on each client points to them. If I want to change something in the keymap or advanced settings I just do it on the server copy and every client reflects the change.

Just FYI.

RE: - thaJack - 2012-12-06

(2011-03-06, 02:47)Ron_C Wrote:
Ron_C Wrote:Good idea. Ticket has been entered.

My ticket was rejected because apparently that resumetime is NOT the field used for...well..the resume time and, it seems the resume time is not set until at least 3 minutes into a video. I tried my setup again, this time skipping more than 3 min and it worked perfectly!

You can also add:

<ignoreatstart>60</ignoreatstart>

To the <video></video> section of your advancedsettings.xml. The number, 60 in this case, is how many seconds the video must place before the resume point is set. I believe the setting still works in the latest versions of XBMC. I've had it in mine for a long time.

(2011-03-06, 02:47)Ron_C Wrote:
Ron_C Wrote:Good idea. Ticket has been entered.

My ticket was rejected because apparently that resumetime is NOT the field used for...well..the resume time and, it seems the resume time is not set until at least 3 minutes into a video. I tried my setup again, this time skipping more than 3 min and it worked perfectly!

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - pheidias - 2012-12-07

I'm trying to move to frodo, after I set everything up and try to update my library I get duplicates. this is how they look in the database one is from db60 and one is the new update from frodo b2

<path>smb://10.0.1.7/720p1080p/Drive.1080p.BluRay.X264-BLOW/</path> <filenameandpath>rar://smb%3a%2f%2f10%2e0%2e1%2e7%2f720p1080p%2fDrive%2e1080p%2eBluRay%2eX264%2dBLOW%2fdrive%2e1080p%2ebluray%2ex264%2dblow%2erar/Drive.1080p.BluRay.X264-BLOW.mkv</filenameandpath>

<path>smb://10.0.1.7/720p1080p/Drive.1080p.BluRay.X264-BLOW/</path>
<filenameandpath>rar://smb%3a%2f%2f10.0.1.7%2f720p1080p%2fDrive.1080p.BluRay.X264-BLOW%2fdrive.1080p.bluray.x264-blow.rar/Drive.1080p.BluRay.X264-BLOW.mkv</filenameandpath>

Why isn't filename and path the same?

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - ScorpioJonesy - 2014-04-12

Is it possible to use a shared MYSQL for just music and video but not the PVR aspect (unless that would work). I want to use a few NUC's with XBMC talking back to a MCE via the plugin as PVR clients but I dont want it causing odd behaviour with recording etc.

Re: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2014-04-12

MySQL only does video and music DB's anyway. Nothing to do with Pvr.

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - ScorpioJonesy - 2014-04-14

(2014-04-12, 22:04)nickr Wrote: MySQL only does video and music DB's anyway. Nothing to do with Pvr.

Great thanks for the info.

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Ned Scott - 2014-04-14

Actually, you can share the PVR DB over MySQL as well, but I don't think it's currently documented on the wiki. It won't use MySQL unless you specifically add a PVR entry in advancedsettings.xml

RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - tank27 - 2014-04-16

I have 4 computers 2 PC 1 OUYA and 1 MAC. I can share mydatabase between the OUYA and PC fine but the MAC can see the movies/TVShows in the database but when i try to play something it says file not in library. any idea why. If i browse for the files i can find them and play them just fine