| Summary: | media-sound/squeezeboxserver-7.5.1 fails to connect to database | ||
|---|---|---|---|
| Product: | Gentoo Linux | Reporter: | Liriel <lassi> |
| Component: | Current packages | Assignee: | Joe Peterson (RETIRED) <lavajoe> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | stuart |
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | AMD64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Package list: | Runtime testing required: | --- | |
Sorry you're having trouble. There might be a problem with the database connection, but I think it might be a red-herring. I think the first thing to understand is the report that something already has port 9090 open - you shouldn't see that error if everything is working OK. Can you run the following command, which should print details of the process that has that port open: lsof -i TCP:9090 Before you try to start the server there should be nothing with that port open, which should therefore print nothing. As an example, on my server it prints the following when the server is running OK: COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME perl 1859 squeezeboxserver 10u IPv4 3602 0t0 TCP *:9090 (LISTEN) Sorry - should have mentioned that you might need to "emerge lsof" if the command isn't found. Thanks for the hint!
lsof showed that XBMC was using port 9090 (for some JSON RPC interface I guess):
# lsof -i TCP:9090
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
xbmc.bin 14004 xbmc 29u IPv4 674818 0t0 TCP ariel.lassi.net:9090 (LISTEN)
but the DB connection error still occours as soon as the wizard is finished...
here's the latest log:
[10-08-16 08:36:44.3365] main::init (323) Starting Squeezebox Server (v7.5.1, r30836, Tue Jun 1 07:00:00 MDT 2010) perl 5.012001
[10-08-16 08:39:07.8311] Slim::Schema::Storage::throw_exception (82) Error: DBI Connection failed: DBI connect('database=squeezeboxserver;mysql_socket=/var/run/mysqld/mysqld.sock','squeezeboxserver',...) failed: Access denied for user 'squeezeboxserver'@'localhost' (using password: YES) at /usr/lib64/perl5/vendor_perl/5.12.1/DBIx/Class/Storage/DBI.pm line 1052
[10-08-16 08:39:07.8325] Slim::Schema::Storage::throw_exception (82) Backtrace:
frame 0: Slim::Utils::Log::logBacktrace (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception (/usr/lib64/perl5/vendor_perl/5.12.1/DBIx/Class/Storage/DBI.pm line 1076)
frame 2: DBIx::Class::Storage::DBI::_connect (/usr/lib64/perl5/vendor_perl/5.12.1/DBIx/Class/Storage/DBI.pm line 906)
frame 3: DBIx::Class::Storage::DBI::_populate_dbh (/usr/lib64/perl5/vendor_perl/5.12.1/DBIx/Class/Storage/DBI.pm line 842)
frame 4: DBIx::Class::Storage::DBI::ensure_connected (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema/Storage.pm line 41)
frame 5: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema/Storage.pm line 41)
frame 6: Slim::Schema::Storage::dbh (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema.pm line 290)
frame 7: Slim::Schema::_connect (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema.pm line 126)
frame 8: Slim::Schema::init (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/Import.pm line 744)
frame 9: Slim::Music::Import::_checkLibraryStatus (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/Import.pm line 677)
frame 10: Slim::Music::Import::useImporter (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/MusicFolderScan.pm line 48)
frame 11: Slim::Music::MusicFolderScan::init (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Utils/Prefs.pm line 769)
frame 12: Slim::Utils::Prefs::__ANON__ (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Utils/Prefs/Base.pm line 307)
frame 13: Slim::Utils::Prefs::Base::set (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/Settings/Server/Wizard.pm line 106)
frame 14: Slim::Web::Settings::Server::Wizard::handler (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 1118)
frame 15: Slim::Web::HTTP::generateHTTPResponse (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 924)
frame 16: Slim::Web::HTTP::processURL (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 735)
frame 17: Slim::Web::HTTP::processHTTP (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 139)
frame 18: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 123)
frame 19: Slim::Networking::IO::Select::__ANON__ (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 183)
frame 20: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 183)
frame 21: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line 627)
frame 22: main::idle (/usr/sbin/squeezeboxserver line 581)
frame 23: main::main (/usr/sbin/squeezeboxserver line 1073)
[10-08-16 08:39:07.8337] Slim::Schema::init (129) Error: Couldn't connect to database! Fatal error: [] Exiting!
[10-08-16 08:39:07.8348] Slim::Schema::init (129) Backtrace:
frame 0: Slim::Utils::Log::logBacktrace (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema.pm line 129)
frame 1: Slim::Schema::init (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/Import.pm line 744)
frame 2: Slim::Music::Import::_checkLibraryStatus (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/Import.pm line 677)
frame 3: Slim::Music::Import::useImporter (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/MusicFolderScan.pm line 48)
frame 4: Slim::Music::MusicFolderScan::init (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Utils/Prefs.pm line 769)
frame 5: Slim::Utils::Prefs::__ANON__ (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Utils/Prefs/Base.pm line 307)
frame 6: Slim::Utils::Prefs::Base::set (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/Settings/Server/Wizard.pm line 106)
frame 7: Slim::Web::Settings::Server::Wizard::handler (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 1118)
frame 8: Slim::Web::HTTP::generateHTTPResponse (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 924)
frame 9: Slim::Web::HTTP::processURL (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 735)
frame 10: Slim::Web::HTTP::processHTTP (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 139)
frame 11: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 123)
frame 12: Slim::Networking::IO::Select::__ANON__ (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 183)
frame 13: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 183)
frame 14: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line 627)
frame 15: main::idle (/usr/sbin/squeezeboxserver line 581)
frame 16: main::main (/usr/sbin/squeezeboxserver line 1073)
(In reply to comment #3) > but the DB connection error still occours as soon as the wizard is finished... Are you definitely sure the --config step was run OK? Try the following command - this should try to connect to MySQL with the same method, username and password that SBS will try: mysql -S /var/run/mysqld/mysqld.sock --user=$(grep ^dbusername /etc/squeezeboxserver/prefs/server.prefs | cut -d' ' -f2) --password=$(grep ^dbpassword /etc/squeezeboxserver/prefs/server.prefs | cut -d' ' -f2) Does that connect OK? If not, you can try re-running the --config step and putting in a new username and password: emerge --config =media-sound/squeezeboxserver-7.5.1 (In reply to comment #4) Thank you for pointing out the /etc/squeezeboxserver/prefs/server.prefs file. It seems that emerge --config only changes /etc/squeezeboxserver/squeezeboxserver.prefs. I changed the password in the server.prefs file and everything works as expected. Thanks again for your help! (In reply to comment #5) > (In reply to comment #4) > > Thank you for pointing out the /etc/squeezeboxserver/prefs/server.prefs file. > It seems that emerge --config only changes > /etc/squeezeboxserver/squeezeboxserver.prefs. > > I changed the password in the server.prefs file and everything works as > expected. > > Thanks again for your help! > Thanks for the report - yes I think there's a bug with the --config step. I've made a note of that and will update it for the next version of the ebuild - thanks for looking into it. |
I have successfully emerged media-sound/squeezeboxserver-7.5.1. After running emerge --config I could start the deamon and access the wizard page. After the wizard is completed the server tries to connect to the database and fails. if I try to connect to the DB using the mysql user and pw manually everything works fine here's my /var/log/squeezeboxserver/server.log: [10-08-15 17:11:10.2300] main::init (323) Starting Squeezebox Server (v7.5.1, r30836, Tue Jun 1 07:00:00 MDT 2010) perl 5.012001 [10-08-15 17:11:13.9518] Slim::Plugin::CLI::Plugin::cli_socket_open (166) Can't setup the listening port 9090: Address already in use [10-08-15 17:11:13.9535] Slim::Utils::PluginManager::load (330) Warning: Couldn't call Slim::Plugin::CLI::Plugin->initPlugin: Can't setup the listening port 9090: Address already in use at /usr/lib/squeezeboxserver/Log/Log4perl/Logger.pm line 900 [10-08-15 17:12:05.3861] Slim::Schema::Storage::throw_exception (82) Error: DBI Connection failed: DBI connect('database=squeezeboxserver;mysql_socket=/var/run/mysqld/mysqld.sock','squeezeboxserver',...) failed: Access denied for user 'squeezeboxserver'@'localhost' (using password: YES) at /usr/lib64/perl5/vendor_perl/5.12.1/DBIx/Class/Storage/DBI.pm line 1052 [10-08-15 17:12:05.3877] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/usr/lib64/perl5/vendor_perl/5.12.1/DBIx/Class/Storage/DBI.pm line 1076) frame 2: DBIx::Class::Storage::DBI::_connect (/usr/lib64/perl5/vendor_perl/5.12.1/DBIx/Class/Storage/DBI.pm line 906) frame 3: DBIx::Class::Storage::DBI::_populate_dbh (/usr/lib64/perl5/vendor_perl/5.12.1/DBIx/Class/Storage/DBI.pm line 842) frame 4: DBIx::Class::Storage::DBI::ensure_connected (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema/Storage.pm line 41) frame 5: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema/Storage.pm line 41) frame 6: Slim::Schema::Storage::dbh (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema.pm line 290) frame 7: Slim::Schema::_connect (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema.pm line 126) frame 8: Slim::Schema::init (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/Import.pm line 744) frame 9: Slim::Music::Import::_checkLibraryStatus (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/Import.pm line 677) frame 10: Slim::Music::Import::useImporter (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/MusicFolderScan.pm line 48) frame 11: Slim::Music::MusicFolderScan::init (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Utils/Prefs.pm line 769) frame 12: Slim::Utils::Prefs::__ANON__ (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Utils/Prefs/Base.pm line 307) frame 13: Slim::Utils::Prefs::Base::set (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/Settings/Server/Wizard.pm line 106) frame 14: Slim::Web::Settings::Server::Wizard::handler (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 1118) frame 15: Slim::Web::HTTP::generateHTTPResponse (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 924) frame 16: Slim::Web::HTTP::processURL (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 735) frame 17: Slim::Web::HTTP::processHTTP (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 139) frame 18: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 123) frame 19: Slim::Networking::IO::Select::__ANON__ (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 183) frame 20: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 183) frame 21: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line 627) frame 22: main::idle (/usr/sbin/squeezeboxserver line 581) frame 23: main::main (/usr/sbin/squeezeboxserver line 1073) [10-08-15 17:12:05.3891] Slim::Schema::init (129) Error: Couldn't connect to database! Fatal error: [] Exiting! [10-08-15 17:12:05.3903] Slim::Schema::init (129) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Schema.pm line 129) frame 1: Slim::Schema::init (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/Import.pm line 744) frame 2: Slim::Music::Import::_checkLibraryStatus (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/Import.pm line 677) frame 3: Slim::Music::Import::useImporter (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Music/MusicFolderScan.pm line 48) frame 4: Slim::Music::MusicFolderScan::init (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Utils/Prefs.pm line 769) frame 5: Slim::Utils::Prefs::__ANON__ (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Utils/Prefs/Base.pm line 307) frame 6: Slim::Utils::Prefs::Base::set (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/Settings/Server/Wizard.pm line 106) frame 7: Slim::Web::Settings::Server::Wizard::handler (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 1118) frame 8: Slim::Web::HTTP::generateHTTPResponse (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 924) frame 9: Slim::Web::HTTP::processURL (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Web/HTTP.pm line 735) frame 10: Slim::Web::HTTP::processHTTP (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 139) frame 11: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 123) frame 12: Slim::Networking::IO::Select::__ANON__ (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 183) frame 13: (eval) (/usr/lib64/perl5/vendor_perl/5.12.1/Slim/Networking/IO/Select.pm line 183) frame 14: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line 627) frame 15: main::idle (/usr/sbin/squeezeboxserver line 581) frame 16: main::main (/usr/sbin/squeezeboxserver line 1073) I am using perl 5.12.1-r1 on amd64 My emerge --info: Portage 2.1.8.3 (default/linux/amd64/10.0, gcc-4.4.4, glibc-2.11.2-r0, 2.6.34-gentoo-r1 x86_64) ================================================================= System uname: Linux-2.6.34-gentoo-r1-x86_64-Intel-R-_Atom-TM-_CPU_330_@_1.60GHz-with-gentoo-2.0.1 Timestamp of tree: Wed, 04 Aug 2010 06:30:01 +0000 ccache version 2.4 [enabled] app-shells/bash: 4.1_p7 dev-lang/python: 2.4.6, 2.6.5-r3, 3.1.2-r4 dev-util/ccache: 2.4-r8 dev-util/cmake: 2.8.1-r2 sys-apps/baselayout: 2.0.1 sys-apps/openrc: 0.6.1-r1 sys-apps/sandbox: 2.2 sys-devel/autoconf: 2.13, 2.65-r1 sys-devel/automake: 1.10.3, 1.11.1 sys-devel/binutils: 2.20.1-r1 sys-devel/gcc: 4.4.4-r1 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.2.10 virtual/os-headers: 2.6.34 ACCEPT_KEYWORDS="amd64 ~amd64 ~x86" ACCEPT_LICENSE="* -@EULA AdobeFlash-10.1 AdobeFlash-10" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-march=core2 -mtune=native -Os -pipe -fomit-frame-pointer -mfpmath=sse -mmmx -msse -msse2 -msse3 -mssse3 -mcx16 -msahf" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo" CXXFLAGS="-march=core2 -mtune=native -Os -pipe -fomit-frame-pointer -mfpmath=sse -mmmx -msse -msse2 -msse3 -mssse3 -mcx16 -msahf" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests ccache distlocks fixpackages news parallel-fetch protect-owned sandbox sfperms strict unmerge-logs unmerge-orphans userfetch" GENTOO_MIRRORS="http://gd.tuwien.ac.at/opsys/linux/gentoo/" LDFLAGS="-Wl,-O1 -Wl,--as-needed" LINGUAS="en en_US" MAKEOPTS="-j5" PKGDIR="/usr/portage/packages" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="3dnow X a52 acl alsa amd64 apache2 berkdb bzip2 cli consolekit cracklib crypt cups cxx dbus dri dv dvb dvd dvdread encode extrafilters fame gdbm gif gpm gtk icecast iconv imagemagick ithreads ivtv javascript jpeg lirc lzo mjpeg mmx mmx2 modules mp3 mpeg mudflap multilib mysql ncurses network nls nowin nptl nptlonly nvidia ogg opengl openmp pam pcre perl png pppd python qt3support quicktime readline reflection sdl session spl sqlite sse sse2 ssl svg sysfs tcpd theora threads transcode truetype unicode v4l v4l2 vcd vcdimager vdpau vorbis winbind xine xinerama xml xorg xv xvid zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="access auth auth_dbm auth_anon auth_digest auth_basic authn_file authz_user alias file-cache echo charset-lite cache disk-cache mem-cache ext-filter case_filter case-filter-in deflate mime-magic cern-meta expires headers usertrack unique-id proxy proxy_connect proxy_ftp proxy_http info include cgi cgid dav dav-fs vhost-alias speling rewrite log_config logio env setenvif mime status autoindex asis negotiation dir imap actions userdir so filter authz_host" ELIBC="glibc" INPUT_DEVICES="evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en en_US" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="nvidia" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS