• 1
  • 2
  • 3
  • 4(current)
  • 5
  • 6
  • 18
[AppleTV2] MySQL database / library support?
#46
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?
Reply
#47
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?
Reply
#48
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.
Reply
#49
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.
Reply
#50
hi mate, im using the official release.

Also that was only an extract from my log, every thumbnail is reporting the same error
Reply
#51
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
Reply
#52
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.
Reply
#53
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:[email protected]/c/Thumbnails/Thumbnails</to>
Reply
#54
Once I have MySQL set up do I still need to add sources on my ATV2?
ImageImage
Reply
#55
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
Search first, provide details and keep forums clean. Mark things solved, to close them out and acknowledge helpful volunteers who share. If I have helped, click the plus button.
Reply
#56
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
Search first, provide details and keep forums clean. Mark things solved, to close them out and acknowledge helpful volunteers who share. If I have helped, click the plus button.
Reply
#57
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).
Reply
#58
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:[email protected]/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
Search first, provide details and keep forums clean. Mark things solved, to close them out and acknowledge helpful volunteers who share. If I have helped, click the plus button.
Reply
#59
what are the benefits of having your xbmc database on a mysql server as oppose to the default way? Is it easy to setup?
Reply
#60
tried opening up full rights w/ xbmc user and no change Sad
Main machine is acer revo on linux, secondary iPad and media/sql server Windows box
Search first, provide details and keep forums clean. Mark things solved, to close them out and acknowledge helpful volunteers who share. If I have helped, click the plus button.
Reply
  • 1
  • 2
  • 3
  • 4(current)
  • 5
  • 6
  • 18

Logout Mark Read Team Forum Stats Members Help
[AppleTV2] MySQL database / library support?1