[AppleTV2] MySQL database / library support? - Printable Version
+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: iOS support (/forumdisplay.php?fid=137)
+---- Thread: [AppleTV2] MySQL database / library support? (/showthread.php?tid=91485)
- vicbitter - 2011-02-10 10:15
transcender Wrote:yep found that other thread w/ skip-resolve-name got me up and running thanks (weird as i was using IPs)
In the substitution <to>smb://user:firstname.lastname@example.org/c/Thumbnails/Thumbnails</to> after the IP address is the share (and directory) of your Thumbnails which will be unique to your set up.
- cgravelle - 2011-02-10 16:30
turbinez Wrote:what are the benefits of having your xbmc database on a mysql server as oppose to the default way? Is it easy to setup?
If you have multiple instances of xbmc, they all refer to the same database. Therefore, if one gets marked as watched, or you stop a video part way through (lets say in the living room), then all other instances will show that first show as watched, and you can resume watching the paused video from the same spot in another instance (lets say living room).
It also means that if you add another xbmc device or wipe a device and start from scratch while testing, you don't loose your watched markings and it doesn't have to do all the scraping again.
- transcender - 2011-02-10 16:43
vicbitter Wrote:In the substitution <to>smb://user:email@example.com/c/Thumbnails/Thumbnails</to> after the IP address is the share (and directory) of your Thumbnails which will be unique to your set up.
I shared out the /thumbnails folder on my WIN server
not working though :/
- vicbitter - 2011-02-10 17:56
transcender Wrote:I shared out the /thumbnails folder on my WIN server
Are you able to post your log file (via pastebin)? Have the Thumbnails already been generated via another XBMC client?
- transcender - 2011-02-10 19:17
Yes, I will try to post when I get home as my ipad is with me currently
I scraped w/ main machine Acer Revo on linux.
On windows server hosting media and MySQL
I've scripted backup of /xbmc folder from Revo via WinSCP to Win server
I shared the /thumbnails folder wide open even to XBMC user
on ipad i put path subsitution to the shared thumbnail folder on the win server
My logs looks much like the others whom have posted snippets, but I'll try to post that pastebin.
- transcender - 2011-02-12 10:48
vicbitter Wrote:Are you able to post your log file (via pastebin)? Have the Thumbnails already been generated via another XBMC client?Its either pretty slow or still buggy but i got it at least pulling some images by using just 'profile' vs 'masterprofile'
Even w/ 802.11n its kinda slow to pull thumbs, fanarts fairly quick on iPad.
But I've finally fully migrated from local myvideos.mdb to centralized MySQL dbase it wasn't easy but now that its over, I'm fairly happy :
Problematic windows install MySQL install resolved by manually adding entry to windows firewall (even though its not enabled?)
MySQL required strange DNS setting even though I was using fixed IPs.
WinSCP script to backup Revo (thumbnails) with binary and ascii mode for xml/logs
Script to parse NFOs and update database directly finally converted from previous one that was running against the myvideos.mdb ported to version that will run vs MySQL this is easier now as I can update/correct now without transerring the mdb back/forth
Resolved path substition to iPad w/ the above.
Thanks to those whom provided insight.
Note with iPad is using a centralized database and no real easy way to access the file system easily makes XBMC hang/crash
So using it to watch local vids would be problematic. Obviously on a plane ride or somethign nice to transfer vids w/ converting and watch on XBMC ...Would be nice to put a hard timeout or something?
- tmmurri - 2011-02-13 06:22
WisdomWolf Wrote:I created an advancedsettings.xml on my iPad and it shows my mySQL library correctly (although no thumbs, obviously). However it won't play anything. Every time I go to play a video it just says that it's no longer available. I don't get it, I can access the shares via the file view (videos) and I know the database has the right SMB links because I use it with a revo and two MacBooks as well. Any ideas?
I am having the same problem. Can someone PLEASE help me with this issue?
- joshua.lyon - 2011-02-14 00:58
tmmurri Wrote:I am having the same problem. Can someone PLEASE help me with this issue?I'm also struggling to get remote thumbnails working. My main box is an XBMC (Live) setup on Ubuntu 10.10. I have the thumbnails exposed via a samba share and I've tried a number of different path substitution setups, but still can't get it to work. I would prefer to get the thumbnails working over samba, but I'm going to try out an rsync setup to see if that will at least get me by for the time being...
- matbor - 2011-02-14 01:22
Hi all, hoping someone can clarify something for me about the remote thumbnails. If all my TVShow and Movie folders have the NFO, TBN, JPG files in each folder already, because I use a 3rd party scrapper (sickbread/couchpotato) then I don't need to worry about having an additional remote thumbnail directory!>?
- transcender - 2011-02-14 04:22
matbor Wrote:Hi all, hoping someone can clarify something for me about the remote thumbnails. If all my TVShow and Movie folders have the NFO, TBN, JPG files in each folder already, because I use a 3rd party scrapper (sickbread/couchpotato) then I don't need to worry about having an additional remote thumbnail directory!>?
False. I think if you read from the nature of this thread's 7 pages thus far, this is not correct. More generic info can be found on the wikis.
Many people use 3rd party scrapers. That just gives you a static place to pull from the LAN vs WAN when scraping initially but that information is still cached locally in the databases as well as the images, which are NOT in the database.
The images and library information shown in XBMC don't come from those 3rd party files. The information comes from the database and the images the locally cached images on the client.
Those nfos/jpgs....blah blah are just there for the scrape into XBMC and not used again. If you watch a file and it gets 'mark as watched', its marked as watched in the database NOT your NFO.