[Lepy]

I have read multiple guides for setting up a shared MySQL library between multiple instances of XBMC; however, all of the guides seem centered on a single server hosting all the media files.
Unfrotunately, I currently can not consolidate and share my files from one source. I may be overlooking something very simple, but I would appreciate some help.

I have 4 main machines on my network with one 12.04 mythbuntu backend acting as the MySQL server for both XBMC and MythTV:

1.) 2X 12.04 Mythbuntu (backend and frontend)
- Each sharing one folder over SAMBA containing sub folders and acting as XBMC frontend
- On each machine, the main folder is shared with subfolders, e.g. /video is shared with sub-folders: /video/TV and /video/Movies
- Accessible on Win7Pro using \\192.168.1.*\video\TV or \\192.168.1.*\video\Movies
2.) 1X Windows 7 Pro
- Sharing 4 folders through default protocol and acting as XBMC frontend
- Shared through Advanced Share Folder diaglouge
- Acessible on Win7Pro using \\192.168.1.101\*ip$, etc.
3.) 1X FreeNAS7 hosting multiple SAMBA/NFS shares
- Accesible on Win7Pro using \\192.168.1.104\pool0*\media\*

I want to setup two MySQL profiles
1.) One for both 12.04 Mythbuntu and the Win7Pro machines
- Accessing only \\192.168.1.*\video\TV, \\192.168.1.*\video\Movies, and \\192.168.1.104\pool0*\media\* for main use
2.) One for both 12.04 Mythbuntu and the Win7Pro machines
- Acessing only \\192.168.1.101\*ip$ and \\192.168.1.104\pool0*\media\* for testing purposes

Sample of advancedsettings.xml for ubuntu machines:

Code:

<advancedsettings>
    <videodatabase>
    <type>mysql</type>
    <host>192.168.1.100</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    </videodatabase>
    <musicdatabase>
    <type>mysql</type>
    <host>192.168.1.100</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
    </musicdatabase>
    <video>
    <vdpauscaling>true</vdpauscaling>
     <usetimeseeking>truee</usetimeseeking>
    <timeseekforward>3</timeseekforward>
    <timeseekbackward>-10</timeseekbackward>
    <timeseekforwardbig>150</timeseekforwardbig>
    <timeseekbackwardbig>-150</timeseekbackwardbig>
    </video>
    <pathsubstitution>
        <substitute>
           <from>/media/pool02/media/movies</from>
           <to>SMB://192.168.1.104/pool02/media/movies</to>
        </substitute>
        <substitute>
           <from>/media/pool02/media/tv</from>
           <to>SMB://192.168.1.104/pool02/media/tv</to>
        </substitute>
        <substitute>
           <from>/video/TV</from>
           <to>SMB://192.168.1.100/video/TV</to>
        </substitute>
        <substitute>
           <from>/video/Movies</from>
           <to>SMB://192.168.1.100/video/Movies</to>
        </substitute>
    </pathsubstitution>
</advancedsettings>

I hope I've been clear enough as I've been banging my head against the a wall trying to configure this setup

Thanks,
-Lepy

[Ned Scott]

Sources don't have to be in the same location, but they have to be a network path even if it is locally hosted content.

Are you trying to use pathsubs because the preexisting libraries used local paths? Are there multiple libraries (one for each XBMC device)? (This isn't a requirement. Just trying to figure out where you are starting from)

[Lepy]

Nevermind, I figured it out.

My problem was related to sources.xml. From using XBMC since the days of the xbox, I guess it was imprinted in my head to use local/locally mounted network drives instead of using network drives.

I created a new sources.xml for both main and test profiles using SMB links, replacing the hostname in smb://HOSTNAME/path/ with the IP address of each machine

After adding the sources.xml to each machine's profile directories, library sharing is working!

Also, beer and networking don't mix well most of the time.