XBMC Community Forum
[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)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26


- WisdomWolf - 2011-02-19 06:23

I can confirm that with the 2.17 build all is now working flawlessly.


- matbor - 2011-02-20 10:47

WisdomWolf Wrote:I can confirm that with the 2.17 build all is now working flawlessly.

working for me too.


- one800higgins - 2011-02-20 17:23

This is getting to be a large and popular topic. Does anyone want to provide a walkthrough / points / tips / benefits on how to properly get this running? Then the original poster can update his post to include this information to benefit the whole community. Plus it will cut down on a lot of repeat questions.


- thesuffering - 2011-02-20 23:00

ive noticed ever since i setup my database as mysql the whole interface as a whole runs slower on the atv2. even scrolling through menus can take 5-10 seconds to respond at times. I have the 2/17/11 nightly on the atv. on my other computers the interface runs just fine. any reason it would be doing this? i know running it through mysql can slow things somewhat, but even in the main menus? anybody elses complete interface running slow?


- thesuffering - 2011-02-20 23:05

one800higgins Wrote:This is getting to be a large and popular topic. Does anyone want to provide a walkthrough / points / tips / benefits on how to properly get this running? Then the original poster can update his post to include this information to benefit the whole community. Plus it will cut down on a lot of repeat questions.
http://lifehacker.com/#!5634515/how-to-synchronize-your-xbmc-media-center-across-every-room-in-the-househttp://forum.xbmc.org/showthread.php?tid=85654
http://www.contentwhores.com/wordpress/?page_id=432

then add advancedsettings.xml to/private/var/mobile/Library/Preferences/XBMC/


- freaksworth - 2011-02-20 23:06

thesuffering Wrote:ive noticed ever since i setup my database as mysql the whole interface as a whole runs slower on the atv2. even scrolling through menus can take 5-10 seconds to respond at times. I have the 2/17/11 nightly on the atv. on my other computers the interface runs just fine. any reason it would be doing this? i know running it through mysql can slow things somewhat, but even in the main menus? anybody elses complete interface running slow?
I noticed that behaviour when xbmc could not connct to the mysql-db. (eg. wrong version)
Do you have acces to your library from atv2?


- matbor - 2011-02-20 23:58

My ATV2 is working perfectly now, both with MySQL and thiumbnails, if only I could get them to work on my ATV1 ConfusedConfused Might dump it and just go buy another ATV2.


- Stiffler - 2011-02-20 23:58

one800higgins Wrote:This is getting to be a large and popular topic. Does anyone want to provide a walkthrough / points / tips / benefits on how to properly get this running? Then the original poster can update his post to include this information to benefit the whole community. Plus it will cut down on a lot of repeat questions.


I wish someone had done that this morning. I dedicated a fair bit of time to figuring everything out today. Still I'm very pleased with the results. On Friday I'd never touched XBMC and today I synced library implementations on two ATV2's via my NAS. I'm "chuffed" Big Grin


Having just done it as a newbie these are my brief Notes:

A good SSH client: PuTTY

Finding ATV2 IP address: Apple TV Home, Settings, General, About

Install the "Daily" XBMC release 17th Feb+ from Keith's - Unofficial builds for testing!

Follow Lifehacker guide to setting up central database for shared library

A SFTP client for Windows

I also noticed that the location to place the "advancedsettings.xml" in iOS is wrong (presumably it's for the ATV1). For me it's:
"/private/var/mobile/Library/Preferences/XBMC/userdata"


Thumbnails:
Create a new file location on the network to store thumbnails.
Add additional lines to "advancedsettings.xml" file, below is an example of mine in full (Red sections need to be updated with your own locations for MySQL and SMB Thumbnail folder)

Code:
<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>[color=Red]192.168.1.2[/color]</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>xbmc_video</name>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>[color=Red]192.168.1.2[/color]</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>xbmc_music</name>
    </musicdatabase>
    
    <pathsubstitution>
        <substitute>
            <from>special://masterprofile/Thumbnails</from>
            <to>[color=Red]smb://192.168.1.2/Volume_1/Media_Server/xbmc_thumbs/[/color]</to>
        </substitute>
    </pathsubstitution>
</advancedsettings>



- thesuffering - 2011-02-21 04:57

freaksworth Wrote:I noticed that behaviour when xbmc could not connct to the mysql-db. (eg. wrong version)
Do you have acces to your library from atv2?

yes, i do have access and movies will play.

you are saying wrong version possibly? you mean wrong mysql version? i have it currently running 5.1 essentials. should i be using a different version of mysql server?


- freaksworth - 2011-02-21 14:44

No! No need to change anything concernig mysql. I was talking about different xbmc internal database versions. (dharma/eden, etc,)
sorry, can't help you.