Hey guys, I've recently set up my first XBMC application on my Windows 7 machine and thought that I might give remote syncing a try with MySQL.
I've followed the guides and have gotten the xbmc_video60 to populate from my SMB shares, however I can't get the xbmc_music18 to populate with list of songs, etc.
I've removed the <name> tags like some threads have said, but yet XBMC is only creating the database with the tables, yet not filling in those tables. I've removed the sources and added them again, as well as forcing an import of the library, yet no use.
I haven't set up my remote PC yet, as I want to get the MySQL looking good before I start that up. Is there any way I could get this DB populated?
Right clicking my source > Scanning into library worked! Thanks for the help!
Sorry for bumping, but I now have the SQL server set up and running and also have XBMCBuntu installed on a flash drive.
Now that I have them ready to do, after copying over my advancedsettings.xml and setting up samba, what should I expect to see when updating the library? Do I have to add my shared samba sources where the files are, or will they populate by themselves from the SQL server? What will I notice? I did the above and didn't see anything but a default XBMC install, so decided to map my sources from my server, was I wrong in doing this?
You need to make the same sources on all clients if you want to be able to scrape from them. The sources need to formatted in such a way that they are the same at all clients because the path is stored in the database and needs to be directly accessible from all.
You should see the library from the clients if the sql database access is setup properly in the advancedsettings.xml
Well I'm not sure what this means.
What do I need to do first exactly? Should I set my scraper to not grab from movie databases and such, just to make sure it only pulls from the SQL database? When I added my movie source it didn't bring over any thumbnails or information. I forced the library to sync up, yet nothing but a list of movies are here.
Are there any preferred settings I have to enable? Any process at which I should go about doing things?
You should only need the advancedsettings.xml file to actually see and share the library. If you want to update the library from any of the devices then you need to set up sources using the same exact file path on each machine. An easy way to do this is to just copy sources.xml between each XBMC box.
I assume you've seen our own
MySQL (wiki) guide regarding this?
Yes sir. I went to Music and selected 'Add Source..." and then selected my Samba folder of 'Music', and then the same for 'Movies', however the thumbnails aren't loading unless I add an IMDB/TMDB scraper. I did add a thumbnail folder substitution as well.
What exactly does the advancedsettings.xml do, add the information of the file to match what is in the MySQL database?
EDIT: I cleared all of my libraries and copied over sources.xml, which looks to have added the movies/music, however no thumbnails or information are being brought. I went back and inserted my username and password for the server onto my Samba URLs, yet still no progress. The XMBCBuntu logs show the thumbnail retriever starting and stopping in 00 seconds, but I'm not seeing any blatant errors.
Can you paste a copy of your debug log to pastebin and link it here?
Your advancedsettings.xml file is messed up.
It shows
Code:
<advancedsettings>
<useddsfanart>true</useddsfanart>
<cputempcommand>cputemp</cputempcommand>
<gputempcommand>gputemp</gputempcommand>
<samba>
<clienttimeout>30</clienttimeout>
</samba>
<network>
<disableipv6>true</disableipv6>
</network>
</advancedsettings>
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.78</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.78</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails/Video/</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/Thumbnails/Video/</to>
</substitute>
<substitute>
<from>special://masterprofile/Thumbnails/Music/</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/Thumbnails/Music/</to>
</substitute>
</pathsubstitution>
<substitute>
<from>special://masterprofile/playlists/</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/playlists/</to>
</substitute>
<substitute>
<from>special://masterprofile/addon_data/</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/addon_data/</to>
</substitute>
<substitute>
<from>special://masterprofile/sources.xml</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/sources.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/mediasources.xml</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/mediasources.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/RssFeeds.xml</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/RssFeeds.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/favourites.xml</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/favourites.xml</to>
</substitute>
when it should be this instead:
Code:
<advancedsettings>
<useddsfanart>true</useddsfanart>
<cputempcommand>cputemp</cputempcommand>
<gputempcommand>gputemp</gputempcommand>
<samba>
<clienttimeout>30</clienttimeout>
</samba>
<network>
<disableipv6>true</disableipv6>
</network>
<videodatabase>
<type>mysql</type>
<host>192.168.1.78</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.78</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails/Video/</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/Thumbnails/Video/</to>
</substitute>
<substitute>
<from>special://masterprofile/Thumbnails/Music/</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/Thumbnails/Music/</to>
</substitute>
<substitute>
<from>special://masterprofile/playlists/</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/playlists/</to>
</substitute>
<substitute>
<from>special://masterprofile/addon_data/</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/addon_data/</to>
</substitute>
<substitute>
<from>special://masterprofile/sources.xml</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/sources.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/mediasources.xml</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/mediasources.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/RssFeeds.xml</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/RssFeeds.xml</to>
</substitute>
<substitute>
<from>special://masterprofile/favourites.xml</from>
<to>smb://Darke:mypassword@DARKE-PC/xbmc/userdata/favourites.xml</to>
</substitute>
</pathsubstitution>
</advancedsettings>
I'm not seeing any errors, but I'm not expert. Any luck?
(2012-07-22, 23:22)Darkeligos Wrote: [ -> ]I'm not seeing any errors, but I'm not expert. Any luck?
Did you change your advancedsettings.xml file to what I said it should be?
Sorry I didn't see your post.
I changed the advancedsettings.xml file and now though it is loading the thumbnails (only after hitting 'i'), no movie information is showing up as well as it is being unbearably slow to load the images. I noticed that the log file had quite a few errors relating to permissions being denied, so I tried running 'sudo xbmc' with no change.
http://pastebin.com/R9RCRTK4
The permissions error seem to be with the SMB server. I would make double check that the user has read and write access, as it looks like it only has read access.