|
Warning: I am a PostgreSQL guy, and I don't know beans about MySQL. I also don't profess to be a Linux expert. I can get around in SuSE, but I'm no expert with it either.
Understanding that, I thought I would let you know how I got MySQL working, as the Wiki was a great help, but wasn't complete (perhaps I should post this there).
First off, I use SuSE, which has to be the easiest Linux in the world. To get MySQL up and running, I start Yast (their installer GUI), picked MySQL, and it installed it for me. No CDs, and a 2 minute install. Did I mention I love Yast? ;-)
Then I used WebMin (already installed on the server) to make sure MySQL was indeed running. It was. I used WebMin to create a user in MySQL called "admin", and gave it all the privs I could find.
Now I looked at the DB/Tables I would need to create in MySQL. Unfortunately you need to do this by hand, as SlimServer doesn't do this for you when you switch over. Thankfully its all laid out in /usr/local/slimserver/SQL/mysql in a small text file called dbcreate.sql. Note that this file isn't part of SQL, it's just a text file.
Then I fired up MySQL by typing "mysql -u admin" which logged me into MySQL as Admin. While inside of MySQL, I needed to create the DB, so I typed "create database slimserver;" to create the database. And then "use slimserver;" to start using it.
Now I needed to create the Tables, so I typed "\. /usr/local/slimserver/SQL/mysql/dbcreate.sql". Note the backslash-dot in the beginning. This tells MySQL to read in the text file as a series of commands. This will return a bunch of OKs, indicating it has created all the DB/Tables. Now type "exit ;" to quit MySQL.
Now that the DB/Tables are all set up, follow the Wiki's instructions about altering your slimserver.conf file. It will need the username, in my case "admin", the password for that account that I set up when I created the account, and the name the of DB (I used "slimserver" above).
Once the config file is edited, stop Slimserver and restart it. Check to see that its still running after 5 seconds. If not, the config file isn't set right to get into MySQL. Check for typos, and also check the privs for the MySQL account (I used "admin"). I had these set wrong on my 1st attempt, and Slimserver wouldn't attach to MySQL, and also would silently crash.
If Slimserver stays loaded, go get a cup of coffee and let it automatically read all your songs from disk. I have about 12k of them, and it took under 2 min.
No go into the web interface, or fire up your SB, just like normal. You'll notice both interfaces are fast, especially the web interface. Zoom - this back-end with MySQL is super fast!
I hope this long email helps out someone who's struggling. Trust me, in the end, its worth the struggle!
---------------------------- This message has been certified virus-free by MailWise Filter - The real-time, intelligent, e-mail firewall used to scan inbound and outbound messages for SPAM, Viruses and Content. For more info visit: http://www.mailwise.com |
_______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
