HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: Tips, tricks, and step by step guides (https://forum.kodi.tv/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 - noner - 2012-04-05 (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 RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - thothom - 2012-04-05 would I need to install mysql client on the media pc to check that? RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - thothom - 2012-04-05 (2012-04-05, 17:57)noner Wrote:(2012-04-05, 16:39)thothom Wrote: Now I get this error: Worked like a charm, thanks a million. RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - thothom - 2012-04-05 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. Code: innodb_thread_concurrency=9 RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - noner - 2012-04-06 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: Code: net_buffer_length = 16384 Adjust the following: Code: query_cache_limit=2M See if that helps with performance RE: HOW-TO synchronize your XBMC Media Center between every room in the house: Lifehacker - Finchy - 2012-04-06 (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 (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. 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 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 ...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 (2012-04-06, 22:07)Finchy Wrote: ...for example, when I try 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 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 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 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 (2012-04-07, 15:51)Finchy Wrote: OK, so thid is the process I have used; 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 (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. 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 (2012-04-07, 19:58)noner Wrote: Try running this as root: 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)" |