X-Git-Url: https://git.exim.org/exim.git/blobdiff_plain/8f2cf8f5adaa08ef84b47bf9bc2f71e39236c22d..aae673d7db4b26e8c4a8cc3d59fe94de4c47ba16:/test/stderr/2620 diff --git a/test/stderr/2620 b/test/stderr/2620 index ab3ca9228..2e0e38247 100644 --- a/test/stderr/2620 +++ b/test/stderr/2620 @@ -14,7 +14,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="select name from them where id='ph10';" opts=NULL database lookup required for select name from them where id='ph10'; PostgreSQL query: "select name from them where id='ph10';" opts 'NULL' - PGSQL new connection: host=localhost port=1223 database=test user=CALLER + PGSQL new connection: host=localhost port=PORT_N database=test user=CALLER creating new cache entry lookup yielded: Philip Hazel search_open: pgsql "NULL" @@ -35,7 +35,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="select name from them where id='xxxx';" opts=NULL database lookup required for select name from them where id='xxxx'; PostgreSQL query: "select name from them where id='xxxx';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER PGSQL: no data found creating new cache entry lookup failed @@ -48,7 +48,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="select name from them where id='nothing';" opts=NULL database lookup required for select name from them where id='nothing'; PostgreSQL query: "select name from them where id='nothing';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: search_open: pgsql "NULL" @@ -60,7 +60,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="select id,name from them where id='nothing';" opts=NULL database lookup required for select id,name from them where id='nothing'; PostgreSQL query: "select id,name from them where id='nothing';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: id=nothing name="" search_open: pgsql "NULL" @@ -72,7 +72,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="delete from them where id='nonexist';" opts=NULL database lookup required for delete from them where id='nonexist'; PostgreSQL query: "delete from them where id='nonexist';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER PGSQL: command does not return any data but was successful. Rows affected: 0 lookup forced cache cleanup lookup yielded: 0 @@ -85,7 +85,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="select * from them where id='quote2';" opts=NULL database lookup required for select * from them where id='quote2'; PostgreSQL query: "select * from them where id='quote2';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: name="\"stquot" id=quote2 search_open: pgsql "NULL" @@ -97,7 +97,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="select * from them where id='newline';" opts=NULL database lookup required for select * from them where id='newline'; PostgreSQL query: "select * from them where id='newline';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: name="before after" id=newline @@ -110,7 +110,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="select * from them where id='tab';" opts=NULL database lookup required for select * from them where id='tab'; PostgreSQL query: "select * from them where id='tab';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: name="x x" id=tab search_open: pgsql "NULL" @@ -122,7 +122,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="select * from them where name='''stquot';" opts=NULL database lookup required for select * from them where name='''stquot'; PostgreSQL query: "select * from them where name='''stquot';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: name='stquot id=quote1 search_open: pgsql "NULL" @@ -138,25 +138,25 @@ dropping to exim gid; retaining priv uid search_open: pgsql "NULL" cached open search_find: file="NULL" - key="servers=localhost::1223:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL + key="servers=localhost::PORT_N:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL LRU list: internal_search_find: file="NULL" - type=pgsql key="servers=localhost::1223:x; select name from them where id='ph10';" opts=NULL - database lookup required for servers=localhost::1223:x; select name from them where id='ph10'; - PostgreSQL query: "servers=localhost::1223:x; select name from them where id='ph10';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + type=pgsql key="servers=localhost::PORT_N:x; select name from them where id='ph10';" opts=NULL + database lookup required for servers=localhost::PORT_N:x; select name from them where id='ph10'; + PostgreSQL query: "servers=localhost::PORT_N:x; select name from them where id='ph10';" opts 'NULL' + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: Philip Hazel search_open: pgsql "NULL" cached open search_find: file="NULL" - key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL + key="servers=localhost::PORT_N/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL LRU list: internal_search_find: file="NULL" - type=pgsql key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" opts=NULL - database lookup required for servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10'; - PostgreSQL query: "servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + type=pgsql key="servers=localhost::PORT_N/test/CALLER/:x; select name from them where id='ph10';" opts=NULL + database lookup required for servers=localhost::PORT_N/test/CALLER/:x; select name from them where id='ph10'; + PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/:x; select name from them where id='ph10';" opts 'NULL' + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: Philip Hazel search_open: pgsql "NULL" @@ -180,7 +180,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa'); PostgreSQL query: "SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: Philip Hazel Aristotle @@ -193,7 +193,7 @@ dropping to exim gid; retaining priv uid type=pgsql key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL database lookup required for SELECT * FROM them WHERE id IN ('ph10', 'aaaa'); PostgreSQL query: "SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER creating new cache entry lookup yielded: name="Philip Hazel" id=ph10 name=Aristotle id=aaaa @@ -206,21 +206,21 @@ dropping to exim gid; retaining priv uid type=pgsql key="delete from them where id='aaaa'" opts=NULL database lookup required for delete from them where id='aaaa' PostgreSQL query: "delete from them where id='aaaa'" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER PGSQL: command does not return any data but was successful. Rows affected: 1 lookup forced cache cleanup lookup yielded: 1 search_tidyup called close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER -close PGSQL connection: localhost:1223/test/CALLER ->>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>> +close PGSQL connection: localhost:PORT_N/test/CALLER +>>>>>>>>>>>>>>>> Exim pid=p1235 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>> Exim version x.yz .... changed uid/gid: forcing real = effective - uid=uuuu gid=CALLER_GID pid=pppp + uid=uuuu gid=CALLER_GID pid=p1236 configuration file is TESTSUITE/test-config admin user changed uid/gid: privilege not needed - uid=EXIM_UID gid=EXIM_GID pid=pppp + uid=EXIM_UID gid=EXIM_GID pid=p1236 seeking password data for user "CALLER": cache not available getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME @@ -241,6 +241,9 @@ host in helo_accept_junk_hosts? no (option unset) SMTP>> 220 myhost.test.ex ESMTP Exim x.yz Tue, 2 Mar 1999 09:44:33 +0000 smtp_setup_msg entered SMTP<< helo test +test in helo_lookup_domains? + list element: @ + list element: @[] test in helo_lookup_domains? no (end of list) sender_fullhost = (test) [10.0.0.0] sender_rcvhost = [10.0.0.0] (helo=test) @@ -260,132 +263,178 @@ processing "warn" (TESTSUITE/test-config 27) internal_search_find: file="NULL" type=pgsql key="select name from them where id = 'c'" opts=NULL database lookup required for select name from them where id = 'c' + (tainted, quoted:pgsql) PostgreSQL query: "select name from them where id = 'c'" opts 'NULL' - PGSQL new connection: host=localhost port=1223 database=test user=CALLER + PGSQL new connection: host=localhost port=PORT_N database=test user=CALLER PGSQL: no data found creating new cache entry lookup failed -check set acl_m0 = ok: ${lookup pgsql {select name from them where id = '$local_part'}} +check set acl_m0 = ok: ${lookup pgsql {select name from them where id = '${quote_pgsql:$local_part}'}} = ok: search_open: pgsql "NULL" cached open search_find: file="NULL" - key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::1223/test/CALLER/" + key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="cache=no_rd" LRU list: internal_search_find: file="NULL" - type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::1223/test/CALLER/" + type=pgsql key="select name from them where id = 'c'" opts=NULL + cached data found but no_rd option set; database lookup required for select name from them where id = 'c' + (tainted) +LOG: MAIN PANIC + tainted search query is not properly quoted (ACL warn, TESTSUITE/test-config 27): select name from them where id = 'c' + search_type NN (pgsql) quoting -1 (none) + PostgreSQL query: "select name from them where id = 'c'" opts 'NULL' + PGSQL using cached connection for localhost:PORT_N/test/CALLER + PGSQL: no data found + replacing old cache entry + lookup failed +check set acl_m0 = FAIL: ${lookup pgsql,cache=no_rd {select name from them where id = '$local_part'}} + = FAIL: +warn: condition test succeeded in ACL "check_recipient" +processing "warn" (TESTSUITE/test-config 32) + search_open: pgsql "NULL" + cached open + search_find: file="NULL" + key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N/test/CALLER/" + LRU list: + internal_search_find: file="NULL" + type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::PORT_N/test/CALLER/" cached data found but wrong opts; database lookup required for select name from them where id = 'c' - PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::1223/test/CALLER/' - PGSQL using cached connection for localhost:1223/test/CALLER + (tainted, quoted:pgsql) + PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::PORT_N/test/CALLER/' + PGSQL using cached connection for localhost:PORT_N/test/CALLER PGSQL: no data found replacing old cache entry lookup failed -check set acl_m0 = ok: ${lookup pgsql,servers=localhost::1223/test/CALLER/ {select name from them where id = '$local_part'}} +check set acl_m0 = ok: ${lookup pgsql,servers=localhost::PORT_N/test/CALLER/ {select name from them where id = '${quote_pgsql:$local_part}'}} = ok: search_open: pgsql "NULL" cached open search_find: file="NULL" - key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::1223" + key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N" LRU list: internal_search_find: file="NULL" - type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::1223" + type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::PORT_N" cached data found but wrong opts; database lookup required for select name from them where id = 'c' - PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::1223' - PGSQL using cached connection for localhost:1223/test/CALLER + (tainted, quoted:pgsql) + PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::PORT_N' + PGSQL using cached connection for localhost:PORT_N/test/CALLER PGSQL: no data found replacing old cache entry lookup failed -check set acl_m0 = ok: ${lookup pgsql,servers=localhost::1223 {select name from them where id = '$local_part'}} +check set acl_m0 = ok: ${lookup pgsql,servers=localhost::PORT_N {select name from them where id = '${quote_pgsql:$local_part}'}} = ok: search_open: pgsql "NULL" cached open search_find: file="NULL" - key="servers=localhost::1223/test/CALLER/; select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL + key="servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL LRU list: internal_search_find: file="NULL" - type=pgsql key="servers=localhost::1223/test/CALLER/; select name from them where id = 'c'" opts=NULL - database lookup required for servers=localhost::1223/test/CALLER/; select name from them where id = 'c' - PostgreSQL query: "servers=localhost::1223/test/CALLER/; select name from them where id = 'c'" opts 'NULL' - lookup deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted + type=pgsql key="servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" opts=NULL + database lookup required for servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c' + (tainted, quoted:pgsql) + PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" opts 'NULL' + lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted warn: condition test deferred in ACL "check_recipient" LOG: MAIN - H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -processing "warn" (TESTSUITE/test-config 38) + H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +processing "warn" (TESTSUITE/test-config 41) check set acl_m0 = ok: hostlist -check hosts = net-pgsql;select * from them where id='$local_part' -search_open: pgsql "NULL" - cached open -search_find: file="NULL" - key="select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL -LRU list: -internal_search_find: file="NULL" - type=pgsql key="select * from them where id='c'" opts=NULL -database lookup required for select * from them where id='c' -PostgreSQL query: "select * from them where id='c'" opts 'NULL' -PGSQL using cached connection for localhost:1223/test/CALLER -PGSQL: no data found -creating new cache entry -lookup failed +check hosts = net-pgsql;select * from them where id='${quote_pgsql:$local_part}' +host in "net-pgsql;select * from them where id='c'"? + list element: net-pgsql;select * from them where id='c' + search_open: pgsql "NULL" + cached open + search_find: file="NULL" + key="select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL + LRU list: + internal_search_find: file="NULL" + type=pgsql key="select * from them where id='c'" opts=NULL + database lookup required for select * from them where id='c' + (tainted, quoted:pgsql) + PostgreSQL query: "select * from them where id='c'" opts 'NULL' + PGSQL using cached connection for localhost:PORT_N/test/CALLER + PGSQL: no data found + creating new cache entry + lookup failed host in "net-pgsql;select * from them where id='c'"? no (end of list) warn: condition test failed in ACL "check_recipient" -processing "warn" (TESTSUITE/test-config 41) +processing "warn" (TESTSUITE/test-config 44) check set acl_m0 = FAIL: hostlist -check hosts = <& net-pgsql;servers=localhost::1223/test/CALLER/; select * from them where id='$local_part' -search_open: pgsql "NULL" - cached open -search_find: file="NULL" - key="servers=localhost::1223/test/CALLER/; select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL -LRU list: -internal_search_find: file="NULL" - type=pgsql key="servers=localhost::1223/test/CALLER/; select * from them where id='c'" opts=NULL -database lookup required for servers=localhost::1223/test/CALLER/; select * from them where id='c' -PostgreSQL query: "servers=localhost::1223/test/CALLER/; select * from them where id='c'" opts 'NULL' -lookup deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -host in "<& net-pgsql;servers=localhost::1223/test/CALLER/; select * from them where id='c'"? list match deferred for net-pgsql;servers=localhost::1223/test/CALLER/; select * from them where id='c' +check hosts = <& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='${quote_pgsql:$local_part}' +host in "<& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"? + list element: net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c' + search_open: pgsql "NULL" + cached open + search_find: file="NULL" + key="servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL + LRU list: + internal_search_find: file="NULL" + type=pgsql key="servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" opts=NULL + database lookup required for servers=localhost::PORT_N/test/CALLER/; select * from them where id='c' + (tainted, quoted:pgsql) + PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" opts 'NULL' + lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +host in "<& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"? list match deferred for net-pgsql;servers=localhost::1223/test/CALLER/; select * from them where id='c' warn: condition test deferred in ACL "check_recipient" LOG: MAIN - H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -processing "warn" (TESTSUITE/test-config 46) + H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +processing "warn" (TESTSUITE/test-config 49) check set acl_m0 = FAIL: hostlist -check hosts = <& net-pgsql,servers=localhost::1223/test/CALLER/; select * from them where id='$local_part' -search_open: pgsql "NULL" - cached open -search_find: file="NULL" - key=" select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::1223/test/CALLER/" -LRU list: -internal_search_find: file="NULL" - type=pgsql key=" select * from them where id='c'" opts="servers=localhost::1223/test/CALLER/" -database lookup required for select * from them where id='c' -PostgreSQL query: " select * from them where id='c'" opts 'servers=localhost::1223/test/CALLER/' -lookup deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -host in "<& net-pgsql,servers=localhost::1223/test/CALLER/; select * from them where id='c'"? list match deferred for net-pgsql,servers=localhost::1223/test/CALLER/; select * from them where id='c' +check hosts = <& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='${quote_pgsql:$local_part}' +host in "<& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"? + list element: net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c' + search_open: pgsql "NULL" + cached open + search_find: file="NULL" + key=" select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N/test/CALLER/" + LRU list: + internal_search_find: file="NULL" + type=pgsql key=" select * from them where id='c'" opts="servers=localhost::PORT_N/test/CALLER/" + database lookup required for select * from them where id='c' + (tainted, quoted:pgsql) + PostgreSQL query: " select * from them where id='c'" opts 'servers=localhost::PORT_N/test/CALLER/' + lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +host in "<& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"? list match deferred for net-pgsql,servers=localhost::1223/test/CALLER/; select * from them where id='c' warn: condition test deferred in ACL "check_recipient" LOG: MAIN - H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -processing "accept" (TESTSUITE/test-config 49) + H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +processing "accept" (TESTSUITE/test-config 52) check domains = +local_domains -d in "@"? no (end of list) +d in "+local_domains"? + list element: +local_domains + start sublist local_domains + d in "@"? + ╎list element: @ + d in "@"? no (end of list) + end sublist local_domains d in "+local_domains"? no (end of list) accept: condition test failed in ACL "check_recipient" -processing "accept" (TESTSUITE/test-config 50) +processing "accept" (TESTSUITE/test-config 53) check hosts = +relay_hosts -search_open: pgsql "NULL" - cached open -search_find: file="NULL" - key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL -LRU list: -internal_search_find: file="NULL" - type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL -database lookup required for select * from them where id='10.0.0.0' -PostgreSQL query: "select * from them where id='10.0.0.0'" opts 'NULL' -PGSQL using cached connection for localhost:1223/test/CALLER -PGSQL: no data found -creating new cache entry -lookup failed -host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list) +host in "+relay_hosts"? + list element: +relay_hosts + start sublist relay_hosts + host in "net-pgsql;select * from them where id='10.0.0.0'"? + ╎list element: net-pgsql;select * from them where id='10.0.0.0' + ╎search_open: pgsql "NULL" + ╎ cached open + ╎search_find: file="NULL" + ╎ key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL + ╎LRU list: + ╎internal_search_find: file="NULL" + ╎ type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL + ╎database lookup required for select * from them where id='10.0.0.0' + ╎PostgreSQL query: "select * from them where id='10.0.0.0'" opts 'NULL' + ╎PGSQL using cached connection for localhost:PORT_N/test/CALLER + ╎PGSQL: no data found + ╎creating new cache entry + ╎lookup failed + host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list) + end sublist relay_hosts host in "+relay_hosts"? no (end of list) accept: condition test failed in ACL "check_recipient" -processing "deny" (TESTSUITE/test-config 51) +processing "deny" (TESTSUITE/test-config 54) message: relay not permitted deny: condition test succeeded in ACL "check_recipient" end of ACL "check_recipient": DENY @@ -403,124 +452,169 @@ processing "warn" (TESTSUITE/test-config 27) internal_search_find: file="NULL" type=pgsql key="select name from them where id = 'c'" opts=NULL cached data found but wrong opts; database lookup required for select name from them where id = 'c' + (tainted, quoted:pgsql) PostgreSQL query: "select name from them where id = 'c'" opts 'NULL' - PGSQL using cached connection for localhost:1223/test/CALLER + PGSQL using cached connection for localhost:PORT_N/test/CALLER PGSQL: no data found replacing old cache entry lookup failed -check set acl_m0 = ok: ${lookup pgsql {select name from them where id = '$local_part'}} +check set acl_m0 = ok: ${lookup pgsql {select name from them where id = '${quote_pgsql:$local_part}'}} = ok: search_open: pgsql "NULL" cached open search_find: file="NULL" - key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::1223/test/CALLER/" + key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="cache=no_rd" LRU list: internal_search_find: file="NULL" - type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::1223/test/CALLER/" + type=pgsql key="select name from them where id = 'c'" opts=NULL + cached data found but no_rd option set; database lookup required for select name from them where id = 'c' + (tainted) +LOG: MAIN PANIC + tainted search query is not properly quoted (ACL warn, TESTSUITE/test-config 27): select name from them where id = 'c' + search_type NN (pgsql) quoting -1 (none) + PostgreSQL query: "select name from them where id = 'c'" opts 'NULL' + PGSQL using cached connection for localhost:PORT_N/test/CALLER + PGSQL: no data found + replacing old cache entry + lookup failed +check set acl_m0 = FAIL: ${lookup pgsql,cache=no_rd {select name from them where id = '$local_part'}} + = FAIL: +warn: condition test succeeded in ACL "check_recipient" +processing "warn" (TESTSUITE/test-config 32) + search_open: pgsql "NULL" + cached open + search_find: file="NULL" + key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N/test/CALLER/" + LRU list: + internal_search_find: file="NULL" + type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::PORT_N/test/CALLER/" cached data found but wrong opts; database lookup required for select name from them where id = 'c' - PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::1223/test/CALLER/' - PGSQL using cached connection for localhost:1223/test/CALLER + (tainted, quoted:pgsql) + PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::PORT_N/test/CALLER/' + PGSQL using cached connection for localhost:PORT_N/test/CALLER PGSQL: no data found replacing old cache entry lookup failed -check set acl_m0 = ok: ${lookup pgsql,servers=localhost::1223/test/CALLER/ {select name from them where id = '$local_part'}} +check set acl_m0 = ok: ${lookup pgsql,servers=localhost::PORT_N/test/CALLER/ {select name from them where id = '${quote_pgsql:$local_part}'}} = ok: search_open: pgsql "NULL" cached open search_find: file="NULL" - key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::1223" + key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N" LRU list: internal_search_find: file="NULL" - type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::1223" + type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::PORT_N" cached data found but wrong opts; database lookup required for select name from them where id = 'c' - PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::1223' - PGSQL using cached connection for localhost:1223/test/CALLER + (tainted, quoted:pgsql) + PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::PORT_N' + PGSQL using cached connection for localhost:PORT_N/test/CALLER PGSQL: no data found replacing old cache entry lookup failed -check set acl_m0 = ok: ${lookup pgsql,servers=localhost::1223 {select name from them where id = '$local_part'}} +check set acl_m0 = ok: ${lookup pgsql,servers=localhost::PORT_N {select name from them where id = '${quote_pgsql:$local_part}'}} = ok: search_open: pgsql "NULL" cached open search_find: file="NULL" - key="servers=localhost::1223/test/CALLER/; select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL + key="servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL LRU list: internal_search_find: file="NULL" - type=pgsql key="servers=localhost::1223/test/CALLER/; select name from them where id = 'c'" opts=NULL - database lookup required for servers=localhost::1223/test/CALLER/; select name from them where id = 'c' - PostgreSQL query: "servers=localhost::1223/test/CALLER/; select name from them where id = 'c'" opts 'NULL' - lookup deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted + type=pgsql key="servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" opts=NULL + database lookup required for servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c' + (tainted, quoted:pgsql) + PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" opts 'NULL' + lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted warn: condition test deferred in ACL "check_recipient" LOG: MAIN - H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -processing "warn" (TESTSUITE/test-config 38) + H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +processing "warn" (TESTSUITE/test-config 41) check set acl_m0 = ok: hostlist -check hosts = net-pgsql;select * from them where id='$local_part' -search_open: pgsql "NULL" - cached open -search_find: file="NULL" - key="select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL -LRU list: -internal_search_find: file="NULL" - type=pgsql key="select * from them where id='c'" opts=NULL -cached data used for lookup of select * from them where id='c' -lookup failed +check hosts = net-pgsql;select * from them where id='${quote_pgsql:$local_part}' +host in "net-pgsql;select * from them where id='c'"? + list element: net-pgsql;select * from them where id='c' + search_open: pgsql "NULL" + cached open + search_find: file="NULL" + key="select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL + LRU list: + internal_search_find: file="NULL" + type=pgsql key="select * from them where id='c'" opts=NULL + cached data used for lookup of select * from them where id='c' + lookup failed host in "net-pgsql;select * from them where id='c'"? no (end of list) warn: condition test failed in ACL "check_recipient" -processing "warn" (TESTSUITE/test-config 41) +processing "warn" (TESTSUITE/test-config 44) check set acl_m0 = FAIL: hostlist -check hosts = <& net-pgsql;servers=localhost::1223/test/CALLER/; select * from them where id='$local_part' -search_open: pgsql "NULL" - cached open -search_find: file="NULL" - key="servers=localhost::1223/test/CALLER/; select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL -LRU list: -internal_search_find: file="NULL" - type=pgsql key="servers=localhost::1223/test/CALLER/; select * from them where id='c'" opts=NULL -database lookup required for servers=localhost::1223/test/CALLER/; select * from them where id='c' -PostgreSQL query: "servers=localhost::1223/test/CALLER/; select * from them where id='c'" opts 'NULL' -lookup deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -host in "<& net-pgsql;servers=localhost::1223/test/CALLER/; select * from them where id='c'"? list match deferred for net-pgsql;servers=localhost::1223/test/CALLER/; select * from them where id='c' +check hosts = <& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='${quote_pgsql:$local_part}' +host in "<& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"? + list element: net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c' + search_open: pgsql "NULL" + cached open + search_find: file="NULL" + key="servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL + LRU list: + internal_search_find: file="NULL" + type=pgsql key="servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" opts=NULL + database lookup required for servers=localhost::PORT_N/test/CALLER/; select * from them where id='c' + (tainted, quoted:pgsql) + PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" opts 'NULL' + lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +host in "<& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"? list match deferred for net-pgsql;servers=localhost::1223/test/CALLER/; select * from them where id='c' warn: condition test deferred in ACL "check_recipient" LOG: MAIN - H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -processing "warn" (TESTSUITE/test-config 46) + H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +processing "warn" (TESTSUITE/test-config 49) check set acl_m0 = FAIL: hostlist -check hosts = <& net-pgsql,servers=localhost::1223/test/CALLER/; select * from them where id='$local_part' -search_open: pgsql "NULL" - cached open -search_find: file="NULL" - key=" select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::1223/test/CALLER/" -LRU list: -internal_search_find: file="NULL" - type=pgsql key=" select * from them where id='c'" opts="servers=localhost::1223/test/CALLER/" -database lookup required for select * from them where id='c' -PostgreSQL query: " select * from them where id='c'" opts 'servers=localhost::1223/test/CALLER/' -lookup deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -host in "<& net-pgsql,servers=localhost::1223/test/CALLER/; select * from them where id='c'"? list match deferred for net-pgsql,servers=localhost::1223/test/CALLER/; select * from them where id='c' +check hosts = <& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='${quote_pgsql:$local_part}' +host in "<& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"? + list element: net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c' + search_open: pgsql "NULL" + cached open + search_find: file="NULL" + key=" select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N/test/CALLER/" + LRU list: + internal_search_find: file="NULL" + type=pgsql key=" select * from them where id='c'" opts="servers=localhost::PORT_N/test/CALLER/" + database lookup required for select * from them where id='c' + (tainted, quoted:pgsql) + PostgreSQL query: " select * from them where id='c'" opts 'servers=localhost::PORT_N/test/CALLER/' + lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +host in "<& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"? list match deferred for net-pgsql,servers=localhost::1223/test/CALLER/; select * from them where id='c' warn: condition test deferred in ACL "check_recipient" LOG: MAIN - H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:1223/test/CALLER/" is tainted -processing "accept" (TESTSUITE/test-config 49) + H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted +processing "accept" (TESTSUITE/test-config 52) check domains = +local_domains -d in "@"? no (end of list) +d in "+local_domains"? + list element: +local_domains + start sublist local_domains + d in "@"? + ╎list element: @ + d in "@"? no (end of list) + end sublist local_domains d in "+local_domains"? no (end of list) accept: condition test failed in ACL "check_recipient" -processing "accept" (TESTSUITE/test-config 50) +processing "accept" (TESTSUITE/test-config 53) check hosts = +relay_hosts -search_open: pgsql "NULL" - cached open -search_find: file="NULL" - key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL -LRU list: -internal_search_find: file="NULL" - type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL -cached data used for lookup of select * from them where id='10.0.0.0' -lookup failed -host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list) +host in "+relay_hosts"? + list element: +relay_hosts + start sublist relay_hosts + host in "net-pgsql;select * from them where id='10.0.0.0'"? + ╎list element: net-pgsql;select * from them where id='10.0.0.0' + ╎search_open: pgsql "NULL" + ╎ cached open + ╎search_find: file="NULL" + ╎ key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL + ╎LRU list: + ╎internal_search_find: file="NULL" + ╎ type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL + ╎cached data used for lookup of select * from them where id='10.0.0.0' + ╎lookup failed + host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list) + end sublist relay_hosts host in "+relay_hosts"? no (end of list) accept: condition test failed in ACL "check_recipient" -processing "deny" (TESTSUITE/test-config 51) +processing "deny" (TESTSUITE/test-config 54) message: relay not permitted deny: condition test succeeded in ACL "check_recipient" end of ACL "check_recipient": DENY @@ -530,17 +624,17 @@ LOG: MAIN REJECT SMTP<< quit SMTP>> 221 myhost.test.ex closing connection LOG: smtp_connection MAIN - SMTP connection from (test) [10.0.0.0] closed by QUIT + SMTP connection from (test) [10.0.0.0] D=qqs closed by QUIT search_tidyup called -close PGSQL connection: localhost:1223/test/CALLER ->>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>> +close PGSQL connection: localhost:PORT_N/test/CALLER +>>>>>>>>>>>>>>>> Exim pid=p1236 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>> Exim version x.yz .... changed uid/gid: forcing real = effective - uid=uuuu gid=CALLER_GID pid=pppp + uid=uuuu gid=CALLER_GID pid=p1237 configuration file is TESTSUITE/test-config admin user changed uid/gid: privilege not needed - uid=EXIM_UID gid=EXIM_GID pid=pppp + uid=EXIM_UID gid=EXIM_GID pid=p1237 seeking password data for user "CALLER": cache not available getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME @@ -554,8 +648,11 @@ Recipients: search_tidyup called >>Headers received: -rewrite_one_header: type=F: - From: CALLER_NAME +qualify & rewrite recipients list +global rewrite rules +rewrite headers + rewrite_one_header: type=F: + From: CALLER_NAME search_tidyup called >>Headers after rewriting and local additions: I Message-Id: @@ -581,7 +678,7 @@ search_tidyup called exec TESTSUITE/eximdir/exim -DEXIM_PATH=TESTSUITE/eximdir/exim -C TESTSUITE/test-config -d=0xf7715cfd -MCd local-accept-delivery -odi -Mc 10HmaX-0005vi-00 Exim version x.yz .... changed uid/gid: forcing real = effective - uid=uuuu gid=EXIM_GID pid=pppp + uid=uuuu gid=EXIM_GID pid=p1238 configuration file is TESTSUITE/test-config trusted user admin user @@ -628,7 +725,7 @@ processing address_data type=pgsql key="select name from them where id='ph10'" opts=NULL database lookup required for select name from them where id='ph10' PostgreSQL query: "select name from them where id='ph10'" opts 'NULL' - PGSQL new connection: host=localhost port=1223 database=test user=CALLER + PGSQL new connection: host=localhost port=PORT_N database=test user=CALLER creating new cache entry lookup yielded: Philip Hazel calling r1 router @@ -650,7 +747,7 @@ After routing: Failed addresses: Deferred addresses: search_tidyup called -close PGSQL connection: localhost:1223/test/CALLER +close PGSQL connection: localhost:PORT_N/test/CALLER >>>>>>>>>>>>>>>> Local deliveries >>>>>>>>>>>>>>>> --------> CALLER@myhost.test.ex <-------- locking TESTSUITE/spool/db/retry.lockfile @@ -661,7 +758,7 @@ close PGSQL connection: localhost:1223/test/CALLER no retry data available search_tidyup called changed uid/gid: local delivery to CALLER transport=t1 - uid=CALLER_UID gid=CALLER_GID pid=pppp + uid=CALLER_UID gid=CALLER_GID pid=p1239 home=NULL current=/ set_process_info: pppp delivering 10HmaX-0005vi-00 to CALLER using t1 appendfile transport entered @@ -673,7 +770,7 @@ appendfile transport entered type=pgsql key="select id from them where id='ph10'" opts=NULL database lookup required for select id from them where id='ph10' PostgreSQL query: "select id from them where id='ph10'" opts 'NULL' - PGSQL new connection: host=localhost port=1223 database=test user=CALLER + PGSQL new connection: host=localhost port=PORT_N database=test user=CALLER creating new cache entry lookup yielded: ph10 appendfile: mode=600 notify_comsat=0 quota=0 warning=0 @@ -693,7 +790,7 @@ writing data block fd=dddd size=sss timeout=0 writing data block fd=dddd size=sss timeout=0 appendfile yields 0 with errno=dd more_errno=dd search_tidyup called -close PGSQL connection: localhost:1223/test/CALLER +close PGSQL connection: localhost:PORT_N/test/CALLER journalling CALLER@myhost.test.ex t1 transport returned OK for CALLER@myhost.test.ex post-process CALLER@myhost.test.ex (0) @@ -702,7 +799,7 @@ LOG: MAIN => CALLER R=r1 T=t1 >>>>>>>>>>>>>>>> deliveries are done >>>>>>>>>>>>>>>> changed uid/gid: post-delivery tidying - uid=EXIM_UID gid=EXIM_GID pid=pppp + uid=EXIM_UID gid=EXIM_GID pid=p1238 set_process_info: pppp tidying up after delivering 10HmaX-0005vi-00 Processing retry items Succeeded addresses: @@ -723,9 +820,9 @@ LOG: MAIN end delivery of 10HmaX-0005vi-00 search_tidyup called search_tidyup called ->>>>>>>>>>>>>>>> Exim pid=pppp (local-accept-delivery) terminating with rc=0 >>>>>>>>>>>>>>>> +>>>>>>>>>>>>>>>> Exim pid=p1238 (local-accept-delivery) terminating with rc=0 >>>>>>>>>>>>>>>> search_tidyup called ->>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>> +>>>>>>>>>>>>>>>> Exim pid=p1237 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>> Exim version x.yz .... configuration file is TESTSUITE/test-config admin user @@ -743,6 +840,8 @@ dropping to exim gid; retaining priv uid lookup yielded: Philip Hazel search_tidyup called close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER ->>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>> +>>>>>>>>>>>>>>>> Exim pid=p1240 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>> ******** SERVER ******** +2017-07-30 18:51:05.712 [pppp] LOG: redirecting log output to logging collector process +2017-07-30 18:51:05.712 [pppp] HINT: Future log output will appear in directory "log".