[AppleTV2] MySQL database / library support?

  Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
keith Offline
Team-XBMC Member
Posts: 696
Joined: Sep 2007
Reputation: 3
Location: SF, CA
Post: #16
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.
find quote
aicjofs Offline
Junior Member
Posts: 40
Joined: Nov 2009
Reputation: 3
Post: #17
ti_gusus Wrote:What about remote Thumbnails Confused
What is the right way to create shortcut Confused

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
find quote
hotlobster Offline
Senior Member
Posts: 245
Joined: Jan 2009
Reputation: 0
Location: Paris FR
Post: #18
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.
find quote
johntash Offline
Junior Member
Posts: 2
Joined: Jan 2011
Reputation: 0
Post: #19
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.
find quote
johoja Offline
Fan
Posts: 567
Joined: Aug 2009
Reputation: 0
Post: #20
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 )
find quote
vicbitter Offline
Donor
Posts: 253
Joined: Jan 2011
Reputation: 3
Post: #21
Depending on your MySQL server configuration you may need to add the skip-name-resolve option to the [mysqld] section in the my.ini config file.

It seems that my MySQL instance couldn't resolve the host name of my AppleTV and was refusing the connection...

After including the skip-name-resolve and restarting MySQL, XBMC on my AppleTV can now see my movies Smile
find quote
amet Offline
How do ya like them apples?
Posts: 4,106
Joined: Jul 2009
Reputation: 39
Location: Novi Sad / Dubai
Post: #22
just FYI,

if you add:

Code:
<pathsubstitution>
    <substitute>
        <from>/Volumes/DRIVE1</from>
        <to>smb://192.168.1.4/DRIVE1</to>
    </substitute>
  </pathsubstitution>

to advancedsetting.xml your paths on remote machine(/Volumes/DRIVE1) would get translated to be used from ATV2(smb://192.168.1.4/DRIVE1)

this is handy when mysql database is setup on the same machine where main XMBC and all media is

more at trac 11101


Always read the XBMC_Online_Manual,Frequently_Asked_Questions and search the forum before posting.
For troubleshooting and bug reporting use -> Log_file.
find quote
r4nd0m Offline
Member
Posts: 66
Joined: Dec 2010
Reputation: 0
Post: #23
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.

i created a shell script on my ipad to do that, I use a modified live XBMC and use a simple script with the following on my ipad root user directory:

rsync -auzvr x.x.x.x:/home/xbmc/.xbmc/userdata/Thumbnails /var/mobile/Library/Preferences/XBMC/userdata/

prio to that I have created ssh keys on the ipad and copied the public key to my xbmc so I have a fully secure and silent authentication for my root user on the ipad ... the inital trasfer tool a few minutes but after that it will sync incrementally
(This post was last modified: 2011-01-30 00:35 by r4nd0m.)
find quote
Hidd3nFury Offline
Senior Member
Posts: 252
Joined: Apr 2009
Reputation: 0
Post: #24
I tried setting up MySQL for the first time for my xbmc machines/atv yesterday and all wireless devices it was taking upwards of 30 seconds to load into my libraries.

Is there anything I can do to speed this up or is it purely an issue with the speed of my network?
find quote
keith Offline
Team-XBMC Member
Posts: 696
Joined: Sep 2007
Reputation: 3
Location: SF, CA
Post: #25
Hidd3nFury Wrote:I tried setting up MySQL for the first time for my xbmc machines/atv yesterday and all wireless devices it was taking upwards of 30 seconds to load into my libraries.

Is there anything I can do to speed this up or is it purely an issue with the speed of my network?

I have mysql remote library running on my QNAP which has a c2d 2.8ghz using 802.11n dual band over my Time Capsule and my 96 shows (almost full) load up in less than 10 seconds, maybe about double the time my MBP takes to load. Not bad at all.

Can you try it via ethernet and see if you still have lag?
find quote
Hidd3nFury Offline
Senior Member
Posts: 252
Joined: Apr 2009
Reputation: 0
Post: #26
meshuga Wrote:I have mysql remote library running on my QNAP which has a c2d 2.8ghz using 802.11n dual band over my Time Capsule and my 96 shows (almost full) load up in less than 10 seconds, maybe about double the time my MBP takes to load. Not bad at all.

Can you try it via ethernet and see if you still have lag?

I can't test at the moment with the ATV cos people are using it but my main HTPC that is wired loads almost immediately. My MacBook Air is as slow as the ATV if not slower and I can't try wired cos theres no ethernet port Laugh

I was running MySQL from my office PC C2Q 2.4 and dual band 802.11n. It certainly doesn't seem to be a problem with the ATV.

UPDATE: I deleted the database and rebuilt be library from scratch and now my 600 something movies load in about 8 seconds and my 77 TV Shows load in about 10. I can deal with that Big Grin
(This post was last modified: 2011-01-30 04:28 by Hidd3nFury.)
find quote
me3head Offline
Junior Member
Posts: 4
Joined: Jan 2011
Reputation: 0
Post: #27
r4nd0m Wrote:i created a shell script on my ipad to do that, I use a modified live XBMC and use a simple script with the following on my ipad root user directory:

rsync -auzvr x.x.x.x:/home/xbmc/.xbmc/userdata/Thumbnails /var/mobile/Library/Preferences/XBMC/userdata/

prio to that I have created ssh keys on the ipad and copied the public key to my xbmc so I have a fully secure and silent authentication for my root user on the ipad ... the inital trasfer tool a few minutes but after that it will sync incrementally


I was able to use rsync to manually transfer over my thumbs.

A couple questions:

1. If I want to set up the public/private keys, do I need to allow my server to accept root logins? (since rsync will be running as root on the aTV, but I'd like it to log in to my server as another user).

2. How do I set up the aTV to run the rsync periodically?
find quote
AaronD Offline
Senior Member
Posts: 252
Joined: Jan 2007
Reputation: 0
Location: Dubai, United Arab Emirates
Post: #28
Try this link.
http://troy.jdmz.net/rsync/index.html

I am just playing with this. I have a Revo in my lounge with a user 'xbmc', and the Apple TV has a user 'root', so I had to modify the line above to authenticate as xbmc on the remote machine not root which it was doing by default. Did you do the same? If I created a local user called xbmc and with the same password as remote, would it then do the rsync without having to setup these ssh keys? I don't care about security in this context at all, I just want it to work.
find quote
WisdomWolf Offline
Senior Member
Posts: 109
Joined: Mar 2008
Reputation: 0
Post: #29
I created an advancedsettings.xml on my iPad and it shows my mySQL library correctly (although no thumbs, obviously). However it won't play anything. Every time I go to play a video it just says that it's no longer available. I don't get it, I can access the shares via the file view (videos) and I know the database has the right SMB links because I use it with a revo and two MacBooks as well. Any ideas?
find quote
me3head Offline
Junior Member
Posts: 4
Joined: Jan 2011
Reputation: 0
Post: #30
AaronD Wrote:Try this link.
http://troy.jdmz.net/rsync/index.html

I am just playing with this. I have a Revo in my lounge with a user 'xbmc', and the Apple TV has a user 'root', so I had to modify the line above to authenticate as xbmc on the remote machine not root which it was doing by default. Did you do the same? If I created a local user called xbmc and with the same password as remote, would it then do the rsync without having to setup these ssh keys? I don't care about security in this context at all, I just want it to work.

I got the passwordless login working, but I dont think aTV runs cron
find quote
Post Reply