+- 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)
- Aslan2120 - 2010-05-04 07:02
I have been following this thread with great interest. It is a great setup and since I got it working yesterday it has been great. I have had 2 interesting things to add to the discussion.
The first interesting thing is in regards to the thumbs and fan art. I have 2 apple tvs and one windows 7 machine. All the media files are stored on a NAS and the database is on the windows 7 machine. When I update the library from the windows machine the thumbs and movie information is shoeing up on both apple tvs. I never created the sym link or anything, it just worked! I am not sure why but it did.
I posted the second issue already in another thread but in case anyone has any thoughts here I will repost here. Tonight "The Big Bang Theory" and "24" would not show up in the library. Ember scrapped them and this only happened to the new episodes from today. The old episodes that were existing before the move to mysql were added fine. Also "Castle" and "Chuck" were added fine. Any thoughts?
- Aslan2120 - 2010-05-04 08:34
Nevermind on the issue with the episodes. Not sure why but they seem to be added now.
- Cheeshead - 2010-05-05 21:18
Should the video database be clear after adding the settings to the advancedsettings.xml? Is there a way to tell inside XBMC or MySql that the database is being used? I don't notice any difference before/after.
Any help would be appreciated....thanks
- RockDawg - 2010-05-05 21:38
Did you rename the old database? If not, XBMC may continue to use it. Also, make sure you export your old db first. After setting up the new db, mine was empty and I had to import the old db from the file that was created when I exported the old one.
- Cheeshead - 2010-05-05 21:40
no i didn't rename old one....i cleared it out and rescraped all the info...I don't have a lot on my test box so it doesn't take long. i just don't see on the Mysql control panel that a xbmc db was created and the watched flags aren't synced.
- RockDawg - 2010-05-05 22:29
Cheeshead Wrote:no i didn't rename old one....i cleared it out and rescraped all the info...I don't have a lot on my test box so it doesn't take long.
OK. Same difference then.
Quote:i just don't see on the Mysql control panel that a xbmc db was created and the watched flags aren't synced.
I'm not well versed at all on mySQL, so i couldn't say for sure. I just know on mine it created a folder named xbmc-video (like I specified in advancedsettings.xml) and it was filled with files that made up the db. Try checking a debug log in XBMC. That will show whether or not it connected to the db. Is the machine you want to host the db on Linux or Win?
- Cheeshead - 2010-05-06 05:40
Ok...so figured out that I was missing the <advancedsetting> tag in the xml file
So now it is actually working off mysql...but does having the mysql option disable the "library view"?? I can't get xbmc to scrape anything new. The only way that I can access anything is from file view.
Am I missing something again?
Update: Think I got it figured out...gotta use network path, not drive path
- WisdomWolf - 2010-05-06 09:31
Ok so I finally got around to setting this up and the first thing that I realized was...Wow it's really slow. Startup of XBMC is slower and accessing the database now takes a ridiculous amount of time. I'm not sure if this is because I'm on wireless or perhaps something to do with the build I'm running (29697). Is this normal?
- RockDawg - 2010-05-06 13:51
Your wireless may be the culprit, but I noticed some weirdness with speed and all my stuff is wired gigabit. When I first set up my main XBMC box with the central db, I hosted the db on a Windows 7 computer. XBMC in general and especially the library was very slow. It took ~20 seconds for XBMC to open the movies library. So I moved the db to a Linux server I had running and bam all of the sudden it was fast. Pretty much just as fast as when the db was local to XBMC. Maybe a split second slower opening the libraries.
So I move on to try setting up the central db on my second XBMC box in the bedroom. It's accessing the db from the same Linux server the other machine is and it's really slow! Like ~45 seconds to open the movies library. For the life of me, I can't figure out why it's different at all let alone such a huge difference in speed. They're both gigbit ehternet and the router they are connected to are gigabit. I checked what Linux had to say about the settings on each network card and they both seemed to be set up the same to me. So I'm not sure. I can't see any reason why the first box was so slow with the db on the windows machine either
What's weird for me was it goes beyond just the libraries. All of XBMC seems slower and navigating in files view was also very slow which makes no sense to me. If you figure out the problem, please post what you did to fix it.
- bmillham - 2010-05-07 02:59
I can't get this working with R29865. The advanced settings seem to be read, because XBMC is creating a local database named xbmc_video.db. It's not creating it on the mysql server.
Code:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.200</host>
<name>xbmc_video</name>
<user>root</user>
</videodatabase>
</advancedsettings>There are no errors in xbmc.log.
I know I've overlooked something simple...
Brian