On Wed, 19 May 2004, Ilja Booij wrote:
> 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
the [EMAIL PROTECTED] does not exist - so the email must be spam:
mysql> SELECT deliver_to FROM aliases WHERE lower(alias) = lower('[EMAIL
PROTECTED]');
Empty set (0.00 sec)
mysql> SELECT deliver_to FROM aliases WHERE lower(alias) =
lower('@motherteresahospice.com');
Empty set (0.00 sec)
I'm more interested in why this email is failing:
May 18 16:52:16 proxy postfix/pipe[26199]: 58A431D4A7: to=<[EMAIL PROTECTED]>,
relay=dbmail-smtp, delay=434188, status=deferred (temporary failure)
(search for the begining of that line in the log file.)
ed
Security on the internet is impossible without strong, open,
and unhindered encryption.
