[AppleTV2] MySQL database / library support?

rinseaid Wrote:No, it's working fine here.

Using ATV2 with 4.2.1 firmware.

I have in /private/var/mobile/Library/Preferences/XBMC/userdata/advancedsettings.xml:

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>10.11.12.100</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>10.11.12.100</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>

And it's working great!
Thanks Davilla and Team-XBMC!

note: I also set up my library such that the initial commit to the sql database was to an smb:// URL rather than a mounted filesystem, in order to be OS agnostic and also for super easy setup (just add advancedsettings.xml and you're done.)

Can you please elaborate on the bold part please?

Did you mean when adding videos to the library you added them through the SMB share?

Ogi010 Wrote:Can you please elaborate on the bold part please?

Did you mean when adding videos to the library you added them through the SMB share?

The paths to the files in the mysql db are shared across the systems since they share the same db. So having a path point to D:\movies\movie.mkv is not going to work on different pc since it doesn't have D:\

Hence use a source which is shared i.e) samaba share smb://pc/share/movie.mkv

johoja Wrote:The paths to the files in the mysql db are shared across the systems since they share the same db. So having a path point to D:\movies\movie.mkv is not going to work on different pc since it doesn't have D:\

Hence use a source which is shared i.e) samaba share smb://pc/share/movie.mkv

Cool, just double checking. I am having some database issues (mostly linux issues), I'm trying to setup an openelec.tv box alongside an appleTV2 box next to each other and see which one performs better

Ogi

Ok I've figured out why it didn't work when i tryed. My SQL lib was the latest pvr git, so it wasn't compatible with iphone xmbc version. I've falled it back to Dharma and now it works ok.

Cheers.

What about remote Thumbnails
What is the right way to create shortcut

With TV, I have my media organized like this:
http://lifehacker.com/5505849/how-to-whi...-and-boxee

I haven't had a chance to fix my Movies yet.

All my thumbnails work in TV great, but yet to fix covers in Movies.


Once you've got .nfo and/or .tbn and .jpgs built scanning goes a ton quicker too.

ti_gusus Wrote:What about remote Thumbnails
What is the right way to create shortcut

I'm taking from it, that at this point, there isn't a good solution as there have been no reply's to this question in a few different posts? Also davilla says there is currently no way to mount a remote disk.

http://forum.xbmc.org/showthread.php?tid=91776

Maybe there is another way, I'm use to mounting a drive in Linux or Windows then symlinking. I can think of a few ways to do it if your concern is just making the thumbnails once, and don't want to duplicate thumbnail generation.

i.e afpfs-gt for mac/linux http://sourceforge.net/projects/afpfs-ng/,

or maybe this for windows http://thebigboss.org/2009/05/22/calling...the-iphone

You can then sync every so often. I personally am interested in serving the thumbnails

Didn't tryed yet but perhaps you can use rsync on your iphone to copy your thumb data daily.

Or Dropbox could be a solution too.

hotlobster Wrote:Didn't tryed yet but perhaps you can use rsync on your iphone to copy your thumb data daily.

Or Dropbox could be a solution too.

This seems like it'd be a good idea if it works. If noone else reports back, I'll give it a shot tomorrow and see what happens.

johntash Wrote:This seems like it'd be a good idea if it works. If noone else reports back, I'll give it a shot tomorrow and see what happens.

Ive been using 'Super Flexible File Synchronizer' to sync from my main XBMC Windows machine to > Apple TV2. Syncs every 60 minutes.

I've mounted the SFTP Drive of the AppleTV using Expandrive.

Also don't think dropbox would work for the AppleTV, don't think you can install it on there.

Samba might work if you can mount a remote share on the AppleTV but still I like having the Thumbnails local to each machine ( network can have latency in loading up pics )