2 WARNING: enabling "trust" authentication for local connections
3 You can change this by editing pg_hba.conf or using the option -A, or
4 --auth-local and --auth-host, the next time you run initdb.
6 configuration file is TESTSUITE/test-config
8 dropping to exim gid; retaining priv uid
9 search_open: pgsql "NULL"
10 search_find: file="NULL"
11 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
13 internal_search_find: file="NULL"
14 type=pgsql key="select name from them where id='ph10';" opts=NULL
15 database lookup required for select name from them where id='ph10';
16 PostgreSQL query: "select name from them where id='ph10';" opts 'NULL'
17 PGSQL new connection: host=localhost port=PORT_N database=test user=CALLER
18 creating new cache entry
19 lookup yielded: Philip Hazel
20 search_open: pgsql "NULL"
22 search_find: file="NULL"
23 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
25 internal_search_find: file="NULL"
26 type=pgsql key="select name from them where id='ph10';" opts=NULL
27 cached data used for lookup of select name from them where id='ph10';
28 lookup yielded: Philip Hazel
29 search_open: pgsql "NULL"
31 search_find: file="NULL"
32 key="select name from them where id='xxxx';" partial=-1 affix=NULL starflags=0 opts=NULL
34 internal_search_find: file="NULL"
35 type=pgsql key="select name from them where id='xxxx';" opts=NULL
36 database lookup required for select name from them where id='xxxx';
37 PostgreSQL query: "select name from them where id='xxxx';" opts 'NULL'
38 PGSQL using cached connection for localhost:PORT_N/test/CALLER
40 creating new cache entry
42 search_open: pgsql "NULL"
44 search_find: file="NULL"
45 key="select name from them where id='nothing';" partial=-1 affix=NULL starflags=0 opts=NULL
47 internal_search_find: file="NULL"
48 type=pgsql key="select name from them where id='nothing';" opts=NULL
49 database lookup required for select name from them where id='nothing';
50 PostgreSQL query: "select name from them where id='nothing';" opts 'NULL'
51 PGSQL using cached connection for localhost:PORT_N/test/CALLER
52 creating new cache entry
54 search_open: pgsql "NULL"
56 search_find: file="NULL"
57 key="select id,name from them where id='nothing';" partial=-1 affix=NULL starflags=0 opts=NULL
59 internal_search_find: file="NULL"
60 type=pgsql key="select id,name from them where id='nothing';" opts=NULL
61 database lookup required for select id,name from them where id='nothing';
62 PostgreSQL query: "select id,name from them where id='nothing';" opts 'NULL'
63 PGSQL using cached connection for localhost:PORT_N/test/CALLER
64 creating new cache entry
65 lookup yielded: id=nothing name=""
66 search_open: pgsql "NULL"
68 search_find: file="NULL"
69 key="delete from them where id='nonexist';" partial=-1 affix=NULL starflags=0 opts=NULL
71 internal_search_find: file="NULL"
72 type=pgsql key="delete from them where id='nonexist';" opts=NULL
73 database lookup required for delete from them where id='nonexist';
74 PostgreSQL query: "delete from them where id='nonexist';" opts 'NULL'
75 PGSQL using cached connection for localhost:PORT_N/test/CALLER
76 PGSQL: command does not return any data but was successful. Rows affected: 0
77 lookup forced cache cleanup
79 search_open: pgsql "NULL"
81 search_find: file="NULL"
82 key="select * from them where id='quote2';" partial=-1 affix=NULL starflags=0 opts=NULL
84 internal_search_find: file="NULL"
85 type=pgsql key="select * from them where id='quote2';" opts=NULL
86 database lookup required for select * from them where id='quote2';
87 PostgreSQL query: "select * from them where id='quote2';" opts 'NULL'
88 PGSQL using cached connection for localhost:PORT_N/test/CALLER
89 creating new cache entry
90 lookup yielded: name="\"stquot" id=quote2
91 search_open: pgsql "NULL"
93 search_find: file="NULL"
94 key="select * from them where id='newline';" partial=-1 affix=NULL starflags=0 opts=NULL
96 internal_search_find: file="NULL"
97 type=pgsql key="select * from them where id='newline';" opts=NULL
98 database lookup required for select * from them where id='newline';
99 PostgreSQL query: "select * from them where id='newline';" opts 'NULL'
100 PGSQL using cached connection for localhost:PORT_N/test/CALLER
101 creating new cache entry
102 lookup yielded: name="before
\r
104 search_open: pgsql "NULL"
106 search_find: file="NULL"
107 key="select * from them where id='tab';" partial=-1 affix=NULL starflags=0 opts=NULL
109 internal_search_find: file="NULL"
110 type=pgsql key="select * from them where id='tab';" opts=NULL
111 database lookup required for select * from them where id='tab';
112 PostgreSQL query: "select * from them where id='tab';" opts 'NULL'
113 PGSQL using cached connection for localhost:PORT_N/test/CALLER
114 creating new cache entry
115 lookup yielded: name="x x" id=tab
116 search_open: pgsql "NULL"
118 search_find: file="NULL"
119 key="select * from them where name='''stquot';" partial=-1 affix=NULL starflags=0 opts=NULL
121 internal_search_find: file="NULL"
122 type=pgsql key="select * from them where name='''stquot';" opts=NULL
123 database lookup required for select * from them where name='''stquot';
124 PostgreSQL query: "select * from them where name='''stquot';" opts 'NULL'
125 PGSQL using cached connection for localhost:PORT_N/test/CALLER
126 creating new cache entry
127 lookup yielded: name='stquot id=quote1
128 search_open: pgsql "NULL"
130 search_find: file="NULL"
131 key="servers=x:localhost; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
133 internal_search_find: file="NULL"
134 type=pgsql key="servers=x:localhost; select name from them where id='ph10';" opts=NULL
135 database lookup required for servers=x:localhost; select name from them where id='ph10';
136 PostgreSQL query: "servers=x:localhost; select name from them where id='ph10';" opts 'NULL'
137 lookup deferred: PostgreSQL server "x" not found in pgsql_servers
138 search_open: pgsql "NULL"
140 search_find: file="NULL"
141 key="servers=localhost::PORT_N:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
143 internal_search_find: file="NULL"
144 type=pgsql key="servers=localhost::PORT_N:x; select name from them where id='ph10';" opts=NULL
145 database lookup required for servers=localhost::PORT_N:x; select name from them where id='ph10';
146 PostgreSQL query: "servers=localhost::PORT_N:x; select name from them where id='ph10';" opts 'NULL'
147 PGSQL using cached connection for localhost:PORT_N/test/CALLER
148 creating new cache entry
149 lookup yielded: Philip Hazel
150 search_open: pgsql "NULL"
152 search_find: file="NULL"
153 key="servers=localhost::PORT_N/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
155 internal_search_find: file="NULL"
156 type=pgsql key="servers=localhost::PORT_N/test/CALLER/:x; select name from them where id='ph10';" opts=NULL
157 database lookup required for servers=localhost::PORT_N/test/CALLER/:x; select name from them where id='ph10';
158 PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/:x; select name from them where id='ph10';" opts 'NULL'
159 PGSQL using cached connection for localhost:PORT_N/test/CALLER
160 creating new cache entry
161 lookup yielded: Philip Hazel
162 search_open: pgsql "NULL"
164 search_find: file="NULL"
165 key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
167 internal_search_find: file="NULL"
168 type=pgsql key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" opts=NULL
169 database lookup required for servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
170 PostgreSQL query: "servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" opts 'NULL'
171 PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
172 creating new cache entry
173 lookup yielded: Philip Hazel
174 search_open: pgsql "NULL"
176 search_find: file="NULL"
177 key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 opts=NULL
179 internal_search_find: file="NULL"
180 type=pgsql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL
181 database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
182 PostgreSQL query: "SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" opts 'NULL'
183 PGSQL using cached connection for localhost:PORT_N/test/CALLER
184 creating new cache entry
185 lookup yielded: Philip Hazel
187 search_open: pgsql "NULL"
189 search_find: file="NULL"
190 key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 opts=NULL
192 internal_search_find: file="NULL"
193 type=pgsql key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL
194 database lookup required for SELECT * FROM them WHERE id IN ('ph10', 'aaaa');
195 PostgreSQL query: "SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" opts 'NULL'
196 PGSQL using cached connection for localhost:PORT_N/test/CALLER
197 creating new cache entry
198 lookup yielded: name="Philip Hazel" id=ph10
199 name=Aristotle id=aaaa
200 search_open: pgsql "NULL"
202 search_find: file="NULL"
203 key="delete from them where id='aaaa'" partial=-1 affix=NULL starflags=0 opts=NULL
205 internal_search_find: file="NULL"
206 type=pgsql key="delete from them where id='aaaa'" opts=NULL
207 database lookup required for delete from them where id='aaaa'
208 PostgreSQL query: "delete from them where id='aaaa'" opts 'NULL'
209 PGSQL using cached connection for localhost:PORT_N/test/CALLER
210 PGSQL: command does not return any data but was successful. Rows affected: 1
211 lookup forced cache cleanup
214 close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER
215 close PGSQL connection: localhost:PORT_N/test/CALLER
216 >>>>>>>>>>>>>>>> Exim pid=p1235 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
217 Exim version x.yz ....
218 changed uid/gid: forcing real = effective
219 uid=uuuu gid=CALLER_GID pid=p1236
220 configuration file is TESTSUITE/test-config
222 changed uid/gid: privilege not needed
223 uid=EXIM_UID gid=EXIM_GID pid=p1236
224 seeking password data for user "CALLER": cache not available
225 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
226 originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
227 sender address = CALLER@myhost.test.ex
228 sender_fullhost = [10.0.0.0]
229 sender_rcvhost = [10.0.0.0]
230 host in hosts_connection_nolog? no (option unset)
231 LOG: smtp_connection MAIN
232 SMTP connection from [10.0.0.0]
233 host in host_lookup? no (option unset)
234 set_process_info: pppp handling incoming connection from [10.0.0.0]
235 host in host_reject_connection? no (option unset)
236 host in sender_unqualified_hosts? no (option unset)
237 host in recipient_unqualified_hosts? no (option unset)
238 host in helo_verify_hosts? no (option unset)
239 host in helo_try_verify_hosts? no (option unset)
240 host in helo_accept_junk_hosts? no (option unset)
241 host in pipelining_connect_advertise_hosts?
243 SMTP>> 220 myhost.test.ex ESMTP Exim x.yz Tue, 2 Mar 1999 09:44:33 +0000
244 smtp_setup_msg entered
246 test in helo_lookup_domains?
249 test in helo_lookup_domains? no (end of list)
250 sender_fullhost = (test) [10.0.0.0]
251 sender_rcvhost = [10.0.0.0] (helo=test)
252 set_process_info: pppp handling incoming connection from (test) [10.0.0.0]
253 SMTP>> 250 myhost.test.ex Hello test [10.0.0.0]
254 SMTP<< mail from:<a@b>
255 spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
256 log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
259 using ACL "check_recipient"
260 processing "warn" (TESTSUITE/test-config 27)
261 search_open: pgsql "NULL"
262 search_find: file="NULL"
263 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL
265 internal_search_find: file="NULL"
266 type=pgsql key="select name from them where id = 'c'" opts=NULL
267 database lookup required for select name from them where id = 'c'
268 (tainted, quoted:pgsql)
269 PostgreSQL query: "select name from them where id = 'c'" opts 'NULL'
270 PGSQL new connection: host=localhost port=PORT_N database=test user=CALLER
272 creating new cache entry
274 check set acl_m0 = ok: ${lookup pgsql {select name from them where id = '${quote_pgsql:$local_part}'}}
276 search_open: pgsql "NULL"
278 search_find: file="NULL"
279 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="cache=no_rd"
281 internal_search_find: file="NULL"
282 type=pgsql key="select name from them where id = 'c'" opts=NULL
283 cached data found but no_rd option set; database lookup required for select name from them where id = 'c'
286 tainted search query is not properly quoted (ACL warn, TESTSUITE/test-config 27): select name from them where id = 'c'
287 search_type NN (pgsql) quoting -1 (none)
288 PostgreSQL query: "select name from them where id = 'c'" opts 'NULL'
289 PGSQL using cached connection for localhost:PORT_N/test/CALLER
291 replacing old cache entry
293 check set acl_m0 = FAIL: ${lookup pgsql,cache=no_rd {select name from them where id = '$local_part'}}
295 warn: condition test succeeded in ACL "check_recipient"
296 processing "warn" (TESTSUITE/test-config 32)
297 search_open: pgsql "NULL"
299 search_find: file="NULL"
300 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N/test/CALLER/"
302 internal_search_find: file="NULL"
303 type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::PORT_N/test/CALLER/"
304 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
305 (tainted, quoted:pgsql)
306 PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::PORT_N/test/CALLER/'
307 PGSQL using cached connection for localhost:PORT_N/test/CALLER
309 replacing old cache entry
311 check set acl_m0 = ok: ${lookup pgsql,servers=localhost::PORT_N/test/CALLER/ {select name from them where id = '${quote_pgsql:$local_part}'}}
313 search_open: pgsql "NULL"
315 search_find: file="NULL"
316 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N"
318 internal_search_find: file="NULL"
319 type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::PORT_N"
320 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
321 (tainted, quoted:pgsql)
322 PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::PORT_N'
323 PGSQL using cached connection for localhost:PORT_N/test/CALLER
325 replacing old cache entry
327 check set acl_m0 = ok: ${lookup pgsql,servers=localhost::PORT_N {select name from them where id = '${quote_pgsql:$local_part}'}}
329 search_open: pgsql "NULL"
331 search_find: file="NULL"
332 key="servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL
334 internal_search_find: file="NULL"
335 type=pgsql key="servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" opts=NULL
336 database lookup required for servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'
337 (tainted, quoted:pgsql)
338 PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" opts 'NULL'
339 lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
340 warn: condition test deferred in ACL "check_recipient"
342 H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
343 processing "warn" (TESTSUITE/test-config 41)
344 check set acl_m0 = ok: hostlist
345 check hosts = net-pgsql;select * from them where id='${quote_pgsql:$local_part}'
346 host in "net-pgsql;select * from them where id='c'"?
347 list element: net-pgsql;select * from them where id='c'
348 search_open: pgsql "NULL"
350 search_find: file="NULL"
351 key="select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
353 internal_search_find: file="NULL"
354 type=pgsql key="select * from them where id='c'" opts=NULL
355 database lookup required for select * from them where id='c'
356 (tainted, quoted:pgsql)
357 PostgreSQL query: "select * from them where id='c'" opts 'NULL'
358 PGSQL using cached connection for localhost:PORT_N/test/CALLER
360 creating new cache entry
362 host in "net-pgsql;select * from them where id='c'"? no (end of list)
363 warn: condition test failed in ACL "check_recipient"
364 processing "warn" (TESTSUITE/test-config 44)
365 check set acl_m0 = FAIL: hostlist
366 check hosts = <& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='${quote_pgsql:$local_part}'
367 host in "<& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"?
368 list element: net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'
369 search_open: pgsql "NULL"
371 search_find: file="NULL"
372 key="servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
374 internal_search_find: file="NULL"
375 type=pgsql key="servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" opts=NULL
376 database lookup required for servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'
377 (tainted, quoted:pgsql)
378 PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" opts 'NULL'
379 lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
380 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'
381 warn: condition test deferred in ACL "check_recipient"
383 H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
384 processing "warn" (TESTSUITE/test-config 49)
385 check set acl_m0 = FAIL: hostlist
386 check hosts = <& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='${quote_pgsql:$local_part}'
387 host in "<& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"?
388 list element: net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'
389 search_open: pgsql "NULL"
391 search_find: file="NULL"
392 key=" select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N/test/CALLER/"
394 internal_search_find: file="NULL"
395 type=pgsql key=" select * from them where id='c'" opts="servers=localhost::PORT_N/test/CALLER/"
396 database lookup required for select * from them where id='c'
397 (tainted, quoted:pgsql)
398 PostgreSQL query: " select * from them where id='c'" opts 'servers=localhost::PORT_N/test/CALLER/'
399 lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
400 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'
401 warn: condition test deferred in ACL "check_recipient"
403 H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
404 processing "accept" (TESTSUITE/test-config 52)
405 check domains = +local_domains
406 d in "+local_domains"?
407 list element: +local_domains
408 start sublist local_domains
411 d in "@"? no (end of list)
412 end sublist local_domains
413 d in "+local_domains"? no (end of list)
414 accept: condition test failed in ACL "check_recipient"
415 processing "accept" (TESTSUITE/test-config 53)
416 check hosts = +relay_hosts
417 host in "+relay_hosts"?
418 list element: +relay_hosts
419 start sublist relay_hosts
420 host in "net-pgsql;select * from them where id='10.0.0.0'"?
421 ╎list element: net-pgsql;select * from them where id='10.0.0.0'
422 ╎search_open: pgsql "NULL"
424 ╎search_find: file="NULL"
425 ╎ key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL
427 ╎internal_search_find: file="NULL"
428 ╎ type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL
429 ╎database lookup required for select * from them where id='10.0.0.0'
430 ╎PostgreSQL query: "select * from them where id='10.0.0.0'" opts 'NULL'
431 ╎PGSQL using cached connection for localhost:PORT_N/test/CALLER
432 ╎PGSQL: no data found
433 ╎creating new cache entry
435 host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
436 end sublist relay_hosts
437 host in "+relay_hosts"? no (end of list)
438 accept: condition test failed in ACL "check_recipient"
439 processing "deny" (TESTSUITE/test-config 54)
440 message: relay not permitted
441 deny: condition test succeeded in ACL "check_recipient"
442 end of ACL "check_recipient": DENY
443 SMTP>> 550 relay not permitted
445 H=(test) [10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
447 using ACL "check_recipient"
448 processing "warn" (TESTSUITE/test-config 27)
449 search_open: pgsql "NULL"
451 search_find: file="NULL"
452 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL
454 internal_search_find: file="NULL"
455 type=pgsql key="select name from them where id = 'c'" opts=NULL
456 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
457 (tainted, quoted:pgsql)
458 PostgreSQL query: "select name from them where id = 'c'" opts 'NULL'
459 PGSQL using cached connection for localhost:PORT_N/test/CALLER
461 replacing old cache entry
463 check set acl_m0 = ok: ${lookup pgsql {select name from them where id = '${quote_pgsql:$local_part}'}}
465 search_open: pgsql "NULL"
467 search_find: file="NULL"
468 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="cache=no_rd"
470 internal_search_find: file="NULL"
471 type=pgsql key="select name from them where id = 'c'" opts=NULL
472 cached data found but no_rd option set; database lookup required for select name from them where id = 'c'
475 tainted search query is not properly quoted (ACL warn, TESTSUITE/test-config 27): select name from them where id = 'c'
476 search_type NN (pgsql) quoting -1 (none)
477 PostgreSQL query: "select name from them where id = 'c'" opts 'NULL'
478 PGSQL using cached connection for localhost:PORT_N/test/CALLER
480 replacing old cache entry
482 check set acl_m0 = FAIL: ${lookup pgsql,cache=no_rd {select name from them where id = '$local_part'}}
484 warn: condition test succeeded in ACL "check_recipient"
485 processing "warn" (TESTSUITE/test-config 32)
486 search_open: pgsql "NULL"
488 search_find: file="NULL"
489 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N/test/CALLER/"
491 internal_search_find: file="NULL"
492 type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::PORT_N/test/CALLER/"
493 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
494 (tainted, quoted:pgsql)
495 PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::PORT_N/test/CALLER/'
496 PGSQL using cached connection for localhost:PORT_N/test/CALLER
498 replacing old cache entry
500 check set acl_m0 = ok: ${lookup pgsql,servers=localhost::PORT_N/test/CALLER/ {select name from them where id = '${quote_pgsql:$local_part}'}}
502 search_open: pgsql "NULL"
504 search_find: file="NULL"
505 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N"
507 internal_search_find: file="NULL"
508 type=pgsql key="select name from them where id = 'c'" opts="servers=localhost::PORT_N"
509 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
510 (tainted, quoted:pgsql)
511 PostgreSQL query: "select name from them where id = 'c'" opts 'servers=localhost::PORT_N'
512 PGSQL using cached connection for localhost:PORT_N/test/CALLER
514 replacing old cache entry
516 check set acl_m0 = ok: ${lookup pgsql,servers=localhost::PORT_N {select name from them where id = '${quote_pgsql:$local_part}'}}
518 search_open: pgsql "NULL"
520 search_find: file="NULL"
521 key="servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL
523 internal_search_find: file="NULL"
524 type=pgsql key="servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" opts=NULL
525 database lookup required for servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'
526 (tainted, quoted:pgsql)
527 PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/; select name from them where id = 'c'" opts 'NULL'
528 lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
529 warn: condition test deferred in ACL "check_recipient"
531 H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
532 processing "warn" (TESTSUITE/test-config 41)
533 check set acl_m0 = ok: hostlist
534 check hosts = net-pgsql;select * from them where id='${quote_pgsql:$local_part}'
535 host in "net-pgsql;select * from them where id='c'"?
536 list element: net-pgsql;select * from them where id='c'
537 search_open: pgsql "NULL"
539 search_find: file="NULL"
540 key="select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
542 internal_search_find: file="NULL"
543 type=pgsql key="select * from them where id='c'" opts=NULL
544 cached data used for lookup of select * from them where id='c'
546 host in "net-pgsql;select * from them where id='c'"? no (end of list)
547 warn: condition test failed in ACL "check_recipient"
548 processing "warn" (TESTSUITE/test-config 44)
549 check set acl_m0 = FAIL: hostlist
550 check hosts = <& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='${quote_pgsql:$local_part}'
551 host in "<& net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"?
552 list element: net-pgsql;servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'
553 search_open: pgsql "NULL"
555 search_find: file="NULL"
556 key="servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
558 internal_search_find: file="NULL"
559 type=pgsql key="servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" opts=NULL
560 database lookup required for servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'
561 (tainted, quoted:pgsql)
562 PostgreSQL query: "servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'" opts 'NULL'
563 lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
564 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'
565 warn: condition test deferred in ACL "check_recipient"
567 H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
568 processing "warn" (TESTSUITE/test-config 49)
569 check set acl_m0 = FAIL: hostlist
570 check hosts = <& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='${quote_pgsql:$local_part}'
571 host in "<& net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'"?
572 list element: net-pgsql,servers=localhost::PORT_N/test/CALLER/; select * from them where id='c'
573 search_open: pgsql "NULL"
575 search_find: file="NULL"
576 key=" select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts="servers=localhost::PORT_N/test/CALLER/"
578 internal_search_find: file="NULL"
579 type=pgsql key=" select * from them where id='c'" opts="servers=localhost::PORT_N/test/CALLER/"
580 database lookup required for select * from them where id='c'
581 (tainted, quoted:pgsql)
582 PostgreSQL query: " select * from them where id='c'" opts 'servers=localhost::PORT_N/test/CALLER/'
583 lookup deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
584 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'
585 warn: condition test deferred in ACL "check_recipient"
587 H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "localhost:PORT_N/test/CALLER/" is tainted
588 processing "accept" (TESTSUITE/test-config 52)
589 check domains = +local_domains
590 d in "+local_domains"?
591 list element: +local_domains
592 start sublist local_domains
595 d in "@"? no (end of list)
596 end sublist local_domains
597 d in "+local_domains"? no (end of list)
598 accept: condition test failed in ACL "check_recipient"
599 processing "accept" (TESTSUITE/test-config 53)
600 check hosts = +relay_hosts
601 host in "+relay_hosts"?
602 list element: +relay_hosts
603 start sublist relay_hosts
604 host in "net-pgsql;select * from them where id='10.0.0.0'"?
605 ╎list element: net-pgsql;select * from them where id='10.0.0.0'
606 ╎search_open: pgsql "NULL"
608 ╎search_find: file="NULL"
609 ╎ key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL
611 ╎internal_search_find: file="NULL"
612 ╎ type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL
613 ╎cached data used for lookup of select * from them where id='10.0.0.0'
615 host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
616 end sublist relay_hosts
617 host in "+relay_hosts"? no (end of list)
618 accept: condition test failed in ACL "check_recipient"
619 processing "deny" (TESTSUITE/test-config 54)
620 message: relay not permitted
621 deny: condition test succeeded in ACL "check_recipient"
622 end of ACL "check_recipient": DENY
623 SMTP>> 550 relay not permitted
625 H=(test) [10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
627 SMTP>> 221 myhost.test.ex closing connection
628 LOG: smtp_connection MAIN
629 SMTP connection from (test) [10.0.0.0] closed by QUIT
631 close PGSQL connection: localhost:PORT_N/test/CALLER
632 >>>>>>>>>>>>>>>> Exim pid=p1236 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
633 Exim version x.yz ....
634 changed uid/gid: forcing real = effective
635 uid=uuuu gid=CALLER_GID pid=p1237
636 configuration file is TESTSUITE/test-config
638 changed uid/gid: privilege not needed
639 uid=EXIM_UID gid=EXIM_GID pid=p1237
640 seeking password data for user "CALLER": cache not available
641 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
642 originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
643 sender address = CALLER@myhost.test.ex
644 set_process_info: pppp accepting a local non-SMTP message from <CALLER@myhost.test.ex>
645 spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
646 log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
647 Sender: CALLER@myhost.test.ex
653 qualify & rewrite recipients list
656 rewrite_one_header: type=F:
657 From: CALLER_NAME <CALLER@myhost.test.ex>
659 >>Headers after rewriting and local additions:
660 I Message-Id: <E10HmaX-0005vi-00@myhost.test.ex>
661 F From: CALLER_NAME <CALLER@myhost.test.ex>
662 Date: Tue, 2 Mar 1999 09:44:33 +0000
664 Data file name: TESTSUITE/spool//input//10HmaX-0005vi-00-D
665 Data file written for message 10HmaX-0005vi-00
666 >>Generated Received: header line
667 P Received: from CALLER by myhost.test.ex with local (Exim x.yz)
668 (envelope-from <CALLER@myhost.test.ex>)
670 for CALLER@myhost.test.ex;
671 Tue, 2 Mar 1999 09:44:33 +0000
672 Writing spool header file: TESTSUITE/spool//input//hdr.10HmaX-0005vi-00
673 DSN: **** SPOOL_OUT - address: <CALLER@myhost.test.ex> errorsto: <NULL> orcpt: <NULL> dsn_flags: 0x0
674 Renaming spool header file: TESTSUITE/spool//input//10HmaX-0005vi-00-H
675 Size of headers = sss
677 <= CALLER@myhost.test.ex U=CALLER P=local S=sss
678 created log directory TESTSUITE/spool/log
680 exec TESTSUITE/eximdir/exim -DEXIM_PATH=TESTSUITE/eximdir/exim -C TESTSUITE/test-config -d=0xf7715cfd -MCd local-accept-delivery -odi -Mc 10HmaX-0005vi-00
681 Exim version x.yz ....
682 changed uid/gid: forcing real = effective
683 uid=uuuu gid=EXIM_GID pid=p1238
684 configuration file is TESTSUITE/test-config
687 dropping to exim gid; retaining priv uid
688 seeking password data for user "CALLER": cache not available
689 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
690 set_process_info: pppp delivering specified messages
691 set_process_info: pppp delivering 10HmaX-0005vi-00
692 Trying spool file TESTSUITE/spool//input//10HmaX-0005vi-00-D
693 reading spool file 10HmaX-0005vi-00-H
694 user=CALLER uid=CALLER_UID gid=CALLER_GID sender=CALLER@myhost.test.ex
695 sender_local=1 ident=CALLER
698 ---- End of tree ----
700 **** SPOOL_IN - No additional fields
701 body_linecount=1 message_linecount=8
702 DSN: set orcpt: flags: 0x0
703 Delivery address list:
704 CALLER@myhost.test.ex
705 locking TESTSUITE/spool/db/retry.lockfile
706 locked TESTSUITE/spool/db/retry.lockfile
707 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
708 returned from EXIM_DBOPEN: (nil)
709 failed to open DB file TESTSUITE/spool/db/retry: No such file or directory
710 no retry data available
711 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
712 Considering: CALLER@myhost.test.ex
713 unique = CALLER@myhost.test.ex
714 no domain retry record
715 no address retry record
716 CALLER@myhost.test.ex: queued for routing
717 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
718 routing CALLER@myhost.test.ex
719 --------> r1 router <--------
720 local_part=CALLER domain=myhost.test.ex
721 processing address_data
722 search_open: pgsql "NULL"
723 search_find: file="NULL"
724 key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
726 internal_search_find: file="NULL"
727 type=pgsql key="select name from them where id='ph10'" opts=NULL
728 database lookup required for select name from them where id='ph10'
729 PostgreSQL query: "select name from them where id='ph10'" opts 'NULL'
730 PGSQL new connection: host=localhost port=PORT_N database=test user=CALLER
731 creating new cache entry
732 lookup yielded: Philip Hazel
734 r1 router called for CALLER@myhost.test.ex
735 domain = myhost.test.ex
737 queued for t1 transport: local_part = CALLER
738 domain = myhost.test.ex
740 domain_data=NULL local_part_data=NULL
742 envelope to: CALLER@myhost.test.ex
744 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
747 CALLER@myhost.test.ex
752 close PGSQL connection: localhost:PORT_N/test/CALLER
753 >>>>>>>>>>>>>>>> Local deliveries >>>>>>>>>>>>>>>>
754 --------> CALLER@myhost.test.ex <--------
755 locking TESTSUITE/spool/db/retry.lockfile
756 locked TESTSUITE/spool/db/retry.lockfile
757 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
758 returned from EXIM_DBOPEN: (nil)
759 failed to open DB file TESTSUITE/spool/db/retry: No such file or directory
760 no retry data available
762 changed uid/gid: local delivery to CALLER <CALLER@myhost.test.ex> transport=t1
763 uid=CALLER_UID gid=CALLER_GID pid=p1239
765 set_process_info: pppp delivering 10HmaX-0005vi-00 to CALLER using t1
766 appendfile transport entered
767 search_open: pgsql "NULL"
768 search_find: file="NULL"
769 key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
771 internal_search_find: file="NULL"
772 type=pgsql key="select id from them where id='ph10'" opts=NULL
773 database lookup required for select id from them where id='ph10'
774 PostgreSQL query: "select id from them where id='ph10'" opts 'NULL'
775 PGSQL new connection: host=localhost port=PORT_N database=test user=CALLER
776 creating new cache entry
778 appendfile: mode=600 notify_comsat=0 quota=0 warning=0
779 file=TESTSUITE/test-mail/ph10 format=unix
780 message_prefix=From ${if def:return_path{$return_path}{MAILER-DAEMON}} ${tod_bsdinbox}\n
782 maildir_use_size_file=no
783 locking by lockfile fcntl
784 lock name: TESTSUITE/test-mail/ph10.lock
785 hitch name: TESTSUITE/test-mail/ph10.lock.test.ex.dddddddd.pppppppp
787 mailbox TESTSUITE/test-mail/ph10 is locked
788 writing to file TESTSUITE/test-mail/ph10
789 writing data block fd=dddd size=sss timeout=0
790 cannot use sendfile for body: spoolfile not wireformat
791 writing data block fd=dddd size=sss timeout=0
792 writing data block fd=dddd size=sss timeout=0
793 appendfile yields 0 with errno=dd more_errno=dd
795 close PGSQL connection: localhost:PORT_N/test/CALLER
796 journalling CALLER@myhost.test.ex
797 t1 transport returned OK for CALLER@myhost.test.ex
798 post-process CALLER@myhost.test.ex (0)
799 CALLER@myhost.test.ex delivered
801 => CALLER <CALLER@myhost.test.ex> R=r1 T=t1
802 >>>>>>>>>>>>>>>> deliveries are done >>>>>>>>>>>>>>>>
803 changed uid/gid: post-delivery tidying
804 uid=EXIM_UID gid=EXIM_GID pid=p1238
805 set_process_info: pppp tidying up after delivering 10HmaX-0005vi-00
806 Processing retry items
808 CALLER@myhost.test.ex: no retry items
811 end of retry processing
812 DSN: processing router : r1
813 DSN: processing successful delivery address: CALLER@myhost.test.ex
814 DSN: Sender_address: CALLER@myhost.test.ex
815 DSN: orcpt: NULL flags: 0x0
816 DSN: envid: NULL ret: 0
817 DSN: Final recipient: CALLER@myhost.test.ex
818 DSN: Remote SMTP server supports DSN: 0
819 DSN: not sending DSN success message
822 end delivery of 10HmaX-0005vi-00
825 >>>>>>>>>>>>>>>> Exim pid=p1238 (local-accept-delivery) terminating with rc=0 >>>>>>>>>>>>>>>>
827 >>>>>>>>>>>>>>>> Exim pid=p1237 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
828 Exim version x.yz ....
829 configuration file is TESTSUITE/test-config
831 dropping to exim gid; retaining priv uid
832 search_open: pgsql "NULL"
833 search_find: file="NULL"
834 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
836 internal_search_find: file="NULL"
837 type=pgsql key="select name from them where id='ph10';" opts=NULL
838 database lookup required for select name from them where id='ph10';
839 PostgreSQL query: "select name from them where id='ph10';" opts 'NULL'
840 PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
841 creating new cache entry
842 lookup yielded: Philip Hazel
844 close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER
845 >>>>>>>>>>>>>>>> Exim pid=p1240 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
847 ******** SERVER ********
848 2017-07-30 18:51:05.712 [pppp] LOG: redirecting log output to logging collector process
849 2017-07-30 18:51:05.712 [pppp] HINT: Future log output will appear in directory "log".