Dave Strickler wrote:
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!
Thanks for the write-up. I've tried making the switch before without
luck, You encouraged me to try again. I've followed instructions on wiki
and here in forum, but my scan process only manages to successfully add
17 from 20.000 tracks. Error reports are similar (below) for every
unsuccessful track. This is W2000Server, Mysql5.0 and latest ActiveState
Perl. How do I know if my process uses "my Perl", or the libs included
in the slim_perlscript.zip distro?:
Thanks a million,
peter
2006-01-26 12:43:14.9154 DBD::mysql::st execute failed: Data truncated
for column 'secs' at row 1 at C:\Slimserver\CPAN/DBIx/ContextualFetch.pm
line 51.
2006-01-26 12:43:14.9573 Backtrace:
frame 0: Slim::DataStores::DBI::DBIStore::newTrack
(C:/Slimserver/Slim/DataStores/DBI/DBIStore.pm line 595)
frame 1: Slim::DataStores::DBI::DBIStore::updateOrCreate
(C:/Slimserver/Slim/DataStores/DBI/DBIStore.pm line 226)
frame 2: Slim::DataStores::DBI::DBIStore::objectForUrl
(C:/Slimserver/Slim/Web/Pages.pm line 1484)
frame 3: Slim::Web::Pages::browsetree
(C:/Slimserver/Slim/Web/HTTP.pm line 769)
frame 4: Slim::Web::HTTP::generateHTTPResponse
(C:/Slimserver/Slim/Web/HTTP.pm line 678)
frame 5: Slim::Web::HTTP::processURL (C:/Slimserver/Slim/Web/HTTP.pm
line 539)
frame 6: Slim::Web::HTTP::processHTTP
(C:/Slimserver/Slim/Networking/Select.pm line 111)
frame 7: Slim::Networking::Select::select
(C:\Slimserver\slimserver.pl line 634)
frame 8: main::idle (C:\Slimserver\slimserver.pl line 570)
frame 9: main::main (C:\Slimserver\slimserver.pl line 1226)
_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
