Thanks for your remark. I gave it a try on postgresql 11.5. Running different
versions of my query against it gives the same result for my case:
SELECT CONCAT(username, '@', domain) FROM users WHERE ?1 LIKE mailbox;
SELECT CONCAT(username, '@', domain) FROM users WHERE mailbox LIKE ?1;
I'm still
I just tested with MySQL and the result is the same.
smtpd -dv -T lookup yielded:
de334c3363d95880 smtp authentication user=u...@host.com result=ok
debug: smtp: SIZE in MAIL FROM command
debug: lka: mailaddrmap senderalias:u...@host.com
lookup: lookup "u...@host.com" as MAILADDRMAP in table proc
Hello Giovanni,
I just gave it a try. The order of the operands of the LIKE operator doesn't
make any difference. I just tested it manually against my sqlite database. The
returned results are identical.
Greetings,
Michael
‐‐‐ Original Message ‐‐‐
Am Montag, Oktober 14, 2019 9:15 AM
On 10/12/19 4:46 PM, y38...@protonmail.com wrote:
> SELECT (username||'@'||domain) FROM users WHERE ? LIKE mailbox
I think it should read
SELECT (username||'@'||domain) FROM users WHERE mailbox LIKE ?
typo or error ?
Giovanni
Because I could not get get my setup working using sqlite I switched over to
postgresql. I ended up with the same error as before.
Can anyone point me to an example config using senders directive with a table
from a database?
Greetings,
Michael
‐‐‐ Original Message ‐‐‐
Am Dienstag, O