Lookups: per-searchtype options framework
[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
JH
15 database lookup required for select name from them where id='ph10';
16 PostgreSQL query: select name from them where id='ph10';
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
JH
35 database lookup required for select name from them where id='xxxx';
36 PostgreSQL query: select name from them where id='xxxx';
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
JH
47 database lookup required for select name from them where id='nothing';
48 PostgreSQL query: select name from them where id='nothing';
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
JH
58 database lookup required for select id,name from them where id='nothing';
59 PostgreSQL query: select id,name from them where id='nothing';
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
JH
69 database lookup required for delete from them where id='nonexist';
70 PostgreSQL query: delete from them where id='nonexist';
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
JH
82 database lookup required for select * from them where id='quote2';
83 PostgreSQL query: select * from them where id='quote2';
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
JH
93 database lookup required for select * from them where id='newline';
94 PostgreSQL query: select * from them where id='newline';
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
JH
105 database lookup required for select * from them where id='tab';
106 PostgreSQL query: select * from them where id='tab';
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
JH
116 database lookup required for select * from them where name='''stquot';
117 PostgreSQL query: select * from them where name='''stquot';
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
JH
127 database lookup required for servers=x:localhost; select name from them where id='ph10';
128 PostgreSQL query: servers=x:localhost; select name from them where id='ph10';
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
JH
137 database lookup required for servers=localhost::1223:x; select name from them where id='ph10';
138 PostgreSQL query: servers=localhost::1223:x; select name from them where id='ph10';
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
JH
148 database lookup required for servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';
149 PostgreSQL query: servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';
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
JH
159 database lookup required for servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
160 PostgreSQL query: servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
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
JH
170 database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
171 PostgreSQL query: SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
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
JH
182 database lookup required for SELECT * FROM them WHERE id IN ('ph10', 'aaaa');
183 PostgreSQL query: SELECT * FROM them WHERE id IN ('ph10', 'aaaa');
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
JH
194 database lookup required for delete from them where id='aaaa'
195 PostgreSQL query: delete from them where id='aaaa'
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"
897024f1 236processing "accept" (TESTSUITE/test-config 25)
54c5ebb1
PH
237check domains = +local_domains
238d in "@"? no (end of list)
239d in "+local_domains"? no (end of list)
de1294ea 240accept: condition test failed in ACL "check_recipient"
897024f1 241processing "accept" (TESTSUITE/test-config 26)
54c5ebb1
PH
242check hosts = +relay_hosts
243search_open: pgsql "NULL"
244search_find: file="NULL"
67a57a5a 245 key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL
54c5ebb1
PH
246LRU list:
247internal_search_find: file="NULL"
67a57a5a 248 type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL
54c5ebb1 249database lookup required for select * from them where id='10.0.0.0'
b7670459 250PostgreSQL query: select * from them where id='10.0.0.0'
de1294ea 251PGSQL new connection: host=localhost port=1223 database=test user=CALLER
54c5ebb1
PH
252PGSQL: no data found
253lookup failed
254host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
255host in "+relay_hosts"? no (end of list)
de1294ea 256accept: condition test failed in ACL "check_recipient"
897024f1 257processing "deny" (TESTSUITE/test-config 27)
de1294ea
JH
258 message: relay not permitted
259deny: condition test succeeded in ACL "check_recipient"
260end of ACL "check_recipient": DENY
7e9fc567 261SMTP>> 550 relay not permitted
54c5ebb1
PH
262LOG: MAIN REJECT
263 H=[10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
264SMTP<< rcpt to:<c@d>
265using ACL "check_recipient"
897024f1 266processing "accept" (TESTSUITE/test-config 25)
54c5ebb1
PH
267check domains = +local_domains
268d in "@"? no (end of list)
269d in "+local_domains"? no (end of list)
de1294ea 270accept: condition test failed in ACL "check_recipient"
897024f1 271processing "accept" (TESTSUITE/test-config 26)
54c5ebb1
PH
272check hosts = +relay_hosts
273search_open: pgsql "NULL"
274 cached open
275search_find: file="NULL"
67a57a5a 276 key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL
54c5ebb1
PH
277LRU list:
278internal_search_find: file="NULL"
67a57a5a 279 type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL
54c5ebb1
PH
280cached data used for lookup of select * from them where id='10.0.0.0'
281lookup failed
282host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
283host in "+relay_hosts"? no (end of list)
de1294ea 284accept: condition test failed in ACL "check_recipient"
897024f1 285processing "deny" (TESTSUITE/test-config 27)
de1294ea
JH
286 message: relay not permitted
287deny: condition test succeeded in ACL "check_recipient"
288end of ACL "check_recipient": DENY
7e9fc567 289SMTP>> 550 relay not permitted
54c5ebb1
PH
290LOG: MAIN REJECT
291 H=[10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
292SMTP<< quit
7e9fc567 293SMTP>> 221 myhost.test.ex closing connection
54c5ebb1
PH
294LOG: smtp_connection MAIN
295 SMTP connection from [10.0.0.0] closed by QUIT
296search_tidyup called
de1294ea 297close PGSQL connection: localhost:1223/test/CALLER
81022793 298>>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
54c5ebb1
PH
299Exim version x.yz ....
300changed uid/gid: forcing real = effective
301 uid=uuuu gid=CALLER_GID pid=pppp
302configuration file is TESTSUITE/test-config
303admin user
304changed uid/gid: privilege not needed
305 uid=EXIM_UID gid=EXIM_GID pid=pppp
16282d2b
PH
306seeking password data for user "CALLER": cache not available
307getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
54c5ebb1
PH
308originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
309sender address = CALLER@myhost.test.ex
310set_process_info: pppp accepting a local non-SMTP message from <CALLER@myhost.test.ex>
de1294ea
JH
311spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
312log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
54c5ebb1
PH
313Sender: CALLER@myhost.test.ex
314Recipients:
315 CALLER
316search_tidyup called
317>>Headers received:
318
319rewrite_one_header: type=F:
320 From: CALLER_NAME <CALLER@myhost.test.ex>
321search_tidyup called
322>>Headers after rewriting and local additions:
323I Message-Id: <E10HmaX-0005vi-00@myhost.test.ex>
324F From: CALLER_NAME <CALLER@myhost.test.ex>
325 Date: Tue, 2 Mar 1999 09:44:33 +0000
326
de1294ea 327Data file name: TESTSUITE/spool//input//10HmaX-0005vi-00-D
54c5ebb1
PH
328Data file written for message 10HmaX-0005vi-00
329>>Generated Received: header line
330P Received: from CALLER by myhost.test.ex with local (Exim x.yz)
331 (envelope-from <CALLER@myhost.test.ex>)
332 id 10HmaX-0005vi-00
333 for CALLER@myhost.test.ex; Tue, 2 Mar 1999 09:44:33 +0000
ec7bc5cc 334Writing spool header file: TESTSUITE/spool//input//hdr.10HmaX-0005vi-00
df98a6ff
JH
335DSN: Write SPOOL: -dsn_envid NULL
336DSN: Write SPOOL :-dsn_ret 0
337DSN: Flags: 0x0
338DSN: **** SPOOL_OUT - address: <CALLER@myhost.test.ex> errorsto: <NULL> orcpt: <NULL> dsn_flags: 0x0
de1294ea 339Renaming spool header file: TESTSUITE/spool//input//10HmaX-0005vi-00-H
54c5ebb1
PH
340Size of headers = sss
341LOG: MAIN
342 <= CALLER@myhost.test.ex U=CALLER P=local S=sss
343created log directory TESTSUITE/spool/log
344search_tidyup called
32393657 345exec 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
346Exim version x.yz ....
347changed uid/gid: forcing real = effective
348 uid=uuuu gid=EXIM_GID pid=pppp
349configuration file is TESTSUITE/test-config
350trusted user
351admin user
4b424e0d 352dropping to exim gid; retaining priv uid
16282d2b
PH
353seeking password data for user "CALLER": cache not available
354getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
54c5ebb1
PH
355set_process_info: pppp delivering specified messages
356set_process_info: pppp delivering 10HmaX-0005vi-00
de1294ea 357Trying spool file TESTSUITE/spool//input//10HmaX-0005vi-00-D
54c5ebb1
PH
358reading spool file 10HmaX-0005vi-00-H
359user=CALLER uid=CALLER_UID gid=CALLER_GID sender=CALLER@myhost.test.ex
360sender_local=1 ident=CALLER
361Non-recipients:
362Empty Tree
363---- End of tree ----
364recipients_count=1
de1294ea 365**** SPOOL_IN - No additional fields
54c5ebb1 366body_linecount=1 message_linecount=7
df98a6ff 367DSN: set orcpt: flags: 0x0
54c5ebb1
PH
368Delivery address list:
369 CALLER@myhost.test.ex
966e829c
JH
370 locking TESTSUITE/spool/db/retry.lockfile
371 locked TESTSUITE/spool/db/retry.lockfile
372 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
373 returned from EXIM_DBOPEN: (nil)
374 ensuring TESTSUITE/spool/db/retry.lockfile is owned by exim
375 failed to open DB file TESTSUITE/spool/db/retry.lockfile: No such file or directory
54c5ebb1
PH
376no retry data available
377>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
378Considering: CALLER@myhost.test.ex
379unique = CALLER@myhost.test.ex
de6f74f2
JH
380no domain retry record
381no address retry record
54c5ebb1
PH
382CALLER@myhost.test.ex: queued for routing
383>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
384routing CALLER@myhost.test.ex
385--------> r1 router <--------
386local_part=CALLER domain=myhost.test.ex
387processing address_data
42c7f0b4
JH
388 search_open: pgsql "NULL"
389 search_find: file="NULL"
67a57a5a 390 key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
391 LRU list:
392 internal_search_find: file="NULL"
67a57a5a 393 type=pgsql key="select name from them where id='ph10'" opts=NULL
42c7f0b4
JH
394 database lookup required for select name from them where id='ph10'
395 PostgreSQL query: select name from them where id='ph10'
396 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
397 lookup yielded: Philip Hazel
54c5ebb1
PH
398calling r1 router
399r1 router called for CALLER@myhost.test.ex
400 domain = myhost.test.ex
401set transport t1
402queued for t1 transport: local_part = CALLER
403domain = myhost.test.ex
404 errors_to=NULL
405 domain_data=NULL localpart_data=NULL
406routed by r1 router
407 envelope to: CALLER@myhost.test.ex
408 transport: t1
409>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
410After routing:
411 Local deliveries:
412 CALLER@myhost.test.ex
413 Remote deliveries:
414 Failed addresses:
415 Deferred addresses:
416search_tidyup called
de1294ea 417close PGSQL connection: localhost:1223/test/CALLER
54c5ebb1
PH
418>>>>>>>>>>>>>>>> Local deliveries >>>>>>>>>>>>>>>>
419--------> CALLER@myhost.test.ex <--------
966e829c
JH
420 locking TESTSUITE/spool/db/retry.lockfile
421 locked TESTSUITE/spool/db/retry.lockfile
422 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
423 returned from EXIM_DBOPEN: (nil)
424 failed to open DB file TESTSUITE/spool/db/retry: No such file or directory
54c5ebb1
PH
425no retry data available
426search_tidyup called
427changed uid/gid: local delivery to CALLER <CALLER@myhost.test.ex> transport=t1
428 uid=CALLER_UID gid=CALLER_GID pid=pppp
429 home=NULL current=/
430set_process_info: pppp delivering 10HmaX-0005vi-00 to CALLER using t1
431appendfile transport entered
42c7f0b4
JH
432 search_open: pgsql "NULL"
433 search_find: file="NULL"
67a57a5a 434 key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
435 LRU list:
436 internal_search_find: file="NULL"
67a57a5a 437 type=pgsql key="select id from them where id='ph10'" opts=NULL
42c7f0b4
JH
438 database lookup required for select id from them where id='ph10'
439 PostgreSQL query: select id from them where id='ph10'
440 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
441 lookup yielded: ph10
54c5ebb1 442appendfile: mode=600 notify_comsat=0 quota=0 warning=0
de1294ea 443 file=TESTSUITE/test-mail/ph10 format=unix
54c5ebb1
PH
444 message_prefix=From ${if def:return_path{$return_path}{MAILER-DAEMON}} ${tod_bsdinbox}\n
445 message_suffix=\n
446 maildir_use_size_file=no
447 locking by lockfile fcntl
de1294ea
JH
448lock name: TESTSUITE/test-mail/ph10.lock
449hitch name: TESTSUITE/test-mail/ph10.lock.test.ex.dddddddd.pppppppp
54c5ebb1 450lock file created
de1294ea
JH
451mailbox TESTSUITE/test-mail/ph10 is locked
452writing to file TESTSUITE/test-mail/ph10
1b781f48 453writing data block fd=dddd size=sss timeout=0
de1294ea 454cannot use sendfile for body: spoolfile not wireformat
1b781f48
PH
455writing data block fd=dddd size=sss timeout=0
456writing data block fd=dddd size=sss timeout=0
54c5ebb1
PH
457appendfile yields 0 with errno=dd more_errno=dd
458search_tidyup called
de1294ea 459close PGSQL connection: localhost:1223/test/CALLER
54c5ebb1
PH
460journalling CALLER@myhost.test.ex
461t1 transport returned OK for CALLER@myhost.test.ex
462post-process CALLER@myhost.test.ex (0)
463CALLER@myhost.test.ex delivered
464LOG: MAIN
465 => CALLER <CALLER@myhost.test.ex> R=r1 T=t1
466>>>>>>>>>>>>>>>> deliveries are done >>>>>>>>>>>>>>>>
467changed uid/gid: post-delivery tidying
468 uid=EXIM_UID gid=EXIM_GID pid=pppp
469set_process_info: pppp tidying up after delivering 10HmaX-0005vi-00
470Processing retry items
471Succeeded addresses:
de1294ea 472 CALLER@myhost.test.ex: no retry items
54c5ebb1
PH
473Failed addresses:
474Deferred addresses:
475end of retry processing
de1294ea
JH
476DSN: processing router : r1
477DSN: processing successful delivery address: CALLER@myhost.test.ex
478DSN: Sender_address: CALLER@myhost.test.ex
df98a6ff 479DSN: orcpt: NULL flags: 0x0
de1294ea
JH
480DSN: envid: NULL ret: 0
481DSN: Final recipient: CALLER@myhost.test.ex
482DSN: Remote SMTP server supports DSN: 0
483DSN: not sending DSN success message
54c5ebb1
PH
484LOG: MAIN
485 Completed
486end delivery of 10HmaX-0005vi-00
487search_tidyup called
488search_tidyup called
81022793 489>>>>>>>>>>>>>>>> Exim pid=pppp (local-accept-delivery) terminating with rc=0 >>>>>>>>>>>>>>>>
54c5ebb1 490search_tidyup called
81022793 491>>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
54c5ebb1
PH
492Exim version x.yz ....
493configuration file is TESTSUITE/test-config
494admin user
4b424e0d 495dropping to exim gid; retaining priv uid
42c7f0b4
JH
496 search_open: pgsql "NULL"
497 search_find: file="NULL"
67a57a5a 498 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
42c7f0b4
JH
499 LRU list:
500 internal_search_find: file="NULL"
67a57a5a 501 type=pgsql key="select name from them where id='ph10';" opts=NULL
42c7f0b4
JH
502 database lookup required for select name from them where id='ph10';
503 PostgreSQL query: select name from them where id='ph10';
504 PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
505 lookup yielded: Philip Hazel
54c5ebb1 506search_tidyup called
de1294ea 507close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER
81022793 508>>>>>>>>>>>>>>>> Exim pid=pppp (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
de1294ea
JH
509
510******** SERVER ********