2 ### wait for db startup, set password on the root user
3 ### create testdb and extra users
5 configuration file is TESTSUITE/test-config
7 dropping to exim gid; retaining priv uid
8 search_open: mysql "NULL"
9 search_find: file="NULL"
10 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
12 internal_search_find: file="NULL"
13 type=mysql key="select name from them where id='ph10';" opts=NULL
14 database lookup required for select name from them where id='ph10';
15 MySQL query: "select name from them where id='ph10';" opts 'NULL'
16 MYSQL new connection: host=127.0.0.1 port=PORT_N socket=NULL database=test user=root
17 creating new cache entry
18 lookup yielded: Philip Hazel
19 search_open: mysql "NULL"
21 search_find: file="NULL"
22 key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
24 internal_search_find: file="NULL"
25 type=mysql key="select name from them where id='ph10';" opts=NULL
26 cached data used for lookup of select name from them where id='ph10';
27 lookup yielded: Philip Hazel
28 search_open: mysql "NULL"
30 search_find: file="NULL"
31 key="select name from them where id='xxxx';" partial=-1 affix=NULL starflags=0 opts=NULL
33 internal_search_find: file="NULL"
34 type=mysql key="select name from them where id='xxxx';" opts=NULL
35 database lookup required for select name from them where id='xxxx';
36 MySQL query: "select name from them where id='xxxx';" opts 'NULL'
37 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
39 creating new cache entry
41 search_open: mysql "NULL"
43 search_find: file="NULL"
44 key="select name from them where id='nothing';" partial=-1 affix=NULL starflags=0 opts=NULL
46 internal_search_find: file="NULL"
47 type=mysql key="select name from them where id='nothing';" opts=NULL
48 database lookup required for select name from them where id='nothing';
49 MySQL query: "select name from them where id='nothing';" opts 'NULL'
50 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
51 creating new cache entry
53 search_open: mysql "NULL"
55 search_find: file="NULL"
56 key="select id,name from them where id='nothing';" partial=-1 affix=NULL starflags=0 opts=NULL
58 internal_search_find: file="NULL"
59 type=mysql key="select id,name from them where id='nothing';" opts=NULL
60 database lookup required for select id,name from them where id='nothing';
61 MySQL query: "select id,name from them where id='nothing';" opts 'NULL'
62 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
63 creating new cache entry
64 lookup yielded: id=nothing name=""
65 search_open: mysql "NULL"
67 search_find: file="NULL"
68 key="delete from them where id='nonexist';" partial=-1 affix=NULL starflags=0 opts=NULL
70 internal_search_find: file="NULL"
71 type=mysql key="delete from them where id='nonexist';" opts=NULL
72 database lookup required for delete from them where id='nonexist';
73 MySQL query: "delete from them where id='nonexist';" opts 'NULL'
74 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
75 MYSQL: query was not one that returns data
76 lookup forced cache cleanup
78 search_open: mysql "NULL"
80 search_find: file="NULL"
81 key="select * from them where id='quote';" partial=-1 affix=NULL starflags=0 opts=NULL
83 internal_search_find: file="NULL"
84 type=mysql key="select * from them where id='quote';" opts=NULL
85 database lookup required for select * from them where id='quote';
86 MySQL query: "select * from them where id='quote';" opts 'NULL'
87 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
89 creating new cache entry
91 search_open: mysql "NULL"
93 search_find: file="NULL"
94 key="select * from them where id='filter';" partial=-1 affix=NULL starflags=0 opts=NULL
96 internal_search_find: file="NULL"
97 type=mysql key="select * from them where id='filter';" opts=NULL
98 database lookup required for select * from them where id='filter';
99 MySQL query: "select * from them where id='filter';" opts 'NULL'
100 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
102 creating new cache entry
104 search_open: mysql "NULL"
106 search_find: file="NULL"
107 key="select * from them where id='quote2';" partial=-1 affix=NULL starflags=0 opts=NULL
109 internal_search_find: file="NULL"
110 type=mysql key="select * from them where id='quote2';" opts=NULL
111 database lookup required for select * from them where id='quote2';
112 MySQL query: "select * from them where id='quote2';" opts 'NULL'
113 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
114 creating new cache entry
115 lookup yielded: name="\"stquot" id=quote2
116 search_open: mysql "NULL"
118 search_find: file="NULL"
119 key="select * from them where id='nlonly';" partial=-1 affix=NULL starflags=0 opts=NULL
121 internal_search_find: file="NULL"
122 type=mysql key="select * from them where id='nlonly';" opts=NULL
123 database lookup required for select * from them where id='nlonly';
124 MySQL query: "select * from them where id='nlonly';" opts 'NULL'
125 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
127 creating new cache entry
129 search_open: mysql "NULL"
131 search_find: file="NULL"
132 key="servers=x:127.0.0.1::PORT_N; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
134 internal_search_find: file="NULL"
135 type=mysql key="servers=x:127.0.0.1::PORT_N; select name from them where id='ph10';" opts=NULL
136 database lookup required for servers=x:127.0.0.1::PORT_N; select name from them where id='ph10';
137 MySQL query: "servers=x:127.0.0.1::PORT_N; select name from them where id='ph10';" opts 'NULL'
138 lookup deferred: MySQL server "x" not found in mysql_servers
139 search_open: mysql "NULL"
141 search_find: file="NULL"
142 key="servers=127.0.0.1::PORT_N:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
144 internal_search_find: file="NULL"
145 type=mysql key="servers=127.0.0.1::PORT_N:x; select name from them where id='ph10';" opts=NULL
146 database lookup required for servers=127.0.0.1::PORT_N:x; select name from them where id='ph10';
147 MySQL query: "servers=127.0.0.1::PORT_N:x; select name from them where id='ph10';" opts 'NULL'
148 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
149 creating new cache entry
150 lookup yielded: Philip Hazel
151 search_open: mysql "NULL"
153 search_find: file="NULL"
154 key="servers=127.0.0.1::PORT_N/test/root/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
156 internal_search_find: file="NULL"
157 type=mysql key="servers=127.0.0.1::PORT_N/test/root/:x; select name from them where id='ph10';" opts=NULL
158 database lookup required for servers=127.0.0.1::PORT_N/test/root/:x; select name from them where id='ph10';
159 MySQL query: "servers=127.0.0.1::PORT_N/test/root/:x; select name from them where id='ph10';" opts 'NULL'
160 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
161 creating new cache entry
162 lookup yielded: Philip Hazel
163 search_open: mysql "NULL"
165 search_find: file="NULL"
166 key="servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::PORT_N; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
168 internal_search_find: file="NULL"
169 type=mysql key="servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::PORT_N; select name from them where id='ph10';" opts=NULL
170 database lookup required for servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::PORT_N; select name from them where id='ph10';
171 MySQL query: "servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::PORT_N; select name from them where id='ph10';" opts 'NULL'
172 MYSQL new connection: host=ip4.ip4.ip4.ip4 port=PORT_N socket=NULL database=test user=root
173 creating new cache entry
174 lookup yielded: Philip Hazel
175 search_open: mysql "NULL"
177 search_find: file="NULL"
178 key="servers=localhost(TESTSUITE/mysql/sock)/test/root/pass; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
180 internal_search_find: file="NULL"
181 type=mysql key="servers=localhost(TESTSUITE/mysql/sock)/test/root/pass; select name from them where id='ph10';" opts=NULL
182 database lookup required for servers=localhost(TESTSUITE/mysql/sock)/test/root/pass; select name from them where id='ph10';
183 MySQL query: "servers=localhost(TESTSUITE/mysql/sock)/test/root/pass; select name from them where id='ph10';" opts 'NULL'
184 MYSQL new connection: host=localhost port=0 socket=TESTSUITE/mysql/sock database=test user=root
185 creating new cache entry
186 lookup yielded: Philip Hazel
187 search_open: mysql "NULL"
189 search_find: file="NULL"
190 key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 opts=NULL
192 internal_search_find: file="NULL"
193 type=mysql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL
194 database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
195 MySQL query: "SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" opts 'NULL'
196 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
197 creating new cache entry
198 lookup yielded: Philip Hazel
200 search_open: mysql "NULL"
202 search_find: file="NULL"
203 key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 opts=NULL
205 internal_search_find: file="NULL"
206 type=mysql key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL
207 database lookup required for SELECT * FROM them WHERE id IN ('ph10', 'aaaa');
208 MySQL query: "SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" opts 'NULL'
209 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
210 creating new cache entry
211 lookup yielded: name="Philip Hazel" id=ph10
212 name=Aristotle id=aaaa
213 search_open: mysql "NULL"
215 search_find: file="NULL"
216 key="delete from them where id='aaaa'" partial=-1 affix=NULL starflags=0 opts=NULL
218 internal_search_find: file="NULL"
219 type=mysql key="delete from them where id='aaaa'" opts=NULL
220 database lookup required for delete from them where id='aaaa'
221 MySQL query: "delete from them where id='aaaa'" opts 'NULL'
222 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
223 MYSQL: query was not one that returns data
224 lookup forced cache cleanup
227 close MYSQL connection: localhost(TESTSUITE/mysql/sock)/test/root
228 close MYSQL connection: ip4.ip4.ip4.ip4:1223/test/root
229 close MYSQL connection: 127.0.0.1:PORT_N/test/root
230 >>>>>>>>>>>>>>>> Exim pid=p1234 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
231 Exim version x.yz ....
232 changed uid/gid: forcing real = effective
233 uid=uuuu gid=CALLER_GID pid=p1235
234 configuration file is TESTSUITE/test-config
236 changed uid/gid: privilege not needed
237 uid=EXIM_UID gid=EXIM_GID pid=p1235
238 seeking password data for user "CALLER": cache not available
239 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
240 originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
241 sender address = CALLER@myhost.test.ex
242 sender_fullhost = [10.0.0.0]
243 sender_rcvhost = [10.0.0.0]
244 host in hosts_connection_nolog? no (option unset)
245 LOG: smtp_connection MAIN
246 SMTP connection from [10.0.0.0]
247 host in host_lookup? no (option unset)
248 set_process_info: pppp handling incoming connection from [10.0.0.0]
249 host in host_reject_connection? no (option unset)
250 host in sender_unqualified_hosts? no (option unset)
251 host in recipient_unqualified_hosts? no (option unset)
252 host in helo_verify_hosts? no (option unset)
253 host in helo_try_verify_hosts? no (option unset)
254 host in helo_accept_junk_hosts? no (option unset)
255 SMTP>> 220 myhost.test.ex ESMTP Exim x.yz Tue, 2 Mar 1999 09:44:33 +0000
256 smtp_setup_msg entered
258 test in helo_lookup_domains?
261 test in helo_lookup_domains? no (end of list)
262 sender_fullhost = (test) [10.0.0.0]
263 sender_rcvhost = [10.0.0.0] (helo=test)
264 set_process_info: pppp handling incoming connection from (test) [10.0.0.0]
265 SMTP>> 250 myhost.test.ex Hello test [10.0.0.0]
266 SMTP<< mail from:<a@b>
267 spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
268 log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
271 using ACL "check_recipient"
272 processing "warn" (TESTSUITE/test-config 26)
273 search_open: mysql "NULL"
274 search_find: file="NULL"
275 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL
277 internal_search_find: file="NULL"
278 type=mysql key="select name from them where id = 'c'" opts=NULL
279 database lookup required for select name from them where id = 'c'
280 (tainted, quoted:mysql)
281 MySQL query: "select name from them where id = 'c'" opts 'NULL'
282 MYSQL new connection: host=127.0.0.1 port=PORT_N socket=NULL database=test user=root
284 creating new cache entry
286 check set acl_m0 = ok: ${lookup mysql {select name from them where id = '${quote_mysql:$local_part}'}}
288 search_open: mysql "NULL"
290 search_find: file="NULL"
291 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="no_rd"
293 internal_search_find: file="NULL"
294 type=mysql key="select name from them where id = 'c'" opts="no_rd"
295 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
298 tainted search query is not properly quoted (ACL warn, TESTSUITE/test-config 26): select name from them where id = 'c'
299 search_type NN (mysql) quoting -1 (none)
300 MySQL query: "select name from them where id = 'c'" opts 'no_rd'
301 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
303 replacing old cache entry
305 check set acl_m0 = FAIL: ${lookup mysql,no_rd {select name from them where id = '$local_part'}}
307 warn: condition test succeeded in ACL "check_recipient"
308 processing "warn" (TESTSUITE/test-config 31)
309 search_open: mysql "NULL"
311 search_find: file="NULL"
312 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=127.0.0.1::PORT_N/test/root/pass"
314 internal_search_find: file="NULL"
315 type=mysql key="select name from them where id = 'c'" opts="servers=127.0.0.1::PORT_N/test/root/pass"
316 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
317 (tainted, quoted:mysql)
318 MySQL query: "select name from them where id = 'c'" opts 'servers=127.0.0.1::PORT_N/test/root/pass'
319 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
321 replacing old cache entry
323 check set acl_m0 = ok: ${lookup mysql,servers=127.0.0.1::PORT_N/test/root/pass {select name from them where id = '${quote_mysql:$local_part}'}}
325 search_open: mysql "NULL"
327 search_find: file="NULL"
328 key="select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts="servers=127.0.0.1::PORT_N"
330 internal_search_find: file="NULL"
331 type=mysql key="select name from them where id = 'c'" opts="servers=127.0.0.1::PORT_N"
332 cached data found but wrong opts; database lookup required for select name from them where id = 'c'
333 (tainted, quoted:mysql)
334 MySQL query: "select name from them where id = 'c'" opts 'servers=127.0.0.1::PORT_N'
335 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
337 replacing old cache entry
339 check set acl_m0 = ok: ${lookup mysql,servers=127.0.0.1::PORT_N {select name from them where id = '${quote_mysql:$local_part}'}}
341 search_open: mysql "NULL"
343 search_find: file="NULL"
344 key="servers=127.0.0.1::PORT_N/test/root/pass; select name from them where id = 'c'" partial=-1 affix=NULL starflags=0 opts=NULL
346 internal_search_find: file="NULL"
347 type=mysql key="servers=127.0.0.1::PORT_N/test/root/pass; select name from them where id = 'c'" opts=NULL
348 database lookup required for servers=127.0.0.1::PORT_N/test/root/pass; select name from them where id = 'c'
349 (tainted, quoted:mysql)
350 MySQL query: "servers=127.0.0.1::PORT_N/test/root/pass; select name from them where id = 'c'" opts 'NULL'
351 lookup deferred: MySQL server "127.0.0.1:PORT_N/test/root/pass" is tainted
352 warn: condition test deferred in ACL "check_recipient"
354 H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: MySQL server "127.0.0.1:PORT_N/test/root/pass" is tainted
355 processing "warn" (TESTSUITE/test-config 40)
356 check set acl_m0 = ok: hostlist
357 check hosts = net-mysql;select * from them where id='${quote_mysql:$local_part}'
358 host in "net-mysql;select * from them where id='c'"?
359 list element: net-mysql;select * from them where id='c'
360 search_open: mysql "NULL"
362 search_find: file="NULL"
363 key="select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
365 internal_search_find: file="NULL"
366 type=mysql key="select * from them where id='c'" opts=NULL
367 database lookup required for select * from them where id='c'
368 (tainted, quoted:mysql)
369 MySQL query: "select * from them where id='c'" opts 'NULL'
370 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
372 creating new cache entry
374 host in "net-mysql;select * from them where id='c'"? no (end of list)
375 warn: condition test failed in ACL "check_recipient"
376 processing "warn" (TESTSUITE/test-config 43)
377 check set acl_m0 = FAIL: hostlist
378 check hosts = <& net-mysql;servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='${quote_mysql:$local_part}'
379 host in "<& net-mysql;servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'"?
380 list element: net-mysql;servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'
381 search_open: mysql "NULL"
383 search_find: file="NULL"
384 key="servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts=NULL
386 internal_search_find: file="NULL"
387 type=mysql key="servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'" opts=NULL
388 database lookup required for servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'
389 (tainted, quoted:mysql)
390 MySQL query: "servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'" opts 'NULL'
391 lookup deferred: MySQL server "127.0.0.1:PORT_N/test/root/pass" is tainted
392 host in "<& net-mysql;servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'"? list match deferred for net-mysql;servers=127.0.0.1::1223/test/root/pass; select * from them where id='c'
393 warn: condition test deferred in ACL "check_recipient"
395 H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: MySQL server "127.0.0.1:PORT_N/test/root/pass" is tainted
396 processing "warn" (TESTSUITE/test-config 48)
397 check set acl_m0 = FAIL: hostlist
398 check hosts = <& net-mysql,servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='${quote_mysql:$local_part}'
399 host in "<& net-mysql,servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'"?
400 list element: net-mysql,servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'
401 search_open: mysql "NULL"
403 search_find: file="NULL"
404 key=" select * from them where id='c'" partial=-1 affix=NULL starflags=0 opts="servers=127.0.0.1::PORT_N/test/root/pass"
406 internal_search_find: file="NULL"
407 type=mysql key=" select * from them where id='c'" opts="servers=127.0.0.1::PORT_N/test/root/pass"
408 database lookup required for select * from them where id='c'
409 (tainted, quoted:mysql)
410 MySQL query: " select * from them where id='c'" opts 'servers=127.0.0.1::PORT_N/test/root/pass'
411 lookup deferred: MySQL server "127.0.0.1:PORT_N/test/root/pass" is tainted
412 host in "<& net-mysql,servers=127.0.0.1::PORT_N/test/root/pass; select * from them where id='c'"? list match deferred for net-mysql,servers=127.0.0.1::1223/test/root/pass; select * from them where id='c'
413 warn: condition test deferred in ACL "check_recipient"
415 H=(test) [10.0.0.0] Warning: ACL "warn" statement skipped: condition test deferred: MySQL server "127.0.0.1:PORT_N/test/root/pass" is tainted
416 processing "accept" (TESTSUITE/test-config 51)
417 check domains = +local_domains
418 d in "+local_domains"?
419 list element: +local_domains
420 start sublist local_domains
423 d in "@"? no (end of list)
424 end sublist local_domains
425 d in "+local_domains"? no (end of list)
426 accept: condition test failed in ACL "check_recipient"
427 processing "accept" (TESTSUITE/test-config 54)
428 check hosts = +relay_hosts
429 host in "+relay_hosts"?
430 list element: +relay_hosts
431 start sublist relay_hosts
432 host in "net-mysql;select * from them where id='10.0.0.0'"?
433 ╎list element: net-mysql;select * from them where id='10.0.0.0'
434 ╎search_open: mysql "NULL"
436 ╎search_find: file="NULL"
437 ╎ key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL
439 ╎internal_search_find: file="NULL"
440 ╎ type=mysql key="select * from them where id='10.0.0.0'" opts=NULL
441 ╎database lookup required for select * from them where id='10.0.0.0'
442 ╎MySQL query: "select * from them where id='10.0.0.0'" opts 'NULL'
443 ╎MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
444 ╎MYSQL: no data found
445 ╎creating new cache entry
447 host in "net-mysql;select * from them where id='10.0.0.0'"? no (end of list)
448 end sublist relay_hosts
449 host in "+relay_hosts"? no (end of list)
450 accept: condition test failed in ACL "check_recipient"
451 processing "deny" (TESTSUITE/test-config 55)
452 message: relay not permitted
453 deny: condition test succeeded in ACL "check_recipient"
454 end of ACL "check_recipient": DENY
455 SMTP>> 550 relay not permitted
457 H=(test) [10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
459 SMTP>> 221 myhost.test.ex closing connection
460 LOG: smtp_connection MAIN
461 SMTP connection from (test) [10.0.0.0] closed by QUIT
463 close MYSQL connection: 127.0.0.1:PORT_N/test/root
464 >>>>>>>>>>>>>>>> Exim pid=p1235 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>
465 Exim version x.yz ....
466 changed uid/gid: forcing real = effective
467 uid=uuuu gid=CALLER_GID pid=p1236
468 configuration file is TESTSUITE/test-config
470 changed uid/gid: privilege not needed
471 uid=EXIM_UID gid=EXIM_GID pid=p1236
472 seeking password data for user "CALLER": cache not available
473 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
474 originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
475 sender address = CALLER@myhost.test.ex
476 set_process_info: pppp accepting a local non-SMTP message from <CALLER@myhost.test.ex>
477 spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
478 log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
479 Sender: CALLER@myhost.test.ex
485 qualify & rewrite recipients list
488 rewrite_one_header: type=F:
489 From: CALLER_NAME <CALLER@myhost.test.ex>
491 >>Headers after rewriting and local additions:
492 I Message-Id: <E10HmaX-0005vi-00@myhost.test.ex>
493 F From: CALLER_NAME <CALLER@myhost.test.ex>
494 Date: Tue, 2 Mar 1999 09:44:33 +0000
496 Data file name: TESTSUITE/spool//input//10HmaX-0005vi-00-D
497 Data file written for message 10HmaX-0005vi-00
498 >>Generated Received: header line
499 P Received: from CALLER by myhost.test.ex with local (Exim x.yz)
500 (envelope-from <CALLER@myhost.test.ex>)
502 for ph10@myhost.test.ex;
503 Tue, 2 Mar 1999 09:44:33 +0000
504 using ACL "check_notsmtp"
505 processing "accept" (TESTSUITE/test-config 58)
506 check set acl_m_qtest = ${quote_mysql:$recipients}
507 = ph10@myhost.test.ex
508 accept: condition test succeeded in ACL "check_notsmtp"
509 end of ACL "check_notsmtp": ACCEPT
510 Writing spool header file: TESTSUITE/spool//input//hdr.10HmaX-0005vi-00
511 DSN: **** SPOOL_OUT - address: <ph10@myhost.test.ex> errorsto: <NULL> orcpt: <NULL> dsn_flags: 0x0
512 Renaming spool header file: TESTSUITE/spool//input//10HmaX-0005vi-00-H
513 Size of headers = sss
515 <= CALLER@myhost.test.ex U=CALLER P=local S=sss
516 created log directory TESTSUITE/spool/log
518 exec TESTSUITE/eximdir/exim -DEXIM_PATH=TESTSUITE/eximdir/exim -C TESTSUITE/test-config -d=0xf7715cfd -MCd local-accept-delivery -odi -Mc 10HmaX-0005vi-00
519 Exim version x.yz ....
520 changed uid/gid: forcing real = effective
521 uid=uuuu gid=EXIM_GID pid=p1237
522 configuration file is TESTSUITE/test-config
525 dropping to exim gid; retaining priv uid
526 seeking password data for user "CALLER": cache not available
527 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
528 set_process_info: pppp delivering specified messages
529 set_process_info: pppp delivering 10HmaX-0005vi-00
530 Trying spool file TESTSUITE/spool//input//10HmaX-0005vi-00-D
531 reading spool file 10HmaX-0005vi-00-H
532 user=CALLER uid=CALLER_UID gid=CALLER_GID sender=CALLER@myhost.test.ex
533 sender_local=1 ident=CALLER
536 ---- End of tree ----
538 **** SPOOL_IN - No additional fields
539 body_linecount=1 message_linecount=8
540 DSN: set orcpt: flags: 0x0
541 Delivery address list:
543 locking TESTSUITE/spool/db/retry.lockfile
544 locked TESTSUITE/spool/db/retry.lockfile
545 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
546 returned from EXIM_DBOPEN: (nil)
547 failed to open DB file TESTSUITE/spool/db/retry: No such file or directory
548 no retry data available
549 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
550 Considering: ph10@myhost.test.ex
551 unique = ph10@myhost.test.ex
552 no domain retry record
553 no address retry record
554 ph10@myhost.test.ex: queued for routing
555 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
556 routing ph10@myhost.test.ex
557 --------> r1 router <--------
558 local_part=ph10 domain=myhost.test.ex
559 search_open: mysql "NULL"
560 search_find: file="NULL"
561 key="select name from them where id='ph10@myhost.test.ex'" partial=-1 affix=NULL starflags=0 opts=NULL
563 internal_search_find: file="NULL"
564 type=mysql key="select name from them where id='ph10@myhost.test.ex'" opts=NULL
565 database lookup required for select name from them where id='ph10@myhost.test.ex'
566 (tainted, quoted:mysql)
567 MySQL query: "select name from them where id='ph10@myhost.test.ex'" opts 'NULL'
568 MYSQL new connection: host=127.0.0.1 port=PORT_N socket=NULL database=test user=root
570 creating new cache entry
572 acl_m_qtest: <ph10@myhost.test.ex> lkup: <>
573 processing address_data
574 search_open: mysql "NULL"
576 search_find: file="NULL"
577 key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
579 internal_search_find: file="NULL"
580 type=mysql key="select name from them where id='ph10'" opts=NULL
581 database lookup required for select name from them where id='ph10'
584 tainted search query is not properly quoted (router r1, TESTSUITE/test-config 66): select name from them where id='ph10'
585 search_type NN (mysql) quoting -1 (none)
586 MySQL query: "select name from them where id='ph10'" opts 'NULL'
587 MYSQL using cached connection for 127.0.0.1:PORT_N/test/root
588 creating new cache entry
589 lookup yielded: Philip Hazel
591 r1 router called for ph10@myhost.test.ex
592 domain = myhost.test.ex
594 queued for t1 transport: local_part = ph10
595 domain = myhost.test.ex
597 domain_data=NULL local_part_data=NULL
599 envelope to: ph10@myhost.test.ex
601 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
609 close MYSQL connection: 127.0.0.1:PORT_N/test/root
610 >>>>>>>>>>>>>>>> Local deliveries >>>>>>>>>>>>>>>>
611 --------> ph10@myhost.test.ex <--------
612 locking TESTSUITE/spool/db/retry.lockfile
613 locked TESTSUITE/spool/db/retry.lockfile
614 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
615 returned from EXIM_DBOPEN: (nil)
616 failed to open DB file TESTSUITE/spool/db/retry: No such file or directory
617 no retry data available
619 changed uid/gid: local delivery to ph10 <ph10@myhost.test.ex> transport=t1
620 uid=CALLER_UID gid=CALLER_GID pid=p1238
622 set_process_info: pppp delivering 10HmaX-0005vi-00 to ph10 using t1
623 appendfile transport entered
624 search_open: mysql "NULL"
625 search_find: file="NULL"
626 key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
628 internal_search_find: file="NULL"
629 type=mysql key="select id from them where id='ph10'" opts=NULL
630 database lookup required for select id from them where id='ph10'
633 tainted search query is not properly quoted (transport t1, TESTSUITE/test-config 79): select id from them where id='ph10'
634 search_type NN (mysql) quoting -1 (none)
635 MySQL query: "select id from them where id='ph10'" opts 'NULL'
636 MYSQL new connection: host=127.0.0.1 port=PORT_N socket=NULL database=test user=root
637 creating new cache entry
639 appendfile: mode=600 notify_comsat=0 quota=0 warning=0
640 file=TESTSUITE/test-mail/ph10 format=unix
641 message_prefix=From ${if def:return_path{$return_path}{MAILER-DAEMON}} ${tod_bsdinbox}\n
643 maildir_use_size_file=no
644 locking by lockfile fcntl
645 lock name: TESTSUITE/test-mail/ph10.lock
646 hitch name: TESTSUITE/test-mail/ph10.lock.test.ex.dddddddd.pppppppp
648 mailbox TESTSUITE/test-mail/ph10 is locked
649 writing to file TESTSUITE/test-mail/ph10
650 writing data block fd=dddd size=sss timeout=0
651 cannot use sendfile for body: spoolfile not wireformat
652 writing data block fd=dddd size=sss timeout=0
653 writing data block fd=dddd size=sss timeout=0
654 appendfile yields 0 with errno=dd more_errno=dd
656 close MYSQL connection: 127.0.0.1:PORT_N/test/root
657 journalling ph10@myhost.test.ex
658 t1 transport returned OK for ph10@myhost.test.ex
659 post-process ph10@myhost.test.ex (0)
660 ph10@myhost.test.ex delivered
662 => ph10 <ph10@myhost.test.ex> R=r1 T=t1
663 >>>>>>>>>>>>>>>> deliveries are done >>>>>>>>>>>>>>>>
664 changed uid/gid: post-delivery tidying
665 uid=EXIM_UID gid=EXIM_GID pid=p1237
666 set_process_info: pppp tidying up after delivering 10HmaX-0005vi-00
667 Processing retry items
669 ph10@myhost.test.ex: no retry items
672 end of retry processing
673 DSN: processing router : r1
674 DSN: processing successful delivery address: ph10@myhost.test.ex
675 DSN: Sender_address: CALLER@myhost.test.ex
676 DSN: orcpt: NULL flags: 0x0
677 DSN: envid: NULL ret: 0
678 DSN: Final recipient: ph10@myhost.test.ex
679 DSN: Remote SMTP server supports DSN: 0
680 DSN: not sending DSN success message
683 end delivery of 10HmaX-0005vi-00
686 >>>>>>>>>>>>>>>> Exim pid=p1237 (local-accept-delivery) terminating with rc=0 >>>>>>>>>>>>>>>>
688 >>>>>>>>>>>>>>>> Exim pid=p1236 (fresh-exec) terminating with rc=0 >>>>>>>>>>>>>>>>