Posts: 1
Joined: Mar 2012
Reputation:
0
I followed the wiki guide (not the lifehacker one) and it all seemed go fine. However, now it says I have 87 TV shows (correct) but 0 episodes. It only sees 2 of about 150 movies. The art is still all there seemingly because the screensaver shows them all (not sure if that means anything). I went in to each source and edited it to tell it what is there (movies, tv shows, etc.) and everything LOOKS right.
I have stripped and reloaded MySQL and done the set up twice. What have I missed? What further information could I provide you to assist in helping me?
Posts: 1
Joined: Mar 2012
Reputation:
0
Installed v11 + MySQL on my server (atom via remote desktop) and installed v11 on my desktop linking to my server (movies, info & fan art/thumbnails).
Now I notice 2 problems after I run XMBC on my desktop
- The set content settings are not remembered for both my series and movies, both show NONE, after saving the setting over and over again.This issues also causes that the library is not scanned on start-up (on my DT).
- Most likely related; after I rightclick on a movie I cannot rescan it (or manual) to make sure the right fanart is linked to it.
To be 100% clear; XBMC on my server is not running (I suppose this is not needed).
Does anybody have a solution?
Posts: 5
Joined: Mar 2012
Reputation:
0
Ok, very easy to follow instructions thanks!
My concern is that my server isn't on all the time, I use the Advanced WOL plugin to wake my server when I start XBMC. How does the syncing work if the server isn't on or if the server isn't immediatly available. Will XBMC freeze or will it just wait until the MySQL database is available and then sync.
In otherwords, is all the info stored locally and synced via MySQL or is it only stored on MySQL.
Thanks
Posts: 21
Joined: Apr 2012
Reputation:
0
I can't get this working either. Everything is correct in xbmc but it's just not populating mysql databases. Help needed.
| Cooler Master MasterCase Maker 5 | Gigabyte Aorus X299 Ultra Gaming Motherboard | Intel Core i7 [email protected] | Corsair Vengence 16GB x 2 Ram | Samsung SSD 960 PRO 512GB M.2 |
| Western Digital 1TB HDD | HGST Ultrastar 4TB HDD | Gigabyte GeForce GTX 950 Extreme | Ubuntu 20.04 x86_64 | Windows 10 Pro 1909 |
Posts: 279
Joined: Dec 2010
Reputation:
1
Finchy
Senior Member
Posts: 279
Nah, I couldn't get it working either. Spent ages following the guides to the letter. It just won't work. I've tried it with MySQL on both Windows Home Server and a Qnap NAS drive but neither work. I got close; one of my PCs connected at one stage but the ATV never did, and as soon as I upgraded from XBMC 10 it wouldn't work again.
Posts: 225
Joined: Sep 2008
Reputation:
0
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.
Posts: 21
Joined: Apr 2012
Reputation:
0
2012-04-04, 15:48
(This post was last modified: 2012-04-04, 15:52 by thothom.)
I got it working w/o xbmc_video and xbmc_music schema, then I added the schema and the same thing happenes, the database does not get populated so I am unable to ad indexes. And when I try to bind my address to my local ip address I get a access denied, permissons error.
| Cooler Master MasterCase Maker 5 | Gigabyte Aorus X299 Ultra Gaming Motherboard | Intel Core i7 [email protected] | Corsair Vengence 16GB x 2 Ram | Samsung SSD 960 PRO 512GB M.2 |
| Western Digital 1TB HDD | HGST Ultrastar 4TB HDD | Gigabyte GeForce GTX 950 Extreme | Ubuntu 20.04 x86_64 | Windows 10 Pro 1909 |
Posts: 126
Joined: May 2011
Reputation:
0
noner
Senior Member
Posts: 126
2012-04-04, 20:55
(This post was last modified: 2012-04-05, 01:40 by noner.)
Aside from firewall, MySQL user also needs permission to connect FROM the host XBMC is running on. If the user only has permission to connect from PC1, you cant use the same settings to connect from PC2
select user, host from mysql.user
will confirm for you if the user has permission to connect from a specific host
In my setup notice the "%" in the host column, which means that the user xbmc is allowed to connect from any host. If I wanted xbmc only to be able to connect from my internal network, the host value would show '192.168.0.%' which would mean any ip address that begins with 192.168.0
+------+-----------+
| user | host |
+------+-----------+
| xbmc | % |
Posts: 21
Joined: Apr 2012
Reputation:
0
2012-04-05, 18:41
(This post was last modified: 2012-04-05, 18:44 by thothom.)
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?
| Cooler Master MasterCase Maker 5 | Gigabyte Aorus X299 Ultra Gaming Motherboard | Intel Core i7 [email protected] | Corsair Vengence 16GB x 2 Ram | Samsung SSD 960 PRO 512GB M.2 |
| Western Digital 1TB HDD | HGST Ultrastar 4TB HDD | Gigabyte GeForce GTX 950 Extreme | Ubuntu 20.04 x86_64 | Windows 10 Pro 1909 |