Hello Viktor,
Indeed, your are right again. I had '%d' in a complex query, changed it
to '%s' and extracted the substring for the domain. That did it! There
are three select statements in a UNION with the others referencing '%s'
already. Too bad there wasn't a switch to make it so '%d' does not
ignore the whole query on keys like jo...@example.com.
Regards,
David Koski
dko...@sutinen.com
On 3/18/21 5:44 PM, Viktor Dukhovni wrote:
On Thu, Mar 18, 2021 at 05:17:58PM -0700, David Koski wrote:
Postfix is only mapping email addresses and not FQDNs. Mapping works
for u...@mydomain.com but not
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmydomain.com&c=E,1,1ufclNlqUwmXD2VK-YrvNGm5q9-QZfGaDfYeiXewkcnlYLErUpSVnoD1mlQN9g_-f3MNe9oMTTYPvxgjvkpOoUHWsL5OtRxhOWh0FgOU1wA,&typo=1,
.https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmydomain.com&c=E,1,eCFYsEaku7fqVeX1R6e9MnlMMC9eHyvOeK3CWcrqTZxNRzEeb4vu6Hpkcoh_NYq4pFSoSZizgoThehS24tqBQQ6pQrTPGeVBCAI8YB6vWPEn1w,,&typo=1
or @mydomain.com.
# postmap -q localhost
mysql:/etc/postfix/https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmysql_transport_maps.cf&c=E,1,qvgEVzjJgncA7i6QmGsTvdQVZ4CnpydYP4R4YizA1FTBDJgQNdvd5cfWxvYzsG_bAYJqyNywwRmVi8tIeIJ-Ves1-YLNATWgy-fcYFwcoPZVDaY,&typo=1
# postmap -q list2@localhost
mysql:/etc/postfix/https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmysql_transport_maps.cf&c=E,1,hC7iKQadbai4p80je8keLWfcmjyGR1yZ9NMG_C7vbRYHyLhq3gpa0q8IycNvJMPCKyzcHdv27eEQ3tNdXkLRPYtnT6uMhxl9SZ_E_dEVTMYpnvKz&typo=1
mailman:
Your definition of the MySQL table in
"/etc/postfix/https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmysql_transport_maps.cf&c=E,1,tk4mCXXxVaoFdFzBBz-FPo6vlUpgW_OUENX4vC6CeH2U6aUov5sJaG0mFRuliQkYNcA51GVqfirrbedg12b55MinLgrKqz1REXGMjqqXaT3G8w,,&typo=1";
is such that only user@domain keys are matched.
