[AppleTV2] MySQL database / library support?

I am using the path substitution method to access my remote Thumbnails folder.
Everything is working fine with movies. When I am playing music there is a 20 second delay before the next song in the queue plays. I do not have this issue when playing music in file mode. Is anyone having this issue.

Here is my log. I am using 2/4/11 nightly build.

http://pastebin.com/td74T5Ci

lestat1977uk Wrote:hi mate, im using the official release.

Also that was only an extract from my log, every thumbnail is reporting the same error

The official build was a bit buggy in regards to scarpping and thumbs, folder.jpg, thumbnail.tbn, etc, as it was fresh off the presses. I'm using the 1/29/11 nightly build I believe, chaoticmaster says he is using 2/4/11 nightly. It would be worth a shot to try it, maybe something was broken in initial release with regards to smb and thumbs. The unix_err:2 No such file or directory makes me think there is just something not right in the path, because usually a permission thing will say Access denied which is the other common problem.

aicjofs Wrote:The official build was a bit buggy in regards to scarpping and thumbs, folder.jpg, thumbnail.tbn, etc, as it was fresh off the presses. I'm using the 1/29/11 nightly build I believe, chaoticmaster says he is using 2/4/11 nightly. It would be worth a shot to try it, maybe something was broken in initial release with regards to smb and thumbs. The unix_err:2 No such file or directory makes me think there is just something not right in the path, because usually a permission thing will say Access denied which is the other common problem.

I was suffering from the access denied issue with some of the builds from earlier this week. It got fixed when i went to 2/4/11.

Also when I did path substitution I had to enter the line as:

<to>smb://user:credentials@192.168.0.1/c/Thumbnails/Thumbnails</to>

Once I have MySQL set up do I still need to add sources on my ATV2?

Could you elaborate on this fix, i'm having same issue?
tx

boasist Wrote:cool, all is working good on the atv2.
The desktop is working on sql OK
Getting this in the log though on the atv2.

DNS is set correctly on the atv2

Code:

17:07:23 T:157904896 M:139616256   ERROR: Unable to open database: xbmc_video [1042](Can't get hostname for your address)
17:07:23 T:157904896 M:139616256   ERROR: Unable to open database at host: 192.168.221.6 db: xbmc_video (old version?)

Thanks again

EDIT: mysql error, added skip-name-resolve to my.ini

I finally got my dbase up
trying this path substitution thing but need to rescrape my dbase and then i can see what this thumbnail thing is all about.

I'm trying to create a system DSN on the same windows box that has media and installed mysql on. Having issues, any help?
I originally was backing up the video db from my Revo and have a script that works really well, that will reupdate the WATCHED flag from NFOs to the dbase and want to port my script to this new sql dbase.

For instances like this when have to rescrape but tags like that aren't recaptured.


UPDATE:
NVM
needed mysql driver

transcender Wrote:Could you elaborate on this fix, i'm having same issue?
tx

You need to add the skip-name-resolve option to your MySQL configuration (see post #21 http://forum.xbmc.org/showpost.php?p=704...stcount=21 for more details).

yep found that other thread w/ skip-resolve-name got me up and running thanks (weird as i was using IPs)
I think the sql setup could use a more slight refined write up then the ones I've seen.
but i cant get thumbnails path subs to work.
I created script to backup /xbmc to Windows server and then shared out the thumbnails folder as thumbnails.

I've tried putting the credentials in


<to>smb://user:credentials@192.168.0.1/c/Thumbnails/Thumbnails</to>

is the "c/Thumbnails/Thumbnails " native to your share? not sure why the c/thumbnails....

Finally got MySQL install working
Got backup / sync script (backup and centrally locate/share thumbnails) working
Got my WATCHED status sync script working
Got my DSN to mySQL database so this would be last step of system migration to central mySQL store...would love to hammer this home, insights apprecriated.

i still get
21:03:08 T:805208064 M:113704960 ERROR: Create - Error( No such file or directory )
21:03:08 T:805208064 M:113704960 ERROR: Create - Error creating special://masterprofile/Thumbnails
21:03:08 T:805208064 M:113700864 ERROR: Create - Error( No such file or directory )
21:03:09 T:805208064 M:113700864 ERROR: Create - Error creating special://masterprofile/Thumbnails/Music
21:03:09 T:805208064 M:113700864 ERROR: Create - Error( No such file or directory )
21:03:09 T:805208064 M:113700864 ERROR: Create - Error creating special://masterprofile/Thumbnails/Music/Artists
21:03:09 T:805208064 M:113700864

what are the benefits of having your xbmc database on a mysql server as oppose to the default way? Is it easy to setup?

tried opening up full rights w/ xbmc user and no change
Main machine is acer revo on linux, secondary iPad and media/sql server Windows box