Package: postfix-mysql
Version: 3.7.9-0+deb12u1
Severity: grave
Justification: renders package unusable

Dear Maintainer,

With the update in stable-updates, this package seems to be no longer working. removing it and going back to 3.7.6 solves the issue. This is what it writes to journal:

Jan 16 14:58:32 mail postfix/smtpd[14969]: error: unsupported dictionary type: mysql
Jan 16 14:58:32 mail postfix/smtpd[14969]: connect from localhost[127.0.0.1] Jan 16 14:58:32 mail postfix/trivial-rewrite[14972]: error: unsupported dictionary type: mysql
Jan 16 14:58:32 mail postfix/trivial-rewrite[14972]: warning: mysql:/etc/postfix/mysql-forwards.cf is unavailable. unsupported dictionary type: mysql
Jan 16 14:58:32 mail postfix/trivial-rewrite[14972]: warning: virtual_alias_domains: mysql:/etc/postfix/mysql-forwards.cf: table lookup problem
Jan 16 14:58:32 mail postfix/trivial-rewrite[14972]: warning: mysql:/etc/postfix/mysql-forwards.cf is unavailable. unsupported dictionary type: mysql
Jan 16 14:58:32 mail postfix/trivial-rewrite[14972]: warning: virtual_alias_domains: mysql:/etc/postfix/mysql-forwards.cf: table lookup problem
Jan 16 14:58:32 mail postfix/smtpd[14969]: warning: mysql:/etc/postfix/mysql-forwards.cf is unavailable. unsupported dictionary type: mysql
Jan 16 14:58:32 mail postfix/smtpd[14969]: warning: mysql:/etc/postfix/mysql-forwards.cf lookup error for "receiver@domain.de"
Jan 16 14:58:32 mail postfix/smtpd[14969]: NOQUEUE: reject: RCPT from localhost[127.0.0.1]: 451 4.3.0 <greceiver@domain.de>: Temporary lookup failure; from=<sender@domain.de> to=<greceiver@domain.de> proto=ESMTP helo=<localhost>

So it simply stops providing the mysql support it was made for, which renders postfix itself unusable unless you where to move away from mysql.


-- System Information:
Debian Release: 12.4
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 6.1.0-16-amd64 (SMP w/2 CPU threads; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages postfix-mysql depends on:
ii libc6 2.36-9+deb12u3
ii libmariadb3 1:10.11.4-1~deb12u1
ih postfix 3.7.9-0+deb12u1

postfix-mysql recommends no packages.

postfix-mysql suggests no packages.

-- no debconf information

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

I agree it's odd. I don't use postfix with any of the external map types, so this isn't something I can really test.

Can you rebuild 3.7.9 against the older mariadb or if not, and I build it, will you test it?

Scott K

On January 16, 2024 5:05:54 PM UTC, Richard Rosner <rrosner@fsmuw.rwth-aachen.de> wrote:

No Idea when was the last update to mariadb, but the fact that the stable version has problems the stable-updates version doesn't while not changing anything else shows that something is broken. Maybe just the communication with postfix. Maybe the

breaking change was in postfix and not postfix-mysql, I can't tell. Just that v3.7.9 refuses to accept mysql as a valid option. Also, for me the logs look like postfix doesn't know what it should do with mysql, not like it can't reach a mysql server=

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

close 1060917 1:10.11.6-0+deb12u1
thanks

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)