+- 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)
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - Finchy - 2012-04-06 18:04
(2012-04-04 04:04)kri kri Wrote: Did you guys follow the Mysql wiki? This lifehacker guide is out of date. If it doesn't work disable your firewalls and check again.
Yes, I followed the wiki guides. I tried it on WHS 2011 and my QNap NAS but neither would work. I disabled the firewall in WHS and it still didn't work.
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - noner - 2012-04-06 19:27
(2012-04-06 18:04)Finchy Wrote:(2012-04-04 04:04)kri kri Wrote: Did you guys follow the Mysql wiki? This lifehacker guide is out of date. If it doesn't work disable your firewalls and check again.
Yes, I followed the wiki guides. I tried it on WHS 2011 and my QNap NAS but neither would work. I disabled the firewall in WHS and it still didn't work.
At what specifically is it not working, if you could provide more information to the issue you are having then maybe someone would be able to point you in the right direction?
The MySQL setup works well and once you tune your setup, provided your MySQL install is running on capable hardware and your network is fast enough, performs just as well as having everything locally, there are just a few nuances you need to be aware of, permissions being one of them - and this is an area that the wiki does not touch on
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - Finchy - 2012-04-06 21:11
Yes, I think permissions is one of the things I'm struggling with. I've tried loads of times now - uninstalling and reinstalling (removing all files in the process), tried the WPI version of MySQL, the latest 64 bit, tried using the standard installation (which doesn't open the firewall ports), customised installs.
I can usually connect locally and remotely using SQLyog and see the databases, but can't change user permissions in it, even when connected locally as root.
I had created a user for the WHS with folder access and the XBMC one for MySQL (as it feels a bit wrong having the same username and password for a Windows and SQL user and having the password as plain text in an XML file!) but the Windows XBMC user definately has file/folder permissions.
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - Finchy - 2012-04-06 22:07
...for example, when I try
mysqlcheck -op -u xbmc xbmc_video
in the command prompt on the WHS with MySQL Server installed I get a 1045 error.
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - noner - 2012-04-06 23:57
(2012-04-06 22:07)Finchy Wrote: ...for example, when I try
mysqlcheck -op -u xbmc xbmc_video
in the command prompt on the WHS with MySQL Server installed I get a 1045 error.
mysqlcheck -uuser -ppassword --optimize xbmc_video
Try it without spaces between -u and user name, and no spaces between -p and password
From the MySQL man page
Quote:The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the
option and the password. If you omit the password value following the --password or -p option on the command line, mysqlcheck
prompts for one.
Specifying a password on the command line should be considered insecure. See Section 5.3.2.2, âEnd-User Guidelines for Password
Security
For other users struggling with permissions maybe an idea is to begin with granting all permissions both within MySQL as well as SMB for the folder access, and then one by one take permissions away, that way you can narrow down where you are running into an issue
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - PeterUK - 2012-04-07 11:29
Hello lads, after a number of retrys and a lot of faffing around I've managed to get my WIndows and Openelec XBMC's syncing.
Hooray!
However I can sync my fanart etc for the main profile but not for my second one as I'm not sure what to replace the coding in advancedsettings wtih:
<from>special://masterprofile/Thumbnails/</from>
If I had a profile called Sofia should this just be changed to:
<from>profiles/sofia/Thumbnails/</from>
Thanks for any help
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - Finchy - 2012-04-07 15:51
OK, so thid is the process I have used;
Pre installation;
Network shares on WHS for the media folders set up, read/write access given to all relevant users and Homegroup users. Control checked by creating and deleting dummy files form another PC on the LAN.
Network share set up for XBMCthumbs with full read/write permissions.
MySQL installation;
Installed MySQL on WHS2011 via the Windows WPI installer (MySQL v 5.1)
Ran the config with standard installtion, set admin password, did not tick 'allow root access from remote machines'.
Added "skip-name-resolve" to the Mysqld section of the 'my.ini' file.
Changed the MySQL service to log on with the local administrator, stopped and restarted the service.
Added incoming and outgoing firewall access rules for port 3306 for domain and private connections.
MySQL XBMC setup;
Open up MySQL command line client and created the xbmc user and DB;
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
CREATE database xbmc_video;
CREATE database xbmc_music;
GRANT ALL ON *.* TO 'xbmc';
At this point should I not be able to test the MySQL DB from another PC on the network for connection? I'm trying to connect with SQLyog and MySQL Workbench from my laptop using the IP and XBMC username/password but it's not connecting. I can however connect to it from SQLyog on the WHS as both root and XBMC, but when I check the user priveledges in there it doesn't have any for XBMC on the xbmc_video or xbmc_music databases, and if I try to add them it gives me a 1044 error.
Do I need to do anything else to the settings/priveledges in MySQL, and if so, how?
Also, for clarification, I have an ATV2 and a Windows 7 PC that I want to connect to the SQL server, although I'm looking at installing XBMCbuntu on the Win 7 PC. Do I need to open the firewall for the Win 7 client as well?
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - noner - 2012-04-07 19:58
(2012-04-07 15:51)Finchy Wrote: OK, so thid is the process I have used;
Pre installation;
Network shares on WHS for the media folders set up, read/write access given to all relevant users and Homegroup users. Control checked by creating and deleting dummy files form another PC on the LAN.
Network share set up for XBMCthumbs with full read/write permissions.
MySQL installation;
Installed MySQL on WHS2011 via the Windows WPI installer (MySQL v 5.1)
Ran the config with standard installtion, set admin password, did not tick 'allow root access from remote machines'.
Added "skip-name-resolve" to the Mysqld section of the 'my.ini' file.
Changed the MySQL service to log on with the local administrator, stopped and restarted the service.
Added incoming and outgoing firewall access rules for port 3306 for domain and private connections.
MySQL XBMC setup;
Open up MySQL command line client and created the xbmc user and DB;
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
CREATE database xbmc_video;
CREATE database xbmc_music;
GRANT ALL ON *.* TO 'xbmc';
At this point should I not be able to test the MySQL DB from another PC on the network for connection? I'm trying to connect with SQLyog and MySQL Workbench from my laptop using the IP and XBMC username/password but it's not connecting. I can however connect to it from SQLyog on the WHS as both root and XBMC, but when I check the user priveledges in there it doesn't have any for XBMC on the xbmc_video or xbmc_music databases, and if I try to add them it gives me a 1044 error.
Do I need to do anything else to the settings/priveledges in MySQL, and if so, how?
Also, for clarification, I have an ATV2 and a Windows 7 PC that I want to connect to the SQL server, although I'm looking at installing XBMCbuntu on the Win 7 PC. Do I need to open the firewall for the Win 7 client as well?
Try running this as root:
grant all on *.* to 'xbmc'@'%' identified by 'yourpassword';
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - noner - 2012-04-07 20:16
(2012-04-07 11:29)PeterUK Wrote: Hello lads, after a number of retrys and a lot of faffing around I've managed to get my WIndows and Openelec XBMC's syncing.
Hooray!
However I can sync my fanart etc for the main profile but not for my second one as I'm not sure what to replace the coding in advancedsettings wtih:
<from>special://masterprofile/Thumbnails/</from>
If I had a profile called Sofia should this just be changed to:
<from>profiles/sofia/Thumbnails/</from>
Thanks for any help
I would try
<from>special://Sofia/Thumbnails/</from>
But just FYI I have not done profiles so I could be wrong. Maybe someone with experience with profiles could guide you if the above does not work
RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - Finchy - 2012-04-07 20:31
(2012-04-07 19:58)noner Wrote: Try running this as root:
grant all on *.* to 'xbmc'@'%' identified by 'yourpassword';
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)"