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

Could you elaborate on that a little further?

Now I get this error:

for those who may need a little help i just finished getting my tv shows and movies sync's between two machines using a windows file server to manage the database i have also after a lot of trying got it to sync up the posters between the machines for both movies and tv shows i had trouble getting my head around the wiki instructions so worked it out myself and posted what i did here in more direct simple terms for those having the same problem hopefully it can help someone

i set mine up for two openelec htpc's so can't say for sure if it works with others but hopefully it does

http://forum.xbmc.org/showthread.php?tid...pid1067201


if you have any questions PM me not sure if i can answer most questions as i am far from expert on this it took me several hair pulling hours and constant trips up and down my house check each machine to get this right i posted to hopefully save someone else the same stress

(2012-04-05 16:39)thothom Wrote:  Now I get this error:

Code:

Host 'thomthom.my modem.my gateway' is not allowed to connect to this MySQL server.

In your my.cnf ensure you have

skip-name-resolve

On the mysql command line enter

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

Assuming the user is 'xbmc'

---

(2012-04-05 16:14)thothom Wrote:  

Code:

If the user only has permission to connect from PC1, you cant use the same settings to connect from PC2

Could you elaborate on that a little further?

MySQL has the ability to limit access based on hostname, ip address etc. Each record in the mysql.user table corresponds to what user can connect from what network address.

The MySQL wildcard character is "%"

If there is only one record in mysql.user that says the host is 192.168.0.10 (for example) that means connections are accepted from just that one ip address. If it says 127.0.0.1 that means only connections from the actual host MySQL is running on (localhost) are accepted. If the record says 192.168.0.% that means any ip beginning with 192.168.0 can connect. If the host is set just to "%" then it can connect from anywhere

You can check this by issuing the following at the mysql command prompt

select user, host from mysql.user;

Makes sense?

I created xbmc user and assigned 192.168.1.3, I am running myqsl on my desktop and have xbmc on it too, I also have xbmc running on the media pc in the living room so what I gather is that the single xbmc user will be sufficient for both pc's?

---

I would also like to sync up all settings, fanart, add-ons etc...would I need to put that in my advancedsettings.xml file?

(2012-04-05 18:41)thothom Wrote:  I created xbmc user and assigned 192.168.1.3, I am running myqsl on my desktop and have xbmc on it too, I also have xbmc running on the media pc in the living room so what I gather is that the single xbmc user will be sufficient for both pc's?

yep. just make sure that the user can connect from both pc's, in your case one connection will be from localhost and the other from your media pc in the living room

would I need to install mysql client on the media pc to check that?

(2012-04-05 17:57)noner Wrote:  

(2012-04-05 16:39)thothom Wrote:  Now I get this error:

Code:

Host 'thomthom.my modem.my gateway' is not allowed to connect to this MySQL server.

In your my.cnf ensure you have

skip-name-resolve

On the mysql command line enter

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

Assuming the user is 'xbmc'

---

(2012-04-05 16:14)thothom Wrote:  

Code:

If the user only has permission to connect from PC1, you cant use the same settings to connect from PC2

Could you elaborate on that a little further?

MySQL has the ability to limit access based on hostname, ip address etc. Each record in the mysql.user table corresponds to what user can connect from what network address.

The MySQL wildcard character is "%"

If there is only one record in mysql.user that says the host is 192.168.0.10 (for example) that means connections are accepted from just that one ip address. If it says 127.0.0.1 that means only connections from the actual host MySQL is running on (localhost) are accepted. If the record says 192.168.0.% that means any ip beginning with 192.168.0 can connect. If the host is set just to "%" then it can connect from anywhere

You can check this by issuing the following at the mysql command prompt

select user, host from mysql.user;

Makes sense?

Worked like a charm, thanks a million.

I have another problem. When I pause a movie in my room to go watch in the living room it doesn't work. Do I need to create a user for connections from the media pc?

UDATE

I have it working, it's a little slow but it's working. Any way you know of to speed up the database?

My my.ini file.

Where'd you get those settings from? They seem pretty off to me. A setting being in the file will override the default. My personal opinion (others here may disagree with me:

Remove the following form the file and let MySQL manage them based on defaults:


Adjust the following:


See if that helps with performance