developers

[Prev] Thread [Next]  |  [Prev] Date [Next]

[Developers] Scaner bug in 7.3.2? brasse Mon Jun 15 15:00:51 2009

Hello!

I just wanted to share with you something. I finally got my Squeezebox
Duet this weekend and installed Squeezecenter 7.3.2 on my Ubuntu box.
After some twaeking I got it to run. Everything seems to work fine
except for the scanning of my music folder. This is what ends up in my
scanner log when I trigger a scan via the web interface or run
squeezecenter-scanner:

[09-06-15 22:53:57.0999] Slim::Schema::Storage::throw_exception (70)
Error: DBI Connection failed: DBI
connect('database=slimserver','slimserver',...) failed: Can't connect to
local MySQL server through socket '/tmp/mysql.sock' (2) at
/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 652
[09-06-15 22:53:57.1011] Slim::Schema::Storage::throw_exception (70)
Backtrace:

frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 70)
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 29)
frame 5: (eval) (/usr/share/perl5/Slim/Schema/Storage.pm line 29)
frame 6: Slim::Schema::Storage::dbh (/usr/share/perl5/Slim/Schema.pm
line 132)
frame 7: Slim::Schema::init (/usr/share/perl5/Slim/Music/Info.pm
line 77)
frame 8: Slim::Music::Info::init (/usr/sbin/squeezecenter-scanner
line 281)
frame 9: main::initializeFrameworks (/usr/sbin/squeezecenter-scanner
line 117)
frame 10: main::main (/usr/sbin/squeezecenter-scanner line 363)

[09-06-15 22:53:57.1022] Slim::Schema::init (135) Error: Couldn't
connect to database! Fatal error: [] Exiting!
[09-06-15 22:53:57.1029] Slim::Schema::init (135) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema.pm line 135)
frame 1: Slim::Schema::init (/usr/share/perl5/Slim/Music/Info.pm
line 77)
frame 2: Slim::Music::Info::init (/usr/sbin/squeezecenter-scanner
line 281)
frame 3: main::initializeFrameworks (/usr/sbin/squeezecenter-scanner
line 117)
frame 4: main::main (/usr/sbin/squeezecenter-scanner line 363)

[09-06-15 22:53:57.1055] Slim::Schema::Storage::throw_exception (70)
Error: DBI Connection failed: DBI
connect('database=slimserver','slimserver',...) failed: Can't connect to
local MySQL server through socket '/tmp/mysql.sock' (2) at
/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 652
[09-06-15 22:53:57.1065] Slim::Schema::Storage::throw_exception (70)
Backtrace:

frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 70)
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 29)
frame 5: (eval) (/usr/share/perl5/Slim/Schema/Storage.pm line 29)
frame 6: Slim::Schema::Storage::dbh
(/usr/share/perl5/Slim/Music/Import.pm line 265)
frame 7: Slim::Music::Import::setIsScanning
(/usr/sbin/squeezecenter-scanner line 349)
frame 8: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line
378)
frame 9: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm
line 412)
frame 10: Slim::bootstrap::theEND (/usr/sbin/squeezecenter-scanner
line 358)
frame 11: main::END (/usr/sbin/squeezecenter-scanner line 0)
frame 12: (eval) (/usr/sbin/squeezecenter-scanner line 0)

[09-06-15 22:53:57.1076] main:: (0) Warning: Can't use an undefined
value as a HASH reference at /usr/share/perl5/Slim/Music/Import.pm line
265.
END failed--call queue aborted.

For some reason the scanner code can't connect to my database. I have
changed my database settings to:

dbpassword: xxx
dbsource: dbi:mysql:database=slimserver
dbusername: slimserver

I have created a database and can connect to it from the command line:
mysql -u slimserver -p.

Anyway I took a look at the code that the backtrace is referencing. In
the file /usr/sbin/squeezecenter-scanner the function
initializeFrameworks() has these line commented out:

        # $log->info("SqueezeCenter MySQL init...");
        # Slim::Utils::MySQLHelper->init();

If I uncomment those line and trigger a scan everything seems to work
fine. So my question becomes this: why are these lines commented out and
will I run into problems later on if I uncomment them?

Regards,
Mattias


-- 
brasse
------------------------------------------------------------------------
brasse's Profile: http://forums.slimdevices.com/member.php?userid=30983
View this thread: http://forums.slimdevices.com/showthread.php?t=64523

_______________________________________________
developers mailing list
[EMAIL PROTECTED]
http://lists.slimdevices.com/mailman/listinfo/developers