[AppleTV2] MySQL database / library support?

I've got a weird problem.. maybe it has been adressed before, but I'll give it a shot:

I put all of my Thumbnails in my smb, did all the advancedsettings.xml changes and all.

However, ATV2 keeps on re-creating the thumbnails folder @ usersettings folder.
Granted, it READS the samba share, but it then downloads them back to the ATV2, making the whole work quite useless (the point obviously is to avoid using the remarkably small local hard drive in favor of the samba's)

Hope someone could orient me a little.

Regards

thesuffering Wrote:i got this when i tried typing it manually via command prompt, your thoughts?

Code:

C:\mysql-proxy\bin>mysql-proxy --max-open-files 1024 --proxy-lua-script=xbmcatv.
lua --proxy-address=0.0.0.0:3307 --proxy-backend-addresses=192.168.254.251:3306

2011-03-14 16:22:36: (critical) admin-plugin.c:569: --admin-username needs to be
set
2011-03-14 16:22:36: (critical) mainloop.c:267: applying config of plugin admin
failed
2011-03-14 16:22:36: (critical) mysql-proxy-cli.c:596: Failure from chassis_main
loop. Shutting down.

C:\mysql-proxy\bin>

My MySql server runs on Linux, so i can't try to solve your issue by testing, but 2 things you should test:
- either remove "--max-open-files 1024". I had to set it to avoid an issue on my Debian system. It may not be required on Windows.
- or try to run Command Line in administrator mode.

Odon Wrote:My MySql server runs on Linux, so i can't try to solve your issue by testing, but 2 things you should test:
- either remove "--max-open-files 1024". I had to set it to avoid an issue on my Debian system. It may not be required on Windows.
- or try to run Command Line in administrator mode.

i tried both, didnt work :-( hopefully the new unofficial builds from keith will get up the the same as the xbmc nightlies so they are on the same db version. windows doesnt want to play nice with me

So, I've got some problems:

I used a advancedsettings.xml:



But when I see the error log:

Any idea?

SunnyynnuS Wrote:So, I've got some problems:

I used a advancedsettings.xml:



But when I see the error log:

Code:

03:00:02 T:223514624 M:163139584  NOTICE: No advancedsettings.xml to load (special://masterprofile/advancedsettings.xml)

Any idea?

That looks like it may be a permissions related issue. In ssh type
chmod a+rw advancedsettings.xml

TheRealDL Wrote:I vote against putting ANY artwork into the DB. I feel that performance on the MySQL DB is slow enough that throwing (in my case) over 500MB of artwork at it is counter productive.

The SAMBA shortcuts work perfectly on iOS and will be rolled into the Desktop releases. In the mean time, a couple of Symlinks ain't half bad.

That said, why is my iPad and iPhone 4 soooo much slower using XBMC than the Apple TV?? Battery vs. AC??

Cheers!

PS... Looks as though it's possible to implement DB storage with FUSE but I don't know if XBMC will be able to use it.
Linux.com::Using MySQL as a filesystem

man, loading thumbs remotely on ATV2 is slower than anything i have ever seen in my whole life

prophetizer Wrote:man, loading thumbs remotely on ATV2 is slower than anything i have ever seen in my whole life

i have it remotely loading thumbs and fanart on mine and the load time isnt that bad. maybe <30 seconds to get into the movie library and then from there everything loads fairly quickly. tv show library (which is smaller (about 25 shows)) loads instantly

thesuffering Wrote:i tried both, didnt work :-( hopefully the new unofficial builds from keith will get up the the same as the xbmc nightlies so they are on the same db version. windows doesnt want to play nice with me

newest atv nightly and win32 nightly are on the same DB so this is a non issue now.

Has anyone made step-by-step instructions for those that wouldn't know how to do a single step of this without hand holding? Including installing MySQL onto a remote instance of Windows and/or Linux?

thanks!

See this post:
http://forum.xbmc.org/showthread.php?tid=80829

I have managed to get it work on my ATV2 and Windows PC.

Any way, I could try to write a step-by-step guide.