PDA

View Full Version : Debian Testing install clarification



teeitup
2007-12-15, 15:50
I'm trying to follow the instructions on the "Debian package" on the wiki.

While I'm pretty good with Linux, I don't know much about MySQL.

Could someone clarify the following for me:

- set the password and audiodir in /etc/slimserver/slimserver.pref
- create MySQL user and database (connect as root)
> grant all on slimserver.* to slimserver identified by 'the-password';
> create database slimserver;

Picked up my Squeezebox yesterday. The only issue I have left is playlists. I'm hoping following these steps will resolve my issue of not being able to create playlists.

Thanks

Randy

pfarrell
2007-12-15, 16:17
teeitup wrote:
> I'm trying to follow the instructions on the "Debian package" on the
> wiki.
>
> While I'm pretty good with Linux, I don't know much about MySQL.

While I've been using the SC nightly, on my debian box I just added the
repository and did apt-get install and it all worked.
No muss no fuss.

So I didn't have to play with any mysql stuff in the prefs file.

>
> Could someone clarify the following for me:
>
> - set the password and audiodir in /etc/slimserver/slimserver.pref

For SC7, its /etc/slimserver/server.pref

Those lines in mine look like:
dbpassword: ''
dbsource: dbi:mysql:hostname=127.0.0.1;port=9092;database=%s
dbusername: slimserver



> - create MySQL user and database (connect as root)

For MySql, the order is important, I always create the database first.
For that you use
mysqladmin create foodatabase

Then you can run mysql's client, called mysql to do the grants

mysql mysql -u root
grant....
flush privileges;
quit


Pat


--
Pat Farrell
http://www.pfarrell.com/

teeitup
2007-12-15, 21:39
Thank you fro the feedback...

> - create MySQL user and database (connect as root)

For MySql, the order is important, I always create the database first.
For that you use
mysqladmin create foodatabase

This is the output from trying to create the database:

[root@diablo:/etc/init.d/]
# ./slimserver stop
Stopping SlimServer Audio Server.

[root@diablo:/etc/init.d/]
# mysqladmin create slimserver
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

?

Mark Miksis
2007-12-16, 11:21
I'm not sure what problem the author of that wiki post was trying to solve, but none of those manual steps should be necessary. SlimServer will automatically create the necessary database with the correct permissions.

teeitup
2007-12-16, 15:03
Well for whatever it's worth, I made the "Auto Commit" change.

After stopping and starting SlimServer everything works perfectly.

I now have working playlists.

My music collection, , Squeeze Network, Live365, and Rhapsody, it's all working through my home entertainment system.

It's a beautiful thing.

-Randy

Mark Lanctot
2007-12-18, 11:10
I'm not sure what problem the author of that wiki post was trying to solve, but none of those manual steps should be necessary. SlimServer will automatically create the necessary database with the correct permissions.

This brings up a good point, that wiki page is pretty messed up with those last two entries. Neither one should be necessary and it has led to confusion in this case.

Should it be deleted? It seems like the sort of thing that belongs in a forum, not the wiki, as it's no longer valid.