+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Announcements, Info, and General Discussion (/forumdisplay.php?fid=85)
+--- Forum: Tips, tricks, and step by step guides (/forumdisplay.php?fid=110)
+--- Thread: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker (/showthread.php?tid=80829)
- rcloud - 2011-11-05 00:42
I was having problems getting this to work with nightly builds, but after messing around with it I figured out a way to get it to work.
I removed <name>xbmc_video</name> and <name>xbmc_music</name> from the advancedsettings.xml and just let xbmc create the databases.
So I ended up with MyVideos57.db, MyVideos34.db and MyMusic18.db.
Next, instead of just creating user 'xbmc' like the it says in the Wiki, I had to create a unique user for each computer and then grant privileges for each database.... So:
CREATE USER xbmc@nameofcomputer IDENTIFIED BY 'xbmc';
GRANT ALL PRIVILEGES ON MyVideos57.* TO xbmc@'%';
GRANT ALL PRIVILEGES ON MyVideos34.* TO xbmc@'%';
GRANT ALL PRIVILEGES ON MyMusic18.* TO xbmc@'%';
This worked for me so hopefully it will help others like myself who have no MySQL experience.
- devilshaven - 2011-11-05 19:45
won't this create redundant databases? any one know of a way to fix nightly builds not to look for the numbered databases and just use 1, just like the final version?
- Ray_N - 2011-11-06 04:10
devilshaven Wrote:won't this create redundant databases? any one know of a way to fix nightly builds not to look for the numbered databases and just use 1, just like the final version?
Call me crazy but, aren't "Nightly Builds" not to be used by everybody? Meaning, they are not final stable versions?...I believe it specifically states in the page:
---------------------------------------------------------------------
Nightly Builds
Only for the brave. You should expect breakage when running these builds.
WARNING: Nightly builds will update your libraries to a version that is not backwards-compatible with stable releases. Backup first!
---------------------------------------------------------------------
So it seems to me, if you want it to work better, stay with the stable releases...Anyway, if you attempt to band-aid it and force it to work, you may end up having to redo work once the next release or update or nightly build comes along. And you may just want to save yourself some unnecessary frustration...just my $0.02.
r
- rcloud - 2011-11-06 05:48
Ray, what would be the fun in that
- Finchy - 2011-11-10 10:16
I'm trying to sync using MySQL on my Windows Home Server 2011. It seemed to be fine until I drop in the advancedsettings.XML file and run XBMC, at which point it just hangs. Do I need to set any specific folder permissions on the home server's video and music folders to allow MySQL access? Or create a specific user for MySQL in whs? I've tried it on my laptop and media pc (both win 7) but both have stumbled at the same point.
I'm still on 10.1 btw.
- jwdv22 - 2011-11-10 16:07
What are the clients that are trying to connect? My OpenElec client was hanging trying to connect to Win7 server with MySQL when I had the user pass incorrect.
I also got mine to work but downloading the recent nightlies, and removing the xbmc_videos and xbmc_music names from as.xml
- dsimages - 2011-11-10 22:46
Finchy Wrote:I'm trying to sync using MySQL on my Windows Home Server 2011. It seemed to be fine until I drop in the advancedsettings.XML file and run XBMC, at which point it just hangs. Do I need to set any specific folder permissions on the home server's video and music folders to allow MySQL access? Or create a specific user for MySQL in whs? I've tried it on my laptop and media pc (both win 7) but both have stumbled at the same point.
I'm still on 10.1 btw.
this is what i did to get mine working.... Im on openelec though. I believe its dharma 10.1
You need to make sure your firewall has whatever port your using open, then flush privledges on the mysql, then grant all on.
http://openelec.tv/forum/14-general-help-and-support/15344-mysql-not-working
- Finchy - 2011-11-11 00:20
dsimages Wrote:this is what i did to get mine working.... Im on openelec though. I believe its dharma 10.1
You need to make sure your firewall has whatever port your using open, then flush privledges on the mysql, then grant all on.
http://openelec.tv/forum/14-general-help-and-support/15344-mysql-not-working
Thanks, I'll give that a go. I just tried connecting SQLyog to the MySQL server and that couldn't connect, so I suspect my first problem is permissions. I'll have a read through your thread when the other half gets off the laptop!
- Darkcloud - 2011-11-13 09:49
I tried it and with the nightly it didn't work he just ignored the advancedsetings to use mysq. With the latest stable he accepts it but for some reason doesn't seem to be able to write to the databases and because of that they stay empty.
- Klyde - 2011-11-13 23:07
I'm running into a little issue hopefully someone can help me with.
Got it configured between 2 PC's with the synced library. They both see the same library, but for some reason neither side can mark episodes or movies as watched? I figured its a file permission issue but reapplied the commands in mysql but it didn't help. Any suggestions?
Another issue I'm not sure if related, but since I re imported my library I'm missing a bunch of movies and when I rescan the sources it briefly does but nothing happens