Arch Linux

burra

Member

From: Vaasa, Finland

Registered: 2006-05-26

Posts: 54

slimserver and mysql setup problems

Hi,
trying to set up slimserver om my archlinux box, but with great problems.

Version info

pacman -Q mysql perl-dbi slimserver
mysql 5.0.41-1
perl-dbi 1.56-1
slimserver v6.5.2-1

What I have done so fare.

Installed the slimserver.

pacman -Sy slimserver

created database in mysql

mysql> create database slimserver;
Query OK, 1 row affected (0.22 sec)

mysql> grant all on slimserver.* to slimserver identified by 'lame_password';
Query OK, 0 rows affected (0.13 sec)

mysql> flush privileges;
Query OK,

mysql> quit

Started slimserver once to get /home/slimserver/.slimserver.pref

/etc/rc.d/slimserver start

Edited the .slimserver.pref file to set my password

dbpassword: lame_password
dbsource: dbi:mysql:hostname=127.0.0.1;port=9092;database=%s
dbusername: slimserver

The server in not starting and I get this message in my /var/log/slimserver.log

2007-07-05 15:56:17.0131 Warning: Migrating from 6.3.x used with MySQL!
Database error: Can't create table './slimserver/years.frm' (errno: 121) at /home/slimserver/CPAN/DBIx/Migration.pm line 115.

I searched the slimserver forum and found this thread, but the guy did not get any help.
http://forums.slimdevices.com/showthrea … x+MySQL%21

Need help

tomk

Forum Fellow

From: Ireland

Registered: 2004-07-21

Posts: 9,839

Re: slimserver and mysql setup problems

My .pref file has

dbsource: dbi:mysql:database=slimserver

as per the recommended howto here. Try that and see how it goes.

burra

Member

From: Vaasa, Finland

Registered: 2006-05-26

Posts: 54

Re: slimserver and mysql setup problems

Hi,
have tried that but I tried it again. I now get the following message in my /var/log/slimserver.log

2007-07-05 17:34:13.3956 ERROR: DBI Connection failed: DBI connect('database=slimserver:mysql_socket=/tmp/mysql.
sock','slimserver',...) failed: Access denied for user 'slimserver'@'localhost' (using password: YES) at /home/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 652

2007-07-05 17:34:13.3961 ERROR: Backtrace follows:

2007-07-05 17:34:13.3965 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (/home/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 658)
   frame 1: DBIx::Class::Storage::DBI::_connect (/home/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 616)
   frame 2: DBIx::Class::Storage::DBI::_populate_dbh (/home/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 543)
   frame 3: DBIx::Class::Storage::DBI::ensure_connected (/home/slimserver/Slim/Schema/Storage.pm line 28)
   frame 4: (eval) (/home/slimserver/Slim/Schema/Storage.pm line 28)
   frame 5: Slim::Schema::Storage::dbh (/home/slimserver/Slim/Schema.pm line 118)
   frame 6: Slim::Schema::init (/home/slimserver/Slim/Music/Info.pm line 71)
   frame 7: Slim::Music::Info::init (./slimserver.pl line 367)
   frame 8: main::init (./slimserver.pl line 444)
   frame 9: main::main (./slimserver.pl line 1072)

2007-07-05 17:34:13.3977 ERROR: Unable to connect to the database - trying to bring it up!

2007-07-05 17:34:13.7253 ERROR: DBI Connection failed: DBI connect('database=slimserver:mysql_socket=/tmp/mysql.
sock','slimserver',...) failed: Access denied for user 'slimserver'@'localhost' (using password: YES) at /home/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 652

2007-07-05 17:34:13.7257 ERROR: Backtrace follows:

2007-07-05 17:34:13.7261 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (/home/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 658)
   frame 1: DBIx::Class::Storage::DBI::_connect (/home/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 616)
   frame 2: DBIx::Class::Storage::DBI::_populate_dbh (/home/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 543)
   frame 3: DBIx::Class::Storage::DBI::ensure_connected (/home/slimserver/Slim/Schema/Storage.pm line 45)
   frame 4: (eval) (/home/slimserver/Slim/Schema/Storage.pm line 45)
   frame 5: Slim::Schema::Storage::dbh (/home/slimserver/Slim/Schema.pm line 118)
   frame 6: Slim::Schema::init (/home/slimserver/Slim/Music/Info.pm line 71)
   frame 7: Slim::Music::Info::init (./slimserver.pl line 367)
   frame 8: main::init (./slimserver.pl line 444)
   frame 9: main::main (./slimserver.pl line 1072)

2007-07-05 17:34:13.7265 ERROR: Unable to connect to the database - even tried restarting it twice!

2007-07-05 17:34:13.7266 ERROR: Check the event log for errors on Windows. Fatal. Exiting.

It seems that it don't get any connection to the mysql server now.

Can it be some kind of permission problems?

//Burra

[edit bad wordwrapping in code]

Last edited by burra (2007-07-05 15:23:34)

burra

Member

From: Vaasa, Finland

Registered: 2006-05-26

Posts: 54

Re: slimserver and mysql setup problems

Hi,
ok found the answer, read to the end as it is called

this was the magical line

http://wiki.slimdevices.com/index.cgi?E … QLInstance

 

In some MySql installations it is necessary to qualify the username with localhost when granting permissions (refer to instructions above):

mysql> grant all on slimserver.* to 'slimserver'@'localhost' identified by 'slimserver_password';
Query OK, 0 rows affected (0.13 sec)

Thanks for the fast response tomk

//Burra