Bugzilla – Bug 5110
Fresh install of slimserver 6.5.2 does not connect to database
Last modified: 2007-06-12 13:03:34 UTC
I just tried downloading and installing 6.5.2 and could not get the server to start. Logs indicate it could not connect to the built-in mysql: 2007-06-07 09:59:21.7397 SlimServer setting language... 2007-06-07 09:59:21.7399 SlimServer MySQL init... 2007-06-07 09:59:21.7404 Firmware init... 2007-06-07 09:59:21.7416 SlimServer Info init... 2007-06-07 09:59:21.8540 ERROR: DBI Connection failed: DBI connect('database=slimserver','ert',...) failed: Unknown database 'slimserver' at /Library/PreferencePanes/SlimServer.prefPane/ Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 652 2007-06-07 09:59:21.8541 ERROR: Backtrace follows: 2007-06-07 09:59:21.8543 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 658) frame 1: DBIx::Class::Storage::DBI::_connect (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 616) frame 2: DBIx::Class::Storage::DBI::_populate_dbh (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 543) frame 3: DBIx::Class::Storage::DBI::ensure_connected (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Schema/Storage.pm line 28) frame 4: (eval) (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Schema/Storage.pm line 28) frame 5: Slim::Schema::Storage::dbh (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Schema.pm line 118) frame 6: Slim::Schema::init (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/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-06-07 09:59:21.8777 ERROR: Unable to connect to the database - trying to bring it up! 2007-06-07 09:59:21.8797 ERROR: DBI Connection failed: DBI connect('database=slimserver','ert',...) failed: Unknown database 'slimserver' at /Library/PreferencePanes/SlimServer.prefPane/ Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 652 ...I run MySQL myself. I note that http://wiki.slimdevices.com/index.cgi?ExistingMySQLInstance says that there should be no conflict: If you already have MySQL installed then there is no problem because this embedded MySQL instance will happily run alongside an existing MySQL server - they will not clash because SlimServer's version has been configured to use a different set of resources to those of a standard MySQL instance (in particular, the port number it listens on has been changed). ...however, on a whim I created a new database called 'slimserver' in my own mysql instance, and the server started up fine: 2007-06-07 10:14:09.2069 SlimServer MySQL init... 2007-06-07 10:14:09.2075 Firmware init... 2007-06-07 10:14:09.2088 SlimServer Info init... 2007-06-07 10:14:09.3229 Warning: Migrating from 6.3.x used with MySQL! 2007-06-07 10:14:10.1073 SlimServer IR init... I'm not sure if the built-in database didn't come up correctly, or if the server was incorrectly trying to talk to my mysql instance, but something's defintely mucked up. Mac OS X 10.4.9.
Hi Ert, Many, many mac users have successfully used 6.5.2 at this point. Do I understand you to say you are running a copy of mysql other than what we include with our installer? If so, your best chance of resolving your problem probably lies in posting to our forums at http://forums.slimdevices.com/, rather than in waiting for the QA team (which responds to bugs) to try to build up a system enough like yours to try to be of some help. If you are using our included mysql, your first stop should probably be support@slimdevices.com.
Yes, I have my own mysql install that was already running on my system when I installed 6.5.2, and I suspect that's the main issue. I'm satisfied with my own work-around of simply creating my database manually. I've actually been running slimserver off mysql for a year or two now on my home server, I've had to set up much earlier versions of slimserver with mysql and it's been fine. I was mainly trying to alert y'all to the possibility that the "embedded MySQL instance will happily run alongside an existing MySQL server" part of the system might not be working correctly, which seems rare enough that I might be the first one reporting it but common enough that others could be interested.
Bugzilla has no bug closure mechanism for 'This is good information for other users' so I'll have to settle for 'WORKSFORME'