Posts: 12
Joined: Jun 2011
Reputation:
0
well, I tryed on ATV2 and after removing <name> from the xml I was able to get it working.... Now I have to wait to openelec has eden working....
Posts: 15
Joined: Dec 2010
Reputation:
0
frr792
Junior Member
Posts: 15
Does the mySQL library and userdata/Thumbnails only update when an Import Library is completed?
If new movies/tvshows are added to the NAS, and xbmc does a auto update library, do these additions make it to the mySQL DB?
My test..
added single folder of movies/tvshows
scanned for content
exported movies library
exited eden
adjusted advancedsettings.xml
updated NAS/userdata/Thumbnails
opened eden
imported movie library
exited eden
read mySQL DB with TOAD, import was successful, db was created and records created
opened eden
added more folders of movies/tvshows
ran update library
verified update library was successful
read mySQL DB with TOAD, update library was unsuccessful, db was unchanged
Posts: 151
Joined: Apr 2009
Reputation:
1
tdhz77
Senior Member
Posts: 151
2012-02-23, 14:02
(This post was last modified: 2012-02-23, 14:25 by tdhz77.)
I need help setting up MYSQL for OSX.
I downloaded mysql-5.5.21-osx10*dmg
Installed using the package file
Terminal>/usr/local/mysql/bin/mysql
I can't create users, nor do I know how to connect to database.
What am I missing, how do I create a databse, or connect to the database and create a user, so that I may continue?
Thanks.
UPDATE: sudo /usr/local/mysql/bin/mysql fixed my problem. All set. Sorry for being n00by.
Posts: 19
Joined: Dec 2011
Reputation:
0
Hello,
I plan to set this up on my new build.
I intend to have 1 windows and pc, and 2 ATV set ups. My Qnap nas also has a MySQL server built into it, and I'm hoping I can run the server from there. I am however curious as to how to get the file on the ATV. Any advice?
Posts: 31,445
Joined: Jan 2011
mikeprep Wrote:Hello,
I plan to set this up on my new build.
I intend to have 1 windows and pc, and 2 ATV set ups. My Qnap nas also has a MySQL server built into it, and I'm hoping I can run the server from there. I am however curious as to how to get the file on the ATV. Any advice?
http://wiki.xbmc.org/index.php?title=XBM...ecific_FAQ
Same instructions as adding an add-on by zip.
Posts: 10
Joined: Nov 2011
Reputation:
0
2012-03-07, 04:03
(This post was last modified: 2012-03-07, 04:38 by impmonkey.)
just set this up. Movies and Music went great! however I can now not get the Vevo Addon to show anything. I only setup the music and movie libraries so not sure whats up with this. Any ideas?
Tried removing and re-adding but nothing.
**NM I'm Retarded***
Posts: 2
Joined: Mar 2012
Reputation:
0
2012-03-14, 22:46
(This post was last modified: 2012-03-14, 22:58 by jad0083.)
This was how I envisioned a centralized XBMC would work in my environment:
File Server (OpenFiler, FreeNAS, UnRAID, or any other NAS) that would provide the actual Videos, Audio, ETC..
another server that has a linux distro that hosts the MySQL database
actual physical boxes with xbmc installed that can see the DB server and have the shared NAS folders Mounted via cifs, nfs, etc...)
gigabit network (affordable intel gb switches and nics nowadays)
And based on the theory above I have my setup like this:
*Server that has Esxi hosting a Server 2008 (DNS, AD,DC), PfSense(dhcp, routing, firewall), UbuntuServer(MySQL, Openfire, Calibre-Server, mumble, minecraft lol)
*Server that has Openfiler(Audio, Video, Pics, UserData, ETC...) serving multiple XFS volumes on several RAID 5s via cifs/smb and nfs
*Now with the setup above, I have my GPO settings to automatically map all the necessary shares from my SAN to any win boxes, so any other box that I add to my environment will automatically see those shares (video, audio, music, etc..)
*I'm pretty sure that you can setup your GPO to push advancedsettings.xml to the client boxes, so it automatically refreshes from a central location as well.
I currently have 2 windows boxes that have XBMC, and all I needed to do with them is modify the advancedsettings.xml to point to MySQL and the thumbnail shares
-=Modified the my.cnf (MySQL settings) and added "skip-name-resolve", solved the initial mysql slowness.=-
Pros:
*Adding new XBMC boxes is easy since it already skips the initial scraping (especially good if you have more than 300+ movies, tv shows, etc...)
*If in an AD environment, login and logoff are WAY faster, since it doesn't have to sync all the user files between the client and server everytime
*Granular modifications on the actual DB (I use Toad for MySQL), if you want/need to.
*Speed: I actually find this faster (but this is my experience), especially if your xbmc boxes are using slow Hdds (IDEs, low rpm drives), since all the streaming will be offloaded to the nic
*Easily more scalable
Cons:
*A little more complicated setup
*Expensive if you're just starting up (great if you already have the existing environment)
*More admin overhead
Im running RC2 btw, no issues so far (crossing fingers)
Posts: 729
Joined: Jun 2011
Reputation:
3
i want to do this but a bit too advanced for me i am actually suprised no one has created a program or addon to do this automatically already
Posts: 225
Joined: Sep 2008
Reputation:
0
Not much work, took me all of 10 minutes to install mysql and make an advancedsettings file. Did you follow the wiki? Don't follow the lifehacker article it is too old.