Re: [exim] Exim can't resolve hostname of database when seco…

Etusivu
Poista viesti
Vastaa
Lähettäjä: Marcin Mirosław
Päiväys:  
Vastaanottaja: exim users
Aihe: Re: [exim] Exim can't resolve hostname of database when second email is sended in one TCP connection
W dniu 08.10.2013 11:58, Marcin Mirosław pisze:
> Hello!
> I'm testing new configuration using "exim -bh x.y.z -d". I've noticed
> strange behavior when I send HELO/EHLO after first mail was received.
>
> I'm sending:
>>>>>>>>>>>>>>>>>>>>>
> ehlo toja
> mail from: a@???
> rcpt to: uzytkownik@???
> data
>
>
> asdadasd
>
> .
>
> helo test
> quit
> <<<<<<<<<<<<<<<<<<<
>
> When second HELO appears I'm getting in debug session:
> SMTP<< ehlo test
> sender_fullhost = google-public-dns-a.google.com (test) [8.8.8.8]
> sender_rcvhost = google-public-dns-a.google.com ([8.8.8.8] helo=test)
> set_process_info: 8450 handling incoming connection from
> google-public-dns-a.google.com (test) [8.8.8.8]
> using ACL "acl_check_helo"
> processing "drop"
> search_open: pgsql "NULL"
> search_find: file="NULL"
> key="SELECT domain FROM postfixadmin_domain WHERE domain = 'test' AND
> active = '1' AND backupmx = '0' UNION select '@'" partial=-1 affix=NULL
> starflags=0
> LRU list:
> internal_search_find: file="NULL"
> type=pgsql key="SELECT domain FROM postfixadmin_domain WHERE domain =
> 'test' AND active = '1' AND backupmx = '0' UNION select '@'"
> database lookup required for SELECT domain FROM postfixadmin_domain
> WHERE domain = 'test' AND active = '1' AND backupmx = '0' UNION select '@'
> PostgreSQL query: SELECT domain FROM postfixadmin_domain WHERE domain =
> 'test' AND active = '1' AND backupmx = '0' UNION select '@'
> PGSQL new connection: host=pgsql port=5432 database=xx_poczta_test_db
> user=xx_poczta_test
> PGSQL connection failed: could not translate host name "pgsql" to
> address: Name or service not known
>
> lookup deferred: PGSQL connection failed: could not translate host name
> "pgsql" to address: Name or service not known
>
> LOG: MAIN PANIC
> failed to expand "<\n ${lookup pgsql{
>
>
> Definition of pgsql_servers is:
> hide pgsql_servers = "pgsql::5432/xx_poczta_test_db/xx_poczta_test/yy"
>
> Full hostname of database server is: pgsql.in.xx.com.pl
> $ cat /etc/resolv.conf
> search in.xx.com.pl
> nameserver 192.168.1.35
>
>
> $ host pgsql
> pgsql.in.cadera.com.pl has address 192.168.1.220
>
> When Iconfigure connection as:
> hide pgsql_servers =
> "pgsql.in.cadera.com.pl::5432/xx_poczta_test_db/xx_poczta_test/yy"
>
> or I add "pgsql" to /etc/hosts then problem disappears.
> It looks like "search" option isn't applied when exim tries translate
> hostname to address.
>
> Ok, I run exim under strace, here is relevant part
> when first time exim tries to resolve "pgsql":
> connect(3, {sa_family=AF_INET, sin_port=htons(53),
> sin_addr=inet_addr("192.168.1.35")}, 16) = 0
> gettimeofday({1381226200, 288600}, NULL) = 0
> poll([{fd=3, events=POLLOUT}], 1, 0)    = 1 ([{fd=3, revents=POLLOUT}])
> sendto(3,
> "\224\242\1\0\0\1\0\0\0\0\0\0\5pgsql\2in\6cadera\3com\2pl\0\0\1\0\1",
> 40, MSG_NOSIGNAL, NULL, 0) = 40
> poll([{fd=3, events=POLLIN|POLLOUT}], 1, 5000) = 1 ([{fd=3,
> revents=POLLOUT}])
> sendto(3,
> "\214o\1\0\0\1\0\0\0\0\0\0\5pgsql\2in\6cadera\3com\2pl\0\0\34\0\1", 40,
> MSG_NOSIGNAL, NULL, 0) = 40
> gettimeofday({1381226200, 289009}, NULL) = 0
> poll([{fd=3, events=POLLIN}], 1, 4999)  = 1 ([{fd=3, revents=POLLIN}])
> ioctl(3, FIONREAD, [94])                = 0
> recvfrom(3,
> "\224\242\205\200\0\1\0\1\0\2\0\0\5pgsql\2in\6cadera\3com\2pl\0\0\1\0\1\300\f\0\1\0\1\0\0*0\0\4\300\250\1\334\300\22\0\2\0\1\0\0*0\0\7\4dns1\300\22\300\22\0\2\0\1\0\0*0\0\7\4dns2\300\22",
> 2048, 0, {sa_family=AF_INET, sin_port=htons(53),
> sin_addr=inet_addr("192.168.1.35")}, [16]) = 94
> gettimeofday({1381226200, 293071}, NULL) = 0
> poll([{fd=3, events=POLLIN}], 1, 4995)  = 1 ([{fd=3, revents=POLLIN}])
> ioctl(3, FIONREAD, [87])                = 0
> recvfrom(3,
> "\214o\205\200\0\1\0\0\0\1\0\0\5pgsql\2in\6cadera\3com\2pl\0\0\34\0\1\300\22\0\6\0\1\0\0*0\0#\4dns1\300\22\5admin\300\25w\3752`\0\0*0\0\0\34
> \0\t:\200\0\0*0", 1954, 0, {sa_family=AF_INET, sin_port=htons(53),
> sin_addr=inet_addr("192.168.1.35")}, [16]) = 87
> close(3)

>
> When second HELO is sended:
> connect(3, {sa_family=AF_INET, sin_port=htons(53),
> sin_addr=inet_addr("192.168.1.35")}, 16) = 0
> gettimeofday({1381226202, 831438}, NULL) = 0
> poll([{fd=3, events=POLLOUT}], 1, 0)    = 1 ([{fd=3, revents=POLLOUT}])
> sendto(3, "\36V\1\0\0\1\0\0\0\0\0\0\5pgsql\0\0\1\0\1", 23, MSG_NOSIGNAL,
> NULL, 0) = 23
> poll([{fd=3, events=POLLIN|POLLOUT}], 1, 5000) = 1 ([{fd=3,
> revents=POLLOUT}])
> sendto(3, "\256J\1\0\0\1\0\0\0\0\0\0\5pgsql\0\0\34\0\1", 23,
> MSG_NOSIGNAL, NULL, 0) = 23
> gettimeofday({1381226202, 831628}, NULL) = 0
> poll([{fd=3, events=POLLIN}], 1, 4999)  = 1 ([{fd=3, revents=POLLIN}])
> ioctl(3, FIONREAD, [98])                = 0
> recvfrom(3,
> "\36V\201\203\0\1\0\0\0\1\0\0\5pgsql\0\0\1\0\1\0\0\6\0\1\0\0#\360\0@\1a\froot-servers\3net\0\5nstld\fverisign-grs\3com\0w\375{\0\0\0\7\10\0\0\3\204\0\t:\2
> 00\0\1Q\200", 2048, 0, {sa_family=AF_INET, sin_port=htons(53),
> sin_addr=inet_addr("192.168.1.35")}, [16]) = 98
> gettimeofday({1381226202, 834145}, NULL) = 0
> poll([{fd=3, events=POLLIN}], 1, 4997)  = 1 ([{fd=3, revents=POLLIN}])
> ioctl(3, FIONREAD, [98])                = 0
> recvfrom(3,
> "\256J\201\203\0\1\0\0\0\1\0\0\5pgsql\0\0\34\0\1\0\0\6\0\1\0\0#\360\0@\1a\froot-servers\3net\0\5nstld\fverisign-grs\3com\0w\375{\0\0\0\7\10\0\0\3\204\0\t:
> \200\0\1Q\200", 1950, 0, {sa_family=AF_INET, sin_port=htons(53),
> sin_addr=inet_addr("192.168.1.35")}, [16]) = 98
> close(3)                                = 0
> write(2, "PGSQL connection failed:
> [...]

>
> So in second case Exim doesn't send correct search option.
>
> exim -bV
> Exim version 4.82_RC2 #2 built 08-Oct-2013 11:56:12
> Copyright (c) University of Cambridge, 1995 - 2012
> (c) The Exim Maintainers and contributors in ACKNOWLEDGMENTS file, 2007
> - 2012
> Berkeley DB: Berkeley DB 4.8.30: (2013-09-25)
> Support for: crypteq iconv() OpenSSL Content_Scanning DKIM Old_Demime
> Experimental_SRS
> Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch cdb dbm
> dbmjz dbmnz dnsdb dsearch passwd pgsql
> Authenticators: cram_md5 dovecot plaintext spa
> Routers: accept dnslookup ipliteral manualroute queryprogram redirect
> Transports: appendfile/maildir/mailstore autoreply lmtp pipe smtp
> Fixed never_users: 0
> Size of off_t: 8
> Configuration file is /etc/exim/exim.conf


Hi!
I just noticed that similar problem appears if I use ${lookup pgsql{}}
in transport. In such situation I have problem with resolving hostname
of database if I don't use FQDN in definition of pgsql server. Again,
"search" option from resolv.conf seems to be ignored.
Marcin