package bacula-director-mysql 5.0.3-0ubuntu2 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1. Also, the database it needed could not be created.

[Matthew]

When the package installs, it attempts to create a database, but fails because the command is run as root during installation.

ProblemType: Package
DistroRelease: Ubuntu 11.04
Package: bacula-director-mysql 5.0.3-0ubuntu2
ProcVersionSignature: Ubuntu 2.6.38-15.64-generic 2.6.38.8
Uname: Linux 2.6.38-15-generic i686
Architecture: i386
Date: Tue Jul 31 21:09:36 2012
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release i386 (20101007)
SourcePackage: bacula
Title: package bacula-director-mysql 5.0.3-0ubuntu2 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to natty on 2012-04-01 (121 days ago)

[Clint Byrum (clint-fewbar)]

Hi Matthew, thanks so much for taking the time to file a bug report.

This is a common problem, but not actually a bug I'm afraid.

Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.63-0ubuntu0.11.04.1_i386.deb) ...
Selecting previously deselected package bacula-sd-mysql.

Because mysql-server can only be a "recommends" of bacula (since it might live on another server and not actually be depended on), apt and dpkg are free to configure the mysql server *after* bacula. But this breaks the bacula installation scripts.

I would recommend that you remove bacula, and then install mysql-server, let it fully set-up, then install bacula.