Re: DBD::MySQL upstream change

Florian Smeets <[email protected]> Sun, 31 Mar 2024 10:03:33 +0200
Newsgroups gmane.mail.virus.amavis.user
Message-ID <[email protected]>
On 31.03.24 03:34, Noel Butler wrote:
> On 30/03/2024 22:41, Florian Smeets wrote:
> 
>>
>> From what I gathered, the DBD:MySQL vs DBD:MariaDB situation is not 
>> easy. You cannot just replace it one for one, some care needs to be taken.
> Care to explain this blanket statement? Or are you relating to FreeBSD 
> that does something strange to be that way?

My mail contained two links which you stripped that explain issues 
people saw when migrating to DBD:MariaDB.

https://blogs.perl.org/users/grinnz/2023/12/migrating-from-dbdmysql-to-dbdmariadb.html
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=277889#c16

I haven't analyzed it in that much detail to say if it will work in most 
cases or just in a lot of cases, all I'm saying is that some care needs 
to be taken as there are subtle differences, so not a 100% drop-in 
replacement.

Florian
OpenPGP_0xEF5BA4DCD5A9F3C0.asc (application/pgp-keys, 8.6 KB)
-----BEGIN PGP PUBLIC KEY BLOCK-----

xsFNBFpyBwsBEADLq0c46orEtbMn4SptX+VJxR1wB4YwaErZme1bqF4nZHIhlRNE
T22HsHdQdoagaB4uACq0Rj5kHcu614ZnnNkLPyCxWQATx+cbdiFO4/hfT8tAvKnB
tiy3awKJ5uGCNO2EzJwXW6KwdDA8XPRySqN8m1yPl+dW0Cls+/vO/QL/6+YLMupm
EpSvFxRzAZTQuKyX4+xl+dYId24JiPd1yfCuDNOY3+OZ3QBMT00u/699N8lUWRti
TwaQMwAOww8r/26YM6/SgcgFuLH2E/CVplY0sDvfoISlAj8agxdomNXfPjCMQ6w5
yGZmA+huFpPCVBTi3on/SWgbQO7dLVpN4BNPuScPosCb/dsOg0S74zCClsIU3gdU
Gh9rwJY00/Ebid6V0R3c1Czwbg8LQedzlGDuXYXmzp6W2ujgr1cqbUD6lUWikUv2
IMdCbb8MxYhHLi3GYUs5Xpi+W7vM6T45KbuMr7O/1SjtcGOlNeDvGNgjcDk20fOg
PPZ+M6i9vX5Q2oI9HoYaeTiYNwILkBLVP/L40kTo5EkiQOt4OW6BMbylqXPOaQMW
uGVbmhCJQpbx8Vo80s2yiBBVWkLkWQIcIm3KZlLldJqKEFpQBWLBE1eFFqboYgAW
zFn73CaV5tihobijMmmOV3a8cI1fI4kREyl3g+8bW+O0u3m3tuzVOpDpjwARAQAB
zR9GbG9yaWFuIFNtZWV0cyA8ZmxvQHNtZWV0cy54eXo+wsGXBBMBCgBBAhsDBQsJ
CAcDBRUKCQgLBRYDAgEAAh4BAheAAhkBFiEE7LNouHkIv7aRTXJp71uk3NWp88AF
AmWarWAFCQ7rjOUACgkQ71uk3NWp88AYfQ/+MJWYN95HXWcWKw9mOffW6WJvq5PO
E2RpoBXj2AJvzjF4bPt/mclA0+wlyAs6ayvCSRwEdgB0vF31DRPgsz/76PC3f1AD
YbLdrGusCcPYMhvkgkXY6/p793YzI2ELjicHgn2pB9iy0Y+BnemAY8qXGqTX4d/q
PllFcEOVZCDHez0JEFNCZC780pEzOHP9mMzXT/Pl4RBUBHOLv9j96enMIr8VXoMk
fNJ5GqdF577Aa/C46pUoOeSc2KvS/5g3axSFLho/ni70M4tjGXMYDdbnNHOg/UjG
iKKuZgzI9CXrvVAZfX663ERps/GXu1IiaJdadnQaLgPvjCjz0qM14hy/n67fCSqm
YdKgwblUGvKC912vGsMN1ibS+7xoAsCiM4w+Ct2plOLO3rJ26xaZZlE137GpLh4R
nnvrnDFUBEG47tZJO8wbedt2KwRKTPle136WedzjVlcuKoH1T9Dem6E1P9TUfNHq
OYtD7iUouWYkftSoRAhkY4ISbDRlz2dqRagbHR1T0DXhraQyswQucoVQPTsy9PoX
AZLY73Jep71nl3zQCTRXn7aSj2RO2ob0RvnBwueXdFpb1SfCeJwJhadmOuYF/i8R
IskAzG0aapYT8VUe8tqjmsKM/MWTcngjWf/7u/7+xmtdpGqI7oY3SGbyu0rw+xIC
XrD28N1H8kyazJ/CwZcEEwEKAEECGwMFCQeGH4AFCwkIBwMFFQoJCAsFFgMCAQAC
HgECF4AWIQTss2i4eQi/tpFNcmnvW6Tc1anzwAUCWnIHWAIZAQAKCRDvW6Tc1anz
wMHxEAC7Bd/rmRO1XAMAkQWddCZHHyr9t9XlZYxVVkwz3Mw6YszTTo+UmWez28MT
B9eRSxM4qkL0YRER0JXGypD9apis7Q7zIthExjQhDrDYHlxXO9/UPBjoWhzvM6kS
C8C3mYJH0GgnV4d/3QqsdhTF/wBpaMn8ITgR03jAO8Rjbe1DWi/RF6I1miQp8opE
XytFsGGnBFxHLNXh5qHda8orI7I8gYqq5cbQZaGC3Let822KifwCiYWhCUrSUKrn
uiRCPQctLe8tPNd7G99awtz6ctdPx6jztyUxBpjPuHkSOozSvgU9GYYnXydDnACu
3m85/mhG/3RFIfdAktrFV2+3QEIOvazUnm1MbuBk/+srLP0Gs+1W8HCIcRbyOHDi
UNtXfEhQRWSPhQSwz1eQesep3wmIU1lk48TblWS4B6h7IHeP2SZ9lzMX9/jVwenm
/lHJNq+1r1BYDpDTsBE+7YkIEww36Un0b86TwmVSBIY7Adn7dHuOO8MwQWHgMmEX
YHvsN0vGktUlLSHlxLxYzpr+ObVKToMCLhuCSx6293IT83/LFCYeiR0phbYsYOB3
tzB0zZfrrRq8VF7iiBnQ94tGKY9vIm5I3b6FkL9/LmMS/k+9n7qym7BgxgMKV59G
m8EOqYILG18zUs0VGJeN1i9R0e9Dd9pwPM2k6Q8unRV7GMknYcLBlwQTAQoAQQIb
AwULCQgHAwUVCgkICwUWAwIBAAIeAQIXgAIZARYhBOyzaLh5CL+2kU1yae9bpNzV
qfPABQJh8FPUBQkLSJbfAAoJEO9bpNzVqfPA+nQP/2DYXGFQ0UqSwzTCxPa6idAx
yRWiEWn6RMRsUIRx4kCqHl8I/O1QikT/vrG3sEuN4NIcOtzYf7/y9lmwMBeELxdz
DgIaIohmjWaB6Tytl8GlnKmvJ4dkCtvBudT8y6KAMe/LWoCAWMj92aEZYbttmHt7
TZzdH9XJBCTEaCQDzu4QxsxRNN5HGhbzrvQDjiTbmmcXVbKZ4urPAeJ/cax1VzTi
JcDKKtlE/Iq7TCW/mVrAW/zo/2VNPqJ4vFViTBDFsFYBDpcMHgMPDyvgtuBdrwI/
rWNw1EPWUAep1+D2XrEZ2ofeSCqwxSYzhoZnUpbNLhkUJJmP1NxErg/twJERl512
e5M+ga01aqJ3oJhsxuiH9wbpby6r/23cBN9iTnvFCGOnCzYYKEXzJcefD6PQ2Qpx
uLsD6+c1abkTuErzgt0c9UPbVFda261mv0FrA5Q28MyF/dnl3lbNZ60KJDvVRORY
N9u/ZLclSRnXEned4ecVwrztEilSJH7zbUzsaHYYRc4YHwYA2uHmKSX0pYEjBAzm
m/70YIwI6lhW6o2Pn2tjgLxl7j4QjvGqHyrYJ0MQivcgEmsqbZ/tyijctNOf0OSr
odQvPXLI0cYWUsOnQfoC3cmYILQ/Jr9dvmmhSHqdxSEziipgOB/wlHChg6M11b4S
9K/dKPgX846KZiB5+leyzSBGbG9yaWFuIFNtZWV0cyA8ZmxvQEZyZWVCU0Qub3Jn
PsLBlAQTAQoAPgIbAwULCQgHAwUVCgkICwUWAwIBAAIeAQIXgBYhBOyzaLh5CL+2
kU1yae9bpNzVqfPABQJlmq1gBQkO64zlAAoJEO9bpNzVqfPAU3YQALit2AZO3MDH
jKG7qT/43hSOnN3BoxRgRFz63N+bFR+tJlTE7k0SA8iephy97UKbf55wfQB4v07q
7kp1VckuJvorsU0ygCA2AnjNPRnGG3VyRfaJKBp22sGICDiMVe/c/SvCy/877A/t
FVZjZ2rxTWNlT6i3In3YFae48OxCL8FfUFF+37tGmwj5PWi3lIpOKeuZLW0KHebX
KCqpzIRcnjHOE7moQILrFsXvmay9JVYclNrDNIaePWuVlFNgFYMsF9+ixn3f7lTg
prIyljS2F1fxpcBIR/KjJFsjXl73IyZr3PxCBq8mpCi6ukD/58UFCvB9VRXUkAqm
8k0eoBe61RlRoXrZlSmIq8qT0K97tqFLpFVRylHnZEsjhxI6Drox+910LyF9rAZD
S1GgDpyAd2qE7AgijcpFjpeYB480ZGgnRtEp3v8MbGNhne7Og07hT1yB9DUoiM9g
LxapLSujp2X6QWRONaLvv0Kz7BuCOHbMaol4YpjABd/43i5jnAsTBkBm6jsmEPhK
69Vxsrkqs7E7OZOBnVdCR5HGZNq6Nss+dRXFHxGTyk+98ADLWl6MtQxZE8jYyxPz
ow5wNgkOoGrpTgQp0lDefI9pQhZFW77HZaBbbaffBAfISXWONmut7GVjb0oNxhW/
OA/oQSiWYIP7c4JOWZ+apAZQtqNxYCWbwsGUBBMBCgA+FiEE7LNouHkIv7aRTXJp
71uk3NWp88AFAlpyB1cCGwMFCQeGH4AFCwkIBwMFFQoJCAsFFgMCAQACHgECF4AA
CgkQ71uk3NWp88C7Yw/+Pcy8F0jqu1+tpLOlQd88nscPL9g3UcP6iqor1VM/TQmB
ESgxCk+YLdjWa2CBSE4N215dLaEuqrSluyvZXzWnlHJuPPohwDO2+08YW1I2KWGM
/mMO5iVrEvnYlgRh2SODjfOrMZC0m1K43G9lYJy4l09serNA5+UwLsoa4AX5pwEM
kip3nFX6dFC06AdpFQz2ExFL//rfBdlXCAwzB3FNbuse5NYih/Bktg1ZCk6Gr1HH
vrzK0jVB8Ml2ZvU2x8cxOqYJMdGP5z7AQwuny6+hzMFAV4kziIeIdLL2pqrNka81
hYx+T4Sx5ZzDbfQByfYtX2jjV4XBCIyvWH+zGIjfBaIJpmZY3EK25uDnLvmlYl5/
kNoVgQCDLDOk0B0RcdM26pJ8G2fNBDlkJ8daXTR8wooVDCNWC20S3rf8Gp6LaFUm
iqUvO4pnMwg6D6wLpa/hlxgGEO4NEKyo6/1+vr1z8S/hrqrnlOVQCCGNydwBycIQ
6/oFVo8Oo7arIMqhHLLHfHsN/UcA5fJzuv+ooI9O7nIZ4D1FWEc6zndDJaTeuoN3
Q+iId6Q/GdKnxFnb1RRoyrijHO2mkeUQNdEt6PqfW6YVuFS7RulG6u5uJouzNetq
tyQJ1C7RH3t3mPBm++MrHhOJYvugeISzdNg1kDHzGYxZmIE5ms7rPm+rWagJ/77C
wZQEEwEKAD4CGwMFCwkIBwMFFQoJCAsFFgMCAQACHgECF4AWIQTss2i4eQi/tpFN
cmnvW6Tc1anzwAUCYfBT1QUJC0iW3wAKCRDvW6Tc1anzwE+0EACIw1ITj7Nd1Wvi
gN6eJJzumzGuUJuNVC9foilOJQHQ7ukdyGbnHDIaXaECdg2VkUoqn5ouv8TOqsFd
FdcMe07CBAqEN2McJ3D5b6IGSzoAO5ZrfDleE8n2UrRHas9ZiOJqmeeo5WGep5Iz
lOJegs9R39/ZVFx2Z0qhKvclvs5MsskIGE3dC8MK9qw5SxRhdQ0Ew7SHwOWyzszU
hcNO/cIs1G0mSKgzMhnBYGqdqLbwjNO0AkrASw7Vr69UMYp5ffeaFpH7SjMMm/Ts
5MLPWihy+WpJ3clEoc/T+duLLMlGKTkEMXgwIHSNUs+PIn21hb7yc59DB5JH2Xhq
jmCdLr5fkifKHxAuMPrp02KI1nyqeHT42dlUBvpMxDdD/xpCF7LueakO61NnnfMk
jlzVhDuFyPMAPNO4yQegxkz2gdHUdqjBmUytapVA6/9nnn0Ux5Oixpy8Fq8/Ojtb
0D3yyYKG6NsnDla6sK2QzpGjt+K3WNw8KjgZRc19PXnYoYd4OSFW8dqwFsCQtsEl
nDH6Xsc71Oq8Te25gmnOugr8q8z7kAM+WImGcd5ro3mWTVOtaYsZSHIzxqfYQlZN
1FeH126pnZrzOuHvCRTYefQek2ojB1L7KYeB9xeWurRTKvTTp/LZ/kCmaQ1hq6V9
4ON2chMseQeJe6yT0z0zCv5r/Hnfus7BTQRacgcLARAA0es6bm/J0r+KPXOQPItn
NuiCTnOMyHqgCvdwfigZskc8uXIVlMJUFhTAPiSHo1XWwq5k55f9rKDJWDVHIu6W
fOxzpiNc4jGWqGpDAYjyTyywAikxJ/Tb3vzUI0XYcLjYKsl4e1c040M06Owy6jHO
Br3MtAKHiMtOUT9NQmjopUAFYFVG1NWHZnvukq03uPY08UEe+nsrRYd9X5NieWyC
OFQDQAJmdR0dLZhHMGELPNB6W53EHPnhL3FtSrWZ9l9XHwBsAZcXbPGjrye+8AAm
fjweIFLd0yEIZgkN1l2NrpB1QU+J6aKc7HCRTMKqYrGb4CPtRK57VJtlmonGYwjV
4Xg6uT8Ekkjvhn8WcmBhHhSQSIPcn8pShxAIgfd1oHX78JeWH30hvsA/5Aa4qTe+
c0eHtUGrcT5UCIzktTQGaBb5x1E8eSLAzuwNrZWdXdWq9XtCagwqccXNQHo2fy4T
6JqSnknzU+vryQM6ruQtbdScaaDU9SpuycJpOKYlvckBhbM5b/0Jhw+VsB0iqL7A
fsw6h4v48D30DeRb/zzWsaZ45gXPOuw1Uu15r4Al9e2ngs3mA5Ug8imi8I1JVdcQ
qCXtri+NQbNUHOsfs/NP6ThdQRDA0IAJ8ZnEQTG2fLX1uO+6ZnSu/4AQAe+xZIpc
dRUnMg2Op31SKhoRsoYA+U8AEQEAAcLBfAQYAQoAJgIbDBYhBOyzaLh5CL+2kU1y
ae9bpNzVqfPABQJlmq1gBQkO64zlAAoJEO9bpNzVqfPAIGwQALR5i/pg0kcx2AYB
vbYSPXA6+zPOrr7awM9cYxPIJQxM6rvv1xzXINysqCIw87oqaD66be95S7/pOu7H
y2PGHGgqtFnz+QXyVzmXHaSs8UMmiiOYeUQ0LIxM6UhEnQztmAkMqQPSkTCbSP1S
CasWYJTqf1YeGmhdbeQYtjQzcgDB7PJE6DUZ+elude9i6fbCYfc66QOg4SS4Ulgn
PbZc1FkFCHb9GO2eVOXqX0blk42BkknOJJr3tnlQSyDfkTK0R5MlVyKI/QFcFaBj
AT7RxGHowSJjnVf6Gp1tRDdFTW0AwLkcYYK1H2UeCkGPRlO0HFec59c1YcNCSzCB
KsRQfUNE5zHsE0l2+PNgzO3C+iN4mA6BIz5EDqGD97fWOm3xfYdNi41SucTWdqid
qyjcRo1dgTZNDS30QZ3FZF+gSVnkNSgUxMpnf/Kw9L0KaxvVM6s7Ye+7GaFuv/fN
8tcjJbLnq2uqqnR9+5t9dPxq900EwnBmNw/E9uzFHC2V7cPjK23LSoPMXuAox3jz
g60Ea1bgLhCGx5TnLIkFcPVK4mNkqh2LCoG1ZSA3UmR96m0a6S6UH43CZUL1iuG9
iNcEOvQQzo63jeSDmMYV0c4CF/Op62dwoqIlRVQcOD6CjF6NqY2w2rzzF2fHVAOw
Oq5kDxR0N0uB3yIMbIdNOWCiQ9mXwsF8BBgBCgAmFiEE7LNouHkIv7aRTXJp71uk
3NWp88AFAlpyBwsCGwwFCQeGH4AACgkQ71uk3NWp88DP/A//SGw8zL7M+DvhnM9a
FMeCDMW0A8PfaoCXsUeXI1ttOxpEZylSdM6se13PlNwMrZ4rsKhxF3leKiKj+ode
KRLgqnUSfn0puuawePmXXjNmOWGL1AQcjjO/DG7OkmctpOV9BC+RV4zVSDDr9iJm
5cnkVoViuoAn3P5e5FdRGFcfS1d7prHOyvnHmZXxNVPIVm4nvK+7Zd1fYIBdoNXM
nPa7tKlt7IPA+LzU0tbsHannHCkXN6LK1cOFq1tZxsU5k0wqlWBh4xdrADRfaNSQ
fd4aF8/JcnZg3YSf+tv1x2qXk9RQfJu4LpYpzN91XjggozfnVIC0JObQBoPoh0Fo
QuEP6OJtDqn3XEmHYQie4diOBsDqBmsc6F6hC+Oxrsc/sxOKLABT+SS8Qk24tseb
Hbgr8cd1mzveZGSSqew9ASCqWynH5MlrHud2ASPcEq5CIpfiJ56r0g81PZzLyMik
o7+LosL2YtR2O7T4oq/z9p2mWokNUgDNCiz94Ndt1nJ4USqPvmUR4Wsuf+9Eihnc
RJin955XfMTQrPRCFjk6UWqnPfsznA9c1U2cJ8IAa5z6s3z1vfnexcAD9THSW60T
rgtm38zWcqEeLhwJwzsjVsBkpkob+4YXXrbTvHSW5Z3k2PL4c8aN+qVpqIxHYIIV
zcPSYu5MiJwJlqvZMFeVaLt2TRfCwXwEGAEKACYCGwwWIQTss2i4eQi/tpFNcmnv
W6Tc1anzwAUCYfBT/gUJC0iW4AAKCRDvW6Tc1anzwHKpD/9znRaNN0u5+TwJxSD3
baeA2OqeebO6gjpscfoT1z1LOTJiG/pPMz7TB5K2bo+0JwzRV29nfiSeNGQqBx1T
HZ3Y0ph5tFB8rfF4aEddjhtwxP80Q4SzxToSZAGMBkndNXlEpMeyHoVpcGoR7qkK
Atrr7M9g9ocf8kTO3hzvDzASVIwiASVwl4QBGAv4slShbxJ86DbhtUgvv+6kSe1q
m62hMTri8cD/0mVBAEwmAf6k4l9pwYW2oAdl0vjS5sz00uqB8nuT22NuiB3XBjSB
5CFbeKhy3EZkcpG1taMmuXtwhAgQTmmknruMv9OvP8joSK1nrSyRBwzcMbYW4PS5
px4c/RSsdVIcyhQLQ084c1ak9cDImiyU9pZhHnvNIdp84qfEWXOrXtWSUfUyEj0n
pK9vAjKH4Vrfakw+WtRrleFC/muTSu1FfskeBphts9gk0fox1VZ+pWMLsxwsKlpg
CqhCFzpN5ey+hsawjbOA8X2KJjl2Lr7fYuvmxu/FOgRxPhiO08UMkFAIlHWn+sXi
vGTbxZxagGoszOr6MZmKT31IcU1WqY3EIjA/ZodDkBz/cT8se4hvh5whroRuGUGf
cp5KmVUJhkCvSxnVwMYz4uDpr8I+TYWU+LnJbIBZcHs8wvNuaSMLd9CLS/4Mi2bJ
DRvAdmReOwiIxzzxdirXq7KkaA==
=HqC9
-----END PGP PUBLIC KEY BLOCK-----
OpenPGP_signature.asc (application/pgp-signature, 840 B)
-----BEGIN PGP SIGNATURE-----

wsF5BAABCAAjFiEE7LNouHkIv7aRTXJp71uk3NWp88AFAmYJGNUFAwAAAAAACgkQ71uk3NWp88CX
Tw//aImAl6xJ4UD0f6h8fSVCcBBhJC8c/JGKUiJo6qTvUCxYOz3oG+A1UGK5u1hRICnFlSIeK/wT
r9yigZ3X1yYCmAq5pZ9UD+pHqNXkr833VWlxfJWT7vIfO9p4vDXvB4kscKnpGCPqR+45HYpdfSCC
8y0cJyDMRv7r2lT7SLO+bRwf2ZtihDUU2lkxwxMfeFPJoGXVKHwVctI1QWQ1Y8qMNcMnXf8qd8Fj
e1M9pYgCSLyqDgSYWyR9Wn8Xt9DB6bsJb5W09elF1hm82x7txOdtWFwru7TpLjjTHASbpUcIwN8H
mDKN2unXiwxNJZQsd5YjEFBJKoswlv5JerEk+LYvzse8p3KyudB7ajK0BA0A7/nXAM0gqooSYdWu
S8bjVf94I1CTdulugYlaCtngHOnbfh3rGRBnY783yr4xKnFTEUeJREdzRsbZ9DR849MIrkpLAibb
bSIm5F13DFytRt/HMSmqRvk2MrwXe2R23bOZy01evcnAdiHVMixJUDh3X75ANbSXAUTkl/3vldUC
T03NBYM1u+Bv20JIraUshV/T4lnQboGzqGBSm42IP9RA5mWmsEPBFhwB9yszp0MLVdzpsrDCGvs/
2a5wdthS0F3brEpdxWVs5rdEaqkpMJal4C7fWXMHB1vLD7Qss9rbOkwVo5gp6KBkeQHjLtW8aRif
mQg=
=2ivB
-----END PGP SIGNATURE-----