[AppleTV2] MySQL database / library support?

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



Thanks again

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

I'm having problems getting thumbnails to work, i liked the idea of using path substitute but it isnt working for me,

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>server2008</host>
<port>3306</port>
<user>root</user>
<pass>xbmc</pass>
<name>xbmc_movies</name>
</videodatabase>

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

<pathsubstitution>
<substitute> <from>/var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/</from>
<to>smb://192.168.0.1/c/Thumbnail Cache/Thumbnails/</to>
</substitute>
</pathsubstitution>
</advancedsettings>

What are you seeing in your xbmc.log?

I'd be worried about the space being translated correctly in between Thumbnail Cache in this

"smb://192.168.0.1/c/Thumbnail Cache/Thumbnails/"

ok that's a fair comment will try without the space and report back

Tried renaming but still getting same issue.

<pathsubstitution>
<substitute>
<from>/var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/</from>
<to>smb://192.168.0.1/c/Thumbnails/Thumbnails/</to>
</substitute>
</pathsubstitution>



11:49:32 T:162021376 M:333041664 ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/Fanart/
11:49:32 T:162021376 M:333041664 ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/Fanart/
11:49:32 T:162021376 M:333041664 WARNING: FileSmb::OpenForWrite() called with overwriting enabled! - smb://192%2e168%2e0%2e1/c/Thumbnails/Thumbnails/Video/Fanart/87087b47%2etbn
11:49:32 T:162021376 M:333041664 ERROR: FileSmb->Open: Unable to open file : 'smb://192%2e168%2e0%2e1/c/Thumbnails/Thumbnails/Video/Fanart/87087b47%2etbn'
unix_err:'2' error : 'No such file or directory'

lestat1977uk Wrote:Tried renaming but still getting same issue.

<pathsubstitution>
<substitute>
<from>/var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/</from>
<to>smb://192.168.0.1/c/Thumbnails/Thumbnails/</to>
</substitute>
</pathsubstitution>



11:49:32 T:162021376 M:333041664 ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/Fanart/
11:49:32 T:162021376 M:333041664 ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/Fanart/
11:49:32 T:162021376 M:333041664 WARNING: FileSmb::OpenForWrite() called with overwriting enabled! - smb://192%2e168%2e0%2e1/c/Thumbnails/Thumbnails/Video/Fanart/87087b47%2etbn
11:49:32 T:162021376 M:333041664 ERROR: FileSmb->Open: Unable to open file : 'smb://192%2e168%2e0%2e1/c/Thumbnails/Thumbnails/Video/Fanart/87087b47%2etbn'
unix_err:'2' error : 'No such file or directory'

I think that this may be related to post #35 (http://forum.xbmc.org/showpost.php?p=710...stcount=35)

Are you able to generate your thumbnails on another XBMC machine and see if that works?

Actually i have 3 other machines using Mysql which all work and i am pointing to that Thumbnails folder, so there already a lot of thumbnails in the directory that should be picked up?

Or am i missing something?

lestat1977uk Wrote:Tried renaming but still getting same issue.

<pathsubstitution>
<substitute>
<from>/var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/</from>
<to>smb://192.168.0.1/c/Thumbnails/Thumbnails/</to>
</substitute>
</pathsubstitution>



11:49:32 T:162021376 M:333041664 ERROR: Create - Error creating /var/mobile/Library/Preferences/XBMC/userdata/Thumbnails/Video/Fanart/
11:49:32 T:162021376 M:333041664 ERROR: Create - Error creating special://masterprofile/Thumbnails/Video/Fanart/
11:49:32 T:162021376 M:333041664 WARNING: FileSmb::OpenForWrite() called with overwriting enabled! - smb://192%2e168%2e0%2e1/c/Thumbnails/Thumbnails/Video/Fanart/87087b47%2etbn
11:49:32 T:162021376 M:333041664 ERROR: FileSmb->Open: Unable to open file : 'smb://192%2e168%2e0%2e1/c/Thumbnails/Thumbnails/Video/Fanart/87087b47%2etbn'
unix_err:'2' error : 'No such file or directory'

Try:

<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails</from>
<to>smb://192.168.0.1/c/Thumbnails/Thumbnails</to>
</substitute>
</pathsubstitution>

works for me.

Which version of XBMC are you using? The original official release or one of the nightlies made by meshuga?

Have you verified there actually is a folder "fanart" with a file a file "87087b47.tbn" in your share under c/Thumbnails/Thumbnail/Video or is it missing.

hi mate, im using the official release.

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