I am sending mail from [EMAIL PROTECTED] to [EMAIL PROTECTED]
in my mailaddr table I have:
[EMAIL PROTECTED] id = 1
[EMAIL PROTECTED] id = 7
In my msgs table I have:
all messages from [EMAIL PROTECTED] sid = 91159
all messages from [EMAIL PROTECTED] sid = 84333
In my wblist table I have:
rid = 91159 | sid = 1 | wb = W
Logs shown that [EMAIL PROTECTED] return 17 as result of the sql query.. I
coundn't find this record in the database, or any other file. How does this
is working?
Please any help will be appreciated.
Thank you very much.
Pablo
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) wbl: checking sender
<[EMAIL PROTECTED]>
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup_sql_field(id)
"[EMAIL PROTECTED]" result=17
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup, 1 matches for
"[EMAIL PROTECTED]", results: "/cached/"=>"17"
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) wbl: (SQL) recip
<[EMAIL PROTECTED]>, 1 matches
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70)
lookup_acl([EMAIL PROTECTED]) matches key ".example.org", result=1
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup (local_domains)
=> true, "[EMAIL PROTECTED]" matches, result="1",
matching_key=".example.org"
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) query_keys:
[EMAIL PROTECTED], mail, @example.org, @.example.org, @.com, @.
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup_sql
"[EMAIL PROTECTED]", query args: "17", "[EMAIL PROTECTED]", "mail",
"@example.org", "@.example.org", "@.com", "@."
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup_sql select:
SELECT wb FROM wblist LEFT JOIN mailaddr ON wblist.sid=mailaddr.id WHERE
(wblist.rid=?) AND (mailaddr.email IN (?,?,?,?,?,?)) ORDER BY
mailaddr.priority DESC
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) sql begin,
nontransaction
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) sql: executing clause:
SELECT wb FROM wblist LEFT JOIN mailaddr ON wblist.sid=mailaddr.id WHERE
(wblist.rid=?) AND (mailaddr.email IN (?,?,?,?,?,?)) ORDER BY
mailaddr.priority DESC
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup_sql,
"[EMAIL PROTECTED]" no match
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup_sql_field(wb),
"[EMAIL PROTECTED]" no matching records
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup => undef,
"[EMAIL PROTECTED]" does not match
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) wbl: (SQL) recip
<[EMAIL PROTECTED]>, rid=17, got: ""
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup
(blacklist_recip<[EMAIL PROTECTED]>) => undef, "[EMAIL PROTECTED]" does not
match
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) query_keys:
[EMAIL PROTECTED], mail@, example.org, .example.org, .com, .
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70)
lookup_hash([EMAIL PROTECTED]), no matches
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup
(blacklist_sender) => undef, "[EMAIL PROTECTED]" does not match
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup
(whitelist_recip<[EMAIL PROTECTED]>) => undef, "[EMAIL PROTECTED]" does not
match
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) query_keys:
[EMAIL PROTECTED], mail@, example.org, .example.org, .com, .
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70)
lookup_hash([EMAIL PROTECTED]), no matches
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup
(whitelist_sender) => undef, "[EMAIL PROTECTED]" does not match
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) query_keys:
[EMAIL PROTECTED], fac@, example.org, .example.org, .com, .
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70)
lookup_hash([EMAIL PROTECTED]) matches keys: "."=>ARRAY(0xa8ae14c)
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup (score_sender), 1
matches for "[EMAIL PROTECTED]", results:
"."=>[Amavis::Lookup::RE=ARRAY(0xa8adf54),HASH(0xa8adfc0)]
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70)
lookup_re("[EMAIL PROTECTED]"), no matches
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) query_keys:
[EMAIL PROTECTED], mail@, example.org, .example.org, .com, .
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70)
lookup_hash([EMAIL PROTECTED]), no matches
Nov 12 18:25:58 postfix amavis[7110]: (07110-01-70) lookup
(score_sender<[EMAIL PROTECTED]>) => undef, "[EMAIL PROTECTED]" does not match
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
