Linking all XBMC boxes in the house?

dkplayaclub

New member
Sep 14, 2012
472
0
0
Rochester, NY
OK. I have been dancing around this issue and doing half-assed solutions for some time now. The sea of info out there has only confused me so I'm here to ask the pros.
What I want to do is set all boxes in my home to use the same profile folder and the same library. My Ouyas are out of memory, mostly due to the profile folder getting larger. I'd like to make it so all XBMC boxes in the house reflect the changes I make on my main PC in the den.
Is this what SQL does? I need a starting point here.
 

the-one

Banned
May 7, 2013
189
0
0
New Jersey, USA
Yes, you need to setup MySql on your PC in the den.

Then setup advancedsettings.xml on each of your ouyas to point to it.

I have a similar setup with my GBOX MX2s. I am posting my advacnedsettings.xml file to give you an idea.

This will also keep your addon settings, favorites, playlists, source synched across multiple boxes.

Code:
<advancedsettings>
     <videodatabase>
       <type>mysql</type>
       <host>192.168.1.109</host>
       <port>3306</port>
       <user>xbmc</user>
       <pass>xbmc</pass>
       <name>xbmc_video</name>
    </videodatabase>
    <musicdatabase>
       <type>mysql</type>
       <host>192.168.1.109</host>
       <port>3306</port>
       <user>xbmc</user>
       <pass>xbmc</pass>
       <name>xbmc_music</name>
    </musicdatabase>
    <pathsubstitution>
     <substitute>
      <from>special://masterprofile/Thumbnails/</from>
      <to>smb://192.168.1.109/xbmc/Thumbnails/</to>
     </substitute>
	 <substitute>
      <from>special://masterprofile/playlists/</from>
      <to>smb://192.168.1.109/xbmc/playlists/</to>
     </substitute>
	 <substitute>
      <from>special://masterprofile/addon_data/</from>
      <to>smb://192.168.1.109/xbmc/addon_data/</to>
     </substitute>
	 <substitute>
      <from>special://masterprofile/keymaps/</from>
      <to>smb://192.168.1.109/xbmc/keymaps/</to>
     </substitute>
	 <substitute>
      <from>special://masterprofile/sources.xml</from>
      <to>smb://192.168.1.109/xbmc/sources.xml</to>
     </substitute>
     <substitute>
      <from>special://masterprofile/mediasources.xml</from>
      <to>smb://192.168.1.109/xbmc/mediasources.xml</to>
     </substitute>
	 <substitute>
      <from>special://masterprofile/RssFeeds.xml</from>
      <to>smb://192.168.1.109/xbmc/RssFeeds.xml</to>
     </substitute>
	 <substitute>
      <from>special://masterprofile/favourites.xml</from>
      <to>smb://192.168.1.109/xbmc/favourites.xml</to>
     </substitute>
	 <substitute>
      <from>special://profile/Thumbnails/</from>
      <to>smb://192.168.1.109/xbmc/Thumbnails/</to>
     </substitute>
	 <substitute>
      <from>special://profile/playlists/</from>
      <to>smb://192.168.1.109/xbmc/playlists/</to>
     </substitute>
	 <substitute>
      <from>special://profile/addon_data/</from>
      <to>smb://192.168.1.109/xbmc/addon_data/</to>
     </substitute>
	 <substitute>
      <from>special://profile/keymaps/</from>
      <to>smb://192.168.1.109/xbmc/keymaps/</to>
     </substitute>
	 <substitute>
      <from>special://profile/sources.xml</from>
      <to>smb://192.168.1.109/xbmc/sources.xml</to>
     </substitute>
     <substitute>
      <from>special://profile/mediasources.xml</from>
      <to>smb://192.168.1.109/xbmc/mediasources.xml</to>
     </substitute>
	 <substitute>
      <from>special://profile/RssFeeds.xml</from>
      <to>smb://192.168.1.109/xbmc/RssFeeds.xml</to>
     </substitute>
	 <substitute>
      <from>special://profile/favourites.xml</from>
      <to>smb://192.168.1.109/xbmc/favourites.xml</to>
     </substitute>
    </pathsubstitution>
</advancedsettings>
 

dkplayaclub

New member
Sep 14, 2012
472
0
0
Rochester, NY
OK. I tried following the guide on the wiki, but no good news here. Once I add the advancedsettings.xml file none of my boxes will boot XBMC. The logo comes up like XBMC is loading, but just freezes and eventually I'm told it's not responding. Removig the advancedsettings.xml file seems to fix it.

Just using the basic .xml listed in the guide on the wiki :

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>

<videolibrary>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
</advancedsettings>

EDIT - yes I remembered to put my IP address in
 

photoplay

New member
Sep 18, 2012
112
0
0
Make sure you allow/make exception for port 3306 on any firewall or similar program on you computer.
 

dkplayaclub

New member
Sep 14, 2012
472
0
0
Rochester, NY
OK. The firewall was not the issue. Apparently, my router reset itself at some point and the internal IP addresses had all been changed. Once I changed the IP addresses in the advancedsettings.xml file XBMC loaded up just fine.
I am now importing the libraries again. I will let you know how it works.
 

dkplayaclub

New member
Sep 14, 2012
472
0
0
Rochester, NY
OK. No dice. I decided to start fresh with the library. I removed all video sources from all boxes, then after adding the advancedsettings.xml to the profile folder of each device, I added all directories to my main PC in the den (my sever) and rebooted all boxes.
None of the machines other than the server PC have anything in the libraries. The guide on the wiki is out of date and the instructions can only be semi-followed (as far as setting up MySQL at least). I am thinking that my issue is the settings of each box (2 Ouyas and one other PC) as clients to MySQL server. The guide on the wiki doesn't really explain this. Any help would be appreciated.
 

photoplay

New member
Sep 18, 2012
112
0
0
None of the machines other than the server PC have anything in the libraries.
MySql is only installed and run on one machine but all get the new advancedsettings.xml

Users are reporting issues with MySQL 5.6. Use MySQL 5.5 instead...according to Wiki

Your advancedsettings.xml in post #3 is correct provided you replaced the *** with your correct ip address as you indicated.

Make sure your advancedsettings.xml is in the correct location on each machine(Don't know location for OUYA):

Windows XP – C:\Documents and Settings\[username]\Application Data\XBMC\
Windows 7/Vista – C:\Users\[username]\AppData\Roaming\XBMC\
Linux/XBMC Live – $HOME/.xbmc/userdata
Mac OS X – /Users/[username]/Library/Application Support/XBMC/userdata

On the other machines that are not showing anything, go into the context menu and "Set Content" again for each source you imported and they should show up as a library scan will start.



This other guide might be helpful: http://www.howtogeek.com/75535/how-to-sync-your-media-across-your-entire-house-with-xbmc/

Also:http://lifehacker.com/5634515/how-to-synchronize-your-xbmc-media-center-across-every-room-in-the-house
 
Last edited: