[AppleTV2] MySQL database / library support?

vmsferreira Wrote:Anynone can help? please thanks

Regards

VF

It seems that it's trying to upgrade your database version from 42 to 53, and fails.

What version XBMC are your trying to share with? You need a nightly if you want to be compatible with ATV2.

I suggest you DROP your databases and recreate them with your ATV2.

I'm sharing with my windows PC (10.1). The ATV2 have the last official build.

I did what you suggested, recreate the DB using ATV2, installed the last nightly for windows and now is the xbmc on windows that is not working

appear this error on the log:

16:49:57 T:10464 M:1992003584 ERROR: Error Type: <type 'exceptions.ValueError'>
16:49:57 T:10464 M:1992003584 ERROR: Error Contents: invalid literal for int() with base 10: 'smb://atv2:atv2@NAS/MULTIMEDIA/Movies/123/9'
16:49:57 T:10464 M:1992204288 ERROR: Traceback (most recent call last):
File "C:\Users\VMSFerreira\AppData\Roaming\XBMC\addons\script.recentlyadded\RecentlyAd​ded.py", line 350, in <module>
Main()
File "C:\Users\VMSFerreira\AppData\Roaming\XBMC\addons\script.recentlyadded\RecentlyAd​ded.py", line 106, in __init__
self._fetch_totals()
File "C:\Users\VMSFerreira\AppData\Roaming\XBMC\addons\script.recentlyadded\RecentlyAd​ded.py", line 137, in _fetch_totals
movies_totals[ 6 ] = datetime.date( int( date[ 0 ] ), int( date[ 1 ] ), int( date[ 2 ] ) ).strftime( date_format ) # last played
ValueError: invalid literal for int() with base 10: 'smb://atv2:atv2@NAS/MULTIMEDIA/Movies/123/9'


Anyone can help

VF

How do I change advancedsettings.xml to use SQL on an Ipad 2 ?

Where, and how do I find the xml file and edit it ?

Blaxxor Wrote:How do I change advancedsettings.xml to use SQL on an Ipad 2 ?

Where, and how do I find the xml file and edit it ?

/private/var/mobile/Libarary/Preferences/XBMC/userdata/advancedsettings.xml

You'll need to have either an ssh daemon or mobile terminal to access it, as well as whatever editor you prefer...

Back up your database first by exporting it on an existing box. Be aware, if your current installations are the stable releases, you're going to hose your database. I just did, and without a back-up!

CSB! Wrote:/private/var/mobile/Libarary/Preferences/XBMC/userdata/advancedsettings.xml

You'll need to have either an ssh daemon or mobile terminal to access it, as well as whatever editor you prefer...

Back up your database first by exporting it on an existing box. Be aware, if your current installations are the stable releases, you're going to hose your database. I just did, and without a back-up!

That doesn't sound very easy to me. Maybe I should ignore XBMC om my iPad2 and use Air video as I did before.

But it would still be nice using XBMC, it works so well om my HTPC's.

lanre Wrote:i have what may be a very simple problem, that, after reading through all 24 pages of this thread, i can't seem to find a solution.

bit of background: i have all my media (and mysql) on a windows home server, i have a HTPC with Windows 7, and atv2 in the bedroom. I have changed advancedsettings.xml to map to mysql and this works fine on both machines.

my atv2 connects fine to the mysql server, but whenever i try to play anything, it says the file no longer exists.

in xbmc.log, i get "permission denied" errors whenever it tries to go get a file.

I'm assuming the problem is that it doesn't have the user/pass combination to gain access to my server, but I've no idea where/how to feed this in.

Would appreciate any help you guys can provide on this.

thanks in advance

EDIT:

Scratch that - all seems to be working now. I set the folder on the server to allow everyone to access, and I made sure that the server folders were in videos as sources.

The problem here is that although your ATV is looking at the database ok you haven't added the sources to the ATV - you still have to do that seperately (i had the same issue)

So add the sources to atv and make sure you give them the same name etc... then you should be fine

Blaxxor Wrote:That doesn't sound very easy to me. Maybe I should ignore XBMC om my iPad2 and use Air video as I did before.

But it would still be nice using XBMC, it works so well om my HTPC's.

It's pretty simple if you have any experience administering a posix box through the CLI... the only dicey part is porting all your other installs to a newer version. I opted to run a local library on the iPad, instead.

CSB! Wrote:It's pretty simple if you have any experience administering a posix box through the CLI... the only dicey part is porting all your other installs to a newer version. I opted to run a local library on the iPad, instead.

My other installations are all the most recent offical.

But I have nog previous experience of what you asking. Too bad. Would really like to have XBMC connected to SQL, but I have no clue how to fix it

//Stellan

Blaxxor Wrote:That doesn't sound very easy to me. Maybe I should ignore XBMC om my iPad2 and use Air video as I did before.

But it would still be nice using XBMC, it works so well om my HTPC's.

That's only if you want to use a shared library feature (keeping movie info and what you watched and didn't watch in sync with other XBMC copies). The single individual library feature on the iPad itself will work just fine without messing with any of this. Using it just in plain old file mode (which now is just not "scrapping") works too. AirVideo doesn't show any of this data either.

Ned Scott Wrote:That's only if you want to use a shared library feature (keeping movie info and what you watched and didn't watch in sync with other XBMC copies). The single individual library feature on the iPad itself will work just fine without messing with any of this. Using it just in plain old file mode (which now is just not "scrapping") works too. AirVideo doesn't show any of this data either.

No i know. But the main reason for me to use XBMC was that I should be connected to my SQL.

I'm not stupid so i might be able to change the xmlfile if there was a guide around that told me step by step how to fix it

//Stellan