mysql> select * from alias where address = '#test@domain.com';
+-------------------+-----------------+------+------------+--------------+-------------+--------+----------+----------+---------------------+---------------------+---------------------+--------+
| address | goto | name | moderators | accesspolicy | domain | islist | is_alias | alias_to | created | modified | expired | active |
+-------------------+-----------------+------+------------+--------------+-------------+--------+----------+----------+---------------------+---------------------+---------------------+--------+
| #test@domain.com | ben@domain.com | | NULL | domain | domain.com | 1 | 0 | | 1970-01-01 01:01:01 | 1970-01-01 01:01:01 | 9999-12-31 00:00:00 | 1 |
+-------------------+-----------------+------+------------+--------------+-------------+--------+----------+----------+---------------------+---------------------+---------------------+--------+
1 row in set (0.01 sec)
Apr 27 20:03:59 mx postfix/postscreen[1956]: CONNECT from [108.60.212.145]:52302 to [45.76.137.157]:25
Apr 27 20:04:01 mx CRON[2288]: (sogo) CMD (/usr/sbin/sogo-tool expire-sessions 30 2>/dev/null)
Apr 27 20:04:05 mx postfix/postscreen[1956]: PASS OLD [108.60.212.145]:52302
Apr 27 20:04:05 mx postfix/smtpd[1959]: connect from unknown[108.60.212.145]
Apr 27 20:04:06 mx postfix/smtpd[1959]: 1B2C15E004: client=unknown[108.60.212.145]
Apr 27 20:04:07 mx postfix/cleanup[2295]: 1B2C15E004: message-id=<aff4a273ac8b8d53@95be485b921bdab3>
Apr 27 20:04:07 mx postfix/qmgr[1721]: 1B2C15E004: from=<test@ismyemailworking.com>, size=1661, nrcpt=1 (queue active)
Apr 27 20:04:07 mx postfix/smtpd[1959]: disconnect from unknown[108.60.212.145] ehlo=1 mail=1 rcpt=1 data=1 quit=1 commands=5
Apr 27 20:04:08 mx postfix/10025/smtpd[2303]: connect from localhost[127.0.0.1]
Apr 27 20:04:08 mx postfix/10025/smtpd[2303]: 8DB5C5E007: client=localhost[127.0.0.1]
Apr 27 20:04:08 mx postfix/cleanup[2295]: 8DB5C5E007: message-id=<aff4a273ac8b8d53@95be485b921bdab3>
Apr 27 20:04:08 mx postfix/qmgr[1721]: 8DB5C5E007: from=<test@ismyemailworking.com>, size=2101, nrcpt=1 (queue active)
Apr 27 20:04:08 mx postfix/10025/smtpd[2303]: disconnect from localhost[127.0.0.1] ehlo=1 mail=1 rcpt=1 data=1 quit=1 commands=5
Apr 27 20:04:08 mx amavis[1883]: (01883-02) Passed CLEAN {RelayedInbound}, [108.60.212.145]:52302 [108.60.212.145] ESMTP/ESMTP <test@ismyemailworking.com> -> <ben@domain.com>, (ESMTP://[108.60.212.145]:52302), Queue-ID: 1B2C15E004, Message-ID: <aff4a273ac8b8d53@95be485b921bdab3>, mail_id: pqDo6DrLbzUi, b: rDm0ISvTO, Hits: 1.591, size: 1661, queued_as: 8DB5C5E007, Subject: "IsMyEmailWorking.com - Test ID [2395e42e-59c6-447e-bda3-e486ec3f3357]", From: <test@ismyemailworking.com>, helo=IsMyEmailWorking.com, Tests: [BAYES_50=0.8,RDNS_NONE=0.793,SPF_HELO_PASS=-0.001,SPF_PASS=-0.001], autolearn=no autolearn_force=no, autolearnscore=1.274, 1226 ms
Apr 27 20:04:08 mx postfix/smtp-amavis/smtp[2299]: 1B2C15E004: to=<ben@domain.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=2.9, delays=1.6/0.02/0.01/1.2, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as 8DB5C5E007)
Apr 27 20:04:08 mx postfix/qmgr[1721]: 1B2C15E004: removed
Apr 27 20:04:08 mx postfix/pipe[2304]: 8DB5C5E007: to=<ben@domain.com>, relay=dovecot, delay=0.07, delays=0.01/0.01/0/0.05, dsn=2.0.0, status=sent (delivered via dovecot service)
Apr 27 20:04:08 mx postfix/qmgr[1721]: 8DB5C5E007: removed
2017-04-27 20:04:06 DEBUG smtp session: request=smtpd_access_policy
2017-04-27 20:04:06 DEBUG smtp session: protocol_state=RCPT
2017-04-27 20:04:06 DEBUG smtp session: protocol_name=ESMTP
2017-04-27 20:04:06 DEBUG smtp session: client_address=108.60.212.145
2017-04-27 20:04:06 DEBUG smtp session: client_name=unknown
2017-04-27 20:04:06 DEBUG smtp session: client_port=52302
2017-04-27 20:04:06 DEBUG smtp session: reverse_client_name=unknown
2017-04-27 20:04:06 DEBUG smtp session: helo_name=IsMyEmailWorking.com
2017-04-27 20:04:06 DEBUG smtp session: sender=test@ismyemailworking.com
2017-04-27 20:04:06 DEBUG smtp session: recipient=#test@domain.com
2017-04-27 20:04:06 DEBUG smtp session: recipient_count=0
2017-04-27 20:04:06 DEBUG smtp session: queue_id=
2017-04-27 20:04:06 DEBUG smtp session: instance=7a7.590240a5.b765f.0
2017-04-27 20:04:06 DEBUG smtp session: size=0
2017-04-27 20:04:06 DEBUG smtp session: etrn_domain=
2017-04-27 20:04:06 DEBUG smtp session: stress=
2017-04-27 20:04:06 DEBUG smtp session: sasl_method=
2017-04-27 20:04:06 DEBUG smtp session: sasl_username=
2017-04-27 20:04:06 DEBUG smtp session: sasl_sender=
2017-04-27 20:04:06 DEBUG smtp session: ccert_subject=
2017-04-27 20:04:06 DEBUG smtp session: ccert_issuer=
2017-04-27 20:04:06 DEBUG smtp session: ccert_fingerprint=
2017-04-27 20:04:06 DEBUG smtp session: ccert_pubkey_fingerprint=
2017-04-27 20:04:06 DEBUG smtp session: encryption_protocol=
2017-04-27 20:04:06 DEBUG smtp session: encryption_cipher=
2017-04-27 20:04:06 DEBUG smtp session: encryption_keysize=0
2017-04-27 20:04:06 DEBUG smtp session: policy_context=
2017-04-27 20:04:06 DEBUG --> Apply plugin: reject_null_sender
2017-04-27 20:04:06 DEBUG <-- Result: DUNNO
2017-04-27 20:04:06 DEBUG --> Apply plugin: reject_sender_login_mismatch
2017-04-27 20:04:06 DEBUG Not an authenticated sender (no sasl_username).
2017-04-27 20:04:06 DEBUG [SQL] query local domain (ismyemailworking.com):
SELECT domain
FROM domain
WHERE domain='ismyemailworking.com'
LIMIT 1
2017-04-27 20:04:06 DEBUG SQL query result: None
2017-04-27 20:04:06 DEBUG [SQL] query alias domains (ismyemailworking.com):
SELECT alias_domain
FROM alias_domain
WHERE alias_domain='ismyemailworking.com' OR target_domain='ismyemailworking.com'
LIMIT 1
2017-04-27 20:04:06 DEBUG SQL query result: None
2017-04-27 20:04:06 DEBUG Sender domain is not hosted locally.
2017-04-27 20:04:06 DEBUG <-- Result: DUNNO
2017-04-27 20:04:06 DEBUG --> Apply plugin: greylisting
2017-04-27 20:04:06 DEBUG [SQL] Query greylisting whitelists:
SELECT id, sender, comment
FROM greylisting_whitelists
WHERE account IN ('#test@domain.com', '@domain.com', '@.')
2017-04-27 20:04:06 DEBUG No whitelist found.
2017-04-27 20:04:06 DEBUG [SQL] query greylisting settings:
SELECT id, account, sender, sender_priority, active
FROM greylisting
WHERE account IN ('#test@domain.com', '@domain.com', '@.')
ORDER BY priority DESC, sender_priority DESC
2017-04-27 20:04:06 DEBUG [SQL] query result: [(1, '@.', '@.', 0, 1)]
2017-04-27 20:04:06 DEBUG Greylisting should be applied according to SQL record: (id=1, account='@.', sender='@.')
2017-04-27 20:04:06 DEBUG [SQL] check whether client address (108.60.212.145) passed greylisting:
SELECT id
FROM greylisting_tracking
WHERE client_address='108.60.212.145'
AND passed=1
LIMIT 1
2017-04-27 20:04:06 DEBUG Client address (108.60.212.145) didn't pass greylisting.
2017-04-27 20:04:06 DEBUG [SQL] query greylisting tracking:
SELECT init_time, blocked_count, block_expired, record_expired
FROM greylisting_tracking
WHERE sender='test@ismyemailworking.com'
AND recipient='#test@domain.com'
AND client_address='108.60.212.145'
LIMIT 1
2017-04-27 20:04:06 INFO [108.60.212.145] Client has not been seen before, greylisted.
2017-04-27 20:04:06 DEBUG [SQL] New tracking:
INSERT INTO greylisting_tracking (sender, sender_domain,
recipient, rcpt_domain,
client_address,
init_time,
block_expired, record_expired,
blocked_count)
VALUES ('test@ismyemailworking.com', 'ismyemailworking.com', '#test@domain.com', 'domain.com', '108.60.212.145', 1493319846, 1493320746, 1493406246, 1)
2017-04-27 20:04:06 DEBUG <-- Result: 451 4.7.1 Intentional policy rejection, please try again later
2017-04-27 20:04:06 DEBUG Session ended.
2017-04-27 20:04:06 INFO 108.60.212.145 RCPT, test@ismyemailworking.com -> #test@domain.com, 451 4.7.1 Intentional policy rejection, please try again later [0.0381s]
2017-04-27 20:04:07 DEBUG Connect from 127.0.0.1, port 40552.
2017-04-27 20:04:07 DEBUG smtp session: request=smtpd_access_policy
2017-04-27 20:04:07 DEBUG smtp session: protocol_state=END-OF-MESSAGE
2017-04-27 20:04:07 DEBUG smtp session: protocol_name=ESMTP
2017-04-27 20:04:07 DEBUG smtp session: client_address=108.60.212.145
2017-04-27 20:04:07 DEBUG smtp session: client_name=unknown
2017-04-27 20:04:07 DEBUG smtp session: client_port=52302
2017-04-27 20:04:07 DEBUG smtp session: reverse_client_name=unknown
2017-04-27 20:04:07 DEBUG smtp session: helo_name=IsMyEmailWorking.com
2017-04-27 20:04:07 DEBUG smtp session: sender=test@ismyemailworking.com
2017-04-27 20:04:07 DEBUG smtp session: recipient=#test@domain.com
2017-04-27 20:04:07 DEBUG smtp session: recipient_count=1
2017-04-27 20:04:07 DEBUG smtp session: queue_id=1B2C15E004
2017-04-27 20:04:07 DEBUG smtp session: instance=7a7.590240a5.b765f.0
2017-04-27 20:04:07 DEBUG smtp session: size=1477
2017-04-27 20:04:07 DEBUG smtp session: etrn_domain=
2017-04-27 20:04:07 DEBUG smtp session: stress=
2017-04-27 20:04:07 DEBUG smtp session: sasl_method=
2017-04-27 20:04:07 DEBUG smtp session: sasl_username=
2017-04-27 20:04:07 DEBUG smtp session: sasl_sender=
2017-04-27 20:04:07 DEBUG smtp session: ccert_subject=
2017-04-27 20:04:07 DEBUG smtp session: ccert_issuer=
2017-04-27 20:04:07 DEBUG smtp session: ccert_fingerprint=
2017-04-27 20:04:07 DEBUG smtp session: ccert_pubkey_fingerprint=
2017-04-27 20:04:07 DEBUG smtp session: encryption_protocol=
2017-04-27 20:04:07 DEBUG smtp session: encryption_cipher=
2017-04-27 20:04:07 DEBUG smtp session: encryption_keysize=0
2017-04-27 20:04:07 DEBUG smtp session: policy_context=
2017-04-27 20:04:07 DEBUG Skip plugin: reject_null_sender (protocol_state != END-OF-MESSAGE)
2017-04-27 20:04:07 DEBUG Skip plugin: reject_sender_login_mismatch (protocol_state != END-OF-MESSAGE)
2017-04-27 20:04:07 DEBUG Skip plugin: greylisting (protocol_state != END-OF-MESSAGE)
2017-04-27 20:04:07 DEBUG --> Apply plugin: throttle
2017-04-27 20:04:07 DEBUG Check sender throttling.
2017-04-27 20:04:07 DEBUG [SQL] Query throttle setting:
SELECT id, account, priority, period, max_msgs, max_quota, msg_size
FROM throttle
WHERE kind='external' AND account IN ('108.60.212.145', '@ip', '@.', 'test@ismyemailworking.com', '@ismyemailworking.com', '@.ismyemailworking.com', '@com', '@.com', '108.60.212.*', '108.60.*.145')
ORDER BY priority DESC
2017-04-27 20:04:07 DEBUG [SQL] Query result:
[]
2017-04-27 20:04:07 DEBUG No sender throttle setting.
2017-04-27 20:04:07 DEBUG Check recipient throttling.
2017-04-27 20:04:07 DEBUG [SQL] Query throttle setting:
SELECT id, account, priority, period, max_msgs, max_quota, msg_size
FROM throttle
WHERE kind='inbound' AND account IN ('108.60.212.145', '@ip', '@.', '#test@domain.com', '@domain.com', '@.domain.com', '@net', '@.net', '108.60.212.*', '108.60.*.145')
ORDER BY priority DESC
2017-04-27 20:04:07 DEBUG [SQL] Query result:
[]
2017-04-27 20:04:07 DEBUG No recipient throttle setting.
2017-04-27 20:04:07 DEBUG <-- Result: DUNNO
2017-04-27 20:04:07 DEBUG Skip plugin: sql_alias_access_policy (protocol_state != END-OF-MESSAGE)
2017-04-27 20:04:07 DEBUG Skip plugin: amavisd_wblist (protocol_state != END-OF-MESSAGE)
2017-04-27 20:04:07 DEBUG Session ended.
2017-04-27 20:04:07 INFO 108.60.212.145 END-OF-MESSAGE, test@ismyemailworking.com -> #test@domain.com, DUNNO [0.0096s]