It's slightly more complicated because you have to make sure you get the old version of mariadb. I'll build it and send you a link.

Scott K

On Tuesday, January 16, 2024 1:08:51 PM EST Richard Rosner wrote:

Would that be more than

sudo apt build-dep postfix-mysql
sudo apt install build-essential
apt source postfix-mysql
cd postfix-mysql*
dpkg-buildpackage -us -uc

? Otherwise, if you want to build it, I can test it, no problem.

Am Dienstag, 16. Januar 2024 18:19 CET, schrieb Scott Kitterman <debian@kitterman.com>: 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=

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

iQIzBAABCgAdFiEE53Kb/76FQA/u7iOxeNfe+5rVmvEFAmWmx2oACgkQeNfe+5rV mvE7PA//Shb8z+SMTfgzYPBL57AwO/fCZH/u/E0SB0BDiGxnF/Jus6pgTDx8XguW PvlG8QRlrBPIZH0wt4++TawA64ky2XojfCfkqNazbP3OlvBwQvQezFzd+uPP2bFS JMYm/o9vQmTsANmmxB9cLuofARZVZfPVUbHVS9fqv5akNad/fHCuGoemHwKlTSux Y1AFWs45X7eiRuvy0DWc5BWmBwYEGXzTj5gtcWvRBMvWvQHNASXV1Ni7xXKlX8Ft UQv/usj3+B+5e4ArJZ/6QvdK75IfAE9qceEzTlw2O7Mx1Z3XMpulL3yNIMvK3kta vlXjE8dYRQp2VvqKq5sHYAi+s+qhbGtrz8NGf9ZgPODC4mL27EPq8V9gE2n3zQHi Cx3TNNR6UA/kr9ABYnNioMGGzTsZAq5izSiXwACmuNwLzmCbRUGL8OYzg8BkADpf CvPyzkEoyZ4HG51DD/jTeIa0sl7b1cAmy+Xc+7kQRwo6FotZcxRt1SCpazuDxj1O 1JHiiIC7NHoN3lPgcWLmb0/w9DzuzVi3oDJK36In7FkihogCuSijXpGUIXKUs8lc sH7cFeBXBEfkkrAiaQBSSZJ2Lvd8dT7abfCMmKAAv1FX0MGoTF7bZOJ11pIDpEt1 tEO0NBkxdhO5mGTXABhKsbpnFJNeciTfMq4MgbffvB3SpLcKA1M=
=+oKT
-----END PGP SIGNATURE-----

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

Rebuild binaries are available (for the moment) at:

https://kitterman.com/debian/

I'll remove them once we've done testing. That's all the binaries built by postfix. You'll need to download and then use dpkg -i to install all the ones you have on your system, not just postfix-mysql. At a minimum it will be postfix and postfix-mysql.

Let me know how it goes.

Scott K

On Tuesday, January 16, 2024 1:14:02 PM EST Scott Kitterman wrote:

It's slightly more complicated because you have to make sure you get the old version of mariadb. I'll build it and send you a link.

Scott K

On Tuesday, January 16, 2024 1:08:51 PM EST Richard Rosner wrote:

Would that be more than

sudo apt build-dep postfix-mysql
sudo apt install build-essential
apt source postfix-mysql
cd postfix-mysql*
dpkg-buildpackage -us -uc

? Otherwise, if you want to build it, I can test it, no problem.

Am Dienstag, 16. Januar 2024 18:19 CET, schrieb Scott Kitterman <debian@kitterman.com>: 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=

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

iQIzBAABCgAdFiEE53Kb/76FQA/u7iOxeNfe+5rVmvEFAmWmzHsACgkQeNfe+5rV mvFO0A/+MbPLxYvvftreeL2DXc+x9/ORWr+NzNuRVKLr/vViYCq0O1p+cBWl2VpU jp2snWftqvkfqlzt/iEYdn3VHt19svk2djkDbydO2buk1cQ8eri/feNebrLVuwgj xlzpBknBv3sBL+VOUscZfzU0Q8fJKxTnEOU4dbtmwwhPezSuXrVuMUilR7WsAMBT W30LKogV8CLYWj0zqm0tn8FV6uwgz6yhftqQx9U/2tZwFnoSX6d1PSD7N3hZ/6eR 0kmtT9QW9kimEXH8dByNjEWU6AaIZDPD6hfI1l7hm6nOarSVBJ0EA5262fukgdIv xpp1k6HUy36UBtvzeZaWUgxkCy9BRXKnARipiPHxqmrCsO76k0SX1AwaZP6MrkFs PRPIN0X98SKusZ5m36yfw3U00edIE2Ti0I94gYZY0Dh2cpiYa2IcGFDp7Ypn5fEH prmq2R0vFnkXcfeh1G9Kbo6wWB6y7crIB3E48QFsO96xyRtY9YmLU4HNVs78YLks nKPFddWbTxScs7lEM+1mgkzBi37dc1QD3sNg1DFrXObYPcZ8krBBzt9ULC88vOxE d3pIvpdpE+ynh0hT5M5Hp7dz/d2wynbxgRWKjQu3Pvwfxa6JUKFZiCaOkxVENFsX ND32vN9BdR6TwQlFPtnV1Ov8BmlIth5FVleMWsvT6GBCfteQYM8=
=8oK1
-----END PGP SIGNATURE-----

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

Excellent. On that basis, I think blaming mariadb for the regression is appropriate. I see there's another mariadb update pending. If would up for another test, I'd like to see if that update solves the problem. I'll build another set of packages against that and if that works, then we just need to make sure we get that update accepted and rebuild postfix.

Scott K

On Tuesday, January 16, 2024 2:25:13 PM EST Richard Rosner wrote:

These packages do work without a problem.

Am Dienstag, 16. Januar 2024 19:35 CET, schrieb Scott Kitterman <debian@kitterman.com>: Rebuild binaries are available (for the moment) at:

https://kitterman.com/debian/

I'll remove them once we've done testing. That's all the binaries built by postfix. You'll need to download and then use dpkg -i to install all the
ones you have on your system, not just postfix-mysql. At a minimum it will
be postfix and postfix-mysql.

Let me know how it goes.

Scott K

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

iQIzBAABCgAdFiEE53Kb/76FQA/u7iOxeNfe+5rVmvEFAmWm2rcACgkQeNfe+5rV mvERAw/5AWI4WNyYQdanYtfgDvuFEQH27qfUTNkT63BnmCwYw09cVdQATz4FNZSr rgj8H3zHUj1cmqwz4JGLYTMD98dTYMb//Mgileoef9Bh8MJHhEWsmT4fvUbuTV6N Iz05YDm4bkTCBELUirkhamVJf7j/YzbWh1IbVlChg+th6d7YyxB35Y2H5zibl8b1 uodMl9DZbHQQNrdZ6c6QK/cuhwTa90IO6msac29kRvOAamOwxIfsip/kdow4TDKj XtavpEFx9Jz1TPZqM2erS64DCOSFV4Rj52oTH9UrMXvjuLRgbbLaniqjDQ/VpLuy 5QXdQNMSIawoRnmeKvYUVCq7yphJGUsxMQpi/r+zUFGlV+MsVrxHRToCvfMYCb7n /8VbhJwjJQ+ewVTKii5zQzlN4XlA92cOyeg2Gk4/uqV5EcG0HiWfQprpMwlxjKDU o8CkrZgTdiqaDI0j80xMjq1jZVg5RjZxhn6quk2IYrQX6H9IfeLEK7IlYrUZQZ+G 6wko490Sg4z79dkWatCat3obmU38yNZWV6uU0NGttRYF1htXt+OXKH1Lahaq0bYc L3vPAu31XMJMD82A2E4wF04xrtxIihrqthCNTCIhYK/90DkgYdd0h2v8xWqXWSNR L1O9pRvdi/CB49UUttrjLcn/DkCUyESo8Mpt9I3O6vNDh1qhGLE=
=Dl83
-----END PGP SIGNATURE-----

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

So, the magic needed to build the new update exceeds my grasp, but it's debian/changelog discusses fixing regressions. On that basis, I think the thing to do is reassign the bug to mariadb and mark it as affecting postfix. I'll also bring it to the stable release manager's attention.

Scott K

On Tuesday, January 16, 2024 2:36:23 PM EST Scott Kitterman wrote:

Excellent. On that basis, I think blaming mariadb for the regression is appropriate. I see there's another mariadb update pending. If would up for another test, I'd like to see if that update solves the problem. I'll
build another set of packages against that and if that works, then we just need to make sure we get that update accepted and rebuild postfix.

Scott K

On Tuesday, January 16, 2024 2:25:13 PM EST Richard Rosner wrote:

These packages do work without a problem.

Am Dienstag, 16. Januar 2024 19:35 CET, schrieb Scott Kitterman <debian@kitterman.com>: Rebuild binaries are available (for the moment)
at:

https://kitterman.com/debian/

I'll remove them once we've done testing. That's all the binaries built by postfix. You'll need to download and then use dpkg -i to install all the ones you have on your system, not just postfix-mysql. At a minimum it will be postfix and postfix-mysql.

Let me know how it goes.

Scott K

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

iQIzBAABCgAdFiEE53Kb/76FQA/u7iOxeNfe+5rVmvEFAmWm4FAACgkQeNfe+5rV mvHR7g//QmSXE9+K1BgimGu5hzZII+Pyx54IxfikMZxr3tNtaGPRSXIcmNRN498X Z3ZlyhY1VU6FnJf1KvymWpqdO7yoabcBf0IkKHzwZNcKWqIlbXdGIQXJIBwYnjWr q55YfO/kmHEEEVvHzUWOKohXO7j8XAIM1mG+YCkEWbJ60/YuoW9ZmBaW/Lo7EXNQ W1hFmLGxYrJ65TqN+lSPZ4ZJQYfCN6qrPF99q8V2iTrmGxD1BE4Yr0FUNshsVDtr 8x/kW1jnvgPxdSWK1GdaDYY7Yttf7HLbU9dDe90P0vK0XUd9jfXneg81gRQ/UPRK ZPcmfZWmG44b2xFrr21EsQriW6ernQ8QbzgN2JgWFEVw8AceesmXl7bJxtYh05Vb Y/yyTHcj1ue95a9g+w9qUKbZ7DrfEG/Pywm3mBwkAkj3QN+OksCRf2y6U+DgeW+N k4SJbvmzwdrPmCA1Cuc3FOwh25VGhhEdL3eoAxEr2TFPTdWWmGgtT7RoHZbh9tRP i4o+dNT0b5fBagvBd9fQyZbxD4oip/p6fP2yZTf0NqoqKsUjffVwOk/3tlaLTTvW XaxM50/hqUzK8sIEi+N5YC4qRpodtdGB0Yytg4Vu8LkdxjCrVzwcQKfK0e2beiml pqeYvWeYSQSXNNW8udwq3eF8crkcxqrV/B5wwnOISZdOWAkbrwo=
=OIMY
-----END PGP SIGNATURE-----

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

They accepted mariadb 10.11.6 as a proposed update and I rebuilt postfix again.

Updated packages (and the first ones also, note the slightly different revision number) at the same location:

https://kitterman.com/debian/

I'm not sure if you'll need to upgrade your mariadb packages. If so, they can currently be found in incoming:

http://incoming.debian.org/debian-buildd/pool/main/m/mariadb/

After the next dinstall they will be available in the bookworm-proposed
updates repository. For incoming, you'll need to wget the binaries and use dpkg to install them. For bookworm-proposed-updates, you can use apt with an appropriate entry in your sources.list.

Please test and let me know how it goes:

Thanks,

Scott K

On Tuesday, January 16, 2024 3:39:43 PM EST Richard Rosner wrote:

Good to know. Thanks.

Am Dienstag, 16. Januar 2024 21:00 CET, schrieb Scott Kitterman <debian@kitterman.com>: So, the magic needed to build the new update
exceeds my grasp, but it's debian/changelog discusses fixing regressions.
On that basis, I think the thing to do is reassign the bug to mariadb and mark it as affecting postfix. I'll also bring it to the stable release manager's attention.

Scott K

On Tuesday, January 16, 2024 2:36:23 PM EST Scott Kitterman wrote:

Excellent. On that basis, I think blaming mariadb for the regression is appropriate. I see there's another mariadb update pending. If would up for another test, I'd like to see if that update solves the problem. I'll
build another set of packages against that and if that works, then we just need to make sure we get that update accepted and rebuild postfix.

Scott K

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

iQIzBAABCgAdFiEE53Kb/76FQA/u7iOxeNfe+5rVmvEFAmWnEpMACgkQeNfe+5rV mvEaPg/+LD3Cz7ddvwIB3qKpT0KzrRQYu5ZilFToNq/qls0nWRQtiRk40WDZthik mFLyN7zwNsNzoWZ/ZtyYmjGYKGrL6yNIOZJrRQgtbxv/jGfYbS+8nmGACdNpFnnm dsnVnw++4g+IopNZe9dHgWk5wlahWzHhP3alGPNjNH/67LFtMcNfEy8lwX2VB4Ko 4qv5tYKrM7Lj6NeQWd+uxppHSNjEHH19BKTiKeQ4DlhSYX83RoUGdsBj/j1bKZD1 yzdDNDahvHaX82yxfL9uGJCYlJxZbcjuKVrgIU8pqSJt95rHBJD0wTWm/ffCPGYf U0Jm94ZT3SVAS8t/Lds95iV5QZo0Pp73Io8Lz2494RXAWGZ0cw2EKhHIhQwAcaAg 9o0mB4pkBwB4d8d6WKtnvSmqMeav+u2Rd/bS1S+0dI1QzjL6Ei1iSQhZNeeXVTKo 8INN6J/TVYELwx+Ksp9r4tpxLuijSN52N7P/KhJKV2ObNUmFZT/gv/CI1p82hSau OqxxTG5Srv6Pz3uh5NWihzG3XPj8WkX6JBN1xAUHMc3Owg3cSkyqOdWyIbnqgC4h uV9eTkjSBWc/m7JNxIbx/mUIDpPYJ4es7J++Wtpdo62QTu7zPPkDszJiVADNU4Br XQYawwfuvR9FbeCSD8IkxRMzWHwC0RpgsGHUAL4a/fqBAcjX7Uo=
=SqDD
-----END PGP SIGNATURE-----

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

On Wednesday, January 17, 2024 9:03:29 AM EST Richard Rosner wrote:

I've updated all mariadb packages to 10.11.6 and all postfix packages. Everything still working.

Excellent news. Thanks for testing.

Scott K

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

iQIzBAABCgAdFiEE53Kb/76FQA/u7iOxeNfe+5rVmvEFAmWn3rsACgkQeNfe+5rV mvFGsRAAuQPTQvzqbVJb+N+GFGvczkkQTnv34PCOSIPRYym2pnw2NB4naUJOfxvZ Q3iQ8CcA3Bw9gwdikM49MBfwnttSubjcGxtUW/eZa/FiWGROBK7k9r8IihqWwU2e kezjN6CIPJ14c5jG6JcoJYuuTaYv7b7WMmIFZF/ru/Gc8dpEZMBsY4PIoMjStMjV ii+MRZzIdMpM+dMvLlsupfeKN5McZCHQgdmBhV3wHVjDvke9FOxTpxd+HeWytYJJ wvTqBusLBoObW2VNy7kXuT8TqevXcNaaecqodYF8ec5DfEGV4Usfhg8E3CSg2dPc LV44rKbmPrCPP16OHPvKbAENPMtQhadY+UHM0T3PG2meXnj+tffqaRamNNWWcige +pW22YwArL2vInaxczIpJ0mbwHsijGDBP4ZwEJOBEN2Y0k5dPt9UKq//v42pohJj oloRro2v1PIUT8VRbpcrSdX1FAfFb57PeDNkk9vR4SqikYx84o6Ln5LAXM/lTBLr DwyUAGcLjsj+7ywPmyZRf2I6qYHSU/G88nkcm97UZw9oVpb5UDPMC8VSXcgV+Vzj Tf4ubhUdEPkqadSjk8Fc5pkKpFXtJnM+qTtj0kWmIoGrwYlsOKSlG7bnsRWwKbFN rn4SlAl4V5M/r0NuofRRQ4iRuGzv5QSrj6Z+WvxUDONKReguxxM=
=ltyo
-----END PGP SIGNATURE-----

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

On Wed, 17 Jan 2024 09:05:47 -0500 Scott Kitterman <debian@kitterman.com> wrote:

On Wednesday, January 17, 2024 9:03:29 AM EST Richard Rosner wrote:

I've updated all mariadb packages to 10.11.6 and all postfix packages. Everything still working.

Excellent news. Thanks for testing.

Postfix packages in bookworm-proposed-updates have been rebuilt against the new mariadb, so I think this can be closed now. If anyone runs into this problem with the packages from bookworm-updates/stable-updates, install the rebuilt version from bookworm/stable-proposed-updates. After the next point release, this will be entirely OBE.

Scott K
-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEE53Kb/76FQA/u7iOxeNfe+5rVmvEFAmWsKNgACgkQeNfe+5rV mvEQKhAAoFNJAhU3Eumju2g4xtqR259jb5W96q/3eXMaXVB8bX4n1diIWv9cEdVv I9mGSeb8qapKP5LTuw3TUqcIUWTgZkLRulZwiJrVJH2DGRC2QGT7AD2m6ZAphw6k eqIc79mxFJgcZGJvwNJWIU4X03Km0tPiaYtjL2BxCXtPCOmDxxuwx4Ysh2yMH+OX zIgzYHije7tYkQ796E/LVTEoObDvG6dQGEyDjQ0n+D2+IOIz07c5ZOfpisAq78uj Onjh5hAi+9LE5i7oSEPEjkQy3nCvaWVXqGK16vmiIXaxvmHeyky4ClX5ynz65cHC 0AvQCcZvW6ixlm5i0wm33/bRQ0KzbKwZiLbzKITQUS82Xzppdvu7997l0QXaYQH7 8LXoLkPI3MHfjkBMlsM66+xrK4lZX0ne7GMVoqxIGYM34MRERmEI2nut2o9J09s/ bcmwhZQ+peupXohySjhz5D7T6yLVRPM+wq+D+3Cb1jzsrPz1aZUfwgO/23iF90fS gp3he8sEQg/NgWrhfaP+ZTPuivTQT8WmEqt8YRl1y1oFnSLJqWST+SQDDcfZKKXv 8Yrrklj+SYpxGcDtz9RvvjOgl41DYo4Mh7Ib+DEDn0WL8z8S41576Url7xxJMHpW UfMRiv/9QdpSotOUUnf82GtjEO6WDKTXbUBzyysmjQ9KyWvfGoA=
=6lLy
-----END PGP SIGNATURE-----

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