package bacula-director-mysql 5.0.1-1ubuntu1 failed to install/upgrade: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[Hontvári József Levente]

Binary package hint: bacula

While upgrading from 09.10 to 10.04 bacula could not upgade the database because of the previous error. The MySQL was definietely run well before the upgrade, but I manually merged its configuration file.

ProblemType: Package
DistroRelease: Ubuntu 10.04
Package: bacula-director-mysql 5.0.1-1ubuntu1
ProcVersionSignature: Ubuntu 2.6.31-20.58-generic-pae
Uname: Linux 2.6.31-20-generic-pae i686
Architecture: i386
Date: Tue Jun 1 03:07:49 2010
ErrorMessage:
 ErrorMessage: subprocess installed post-installation script returned error exit status 1
SourcePackage: bacula
Title: package bacula-director-mysql 5.0.1-1ubuntu1 failed to install/upgrade:

[Hontvári József Levente (hontvari)]

At the end of the OS upgrade, Ubuntu displays "A recovery will run now (dpkg --configure -a)." After this it again attempts to upgrade the bacula database, and it seems it have completed successfully.

[Scott Moser (smoser)]

- "MySQL was definietely run well before the upgrade"

  did you mean "running" ?

It sure would seem to me that the likely issue was that mysql server was not running when you started the upgrade. Nothing in the logs attached would seem to indicate that mysql was shut down.

[Hontvári József Levente (hontvari)]

Yes, I meant MySQL was running before the OS upgrade. Actually there is a log entry in VarLogDistupgradeApttermlog.gz which shows that it had been running for about a month. I had the feeling that MySQL was stopped by the upgrade script before the bacula upgrade, and indeed I saw a few lines *after* the failed bacula upgrade (and after submitting this issue, so this is not in the logs) on the console that was related to MySQL. Maybe MySQL was started at that time. Following that, the second Bacula reconfiguration succeeded. In the log file above I also see two strange lines:

(Reading database ... 55366 files and directories currently installed.)
Preparing to replace mysql-server-5.1 5.1.37-1ubuntu5.1 (using .../mysql-server-5.1_5.1.41-3ubuntu12.1_i386.deb) ...
 * Stopping MySQL database server mysqld 
[ OK ]
 * Stopping MySQL database server mysqld 
[ OK ]
Unpacking replacement mysql-server-5.1 ...
Preparing to replace ubuntu-serverguide 9.10.11 (using .../ubuntu-serverguide_10.04.3_all.deb) ...

I.e. it stops MySQL two times. On the other hand I do not find any line in this log file, which would indicate that MySQL daemon was started later during the upgrade (and before this issue report).

[vedavata (vedavrata)]

The same problem:
============================================================
Setting up bacula-director-mysql (5.0.1-1ubuntu1) ...
debconf: Unknown template field '_description', in stanza #9 of /var/lib/dpkg/info/bacula-director-mysql.templates

dbconfig-common: writing config to /etc/dbconfig-common/bacula-director-mysql.conf
Processing configuration...Ok.
 * Starting Bacula Director...
05-Oct 14:45 bacula-dir: ERROR TERMINATION at lex.c:784
Config error: expected a string, got T_EOL: =
            : line 236, col 12 of file /etc/bacula/bacula-dir.conf
  dbname = ; DB Address = ""; dbuser = ""; dbpassword = ""
                                                                                                      [fail]
dpkg: error processing bacula-director-mysql (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of bacula-server:
 bacula-server depends on bacula-director-mysql (>= 5.0.1-1ubuntu1) | bacula-director; however:
  Package bacula-director-mysql is not configured yet.
  Package bacula-director is not installed.
  Package bacula-director-mysql which provides bacula-director is not configured yet.
dpkg: error processing bacula-server (--configure):
 dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of bacula:
 bacula depends on bacula-server; however:
  Package bacula-server is not configured yet.
dpkg: error processing bacula (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
No apport report written because the error message indicates its a followup error from a previous failure.
Errors were encountered while processing:
 bacula-director-mysql
 bacula-server
 bacula
E: Sub-process /usr/bin/dpkg returned an error code (1)
============================================================

And the same during uninstall :
============================================================
2 not fully installed or removed.
After this operation, 0B of additional disk space will be used.
Setting up bacula-director-mysql (5.0.1-1ubuntu1) ...
debconf: Unknown template field '_description', in stanza #9 of /var/lib/dpkg/info/bacula-director-mysql.templates

dbconfig-common: writing config to /etc/dbconfig-common/bacula-director-mysql.conf
Processing configuration...Ok.
 * Starting Bacula Director...
05-Oct 14:53 bacula-dir: ERROR TERMINATION at lex.c:784
Config error: expected a string, got T_EOL: =
            : line 236, col 12 of file /etc/bacula/bacula-dir.conf
  dbname = ; DB Address = ""; dbuser = ""; dbpassword = ""
                                                                                                      [fail]
dpkg: error processing bacula-director-mysql (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of bacula-server:
 bacula-server depends on bacula-director-mysql (>= 5.0.1-1ubuntu1) | bacula-director; however:
  Package...

[Launchpad Janitor (janitor)]

[Expired for bacula (Ubuntu) because there has been no activity for 60 days.]