Ed K. wrote
Ok, I was using a cvs checkout of dbmail (v2pre i guess) that was checked out
on april 16th.
I am using the lmtp transport from postfix 2.0.18
I have the trace levels set to 5.
When I issued a posfix flush command, this is the output sent to
/var/log/maillog:
http://www.hp.uab.edu/~ed/dbmail.log
After I had this problem, I downloaded a new copy from cvs and ran the new
version.
Soon after the update, all the email bounced back to the originator.
fyi: all accounts do exist
I read this in your logs:
========
query [SELECT deliver_to FROM aliases WHERE lower(alias) =
lower('[EMAIL PROTECTED]')]
May 18 16:52:16 proxy dbmail/smtp[26204]: authsql.c,auth_check_user_ext:
user [EMAIL PROTECTED] not in aliases table
May 18 16:52:16 proxy dbmail/smtp[26204]: dsn.c, dsnuser_resolve_list:
user [EMAIL PROTECTED] found total of [0] aliases
May 18 16:52:16 proxy dbmail/smtp[26204]: dsn.c, dsnuser_resolve_list:
user [EMAIL PROTECTED] checking for domain forwards.
May 18 16:52:16 proxy dbmail/smtp[26204]: dsn.c, dsnuser_resolve_list:
domain [EMAIL PROTECTED] checking for domain forwards
May 18 16:52:16 proxy dbmail/smtp[26204]: authsql.c,auth_check_user_ext:
checking user [EMAIL PROTECTED] in alias table
May 18 16:52:16 proxy dbmail/smtp[26204]: authsql.c,auth_check_user_ext:
checks [-1]
May 18 16:52:16 proxy dbmail/smtp[26204]: dbmysql.c,db_query: executing
query [SELECT deliver_to FROM aliases WHERE lower(alias) =
lower('@motherteresahospice.com')]
May 18 16:52:16 proxy dbmail/smtp[26204]: authsql.c,auth_check_user_ext:
user @motherteresahospice.com not in aliases table
May 18 16:52:16 proxy dbmail/smtp[26204]: dsn.c, dsnuser_resolve_list:
domain [EMAIL PROTECTED] found total of [0] aliases
======
This would suggest that the users the emails are aimed at do not have
aliases in the 'aliases'-table.
Can you run the queries in the above log (SELECT deliver_to FROM aliases
WHERE lower(alias) = lower('[EMAIL PROTECTED]')) and (SELECT
deliver_to FROM aliases WHERE lower(alias) =
lower('@motherteresahospice.com')) directly in your SQL client and show
the results.
Ilja
