Reinstalling mysql - how?

[GNOE Inc..]

ah, okay....

[Hammer]

Lots of interest in the off topic, but PLEASE, thread topic was how to reinstall mysql, and none has so far been able to provide an answer to that or if there is anything I will mess up by doing so.

My squeezecenter is still broken, and the target is to have it working. Any tips in that direction will of course be considered, but it seems like reinstalling mysql is the only option right now.

[asparak]

reinstalling mysql will do precisely that. Any database you have at the moment (I don't know if you actually use it for things) will probably get wiped.

Try:

Code: Select all

apt-get install --reinstall mysql

However, thats a bit of a radical step, to fix what is probably just a config error, so have you tried the following:
http://www.cyberciti.biz/tips/recover-m ... sword.html

[carl]

It's strange that your squeezecenter is reporting to have been fully installed while it isn't; So, lets solve this

First try following:

Code: Select all

dpkg-reconfigure -phigh squeezecenter

if that didn't resulted in anything useful we'll have to try removing squeezecenter totally.
Issue following command:

Code: Select all

dpkg --purge squeezecenter

Important to say "yes" on the question if the database should be removed

If the purge is sucessfull, try now to (re)install squeezecenter

Code: Select all

DEBIAN_FRONTEND=noninteractive apt-get -y -c /etc/apt/bubba-apt.conf install squeezecenter

or

Code: Select all

apt-get install squeezecenter

depending on if you have changed mysql root password or not

Now inspect the output from the install, especially when it talks about creating database user. if it says like "allready exists", then we need to try even more things, eventually above steps again can work, but manual sql work might be needed. But if not, then hopefully squeezecenter should be fully operational again.

[Hammer]

Hi Carl

First command gives the following output:

dbconfig-common: writing config to /etc/dbconfig-common/squeezecenter.conf
Replacing config file /etc/squeezecenter/debian-db.pm with new version
granting access to database squeezecenter for squeezecenter@localhost: already exists.
creating database squeezecenter: already exists.
populating database via sql... done.
dbconfig-common: flushing administrative password

which didn't seem useful. I continued to the next step; purge of squeezecenter.
When asking for db admin password, I just hit enter and it proceeded to drop tables. So I HADN'T changed the root pass, so why on earth did the upgrade fail in the first place??

So, I proceeded with the re-installation.
This step reported only successes, so I did the remaining step as well.

apt-get install squeezecenter

Here something odd(?) occurred, it reported:

Reading package lists... Done
Building dependency tree... Done
squeezecenter is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

Now I will go start the logitech squeezebox and see if it works, BRB.

[Hammer]

dkpg.log reports:

2009-07-24 15:06:23 status installed squeezecenter 7.3.3.dfsg-1
2009-07-24 15:06:25 remove squeezecenter 7.3.3.dfsg-1 7.3.3.dfsg-1
2009-07-24 15:06:25 status half-configured squeezecenter 7.3.3.dfsg-1
2009-07-24 15:07:07 status half-installed squeezecenter 7.3.3.dfsg-1
2009-07-24 15:07:14 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-24 15:07:14 purge squeezecenter 7.3.3.dfsg-1 7.3.3.dfsg-1
2009-07-24 15:07:14 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-24 15:07:14 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-24 15:07:14 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-24 15:07:24 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-24 15:07:24 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-24 15:07:24 status not-installed squeezecenter <none>
2009-07-24 15:08:23 install squeezecenter <none> 7.3.3.dfsg-1
2009-07-24 15:08:23 status half-installed squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:28 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:28 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:29 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:29 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:29 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:29 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:29 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:29 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:29 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:29 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:29 status half-configured squeezecenter 7.3.3.dfsg-1
2009-07-24 15:08:45 status installed squeezecenter 7.3.3.dfsg-1


"top | grep sq" yields:
2077 mysql 20 0 128m 42m 4368 S 3.6 17.1 486:21.13 mysqld
1991 dnsmasq 20 0 2708 808 704 S 0.0 0.3 0:18.46 dnsmasq
2038 root 20 0 3460 1240 1240 S 0.0 0.5 0:00.10 mysqld_safe
2578 root 20 0 5868 476 396 S 0.0 0.2 0:00.00 squid
2580 proxy 20 0 22868 18m 1716 S 0.0 7.3 138:01.82 squid
2589 proxy 20 0 4004 2252 944 S 0.0 0.9 4:46.10 squidGuard
2590 proxy 20 0 4004 2236 944 S 0.0 0.9 0:31.58 squidGuard
2591 proxy 20 0 4004 2224 944 S 0.0 0.9 0:16.70 squidGuard
2592 proxy 20 0 4004 2236 944 S 0.0 0.9 0:09.62 squidGuard
2594 proxy 20 0 4004 2240 940 S 0.0 0.9 0:06.34 squidGuard

so it doesn't seem like squeezecenter is running. Odd.

[carl]

It seems that the database has become out of sync (probably an upgrade gone bad). I would suggest issuing following commands:

First we purge squeezecenter

Code: Select all

dpkg --force-depends --purge squeezecenter

Now, enter mysql (using command mysql)

in mysql issue following commands:

Code: Select all

DROP DATABASE squeezecenter;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM squeezecenter@localhost;
DROP USER squeezecenter@localhost;

Now exit mysql, and issue following command to install squeezecenter:

Code: Select all

DEBIAN_FRONTEND=noninteractive apt-get -y -c /etc/apt/bubba-apt.conf install squeezecenter

Output of interest should looks as following during the install:

Code: Select all

dbconfig-common: writing config to /etc/dbconfig-common/squeezecenter.conf

Creating config file /etc/dbconfig-common/squeezecenter.conf with new version

Creating config file /etc/squeezecenter/debian-db.pm with new version
granting access to database squeezecenter for squeezecenter@localhost: success.
verifying access for squeezecenter@localhost: success.
creating database squeezecenter: success.
verifying database squeezecenter exists: success.
populating database via sql...  done.
dbconfig-common: flushing administrative password

After this, go to the services interface and verify that squeezecenter is checked, and if not, check it to allow it to start automatic.

[Hammer]

Hi,

Did all you wrote.
dkpg.log shows:

2009-07-30 11:16:48 status installed squeezecenter 7.3.3.dfsg-1
2009-07-30 11:16:50 remove squeezecenter 7.3.3.dfsg-1 7.3.3.dfsg-1
2009-07-30 11:16:50 status half-configured squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:29 status half-installed squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:36 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:36 purge squeezecenter 7.3.3.dfsg-1 7.3.3.dfsg-1
2009-07-30 11:17:36 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:36 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:36 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:45 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:45 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:45 status not-installed squeezecenter <none>
2009-07-30 11:18:34 install squeezecenter <none> 7.3.3.dfsg-1
2009-07-30 11:18:34 status half-installed squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:39 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:39 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status half-configured squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:57 status installed squeezecenter 7.3.3.dfsg-1

top now shows squeezecenter running.

And WEEEEEE it is back up, now I can play my music again!!!!!

Thanks a LOT Carl!

BR,
Hammer

[Hammer]

Hi,

Did all you wrote.
dkpg.log shows:

2009-07-30 11:16:48 status installed squeezecenter 7.3.3.dfsg-1
2009-07-30 11:16:50 remove squeezecenter 7.3.3.dfsg-1 7.3.3.dfsg-1
2009-07-30 11:16:50 status half-configured squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:29 status half-installed squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:36 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:36 purge squeezecenter 7.3.3.dfsg-1 7.3.3.dfsg-1
2009-07-30 11:17:36 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:36 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:36 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:45 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:45 status config-files squeezecenter 7.3.3.dfsg-1
2009-07-30 11:17:45 status not-installed squeezecenter <none>
2009-07-30 11:18:34 install squeezecenter <none> 7.3.3.dfsg-1
2009-07-30 11:18:34 status half-installed squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:39 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:39 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status unpacked squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:40 status half-configured squeezecenter 7.3.3.dfsg-1
2009-07-30 11:18:57 status installed squeezecenter 7.3.3.dfsg-1

top now shows squeezecenter running.

And WEEEEEE it is back up, now I can play my music again!!!!!

Thanks a LOT Carl!

BR,
Hammer

[hmattsso]

Hi,

When trying to upgrade to squeezecenter 7.4 manually I have got problems similar to the ones discussed earlier in this thread and I have tried to follow the steps proposed by Carl in his October 25th reply. There is though still some problem remaining for me:

When issuing the command:
DEBIAN_FRONTEND=noninteractive apt-get -y -c /etc/apt/bubba-apt.conf install squeezecenter

I get the following output:
.......
pmstatus:squeezecenter:80:Configuring squeezecenter
dbconfig-common: writing config to /etc/dbconfig-common/squeezecenter.conf

Creating config file /etc/dbconfig-common/squeezecenter.conf with new version

Creating config file /etc/squeezecenter/debian-db.pm with new version
granting access to database squeezecenter for squeezecenter@localhost: success.
verifying access for squeezecenter@localhost: success.
creating database squeezecenter: success.
verifying database squeezecenter exists: success.
populating database via sql... error encountered populating database:
mysql said: ERROR 1005 (HY000) at line 6: Can't create table './squeezecenter/playlist_track.frm' (errno: 150)
dbconfig-common: squeezecenter configure: aborted.
dbconfig-common: flushing administrative password
done.
dbconfig-common: flushing administrative password

pmstatus:squeezecenterInstalled squeezecenter
---------------------

And when looking into /var/log/squeezecenter/server.log squeezecenter continously crashes and restarts with the following output:

-- Start server.log ----------------------------
009-11-01 21:53:35 squeezecenter_safe started.
[09-11-01 21:54:00.7776] main::init (320) Starting Squeezebox Server (v7.4.0, rTRUNK, UNKNOWN) perl 5.008008
[09-11-01 21:54:18.4523] Slim::Schema::init (147) Warning: Creating new database - empty database or database from 6.3.x found
[09-11-01 21:54:21.2118] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Table 'squeezecenter.tracks' doesn't exist [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )" with ParamValues: 0='mov']
[09-11-01 21:54:21.2243] 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/perl5/DBIx/Class/Storage/DBI.pm line 957)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1217)
frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 532)
frame 4: DBIx::Class::Storage::DBI::dbh_do (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1227)
frame 5: DBIx::Class::Storage::DBI::_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1451)
frame 6: DBIx::Class::Storage::DBI::_select (/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 82)
frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 547)
frame 8: (eval) (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 540)
frame 9: DBIx::Class::Storage::DBI::dbh_do (/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 101)
frame 10: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/perl5/DBIx/Class/ResultSetColumn.pm line 128)
frame 11: DBIx::Class::ResultSetColumn::next (/usr/share/perl5/DBIx/Class/ResultSet.pm line 1181)
frame 12: DBIx::Class::ResultSet::count (/usr/share/perl5/DBIx/Class/ResultSet.pm line 1164)
frame 13: DBIx::Class::ResultSet::count (/usr/share/perl5/Slim/Schema.pm line 530)
frame 14: Slim::Schema::count (/usr/share/perl5/Slim/Schema.pm line 235)
frame 15: Slim::Schema::init (/usr/share/perl5/Slim/Music/Import.pm line 740)
frame 16: Slim::Music::Import::_checkLibraryStatus (/usr/share/perl5/Slim/Music/Import.pm line 673)
frame 17: Slim::Music::Import::useImporter (/usr/share/perl5/Slim/Music/MusicFolderScan.pm line 48)
frame 18: Slim::Music::MusicFolderScan::init (/usr/sbin/squeezecenter-server line 429)
frame 19: main::init (/usr/sbin/squeezecenter-server line 572)
frame 20: main::main (/usr/sbin/squeezecenter-server line 1103)

[09-11-01 21:54:21.2350] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Table 'squeezecenter.tracks' doesn't exist [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )" with ParamValues: 0='mov'] at /usr/share/perl5/Slim/Schema/Storage.pm line 86
[09-11-01 21:54:21.2456] 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/perl5/DBIx/Class/Storage/DBI.pm line 562)
frame 2: DBIx::Class::Storage::DBI::dbh_do (/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 101)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/perl5/DBIx/Class/ResultSetColumn.pm line 128)
frame 4: DBIx::Class::ResultSetColumn::next (/usr/share/perl5/DBIx/Class/ResultSet.pm line 1181)
frame 5: DBIx::Class::ResultSet::count (/usr/share/perl5/DBIx/Class/ResultSet.pm line 1164)
frame 6: DBIx::Class::ResultSet::count (/usr/share/perl5/Slim/Schema.pm line 530)
frame 7: Slim::Schema::count (/usr/share/perl5/Slim/Schema.pm line 235)
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/squeezecenter-server line 429)
frame 12: main::init (/usr/sbin/squeezecenter-server line 572)
frame 13: main::main (/usr/sbin/squeezecenter-server line 1103)

[09-11-01 21:54:21.2541] Carp::Clan::__ANON__ (213) Warning: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Table 'squeezecenter.tracks' doesn't exist [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )" with ParamValues: 0='mov'] at /usr/share/perl5/Slim/Schema/Storage.pm line 86
[09-11-01 21:54:21.3303] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Table 'squeezecenter.tracks_persistent' doesn't exist [for Statement "SELECT me.id, me.url, me.musicbrainz_id, me.added, me.playcount, me.lastplayed, me.rating FROM tracks_persistent me WHERE ( ( rating IS NOT NULL OR playcount IS NOT NULL OR lastplayed IS NOT NULL ) )"]
[09-11-01 21:54:21.3420] 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/perl5/DBIx/Class/Storage/DBI.pm line 957)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1217)
frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 532)
frame 4: DBIx::Class::Storage::DBI::dbh_do (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1227)
frame 5: DBIx::Class::Storage::DBI::_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1451)
frame 6: DBIx::Class::Storage::DBI::_select (/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 82)
frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 547)
frame 8: (eval) (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 540)
frame 9: DBIx::Class::Storage::DBI::dbh_do (/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 101)
frame 10: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/perl5/DBIx/Class/ResultSet.pm line 949)
frame 11: DBIx::Class::ResultSet::next (/usr/share/perl5/Slim/Schema/TrackPersistent.pm line 62)
frame 12: Slim::Schema::TrackPersistent::export (/usr/sbin/squeezecenter-server line 1046)
frame 13: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 405)
frame 14: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm line 439)
frame 15: Slim::bootstrap::theEND (/usr/sbin/squeezecenter-server line 1099)
frame 16: main::END (/usr/sbin/squeezecenter-server line 0)
frame 17: (eval) (/usr/sbin/squeezecenter-server line 0)

[09-11-01 21:54:21.3528] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Table 'squeezecenter.tracks_persistent' doesn't exist [for Statement "SELECT me.id, me.url, me.musicbrainz_id, me.added, me.playcount, me.lastplayed, me.rating FROM tracks_persistent me WHERE ( ( rating IS NOT NULL OR playcount IS NOT NULL OR lastplayed IS NOT NULL ) )"] at /usr/share/perl5/Slim/Schema/Storage.pm line 86
[09-11-01 21:54:21.3627] 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/perl5/DBIx/Class/Storage/DBI.pm line 562)
frame 2: DBIx::Class::Storage::DBI::dbh_do (/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 101)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/perl5/DBIx/Class/ResultSet.pm line 949)
frame 4: DBIx::Class::ResultSet::next (/usr/share/perl5/Slim/Schema/TrackPersistent.pm line 62)
frame 5: Slim::Schema::TrackPersistent::export (/usr/sbin/squeezecenter-server line 1046)
frame 6: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 405)
frame 7: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm line 439)
frame 8: Slim::bootstrap::theEND (/usr/sbin/squeezecenter-server line 1099)
frame 9: main::END (/usr/sbin/squeezecenter-server line 0)
frame 10: (eval) (/usr/sbin/squeezecenter-server line 0)

[09-11-01 21:54:21.3717] main:: (0) Warning: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Table 'squeezecenter.tracks_persistent' doesn't exist [for Statement "SELECT me.id, me.url, me.musicbrainz_id, me.added, me.playcount, me.lastplayed, me.rating FROM tracks_persistent me WHERE ( ( rating IS NOT NULL OR playcount IS NOT NULL OR lastplayed IS NOT NULL ) )"] at /usr/share/perl5/Slim/Schema/Storage.pm line 86
END failed--call queue aborted.
2009-11-01 21:54:21 SqueezeCenter died. Restarting.
-- End server.log ----------------------------

I would be happy for any input on what might be wrong and/or how it could be solved.

/Hans

[carl]

Hi,

When trying to upgrade to squeezecenter 7.4 manually I have got problems similar to the ones discussed earlier in this thread and I have tried to follow the steps proposed by Carl in his October 25th reply. There is though still some problem remaining for me:

When issuing the command:
DEBIAN_FRONTEND=noninteractive apt-get -y -c /etc/apt/bubba-apt.conf install squeezecenter

I get the following output:
...

I would be happy for any input on what might be wrong and/or how it could be solved.

/Hans

Seems it failed to upgrade the database as it should, could you try following command:

Code: Select all

mysql squeezecenter< /usr/share/dbconfig-common/data/squeezecenter/upgrade/mysql/7.4.0

/Carl

[hmattsso]

Hi again Carl,

Now I have tried the command you gave me but unfortunately it was no successful.

This is the response I got:

bubba:/home/hans# mysql squeezecenter< /usr/share/dbconfig-common/data/squeezecenter/upgrade/mysql/7.4.0
ERROR 1146 (42S02) at line 1: Table 'squeezecenter.tracks' doesn't exist

Any idea idea what to do?

Best Regards
Hans

[carl]

Hi again Carl,

Now I have tried the command you gave me but unfortunately it was no successful.

This is the response I got:

bubba:/home/hans# mysql squeezecenter< /usr/share/dbconfig-common/data/squeezecenter/upgrade/mysql/7.4.0
ERROR 1146 (42S02) at line 1: Table 'squeezecenter.tracks' doesn't exist

Any idea idea what to do?

Best Regards
Hans

That sounds a bit problematic, as the "tracks" tables should have been created at the first install of squeezecenter.

I think you will need to reinstall the whole database:

Code: Select all

mysql squeezecenter< /usr/share/dbconfig-common/data/squeezecenter/install/mysql

/Carl

[hmattsso]

Hi again Carl,

I tried the new command you gave me but still no success I'm afraid....

This is what I got this time:

bubba:/etc/apt# mysql squeezecenter< /usr/share/dbconfig-common/data/squeezecenter/install/mysql
ERROR 1005 (HY000) at line 6: Can't create table './squeezecenter/playlist_track.frm' (errno: 150)

I guess the reason getting into these problems is that I when trying to manually install 7.4 at one point when responding to a question triggered by an " apt-get remove --purge squeezecenter"-command answered yes to the removal of a data-base....

Is there maybe a possibiliy to reinstall squeezecenter from scratch (without having to reinstall the whole Bubba-distribution)?

Thankful for any help...
/Hans

[carl]

Hi again Carl,

I tried the new command you gave me but still no success I'm afraid....

This is what I got this time:

bubba:/etc/apt# mysql squeezecenter< /usr/share/dbconfig-common/data/squeezecenter/install/mysql
ERROR 1005 (HY000) at line 6: Can't create table './squeezecenter/playlist_track.frm' (errno: 150)

I guess the reason getting into these problems is that I when trying to manually install 7.4 at one point when responding to a question triggered by an " apt-get remove --purge squeezecenter"-command answered yes to the removal of a data-base....

Is there maybe a possibiliy to reinstall squeezecenter from scratch (without having to reinstall the whole Bubba-distribution)?

Thankful for any help...
/Hans

Squeezecenter isn't a dpendency for the main bubba installation, so a normal "apt-get remove --purge squeezecenter" should do the trick.