Looks like the apparmor issues on ubuntu are back on the 7.4 SBS. When
updating from the nightlies and initially with 7.4.0, I had to stop the
apparmor service to allow the SBS Mysql instance to start. My server
log:
Code:
--------------------
2009-10-02 14:44:31 squeezeboxserver_safe stopped.
2009-10-02 14:45:18 squeezeboxserver_safe started.
[09-10-02 14:45:22.8863] main::init (320) Starting Squeezebox Server (v7.4.1,
r28740, Fri Oct 2 04:00:09 PDT 2009) perl 5.010000
[09-10-02 14:45:54.5811] Slim::Schema::Storage::throw_exception (82) Error:
DBI Connection failed: DBI
connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
failed: Can't connect to MySQL server on '127.0.0.1' (111) at
/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 950
[09-10-02 14:45:54.5816] Slim::Schema::Storage::throw_exception (82)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 972)
frame 2: DBIx::Class::Storage::DBI::_connect
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 814)
frame 3: DBIx::Class::Storage::DBI::_populate_dbh
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 753)
frame 4: DBIx::Class::Storage::DBI::ensure_connected
(/usr/share/perl5/Slim/Schema/Storage.pm line 41)
frame 5: (eval) (/usr/share/perl5/Slim/Schema/Storage.pm line 41)
frame 6: Slim::Schema::Storage::dbh (/usr/share/perl5/Slim/Schema.pm line 291)
frame 7: Slim::Schema::_connect (/usr/share/perl5/Slim/Schema.pm line 127)
frame 8: Slim::Schema::init (/usr/share/perl5/Slim/Music/Import.pm line 740)
frame 9: Slim::Music::Import::_checkLibraryStatus
(/usr/share/perl5/Slim/Music/Import.pm line 673)
frame 10: Slim::Music::Import::useImporter
(/usr/share/perl5/Slim/Music/MusicFolderScan.pm line 48)
frame 11: Slim::Music::MusicFolderScan::init (/usr/sbin/squeezeboxserver line
429)
frame 12: main::init (/usr/sbin/squeezeboxserver line 572)
frame 13: main::main (/usr/sbin/squeezeboxserver line 1103)
[09-10-02 14:45:54.5822] Slim::Schema::init (130) Error: Couldn't connect to
database! Fatal error: [Connection refused] Exiting!
--------------------
System is AMD64x2 ubuntu 9.04.
Initial update to 7.4.0 was done using Synaptic and removal of 7.3.4
was automatic.
Could it be that the apparmor profile was not modified properly?
/etc/apparmor.d/usr.sbin.mysqld now looks like this:
Code:
--------------------
# vim:syntax=apparmor
# Last Modified: Tue Jun 19 17:37:30 2007
#include <tunables/global>
/usr/sbin/mysqld {
#include <abstractions/base>
#include <abstractions/nameservice>
#include <abstractions/user-tmp>
#include <abstractions/mysql>
capability dac_override,
capability setgid,
capability setuid,
/etc/hosts.allow r,
/etc/hosts.deny r,
/etc/group m,
/etc/passwd m,
/etc/mysql/*.pem r,
/etc/mysql/conf.d/ r,
/etc/mysql/conf.d/* r,
/etc/mysql/my.cnf r,
/usr/sbin/mysqld mr,
/usr/share/mysql/** r,
/var/lib/mysql/ r,
/var/lib/mysql/** rwk,
/var/log/mysql/ r,
/var/log/mysql/* rw,
/var/run/mysqld/mysqld.pid w,
/var/run/mysqld/mysqld.sock w,
# SqueezeCenter Apparmor Changes for MySqld
/var/lib/squeezecenter/cache/ r,
/var/lib/squeezecenter/cache/my.cnf r,
/var/lib/squeezecenter/cache/mysql.startup rw,
/var/lib/squeezecenter/cache/mysql-error-log.txt rw,
/var/lib/squeezecenter/cache/squeezecenter-mysql.pid w,
/var/lib/squeezecenter/cache/squeezecenter-mysql.sock w,
/var/lib/squeezecenter/cache/MySQL/ r,
/var/lib/squeezecenter/cache/MySQL/** rwk,
# SqueezeBox Apparmor Changes for MySqld
/var/lib/squeezeboxserver/cache/ r,
/var/lib/squeezeboxserver/cache/my.cnf r,
/var/lib/squeezeboxserver/cache/mysql.startup rw,
/var/lib/squeezeboxserver/cache/mysql-error-log.txt rw,
/var/lib/squeezeboxserver/cache/squeezebox-mysql.pid w,
/var/lib/squeezeboxserver/cache/squeezebox-mysql.sock w,
/var/lib/squeezeboxserver/cache/MySQL/ r,
/var/lib/squeezeboxserver/cache/MySQL/** rwk,
}
--------------------
I'll clear the old ref to squeezecenter from the apparmor profile to
see if that solves the problem.
--
Ramage
P2 266MHz, ubuntu server 9.04 SC 7.4~27942
AMD64x2 ubuntu 9.04, SC 7.3.4~28263
Dell 10v WinXP SBS 7.4
Players: Classic, Duet, Boom, Controller
------------------------------------------------------------------------
Ramage's Profile: http://forums.slimdevices.com/member.php?userid=5343
View this thread: http://forums.slimdevices.com/showthread.php?t=68917
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
