readsocket expansion: response caching
[exim.git] / test / stderr / 2620
CommitLineData
de1294ea
JH
1
2WARNING: enabling "trust" authentication for local connections
3You 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.
54c5ebb1
PH
5Exim version x.yz ....
6configuration file is TESTSUITE/test-config
7admin user
4b424e0d 8dropping to exim gid; retaining priv uid
42c7f0b4
JH
9 search_open: pgsql "NULL"
10 search_find: file="NULL"
67a57a5a 11 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
12 LRU list:
13 internal_search_find: file="NULL"
67a57a5a 14 type=pgsql key="select name from them where id='ph10';" opts=NULL
42c7f0b4 15 database lookup required for select name from them where id='ph10';
0b4dfe7a 16 PostgreSQL query: "select name from them where id='ph10';" opts 'NULL'
42c7f0b4
JH
17 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
18 lookup yielded: Philip Hazel
19 search_open: pgsql "NULL"
20 cached open
21 search_find: file="NULL"
67a57a5a 22 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
23 LRU list:
24 internal_search_find: file="NULL"
67a57a5a 25 type=pgsql key="select name from them where id='ph10';" opts=NULL
42c7f0b4
JH
26 cached data used for lookup of select name from them where id='ph10';
27 lookup yielded: Philip Hazel
28 search_open: pgsql "NULL"
29 cached open
30 search_find: file="NULL"
67a57a5a 31 key="select name from them where id='xxxx';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
32 LRU list:
33 internal_search_find: file="NULL"
67a57a5a 34 type=pgsql key="select name from them where id='xxxx';" opts=NULL
42c7f0b4 35 database lookup required for select name from them where id='xxxx';
0b4dfe7a 36 PostgreSQL query: "select name from them where id='xxxx';" opts 'NULL'
42c7f0b4
JH
37 PGSQL using cached connection for localhost:1223/test/CALLER
38 PGSQL: no data found
39 lookup failed
40 search_open: pgsql "NULL"
41 cached open
42 search_find: file="NULL"
67a57a5a 43 key="select name from them where id='nothing';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
44 LRU list:
45 internal_search_find: file="NULL"
67a57a5a 46 type=pgsql key="select name from them where id='nothing';" opts=NULL
42c7f0b4 47 database lookup required for select name from them where id='nothing';
0b4dfe7a 48 PostgreSQL query: "select name from them where id='nothing';" opts 'NULL'
42c7f0b4
JH
49 PGSQL using cached connection for localhost:1223/test/CALLER
50 lookup yielded:
51 search_open: pgsql "NULL"
52 cached open
53 search_find: file="NULL"
67a57a5a 54 key="select id,name from them where id='nothing';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
55 LRU list:
56 internal_search_find: file="NULL"
67a57a5a 57 type=pgsql key="select id,name from them where id='nothing';" opts=NULL
42c7f0b4 58 database lookup required for select id,name from them where id='nothing';
0b4dfe7a 59 PostgreSQL query: "select id,name from them where id='nothing';" opts 'NULL'
42c7f0b4
JH
60 PGSQL using cached connection for localhost:1223/test/CALLER
61 lookup yielded: id=nothing name=""
62 search_open: pgsql "NULL"
63 cached open
64 search_find: file="NULL"
67a57a5a 65 key="delete from them where id='nonexist';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
66 LRU list:
67 internal_search_find: file="NULL"
67a57a5a 68 type=pgsql key="delete from them where id='nonexist';" opts=NULL
42c7f0b4 69 database lookup required for delete from them where id='nonexist';
0b4dfe7a 70 PostgreSQL query: "delete from them where id='nonexist';" opts 'NULL'
42c7f0b4
JH
71 PGSQL using cached connection for localhost:1223/test/CALLER
72 PGSQL: command does not return any data but was successful. Rows affected: 0
73 lookup forced cache cleanup
74 lookup yielded: 0
75 search_open: pgsql "NULL"
76 cached open
77 search_find: file="NULL"
67a57a5a 78 key="select * from them where id='quote2';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
79 LRU list:
80 internal_search_find: file="NULL"
67a57a5a 81 type=pgsql key="select * from them where id='quote2';" opts=NULL
42c7f0b4 82 database lookup required for select * from them where id='quote2';
0b4dfe7a 83 PostgreSQL query: "select * from them where id='quote2';" opts 'NULL'
42c7f0b4
JH
84 PGSQL using cached connection for localhost:1223/test/CALLER
85 lookup yielded: name="\"stquot" id=quote2
86 search_open: pgsql "NULL"
87 cached open
88 search_find: file="NULL"
67a57a5a 89 key="select * from them where id='newline';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
90 LRU list:
91 internal_search_find: file="NULL"
67a57a5a 92 type=pgsql key="select * from them where id='newline';" opts=NULL
42c7f0b4 93 database lookup required for select * from them where id='newline';
0b4dfe7a 94 PostgreSQL query: "select * from them where id='newline';" opts 'NULL'
42c7f0b4
JH
95 PGSQL using cached connection for localhost:1223/test/CALLER
96 lookup yielded: name="before\r
97 after" id=newline
98 search_open: pgsql "NULL"
99 cached open
100 search_find: file="NULL"
67a57a5a 101 key="select * from them where id='tab';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
102 LRU list:
103 internal_search_find: file="NULL"
67a57a5a 104 type=pgsql key="select * from them where id='tab';" opts=NULL
42c7f0b4 105 database lookup required for select * from them where id='tab';
0b4dfe7a 106 PostgreSQL query: "select * from them where id='tab';" opts 'NULL'
42c7f0b4
JH
107 PGSQL using cached connection for localhost:1223/test/CALLER
108 lookup yielded: name="x x" id=tab
109 search_open: pgsql "NULL"
110 cached open
111 search_find: file="NULL"
67a57a5a 112 key="select * from them where name='''stquot';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
113 LRU list:
114 internal_search_find: file="NULL"
67a57a5a 115 type=pgsql key="select * from them where name='''stquot';" opts=NULL
42c7f0b4 116 database lookup required for select * from them where name='''stquot';
0b4dfe7a 117 PostgreSQL query: "select * from them where name='''stquot';" opts 'NULL'
42c7f0b4
JH
118 PGSQL using cached connection for localhost:1223/test/CALLER
119 lookup yielded: name='stquot id=quote1
120 search_open: pgsql "NULL"
121 cached open
122 search_find: file="NULL"
67a57a5a 123 key="servers=x:localhost; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
124 LRU list:
125 internal_search_find: file="NULL"
67a57a5a 126 type=pgsql key="servers=x:localhost; select name from them where id='ph10';" opts=NULL
42c7f0b4 127 database lookup required for servers=x:localhost; select name from them where id='ph10';
0b4dfe7a 128 PostgreSQL query: "servers=x:localhost; select name from them where id='ph10';" opts 'NULL'
42c7f0b4
JH
129 lookup deferred: PostgreSQL server "x" not found in pgsql_servers
130 search_open: pgsql "NULL"
131 cached open
132 search_find: file="NULL"
67a57a5a 133 key="servers=localhost::1223:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
134 LRU list:
135 internal_search_find: file="NULL"
67a57a5a 136 type=pgsql key="servers=localhost::1223:x; select name from them where id='ph10';" opts=NULL
42c7f0b4 137 database lookup required for servers=localhost::1223:x; select name from them where id='ph10';
0b4dfe7a 138 PostgreSQL query: "servers=localhost::1223:x; select name from them where id='ph10';" opts 'NULL'
42c7f0b4
JH
139 PGSQL using cached connection for localhost:1223/test/CALLER
140 lookup yielded: Philip Hazel
141 search_open: pgsql "NULL"
142 cached open
143 search_find: file="NULL"
67a57a5a 144 key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
145 LRU list:
146 internal_search_find: file="NULL"
67a57a5a 147 type=pgsql key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" opts=NULL
42c7f0b4 148 database lookup required for servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';
0b4dfe7a 149 PostgreSQL query: "servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" opts 'NULL'
42c7f0b4
JH
150 PGSQL using cached connection for localhost:1223/test/CALLER
151 lookup yielded: Philip Hazel
152 search_open: pgsql "NULL"
153 cached open
154 search_find: file="NULL"
67a57a5a 155 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
42c7f0b4
JH
156 LRU list:
157 internal_search_find: file="NULL"
67a57a5a 158 type=pgsql key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" opts=NULL
42c7f0b4 159 database lookup required for servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
0b4dfe7a 160 PostgreSQL query: "servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" opts 'NULL'
42c7f0b4
JH
161 PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
162 lookup yielded: Philip Hazel
163 search_open: pgsql "NULL"
164 cached open
165 search_find: file="NULL"
67a57a5a 166 key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
167 LRU list:
168 internal_search_find: file="NULL"
67a57a5a 169 type=pgsql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL
42c7f0b4 170 database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
0b4dfe7a 171 PostgreSQL query: "SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" opts 'NULL'
42c7f0b4
JH
172 PGSQL using cached connection for localhost:1223/test/CALLER
173 lookup yielded: Philip Hazel
174 Aristotle
175 search_open: pgsql "NULL"
176 cached open
177 search_find: file="NULL"
67a57a5a 178 key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
179 LRU list:
180 internal_search_find: file="NULL"
67a57a5a 181 type=pgsql key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL
42c7f0b4 182 database lookup required for SELECT * FROM them WHERE id IN ('ph10', 'aaaa');
0b4dfe7a 183 PostgreSQL query: "SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" opts 'NULL'
42c7f0b4
JH
184 PGSQL using cached connection for localhost:1223/test/CALLER
185 lookup yielded: name="Philip Hazel" id=ph10
186 name=Aristotle id=aaaa
187 search_open: pgsql "NULL"
188 cached open
189 search_find: file="NULL"
67a57a5a 190 key="delete from them where id='aaaa'" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
191 LRU list:
192 internal_search_find: file="NULL"
67a57a5a 193 type=pgsql key="delete from them where id='aaaa'" opts=NULL
42c7f0b4 194 database lookup required for delete from them where id='aaaa'
0b4dfe7a 195 PostgreSQL query: "delete from them where id='aaaa'" opts 'NULL'
42c7f0b4
JH
196 PGSQL using cached connection for localhost:1223/test/CALLER
197 PGSQL: command does not return any data but was successful. Rows affected: 1
198 lookup forced cache cleanup
199 lookup yielded: 1
54c5ebb1 200search_tidyup called
de1294ea
JH
201close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER
202close PGSQL connection: localhost:1223/test/CALLER
81022793 203>>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
54c5ebb1
PH
204Exim version x.yz ....
205changed uid/gid: forcing real = effective
206 uid=uuuu gid=CALLER_GID pid=pppp
207configuration file is TESTSUITE/test-config
208admin user
209changed uid/gid: privilege not needed
210 uid=EXIM_UID gid=EXIM_GID pid=pppp
16282d2b
PH
211seeking password data for user "CALLER": cache not available
212getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
54c5ebb1
PH
213originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
214sender address = CALLER@myhost.test.ex
215sender_fullhost = [10.0.0.0]
216sender_rcvhost = [10.0.0.0]
217host in hosts_connection_nolog? no (option unset)
218LOG: smtp_connection MAIN
219 SMTP connection from [10.0.0.0]
220host in host_lookup? no (option unset)
221set_process_info: pppp handling incoming connection from [10.0.0.0]
222host in host_reject_connection? no (option unset)
223host in sender_unqualified_hosts? no (option unset)
224host in recipient_unqualified_hosts? no (option unset)
225host in helo_verify_hosts? no (option unset)
226host in helo_try_verify_hosts? no (option unset)
227host in helo_accept_junk_hosts? no (option unset)
7e9fc567 228SMTP>> 220 myhost.test.ex ESMTP Exim x.yz Tue, 2 Mar 1999 09:44:33 +0000
54c5ebb1
PH
229smtp_setup_msg entered
230SMTP<< mail from:<a@b>
de1294ea
JH
231spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
232log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
7e9fc567 233SMTP>> 250 OK
54c5ebb1
PH
234SMTP<< rcpt to:<c@d>
235using ACL "check_recipient"
0b4dfe7a
JH
236processing "warn" (TESTSUITE/test-config 27)
237 search_open: pgsql "NULL"
238 search_find: file="NULL"
239 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL
240 LRU list:
241 internal_search_find: file="NULL"
242 type=pgsql key="select name from them where id = 'c'" opts=NULL
243 database lookup required for select name from them where id = 'c'
244 PostgreSQL query: "select name from them where id = 'c'" opts 'NULL'
245 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
246 PGSQL: no data found
247 lookup failed
248check set acl_m0 = ok: ${lookup pgsql {select name from them where id = '$local_part'}}
249 = ok:
250 search_open: pgsql "NULL"
251 cached open
252 search_find: file="NULL"
253 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=SSPEC"
254 LRU list:
255 internal_search_find: file="NULL"
256 type=pgsql key="select name from them where id = 'c'" opts="servers=SSPEC"
1950cf85 257 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
0b4dfe7a
JH
258 PostgreSQL query: "select name from them where id = 'c'" opts 'servers=SSPEC'
259 lookup deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
260warn: condition test deferred in ACL "check_recipient"
261LOG: MAIN
262 H=[10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
263processing "warn" (TESTSUITE/test-config 38)
264check set acl_m0 = ok: hostlist
265check hosts = net-pgsql;select * from them where id='$local_part'
266search_open: pgsql "NULL"
267 cached open
268search_find: file="NULL"
269 key="select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
270LRU list:
271internal_search_find: file="NULL"
272 type=pgsql key="select * from them where id='c'" opts=NULL
273database lookup required for select * from them where id='c'
274PostgreSQL query: "select * from them where id='c'" opts 'NULL'
275PGSQL using cached connection for localhost:1223/test/CALLER
276PGSQL: no data found
277lookup failed
278host in "net-pgsql;select * from them where id='c'"? no (end of list)
279warn: condition test failed in ACL "check_recipient"
280processing "warn" (TESTSUITE/test-config 41)
281check set acl_m0 = FAIL: hostlist
282check hosts = <& net-pgsql;servers=SSPEC; select * from them where id='$local_part'
283search_open: pgsql "NULL"
284 cached open
285search_find: file="NULL"
286 key="servers=SSPEC; select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
287LRU list:
288internal_search_find: file="NULL"
289 type=pgsql key="servers=SSPEC; select * from them where id='c'" opts=NULL
290database lookup required for servers=SSPEC; select * from them where id='c'
291PostgreSQL query: "servers=SSPEC; select * from them where id='c'" opts 'NULL'
292lookup deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
293host in "<& net-pgsql;servers=SSPEC; select * from them where id='c'"? list match deferred for net-pgsql;servers=SSPEC; select * from them where id='c'
294warn: condition test deferred in ACL "check_recipient"
295LOG: MAIN
296 H=[10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
297processing "warn" (TESTSUITE/test-config 46)
298check set acl_m0 = FAIL: hostlist
299check hosts = <& net-pgsql,servers=SSPEC; select * from them where id='$local_part'
300search_open: pgsql "NULL"
301 cached open
302search_find: file="NULL"
303 key=" select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts="servers=SSPEC"
304LRU list:
305internal_search_find: file="NULL"
306 type=pgsql key=" select * from them where id='c'" opts="servers=SSPEC"
307database lookup required for select * from them where id='c'
308PostgreSQL query: " select * from them where id='c'" opts 'servers=SSPEC'
309lookup deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
310host in "<& net-pgsql,servers=SSPEC; select * from them where id='c'"? list match deferred for net-pgsql,servers=SSPEC; select * from them where id='c'
311warn: condition test deferred in ACL "check_recipient"
312LOG: MAIN
313 H=[10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
314processing "accept" (TESTSUITE/test-config 49)
54c5ebb1
PH
315check domains = +local_domains
316d in "@"? no (end of list)
317d in "+local_domains"? no (end of list)
de1294ea 318accept: condition test failed in ACL "check_recipient"
0b4dfe7a 319processing "accept" (TESTSUITE/test-config 50)
54c5ebb1
PH
320check hosts = +relay_hosts
321search_open: pgsql "NULL"
0b4dfe7a 322 cached open
54c5ebb1 323search_find: file="NULL"
67a57a5a 324 key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL
54c5ebb1
PH
325LRU list:
326internal_search_find: file="NULL"
67a57a5a 327 type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL
54c5ebb1 328database lookup required for select * from them where id='10.0.0.0'
0b4dfe7a
JH
329PostgreSQL query: "select * from them where id='10.0.0.0'" opts 'NULL'
330PGSQL using cached connection for localhost:1223/test/CALLER
54c5ebb1
PH
331PGSQL: no data found
332lookup failed
333host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
334host in "+relay_hosts"? no (end of list)
de1294ea 335accept: condition test failed in ACL "check_recipient"
0b4dfe7a 336processing "deny" (TESTSUITE/test-config 51)
de1294ea
JH
337 message: relay not permitted
338deny: condition test succeeded in ACL "check_recipient"
339end of ACL "check_recipient": DENY
7e9fc567 340SMTP>> 550 relay not permitted
54c5ebb1
PH
341LOG: MAIN REJECT
342 H=[10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
343SMTP<< rcpt to:<c@d>
344using ACL "check_recipient"
0b4dfe7a
JH
345processing "warn" (TESTSUITE/test-config 27)
346 search_open: pgsql "NULL"
347 cached open
348 search_find: file="NULL"
349 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL
350 LRU list:
351 internal_search_find: file="NULL"
352 type=pgsql key="select name from them where id = 'c'" opts=NULL
353 cached data used for lookup of select name from them where id = 'c'
354 lookup failed
355check set acl_m0 = ok: ${lookup pgsql {select name from them where id = '$local_part'}}
356 = ok:
357 search_open: pgsql "NULL"
358 cached open
359 search_find: file="NULL"
360 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=SSPEC"
361 LRU list:
362 internal_search_find: file="NULL"
363 type=pgsql key="select name from them where id = 'c'" opts="servers=SSPEC"
1950cf85 364 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
0b4dfe7a
JH
365 PostgreSQL query: "select name from them where id = 'c'" opts 'servers=SSPEC'
366 lookup deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
367warn: condition test deferred in ACL "check_recipient"
368LOG: MAIN
369 H=[10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
370processing "warn" (TESTSUITE/test-config 38)
371check set acl_m0 = ok: hostlist
372check hosts = net-pgsql;select * from them where id='$local_part'
373search_open: pgsql "NULL"
374 cached open
375search_find: file="NULL"
376 key="select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
377LRU list:
378internal_search_find: file="NULL"
379 type=pgsql key="select * from them where id='c'" opts=NULL
380cached data used for lookup of select * from them where id='c'
381lookup failed
382host in "net-pgsql;select * from them where id='c'"? no (end of list)
383warn: condition test failed in ACL "check_recipient"
384processing "warn" (TESTSUITE/test-config 41)
385check set acl_m0 = FAIL: hostlist
386check hosts = <& net-pgsql;servers=SSPEC; select * from them where id='$local_part'
387search_open: pgsql "NULL"
388 cached open
389search_find: file="NULL"
390 key="servers=SSPEC; select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
391LRU list:
392internal_search_find: file="NULL"
393 type=pgsql key="servers=SSPEC; select * from them where id='c'" opts=NULL
394database lookup required for servers=SSPEC; select * from them where id='c'
395PostgreSQL query: "servers=SSPEC; select * from them where id='c'" opts 'NULL'
396lookup deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
397host in "<& net-pgsql;servers=SSPEC; select * from them where id='c'"? list match deferred for net-pgsql;servers=SSPEC; select * from them where id='c'
398warn: condition test deferred in ACL "check_recipient"
399LOG: MAIN
400 H=[10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
401processing "warn" (TESTSUITE/test-config 46)
402check set acl_m0 = FAIL: hostlist
403check hosts = <& net-pgsql,servers=SSPEC; select * from them where id='$local_part'
404search_open: pgsql "NULL"
405 cached open
406search_find: file="NULL"
407 key=" select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts="servers=SSPEC"
408LRU list:
409internal_search_find: file="NULL"
410 type=pgsql key=" select * from them where id='c'" opts="servers=SSPEC"
411database lookup required for select * from them where id='c'
412PostgreSQL query: " select * from them where id='c'" opts 'servers=SSPEC'
413lookup deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
414host in "<& net-pgsql,servers=SSPEC; select * from them where id='c'"? list match deferred for net-pgsql,servers=SSPEC; select * from them where id='c'
415warn: condition test deferred in ACL "check_recipient"
416LOG: MAIN
417 H=[10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: PostgreSQL server "SSPEC" not found in pgsql_servers
418processing "accept" (TESTSUITE/test-config 49)
54c5ebb1
PH
419check domains = +local_domains
420d in "@"? no (end of list)
421d in "+local_domains"? no (end of list)
de1294ea 422accept: condition test failed in ACL "check_recipient"
0b4dfe7a 423processing "accept" (TESTSUITE/test-config 50)
54c5ebb1
PH
424check hosts = +relay_hosts
425search_open: pgsql "NULL"
426 cached open
427search_find: file="NULL"
67a57a5a 428 key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL
54c5ebb1
PH
429LRU list:
430internal_search_find: file="NULL"
67a57a5a 431 type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL
54c5ebb1
PH
432cached data used for lookup of select * from them where id='10.0.0.0'
433lookup failed
434host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
435host in "+relay_hosts"? no (end of list)
de1294ea 436accept: condition test failed in ACL "check_recipient"
0b4dfe7a 437processing "deny" (TESTSUITE/test-config 51)
de1294ea
JH
438 message: relay not permitted
439deny: condition test succeeded in ACL "check_recipient"
440end of ACL "check_recipient": DENY
7e9fc567 441SMTP>> 550 relay not permitted
54c5ebb1
PH
442LOG: MAIN REJECT
443 H=[10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
444SMTP<< quit
7e9fc567 445SMTP>> 221 myhost.test.ex closing connection
54c5ebb1
PH
446LOG: smtp_connection MAIN
447 SMTP connection from [10.0.0.0] closed by QUIT
448search_tidyup called
de1294ea 449close PGSQL connection: localhost:1223/test/CALLER
81022793 450>>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
54c5ebb1
PH
451Exim version x.yz ....
452changed uid/gid: forcing real = effective
453 uid=uuuu gid=CALLER_GID pid=pppp
454configuration file is TESTSUITE/test-config
455admin user
456changed uid/gid: privilege not needed
457 uid=EXIM_UID gid=EXIM_GID pid=pppp
16282d2b
PH
458seeking password data for user "CALLER": cache not available
459getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
54c5ebb1
PH
460originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
461sender address = CALLER@myhost.test.ex
462set_process_info: pppp accepting a local non-SMTP message from <CALLER@myhost.test.ex>
de1294ea
JH
463spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
464log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
54c5ebb1
PH
465Sender: CALLER@myhost.test.ex
466Recipients:
467 CALLER
468search_tidyup called
469>>Headers received:
470
471rewrite_one_header: type=F:
472 From: CALLER_NAME <CALLER@myhost.test.ex>
473search_tidyup called
474>>Headers after rewriting and local additions:
475I Message-Id: <E10HmaX-0005vi-00@myhost.test.ex>
476F From: CALLER_NAME <CALLER@myhost.test.ex>
477 Date: Tue, 2 Mar 1999 09:44:33 +0000
478
de1294ea 479Data file name: TESTSUITE/spool//input//10HmaX-0005vi-00-D
54c5ebb1
PH
480Data file written for message 10HmaX-0005vi-00
481>>Generated Received: header line
482P Received: from CALLER by myhost.test.ex with local (Exim x.yz)
483 (envelope-from <CALLER@myhost.test.ex>)
484 id 10HmaX-0005vi-00
485 for CALLER@myhost.test.ex; Tue, 2 Mar 1999 09:44:33 +0000
ec7bc5cc 486Writing spool header file: TESTSUITE/spool//input//hdr.10HmaX-0005vi-00
df98a6ff
JH
487DSN: Write SPOOL: -dsn_envid NULL
488DSN: Write SPOOL :-dsn_ret 0
489DSN: Flags: 0x0
490DSN: **** SPOOL_OUT - address: <CALLER@myhost.test.ex> errorsto: <NULL> orcpt: <NULL> dsn_flags: 0x0
de1294ea 491Renaming spool header file: TESTSUITE/spool//input//10HmaX-0005vi-00-H
54c5ebb1
PH
492Size of headers = sss
493LOG: MAIN
494 <= CALLER@myhost.test.ex U=CALLER P=local S=sss
495created log directory TESTSUITE/spool/log
496search_tidyup called
32393657 497exec TESTSUITE/eximdir/exim -DEXIM_PATH=TESTSUITE/eximdir/exim -C TESTSUITE/test-config -d=0xf7715cfd -MCd local-accept-delivery -odi -Mc 10HmaX-0005vi-00
54c5ebb1
PH
498Exim version x.yz ....
499changed uid/gid: forcing real = effective
500 uid=uuuu gid=EXIM_GID pid=pppp
501configuration file is TESTSUITE/test-config
502trusted user
503admin user
4b424e0d 504dropping to exim gid; retaining priv uid
16282d2b
PH
505seeking password data for user "CALLER": cache not available
506getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
54c5ebb1
PH
507set_process_info: pppp delivering specified messages
508set_process_info: pppp delivering 10HmaX-0005vi-00
de1294ea 509Trying spool file TESTSUITE/spool//input//10HmaX-0005vi-00-D
54c5ebb1
PH
510reading spool file 10HmaX-0005vi-00-H
511user=CALLER uid=CALLER_UID gid=CALLER_GID sender=CALLER@myhost.test.ex
512sender_local=1 ident=CALLER
513Non-recipients:
514Empty Tree
515---- End of tree ----
516recipients_count=1
de1294ea 517**** SPOOL_IN - No additional fields
54c5ebb1 518body_linecount=1 message_linecount=7
df98a6ff 519DSN: set orcpt: flags: 0x0
54c5ebb1
PH
520Delivery address list:
521 CALLER@myhost.test.ex
966e829c
JH
522 locking TESTSUITE/spool/db/retry.lockfile
523 locked TESTSUITE/spool/db/retry.lockfile
524 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
525 returned from EXIM_DBOPEN: (nil)
526 ensuring TESTSUITE/spool/db/retry.lockfile is owned by exim
527 failed to open DB file TESTSUITE/spool/db/retry.lockfile: No such file or directory
54c5ebb1
PH
528no retry data available
529>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
530Considering: CALLER@myhost.test.ex
531unique = CALLER@myhost.test.ex
de6f74f2
JH
532no domain retry record
533no address retry record
54c5ebb1
PH
534CALLER@myhost.test.ex: queued for routing
535>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
536routing CALLER@myhost.test.ex
537--------> r1 router <--------
538local_part=CALLER domain=myhost.test.ex
539processing address_data
42c7f0b4
JH
540 search_open: pgsql "NULL"
541 search_find: file="NULL"
67a57a5a 542 key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
543 LRU list:
544 internal_search_find: file="NULL"
67a57a5a 545 type=pgsql key="select name from them where id='ph10'" opts=NULL
42c7f0b4 546 database lookup required for select name from them where id='ph10'
0b4dfe7a 547 PostgreSQL query: "select name from them where id='ph10'" opts 'NULL'
42c7f0b4
JH
548 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
549 lookup yielded: Philip Hazel
54c5ebb1
PH
550calling r1 router
551r1 router called for CALLER@myhost.test.ex
552 domain = myhost.test.ex
553set transport t1
554queued for t1 transport: local_part = CALLER
555domain = myhost.test.ex
556 errors_to=NULL
557 domain_data=NULL localpart_data=NULL
558routed by r1 router
559 envelope to: CALLER@myhost.test.ex
560 transport: t1
561>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
562After routing:
563 Local deliveries:
564 CALLER@myhost.test.ex
565 Remote deliveries:
566 Failed addresses:
567 Deferred addresses:
568search_tidyup called
de1294ea 569close PGSQL connection: localhost:1223/test/CALLER
54c5ebb1
PH
570>>>>>>>>>>>>>>>> Local deliveries >>>>>>>>>>>>>>>>
571--------> CALLER@myhost.test.ex <--------
966e829c
JH
572 locking TESTSUITE/spool/db/retry.lockfile
573 locked TESTSUITE/spool/db/retry.lockfile
574 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
575 returned from EXIM_DBOPEN: (nil)
576 failed to open DB file TESTSUITE/spool/db/retry: No such file or directory
54c5ebb1
PH
577no retry data available
578search_tidyup called
579changed uid/gid: local delivery to CALLER <CALLER@myhost.test.ex> transport=t1
580 uid=CALLER_UID gid=CALLER_GID pid=pppp
581 home=NULL current=/
582set_process_info: pppp delivering 10HmaX-0005vi-00 to CALLER using t1
583appendfile transport entered
42c7f0b4
JH
584 search_open: pgsql "NULL"
585 search_find: file="NULL"
67a57a5a 586 key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
587 LRU list:
588 internal_search_find: file="NULL"
67a57a5a 589 type=pgsql key="select id from them where id='ph10'" opts=NULL
42c7f0b4 590 database lookup required for select id from them where id='ph10'
0b4dfe7a 591 PostgreSQL query: "select id from them where id='ph10'" opts 'NULL'
42c7f0b4
JH
592 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
593 lookup yielded: ph10
54c5ebb1 594appendfile: mode=600 notify_comsat=0 quota=0 warning=0
de1294ea 595 file=TESTSUITE/test-mail/ph10 format=unix
54c5ebb1
PH
596 message_prefix=From ${if def:return_path{$return_path}{MAILER-DAEMON}} ${tod_bsdinbox}\n
597 message_suffix=\n
598 maildir_use_size_file=no
599 locking by lockfile fcntl
de1294ea
JH
600lock name: TESTSUITE/test-mail/ph10.lock
601hitch name: TESTSUITE/test-mail/ph10.lock.test.ex.dddddddd.pppppppp
54c5ebb1 602lock file created
de1294ea
JH
603mailbox TESTSUITE/test-mail/ph10 is locked
604writing to file TESTSUITE/test-mail/ph10
1b781f48 605writing data block fd=dddd size=sss timeout=0
de1294ea 606cannot use sendfile for body: spoolfile not wireformat
1b781f48
PH
607writing data block fd=dddd size=sss timeout=0
608writing data block fd=dddd size=sss timeout=0
54c5ebb1
PH
609appendfile yields 0 with errno=dd more_errno=dd
610search_tidyup called
de1294ea 611close PGSQL connection: localhost:1223/test/CALLER
54c5ebb1
PH
612journalling CALLER@myhost.test.ex
613t1 transport returned OK for CALLER@myhost.test.ex
614post-process CALLER@myhost.test.ex (0)
615CALLER@myhost.test.ex delivered
616LOG: MAIN
617 => CALLER <CALLER@myhost.test.ex> R=r1 T=t1
618>>>>>>>>>>>>>>>> deliveries are done >>>>>>>>>>>>>>>>
619changed uid/gid: post-delivery tidying
620 uid=EXIM_UID gid=EXIM_GID pid=pppp
621set_process_info: pppp tidying up after delivering 10HmaX-0005vi-00
622Processing retry items
623Succeeded addresses:
de1294ea 624 CALLER@myhost.test.ex: no retry items
54c5ebb1
PH
625Failed addresses:
626Deferred addresses:
627end of retry processing
de1294ea
JH
628DSN: processing router : r1
629DSN: processing successful delivery address: CALLER@myhost.test.ex
630DSN: Sender_address: CALLER@myhost.test.ex
df98a6ff 631DSN: orcpt: NULL flags: 0x0
de1294ea
JH
632DSN: envid: NULL ret: 0
633DSN: Final recipient: CALLER@myhost.test.ex
634DSN: Remote SMTP server supports DSN: 0
635DSN: not sending DSN success message
54c5ebb1
PH
636LOG: MAIN
637 Completed
638end delivery of 10HmaX-0005vi-00
639search_tidyup called
640search_tidyup called
81022793 641>>>>>>>>>>>>>>>> Exim pid=pppp (local-accept-delivery) terminating with rc=0 >>>>>>>>>>>>>>>>
54c5ebb1 642search_tidyup called
81022793 643>>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
54c5ebb1
PH
644Exim version x.yz ....
645configuration file is TESTSUITE/test-config
646admin user
4b424e0d 647dropping to exim gid; retaining priv uid
42c7f0b4
JH
648 search_open: pgsql "NULL"
649 search_find: file="NULL"
67a57a5a 650 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
651 LRU list:
652 internal_search_find: file="NULL"
67a57a5a 653 type=pgsql key="select name from them where id='ph10';" opts=NULL
42c7f0b4 654 database lookup required for select name from them where id='ph10';
0b4dfe7a 655 PostgreSQL query: "select name from them where id='ph10';" opts 'NULL'
42c7f0b4
JH
656 PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
657 lookup yielded: Philip Hazel
54c5ebb1 658search_tidyup called
de1294ea 659close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER
81022793 660>>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
de1294ea
JH
661
662******** SERVER ********