主题: sql_alias_access_policy 失效
==== 必填信息。没有填写将不予回复 ====
- iRedMail 版本号:iRedMail-0.9.6
- 使用哪个数据库存储用户帐号(OpenLDAP,MySQL,PostgreSQL):MariaDB
- 使用的 Linux/BSD 发行版名称及版本号:CentOS Linux release 7.3.1611 (Core)
- 与您的问题相关的日志信息:
2017-04-06 12:00:18 DEBUG Connect from 127.0.0.1, port 59394.
2017-04-06 12:00:18 DEBUG smtp session: request=smtpd_access_policy
2017-04-06 12:00:18 DEBUG smtp session: protocol_state=RCPT
2017-04-06 12:00:18 DEBUG smtp session: protocol_name=ESMTP
2017-04-06 12:00:18 DEBUG smtp session: client_address=183.60.2.225
2017-04-06 12:00:18 DEBUG smtp session: client_name=smtpbg129.qq.com
2017-04-06 12:00:18 DEBUG smtp session: reverse_client_name=smtpbg129.qq.com
2017-04-06 12:00:18 DEBUG smtp session: helo_name=smtpbg129.qq.com
2017-04-06 12:00:18 DEBUG smtp session: sender=3333333333@qq.com
2017-04-06 12:00:18 DEBUG smtp session: recipient=ops@1234567.com
2017-04-06 12:00:18 DEBUG smtp session: recipient_count=0
2017-04-06 12:00:18 DEBUG smtp session: queue_id=
2017-04-06 12:00:18 DEBUG smtp session: instance=c5d.58e66611.7c8d8.0
2017-04-06 12:00:18 DEBUG smtp session: size=0
2017-04-06 12:00:18 DEBUG smtp session: etrn_domain=
2017-04-06 12:00:18 DEBUG smtp session: stress=
2017-04-06 12:00:18 DEBUG smtp session: sasl_method=
2017-04-06 12:00:18 DEBUG smtp session: sasl_username=
2017-04-06 12:00:18 DEBUG smtp session: sasl_sender=
2017-04-06 12:00:18 DEBUG smtp session: ccert_subject=
2017-04-06 12:00:18 DEBUG smtp session: ccert_issuer=
2017-04-06 12:00:18 DEBUG smtp session: ccert_fingerprint=
2017-04-06 12:00:18 DEBUG smtp session: ccert_pubkey_fingerprint=
2017-04-06 12:00:18 DEBUG smtp session: encryption_protocol=TLSv1
2017-04-06 12:00:18 DEBUG smtp session: encryption_cipher=DHE-RSA-AES256-SHA
2017-04-06 12:00:18 DEBUG smtp session: encryption_keysize=256
2017-04-06 12:00:18 DEBUG --> Apply plugin: reject_null_sender
2017-04-06 12:00:18 DEBUG <-- Result: DUNNO
2017-04-06 12:00:18 DEBUG --> Apply plugin: reject_sender_login_mismatch
2017-04-06 12:00:18 DEBUG Not an authenticated sender (no sasl_username).
2017-04-06 12:00:18 DEBUG [SQL] query local domain (qq.com):
2017-04-06 12:00:18 DEBUG SQL query result: None
2017-04-06 12:00:18 DEBUG [SQL] query alias domains (qq.com):
2017-04-06 12:00:18 DEBUG SQL query result: None
2017-04-06 12:00:18 DEBUG Sender domain is not hosted locally.
2017-04-06 12:00:18 DEBUG <-- Result: DUNNO
2017-04-06 12:00:18 DEBUG --> Apply plugin: throttle
2017-04-06 12:00:18 DEBUG Check sender throttling.
2017-04-06 12:00:18 DEBUG [SQL] Query throttle setting:
2017-04-06 12:00:18 DEBUG [SQL] Query result:
2017-04-06 12:00:18 DEBUG No sender throttle setting.
2017-04-06 12:00:18 DEBUG Check recipient throttling.
2017-04-06 12:00:18 DEBUG [SQL] Query throttle setting:
2017-04-06 12:00:18 DEBUG [SQL] Query result:
2017-04-06 12:00:18 DEBUG No recipient throttle setting.
2017-04-06 12:00:18 DEBUG <-- Result: DUNNO
2017-04-06 12:00:18 DEBUG --> Apply plugin: sql_alias_access_policy
2017-04-06 12:00:18 DEBUG [SQL] query access policy:
2017-04-06 12:00:18 DEBUG SQL query result: ('memebersAndModeratorsOnly', 'zzzzzz@1234567.com,test@1234567.com', 'zzzzzz@1234567.com')
2017-04-06 12:00:18 DEBUG Access policy: memebersandmoderatorsonly
2017-04-06 12:00:18 DEBUG members: zzzzzz@1234567.com, test@1234567.com
2017-04-06 12:00:18 DEBUG moderators: zzzzzz@1234567.com
2017-04-06 12:00:18 DEBUG [SQL] query alias domains:
2017-04-06 12:00:18 DEBUG No alias domain.
2017-04-06 12:00:18 DEBUG <-- Result: DUNNO (Policy is not defined: memebersandmoderatorsonly)
2017-04-06 12:00:18 DEBUG --> Apply plugin: amavisd_wblist
2017-04-06 12:00:18 DEBUG Possible policy senders: ['@.', '3333333333@qq.com', '@qq.com', '@.qq.com', '@com', '@.com', '3333333333@*', '183.60.2.225', '183.60.2.*', '183.60.*.225']
2017-04-06 12:00:18 DEBUG Possible policy recipients: ['@.', 'ops@1234567.com', '@1234567.com', '@.1234567.com', '@com', '@.com']
2017-04-06 12:00:18 DEBUG [SQL] query local domain (qq.com):
2017-04-06 12:00:18 DEBUG SQL query result: None
2017-04-06 12:00:18 DEBUG [SQL] query alias domains (qq.com):
2017-04-06 12:00:18 DEBUG SQL query result: None
2017-04-06 12:00:18 DEBUG Apply wblist for inbound message.
2017-04-06 12:00:18 DEBUG [SQL] Query local addresses:
2017-04-06 12:00:18 DEBUG No record found in SQL database.
2017-04-06 12:00:18 DEBUG No valid sender id or recipient id.
2017-04-06 12:00:18 DEBUG <-- Result: DUNNO
2017-04-06 12:00:18 DEBUG Session ended.
2017-04-06 12:00:18 INFO 183.60.2.225 RCPT, 3333333333@qq.com -> ops@1234567.com, DUNNO [0.0752s]
2017-04-06 12:00:18 DEBUG smtp session: request=smtpd_access_policy
2017-04-06 12:00:18 DEBUG smtp session: protocol_state=END-OF-MESSAGE
2017-04-06 12:00:18 DEBUG smtp session: protocol_name=ESMTP
2017-04-06 12:00:18 DEBUG smtp session: client_address=183.60.2.225
2017-04-06 12:00:18 DEBUG smtp session: client_name=smtpbg129.qq.com
2017-04-06 12:00:18 DEBUG smtp session: reverse_client_name=smtpbg129.qq.com
2017-04-06 12:00:18 DEBUG smtp session: helo_name=smtpbg129.qq.com
2017-04-06 12:00:18 DEBUG smtp session: sender=3333333333@qq.com
2017-04-06 12:00:18 DEBUG smtp session: recipient=ops@1234567.com
2017-04-06 12:00:18 DEBUG smtp session: recipient_count=1
2017-04-06 12:00:18 DEBUG smtp session: queue_id=7FE6E40841D1
2017-04-06 12:00:18 DEBUG smtp session: instance=c5d.58e66611.7c8d8.0
2017-04-06 12:00:18 DEBUG smtp session: size=1744
2017-04-06 12:00:18 DEBUG smtp session: etrn_domain=
2017-04-06 12:00:18 DEBUG smtp session: stress=
2017-04-06 12:00:18 DEBUG smtp session: sasl_method=
2017-04-06 12:00:18 DEBUG smtp session: sasl_username=
2017-04-06 12:00:18 DEBUG smtp session: sasl_sender=
2017-04-06 12:00:18 DEBUG smtp session: ccert_subject=
2017-04-06 12:00:18 DEBUG smtp session: ccert_issuer=
2017-04-06 12:00:18 DEBUG smtp session: ccert_fingerprint=
2017-04-06 12:00:18 DEBUG smtp session: ccert_pubkey_fingerprint=
2017-04-06 12:00:18 DEBUG smtp session: encryption_protocol=TLSv1
2017-04-06 12:00:18 DEBUG smtp session: encryption_cipher=DHE-RSA-AES256-SHA
2017-04-06 12:00:18 DEBUG smtp session: encryption_keysize=256
2017-04-06 12:00:18 DEBUG Skip plugin: reject_null_sender (protocol_state != END-OF-MESSAGE)
2017-04-06 12:00:18 DEBUG Skip plugin: reject_sender_login_mismatch (protocol_state != END-OF-MESSAGE)
2017-04-06 12:00:18 DEBUG --> Apply plugin: throttle
2017-04-06 12:00:18 DEBUG Check sender throttling.
2017-04-06 12:00:18 DEBUG [SQL] Query throttle setting:
2017-04-06 12:00:18 DEBUG [SQL] Query result:
2017-04-06 12:00:18 DEBUG No sender throttle setting.
2017-04-06 12:00:18 DEBUG Check recipient throttling.
2017-04-06 12:00:18 DEBUG [SQL] Query throttle setting:
2017-04-06 12:00:18 DEBUG [SQL] Query result:
2017-04-06 12:00:18 DEBUG No recipient throttle setting.
2017-04-06 12:00:18 DEBUG <-- Result: DUNNO
2017-04-06 12:00:18 DEBUG Skip plugin: sql_alias_access_policy (protocol_state != END-OF-MESSAGE)
2017-04-06 12:00:18 DEBUG Skip plugin: amavisd_wblist (protocol_state != END-OF-MESSAGE)
2017-04-06 12:00:18 DEBUG Session ended.
2017-04-06 12:00:18 INFO 183.60.2.225 END-OF-MESSAGE, 3333333333@qq.com -> ops@1234567.com, DUNNO [0.0075s]
====
张工,
日志中提示<-- Result: DUNNO (Policy is not defined: memebersandmoderatorsonly),邮件列表的限制功能失效,任何人都可以发送邮件到此列表。请问如何解决?
另外,测试domain、subdomain、membersonly、allowedonly这几种模式都可以正常工作。