Hi again,
* Alexander Neumann <alexander@???> wrote:
> [...]
> Exim is version 4.50, postgresql version 7.4.7.
> =================<snip>========================
> 2005-09-01 18:19:01 H=www.xxxxxxxxx.de [XXX.XXX.XXX.XXX]:40692 I=[XX.XX.XXX.XX]:25 Warning: tempreject_score for xxxxxxxxx@??? is 2
> 2005-09-01 18:19:01 failed to expand ACL message "X-SA-Reject-Score: ${lookup pgsql{SELECT sa_reject_score FROM exim_virtual_addresses WHERE domain = '${quote_pgsql:$domain}' AND (mailbox = '${quote_pgsql:$local_part}' OR mailbox = '*') ORDER BY mailbox DESC LIMIT 1}}": lookup of "SELECT sa_reject_score FROM exim_virtual_addresses WHERE domain = 'xxxx.org' AND (mailbox = 'xxxxxxxxx' OR mailbox = '*') ORDER BY mailbox DESC LIMIT 1" gave DEFER: PGSQL: query failed:
>
> 2005-09-01 18:19:01 failed to expand ACL message "reject_score for $local_part@$domain is ${lookup pgsql{SELECT sa_reject_score FROM exim_virtual_addresses WHERE domain = '${quote_pgsql:$domain}' AND (mailbox = '${quote_pgsql:$local_part}' OR mailbox = '*') ORDER BY mailbox DESC LIMIT 1}}": lookup of "SELECT sa_reject_score FROM exim_virtual_addresses WHERE domain = 'xxxx.org' AND (mailbox = 'xxxxxxxxt' OR mailbox = '*') ORDER BY mailbox DESC LIMIT 1" gave DEFER: PGSQL: query failed:
>
> 2005-09-01 18:19:01 H=www.xxxxxxxxx.de [XXX.XXX.XXX.XXX]:40692 I=[XX.XX.XXX.XX]:25 F=<xxxxxxx@www.xxxxxxxxx.de> temporarily rejected RCPT <xxxxxxxxx@???>: PGSQL: query failed:
> =================<snip>========================
I just discovered that after the query for the tempreject score, exim closes
the database connection.
Any idea how to debug that?
Thanks for reading!
- Alexander
