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 search_open: pgsql "NULL"
9 search_find: file="NULL"
10 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
12 internal_search_find: file="NULL"
13 type=pgsql key="select name from them where id='ph10';"
14 database lookup required for select name from them where id='ph10';
15 PostgreSQL query: select name from them where id='ph10';
16 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
17 lookup yielded: Philip Hazel
18 search_open: pgsql "NULL"
20 search_find: file="NULL"
21 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
23 internal_search_find: file="NULL"
24 type=pgsql key="select name from them where id='ph10';"
25 cached data used for lookup of select name from them where id='ph10';
26 lookup yielded: Philip Hazel
27 search_open: pgsql "NULL"
29 search_find: file="NULL"
30 key="select name from them where id='xxxx';" partial=-1 affix=NULL starflags=0
32 internal_search_find: file="NULL"
33 type=pgsql key="select name from them where id='xxxx';"
34 database lookup required for select name from them where id='xxxx';
35 PostgreSQL query: select name from them where id='xxxx';
36 PGSQL using cached connection for localhost:1223/test/CALLER
39 search_open: pgsql "NULL"
41 search_find: file="NULL"
42 key="select name from them where id='nothing';" partial=-1 affix=NULL starflags=0
44 internal_search_find: file="NULL"
45 type=pgsql key="select name from them where id='nothing';"
46 database lookup required for select name from them where id='nothing';
47 PostgreSQL query: select name from them where id='nothing';
48 PGSQL using cached connection for localhost:1223/test/CALLER
50 search_open: pgsql "NULL"
52 search_find: file="NULL"
53 key="select id,name from them where id='nothing';" partial=-1 affix=NULL starflags=0
55 internal_search_find: file="NULL"
56 type=pgsql key="select id,name from them where id='nothing';"
57 database lookup required for select id,name from them where id='nothing';
58 PostgreSQL query: select id,name from them where id='nothing';
59 PGSQL using cached connection for localhost:1223/test/CALLER
60 lookup yielded: id=nothing name=""
61 search_open: pgsql "NULL"
63 search_find: file="NULL"
64 key="delete from them where id='nonexist';" partial=-1 affix=NULL starflags=0
66 internal_search_find: file="NULL"
67 type=pgsql key="delete from them where id='nonexist';"
68 database lookup required for delete from them where id='nonexist';
69 PostgreSQL query: delete from them where id='nonexist';
70 PGSQL using cached connection for localhost:1223/test/CALLER
71 PGSQL: command does not return any data but was successful. Rows affected: 0
72 lookup forced cache cleanup
74 search_open: pgsql "NULL"
76 search_find: file="NULL"
77 key="select * from them where id='quote2';" partial=-1 affix=NULL starflags=0
79 internal_search_find: file="NULL"
80 type=pgsql key="select * from them where id='quote2';"
81 database lookup required for select * from them where id='quote2';
82 PostgreSQL query: select * from them where id='quote2';
83 PGSQL using cached connection for localhost:1223/test/CALLER
84 lookup yielded: name="\"stquot" id=quote2
85 search_open: pgsql "NULL"
87 search_find: file="NULL"
88 key="select * from them where id='newline';" partial=-1 affix=NULL starflags=0
90 internal_search_find: file="NULL"
91 type=pgsql key="select * from them where id='newline';"
92 database lookup required for select * from them where id='newline';
93 PostgreSQL query: select * from them where id='newline';
94 PGSQL using cached connection for localhost:1223/test/CALLER
95 lookup yielded: name="before
\r
97 search_open: pgsql "NULL"
99 search_find: file="NULL"
100 key="select * from them where id='tab';" partial=-1 affix=NULL starflags=0
102 internal_search_find: file="NULL"
103 type=pgsql key="select * from them where id='tab';"
104 database lookup required for select * from them where id='tab';
105 PostgreSQL query: select * from them where id='tab';
106 PGSQL using cached connection for localhost:1223/test/CALLER
107 lookup yielded: name="x x" id=tab
108 search_open: pgsql "NULL"
110 search_find: file="NULL"
111 key="select * from them where name='''stquot';" partial=-1 affix=NULL starflags=0
113 internal_search_find: file="NULL"
114 type=pgsql key="select * from them where name='''stquot';"
115 database lookup required for select * from them where name='''stquot';
116 PostgreSQL query: select * from them where name='''stquot';
117 PGSQL using cached connection for localhost:1223/test/CALLER
118 lookup yielded: name='stquot id=quote1
119 search_open: pgsql "NULL"
121 search_find: file="NULL"
122 key="servers=x:localhost; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
124 internal_search_find: file="NULL"
125 type=pgsql key="servers=x:localhost; select name from them where id='ph10';"
126 database lookup required for servers=x:localhost; select name from them where id='ph10';
127 PostgreSQL query: servers=x:localhost; select name from them where id='ph10';
128 lookup deferred: PostgreSQL server "x" not found in pgsql_servers
129 search_open: pgsql "NULL"
131 search_find: file="NULL"
132 key="servers=localhost::1223:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
134 internal_search_find: file="NULL"
135 type=pgsql key="servers=localhost::1223:x; select name from them where id='ph10';"
136 database lookup required for servers=localhost::1223:x; select name from them where id='ph10';
137 PostgreSQL query: servers=localhost::1223:x; select name from them where id='ph10';
138 PGSQL using cached connection for localhost:1223/test/CALLER
139 lookup yielded: Philip Hazel
140 search_open: pgsql "NULL"
142 search_find: file="NULL"
143 key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
145 internal_search_find: file="NULL"
146 type=pgsql key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';"
147 database lookup required for servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';
148 PostgreSQL query: servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';
149 PGSQL using cached connection for localhost:1223/test/CALLER
150 lookup yielded: Philip Hazel
151 search_open: pgsql "NULL"
153 search_find: file="NULL"
154 key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
156 internal_search_find: file="NULL"
157 type=pgsql key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';"
158 database lookup required for servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
159 PostgreSQL query: servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
160 PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
161 lookup yielded: Philip Hazel
162 search_open: pgsql "NULL"
164 search_find: file="NULL"
165 key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0
167 internal_search_find: file="NULL"
168 type=pgsql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');"
169 database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
170 PostgreSQL query: SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
171 PGSQL using cached connection for localhost:1223/test/CALLER
172 lookup yielded: Philip Hazel
174 search_open: pgsql "NULL"
176 search_find: file="NULL"
177 key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0
179 internal_search_find: file="NULL"
180 type=pgsql key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');"
181 database lookup required for SELECT * FROM them WHERE id IN ('ph10', 'aaaa');
182 PostgreSQL query: SELECT * FROM them WHERE id IN ('ph10', 'aaaa');
183 PGSQL using cached connection for localhost:1223/test/CALLER
184 lookup yielded: name="Philip Hazel" id=ph10
185 name=Aristotle id=aaaa
186 search_open: pgsql "NULL"
188 search_find: file="NULL"
189 key="delete from them where id='aaaa'" partial=-1 affix=NULL starflags=0
191 internal_search_find: file="NULL"
192 type=pgsql key="delete from them where id='aaaa'"
193 database lookup required for delete from them where id='aaaa'
194 PostgreSQL query: delete from them where id='aaaa'
195 PGSQL using cached connection for localhost:1223/test/CALLER
196 PGSQL: command does not return any data but was successful. Rows affected: 1
197 lookup forced cache cleanup
200 close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER
201 close PGSQL connection: localhost:1223/test/CALLER
202 >>>>>>>>>>>>>>>> Exim pid=pppp (main: expansion test) terminating with rc=0 >>>>>>>>>>>>>>>>
203 Exim version x.yz ....
204 changed uid/gid: forcing real = effective
205 uid=uuuu gid=CALLER_GID pid=pppp
206 configuration file is TESTSUITE/test-config
208 changed uid/gid: privilege not needed
209 uid=EXIM_UID gid=EXIM_GID pid=pppp
210 seeking password data for user "CALLER": cache not available
211 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
212 originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
213 sender address = CALLER@myhost.test.ex
214 sender_fullhost = [10.0.0.0]
215 sender_rcvhost = [10.0.0.0]
216 host in hosts_connection_nolog? no (option unset)
217 LOG: smtp_connection MAIN
218 SMTP connection from [10.0.0.0]
219 host in host_lookup? no (option unset)
220 set_process_info: pppp handling incoming connection from [10.0.0.0]
221 host in host_reject_connection? no (option unset)
222 host in sender_unqualified_hosts? no (option unset)
223 host in recipient_unqualified_hosts? no (option unset)
224 host in helo_verify_hosts? no (option unset)
225 host in helo_try_verify_hosts? no (option unset)
226 host in helo_accept_junk_hosts? no (option unset)
227 SMTP>> 220 myhost.test.ex ESMTP Exim x.yz Tue, 2 Mar 1999 09:44:33 +0000
228 smtp_setup_msg entered
229 SMTP<< mail from:<a@b>
230 spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
231 log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
234 using ACL "check_recipient"
236 check domains = +local_domains
237 d in "@"? no (end of list)
238 d in "+local_domains"? no (end of list)
239 accept: condition test failed in ACL "check_recipient"
241 check hosts = +relay_hosts
242 search_open: pgsql "NULL"
243 search_find: file="NULL"
244 key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0
246 internal_search_find: file="NULL"
247 type=pgsql key="select * from them where id='10.0.0.0'"
248 database lookup required for select * from them where id='10.0.0.0'
249 PostgreSQL query: select * from them where id='10.0.0.0'
250 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
253 host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
254 host in "+relay_hosts"? no (end of list)
255 accept: condition test failed in ACL "check_recipient"
257 message: relay not permitted
258 deny: condition test succeeded in ACL "check_recipient"
259 end of ACL "check_recipient": DENY
260 SMTP>> 550 relay not permitted
262 H=[10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
264 using ACL "check_recipient"
266 check domains = +local_domains
267 d in "@"? no (end of list)
268 d in "+local_domains"? no (end of list)
269 accept: condition test failed in ACL "check_recipient"
271 check hosts = +relay_hosts
272 search_open: pgsql "NULL"
274 search_find: file="NULL"
275 key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0
277 internal_search_find: file="NULL"
278 type=pgsql key="select * from them where id='10.0.0.0'"
279 cached data used for lookup of select * from them where id='10.0.0.0'
281 host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
282 host in "+relay_hosts"? no (end of list)
283 accept: condition test failed in ACL "check_recipient"
285 message: relay not permitted
286 deny: condition test succeeded in ACL "check_recipient"
287 end of ACL "check_recipient": DENY
288 SMTP>> 550 relay not permitted
290 H=[10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
292 SMTP>> 221 myhost.test.ex closing connection
293 LOG: smtp_connection MAIN
294 SMTP connection from [10.0.0.0] closed by QUIT
296 close PGSQL connection: localhost:1223/test/CALLER
297 >>>>>>>>>>>>>>>> Exim pid=pppp (main) terminating with rc=0 >>>>>>>>>>>>>>>>
298 Exim version x.yz ....
299 changed uid/gid: forcing real = effective
300 uid=uuuu gid=CALLER_GID pid=pppp
301 configuration file is TESTSUITE/test-config
303 changed uid/gid: privilege not needed
304 uid=EXIM_UID gid=EXIM_GID pid=pppp
305 seeking password data for user "CALLER": cache not available
306 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
307 originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
308 sender address = CALLER@myhost.test.ex
309 set_process_info: pppp accepting a local non-SMTP message from <CALLER@myhost.test.ex>
310 spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
311 log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
312 Sender: CALLER@myhost.test.ex
318 rewrite_one_header: type=F:
319 From: CALLER_NAME <CALLER@myhost.test.ex>
321 >>Headers after rewriting and local additions:
322 I Message-Id: <E10HmaX-0005vi-00@myhost.test.ex>
323 F From: CALLER_NAME <CALLER@myhost.test.ex>
324 Date: Tue, 2 Mar 1999 09:44:33 +0000
326 Data file name: TESTSUITE/spool//input//10HmaX-0005vi-00-D
327 Data file written for message 10HmaX-0005vi-00
328 >>Generated Received: header line
329 P Received: from CALLER by myhost.test.ex with local (Exim x.yz)
330 (envelope-from <CALLER@myhost.test.ex>)
332 for CALLER@myhost.test.ex; Tue, 2 Mar 1999 09:44:33 +0000
333 calling local_scan(); timeout=300
334 local_scan() returned 0 NULL
335 Writing spool header file: TESTSUITE/spool//input//hdr.pppp
336 DSN: Write SPOOL :-dsn_envid NULL
337 DSN: Write SPOOL :-dsn_ret 0
339 DSN: **** SPOOL_OUT - address: |CALLER@myhost.test.ex| errorsto: |NULL| orcpt: |NULL| dsn_flags: 0
340 Renaming spool header file: TESTSUITE/spool//input//10HmaX-0005vi-00-H
341 Size of headers = sss
343 <= CALLER@myhost.test.ex U=CALLER P=local S=sss
344 created log directory TESTSUITE/spool/log
346 exec TESTSUITE/eximdir/exim -DEXIM_PATH=TESTSUITE/eximdir/exim -C TESTSUITE/test-config -d=0xfbb95cfd -odi -Mc 10HmaX-0005vi-00
347 Exim version x.yz ....
348 changed uid/gid: forcing real = effective
349 uid=uuuu gid=EXIM_GID pid=pppp
350 configuration file is TESTSUITE/test-config
353 seeking password data for user "CALLER": cache not available
354 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
355 set_process_info: pppp delivering specified messages
356 set_process_info: pppp delivering 10HmaX-0005vi-00
357 Trying spool file TESTSUITE/spool//input//10HmaX-0005vi-00-D
358 reading spool file 10HmaX-0005vi-00-H
359 user=CALLER uid=CALLER_UID gid=CALLER_GID sender=CALLER@myhost.test.ex
360 sender_local=1 ident=CALLER
363 ---- End of tree ----
365 **** SPOOL_IN - No additional fields
366 body_linecount=1 message_linecount=7
367 DSN: set orcpt: flags: 0
368 Delivery address list:
369 CALLER@myhost.test.ex
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
376 no retry data available
377 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
378 Considering: CALLER@myhost.test.ex
379 unique = CALLER@myhost.test.ex
380 no domain retry record
381 no address retry record
382 CALLER@myhost.test.ex: queued for routing
383 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
384 routing CALLER@myhost.test.ex
385 --------> r1 router <--------
386 local_part=CALLER domain=myhost.test.ex
387 processing address_data
388 search_open: pgsql "NULL"
389 search_find: file="NULL"
390 key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0
392 internal_search_find: file="NULL"
393 type=pgsql key="select name from them where id='ph10'"
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
399 r1 router called for CALLER@myhost.test.ex
400 domain = myhost.test.ex
402 queued for t1 transport: local_part = CALLER
403 domain = myhost.test.ex
405 domain_data=NULL localpart_data=NULL
407 envelope to: CALLER@myhost.test.ex
409 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
412 CALLER@myhost.test.ex
417 close PGSQL connection: localhost:1223/test/CALLER
418 >>>>>>>>>>>>>>>> Local deliveries >>>>>>>>>>>>>>>>
419 --------> CALLER@myhost.test.ex <--------
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
425 no retry data available
427 changed uid/gid: local delivery to CALLER <CALLER@myhost.test.ex> transport=t1
428 uid=CALLER_UID gid=CALLER_GID pid=pppp
430 set_process_info: pppp delivering 10HmaX-0005vi-00 to CALLER using t1
431 appendfile transport entered
432 search_open: pgsql "NULL"
433 search_find: file="NULL"
434 key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0
436 internal_search_find: file="NULL"
437 type=pgsql key="select id from them where id='ph10'"
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
442 appendfile: mode=600 notify_comsat=0 quota=0 warning=0
443 file=TESTSUITE/test-mail/ph10 format=unix
444 message_prefix=From ${if def:return_path{$return_path}{MAILER-DAEMON}} ${tod_bsdinbox}\n
446 maildir_use_size_file=no
447 locking by lockfile fcntl
448 lock name: TESTSUITE/test-mail/ph10.lock
449 hitch name: TESTSUITE/test-mail/ph10.lock.test.ex.dddddddd.pppppppp
451 mailbox TESTSUITE/test-mail/ph10 is locked
452 writing to file TESTSUITE/test-mail/ph10
453 writing data block fd=dddd size=sss timeout=0
454 cannot use sendfile for body: spoolfile not wireformat
455 writing data block fd=dddd size=sss timeout=0
456 writing data block fd=dddd size=sss timeout=0
457 appendfile yields 0 with errno=dd more_errno=dd
459 close PGSQL connection: localhost:1223/test/CALLER
460 journalling CALLER@myhost.test.ex
461 t1 transport returned OK for CALLER@myhost.test.ex
462 post-process CALLER@myhost.test.ex (0)
463 CALLER@myhost.test.ex delivered
465 => CALLER <CALLER@myhost.test.ex> R=r1 T=t1
466 >>>>>>>>>>>>>>>> deliveries are done >>>>>>>>>>>>>>>>
467 changed uid/gid: post-delivery tidying
468 uid=EXIM_UID gid=EXIM_GID pid=pppp
469 set_process_info: pppp tidying up after delivering 10HmaX-0005vi-00
470 Processing retry items
472 CALLER@myhost.test.ex: no retry items
475 end of retry processing
476 DSN: processing router : r1
477 DSN: processing successful delivery address: CALLER@myhost.test.ex
478 DSN: Sender_address: CALLER@myhost.test.ex
479 DSN: orcpt: NULL flags: 0
480 DSN: envid: NULL ret: 0
481 DSN: Final recipient: CALLER@myhost.test.ex
482 DSN: Remote SMTP server supports DSN: 0
483 DSN: not sending DSN success message
486 end delivery of 10HmaX-0005vi-00
489 >>>>>>>>>>>>>>>> Exim pid=pppp (main) terminating with rc=0 >>>>>>>>>>>>>>>>
491 >>>>>>>>>>>>>>>> Exim pid=pppp (main) terminating with rc=0 >>>>>>>>>>>>>>>>
492 Exim version x.yz ....
493 configuration file is TESTSUITE/test-config
495 search_open: pgsql "NULL"
496 search_find: file="NULL"
497 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
499 internal_search_find: file="NULL"
500 type=pgsql key="select name from them where id='ph10';"
501 database lookup required for select name from them where id='ph10';
502 PostgreSQL query: select name from them where id='ph10';
503 PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
504 lookup yielded: Philip Hazel
506 close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER
507 >>>>>>>>>>>>>>>> Exim pid=pppp (main: expansion test) terminating with rc=0 >>>>>>>>>>>>>>>>
509 ******** SERVER ********