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=<[email protected]> temporarily rejected RCPT <[email protected]>: 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=<[email protected]> temporarily rejected RCPT <[email protected]>: 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=<[email protected]> rejected RCPT <[email protected]>: 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 -- ## List details at http://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
