[Bug 1791139] Re: postfix-mysql package upgrade results in server configuration error

[Andreas Hasenack]

Bionic Verification
===================

First, reproducing the bug. Since the postinst of other postfix-*
packages was also changed, I'm installing them as well, and not just
postfix-mysql:

ubuntu at bionic-postfix-1791139:~$ sudo apt install postfix postfix-mysql postfix-cdb postfix-ldap postfix-lmdb postfix-pcre postfix-pgsql -y
(...)

ubuntu at bionic-postfix-1791139:~$ apt-cache policy postfix
postfix:
  Installed: 3.3.0-1ubuntu0.1
  Candidate: 3.3.0-1ubuntu0.1
  Version table:
 *** 3.3.0-1ubuntu0.1 500
        500 http://br.archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages


# Creating condition for the bug:
ubuntu at bionic-postfix-1791139:~$ sudo sed -i 's/\(alias_.* =\).*/\1/g' /etc/postfix/main.cf
ubuntu at bionic-postfix-1791139:~$ sudo service postfix reload
ubuntu at bionic-postfix-1791139:~$ 

# reinstalling the same packages, showing the failures, one per package:

ubuntu at bionic-postfix-1791139:~$ sudo apt install postfix postfix-mysql postfix-cdb postfix-ldap postfix-lmdb postfix-pcre postfix-pgsql -y --reinstall
(...)
Setting up postfix-pcre (3.3.0-1ubuntu0.1) ...
Adding pcre map entry to /etc/postfix/dynamicmaps.cf
/var/lib/dpkg/info/postfix-pcre.postinst: 33: [: =: unexpected operator
Setting up postfix-mysql (3.3.0-1ubuntu0.1) ...
Adding mysql map entry to /etc/postfix/dynamicmaps.cf
/var/lib/dpkg/info/postfix-mysql.postinst: 33: [: =: unexpected operator
Setting up postfix-lmdb (3.3.0-1ubuntu0.1) ...
Adding lmdb map entry to /etc/postfix/dynamicmaps.cf
/var/lib/dpkg/info/postfix-lmdb.postinst: 34: [: =: unexpected operator
Setting up postfix-ldap (3.3.0-1ubuntu0.1) ...
Adding ldap map entry to /etc/postfix/dynamicmaps.cf
/var/lib/dpkg/info/postfix-ldap.postinst: 33: [: =: unexpected operator
Setting up postfix-pgsql (3.3.0-1ubuntu0.1) ...
Adding pgsql map entry to /etc/postfix/dynamicmaps.cf
/var/lib/dpkg/info/postfix-pgsql.postinst: 33: [: =: unexpected operator
Setting up postfix-cdb (3.3.0-1ubuntu0.1) ...
Adding cdb map entry to /etc/postfix/dynamicmaps.cf
/var/lib/dpkg/info/postfix-cdb.postinst: 33: [: =: unexpected operator
Processing triggers for libc-bin (2.27-3ubuntu1) ...


a) upgrading to the fixed packages
# Installing the fixed packages on top (I enabled universe for bionic-proposed because of lmdb):
ubuntu at bionic-postfix-1791139:~$ sudo apt install postfix postfix-mysql postfix-cdb postfix-ldap postfix-lmdb postfix-pcre postfix-pgsql -y 
(...)
Setting up postfix-pcre (3.3.0-1ubuntu0.2) ...
Adding pcre map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-mysql (3.3.0-1ubuntu0.2) ...
Adding mysql map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-lmdb (3.3.0-1ubuntu0.2) ...
Adding lmdb map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-ldap (3.3.0-1ubuntu0.2) ...
Adding ldap map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-pgsql (3.3.0-1ubuntu0.2) ...
Adding pgsql map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-cdb (3.3.0-1ubuntu0.2) ...
Adding cdb map entry to /etc/postfix/dynamicmaps.cf
Processing triggers for libc-bin (2.27-3ubuntu1) ...
ubuntu at bionic-postfix-1791139:~$ 

Worked just fine.

b) fresh install scenario with the fixed packages
ubuntu at bionic-postfix-1791139:~$ sudo apt install postfix postfix-mysql postfix-cdb postfix-ldap postfix-lmdb postfix-pcre postfix-pgsql -y
...
ubuntu at bionic-postfix-1791139:~$ apt-cache policy postfix
postfix:
  Installed: 3.3.0-1ubuntu0.2
  Candidate: 3.3.0-1ubuntu0.2
  Version table:
 *** 3.3.0-1ubuntu0.2 500
        500 http://br.archive.ubuntu.com/ubuntu bionic-proposed/main amd64 Packages

# creating the conditions for the bug:
ubuntu at bionic-postfix-1791139:~$ sudo sed -i 's/\(alias_.* =\).*/\1/g' /etc/postfix/main.cf
ubuntu at bionic-postfix-1791139:~$ sudo service postfix reload
ubuntu at bionic-postfix-1791139:~$ 

# now reinstalling the same packages:
ubuntu at bionic-postfix-1791139:~$ sudo apt install postfix postfix-mysql postfix-cdb postfix-ldap postfix-lmdb postfix-pcre postfix-pgsql -y --reinstall
(...)
Setting up postfix-pcre (3.3.0-1ubuntu0.2) ...
Adding pcre map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-mysql (3.3.0-1ubuntu0.2) ...
Adding mysql map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-lmdb (3.3.0-1ubuntu0.2) ...
Adding lmdb map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-ldap (3.3.0-1ubuntu0.2) ...
Adding ldap map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-pgsql (3.3.0-1ubuntu0.2) ...
Adding pgsql map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-cdb (3.3.0-1ubuntu0.2) ...
Adding cdb map entry to /etc/postfix/dynamicmaps.cf
Processing triggers for libc-bin (2.27-3ubuntu1) ...
ubuntu at bionic-postfix-1791139:~$ 


Worked just fine.

Verification succeeded.

** Tags removed: verification-needed-bionic
** Tags added: verification-done-bionic

-- 
You received this bug notification because you are a member of Ubuntu
Server, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/1791139

Title:
  postfix-mysql package upgrade results in server configuration error

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postfix/+bug/1791139/+subscriptions