Hello!
I've found in reject log messages with reject error "PGSQL: no data
found". For example:
2011-04-09 07:12:06 H=(180.245.254.157) [180.245.254.157]
I=[193.238.12.139]:25 F=<ECdK@???> temporarily rejected RCPT
<olga@???>: PGSQL: no data found
domain "vipmaster.ru" isn't local domain, bot tried to relay via my mx.
I've made little investigation. Please look at those two lines:
2011-04-15 12:44:47 H=(localhost) [x.x.x.x] I=[193.238.12.139]:25
F=<aa@???> temporarily rejected RCPT <spam@???>:
PGSQL: no data found
2011-04-15 12:44:57 H=correct.revdns.of.ip (localhost) [x.x.x.x]
I=[193.238.12.139]:25 F=<aa@???> rejected RCPT
<spam@???>: relay not permitted (brak autoryzacji)
In booth cases, domain "XXXkolekcja.mejor.pl" isn't in local domain.
First line was created while named was down, exim couldn't verify
reverse_host_lookup (exim reponsed "451 Temporary local problem - please
try later" to client ). The second one was logged while named was up,
exim could verify reverse ip (exim responsed "550 relay not permitted"
to client).
I'm wondering why exim throws "PGSQL: no data found" to reject log,
shouldn't log somthing like "host lookup failed"?
In exim.conf there are a couple places when i'm making psql lookup. All
sql queries has domena='${quote_pgsql:$domain}' in WHERE clausule so all
of them return zero records.
Example query:
domainlist local_domains = localhost : @ : \
${lookup pgsql {SELECT domena FROM exim_users where \
domena='${quote_pgsql:$domain}' limit 1 }}: \
${lookup pgsql {select regexp_replace(alias, '.*@','') \
from exim_aliasy where alias like '%@${quote_pgsql:$domain}' }}
# exim -bV
Exim version 4.75 #1 built 15-Apr-2011 11:52:38
Copyright (c) University of Cambridge, 1995 - 2007
Berkeley DB: Berkeley DB 4.8.30: (2010-08-28)
Support for: crypteq iconv() IPv6 OpenSSL Content_Scanning DKIM
Old_Demime Experimental_SRS
Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch cdb dbm
dbmnz dnsdb dsearch passwd pgsql
Authenticators: cram_md5 plaintext spa
Routers: accept dnslookup ipliteral manualroute queryprogram redirect
Transports: appendfile/maildir/mailstore autoreply pipe smtp C&W_DSN_1.3
Fixed never_users: 0
Size of off_t: 4
OpenSSL compile-time version: OpenSSL 1.0.0d 8 Feb 2011
OpenSSL runtime version: OpenSSL 1.0.0d 8 Feb 2011
Configuration file is /etc/exim/exim.conf
Postgresql-9.0
If more information, content of acl_check_rcpt will be needed, please
let me know.
Thanks for suggestions.
Marcin
