[ringgh0st]

hey guys,

im using the shared database feature (with mysql-database on a synology) for about a year now. after updating my apple tv to eden i have a question. is there also a mysql support? and when yes - is it as same as easy to configure like with normal OS X (just paste the stuff in the advancedsettings.xml)? Is there a tutorial?

[bananen]

yes. yes, on the wiki

[ringgh0st]

thx. i read. soooo. i only have to edit the advanced settings.xml located here:

Code:

iOS: /private/var/mobile/Library/Preferences/XBMC/userdata/advancedsettings.xml

and have to substitute something like this?

Code:

<pathsubstitution>
      <substitute>
      <from>/media/Goods/</from>
      <to>smb://MEDIABOB/goods/</to>
      </substitute>
  </pathsubstitution>

[kno1]

Something like that, yeah.

Here's my advancedsettings.xml:

Code:

<advancedsettings>
    <pathsubstitution>
       <substitute>
         <from>special://masterprofile/Thumbnails</from>  
         <to>smb://host-computer-name/path-to_shared_thumbnail-folder/</to>
      </substitute>
    </pathsubstitution>
    <videolibrary>
        <cleanonupdate>true</cleanonupdate>
    </videolibrary>
    <videodatabase>
      <type>mysql</type>
      <host>host-computer-name-or-ip</host>
      <port>3306</port>
      <name>xbmc_video</name>
      <user>xbmc</user>
      <pass>xbmc</pass>
    </videodatabase>
    <musicdatabase>
      <type>mysql</type>
      <host>host-computer-name-or-ip</host>
      <port>3306</port>
      <name>xbmc_music</name>
      <user>xbmc</user>
      <pass>xbmc</pass>
    </musicdatabase>
    <gui>    
        <algorithmdirtyregions>3</algorithmdirtyregions>
        <nofliptimeout>0</nofliptimeout>
    </gui>
</advancedsettings>

So what this does is give you a shared mysql database for video and music. And it shared the thumbnails for the downloaded images for your library.

Additionally I used the safe dirty region mode.

Remco

[ringgh0st]

So what this does is give you a shared mysql database for video and music. And it shared the thumbnails for the downloaded images for your library.

Additionally I used the safe dirty region mode.

Remco

mhh so, you use thumbnail sharing through smb? i tried it sometimes ago but wasnt satisfied with xbmc-starting time. however when using a samba-share for thumbnails the starting time of xbmc was significant longer. so i sync the /thumbnail folder with dropbox (installed on every client).

is the speed-hickup fixed now?

[kno1]

There's no starting delay, some of the thumbs might take a little longer to load, but navigating goes just fine.

Supposedly NFS is faster, but I haven't tried that for sharing the thumbnails. While browsing a large folder though, I didn't really see any difference between NFS & SMB, so I can't really say anything about the performance difference between them.

I wouldn't know how to use dropbox to sync between two appletv's though. (or to just 1 atv and another machine)

Remco

[haffi]

I use smb for the thumbs and also tried NFS method.

the speed is the same if your on a Wired 100 MB network. If something the SMB seams to be faster even at least for thumbs, streaming I use FTP for source since that seams to be the most bytesforthebucks and causes the least buffering.

[ringgh0st]

K. thanx for your input. imho the local-way with dropbox is the best solution for keeping thumbnails synced...

but i will test the smb-share-thing again and give feedback.

[Ned Scott]

Thumb/fanart sync via pathsubs is optional, just to be clear.

[spillington]

trying to sync xbmc databases with a mysql database, but as soon as i load xbmc on my atv2 with the advancedsettings.xml in place, xmbc main menu is SLOW AS MOLASSES! It also seems to act as though there is no library at all. Connection issue perhaps? The firewall on my sql sever is OFF, and tcp/ip connections to mysql are enabled. Any suggestions??

[jmarshall]

As always, the Debug Log will tell you.

[spillington]

Thanks. I checked out the log, but it's not giving me much to go on.

The errors start with 61 similar errors:
ERROR: Unable to open database: xbmc_video60 [1049] (Unknown database 'xbmc_video60')
This error is repeated from xbmc_video60 down to xbmc_video0, then it says:
NOTICE: Old database found - upgrading from version 0 to 60
ERROR: SQL: The source database was unexpectedly empty.
ERROR: Unable to copy old database xbmc_video to new version xbmc_video60

Then the whole string repeats again, over and over. Not sure what to make of it?

[jmarshall]

Looks like you created the xbmc_video and xbmc_music databases in mysql. Delete them.

[spillington]

That did the trick. Your help is greatly appreciated!

this information is contrary to some of the guides out there...

[jmarshall]

But not contary to the clear guidelines in the wiki.