PDA

View Full Version : Solaris 10: MySQL problem......



wardjones
2007-12-27, 08:54
Hi there,

I知 new to slimdevices and am having a little trouble getting slimserver working on Solaris 10

I知 using the following:

Solaris 10 8/07 x86
MySQL 5.0.41 (from sunfreeware)
Perl 5.8.8 (built with Sun Studio 11 and all appropriate mods installed)
Slimserver 6.5.4

I致e run build-perl-modules.pl and got a working slimserver well sort of 

When I start slimserver using:

/opt/slimserver/slimserver.pl --cachedir=/opt/slimserver/cachedir \
--user=slimsrv --group=slimsrv \
--prefsfile=/opt/slimserver/cachedir/slimserver.pref \
--audiodir=/tmp \
--pidfile=/opt/slimserver/cachedir/slimserver.pid $*

I get the following:

2007-12-26 17:24:52.5580 UPnP: Error adding multicast membership, UPnP may not work properly: Option not supported by protocol
2007-12-26 17:24:52.5598 UPnP: Error setting multicast TTL: Option not supported by protocol
2007-12-26 17:24:53.7719 commit ineffective with AutoCommit enabled at /opt/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 706.
2007-12-26 17:24:53.7728 Commmit ineffective while AutoCommit is on at /opt/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 706.
2007-12-26 17:24:53.7742 ERROR: DBD::mysql::db commit failed: Commmit ineffective while AutoCommit is on at /opt/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 706.

2007-12-26 17:24:53.7747 ERROR: Backtrace follows:

2007-12-26 17:24:53.7756 Backtrace:

frame 0: Slim::Schema::throw_exception (/opt/slimserver/CPAN/DBIx/Class/Schema.pm line 606)
frame 1: DBIx::Class::Schema::txn_do (/opt/slimserver/Slim/Music/Import.pm line 241)
frame 2: (eval) (/opt/slimserver/Slim/Music/Import.pm line 233)
frame 3: Slim::Music::Import::setIsScanning (/opt/slimserver/Slim/Music/Import.pm line 152)
frame 4: Slim::Music::Import::launchScan (/opt/slimserver/Slim/Control/Commands.pm line 1958)
frame 5: Slim::Control::Commands::wipecacheCommand (/opt/slimserver/Slim/Control/Request.pm line 1483)
frame 6: (eval) (/opt/slimserver/Slim/Control/Request.pm line 1483)
frame 7: Slim::Control::Request::execute (/opt/slimserver/Slim/Control/Request.pm line 772)
frame 8: Slim::Control::Request::executeRequest (/opt/slimserver/slimserver.pl line 964)
frame 9: main::checkDataSource (/opt/slimserver/slimserver.pl line 425)
frame 10: main::init (/opt/slimserver/slimserver.pl line 450)
frame 11: main::main (/opt/slimserver/slimserver.pl line 1076)

The following modules failed to load: DBD::mysql

To download and compile them, please run: /opt/slimserver/Bin/build-perl-modules.pl DBD::mysql

Exiting..


Now I知 no perl or MySQL expert but this suggests to me that DBD::mysql did load successfully and that the real issue is that slimserver can稚 handle the default (on) mysql autocommit setting. Has anyone else experienced this abd/or know how to work around it????

Thanks in advance,
Chris.