• Re: postfix-mysql broken in 3.7.9, results in unsupported dictionary ty

    From Scott Kitterman@21:1/5 to aachen.de on Tue Jan 16 11:48:39 2024
    On Tue, 16 Jan 2024 15:09:18 +0100 Richard Rosner <rrosner@fsmuw.rwth- aachen.de> wrote:
    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

    I'm not sure where this comes from. There are no mysql related changes in
    this update. I note that the mariadb version is different, so I would think it's more likely the issue is related to a change there.

    Scott K

    -----BEGIN PGP SIGNATURE-----

    iQIzBAABCgAdFiEE53Kb/76FQA/u7iOxeNfe+5rVmvEFAmWms2cACgkQeNfe+5rV mvFj/w/+MyfE//V/iYFBgvGkv86WjhiXrRPZq6e8NClfg8GSghNG5bJMKdwWudy3 PBxLdmtbCXmVAoEWVPk+F7ckdF4qWA2bLoJ3NvFR/qo+PTj4SEGUwHzNGzOjR5fK 44rbNmPS++GxkyayMfcehA1jLEtSbngV3Kgt8QFwmazbrG56B+7UCpdiToccs1fB Oi/ELNiyWT4SqetCECoIj5QJAk9G2kqUd+Jibx/3oL55dMasPJT2qqCu+faQfzm3 Oq5MoeGn5HSA9InxhM6lblm3Htlvcjenwh5VCWnT49q1EDcsUg46FNaW19hmX4ZW jcx4ujIo9uB67Lk7qUEG44E23unuRt8HAN8SfRykSl0hyuJBAnjClZZdrhXkAOFD XYTYPSH0R372Ktl4VsnVpUyj48VRmuiVTtDyxyscfKKMJgLoGCsw9iX1iSo2VggD PrYOFtERhJQBgtdujroj0RU8LmtQw7UjOWOhVgssMP4L1dSZZYigFgfb+aJUkSqK gyHQyGXyqONpAJc4eoC5jhuqp4uL7opQHAo1nBtgk1XYKn6Rvu8LimkPIUNSUOzr OBFTnOcfLZ6gvzr/2IfkWr/Ij9yTGDFsbxYRkBLbo/OcPhR/uREKad+i6tfmKo2I llQ0t2dw8MromtFL2Dtobn5PY0zVL1mZXXDNktcsWbTWGkyG5N4=
    =fdGw
    -----END PGP SIGNATURE-----

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