Squeezebox Server Not Working

[hypertense]

Yesterday Squeezebox server stopped working for me after I had been trying to get Amahitunes to work, so I reinstalled it. The reinstall starts and gets to the "Welcome to Squeezebox" screen where I click the finish button to complete the setup. At this point it hangs.

If I then type squeeze in to the browser window the Squeezebox Server main window comes up, but the music library is completely missing. A rescan does nothing, but in the information screen next to Library Statistics is the message

No music library configured

The music folder is /var/hda/files/music and the server is pointed accordingly.

hypertense

[bigfoot65]

You sure seem to be having a lot of problems lately with the streaming apps Did you follow the wiki guidance for completing install as noted in Special Instructions?

Not sure if it would change anything, but thought it was worth a mention.

[hypertense]

bigfoot, you're right, I have been having a hard time with these applications recently. This is the one that I really want and it has worked well for me in the past.

I can only assume one of a couple of things have happened - either I changed something when trying to get Amahitunes to work or Squeezeboxserver carried out an automatic update that broke it.

I have followed the final steps detailed in the wiki on each install. The server appears to be running OK apart from not locating my music - I can play internet radio etc.

Looking at the scanner log I see the following:

frame 4: Slim::Schema::migrateDB (/usr/lib/perl5/vendor_perl/Slim/Schema.pm line 168)
frame 5: Slim::Schema::init (/usr/lib/perl5/vendor_perl/Slim/Music/Import.pm line 637)
frame 6: Slim::Music::Import::_checkLibraryStatus (/usr/lib/perl5/vendor_perl/Slim/Music/Import.pm line 440)
frame 7: Slim::Music::Import::addImporter (/usr/lib/perl5/vendor_perl/Slim/Music/MusicFolderScan.pm line 46)
frame 8: Slim::Music::MusicFolderScan::init (/usr/lib/perl5/vendor_perl/Slim/Utils/Prefs.pm line 797)
frame 9: Slim::Utils::Prefs::__ANON__ (/usr/lib/perl5/vendor_perl/Slim/Utils/Prefs/Base.pm line 299)
frame 10: Slim::Utils::Prefs::Base::set (/usr/lib/perl5/vendor_perl/Slim/Web/Settings/Server/Wizard.pm line 106)
frame 11: Slim::Web::Settings::Server::Wizard::handler (/usr/lib/perl5/vendor_perl/Slim/Web/HTTP.pm line 1124)
frame 12: Slim::Web::HTTP::generateHTTPResponse (/usr/lib/perl5/vendor_perl/Slim/Web/HTTP.pm line 926)
frame 13: Slim::Web::HTTP::processURL (/usr/lib/perl5/vendor_perl/Slim/Web/HTTP.pm line 736)
frame 14: Slim::Web::HTTP::processHTTP (/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 139)
frame 15: (eval) (/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 123)
frame 16: Slim::Networking::IO::Select::__ANON__ (/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 184)
frame 17: (eval) (/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 184)
frame 18: Slim::Networking::IO::Select::loop (/usr/libexec/squeezeboxserver line 691)
frame 19: main::idle (/usr/libexec/squeezeboxserver line 641)
frame 20: main::main (/usr/libexec/squeezeboxserver line 1136)

[11-10-23 18:49:40.9156] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Web::HTTP::processHTTP: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: database disk image is malformed [for Statement "-- Table to store persistent track information, e.g. ratings and playcounts
-- This data survives a rescan
DROP TABLE IF EXISTS persistentdb.tracks_persistent"] at /usr/lib/perl5/vendor_perl/Slim/Schema/Storage.pm line 123
; fh=Slim::Web::HTTP::ClientConn=GLOB(0x982a188)
[11-10-23 18:53:47.9491] Slim::Utils::Scanner::Remote::__ANON__ (240) Error: Can't connect to remote server to retrieve playlist for, http://192.168.1.20:3689/: 401 Unauthorized.
[11-10-23 18:59:07.6084] Slim::Utils::Scanner::Local::rescan (166) Discovering files in /var/hda/files/music
[11-10-23 18:59:07.6101] Slim::Schema::Storage::throw_exception (119) Error: DBI Exception: DBD::SQLite::db do failed: no such table: scanned_files [for Statement "DELETE FROM scanned_files WHERE url = 'file:///var/hda/files/music' OR url LIKE 'file:///var/hda/files/music/%'"]
[11-10-23 18:59:07.6109] Slim::Schema::Storage::throw_exception (119) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/lib/perl5/vendor_perl/Slim/Schema/Storage.pm line 119)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/lib/perl5/vendor_perl/Slim/Utils/Scanner/Local.pm line 60)
frame 3: Slim::Utils::Scanner::Local::find (/usr/lib/perl5/vendor_perl/Slim/Utils/Scanner/Local.pm line 493)
frame 4: Slim::Utils::Scanner::Local::rescan (/usr/lib/perl5/vendor_perl/Slim/Control/Commands.pm line 2486)
frame 5: Slim::Control::Commands::rescanCommand (/usr/lib/perl5/vendor_perl/Slim/Control/Request.pm line 1878)
frame 6: (eval) (/usr/lib/perl5/vendor_perl/Slim/Control/Request.pm line 1878)
frame 7: Slim::Control::Request::execute (/usr/lib/perl5/vendor_perl/Slim/Control/Request.pm line 875)
frame 8: Slim::Control::Request::executeRequest (/usr/lib/perl5/vendor_perl/Slim/Web/Settings/Server/Basic.pm line 74)
frame 9: Slim::Web::Settings::Server::Basic::handler (/usr/lib/perl5/vendor_perl/Slim/Web/HTTP.pm line 1124)
frame 10: Slim::Web::HTTP::generateHTTPResponse (/usr/lib/perl5/vendor_perl/Slim/Web/HTTP.pm line 926)
frame 11: Slim::Web::HTTP::processURL (/usr/lib/perl5/vendor_perl/Slim/Web/HTTP.pm line 736)
frame 12: Slim::Web::HTTP::processHTTP (/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 139)
frame 13: (eval) (/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 123)
frame 14: Slim::Networking::IO::Select::__ANON__ (/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 184)
frame 15: (eval) (/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 184)
frame 16: Slim::Networking::IO::Select::loop (/usr/libexec/squeezeboxserver line 691)
frame 17: main::idle (/usr/libexec/squeezeboxserver line 641)
frame 18: main::main (/usr/libexec/squeezeboxserver line 1136)

[11-10-23 18:59:07.6117] Slim::Control::Request::execute (1883) Error: While trying to run function coderef [Slim::Control::Commands::rescanCommand]: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: no such table: scanned_files [for Statement "DELETE FROM scanned_files WHERE url = 'file:///var/hda/files/music' OR url LIKE 'file:///var/hda/files/music/%'"] at /usr/lib/perl5/vendor_perl/Slim/Schema/Storage.pm line 123
]

I have checked file permissions for var/hda/files/music and they appear to be correct with read/write access for all in group users and read access for everyone.

hypertense

[hypertense]

Fixed it!

Could not rely on HDA uninstall/reinstall from the Apps menu on the HDA. I carried out an uninstall from the menu and then searched the HDA for all references to squeezeboxserver. There were quite a few folders left behind and I deleted all of them. I then rebooted and installed from the HDA Apps menu. This time everything went smoothly and my music was scanned and showing in seconds. All I had to do then was go in and set up all my plugins and preferences that had obviously been deleted when I removed the squeezeboxserver files and folders.

I can only assume that Squeezeboxserver corrupted something at some point and that this corruption was to some file or files that were referenced during a reinstall.

Hopefully this will be of use if anyone else encounters the same problem.

hypertense

[bigfoot65]

I am betting that when the app was uninstalled, the RPM was still there. Unfortunately when RPMs are uninstalled, they leave behind folders and sometimes config files with the rpmsave extension.

Glad you are back in service.