[AppleTV2] MySQL database / library support? - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111) +---- Forum: iOS & tvOS (https://forum.kodi.tv/forumdisplay.php?fid=137) +---- Thread: [AppleTV2] MySQL database / library support? (/showthread.php?tid=91485) |
- RudolfR - 2011-07-01 vmsferreira Wrote:Anynone can help? please thanks 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. - vmsferreira - 2011-07-01 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\RecentlyAdded.py", line 350, in <module> Main() File "C:\Users\VMSFerreira\AppData\Roaming\XBMC\addons\script.recentlyadded\RecentlyAdded.py", line 106, in __init__ self._fetch_totals() File "C:\Users\VMSFerreira\AppData\Roaming\XBMC\addons\script.recentlyadded\RecentlyAdded.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 - Blaxxor - 2011-07-06 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 ? - CSB! - 2011-07-06 Blaxxor Wrote:How do I change advancedsettings.xml to use SQL on an Ipad 2 ? /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! - Blaxxor - 2011-07-07 CSB! Wrote:/private/var/mobile/Libarary/Preferences/XBMC/userdata/advancedsettings.xml 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. - Duncan Miller - 2011-07-07 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. 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 - CSB! - 2011-07-07 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. 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. - Blaxxor - 2011-07-08 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 - Ned Scott - 2011-07-08 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. 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. - Blaxxor - 2011-07-08 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 - joshua.lyon - 2011-07-08 Blaxxor Wrote:My other installations are all the most recent offical. As far as I'm aware, the most recent officials are running on older code (and older databases) than the latest iOS builds. I ended up upgrading my main HTPC to an unstable (Linux) build so the database version between it and my AppleTV 2 would be in sync. - urbanracer34 - 2011-08-04 I set this up with a Mac OS X server 10.6.8 running on a mac mini with MYSQL and the content held on a Drobo. 2 ATV2s jailbroken and everything (ATV version 4.2.1) I passworded the shares, for my TV and Movies along with the thumbnail share. Got mysql library functioning no problem, but no thumbnails for ANYTHING! What was the problem? I forgot to give XBMC the user/pass for the thumbnails! Did that, wiped the DB, re-ran the library scan, and everything appears to work perfectly! Just a heads up for anyone with this kind of problem. RE: My Working Setup (Updated for Eden) - adsharp - 2012-04-16 (2011-02-28, 00:57)TheRealDL Wrote: This is my first post. For anyone using this setup, (as I have been for the last year or so), Eden changes the name of the databases, requiring permissions to be added for the new database names to effectively use the "watched flag" and "stop position". Essentially, open a query window and execute: Code: GRANT ALL ON xbmc_video57.bookmark TO 'atv2'; RE: [AppleTV2] MySQL database / library support? - jmarshall - 2012-04-16 Read the wiki. XBMC need permissions to create databases. Never, ever, create databases yourself. RE: [AppleTV2] MySQL database / library support? - acyclovir - 2012-10-02 Hi, i have made a pathsubstitution, advancedsettings.xml etc.. to share databases between my atv2, and my mac mini, mysql database is located in my synology ds, every thing works perfectly except for: logos, clear arts, same as all artwork downloader´s stuff; there is no skin capable of read any of them, i have given the needed permissions, i am using protected smb, but artwork downloader seems not to like protected smb, is there any one could help me Thanks in advance (sorry about my poor english) |