I just tested with MySQL and the result is the same.
smtpd -dv -T lookup yielded:
de334c3363d95880 smtp authentication [email protected] result=ok
debug: smtp: SIZE in MAIL FROM command
debug: lka: mailaddrmap senderalias:[email protected]
lookup: lookup "[email protected]" as MAILADDRMAP in table proc:senderalias
-> error: No such file or directory
warn: failure during mailaddrmap lookup senderalias:[email protected]
Preceeded by:
senderalias[36753]: debug: (re)connecting
senderalias[36753]: debug: connected
So the table is loaded but it tries to look up from a file maybe?
Good luck,
Reio
On 14/10/2019 13:32, [email protected] wrote:
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 schrieb Giovanni Bechis
<[email protected]>:
On 10/12/19 4:46 PM, [email protected] 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
