+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)
- charrua - 2010-04-22 04:17
WisdomWolf Wrote:I am going to look into this when I get home. Previously I had been using Sugarsync to sync the Database folder as well as the Thumnail folder. I would assume (if the thumbnail/coverart issue still exists) that the MySQL route + Sugarsync for the Thumbnail directory would work a bit more elegantly than my current solution. Am I correct?Yes, I believe you are correct.
Also be aware that there is another temporary solution for the thumbnail cache, originally suggested by MrDVD: symlinking a network shared folder as a common central cache, that way you don't even have to use Sugarsync for syncing thumbnails. The only cons I've found so far with that approach is that XBMC GUI speed suffers a little (at least in my tests) compared to XBMC using a local image cache, and the other issue is that if you loose connection to the network shared cache folder XBMC won't be able to show any poster, fanart, etc. Other than that is a very good temporary solution.
- RockDawg - 2010-04-22 05:22
I'm trying to implement this and I'm a little stumped. I keep getting the following error in my log:
Code:
22:56:35 T:3077834640 M:1480773632 DEBUG: CDatabase: Connecting to database xbmc_video at 192.168.1.8:3306
22:59:44 T:3077834640 M:1479913472 ERROR: Unable to open database:xbmc_video [2003](Can't connect to MySQL server on '192.168.1.8' (110))
22:59:44 T:3077834640 M:1479913472 ERROR: Unable to open database at host: 192.168.1.8 db: xbmc_video (old version?)I downloaded and installed MySQL. I set my advancedsettings.xml to the following:
Code:
<advancedsettings>
<videolibrary>
<cleanonupdate>true</cleanonupdate>
</videolibrary>
<videodatabase>
<type>mysql</type>
<host>192.168.1.8</host>
<port>3306</port>
<user>kevin</user>
<pass>tesla2232</pass>
<name>xbmc_video</name>
</videodatabase>
</advancedsettings>In MySQL I created the user 'kevin' with a password of 'tesla2232' and set permissions to full as demonstrated by:
Code:
mysql> SHOW GRANTS FOR kevin;
+-------------------------------------------------------------------------------
-----------------------+
| Grants for kevin@%
|
+-------------------------------------------------------------------------------
-----------------------+
| GRANT USAGE ON *.* TO 'kevin'@'%' IDENTIFIED BY PASSWORD '*FFCE64C407E518588E1
CF6800AD85B5617ACBD77' |
| GRANT ALL PRIVILEGES ON `xbmc_video`.* TO 'kevin'@'%'
|
+-------------------------------------------------------------------------------
-----------------------+
2 rows in set (0.00 sec)My server is running on a Win7 machine and my 2 XBMC boxes are different machines running XBMC Live r28256. Should MySQL server show an icon in the system tray when it's running?
- charrua - 2010-04-22 05:58
RockDawg Wrote:My server is running on a Win7 machine and my 2 XBMC boxes are different machines running XBMC Live r28256. Should MySQL server show an icon in the system tray when it's running?No, it doesn't show an icon in the system tray when it's running. You can only see the MySQL service running on the Services window of the win7 Administrative Tools.
Did you open port 3306 in the windows firewall?
- RockDawg - 2010-04-22 06:44
I can't believe I overlooked that. Thanks so much!
- RockDawg - 2010-04-22 06:58
charrua Wrote:First I copied the thumbnails folder inside userdata to the server, then I shared that path from the server, renamed the thumbnails folder inside userdata folder in the client machine to thumbnails.old (to avoid its deletion) and finally made a NTFS directory symbolic link pointing to the shared folder in my server with the command:
If you try it, please let me know if in your case it is also noticeable slower than the local cache. Anyway is not a bad option until the new cache system is in place.Code:
[b]mklink /D[/b] thumbnails [i]//SERVER_ADDRESS/shared_thumbnails_folder[/i]
I'm a little confused on this part. From what I read mklink is a Windows command. In my situation the server is Win but the clients are Linux. What would be the proper command?
- charrua - 2010-04-22 07:22
RockDawg Wrote:I can't believe I overlooked that. Thanks so much!You're very welcome.
RockDawg Wrote:I'm a little confused on this part. From what I read mklink is a Windows command. In my situation the server is Win but the clients are Linux. What would be the proper command?Yes, mklink is a windows command.
If you want to use the same server for hosting the MySQL db and the shared cache folder, then you should share the folder thumbnails inside the userdata folder of XBMC on your Win7 server and then create the symbolic link to that folder from the Linux clients running this command from the linux shell from inside the userdata folder of XBMC
Code:
ln -s [i]shared_cache_folder[/i] thumbnails- RockDawg - 2010-04-22 15:12
Thanks. I'll try that when I get home from work.
A strange thing I noticed was when I got XBMC using the db on the server. I tried to import my movies from the .xml file and I could see what looked like them scanning in, but when I woke up this morning and checked it out. XBMC acted as though there was no library. I figured I would go into files mode and set content and re-scan them in, but "exclude folder from scans" was checked and I couldn't uncheck it. I was leaving for work and didn't have much time to investigate, but does anyone have an idea what the problem could be?
- lestat1977uk - 2010-04-22 15:59
Thanks i have now managed to get it to work by using remote paths, so once i have my main video database all compiled, how do i keep all the Fanart, thumbs etc in sync?
i know there is some discussion on this including using remote cache paths (which i am keen to try) but what would you suggest being the easiest way?
Another quick question rather than use mysql can i use sql 2005 express or even sql 2008?
- charrua - 2010-04-22 18:53
RockDawg Wrote:Thanks. I'll try that when I get home from work.Do you have any local paths defined as media sources?
A strange thing I noticed was when I got XBMC using the db on the server. I tried to import my movies from the .xml file and I could see what looked like them scanning in, but when I woke up this morning and checked it out. XBMC acted as though there was no library. I figured I would go into files mode and set content and re-scan them in, but "exclude folder from scans" was checked and I couldn't uncheck it. I was leaving for work and didn't have much time to investigate, but does anyone have an idea what the problem could be?
lestat1977uk Wrote:Thanks i have now managed to get it to work by using remote paths, so once i have my main video database all compiled, how do i keep all the Fanart, thumbs etc in sync?If you don't mind a little lag while accesing the media lists and eventually having no posters and fanart displayed in XBMC if the connection to the machine hosting the shared cache folder is down, then I think the common network shared cache folder is the best option so far.
I know there is some discussion on this including using remote cache paths (which i am keen to try) but what would you suggest being the easiest way?
If you have a few XBMC clients, and your network is not too fast or reliable you may prefer to sync the cache folder between machines instead.
lestat1977uk Wrote:Another quick question rather than use mysql can i use sql 2005 express or even sql 2008?Currently no.
What about Drobo users? - joedeal - 2010-04-22 19:17
Anyone know if there is a app like MySQL for the Drobo that would work as well?