Advertisement
Guest User

headers_remove :: when_not_working

a guest
Jan 29th, 2015
264
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 84.28 KB | None | 0 0
  1. Test Parameters
  2. ===============
  3. headers_remove = ${if or { { <{$spam_score_int}{1} } \
  4. { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains \
  5. where localpart = '${quote_mysql::$local_part}' \
  6. and domain = '${quote_mysql::$domain}' \
  7. and users.on_spamassassin = 1 \
  8. and users.domain_id=domains.domain_id}{$value}fail}} } \
  9. { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains \
  10. where localpart = '${quote_mysql::$local_part}' \
  11. and domain = '${quote_mysql::$domain}' \
  12. and users.on_spamassassin = 0 \
  13. and users.domain_id=domains.domain_id}{$value}fail}}} \
  14. } {X-Spam-Score::X-Spam-Report} }
  15.  
  16.  
  17. Result
  18. ======
  19.  
  20. Script started on Thu Jan 29 16:02:56 2015
  21. root@bMail:/root/eximDiags # exim -bd -d+all
  22.  
  23. 16:02:58 65900 Exim version 4.85 (FreeBSD 10.1) uid=0 gid=0 pid=65900 D=fffdffff
  24. Probably Berkeley DB version 1.8x (native mode)
  25. Support for: crypteq iconv() use_setclassresources Perl Expand_dlfunc OpenSSL Content_Scanning DKIM Old_Demime PRDR OCSP Experimental_SPF
  26. Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmjz dbmnz dnsdb dsearch mysql
  27. Authenticators: cram_md5 plaintext spa
  28. Routers: accept dnslookup ipliteral manualroute queryprogram redirect
  29. Transports: appendfile/maildir autoreply lmtp pipe smtp
  30. Fixed never_users: 0
  31. Size of off_t: 8
  32. Compiler: CLang [3.4.1 (tags/RELEASE_34/dot1-final 208032)]
  33. Library version: OpenSSL: Compile: OpenSSL 1.0.1k-freebsd 8 Jan 2015
  34. Runtime: OpenSSL 1.0.1k-freebsd 8 Jan 2015
  35. : built on: date not available
  36. Library version: PCRE: Compile: 8.35
  37. Runtime: 8.35 2014-04-04
  38. 16:02:58 65900 Total 12 lookups
  39. Library version: MySQL: Compile: 5.6.22 [Source distribution]
  40. Runtime: 5.6.22
  41. WHITELIST_D_MACROS unset
  42. TRUSTED_CONFIG_LIST unset
  43. 16:02:58 65900 changed uid/gid: forcing real = effective
  44. 16:02:58 65900 uid=0 gid=0 pid=65900
  45. 16:02:58 65900 auxiliary group list: 0
  46. 16:02:58 65900 seeking password data for user "mailnull": using cached result
  47. 16:02:58 65900 getpwnam() succeeded uid=26 gid=26
  48. 16:02:58 65900 seeking password data for user "www": cache not available
  49. 16:02:58 65900 getpwnam() succeeded uid=80 gid=80
  50. 16:02:58 65900 seeking password data for user "mailnull": cache not available
  51. 16:02:58 65900 getpwnam() succeeded uid=26 gid=26
  52. 16:02:58 65900 seeking password data for user "root": cache not available
  53. 16:02:58 65900 getpwnam() succeeded uid=0 gid=0
  54. 16:02:58 65901 changed uid/gid: calling tls_validate_require_cipher
  55. 16:02:58 65901 uid=26 gid=6 pid=65901
  56. 16:02:58 65901 auxiliary group list: 6
  57. 16:02:58 65900 tls_validate_require_cipher child 65901 ended: status=0x0
  58. 16:02:58 65900 configuration file is /usr/local/etc/exim/configure
  59. 16:02:58 65900 log selectors = 00000ffc 002b2001
  60. 16:02:58 65900 cwd=/RWs/root/eximDiags 3 args: exim -bd -d+all
  61. 16:02:58 65900 trusted user
  62. 16:02:58 65900 admin user
  63. 16:02:58 65900 seeking password data for user "mailnull": cache not available
  64. 16:02:58 65900 getpwnam() succeeded uid=26 gid=26
  65. 16:02:58 65900 seeking password data for user "mailnull": using cached result
  66. 16:02:58 65900 getpwnam() succeeded uid=26 gid=26
  67. 16:02:58 65900 originator: uid=0 gid=0 login=root name=Charlie Root
  68. 16:02:58 65900 listening on all interfaces (IPv4) port 25
  69. 16:02:58 65900 listening on all interfaces (IPv4) port 465
  70. 16:02:58 65900 pid written to /var/run/exim.pid
  71. 16:02:58 65900 changed uid/gid: running as a daemon
  72. 16:02:58 65900 uid=26 gid=6 pid=65900
  73. 16:02:58 65900 auxiliary group list: 6
  74. 16:02:58 65900 LOG: MAIN
  75. 16:02:58 65900 exim 4.85 daemon started: pid=65900, no queue runs, listening for SMTP on port 25 (IPv4) and for SMTPS on port 465 (IPv4)
  76. 16:02:58 65900 set_process_info: 65900 daemon: no queue runs, listening for SMTP on port 25 (IPv4) and for SMTPS on port 465 (IPv4)
  77. 16:02:58 65900 daemon running with uid=26 gid=6 euid=26 egid=6
  78. 16:02:58 65900 Listening...
  79. 16:03:04 65900 Connection request from 172.16.0.245 port 29743
  80. 16:03:04 65900 interface address=172.16.0.245 port=25
  81. 16:03:04 65900 search_tidyup called
  82. 16:03:04 65900 1 SMTP accept process running
  83. 16:03:04 65900 Listening...
  84. 16:03:04 65903 host in rfc1413_hosts? yes (matched "*")
  85. 16:03:04 65903 doing ident callback
  86. 16:03:04 65903 ident connection to 172.16.0.245 failed: Connection refused
  87. 16:03:04 65903 sender_fullhost = [172.16.0.245]
  88. 16:03:04 65903 sender_rcvhost = [172.16.0.245]
  89. 16:03:04 65903 Process 65903 is handling incoming connection from [172.16.0.245]
  90. 16:03:04 65903 checking for IP options
  91. 16:03:04 65903 no IP options found
  92. 16:03:04 65903 host in host_lookup? no (option unset)
  93. 16:03:04 65903 set_process_info: 65903 handling incoming connection from [172.16.0.245]
  94. 16:03:04 65903 host in host_reject_connection? no (option unset)
  95. 16:03:04 65903 host in sender_unqualified_hosts? no (option unset)
  96. 16:03:04 65903 host in recipient_unqualified_hosts? no (option unset)
  97. 16:03:04 65903 host in helo_verify_hosts? no (option unset)
  98. 16:03:04 65903 host in helo_try_verify_hosts? no (option unset)
  99. 16:03:04 65903 host in helo_accept_junk_hosts? no (option unset)
  100. 16:03:04 65903 expanding: $smtp_active_hostname ESMTP Exim $version_number $tod_full
  101. 16:03:04 65903 result: mailsrv.localdomain.lan ESMTP Exim 4.85 Thu, 29 Jan 2015 16:03:04 +0000
  102. 16:03:04 65903 SMTP>> 220 mailsrv.localdomain.lan ESMTP Exim 4.85 Thu, 29 Jan 2015 16:03:04 +0000
  103. 16:03:04 65903 Process 65903 is ready for new message
  104. 16:03:04 65903 smtp_setup_msg entered
  105. 16:03:07 65903 SMTP<< ehlo mailer
  106. 16:03:07 65903 mailer in helo_lookup_domains? no (end of list)
  107. 16:03:07 65903 sender_fullhost = (mailer) [172.16.0.245]
  108. 16:03:07 65903 sender_rcvhost = [172.16.0.245] (helo=mailer)
  109. 16:03:07 65903 set_process_info: 65903 handling incoming connection from (mailer) [172.16.0.245]
  110. 16:03:07 65903 using ACL "acl_check_helo"
  111. 16:03:07 65903 processing "accept"
  112. 16:03:07 65903 check hosts = :
  113. 16:03:07 65903 host in ":"? no (end of list)
  114. 16:03:07 65903 accept: condition test failed in ACL "acl_check_helo"
  115. 16:03:07 65903 processing "accept"
  116. 16:03:07 65903 check hosts = +relay_from_hosts
  117. 16:03:07 65903 gethostbyname looked up these IP addresses:
  118. 16:03:07 65903 name=localhost address=127.0.0.1
  119. 16:03:07 65903 host in "localhost : 172.16.0.245"? yes (matched "172.16.0.245")
  120. 16:03:07 65903 host in "+relay_from_hosts"? yes (matched "+relay_from_hosts")
  121. 16:03:07 65903 accept: condition test succeeded in ACL "acl_check_helo"
  122. 16:03:07 65903 end of ACL "acl_check_helo": ACCEPT
  123. 16:03:07 65903 host in pipelining_advertise_hosts? yes (matched "*")
  124. 16:03:07 65903 host in auth_advertise_hosts? yes (matched "*")
  125. 16:03:07 65903 expanding: $tls_cipher
  126. 16:03:07 65903 result:
  127. 16:03:07 65903 expanding:
  128. 16:03:07 65903 result:
  129. 16:03:07 65903 expanding: $sender_host_address
  130. 16:03:07 65903 result: 172.16.0.245
  131. 16:03:07 65903 expanding: @[]
  132. 16:03:07 65903 result: @[]
  133. 16:03:07 65903 Actual local interface address is 172.16.0.245 (re0)
  134. 16:03:07 65903 172.16.0.245 in "@[]"? yes (matched "@[]")
  135. 16:03:07 65903 condition: or{{!eq{$tls_cipher}{}}{match_ip {$sender_host_address}{@[]}}}
  136. 16:03:07 65903 result: true
  137. 16:03:07 65903 expanding: *
  138. 16:03:07 65903 result: *
  139. 16:03:07 65903 expanding:
  140. 16:03:07 65903 result:
  141. 16:03:07 65903 skipping: result is not used
  142. 16:03:07 65903 expanding: ${if or{{!eq{$tls_cipher}{}}{match_ip {$sender_host_address}{@[]}}}{*}{}}
  143. 16:03:07 65903 result: *
  144. 16:03:07 65903 expanding: $tls_cipher
  145. 16:03:07 65903 result:
  146. 16:03:07 65903 expanding:
  147. 16:03:07 65903 result:
  148. 16:03:07 65903 expanding: $sender_host_address
  149. 16:03:07 65903 result: 172.16.0.245
  150. 16:03:07 65903 expanding: @[]
  151. 16:03:07 65903 result: @[]
  152. 16:03:07 65903 172.16.0.245 in "@[]"? yes (matched "@[]")
  153. 16:03:07 65903 condition: or{{!eq{$tls_cipher}{}}{match_ip {$sender_host_address}{@[]}}}
  154. 16:03:07 65903 result: true
  155. 16:03:07 65903 expanding: *
  156. 16:03:07 65903 result: *
  157. 16:03:07 65903 expanding:
  158. 16:03:07 65903 result:
  159. 16:03:07 65903 skipping: result is not used
  160. 16:03:07 65903 expanding: ${if or{{!eq{$tls_cipher}{}}{match_ip {$sender_host_address}{@[]}}}{*}{}}
  161. 16:03:07 65903 result: *
  162. 16:03:07 65903 host in tls_advertise_hosts? yes (matched "*")
  163. 16:03:07 65903 SMTP>> 250-mailsrv.localdomain.lan Hello mailer [172.16.0.245]
  164. 16:03:07 65903 250-SIZE 52428800
  165. 16:03:07 65903 250-8BITMIME
  166. 16:03:07 65903 250-PIPELINING
  167. 16:03:07 65903 250-AUTH PLAIN LOGIN
  168. 16:03:07 65903 250-STARTTLS
  169. 16:03:07 65903 250 HELP
  170. 16:03:15 65903 SMTP<< mail from:<nobody@nowhere.com>
  171. 16:03:15 65903 SMTP>> 250 OK
  172. 16:03:27 65903 SMTP<< rcpt to:<postmaster@localdomain.lan>
  173. 16:03:27 65903 using ACL "acl_check_rcpt"
  174. 16:03:27 65903 processing "accept"
  175. 16:03:27 65903 check authenticated = *
  176. 16:03:27 65903 accept: condition test failed in ACL "acl_check_rcpt"
  177. 16:03:27 65903 processing "accept"
  178. 16:03:27 65903 check hosts = :
  179. 16:03:27 65903 host in ":"? no (end of list)
  180. 16:03:27 65903 accept: condition test failed in ACL "acl_check_rcpt"
  181. 16:03:27 65903 processing "deny"
  182. 16:03:27 65903 message: DNSBL listed at $dnslist_domain\n$dnslist_text
  183. 16:03:27 65903 check dnslists = zen.spamhaus.org:bl.spamcop.net
  184. 16:03:27 65903 DNS list check: zen.spamhaus.org
  185. 16:03:27 65903 new DNS lookup for 245.0.16.172.zen.spamhaus.org
  186. ;; res_nquerydomain(245.0.16.172.zen.spamhaus.org, <Nil>, 1, 1)
  187. ;; res_query(245.0.16.172.zen.spamhaus.org, 1, 1)
  188. ;; res_nmkquery(QUERY, 245.0.16.172.zen.spamhaus.org, IN, A)
  189. ;; res_send()
  190. ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 60000
  191. ;; flags: rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0
  192. ;; 245.0.16.172.zen.spamhaus.org, type = A, class = IN
  193. ;; Querying server (# 1) address = 8.8.8.8
  194. ;; new DG socket
  195. ;; got answer:
  196. ;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 60000
  197. ;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0
  198. ;; 245.0.16.172.zen.spamhaus.org, type = A, class = IN
  199. zen.spamhaus.org. 9S IN SOA need.to.know.only. hostmaster.spamhaus.org. (
  200. 1501291602 ; serial
  201. 1H ; refresh
  202. 10M ; retry
  203. 5D ; expiry
  204. 10S ) ; minimum
  205.  
  206. ;; rcode = (NXDOMAIN), counts = an:0 ns:1 ar:0
  207. 16:03:27 65903 DNS lookup of 245.0.16.172.zen.spamhaus.org (A) gave HOST_NOT_FOUND
  208. 16:03:27 65903 returning DNS_NOMATCH
  209. 16:03:27 65903 DNS lookup for 245.0.16.172.zen.spamhaus.org failed
  210. 16:03:27 65903 => that means 172.16.0.245 is not listed at zen.spamhaus.org
  211. 16:03:27 65903 DNS list check: bl.spamcop.net
  212. 16:03:27 65903 new DNS lookup for 245.0.16.172.bl.spamcop.net
  213. ;; res_nquerydomain(245.0.16.172.bl.spamcop.net, <Nil>, 1, 1)
  214. ;; res_query(245.0.16.172.bl.spamcop.net, 1, 1)
  215. ;; res_nmkquery(QUERY, 245.0.16.172.bl.spamcop.net, IN, A)
  216. ;; res_send()
  217. ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 52513
  218. ;; flags: rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0
  219. ;; 245.0.16.172.bl.spamcop.net, type = A, class = IN
  220. ;; Querying server (# 1) address = 8.8.8.8
  221. ;; new DG socket
  222. ;; got answer:
  223. ;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 52513
  224. ;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0
  225. ;; 245.0.16.172.bl.spamcop.net, type = A, class = IN
  226. bl.spamcop.net. 0S IN SOA bl.spamcop.net. hostmaster.admin.spamcop.net. (
  227. 1422547290 ; serial
  228. 1H ; refresh
  229. 30M ; retry
  230. 1H ; expiry
  231. 0S ) ; minimum
  232.  
  233. ;; rcode = (NXDOMAIN), counts = an:0 ns:1 ar:0
  234. 16:03:27 65903 DNS lookup of 245.0.16.172.bl.spamcop.net (A) gave HOST_NOT_FOUND
  235. 16:03:27 65903 returning DNS_NOMATCH
  236. 16:03:27 65903 DNS lookup for 245.0.16.172.bl.spamcop.net failed
  237. 16:03:27 65903 => that means 172.16.0.245 is not listed at bl.spamcop.net
  238. 16:03:27 65903 deny: condition test failed in ACL "acl_check_rcpt"
  239. 16:03:27 65903 processing "deny"
  240. 16:03:27 65903 check local_parts = ^.*[@%!/|] : ^\\.
  241. 16:03:27 65903 expanding: ^.*[@%!/|] : ^\\.
  242. 16:03:27 65903 result: ^.*[@%!/|] : ^\.
  243. 16:03:27 65903 postmaster in "^.*[@%!/|] : ^\."? no (end of list)
  244. 16:03:27 65903 deny: condition test failed in ACL "acl_check_rcpt"
  245. 16:03:27 65903 processing "accept"
  246. 16:03:27 65903 check local_parts = postmaster
  247. 16:03:27 65903 postmaster in "postmaster"? yes (matched "postmaster")
  248. 16:03:27 65903 check domains = +local_domains
  249. 16:03:27 65903 expanding: $domain
  250. 16:03:27 65903 result: localdomain.lan
  251. 16:03:27 65903 expanding: SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = '${quote_mysql:$domain}'
  252. 16:03:27 65903 result: SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'
  253. 16:03:27 65903 search_open: mysql "NULL"
  254. 16:03:27 65903 search_find: file="NULL"
  255. 16:03:27 65903 key="SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'" partial=-1 affix=NULL starflags=0
  256. 16:03:27 65903 LRU list:
  257. 16:03:27 65903 internal_search_find: file="NULL"
  258. 16:03:27 65903 type=mysql key="SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'"
  259. 16:03:27 65903 database lookup required for SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'
  260. 16:03:27 65903 MySQL query: SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'
  261. 16:03:27 65903 MYSQL new connection: host=localhost port=0 socket=/tmp/mysql.sock database=vexiBack user=vexBack
  262. 16:03:27 65903 lookup yielded: localdomain.lan
  263. 16:03:27 65903 expanding: $domain
  264. 16:03:27 65903 result: localdomain.lan
  265. 16:03:27 65903 expanding: SELECT DISTINCT alias FROM domainalias WHERE alias = '${quote_mysql:$domain}'
  266. 16:03:27 65903 result: SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'
  267. 16:03:27 65903 search_open: mysql "NULL"
  268. 16:03:27 65903 cached open
  269. 16:03:27 65903 search_find: file="NULL"
  270. 16:03:27 65903 key="SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'" partial=-1 affix=NULL starflags=0
  271. 16:03:27 65903 LRU list:
  272. 16:03:27 65903 internal_search_find: file="NULL"
  273. 16:03:27 65903 type=mysql key="SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'"
  274. 16:03:27 65903 database lookup required for SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'
  275. 16:03:27 65903 MySQL query: SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'
  276. 16:03:27 65903 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  277. 16:03:27 65903 MYSQL: no data found
  278. 16:03:27 65903 lookup failed
  279. 16:03:27 65903 expanding: @ : ${lookup mysql{SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = '${quote_mysql:$domain}'}} : ${lookup mysql{SELECT DISTINCT alias FROM domainalias WHERE alias = '${quote_mysql:$domain}'}}
  280. 16:03:27 65903 result: @ : localdomain.lan :
  281. 16:03:27 65903 localdomain.lan in "@ : localdomain.lan : "? yes (matched "localdomain.lan")
  282. 16:03:27 65903 localdomain.lan in "+local_domains"? yes (matched "+local_domains")
  283. 16:03:27 65903 accept: condition test succeeded in ACL "acl_check_rcpt"
  284. 16:03:27 65903 end of ACL "acl_check_rcpt": ACCEPT
  285. 16:03:27 65903 SMTP>> 250 Accepted
  286. 16:03:29 65903 SMTP<< data
  287. 16:03:29 65903 SMTP>> 354 Enter message, ending with "." on a line by itself
  288. 16:03:29 65903 search_tidyup called
  289. 16:03:29 65903 close MYSQL connection: localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  290. PDKIM >> Hashed body data, canonicalized >>>>>>>>>>>>>>>>>>>>>>>>>>>>>
  291. 16:03:41 65903 host in ignore_fromline_hosts? no (option unset)
  292. 16:03:41 65903 >>Headers received:
  293. 16:03:41 65903 Subject: test with headers_remove I would like to have
  294. 16:03:41 65903
  295. 16:03:41 65903 search_tidyup called
  296. 16:03:41 65903 >>Headers after rewriting and local additions:
  297. 16:03:41 65903 Subject: test with headers_remove I would like to have
  298. 16:03:41 65903
  299. 16:03:49 65903 Data file written for message 1YGrZ3-000H8x-AL
  300. 16:03:49 65903 expanding: ${tod_full}
  301. 16:03:49 65903 result: Thu, 29 Jan 2015 16:03:49 +0000
  302. 16:03:49 65903 condition: def:sender_rcvhost
  303. 16:03:49 65903 result: true
  304. 16:03:49 65903 expanding: from $sender_rcvhost
  305. 16:03:49 65903
  306. 16:03:49 65903 result: from [172.16.0.245] (helo=mailer)
  307. 16:03:49 65903
  308. 16:03:49 65903 condition: def:sender_ident
  309. 16:03:49 65903 result: false
  310. 16:03:49 65903 expanding: $sender_ident
  311. 16:03:49 65903 result:
  312. 16:03:49 65903 skipping: result is not used
  313. 16:03:49 65903 expanding: from ${quote_local_part:$sender_ident}
  314. 16:03:49 65903 result: from
  315. 16:03:49 65903 skipping: result is not used
  316. 16:03:49 65903 condition: def:sender_helo_name
  317. 16:03:49 65903 result: false
  318. 16:03:49 65903 expanding: (helo=$sender_helo_name)
  319. 16:03:49 65903
  320. 16:03:49 65903 result: (helo=)
  321. 16:03:49 65903
  322. 16:03:49 65903 skipping: result is not used
  323. 16:03:49 65903 expanding: ${if def:sender_ident {from ${quote_local_part:$sender_ident} }}${if def:sender_helo_name {(helo=$sender_helo_name)
  324. 16:03:49 65903 }}
  325. 16:03:49 65903 result:
  326. 16:03:49 65903 skipping: result is not used
  327. 16:03:49 65903 condition: def:received_protocol
  328. 16:03:49 65903 result: true
  329. 16:03:49 65903 expanding: with $received_protocol
  330. 16:03:49 65903 result: with esmtp
  331. 16:03:49 65903 condition: def:tls_cipher
  332. 16:03:49 65903 result: false
  333. 16:03:49 65903 expanding: ($tls_cipher)
  334. 16:03:49 65903
  335. 16:03:49 65903 result: ()
  336. 16:03:49 65903
  337. 16:03:49 65903 skipping: result is not used
  338. 16:03:49 65903 condition: def:sender_address
  339. 16:03:49 65903 result: true
  340. 16:03:49 65903 expanding: (envelope-from <$sender_address>)
  341. 16:03:49 65903
  342. 16:03:49 65903 result: (envelope-from <nobody@nowhere.com>)
  343. 16:03:49 65903
  344. 16:03:49 65903 condition: def:received_for
  345. 16:03:49 65903 result: true
  346. 16:03:49 65903 expanding:
  347. 16:03:49 65903 for $received_for
  348. 16:03:49 65903 result:
  349. 16:03:49 65903 for postmaster@localdomain.lan
  350. 16:03:49 65903 expanding: Received: ${if def:sender_rcvhost {from $sender_rcvhost
  351. 16:03:49 65903 }{${if def:sender_ident {from ${quote_local_part:$sender_ident} }}${if def:sender_helo_name {(helo=$sender_helo_name)
  352. 16:03:49 65903 }}}}by $primary_hostname ${if def:received_protocol {with $received_protocol}} ${if def:tls_cipher {($tls_cipher)
  353. 16:03:49 65903 }}(Exim $version_number (FreeBSD))
  354. 16:03:49 65903 ${if def:sender_address {(envelope-from <$sender_address>)
  355. 16:03:49 65903 }}id $message_exim_id${if def:received_for {
  356. 16:03:49 65903 for $received_for}}
  357. 16:03:49 65903 result: Received: from [172.16.0.245] (helo=mailer)
  358. 16:03:49 65903 by mailsrv.localdomain.lan with esmtp (Exim 4.85 (FreeBSD))
  359. 16:03:49 65903 (envelope-from <nobody@nowhere.com>)
  360. 16:03:49 65903 id 1YGrZ3-000H8x-AL
  361. 16:03:49 65903 for postmaster@localdomain.lan
  362. 16:03:49 65903 >>Generated Received: header line
  363. 16:03:49 65903 P Received: from [172.16.0.245] (helo=mailer)
  364. 16:03:49 65903 by mailsrv.localdomain.lan with esmtp (Exim 4.85 (FreeBSD))
  365. 16:03:49 65903 (envelope-from <nobody@nowhere.com>)
  366. 16:03:49 65903 id 1YGrZ3-000H8x-AL
  367. 16:03:49 65903 for postmaster@localdomain.lan; Thu, 29 Jan 2015 16:03:49 +0000
  368. PDKIM <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
  369. 16:03:49 65903 using ACL "acl_check_data"
  370. 16:03:49 65903 processing "accept"
  371. 16:03:49 65903 accept: condition test succeeded in ACL "acl_check_data"
  372. 16:03:49 65903 end of ACL "acl_check_data": ACCEPT
  373. 16:03:49 65903 calling local_scan(); timeout=300
  374. 16:03:49 65903 expanding: $sender_host_address
  375. 16:03:49 65903 result: 172.16.0.245
  376. 16:03:49 65903 expanding: 127.0.0.1
  377. 16:03:49 65903 result: 127.0.0.1
  378. 16:03:49 65903 expanding: $h_X-SA-Do-Not-Run:
  379. 16:03:49 65903 result:
  380. 16:03:49 65903 expanding: Yes
  381. 16:03:49 65903 result: Yes
  382. 16:03:49 65903 condition: and {{def:sender_host_address} {!eq {$sender_host_address}{127.0.0.1}} {!eq {$h_X-SA-Do-Not-Run:}{Yes}} }
  383. 16:03:49 65903 result: true
  384. 16:03:49 65903 expanding: 1
  385. 16:03:49 65903 result: 1
  386. 16:03:49 65903 expanding: 0
  387. 16:03:49 65903 result: 0
  388. 16:03:49 65903 skipping: result is not used
  389. 16:03:49 65903 expanding: ${if and {{def:sender_host_address} {!eq {$sender_host_address}{127.0.0.1}} {!eq {$h_X-SA-Do-Not-Run:}{Yes}} } {1}{0}}
  390. 16:03:49 65903 result: 1
  391. 16:03:49 65903 LOG: MAIN
  392. 16:03:49 65903 SA: Debug: SAEximRunCond expand returned: '1'
  393. 16:03:49 65903 LOG: MAIN
  394. 16:03:49 65903 SA: Debug: check succeeded, running spamc
  395. 16:03:49 65903 LOG: MAIN
  396. 16:03:49 65903 SA: Action: scanned but message isn't spam: score=2.7 required=5.0 (scanned in 0/0 secs | Message-Id: 1YGrZ3-000H8x-AL). From <nobody@nowhere.com> (host=NULL [172.16.0.245]) for postmaster@localdomain.lan
  397. 16:03:49 65903 local_scan() returned 0 NULL
  398. 16:03:49 65903 expanding: ${tod_full}
  399. 16:03:49 65903 result: Thu, 29 Jan 2015 16:03:49 +0000
  400. 16:03:49 65903 Writing spool header file
  401. 16:03:49 65903 Size of headers = 695
  402. 16:03:49 65903 expanding: $h_subject:
  403. 16:03:49 65903 result: test with headers_remove I would like to have
  404. 16:03:49 65903 LOG: MAIN
  405. 16:03:49 65903 <= nobody@nowhere.com H=(mailer) [172.16.0.245] P=esmtp S=739 T="test with headers_remove I would like to have"
  406. 16:03:49 65903 SMTP>> 250 OK id=1YGrZ3-000H8x-AL
  407. 16:03:49 65903 search_tidyup called
  408. 16:03:49 65903 Sender: nobody@nowhere.com
  409. 16:03:49 65903 Recipients:
  410. 16:03:49 65903 postmaster@localdomain.lan
  411. 16:03:49 65903 forked delivery process 65905
  412. 16:03:49 65903 Process 65903 is ready for new message
  413. 16:03:49 65903 smtp_setup_msg entered
  414. 16:03:49 65905 exec /usr/local/sbin/exim -d=0xfffdffff -Mc 1YGrZ3-000H8x-AL
  415. 16:03:49 65905 Exim version 4.85 (FreeBSD 10.1) uid=26 gid=6 pid=65905 D=fffdffff
  416. Probably Berkeley DB version 1.8x (native mode)
  417. Support for: crypteq iconv() use_setclassresources Perl Expand_dlfunc OpenSSL Content_Scanning DKIM Old_Demime PRDR OCSP Experimental_SPF
  418. Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmjz dbmnz dnsdb dsearch mysql
  419. Authenticators: cram_md5 plaintext spa
  420. Routers: accept dnslookup ipliteral manualroute queryprogram redirect
  421. Transports: appendfile/maildir autoreply lmtp pipe smtp
  422. Fixed never_users: 0
  423. Size of off_t: 8
  424. Compiler: CLang [3.4.1 (tags/RELEASE_34/dot1-final 208032)]
  425. Library version: OpenSSL: Compile: OpenSSL 1.0.1k-freebsd 8 Jan 2015
  426. Runtime: OpenSSL 1.0.1k-freebsd 8 Jan 2015
  427. : built on: date not available
  428. Library version: PCRE: Compile: 8.35
  429. Runtime: 8.35 2014-04-04
  430. 16:03:49 65905 Total 12 lookups
  431. Library version: MySQL: Compile: 5.6.22 [Source distribution]
  432. Runtime: 5.6.22
  433. WHITELIST_D_MACROS unset
  434. TRUSTED_CONFIG_LIST unset
  435. 16:03:49 65905 changed uid/gid: forcing real = effective
  436. 16:03:49 65905 uid=0 gid=6 pid=65905
  437. 16:03:49 65905 auxiliary group list: 6
  438. 16:03:49 65905 seeking password data for user "mailnull": using cached result
  439. 16:03:49 65905 getpwnam() succeeded uid=26 gid=26
  440. 16:03:49 65905 seeking password data for user "www": cache not available
  441. 16:03:49 65905 getpwnam() succeeded uid=80 gid=80
  442. 16:03:49 65905 seeking password data for user "mailnull": cache not available
  443. 16:03:49 65905 getpwnam() succeeded uid=26 gid=26
  444. 16:03:49 65905 seeking password data for user "root": cache not available
  445. 16:03:49 65905 getpwnam() succeeded uid=0 gid=0
  446. 16:03:49 65906 changed uid/gid: calling tls_validate_require_cipher
  447. 16:03:49 65906 uid=26 gid=6 pid=65906
  448. 16:03:49 65906 auxiliary group list: 6
  449. 16:03:49 65905 tls_validate_require_cipher child 65906 ended: status=0x0
  450. 16:03:49 65905 configuration file is /usr/local/etc/exim/configure
  451. 16:03:49 65905 log selectors = 00000ffc 002b2001
  452. 16:03:49 65905 cwd=/RWs/var/spool/exim 4 args: /usr/local/sbin/exim -d=0xfffdffff -Mc 1YGrZ3-000H8x-AL
  453. 16:03:49 65905 trusted user
  454. 16:03:49 65905 admin user
  455. 16:03:49 65905 seeking password data for user "mailnull": cache not available
  456. 16:03:49 65905 getpwnam() succeeded uid=26 gid=26
  457. 16:03:49 65905 seeking password data for user "mailnull": using cached result
  458. 16:03:49 65905 getpwnam() succeeded uid=26 gid=26
  459. 16:03:49 65905 set_process_info: 65905 delivering specified messages
  460. 16:03:49 65905 set_process_info: 65905 delivering 1YGrZ3-000H8x-AL
  461. 16:03:49 65905 reading spool file 1YGrZ3-000H8x-AL-H
  462. 16:03:49 65905 user=mailnull uid=26 gid=6 sender=nobody@nowhere.com
  463. 16:03:49 65905 sender_fullhost = (mailer) [172.16.0.245]
  464. 16:03:49 65905 sender_rcvhost = [172.16.0.245] (helo=mailer)
  465. 16:03:49 65905 sender_local=0 ident=unset
  466. 16:03:49 65905 Non-recipients:
  467. 16:03:49 65905 Empty Tree
  468. 16:03:49 65905 ---- End of tree ----
  469. 16:03:49 65905 recipients_count=1
  470. 16:03:49 65905 body_linecount=1 message_linecount=16
  471. 16:03:49 65905 Delivery address list:
  472. 16:03:49 65905 postmaster@localdomain.lan
  473. 16:03:49 65905 locking /var/spool/exim/db/retry.lockfile
  474. 16:03:49 65905 locked /var/spool/exim/db/retry.lockfile
  475. 16:03:49 65905 EXIM_DBOPEN(/var/spool/exim/db/retry)
  476. 16:03:49 65905 returned from EXIM_DBOPEN
  477. 16:03:49 65905 opened hints database /var/spool/exim/db/retry: flags=O_RDONLY
  478. 16:03:49 65905 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
  479. 16:03:49 65905 Considering: postmaster@localdomain.lan
  480. 16:03:49 65905 unique = postmaster@localdomain.lan
  481. 16:03:49 65905 dbfn_read: key=R:localdomain.lan
  482. 16:03:49 65905 dbfn_read: key=R:postmaster@localdomain.lan
  483. 16:03:49 65905 dbfn_read: key=R:postmaster@localdomain.lan:<nobody@nowhere.com>
  484. 16:03:49 65905 no domain retry record
  485. 16:03:49 65905 no address retry record
  486. 16:03:49 65905 postmaster@localdomain.lan: queued for routing
  487. 16:03:49 65905 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
  488. 16:03:49 65905 routing postmaster@localdomain.lan
  489. 16:03:49 65905 --------> send_to_hub router <--------
  490. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  491. 16:03:49 65905 checking domains
  492. 16:03:49 65905 expanding: $domain
  493. 16:03:49 65905 result: localdomain.lan
  494. 16:03:49 65905 expanding: SELECT DISTINCT domain FROM domains WHERE type = 'forward' AND domain = '${quote_mysql:$domain}'
  495. 16:03:49 65905 result: SELECT DISTINCT domain FROM domains WHERE type = 'forward' AND domain = 'localdomain.lan'
  496. 16:03:49 65905 search_open: mysql "NULL"
  497. 16:03:49 65905 search_find: file="NULL"
  498. 16:03:49 65905 key="SELECT DISTINCT domain FROM domains WHERE type = 'forward' AND domain = 'localdomain.lan'" partial=-1 affix=NULL starflags=0
  499. 16:03:49 65905 LRU list:
  500. 16:03:49 65905 internal_search_find: file="NULL"
  501. 16:03:49 65905 type=mysql key="SELECT DISTINCT domain FROM domains WHERE type = 'forward' AND domain = 'localdomain.lan'"
  502. 16:03:49 65905 database lookup required for SELECT DISTINCT domain FROM domains WHERE type = 'forward' AND domain = 'localdomain.lan'
  503. 16:03:49 65905 MySQL query: SELECT DISTINCT domain FROM domains WHERE type = 'forward' AND domain = 'localdomain.lan'
  504. 16:03:49 65905 MYSQL new connection: host=localhost port=0 socket=/tmp/mysql.sock database=vexiBack user=vexBack
  505. 16:03:49 65905 MYSQL: no data found
  506. 16:03:49 65905 lookup failed
  507. 16:03:49 65905 expanding: ${lookup mysql{SELECT DISTINCT domain FROM domains WHERE type = 'forward' AND domain = '${quote_mysql:$domain}'}}
  508. 16:03:49 65905 result:
  509. 16:03:49 65905 localdomain.lan in ""? no (end of list)
  510. 16:03:49 65905 localdomain.lan in "+fwd_domains"? no (end of list)
  511. 16:03:49 65905 send_to_hub router skipped: domains mismatch
  512. 16:03:49 65905 --------> disclaimers router <--------
  513. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  514. 16:03:49 65905 checking domains
  515. 16:03:49 65905 expanding: $domain
  516. 16:03:49 65905 result: localdomain.lan
  517. 16:03:49 65905 expanding: SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = '${quote_mysql:$domain}'
  518. 16:03:49 65905 result: SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'
  519. 16:03:49 65905 search_open: mysql "NULL"
  520. 16:03:49 65905 cached open
  521. 16:03:49 65905 search_find: file="NULL"
  522. 16:03:49 65905 key="SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'" partial=-1 affix=NULL starflags=0
  523. 16:03:49 65905 LRU list:
  524. 16:03:49 65905 internal_search_find: file="NULL"
  525. 16:03:49 65905 type=mysql key="SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'"
  526. 16:03:49 65905 database lookup required for SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'
  527. 16:03:49 65905 MySQL query: SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'
  528. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  529. 16:03:49 65905 lookup yielded: localdomain.lan
  530. 16:03:49 65905 expanding: $domain
  531. 16:03:49 65905 result: localdomain.lan
  532. 16:03:49 65905 expanding: SELECT DISTINCT alias FROM domainalias WHERE alias = '${quote_mysql:$domain}'
  533. 16:03:49 65905 result: SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'
  534. 16:03:49 65905 search_open: mysql "NULL"
  535. 16:03:49 65905 cached open
  536. 16:03:49 65905 search_find: file="NULL"
  537. 16:03:49 65905 key="SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'" partial=-1 affix=NULL starflags=0
  538. 16:03:49 65905 LRU list:
  539. 16:03:49 65905 internal_search_find: file="NULL"
  540. 16:03:49 65905 type=mysql key="SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'"
  541. 16:03:49 65905 database lookup required for SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'
  542. 16:03:49 65905 MySQL query: SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'
  543. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  544. 16:03:49 65905 MYSQL: no data found
  545. 16:03:49 65905 lookup failed
  546. 16:03:49 65905 expanding: @ : ${lookup mysql{SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = '${quote_mysql:$domain}'}} : ${lookup mysql{SELECT DISTINCT alias FROM domainalias WHERE alias = '${quote_mysql:$domain}'}}
  547. 16:03:49 65905 result: @ : localdomain.lan :
  548. 16:03:49 65905 localdomain.lan in "@ : localdomain.lan : "? yes (matched "localdomain.lan")
  549. 16:03:49 65905 localdomain.lan in "! +local_domains"? no (matched "! +local_domains")
  550. 16:03:49 65905 disclaimers router skipped: domains mismatch
  551. 16:03:49 65905 --------> dnslookup router <--------
  552. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  553. 16:03:49 65905 checking domains
  554. 16:03:49 65905 expanding: $domain
  555. 16:03:49 65905 result: localdomain.lan
  556. 16:03:49 65905 expanding: SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = '${quote_mysql:$domain}'
  557. 16:03:49 65905 result: SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'
  558. 16:03:49 65905 search_open: mysql "NULL"
  559. 16:03:49 65905 cached open
  560. 16:03:49 65905 search_find: file="NULL"
  561. 16:03:49 65905 key="SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'" partial=-1 affix=NULL starflags=0
  562. 16:03:49 65905 LRU list:
  563. 16:03:49 65905 internal_search_find: file="NULL"
  564. 16:03:49 65905 type=mysql key="SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'"
  565. 16:03:49 65905 cached data used for lookup of SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = 'localdomain.lan'
  566. 16:03:49 65905 lookup yielded: localdomain.lan
  567. 16:03:49 65905 expanding: $domain
  568. 16:03:49 65905 result: localdomain.lan
  569. 16:03:49 65905 expanding: SELECT DISTINCT alias FROM domainalias WHERE alias = '${quote_mysql:$domain}'
  570. 16:03:49 65905 result: SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'
  571. 16:03:49 65905 search_open: mysql "NULL"
  572. 16:03:49 65905 cached open
  573. 16:03:49 65905 search_find: file="NULL"
  574. 16:03:49 65905 key="SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'" partial=-1 affix=NULL starflags=0
  575. 16:03:49 65905 LRU list:
  576. 16:03:49 65905 internal_search_find: file="NULL"
  577. 16:03:49 65905 type=mysql key="SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'"
  578. 16:03:49 65905 cached data used for lookup of SELECT DISTINCT alias FROM domainalias WHERE alias = 'localdomain.lan'
  579. 16:03:49 65905 lookup failed
  580. 16:03:49 65905 expanding: @ : ${lookup mysql{SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1' AND domain = '${quote_mysql:$domain}'}} : ${lookup mysql{SELECT DISTINCT alias FROM domainalias WHERE alias = '${quote_mysql:$domain}'}}
  581. 16:03:49 65905 result: @ : localdomain.lan :
  582. 16:03:49 65905 localdomain.lan in "@ : localdomain.lan : "? yes (matched "localdomain.lan")
  583. 16:03:49 65905 localdomain.lan in "! +local_domains"? no (matched "! +local_domains")
  584. 16:03:49 65905 dnslookup router skipped: domains mismatch
  585. 16:03:49 65905 --------> mailman_router router <--------
  586. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  587. 16:03:49 65905 checking require_files
  588. 16:03:49 65905 expanding: /usr/local/mailman/lists/$local_part/config.pck
  589. 16:03:49 65905 result: /usr/local/mailman/lists/postmaster/config.pck
  590. 16:03:49 65905 file check: /usr/local/mailman/lists/$local_part/config.pck
  591. 16:03:49 65905 expanded file: /usr/local/mailman/lists/postmaster/config.pck
  592. 16:03:49 65905 stat() yielded -1
  593. 16:03:49 65905 errno = 2
  594. 16:03:49 65905 mailman_router router skipped: file check
  595. 16:03:49 65905 --------> ditch_maxmsgsize router <--------
  596. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  597. 16:03:49 65905 checking "condition"
  598. 16:03:49 65905 expanding: NULL
  599. 16:03:49 65905 result: NULL
  600. 16:03:49 65905 considering bool_lax: NULL
  601. 16:03:49 65905 expanding: $message_size
  602. 16:03:49 65905 result: 739
  603. 16:03:49 65905 expanding: $local_part
  604. 16:03:49 65905 result: postmaster
  605. 16:03:49 65905 expanding: $domain
  606. 16:03:49 65905 result: localdomain.lan
  607. 16:03:49 65905 expanding: select users.maxmsgsize from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.maxmsgsize > 0 and users.domain_id=domains.domain_id
  608. 16:03:49 65905 result: select users.maxmsgsize from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.maxmsgsize > 0 and users.domain_id=domains.domain_id
  609. 16:03:49 65905 search_open: mysql "NULL"
  610. 16:03:49 65905 cached open
  611. 16:03:49 65905 search_find: file="NULL"
  612. 16:03:49 65905 key="select users.maxmsgsize from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.maxmsgsize > 0 and users.domain_id=domains.domain_id " partial=-1 affix=NULL starflags=0
  613. 16:03:49 65905 LRU list:
  614. 16:03:49 65905 internal_search_find: file="NULL"
  615. 16:03:49 65905 type=mysql key="select users.maxmsgsize from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.maxmsgsize > 0 and users.domain_id=domains.domain_id "
  616. 16:03:49 65905 database lookup required for select users.maxmsgsize from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.maxmsgsize > 0 and users.domain_id=domains.domain_id
  617. 16:03:49 65905 MySQL query: select users.maxmsgsize from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.maxmsgsize > 0 and users.domain_id=domains.domain_id
  618. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  619. 16:03:49 65905 MYSQL: no data found
  620. 16:03:49 65905 lookup failed
  621. 16:03:49 65905 expanding: ${value}K
  622. 16:03:49 65905 result: K
  623. 16:03:49 65905 skipping: result is not used
  624. 16:03:49 65905 failed to expand: ${lookup mysql{select users.maxmsgsize from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.maxmsgsize > 0 and users.domain_id=domains.domain_id }{${value}K}fail}} {yes}{no}}}}}}
  625. 16:03:49 65905 error message: "lookup" failed and "fail" requested
  626. 16:03:49 65905 failure was forced
  627. 16:03:49 65905 failed to expand: ${if >{$message_size}{${lookup mysql{select users.maxmsgsize from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.maxmsgsize > 0 and users.domain_id=domains.domain_id }{${value}K}fail}} {yes}{no}}}}}}
  628. 16:03:49 65905 error message: "lookup" failed and "fail" requested
  629. 16:03:49 65905 failure was forced
  630. 16:03:49 65905 failed to expand: ${if and{{bool_lax{NULL}}{bool_lax{${if >{$message_size}{${lookup mysql{select users.maxmsgsize from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.maxmsgsize > 0 and users.domain_id=domains.domain_id }{${value}K}fail}} {yes}{no}}}}}}
  631. 16:03:49 65905 error message: "lookup" failed and "fail" requested inside "and{...}" condition
  632. 16:03:49 65905 failure was forced
  633. 16:03:49 65905 ditch_maxmsgsize router skipped: condition failure
  634. 16:03:49 65905 --------> ditch_malware router <--------
  635. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  636. 16:03:49 65905 checking "condition"
  637. 16:03:49 65905 expanding: NULL
  638. 16:03:49 65905 result: NULL
  639. 16:03:49 65905 considering bool_lax: NULL
  640. 16:03:49 65905 expanding: $h_X-ACL-Warn:
  641. 16:03:49 65905 result:
  642. 16:03:49 65905 expanding: .*malware.*
  643. 16:03:49 65905 result: .*malware.*
  644. 16:03:49 65905 expanding: $local_part
  645. 16:03:49 65905 result:
  646. 16:03:49 65905 skipping: result is not used
  647. 16:03:49 65905 expanding: $domain
  648. 16:03:49 65905 result:
  649. 16:03:49 65905 skipping: result is not used
  650. 16:03:49 65905 expanding: select users.on_avscan from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_avscan = '1' and users.domain_id=domains.domain_id
  651. 16:03:49 65905 result: select users.on_avscan from users,domains where localpart = '' and domain = '' and users.on_avscan = '1' and users.domain_id=domains.domain_id
  652. 16:03:49 65905 skipping: result is not used
  653. 16:03:49 65905 expanding: ${lookup mysql{select users.on_avscan from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_avscan = '1' and users.domain_id=domains.domain_id}}
  654. 16:03:49 65905 result:
  655. 16:03:49 65905 skipping: result is not used
  656. 16:03:49 65905 expanding: 1
  657. 16:03:49 65905 result: 1
  658. 16:03:49 65905 skipping: result is not used
  659. 16:03:49 65905 condition: and { {match {$h_X-ACL-Warn:}{.*malware.*}} {eq {${lookup mysql{select users.on_avscan from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_avscan = '1' and users.domain_id=domains.domain_id}}}{1} }}
  660. 16:03:49 65905 result: false
  661. 16:03:49 65905 expanding: yes
  662. 16:03:49 65905 result: yes
  663. 16:03:49 65905 skipping: result is not used
  664. 16:03:49 65905 expanding: no
  665. 16:03:49 65905 result: no
  666. 16:03:49 65905 expanding: ${if and { {match {$h_X-ACL-Warn:}{.*malware.*}} {eq {${lookup mysql{select users.on_avscan from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_avscan = '1' and users.domain_id=domains.domain_id}}}{1} }} {yes}{no} }
  667. 16:03:49 65905 result: no
  668. 16:03:49 65905 considering bool_lax: no
  669. 16:03:49 65905 condition: and{{bool_lax{NULL}}{bool_lax{${if and { {match {$h_X-ACL-Warn:}{.*malware.*}} {eq {${lookup mysql{select users.on_avscan from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_avscan = '1' and users.domain_id=domains.domain_id}}}{1} }} {yes}{no} }}}}
  670. 16:03:49 65905 result: false
  671. 16:03:49 65905 expanding: ${if and{{bool_lax{NULL}}{bool_lax{${if and { {match {$h_X-ACL-Warn:}{.*malware.*}} {eq {${lookup mysql{select users.on_avscan from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_avscan = '1' and users.domain_id=domains.domain_id}}}{1} }} {yes}{no} }}}}}
  672. 16:03:49 65905 result:
  673. 16:03:49 65905 ditch_malware router skipped: condition failure
  674. 16:03:49 65905 --------> ditch_spam router <--------
  675. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  676. 16:03:49 65905 checking "condition"
  677. 16:03:49 65905 expanding: NULL
  678. 16:03:49 65905 result: NULL
  679. 16:03:49 65905 considering bool_lax: NULL
  680. 16:03:49 65905 expanding: $spam_score_int
  681. 16:03:49 65905 result:
  682. 16:03:49 65905 empty string cast to zero for numerical comparison
  683. 16:03:49 65905 expanding: $local_part
  684. 16:03:49 65905 result: postmaster
  685. 16:03:49 65905 expanding: $domain
  686. 16:03:49 65905 result: localdomain.lan
  687. 16:03:49 65905 expanding: select users.sa_refuse * 10 from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0
  688. 16:03:49 65905 result: select users.sa_refuse * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0
  689. 16:03:49 65905 search_open: mysql "NULL"
  690. 16:03:49 65905 cached open
  691. 16:03:49 65905 search_find: file="NULL"
  692. 16:03:49 65905 key="select users.sa_refuse * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0 " partial=-1 affix=NULL starflags=0
  693. 16:03:49 65905 LRU list:
  694. 16:03:49 65905 internal_search_find: file="NULL"
  695. 16:03:49 65905 type=mysql key="select users.sa_refuse * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0 "
  696. 16:03:49 65905 database lookup required for select users.sa_refuse * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0
  697. 16:03:49 65905 MySQL query: select users.sa_refuse * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0
  698. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  699. 16:03:49 65905 MYSQL: no data found
  700. 16:03:49 65905 lookup failed
  701. 16:03:49 65905 expanding: $value
  702. 16:03:49 65905 result:
  703. 16:03:49 65905 skipping: result is not used
  704. 16:03:49 65905 failed to expand: ${lookup mysql{select users.sa_refuse * 10 from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0 }{$value}fail}} {yes}{no}}}}}}
  705. 16:03:49 65905 error message: "lookup" failed and "fail" requested
  706. 16:03:49 65905 failure was forced
  707. 16:03:49 65905 failed to expand: ${if >{$spam_score_int}{${lookup mysql{select users.sa_refuse * 10 from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0 }{$value}fail}} {yes}{no}}}}}}
  708. 16:03:49 65905 error message: "lookup" failed and "fail" requested
  709. 16:03:49 65905 failure was forced
  710. 16:03:49 65905 failed to expand: ${if and{{bool_lax{NULL}}{bool_lax{${if >{$spam_score_int}{${lookup mysql{select users.sa_refuse * 10 from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0 }{$value}fail}} {yes}{no}}}}}}
  711. 16:03:49 65905 error message: "lookup" failed and "fail" requested inside "and{...}" condition
  712. 16:03:49 65905 failure was forced
  713. 16:03:49 65905 ditch_spam router skipped: condition failure
  714. 16:03:49 65905 --------> ditch_hdrmailer router <--------
  715. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  716. 16:03:49 65905 checking "condition"
  717. 16:03:49 65905 expanding: NULL
  718. 16:03:49 65905 result: NULL
  719. 16:03:49 65905 considering bool_lax: NULL
  720. 16:03:49 65905 expanding: $h_x-mailer:
  721. 16:03:49 65905 result:
  722. 16:03:49 65905 expanding: $local_part
  723. 16:03:49 65905 result: postmaster
  724. 16:03:49 65905 expanding: $domain
  725. 16:03:49 65905 result: localdomain.lan
  726. 16:03:49 65905 expanding: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '${quote_mysql:$h_x-mailer:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  727. 16:03:49 65905 result: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  728. 16:03:49 65905 search_open: mysql "NULL"
  729. 16:03:49 65905 cached open
  730. 16:03:49 65905 search_find: file="NULL"
  731. 16:03:49 65905 key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
  732. 16:03:49 65905 LRU list:
  733. 16:03:49 65905 internal_search_find: file="NULL"
  734. 16:03:49 65905 type=mysql key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id"
  735. 16:03:49 65905 database lookup required for select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  736. 16:03:49 65905 MySQL query: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  737. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  738. 16:03:49 65905 lookup yielded: 0
  739. 16:03:49 65905 expanding: ${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '${quote_mysql:$h_x-mailer:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}
  740. 16:03:49 65905 result: 0
  741. 16:03:49 65905 expanding: 1
  742. 16:03:49 65905 result: 1
  743. 16:03:49 65905 condition: eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '${quote_mysql:$h_x-mailer:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1}
  744. 16:03:49 65905 result: false
  745. 16:03:49 65905 expanding: yes
  746. 16:03:49 65905 result: yes
  747. 16:03:49 65905 skipping: result is not used
  748. 16:03:49 65905 expanding: no
  749. 16:03:49 65905 result: no
  750. 16:03:49 65905 expanding: ${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '${quote_mysql:$h_x-mailer:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}
  751. 16:03:49 65905 result: no
  752. 16:03:49 65905 considering bool_lax: no
  753. 16:03:49 65905 condition: and{{bool_lax{NULL}}{bool_lax{${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '${quote_mysql:$h_x-mailer:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}}}}
  754. 16:03:49 65905 result: false
  755. 16:03:49 65905 expanding: ${if and{{bool_lax{NULL}}{bool_lax{${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '${quote_mysql:$h_x-mailer:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}}}}}
  756. 16:03:49 65905 result:
  757. 16:03:49 65905 ditch_hdrmailer router skipped: condition failure
  758. 16:03:49 65905 --------> ditch_hdrto router <--------
  759. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  760. 16:03:49 65905 checking "condition"
  761. 16:03:49 65905 expanding: NULL
  762. 16:03:49 65905 result: NULL
  763. 16:03:49 65905 considering bool_lax: NULL
  764. 16:03:49 65905 expanding: $h_to:
  765. 16:03:49 65905 result:
  766. 16:03:49 65905 expanding: $local_part
  767. 16:03:49 65905 result: postmaster
  768. 16:03:49 65905 expanding: $domain
  769. 16:03:49 65905 result: localdomain.lan
  770. 16:03:49 65905 expanding: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '${quote_mysql:$h_to:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  771. 16:03:49 65905 result: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  772. 16:03:49 65905 search_open: mysql "NULL"
  773. 16:03:49 65905 cached open
  774. 16:03:49 65905 search_find: file="NULL"
  775. 16:03:49 65905 key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
  776. 16:03:49 65905 LRU list:
  777. 16:03:49 65905 internal_search_find: file="NULL"
  778. 16:03:49 65905 type=mysql key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id"
  779. 16:03:49 65905 database lookup required for select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  780. 16:03:49 65905 MySQL query: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  781. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  782. 16:03:49 65905 lookup yielded: 0
  783. 16:03:49 65905 expanding: ${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '${quote_mysql:$h_to:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}
  784. 16:03:49 65905 result: 0
  785. 16:03:49 65905 expanding: 1
  786. 16:03:49 65905 result: 1
  787. 16:03:49 65905 condition: eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '${quote_mysql:$h_to:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1}
  788. 16:03:49 65905 result: false
  789. 16:03:49 65905 expanding: yes
  790. 16:03:49 65905 result: yes
  791. 16:03:49 65905 skipping: result is not used
  792. 16:03:49 65905 expanding: no
  793. 16:03:49 65905 result: no
  794. 16:03:49 65905 expanding: ${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '${quote_mysql:$h_to:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}
  795. 16:03:49 65905 result: no
  796. 16:03:49 65905 considering bool_lax: no
  797. 16:03:49 65905 condition: and{{bool_lax{NULL}}{bool_lax{${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '${quote_mysql:$h_to:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}}}}
  798. 16:03:49 65905 result: false
  799. 16:03:49 65905 expanding: ${if and{{bool_lax{NULL}}{bool_lax{${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '${quote_mysql:$h_to:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}}}}}
  800. 16:03:49 65905 result:
  801. 16:03:49 65905 ditch_hdrto router skipped: condition failure
  802. 16:03:49 65905 --------> ditch_hdrfrom router <--------
  803. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  804. 16:03:49 65905 checking "condition"
  805. 16:03:49 65905 expanding: NULL
  806. 16:03:49 65905 result: NULL
  807. 16:03:49 65905 considering bool_lax: NULL
  808. 16:03:49 65905 expanding: $h_from:
  809. 16:03:49 65905 result:
  810. 16:03:49 65905 expanding: $local_part
  811. 16:03:49 65905 result: postmaster
  812. 16:03:49 65905 expanding: $domain
  813. 16:03:49 65905 result: localdomain.lan
  814. 16:03:49 65905 expanding: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '${quote_mysql:$h_from:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  815. 16:03:49 65905 result: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  816. 16:03:49 65905 search_open: mysql "NULL"
  817. 16:03:49 65905 cached open
  818. 16:03:49 65905 search_find: file="NULL"
  819. 16:03:49 65905 key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
  820. 16:03:49 65905 LRU list:
  821. 16:03:49 65905 internal_search_find: file="NULL"
  822. 16:03:49 65905 type=mysql key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id"
  823. 16:03:49 65905 database lookup required for select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  824. 16:03:49 65905 MySQL query: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  825. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  826. 16:03:49 65905 lookup yielded: 0
  827. 16:03:49 65905 expanding: ${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '${quote_mysql:$h_from:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}
  828. 16:03:49 65905 result: 0
  829. 16:03:49 65905 expanding: 1
  830. 16:03:49 65905 result: 1
  831. 16:03:49 65905 condition: eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '${quote_mysql:$h_from:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1}
  832. 16:03:49 65905 result: false
  833. 16:03:49 65905 expanding: yes
  834. 16:03:49 65905 result: yes
  835. 16:03:49 65905 skipping: result is not used
  836. 16:03:49 65905 expanding: no
  837. 16:03:49 65905 result: no
  838. 16:03:49 65905 expanding: ${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '${quote_mysql:$h_from:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}
  839. 16:03:49 65905 result: no
  840. 16:03:49 65905 considering bool_lax: no
  841. 16:03:49 65905 condition: and{{bool_lax{NULL}}{bool_lax{${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '${quote_mysql:$h_from:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}}}}
  842. 16:03:49 65905 result: false
  843. 16:03:49 65905 expanding: ${if and{{bool_lax{NULL}}{bool_lax{${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '${quote_mysql:$h_from:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}}}}}
  844. 16:03:49 65905 result:
  845. 16:03:49 65905 ditch_hdrfrom router skipped: condition failure
  846. 16:03:49 65905 --------> ditch_hdrsubject router <--------
  847. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  848. 16:03:49 65905 checking "condition"
  849. 16:03:49 65905 expanding: NULL
  850. 16:03:49 65905 result: NULL
  851. 16:03:49 65905 considering bool_lax: NULL
  852. 16:03:49 65905 expanding: $h_subject:
  853. 16:03:49 65905 result: test with headers_remove I would like to have
  854. 16:03:49 65905 expanding: $local_part
  855. 16:03:49 65905 result: postmaster
  856. 16:03:49 65905 expanding: $domain
  857. 16:03:49 65905 result: localdomain.lan
  858. 16:03:49 65905 expanding: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = '${quote_mysql:$h_subject:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  859. 16:03:49 65905 result: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = 'test with headers_remove I would like to have' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  860. 16:03:49 65905 search_open: mysql "NULL"
  861. 16:03:49 65905 cached open
  862. 16:03:49 65905 search_find: file="NULL"
  863. 16:03:49 65905 key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = 'test with headers_remove I would like to have' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
  864. 16:03:49 65905 LRU list:
  865. 16:03:49 65905 internal_search_find: file="NULL"
  866. 16:03:49 65905 type=mysql key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = 'test with headers_remove I would like to have' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id"
  867. 16:03:49 65905 database lookup required for select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = 'test with headers_remove I would like to have' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  868. 16:03:49 65905 MySQL query: select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = 'test with headers_remove I would like to have' and users.localpart = 'postmaster' and domains.domain = 'localdomain.lan' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id
  869. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  870. 16:03:49 65905 lookup yielded: 0
  871. 16:03:49 65905 expanding: ${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = '${quote_mysql:$h_subject:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}
  872. 16:03:49 65905 result: 0
  873. 16:03:49 65905 expanding: 1
  874. 16:03:49 65905 result: 1
  875. 16:03:49 65905 condition: eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = '${quote_mysql:$h_subject:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1}
  876. 16:03:49 65905 result: false
  877. 16:03:49 65905 expanding: yes
  878. 16:03:49 65905 result: yes
  879. 16:03:49 65905 skipping: result is not used
  880. 16:03:49 65905 expanding: no
  881. 16:03:49 65905 result: no
  882. 16:03:49 65905 expanding: ${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = '${quote_mysql:$h_subject:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}
  883. 16:03:49 65905 result: no
  884. 16:03:49 65905 considering bool_lax: no
  885. 16:03:49 65905 condition: and{{bool_lax{NULL}}{bool_lax{${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = '${quote_mysql:$h_subject:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}}}}
  886. 16:03:49 65905 result: false
  887. 16:03:49 65905 expanding: ${if and{{bool_lax{NULL}}{bool_lax{${if eq {${lookup mysql{select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = '${quote_mysql:$h_subject:}' and users.localpart = '${quote_mysql:$local_part}' and domains.domain = '${quote_mysql:$domain}' and domains.domain_id=blocklists.domain_id and users.user_id=blocklists.user_id}}}{1} {yes}{no}}}}}}
  888. 16:03:49 65905 result:
  889. 16:03:49 65905 ditch_hdrsubject router skipped: condition failure
  890. 16:03:49 65905 --------> virtual_vacation router <--------
  891. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  892. 16:03:49 65905 checking senders
  893. 16:03:49 65905 address match test: subject=nobody@nowhere.com pattern=^.*-request@.*
  894. 16:03:49 65905 address match test: subject=nobody@nowhere.com pattern=^bounce-.*@.*
  895. 16:03:49 65905 address match test: subject=nobody@nowhere.com pattern=^.*-bounce@.*
  896. 16:03:49 65905 address match test: subject=nobody@nowhere.com pattern=^owner-.*@.*
  897. 16:03:49 65905 address match test: subject=nobody@nowhere.com pattern=^postmaster@.*
  898. 16:03:49 65905 address match test: subject=nobody@nowhere.com pattern=^webmaster@.*
  899. 16:03:49 65905 address match test: subject=nobody@nowhere.com pattern=^listmaster@.*
  900. 16:03:49 65905 address match test: subject=nobody@nowhere.com pattern=^mailer-daemon@.*
  901. 16:03:49 65905 address match test: subject=nobody@nowhere.com pattern=^root@.*
  902. 16:03:49 65905 nobody@nowhere.com in "! ^.*-request@.*:! ^bounce-.*@.*:! ^.*-bounce@.*:! ^owner-.*@.*:! ^postmaster@.*:! ^webmaster@.*:! ^listmaster@.*:! ^mailer-daemon@.*:! ^root@.*"? yes (end of list)
  903. 16:03:49 65905 checking "condition"
  904. 16:03:49 65905 expanding: NULL
  905. 16:03:49 65905 result: NULL
  906. 16:03:49 65905 considering bool_lax: NULL
  907. 16:03:49 65905 expanding: $h_precedence:
  908. 16:03:49 65905 result:
  909. 16:03:49 65905 expanding: (?i)junk|bulk|list
  910. 16:03:49 65905 result: (?i)junk|bulk|list
  911. 16:03:49 65905 expanding: $local_part
  912. 16:03:49 65905 result: postmaster
  913. 16:03:49 65905 expanding: $domain
  914. 16:03:49 65905 result: localdomain.lan
  915. 16:03:49 65905 expanding: select users.on_vacation from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_vacation = '1' and users.domain_id=domains.domain_id
  916. 16:03:49 65905 result: select users.on_vacation from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_vacation = '1' and users.domain_id=domains.domain_id
  917. 16:03:49 65905 search_open: mysql "NULL"
  918. 16:03:49 65905 cached open
  919. 16:03:49 65905 search_find: file="NULL"
  920. 16:03:49 65905 key="select users.on_vacation from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_vacation = '1' and users.domain_id=domains.domain_id" partial=-1 affix=NULL starflags=0
  921. 16:03:49 65905 LRU list:
  922. 16:03:49 65905 internal_search_find: file="NULL"
  923. 16:03:49 65905 type=mysql key="select users.on_vacation from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_vacation = '1' and users.domain_id=domains.domain_id"
  924. 16:03:49 65905 database lookup required for select users.on_vacation from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_vacation = '1' and users.domain_id=domains.domain_id
  925. 16:03:49 65905 MySQL query: select users.on_vacation from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_vacation = '1' and users.domain_id=domains.domain_id
  926. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  927. 16:03:49 65905 MYSQL: no data found
  928. 16:03:49 65905 lookup failed
  929. 16:03:49 65905 expanding: ${lookup mysql{select users.on_vacation from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_vacation = '1' and users.domain_id=domains.domain_id}}
  930. 16:03:49 65905 result:
  931. 16:03:49 65905 expanding: 1
  932. 16:03:49 65905 result: 1
  933. 16:03:49 65905 condition: and { {!match {$h_precedence:}{(?i)junk|bulk|list}} {eq {${lookup mysql{select users.on_vacation from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_vacation = '1' and users.domain_id=domains.domain_id}}}{1} }}
  934. 16:03:49 65905 result: false
  935. 16:03:49 65905 expanding: yes
  936. 16:03:49 65905 result: yes
  937. 16:03:49 65905 skipping: result is not used
  938. 16:03:49 65905 expanding: no
  939. 16:03:49 65905 result: no
  940. 16:03:49 65905 expanding: ${if and { {!match {$h_precedence:}{(?i)junk|bulk|list}} {eq {${lookup mysql{select users.on_vacation from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_vacation = '1' and users.domain_id=domains.domain_id}}}{1} }} {yes}{no} }
  941. 16:03:49 65905 result: no
  942. 16:03:49 65905 considering bool_lax: no
  943. 16:03:49 65905 condition: and{{bool_lax{NULL}}{bool_lax{${if and { {!match {$h_precedence:}{(?i)junk|bulk|list}} {eq {${lookup mysql{select users.on_vacation from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_vacation = '1' and users.domain_id=domains.domain_id}}}{1} }} {yes}{no} }}}}
  944. 16:03:49 65905 result: false
  945. 16:03:49 65905 expanding: ${if and{{bool_lax{NULL}}{bool_lax{${if and { {!match {$h_precedence:}{(?i)junk|bulk|list}} {eq {${lookup mysql{select users.on_vacation from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_vacation = '1' and users.domain_id=domains.domain_id}}}{1} }} {yes}{no} }}}}}
  946. 16:03:49 65905 result:
  947. 16:03:49 65905 virtual_vacation router skipped: condition failure
  948. 16:03:49 65905 --------> virtual_forward router <--------
  949. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  950. 16:03:49 65905 checking "condition"
  951. 16:03:49 65905 expanding: NULL
  952. 16:03:49 65905 result: NULL
  953. 16:03:49 65905 considering bool_lax: NULL
  954. 16:03:49 65905 expanding: $h_precedence:
  955. 16:03:49 65905 result:
  956. 16:03:49 65905 expanding: (?i)junk
  957. 16:03:49 65905 result: (?i)junk
  958. 16:03:49 65905 expanding: $local_part
  959. 16:03:49 65905 result: postmaster
  960. 16:03:49 65905 expanding: $domain
  961. 16:03:49 65905 result: localdomain.lan
  962. 16:03:49 65905 expanding: select users.on_forward from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_forward = '1' and users.domain_id=domains.domain_id
  963. 16:03:49 65905 result: select users.on_forward from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_forward = '1' and users.domain_id=domains.domain_id
  964. 16:03:49 65905 search_open: mysql "NULL"
  965. 16:03:49 65905 cached open
  966. 16:03:49 65905 search_find: file="NULL"
  967. 16:03:49 65905 key="select users.on_forward from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_forward = '1' and users.domain_id=domains.domain_id" partial=-1 affix=NULL starflags=0
  968. 16:03:49 65905 LRU list:
  969. 16:03:49 65905 internal_search_find: file="NULL"
  970. 16:03:49 65905 type=mysql key="select users.on_forward from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_forward = '1' and users.domain_id=domains.domain_id"
  971. 16:03:49 65905 database lookup required for select users.on_forward from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_forward = '1' and users.domain_id=domains.domain_id
  972. 16:03:49 65905 MySQL query: select users.on_forward from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_forward = '1' and users.domain_id=domains.domain_id
  973. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  974. 16:03:49 65905 MYSQL: no data found
  975. 16:03:49 65905 lookup failed
  976. 16:03:49 65905 expanding: ${lookup mysql{select users.on_forward from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_forward = '1' and users.domain_id=domains.domain_id}}
  977. 16:03:49 65905 result:
  978. 16:03:49 65905 expanding: 1
  979. 16:03:49 65905 result: 1
  980. 16:03:49 65905 condition: and { {!match {$h_precedence:}{(?i)junk}} {eq {${lookup mysql{select users.on_forward from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_forward = '1' and users.domain_id=domains.domain_id}}}{1} }}
  981. 16:03:49 65905 result: false
  982. 16:03:49 65905 expanding: yes
  983. 16:03:49 65905 result: yes
  984. 16:03:49 65905 skipping: result is not used
  985. 16:03:49 65905 expanding: no
  986. 16:03:49 65905 result: no
  987. 16:03:49 65905 expanding: ${if and { {!match {$h_precedence:}{(?i)junk}} {eq {${lookup mysql{select users.on_forward from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_forward = '1' and users.domain_id=domains.domain_id}}}{1} }} {yes}{no} }
  988. 16:03:49 65905 result: no
  989. 16:03:49 65905 considering bool_lax: no
  990. 16:03:49 65905 condition: and{{bool_lax{NULL}}{bool_lax{${if and { {!match {$h_precedence:}{(?i)junk}} {eq {${lookup mysql{select users.on_forward from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_forward = '1' and users.domain_id=domains.domain_id}}}{1} }} {yes}{no} }}}}
  991. 16:03:49 65905 result: false
  992. 16:03:49 65905 expanding: ${if and{{bool_lax{NULL}}{bool_lax{${if and { {!match {$h_precedence:}{(?i)junk}} {eq {${lookup mysql{select users.on_forward from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_forward = '1' and users.domain_id=domains.domain_id}}}{1} }} {yes}{no} }}}}}
  993. 16:03:49 65905 result:
  994. 16:03:49 65905 virtual_forward router skipped: condition failure
  995. 16:03:49 65905 --------> virtual_domains router <--------
  996. 16:03:49 65905 local_part=postmaster domain=localdomain.lan
  997. 16:03:49 65905 calling virtual_domains router
  998. 16:03:49 65905 rda_interpret (string): ${lookup mysql{select smtp from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and domains.enabled = '1' and users.domain_id = domains.domain_id}}
  999. 16:03:49 65905 expanding: $local_part
  1000. 16:03:49 65905 result: postmaster
  1001. 16:03:49 65905 expanding: $domain
  1002. 16:03:49 65905 result: localdomain.lan
  1003. 16:03:49 65905 expanding: select smtp from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and domains.enabled = '1' and users.domain_id = domains.domain_id
  1004. 16:03:49 65905 result: select smtp from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and domains.enabled = '1' and users.domain_id = domains.domain_id
  1005. 16:03:49 65905 search_open: mysql "NULL"
  1006. 16:03:49 65905 cached open
  1007. 16:03:49 65905 search_find: file="NULL"
  1008. 16:03:49 65905 key="select smtp from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and domains.enabled = '1' and users.domain_id = domains.domain_id" partial=-1 affix=NULL starflags=0
  1009. 16:03:49 65905 LRU list:
  1010. 16:03:49 65905 internal_search_find: file="NULL"
  1011. 16:03:49 65905 type=mysql key="select smtp from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and domains.enabled = '1' and users.domain_id = domains.domain_id"
  1012. 16:03:49 65905 database lookup required for select smtp from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and domains.enabled = '1' and users.domain_id = domains.domain_id
  1013. 16:03:49 65905 MySQL query: select smtp from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and domains.enabled = '1' and users.domain_id = domains.domain_id
  1014. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  1015. 16:03:49 65905 lookup yielded: /RWs/home/vMails/localdomain.lan/postmaster/Maildir
  1016. 16:03:49 65905 expanding: ${lookup mysql{select smtp from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and domains.enabled = '1' and users.domain_id = domains.domain_id}}
  1017. 16:03:49 65905 result: /RWs/home/vMails/localdomain.lan/postmaster/Maildir
  1018. 16:03:49 65905 expanded: /RWs/home/vMails/localdomain.lan/postmaster/Maildir
  1019. 16:03:49 65905 file is not a filter file
  1020. 16:03:49 65905 parse_forward_list: /RWs/home/vMails/localdomain.lan/postmaster/Maildir
  1021. 16:03:49 65905 extract item: /RWs/home/vMails/localdomain.lan/postmaster/Maildir
  1022. 16:03:49 65905 expanding: $spam_score_int
  1023. 16:03:49 65905 result:
  1024. 16:03:49 65905 empty string cast to zero for numerical comparison
  1025. 16:03:49 65905 expanding: $local_part
  1026. 16:03:49 65905 result: postmaster
  1027. 16:03:49 65905 expanding: $domain
  1028. 16:03:49 65905 result: localdomain.lan
  1029. 16:03:49 65905 expanding: select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id
  1030. 16:03:49 65905 result: select users.sa_tag * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id
  1031. 16:03:49 65905 search_open: mysql "NULL"
  1032. 16:03:49 65905 cached open
  1033. 16:03:49 65905 search_find: file="NULL"
  1034. 16:03:49 65905 key="select users.sa_tag * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id " partial=-1 affix=NULL starflags=0
  1035. 16:03:49 65905 LRU list:
  1036. 16:03:49 65905 internal_search_find: file="NULL"
  1037. 16:03:49 65905 type=mysql key="select users.sa_tag * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id "
  1038. 16:03:49 65905 database lookup required for select users.sa_tag * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id
  1039. 16:03:49 65905 MySQL query: select users.sa_tag * 10 from users,domains where localpart = 'postmaster' and domain = 'localdomain.lan' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id
  1040. 16:03:49 65905 MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  1041. 16:03:49 65905 MYSQL: no data found
  1042. 16:03:49 65905 lookup failed
  1043. 16:03:49 65905 expanding: $value
  1044. 16:03:49 65905 result:
  1045. 16:03:49 65905 skipping: result is not used
  1046. 16:03:49 65905 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id }{$value}fail}} {X-Spam-Flag:: YES\n}{} }
  1047. 16:03:49 65905 error message: "lookup" failed and "fail" requested
  1048. 16:03:49 65905 failure was forced
  1049. 16:03:49 65905 failed to expand: ${if >{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id }{$value}fail}} {X-Spam-Flag:: YES\n}{} }
  1050. 16:03:49 65905 error message: "lookup" failed and "fail" requested
  1051. 16:03:49 65905 failure was forced
  1052. 16:03:49 65905 expanding: $spam_score_int
  1053. 16:03:49 65905 result:
  1054. 16:03:49 65905 empty string cast to zero for numerical comparison
  1055. 16:03:49 65905 expanding: 1
  1056. 16:03:49 65905 result: 1
  1057. 16:03:49 65905 expanding: $spam_score_int
  1058. 16:03:49 65905 result:
  1059. 16:03:49 65905 skipping: result is not used
  1060. 16:03:49 65905 failed to expand: select users.sa_tag * 10 from users,domains where local
  1061. 16:03:49 65905 error message: missing } at end of string
  1062. 16:03:49 65905 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains where local
  1063. 16:03:49 65905 error message: missing } at end of string
  1064. 16:03:49 65905 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where local
  1065. 16:03:49 65905 error message: missing } at end of string inside "or{...}" condition
  1066. 16:03:49 65905 virtual_domains router: defer for postmaster@localdomain.lan
  1067. 16:03:49 65905 message: virtual_domains router failed to expand "${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql::$local_part}' and domain = '${quote_mysql::$domain}' and users.on_spamassassin = 1 and users.domain_id=domains.domain_id}{$value}fail}} } { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql::$local_part}' and domain = '${quote_mysql::$domain}' and users.on_spamassassin = 0 and users.domain_id=domains.domain_id}{$value}fail}}} } {X-Spam-Score::X-Spam-Report} }": missing } at end of string inside "or{...}" condition
  1068. 16:03:49 65905 added retry item for R:postmaster@localdomain.lan: errno=-1 more_errno=0 flags=0
  1069. 16:03:49 65905 post-process postmaster@localdomain.lan (1)
  1070. 16:03:49 65905 LOG: MAIN
  1071. 16:03:49 65905 == postmaster@localdomain.lan R=virtual_domains defer (-1): Temporary internal error
  1072. 16:03:49 65905 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
  1073. 16:03:49 65905 After routing:
  1074. 16:03:49 65905 Local deliveries:
  1075. 16:03:49 65905 Remote deliveries:
  1076. 16:03:49 65905 Failed addresses:
  1077. 16:03:49 65905 Deferred addresses:
  1078. 16:03:49 65905 postmaster@localdomain.lan
  1079. 16:03:49 65905 search_tidyup called
  1080. 16:03:49 65905 close MYSQL connection: localhost:(/tmp/mysql.sock)/vexiBack/vexBack
  1081. 16:03:49 65905 >>>>>>>>>>>>>>>> deliveries are done >>>>>>>>>>>>>>>>
  1082. 16:03:49 65905 changed uid/gid: post-delivery tidying
  1083. 16:03:49 65905 uid=26 gid=6 pid=65905
  1084. 16:03:49 65905 auxiliary group list: 6
  1085. 16:03:49 65905 set_process_info: 65905 tidying up after delivering 1YGrZ3-000H8x-AL
  1086. 16:03:49 65905 Processing retry items
  1087. 16:03:49 65905 Succeeded addresses:
  1088. 16:03:49 65905 Failed addresses:
  1089. 16:03:49 65905 Deferred addresses:
  1090. 16:03:49 65905 postmaster@localdomain.lan
  1091. 16:03:49 65905 locking /var/spool/exim/db/retry.lockfile
  1092. 16:03:49 65905 locked /var/spool/exim/db/retry.lockfile
  1093. 16:03:49 65905 EXIM_DBOPEN(/var/spool/exim/db/retry)
  1094. 16:03:49 65905 returned from EXIM_DBOPEN
  1095. 16:03:49 65905 opened hints database /var/spool/exim/db/retry: flags=O_RDWR
  1096. 16:03:49 65905 address match test: subject=postmaster@localdomain.lan pattern=*
  1097. 16:03:49 65905 localdomain.lan in "*"? yes (matched "*")
  1098. 16:03:49 65905 postmaster@localdomain.lan in "*"? yes (matched "*")
  1099. 16:03:49 65905 retry for R:postmaster@localdomain.lan = * 0 0
  1100. 16:03:49 65905 dbfn_read: key=R:postmaster@localdomain.lan
  1101. 16:03:49 65905 failing_interval=0 message_age=20
  1102. 16:03:49 65905 Writing retry data for R:postmaster@localdomain.lan
  1103. 16:03:49 65905 first failed=1422547429 last try=1422547429 next try=1422548329 expired=0
  1104. 16:03:49 65905 errno=-1 more_errno=0 Temporary internal error
  1105. 16:03:49 65905 dbfn_write: key=R:postmaster@localdomain.lan
  1106. 16:03:49 65905 end of retry processing
  1107. 16:03:49 65905 expanding: $h_list-id:$h_list-post:$h_list-subscribe:
  1108. 16:03:49 65905 result:
  1109. 16:03:49 65905 expanding:
  1110. 16:03:49 65905 result:
  1111. 16:03:49 65905 expanding: $h_precedence:
  1112. 16:03:49 65905 result:
  1113. 16:03:49 65905 expanding: (?i)bulk|list|junk
  1114. 16:03:49 65905 result: (?i)bulk|list|junk
  1115. 16:03:49 65905 expanding: $h_auto-submitted:
  1116. 16:03:49 65905 result:
  1117. 16:03:49 65905 expanding: (?i)auto-generated|auto-replied
  1118. 16:03:49 65905 result: (?i)auto-generated|auto-replied
  1119. 16:03:49 65905 condition: or {{ !eq{$h_list-id:$h_list-post:$h_list-subscribe:}{} }{ match{$h_precedence:}{(?i)bulk|list|junk} }{ match{$h_auto-submitted:}{(?i)auto-generated|auto-replied} }}
  1120. 16:03:49 65905 result: false
  1121. 16:03:49 65905 expanding: no
  1122. 16:03:49 65905 result: no
  1123. 16:03:49 65905 skipping: result is not used
  1124. 16:03:49 65905 expanding: yes
  1125. 16:03:49 65905 result: yes
  1126. 16:03:49 65905 expanding: ${if or {{ !eq{$h_list-id:$h_list-post:$h_list-subscribe:}{} }{ match{$h_precedence:}{(?i)bulk|list|junk} }{ match{$h_auto-submitted:}{(?i)auto-generated|auto-replied} }} {no}{yes}}
  1127. 16:03:49 65905 result: yes
  1128. 16:03:49 65905 time on queue = 20s
  1129. 16:03:49 65905 warning counts: required 0 done 0
  1130. 16:03:49 65905 delivery deferred: update_spool=1 header_rewritten=0
  1131. 16:03:49 65905 Writing spool header file
  1132. 16:03:49 65905 Size of headers = 695
  1133. 16:03:49 65905 end delivery of 1YGrZ3-000H8x-AL
  1134. 16:03:49 65905 search_tidyup called
  1135. 16:03:49 65905 search_tidyup called
  1136. 16:03:49 65905 >>>>>>>>>>>>>>>> Exim pid=65905 terminating with rc=0 >>>>>>>>>>>>>>>>
  1137. 16:03:51 65903 SMTP<< quit
  1138. 16:03:51 65903 SMTP>> 221 mailsrv.localdomain.lan closing connection
  1139. 16:03:51 65903 LOG: smtp_connection MAIN
  1140. 16:03:51 65903 SMTP connection from (mailer) [172.16.0.245] closed by QUIT
  1141. 16:03:51 65903 search_tidyup called
  1142. 16:03:51 65900 child 65903 ended: status=0x0
  1143. 16:03:51 65900 normal exit, 0
  1144. 16:03:51 65900 0 SMTP accept processes now running
  1145. 16:03:51 65900 Listening...
  1146. ^C
  1147.  
  1148. root@bMail:/root/eximDiags # ^Dexit
  1149.  
  1150. Script done on Thu Jan 29 16:04:06 2015
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement