Reinstalling mysql - how?

[hmattsso]

Hi Carl,

Still no luck....

Now I have attempted the following command sequence:

1) Squeezecenter has been ticked off on the Services page in the Bubba administration tool.

Below commands run as superuser using bash from disrectory /etc/apt
2) apt-get remove --purge squeezecenter
3) apt-get update
4) apt-get install squeezecenter

I then answer yes to the question if the script shall configure the database answer the default to all password question.
The script then signals an error and asks me how to continue and I answer "abort".

as part of the output from 4) I get the same error as with the command you previously sent me.
The following text was included in the output from the script:
...
...
Setting up squeezecenter (7.4.0.dfsg1-2) ...
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


Any more idea on what could be wrong?

/Hans

[carl]

Hi Carl,

Still no luck....

Now I have attempted the following command sequence:

1) Squeezecenter has been ticked off on the Services page in the Bubba administration tool.

Below commands run as superuser using bash from disrectory /etc/apt
2) apt-get remove --purge squeezecenter
3) apt-get update
4) apt-get install squeezecenter

I then answer yes to the question if the script shall configure the database answer the default to all password question.
The script then signals an error and asks me how to continue and I answer "abort".

as part of the output from 4) I get the same error as with the command you previously sent me.
The following text was included in the output from the script:
...
...
Setting up squeezecenter (7.4.0.dfsg1-2) ...
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


Any more idea on what could be wrong?

/Hans

Lets see if you can actually create a database;
First make sure that the database directory is writable correcty. Issue following command:

Code: Select all

 ls -ld /var/lib/mysql/squeezecenter

You should get an output as following:

Code: Select all

[0:0][root@bubba azatoth]# ls -ld /var/lib/mysql/squeezecenter
drwx------ 2 mysql mysql 4096 2009-11-04 21:20 /var/lib/mysql/squeezecenter

Also you can check the content of that directory so it's writeable:

Code: Select all

[0:0][root@bubba azatoth]# ls -l /var/lib/mysql/squeezecenter
totalt 200
-rw-rw---- 1 mysql mysql  9130 2009-07-25 17:21 albums.frm
-rw-rw---- 1 mysql mysql  8620 2009-07-25 17:21 comments.frm
-rw-rw---- 1 mysql mysql  8636 2009-07-25 17:21 contributor_album.frm
-rw-rw---- 1 mysql mysql  8820 2009-07-25 17:21 contributors.frm
-rw-rw---- 1 mysql mysql  8636 2009-07-25 17:21 contributor_track.frm
-rw-rw---- 1 mysql mysql    65 2009-07-25 17:21 db.opt
-rw-rw---- 1 mysql mysql  8770 2009-07-25 17:21 genres.frm
-rw-rw---- 1 mysql mysql  8594 2009-07-25 17:21 genre_track.frm
-rw-rw---- 1 mysql mysql  8592 2009-07-25 17:21 metainformation.frm
-rw-rw---- 1 mysql mysql  8664 2009-11-04 21:20 playlist_track.frm
-rw-rw---- 1 mysql mysql  8622 2009-07-25 17:21 pluginversion.frm
-rw-rw---- 1 mysql mysql  8808 2009-07-25 17:21 progress.frm
-rw-rw---- 1 mysql mysql  8732 2009-07-25 17:21 rescans.frm
-rw-rw---- 1 mysql mysql 14092 2009-11-04 21:20 tracks.frm
-rw-rw---- 1 mysql mysql  8814 2009-07-25 17:21 tracks_persistent.frm
-rw-rw---- 1 mysql mysql  8652 2009-07-25 17:21 unreadable_tracks.frm
-rw-rw---- 1 mysql mysql  8556 2009-07-25 17:21 years.frm

I.e. they chould all be owned by the user mysql and the group mysql and be fully readable and writeable by that user.

/Carl

[hmattsso]

Hi Carl,

This is what I got:

bubba:/home/hans# ls -ld /var/lib/mysql/squeezecenter
drwx------ 2 mysql mysql 4096 Nov 4 19:01 /var/lib/mysql/squeezecenter
bubba:/home/hans# ls -l /var/lib/mysql/squeezecenter
total 4
-rw-rw---- 1 mysql mysql 65 Nov 4 19:01 db.opt
bubba:/home/hans#

It seems like there is only a single file in the directory but the permissions look OK, don't they?

/Hans

[carl]

Hi Carl,

This is what I got:

bubba:/home/hans# ls -ld /var/lib/mysql/squeezecenter
drwx------ 2 mysql mysql 4096 Nov 4 19:01 /var/lib/mysql/squeezecenter
bubba:/home/hans# ls -l /var/lib/mysql/squeezecenter
total 4
-rw-rw---- 1 mysql mysql 65 Nov 4 19:01 db.opt
bubba:/home/hans#

It seems like there is only a single file in the directory but the permissions look OK, don't they?

/Hans

Hello Hans,

Sorry for my tries to help you when I missed the actual reason for the failure, which is in the package itself. We will try to have an new version (7.4.1) before this weekend.

/Carl

[carl]

New squeezecenter is released now, could you test installing it? Possibly you need to do one purge in between if you notice it doesn't try installing any database.

/Carl

[hmattsso]

Hi Carl,

I have installed 7.4.1 and now squeezeserver starts up fine (I had to do the purge as you indicated) and I can access it from my Squeezebox Duet. From the controller/receiver I can access and listen to Web-radio and also I am able to browse my music-files on the bubba.

So far so good.... but there is still one remaining problem I am afraid.....
The problem is that when I try to play any of the music-files on the bubba they fail with the following error-text shown in the controller: "Problem det går inte att öppna fil för: " tail -f (In Swedish but I assume you that is something you know )
When playing the same files using mediatomb to another mediaplayer it works fine. They also played fine on the squeezebox before I started to upgrade to 7.4.

When looking into /var/log/squeezecenter/server.log I find a number of error printouts like the following:

[09-11-08 08:30:02.5954] main::init (320) Starting Squeezebox Server (v7.4.1, rTRUNK, UNKNOWN) perl 5.008008
[09-11-08 08:30:50.9680] Slim::Utils::Misc::msg (1165) Warning: [08:30:50.9482] Use of uninitialized value in pattern match (m//) at /usr/share/perl5/Slim/Control/Request.pm line 726.
[09-11-08 08:30:50.9884] Slim::Utils::Misc::msg (1165) Warning: [08:30:50.9713] Use of uninitialized value in hash element at /usr/share/perl5/Slim/Control/Request.pm line 762.
[09-11-08 08:30:50.9976] Slim::Utils::Misc::msg (1165) Warning: [08:30:50.9916] Use of uninitialized value in hash element at /usr/share/perl5/Slim/Plugin/OPMLBased.pm line 135.
[09-11-08 08:30:52.4165] Slim::Utils::Misc::msg (1165) Warning: [08:30:52.4109] Use of uninitialized value in string eq at /usr/share/perl5/Slim/Plugin/OPMLBased.pm line 98.
[09-11-08 08:32:15.4264] Slim::Utils::Misc::msg (1165) Warning: [08:32:15.4011] Use of uninitialized value in string ne at /usr/share/perl5/Slim/Player/Protocols/HTTP.pm line 586.
[09-11-08 08:41:37.5136] Slim::Utils::Misc::msg (1165) Warning: [08:41:37.5081] Use of uninitialized value in multiplication (*) at /usr/share/perl5/Slim/Utils/Scanner/Remote.pm line 440.
[09-11-08 08:43:11.0074] Slim::Utils::Misc::msg (1165) Warning: [08:43:10.0013] Use of uninitialized value in pattern match (m//) at /usr/share/perl5/Slim/Control/XMLBrowser.pm line 207.

Any idea if there is a salvation for this (new) problem?

/Hans

[carl]

Hi Carl,

I have installed 7.4.1 and now squeezeserver starts up fine (I had to do the purge as you indicated) and I can access it from my Squeezebox Duet. From the controller/receiver I can access and listen to Web-radio and also I am able to browse my music-files on the bubba.

So far so good.... but there is still one remaining problem I am afraid.....
The problem is that when I try to play any of the music-files on the bubba they fail with the following error-text shown in the controller: "Problem det går inte att öppna fil för: " tail -f (In Swedish but I assume you that is something you know )
When playing the same files using mediatomb to another mediaplayer it works fine. They also played fine on the squeezebox before I started to upgrade to 7.4.

When looking into /var/log/squeezecenter/server.log I find a number of error printouts like the following:

[09-11-08 08:30:02.5954] main::init (320) Starting Squeezebox Server (v7.4.1, rTRUNK, UNKNOWN) perl 5.008008
[09-11-08 08:30:50.9680] Slim::Utils::Misc::msg (1165) Warning: [08:30:50.9482] Use of uninitialized value in pattern match (m//) at /usr/share/perl5/Slim/Control/Request.pm line 726.
[09-11-08 08:30:50.9884] Slim::Utils::Misc::msg (1165) Warning: [08:30:50.9713] Use of uninitialized value in hash element at /usr/share/perl5/Slim/Control/Request.pm line 762.
[09-11-08 08:30:50.9976] Slim::Utils::Misc::msg (1165) Warning: [08:30:50.9916] Use of uninitialized value in hash element at /usr/share/perl5/Slim/Plugin/OPMLBased.pm line 135.
[09-11-08 08:30:52.4165] Slim::Utils::Misc::msg (1165) Warning: [08:30:52.4109] Use of uninitialized value in string eq at /usr/share/perl5/Slim/Plugin/OPMLBased.pm line 98.
[09-11-08 08:32:15.4264] Slim::Utils::Misc::msg (1165) Warning: [08:32:15.4011] Use of uninitialized value in string ne at /usr/share/perl5/Slim/Player/Protocols/HTTP.pm line 586.
[09-11-08 08:41:37.5136] Slim::Utils::Misc::msg (1165) Warning: [08:41:37.5081] Use of uninitialized value in multiplication (*) at /usr/share/perl5/Slim/Utils/Scanner/Remote.pm line 440.
[09-11-08 08:43:11.0074] Slim::Utils::Misc::msg (1165) Warning: [08:43:10.0013] Use of uninitialized value in pattern match (m//) at /usr/share/perl5/Slim/Control/XMLBrowser.pm line 207.

Any idea if there is a salvation for this (new) problem?

/Hans

Hello Hans,

Yes, I understand the error message, though I'm not certain whaat you exactly mean by "controller" here, and also I'm not certain in what context 'tail -f' is executed here. The output in the server.log isn't errors, it's just some warnings which often can be ignored.
I think the problem can be that the permissions on your music files is wrong; Could you, if possible, give an output of the permissions on a sample file and directory (i.e. ls -ld dir file) and post it here?

/Carl

[hmattsso]

Hi Carl,

With the "controller" I mean the remote control provided with the Squeezebox Duet. But I also get the same result when I use the "bubba:9000"-application.

Below you can see a directory listing of some of my media-files and the directory they reside in. All the directories in the path have the same privileges except (/home which has drwxr-xr-x). The file and directory names are as you can see quite long (they originate from Windows) but I don't think that should be the problem since they worked fine before I started the upgrade to 7.4.

hans@bubba:/home/storage/music/Hans/Bernstein, Leonard/Chichester Psalms$ ls -l
total 185388
-rwxrwxrwx 1 admin users 41588108 Aug 22 16:36 01. Bernstein Chichester Psalms -I- Maestoso ma energico - Allegro molto - The Choir of King's College, Cambridge.wav
-rwxrwxrwx 1 admin users 54166604 Aug 22 16:36 02. Bernstein Chichester Psalms -II- Andante con moto, ma tranquillo - Allegro feroce - Meno come prima - The Choir of King's College, Cambridge.wav
-rwxrwxrwx 1 admin users 93875420 Aug 22 16:37 03. Bernstein Chichester Psalms -III- Prelude (Sostenuto molto) - Peacefully flowing - The Choir of King's College, Cambridge.wav

hans@bubba:/home/storage/music/Hans/Bernstein, Leonard/Chichester Psalms$ ls -ld
drwxrwxrwx 2 admin users 4096 Sep 11 01:19 .

/Hans

[NightGeo]

Sorry if this is almost highjacking the thread...

For me Squeezecenter still isn't working. I've tried purge, reinstal, confirmed directories permissions. When I click the check box to run squeezecenter and then go to bubba.local:9000 I get an unable to connect (same if I use the ip address).

looking at the logs I get:

Code: Select all

bubba:/home/me# tail  /var/log/squeezecenter/server.log 
2009-11-29 16:32:13 SqueezeCenter died. Restarting.
2009-11-29 16:32:45 SqueezeCenter died. Restarting.
2009-11-29 16:33:16 SqueezeCenter died. Restarting.
2009-11-29 16:33:48 SqueezeCenter died. Restarting.
2009-11-29 16:34:20 SqueezeCenter died. Restarting.
2009-11-29 16:34:52 SqueezeCenter died. Restarting.
2009-11-29 16:35:31 SqueezeCenter died. Restarting.
2009-11-29 16:36:04 SqueezeCenter died. Restarting.
2009-11-29 16:36:35 SqueezeCenter died. Restarting.
2009-11-29 16:37:07 SqueezeCenter died. Restarting.

dpkg.log gives me:

Code: Select all

009-11-29 16:15:04 install squeezecenter <none> 7.4.1.dfsg1-3
2009-11-29 16:15:04 status half-installed squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:30 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:31 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:33 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:33 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:33 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:33 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:33 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:33 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:33 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:33 status unpacked squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:15:33 status half-configured squeezecenter 7.4.1.dfsg1-3
2009-11-29 16:16:53 status installed squeezecenter 7.4.1.dfsg1-3

Kind of stuck, as there is nothing useful there. Not sure what to try, or where to look, next. Any suggestions?

EDIT
Maybe should have a new post, also tried:

Code: Select all

bubba:/home/me# dpkg -l | grep -v ^ii
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name                             Version                              Description
+++-================================-====================================-============================================

[NightGeo]

I found instructions for starting squeezecenter in verbose debug mode:

Code: Select all

/usr/sbin/squeezecenter-server --debug d_startup --diag --verboseOB

And I saw something as so:

Code: Select all

The following optional modules failed to load: [Locale::Hebrew] after their second try.

Which I assume is safe to ignore as a) it is optional and b) as far as I know none of my music contains hebrew characters in filenames or tags.

However, more interstingly I then see this:

Code: Select all

Can't locate Exporter/Lite.pm in @INC (@INC contains: /usr/share/squeezecenter/CPAN/arch/5.8/powerpc-linux-thread-multi /usr/share/squeezecenter/CPAN/arch/5.8/powerpc-linux-thread-multi/auto /usr/share/squeezecenter/CPAN/arch/5.8.8/powerpc-linux-gnu-thread-multi /usr/share/squeezecenter/CPAN/arch/5.8.8/powerpc-linux-gnu-thread-multi/auto /usr/share/squeezecenter/CPAN/arch/5.8/powerpc-linux-gnu-thread-multi /usr/share/squeezecenter/CPAN/arch/5.8/powerpc-linux-gnu-thread-multi/auto /usr/share/squeezecenter/CPAN/arch/powerpc-linux-gnu-thread-multi /usr/share/squeezecenter/lib /usr/share/squeezecenter/CPAN /usr/share/squeezecenter /usr/share/squeezecenter /etc/squeezecenter /usr/sbin /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at /usr/share/perl5/Slim/Utils/Log.pm line 39.
BEGIN failed--compilation aborted at /usr/share/perl5/Slim/Utils/Log.pm line 39.
Compilation failed in require at /usr/sbin/squeezecenter-server line 160.
BEGIN failed--compilation aborted at /usr/sbin/squeezecenter-server line 160.

Which would seem to imply that maybe my problem is with Exporter/Lite.pm?

Anyway, CPAN didn't want to update it either, and as of now I need to go eat.

Mostly writing this in the hope that someone can help, and that if anyone else has similar problems that this may help...

[carl]

Check if the package "libexporter-lite-perl" is installed.

[NightGeo]

Check if the package "libexporter-lite-perl" is installed.

It doesn't seem to be.

[NightGeo]

Next steps.

I used apt to get libexporter-lite-perl and libtie-ixhash-perl, as i saw errors on them.

Tailing the log I then saw:

Code: Select all

[09-12-05 10:38:27.1729] Slim::Web::HTTP::init (124) Warning: Can't locate Template.pm in @INC (@INC contains: /var/lib/squeezecenter/cache/InstalledPlugins /usr/share/squeezecenter/CPAN/arch/5.8/powerpc-linux-thread-multi /usr/share/squeezecenter/CPAN/arch/5.8/powerpc-linux-thread-multi/auto /usr/share/squeezecenter/CPAN/arch/5.8.8/powerpc-linux-gnu-thread-multi /usr/share/squeezecenter/CPAN/arch/5.8.8/powerpc-linux-gnu-thread-multi/auto /usr/share/squeezecenter/CPAN/arch/5.8/powerpc-linux-gnu-thread-multi /usr/share/squeezecenter/CPAN/arch/5.8/powerpc-linux-gnu-thread-multi/auto /usr/share/squeezecenter/CPAN/arch/powerpc-linux-gnu-thread-multi /usr/share/squeezecenter/lib /usr/share/squeezecenter/CPAN /usr/share/squeezecenter /usr/share/squeezecenter /etc/squeezecenter /usr/sbin /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at /usr/share/perl5/Slim/Web/Template/SkinManager.pm line 14.
BEGIN failed--compilation aborted at /usr/share/perl5/Slim/Web/Template/SkinManager.pm line 14.
Compilation failed in require at /usr/share/perl5/Slim/Web/HTTP.pm line 124.
[09-12-05 10:38:27.3828] Slim::Utils::Prefs::Namespace::savenow (333) Error: can't save /var/lib/squeezecenter/prefs/plugin/state.prefs: Permission denied at /usr/share/perl5/Slim/Utils/Prefs/Namespace.pm line 322.
2009-12-05 10:38:27 SqueezeCenter died. Restarting.

So I tried getting libhtml-template-perl which didn't make any differnce, added libhtml-template-expr-perl next, also no difference.

I next tried libtemplate-plugin-class-perl which had a bunch of dependencies, but seems to have done the trick for now. Well, in that I get a bunch of stuff flowing through my logs, at least. I seem to be getting the following now:

Code: Select all

[09-12-05 10:44:53.9038] Slim::Utils::Prefs::Namespace::savenow (333) Error: can't save /var/lib/squeezecenter/prefs/plugin/cli.prefs: Permission denied at /usr/share/perl5/Slim/Utils/Prefs/Namespace.pm line 322.
[09-12-05 10:44:53.9212] Slim::Utils::Misc::msg (1165) Warning: [10:44:53.9157] Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Slim/Music/Import.pm line 161.
[09-12-05 10:44:53.9294] Slim::Utils::Misc::msg (1165) Warning: [10:44:53.9238] Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Slim/Music/Import.pm line 161.
[09-12-05 10:45:24.3862] Slim::Networking::Discovery::Players::_players_error (143) Unable to get players: Error on HTTP socket: Inappropriate ioctl for device
[09-12-05 10:45:41.4604] Slim::Plugin::InternetRadio::Plugin::_gotRadioError (103) Unable to retrieve radio directory from SN: unexpected end of string while parsing JSON string, at character offset 875 ["(end of string)"] at /usr/share/perl5/Slim/Plugin/InternetRadio/Plugin.pm line 85.
[09-12-05 10:45:52.5622] Slim::Utils::Update::checkVersionError (129) There was an error while checking for updates to Squeezebox Server:
Connect timed out: Inappropriate ioctl for device

I guess I now just go through step by step and try and fix those issues. BUT - it does look like i can navigate to the squeezebox web page.


My remaining question is - how come none of the above where in place? I'd take a guess that somehow my Bubba2 has a slightly borked setup. (But then I'm a software tester by trade, so I kinda assume all software is borked by default, it's professional paranoia...)

[carl]

I'm sorry for the issue with squeezecenter here, the two dependence you stated plus libtemplate-perl has gone missing in dependence from earlier releases.

[NightGeo]

Ahh, okay, so it was just a dropped dependence. At least we know now.