Bugzilla – Bug 8134
Unknown database 'slimserver'
Last modified: 2008-05-19 11:34:46 UTC
I'm trying to get squeezecenter to work on my Ubuntu Server 8.04 box. First it wouldn't start due to bug 7580. I followed the instructions from comment 13 on that bug and got a little further, but it still won't start. Now it keeps repeating these lines every five seconds in server.log: [08-05-12 23:11:24.5851] Slim::Schema::Storage::throw_exception (67) Error: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=slimserver:mysql_socket=/var/lib/squeezecenter/cache/squeezecenter-mysql.sock','slimserver',...) failed: Unknown database 'slimserver' at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 652 [08-05-12 23:11:24.5858] Slim::Schema::Storage::throw_exception (67) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 67) frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 658) frame 2: DBIx::Class::Storage::DBI::_connect (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 616) frame 3: DBIx::Class::Storage::DBI::_populate_dbh (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 543) frame 4: DBIx::Class::Storage::DBI::ensure_connected (/usr/share/perl5/Slim/Schema/Storage.pm line 27) frame 5: (eval) (/usr/share/perl5/Slim/Schema/Storage.pm line 27) frame 6: Slim::Schema::Storage::dbh (/usr/share/perl5/Slim/Schema.pm line 121) frame 7: Slim::Schema::init (/usr/share/perl5/Slim/Music/Info.pm line 76) frame 8: Slim::Music::Info::init (/usr/sbin/squeezecenter-server line 348) frame 9: main::init (/usr/sbin/squeezecenter-server line 451) frame 10: main::main (/usr/sbin/squeezecenter-server line 1005) [08-05-12 23:11:24.5866] Slim::Schema::init (124) Error: Couldn't connect to database! Fatal error: [] Exiting! [08-05-12 23:11:24.5871] Slim::Schema::init (124) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema.pm line 124) frame 1: Slim::Schema::init (/usr/share/perl5/Slim/Music/Info.pm line 76) frame 2: Slim::Music::Info::init (/usr/sbin/squeezecenter-server line 348) frame 3: main::init (/usr/sbin/squeezecenter-server line 451) frame 4: main::main (/usr/sbin/squeezecenter-server line 1005) [08-05-12 23:11:24.5879] Slim::Schema::forceCommit (1363) Warning: Trying to commit transactions before DB is initialized! [08-05-12 23:11:24.5912] Slim::Schema::Storage::throw_exception (67) Error: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=slimserver:mysql_socket=/var/lib/squeezecenter/cache/squeezecenter-mysql.sock','slimserver',...) failed: Unknown database 'slimserver' at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 652 [08-05-12 23:11:24.5919] Slim::Schema::Storage::throw_exception (67) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 67) frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 658) frame 2: DBIx::Class::Storage::DBI::_connect (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 616) frame 3: DBIx::Class::Storage::DBI::_populate_dbh (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 543) frame 4: DBIx::Class::Storage::DBI::ensure_connected (/usr/share/perl5/Slim/Schema/Storage.pm line 27) frame 5: (eval) (/usr/share/perl5/Slim/Schema/Storage.pm line 27) frame 6: Slim::Schema::Storage::dbh (/usr/share/perl5/Slim/Schema.pm line 244) frame 7: (eval) (/usr/share/perl5/Slim/Schema.pm line 244) frame 8: Slim::Schema::disconnect (/usr/sbin/squeezecenter-server line 964) frame 9: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 368) frame 10: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm line 402) frame 11: Slim::bootstrap::theEND (/usr/sbin/squeezecenter-server line 1001) frame 12: main::END (/usr/sbin/squeezecenter-server line 0) frame 13: (eval) (/usr/sbin/squeezecenter-server line 0) 2008-05-12 23:11:25 SqueezeCenter died. Restarting. I stopped my normal mysqld to make sure that wasn't interfering but that made no difference. The squeezecenter mysqld appears to be running according to ps. I tried starting squeezecenter after having made sure that there were no running mysqld's, but that made no difference. I already tried purging squeezecenter and installing it again, but that didn't help either. The way I installed was by adding your repository to sources.list and using apt-get. Is it correct that slimserver and squeezecenter are not in the official Ubuntu repositories? I keep finding hints that they should be... I will provide any debug or log information that may help if someone tells me how to generate it. My hardware is as follows: Intel Pentium 4 2 GHz 768 MB RAM
Ross, can you investigate this
Could you please try 7.0.1? Also, please try downloading the .deb file from here: http://www.slimdevices.com/downloads/SqueezeCenter_v7.0.1/
I installed the file using dpkg -i and then had to fix the broken dependencies with apt-get -f install. At first it still didn't work, failing with almost exactly the same message. Then I tried a dpkg-reconfigure squeezecenter, and then it appeared to start up correctly! It did leave the following messages in the server.log: 2008-05-17 13:58:21 squeezecenter_safe started. [08-05-17 13:58:29.2639] Slim::Schema::init (151) Warning: Creating new database - empty database or database from 6.3.x found [08-05-17 13:58:32.6303] Slim::Utils::PluginManager::enablePlugins (374) Couldn't load Slim::Plugin::PreventStandby::Plugin. Error: [-5] [08-05-17 13:58:32.9823] main::checkDataSource (873) Warning: Schema updated or no tracks in the database, initiating scan. [08-05-17 13:58:33.0327] Slim::Networking::mDNS::startAdvertising (110) Error: Couldn't find mDNSResponderPosix binary! Aborting! I could now connect to port 9000 and set up the server. So the PreventStandby plugin could not be loaded, whatever that is, and it couldn't find mDNSResponderPostfix, whatever that is. Do I need either of those? The installation procedure seems a bit involved, surely a simple apt-get install squeezecenter ought to do all this automatically?
http://wiki.slimdevices.com/index.php/DebianPackage The Ubuntu / Debian installation process is documented in the wiki. Installing by downloading the .deb file with package installer should be straight forward enough. I'll close this bug for now, if anyone else is seeing this or feels it should be re-opened please go ahead and do so and comment accordingly.