|
Its been a little while running SQLite, and I thought I would chime in an give you a "report from the field"...
1. I have seen no slow-downs in Slimserver's response, either from the web or from the SB itself. It's as snappy as the day I hooked in MySQL.
2. Both my SB2 and SB3 have not had a single problem with disconnects, dropouts, timeouts, etc. I used to get these about twice a day (I listen to the SB2 at work, all day). They were irritating, and were the only problem I had with the SB units.
In summary, the MySQL upgrade has made the SB devices work solidly. Better, to the point where I am planning on buying more SB3s (hear that Slimdevices, inc.? - a MySQL back end is fueling SB sales).
If you have the resources to load MySQL as back-end to your Slimserver, I can't recommend it enough...
Dave Strickler
MailWise LLC 617-933-5810 (direct) www.mailwise.com "Intelligent E-mail Protection" >>> [EMAIL PROTECTED] 8:20 AM Wednesday, January 25, 2006 >>> 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 ---------------------------- 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
