MySQL Database: Multiple XBMC HTPC's with 1 Shared Library

MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library (/showthread.php?tid=85654)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

- pletopia - 2011-02-23

Avigrace Wrote:I would greatly appreciate if someone with good Mysql knowledge could write up a quick guide on how to set up indexing to speed up the SQL XBMC video database.

bump ...

I read the whole thread and overall some decent info, i think i'm gonna set this up as soon however the one thing this thread is missing is the various index's that should be created to speed things up

- tboooe - 2011-02-23

czfj5r Wrote:I think it starts to come down to the speed of your db server combined with the right indexing as well as the network overall and that is where it starts to become tricky.

I am using the MySQL db and it works great with the possibility to move between rooms and continue where you are. You just update from one computer and all PC's get the updated library and thumbnails.

Just to be clear, I thought using the mysql database does not sync thumbnails. The only way I know to do this is to make a symbolic link the the thumbnails folder. Can you please explain further how you are syncing the thumbnails?

- christsim - 2011-02-23

Does anybody know how to create a symlink for thumbnails on a Apple TV 2?

- one800higgins - 2011-02-24

christsim Wrote:Does anybody know how to create a symlink for thumbnails on a Apple TV 2?

I'm curious about this same question.

- davilla - 2011-02-24

christsim Wrote:Does anybody know how to create a symlink for thumbnails on a Apple TV 2?

just like under osx/linux

ln -s <original file> <symlink>

- tomal2k - 2011-02-25

hello guys,
does this work with ATV 2G XBMC iOS Version and My HTPC r33324 [10.0 beta1]? very new to these hacks, please advice.

ResumeTime issue - Ron_C - 2011-02-25

I've set this up and I'm having some trouble with the resumetime data. I have MySQL set up and populated with my movies and TV shows. I pointed a second PC to that DB and all the TV Shows/Movies were there (so I knew my MySQL connection was good). I fired up a TV show and watched a bit of it, then stopped it. Went back to the main PC and started the same show...and it started from the beginning. I turned on Debug logging and saw this:

Mysql execute: update settings set Deinterlace=0,ViewMode=0,ZoomAmount=1.000000,PixelRatio=1.000000,VerticalShift=0.000000,AudioStream=-1,SubtitleStream=-1,SubtitleDelay=0.000000,SubtitlesOn=1,Brightness=50.000000,Contrast=50.000000,Gamma=20.000000,VolumeAmplification=0.000000,AudioDelay=0.000000,OutputToAllSpeakers=0,Sharpness=0.000000,NoiseReduction=0.000000,NonLinStretch=0,PostProcess=0,ResumeTime=0,Crop=0,CropLeft=0,CropRight=0,CropTop=0,CropBottom=0 where idFile=103

So it seems XBMC made the call to MySQL to update the settings, but set the resumetime=0 as if I hadn't watched it. I see the lastplayed column in the files table is updated appropriately so queries are definitely executing ok.

I'm using nightly build xbmc-rfe6ddc7-master.exe from today, 2/24.

Any help is appreciated.

- tboooe - 2011-02-25

Ron_C Wrote:I've set this up and I'm having some trouble with the resumetime data. I have MySQL set up and populated with my movies and TV shows. I pointed a second PC to that DB and all the TV Shows/Movies were there (so I knew my MySQL connection was good). I fired up a TV show and watched a bit of it, then stopped it. Went back to the main PC and started the same show...and it started from the beginning. I turned on Debug logging and saw this:

Mysql execute: update settings set Deinterlace=0,ViewMode=0,ZoomAmount=1.000000,PixelRatio=1.000000,VerticalShift=0.000000,AudioStream=-1,SubtitleStream=-1,SubtitleDelay=0.000000,SubtitlesOn=1,Brightness=50.000000,Contrast=50.000000,Gamma=20.000000,VolumeAmplification=0.000000,AudioDelay=0.000000,OutputToAllSpeakers=0,Sharpness=0.000000,NoiseReduction=0.000000,NonLinStretch=0,PostProcess=0,ResumeTime=0,Crop=0,CropLeft=0,CropRight=0,CropTop=0,CropBottom=0 where idFile=103

So it seems XBMC made the call to MySQL to update the settings, but set the resumetime=0 as if I hadn't watched it. I see the lastplayed column in the files table is updated appropriately so queries are definitely executing ok.

I'm using nightly build xbmc-rfe6ddc7-master.exe from today, 2/24.

Any help is appreciated.

Try using the last official release of Dharma. I have a read a few other posts with people having issues with the mysql db using the nightly build.

- Ron_C - 2011-02-25

tboooe Wrote:Try using the last official release of Dharma. I have a read a few other posts with people having issues with the mysql db using the nightly build.

Ok, ill give that a try. Unfortunately the official release has trouble playing some of my movies but I'd like to see this working. Hopefully 10.1 or a future nightly will have both the movie fix and update the setting properly.

- TugboatBill - 2011-02-25

Ron_C Wrote:Ok, ill give that a try. Unfortunately the official release has trouble playing some of my movies but I'd like to see this working. Hopefully 10.1 or a future nightly will have both the movie fix and update the setting properly.

They're working on getting 10.1 out and the release is imminent. If you post a bug in the trackit system it may make the release.

- tboooe - 2011-02-25

Ron_C Wrote:Ok, ill give that a try. Unfortunately the official release has trouble playing some of my movies but I'd like to see this working. Hopefully 10.1 or a future nightly will have both the movie fix and update the setting properly.

What kinds of files does Dharma have trouble playing?

- Ron_C - 2011-02-26

TugboatBill Wrote:They're working on getting 10.1 out and the release is imminent. If you post a bug in the trackit system it may make the release.

Good idea. Ticket has been entered.

- Ron_C - 2011-02-26

tboooe Wrote:What kinds of files does Dharma have trouble playing?

Here is the original post I made regarding playback issues. It seems that the the nightly builds have fixed this already:
http://forum.xbmc.org/showthread.php?tid=89218

- Ron_C - 2011-03-06

Ron_C Wrote:Good idea. Ticket has been entered.

My ticket was rejected because apparently that resumetime is NOT the field used for...well..the resume time and, it seems the resume time is not set until at least 3 minutes into a video. I tried my setup again, this time skipping more than 3 min and it worked perfectly!

- FreakinAye - 2011-03-08

I'm feeling like a complete idiot but I can't even get XBMC to read my advancedsettings.xml

MySQL is running fine and accessible from local and remote locations

Code:
<advancedsettings>

    <videodatabase>

        <type>mysql</type>

        <host>127.0.0.1<host>

        <port>3306</port>

        <name>xbmc_video</name>

        <user>xbmc123</user>

        <pass>****</pass>

    </videodatabase>

    <musicdatabase>

        <type>mysql</type>

        <host>127.0.0.1</host>

        <port>3306</port>

        <name>xbmc_music</name>

        <user>xbmc123</user>

        <pass>****</pass>

    </musicdatabase>

</advancedsettings>

Log file is showing me

Quote:09:11:41 T:3816 M:2818031616 ERROR: Error loading special://profile/advancedsettings.xml, Line 9
Error reading end tag.

Does anything look wrong here? Why wouldn't this be working?