HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker

noner · 2012-04-07 20:33

Also for people struggling with this (and assuming you are not using separate databases for separate profiles)

As of Eden, you no longer need to either create the databases in MySQL or specify them in advancedsettings, XBMC will do that for you automatically. Just ensure that you grant permission for the MySQL 'xbmc' user to create databases and allow the user to connect from all hosts

As the MySQL root user, DO execute this:

Code:

grant all on *.* to 'xbmc'@'%' identified by 'xbmc';

DONT do this any more in MySQL:

Code:

create database xbmc_video;

create database xbmc_music;

In advancedsettings.xml, DONT put in the following lines:

Code:

<name>xbmc_video</name>

<name>xbmc_music</name>

To clarify further, your advancedsettings.xml should just look like this for the MySQL sections (for path substitutions or anything else you require you still need to add that in there in addition to whats below for the MySQL portion)

Code:

<videodatabase>

<type>mysql</type>

<host>IP_OF_YOUR_MYSQL_SERVER</host>

<user>xbmc</user>

<pass>xbmc</pass>

</videodatabase>

<musicdatabase>

<type>mysql</type>

<host>IP_OF_YOUR_MYSQL_SERVER</host>

<user>xbmc</user>

<pass>xbmc</pass>

</musicdatabase>

Eden will create everything for you

noner · 2012-04-07 20:43

(2012-04-07 20:31)Finchy Wrote: Ah, thanks. That has let me access it locally in SQLyog as root and allow priveledges for XBMC on xbmc_video and _audio. I still can't access remotely from my laptop though. Any ideas? SQLyog gets a "2003 error - cannot connect to MySQL server on 192.168.1.4 (10600)"

This is likely a firewall issue, ensure you have port 3306 open on both your laptop and on the server you are running MySQL on (assuming you did not change the default port that MySQL listens to)

Also, in your MySQL config file, ensure you dont have the following variables assigned - if you do, just get rid of them

Code:

bind-address

skip_networking

Finchy · 2012-04-07 20:54

3306 is definately open in the firewall on both the WHS and the laptop, as TCP. Is that correct?

I don't have those two variables in my ini so that's ok.

Hmmm. Or maybe not. I just disabled the firewall on the WHS and I can connect. Strange. There's definately a rule for both in and out allowing 3306.

noner · 2012-04-07 21:09

(2012-04-07 20:54)Finchy Wrote: 3306 is definately open in the firewall on both the WHS and the laptop, as TCP. Is that correct?

I don't have those two variables in my ini so that's ok.
Hmmm. Or maybe not. I just disabled the firewall on the WHS and I can connect. Strange. There's definately a rule for both in and out allowing 3306.

Try both TCP and UDP 3306. If Memory serves me it should only require TCP.

Are you sure its running on 3306?

Finchy · 2012-04-07 21:27

Yes, deffo 3306 as the local SQLyog connects to it fine on that port. So create a second UDP rule for in and out, 3306?

Crap, that didn't work.

It's the Private Profile of the firewall. When I disable it completely in the WHS, or change inbound connects on private to allow it can connect from my laptop.

Finchy · 2012-04-07 21:49

Ah, got the rules working now. I can connect from my laptop (thank F for that!)

So should I delete the xbmc_video and _audio tables to let Eden recreate them, and use the advanced settings layouts you've mentioned above?

Thanks, BTW! Smile

noner · 2012-04-07 21:57

(2012-04-07 21:49)Finchy Wrote: Ah, got the rules working now. I can connect from my laptop (thank F for that!)

So should I delete the xbmc_video and _audio tables to let Eden recreate them, and use the advanced settings layouts you've mentioned above?

Thanks, BTW!

No problem

Yep, unless you are planning on using multiple MySQL db's for multiple profiles, its easier to just let XBMC manage the db's

You can leave the db's in MySQL, and just remove them from your advanced settings, and when XBMC starts up for the first time, it will create the video and music databases (which in Eden Final are called MyVideos60 and MyMusic18) and going forward when you need to upgrade XBMC, if required it will make copies of those db's and upgrade the copy

Also, maybe post your solution for the firewall issue in case someone else is struggling with it and it may help them

Finchy · 2012-04-08 12:04

Well, it wasn't so much a solution as deleting the ones I had created and creating new ones for in and outbound. So just New Rule>Port>TCP, 3306>Allow>Private>Name of rule>Finish

The rules I did have in there were previously created by the MySQL installation, and I'd been changing the settings within the rules to try to get them to open up properly. It was through disabling all parts of the firewall (domain, private and public) and gradually enabling them that I worked out that the rules I had in there were not working, so I deleted them and re-created them as above.

I'm hoping that all the problems I've been having in trying to get it set up have been caused by this! Fingers crossed...! I suspect I'll be back soon....!

Finchy · 2012-04-08 12:49

Back already! Big Grin

So with the advanced settings file, should I use this;

Code:

<advancedsettings>

    <videodatabase>

    <type>mysql</type>

    <host>192.168.1.4</host>

    <user>xbmc</user>

    <pass>xbmc</pass>

    </videodatabase>

    <musicdatabase>

    <type>mysql</type>

    <host>192.168.1.4</host>

    <user>xbmc</user>

    <pass>xbmc</pass>

    </musicdatabase>

<pathsubstitution>

  <substitute>

    <from>special://masterprofile/Thumbnails/</from>

    <to>smb://XBMCUser:password@192.168.1.4/XBMCthumbnails/</to>

  </substitute>

</pathsubstitution>

</advancedsettings>

The IP of the WHS/SQL server is 192.168.1.4, and I created a Windows user on the WHS called XBMCUser to have permissions to access the shares?

I'm going to do it from the ATV first as that seems to be more temperamental, so if I let that create the database and xml files I can then do the other PC later?

Finchy · 2012-04-08 14:17

To carry that further, if I want to sync the other options as well (other than add-ons);

Code:

<advancedsettings>

    <videodatabase>

    <type>mysql</type>

    <host>192.168.1.4</host>

    <port>3306</port>

    <user>xbmc</user>

    <pass>xbmc</pass>

    </videodatabase>

    <musicdatabase>

    <type>mysql</type>

    <host>192.168.1.4</host>

    <port>3306</port>

    <user>xbmc</user>

    <pass>xbmc</pass>

    </musicdatabase>

<pathsubstitution>

  <substitute>

    <from>special://masterprofile/Thumbnails/</from>

    <to>smb://XBMCUser:password@192.168.1.4XBMCthumbnails/</to>

  </substitute>

  <substitute>

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

    <to>smb://XBMCUser:password@192.168.1.4/XBMC-XML-Files/sources.xml</to>

  </substitute>

  <substitute>

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

    <to>smb://XBMCUser:password@192.168.1.4/XBMC-XML-Files/mediasources.xml</to>

  </substitute>

  <substitute>

    <from>special://masterprofile/playlists/</from>

    <to>smb://XBMCUser:password@192.168.1.4/XBMC-XML-Files/Playlists/</to>

  </substitute>

  <substitute>

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

    <to>smb://XBMCUser:password@192.168.1.4/XBMC-XML-Files/favourites.xml</to>

  </substitute>

  <substitute>

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

    <to>smb://XBMCUser:password@192.168.1.4/XBMC-XML-Files/RssFeeds.xml</to>

  </substitute>

</pathsubstitution>

</advancedsettings>

Should that then create the sources.xml, favourites.xml, etc as the paths and favourites, etc are added, so if I then add the same advancedsettings.xml to the other devices they should be the same?

Finchy Senior Member Posts: 154 Joined: Dec 2010 Reputation: 0	2012-04-07 21:27 Post: #395 Yes, deffo 3306 as the local SQLyog connects to it fine on that port. So create a second UDP rule for in and out, 3306? Crap, that didn't work. It's the Private Profile of the firewall. When I disable it completely in the WHS, or change inbound connects on private to allow it can connect from my laptop.
	find

Finchy Senior Member Posts: 154 Joined: Dec 2010 Reputation: 0	2012-04-07 21:49 Post: #396 Ah, got the rules working now. I can connect from my laptop (thank F for that!) So should I delete the xbmc_video and _audio tables to let Eden recreate them, and use the advanced settings layouts you've mentioned above? Thanks, BTW!
	find