Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO policy_groups (Name) VALUES ('LOW');
- INSERT INTO policy_groups (Name) VALUES ('MEDIUM');
- INSERT INTO policy_groups (Name) VALUES ('HIGH');
- INSERT INTO policy_group_members (PolicyGroupID,Member) VALUES (1,'@abcxyz.pl');
- INSERT INTO policy_group_members (PolicyGroupID,Member) VALUES (2,'medium@abcxyz.pl');
- INSERT INTO policy_group_members (PolicyGroupID,Member) VALUES (3,'high@abcxyz.pl');
- INSERT INTO policies (Name,Priority,Description) VALUES ('Low Message Count.', 30,'Low mail message count');
- INSERT INTO policies (Name,Priority,Description) VALUES ('Medium Message Count.', 30,'Medium mail message count');
- INSERT INTO policies (Name,Priority,Description) VALUES ('High Message Count.', 30,'High mail message count');
- INSERT INTO policy_members (PolicyID,Source,Destination) VALUES (1,'!%MEDIUM,!%HIGH,%LOW',NULL);
- INSERT INTO policy_members (PolicyID,Source,Destination) VALUES (2,'%MEDIUM',NULL);
- INSERT INTO policy_members (PolicyID,Source,Destination) VALUES (3,'%HIGH',NULL);
- INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (1,'LOW Outgoing messages per minute.','Sender:user@domain',60,'REJECT');
- INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (1,'LOW Outgoing messages per hour.','Sender:user@domain',3600,'REJECT');
- INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (1,'LOW Outgoing messages per day.','Sender:user@domain',86400,'REJECT');
- INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (2,'MEDIUM Outgoing messages per minute.','Sender:user@domain',60,'REJECT');
- INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (2,'MEDIUM Outgoing messages per hour.','Sender:user@domain',3600,'REJECT');
- INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (2,'MEDIUM Outgoing messages per day.','Sender:user@domain',86400,'REJECT');
- INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (3,'HIGH Outgoing messages per minute.','Sender:user@domain',60,'REJECT');
- INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (3,'HIGH Outgoing messages per hour.','Sender:user@domain',3600,'REJECT');
- INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (3,'HIGH Outgoing messages per day.','Sender:user@domain',86400,'REJECT');
- INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (1,'MessagesCount',60);
- INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (2,'MessagesCount',300);
- INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (3,'MessagesCount',2400);
- INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (4,'MessagesCount',120);
- INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (5,'MessagesCount',600);
- INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (6,'MessagesCount',4800);
- INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (7,'MessagesCount',180);
- INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (8,'MessagesCount',900);
- INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (9,'MessagesCount',7200);
- Jul 1 14:20:18 darkstar cbpolicyd[2633]: module=Quotas, mode=update, host=22.222.22.222, helo=[192.168.0.10], from=guest@abcxyz.pl, to=2222222@gmail.com, reason=quota_update, policy=1, quota=1, limit=1, track=Sender:guest@abcxyz.pl, counter=MessagesCount, quota=0.00/60 (0.0%)
- Jul 1 14:20:18 darkstar cbpolicyd[2633]: module=Quotas, mode=update, host=22.222.22.222, helo=[192.168.0.10], from=guest@abcxyz.pl, to=2222222@gmail.com, reason=quota_update, policy=1, quota=2, limit=2, track=Sender:guest@abcxyz.pl, counter=MessagesCount, quota=0.00/300 (0.0%)
- Jul 1 14:20:18 darkstar cbpolicyd[2633]: module=Quotas, mode=update, host=22.222.22.222, helo=[192.168.0.10], from=guest@abcxyz.pl, to=2222222@gmail.com, reason=quota_update, policy=1, quota=3, limit=3, track=Sender:guest@abcxyz.pl, counter=MessagesCount, quota=0.00/2400 (0.0%)
- [2015/07/01-14:20:18 - 2633] [CORE] INFO: 2015/07/01-14:20:18 CONNECT TCP Peer: "[127.0.0.1]:54982" Local: "[127.0.0.1]:10031"
- [2015/07/01-14:20:18 - 2632] [CORE] INFO: Starting "1" children
- [2015/07/01-14:20:18 - 2737] [CORE] DEBUG: Child Preforked (2737)
- [2015/07/01-14:20:18 - 2737] [CBPOLICYD] DEBUG: Starting up caching engine
- [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: No session tracking data exists for request: $VAR1 = {'size' => '366',
- 'client_name' => '22-222-22-222.dynamic.chello.pl',
- 'client_address' => '22.222.22.222',
- 'request' => 'smtpd_access_policy',
- 'protocol_state' => 'RCPT',
- 'encryption_cipher' => 'ECDHE-RSA-AES256-SHA',
- '_timestamp' => 1435753218,
- 'sasl_sender' => '',
- 'instance' => 'aab.5593db02.d39f9.0',
- 'etrn_domain' => '',
- 'reverse_client_name' => '22-222-22-222.dynamic.chello.pl',
- '_protocol_transport' => 'Postfix',
- 'stress' => '',
- 'sasl_method' => 'PLAIN',
- 'sender' => 'guest@abcxyz.pl',
- 'helo_name' => '[192.168.0.10]',
- 'ccert_fingerprint' => '',
- 'ccert_pubkey_fingerprint' => '',
- 'encryption_keysize' => '256',
- 'protocol_name' => 'ESMTP',
- 'sasl_username' => 'guest@abcxyz.pl',
- 'recipient' => '2222222@gmail.com',
- 'recipient_count' => '0',
- 'queue_id' => '',
- 'ccert_subject' => '',
- 'ccert_issuer' => '',
- 'encryption_protocol' => 'TLSv1.2'
- };
- [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Added session tracking information for: $VAR1 = {'size' => '366','client_name' => '22-222-22-222.dynamic.chello.pl',
- 'client_address' => '22.222.22.222',
- 'request' => 'smtpd_access_policy',
- 'protocol_state' => 'RCPT',
- 'encryption_cipher' => 'ECDHE-RSA-AES256-SHA',
- '_timestamp' => 1435753218,
- 'sasl_sender' => '',
- 'instance' => 'aab.5593db02.d39f9.0',
- 'etrn_domain' => '',
- 'reverse_client_name' => '22-222-22-222.dynamic.chello.pl',
- '_protocol_transport' => 'Postfix',
- 'stress' => '',
- 'sasl_method' => 'PLAIN',
- 'sender' => 'guest@abcxyz.pl',
- 'helo_name' => '[192.168.0.10]',
- 'ccert_fingerprint' => '',
- 'ccert_pubkey_fingerprint' => '',
- 'encryption_keysize' => '256',
- 'protocol_name' => 'ESMTP',
- 'sasl_username' => 'guest@abcxyz.pl',
- 'recipient' => '2222222@gmail.com',
- 'recipient_count' => '0',
- 'queue_id' => '',
- 'ccert_subject' => '',
- 'ccert_issuer' => '',
- 'encryption_protocol' => 'TLSv1.2'};
- [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Protocol state is 'RCPT', resolving policy...
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: Going to resolve session data into policy: $VAR1 = {
- 'Recipient' => '2222222@gmail.com',
- 'Helo' => '[192.168.0.10]',
- 'QueueID' => '',
- 'Size' => '1',
- 'RecipientData' => '',
- 'SASLUsername' => 'guest@abcxyz.pl',
- 'EncryptionKeySize' => '256',
- 'EncryptionCipher' => 'ECDHE-RSA-AES256-SHA',
- 'SASLSender' => '',
- 'Protocol' => 'ESMTP',
- 'Instance' => 'aab.5593db02.d39f9.0',
- 'ClientName' => '22-222-22-222.dynamic.chello.pl',
- 'Sender' => 'guest@abcxyz.pl',
- 'ClientAddress' => '22.222.22.222',
- 'EncryptionProtocol' => 'TLSv1.2',
- 'ClientReverseName' => '22-222-22-222.dynamic.chello.pl',
- 'SASLMethod' => 'PLAIN' };
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: Found policy member with ID '1' in policy 'Low Message Count.'
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: Found policy member with ID '2' in policy 'Medium Message Count.'
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: Found policy member with ID '3' in policy 'High Message Count.'
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Main policy sources '%LOW,!%MEDIUM,!%HIGH'
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Group 'LOW' has 1 source(s) => @abcxyz.pl
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]=>(group:LOW): - Resolved source '@abcxyz.pl' to a email address specification, match = 1
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]=>(group:LOW): Source group result: matched=1
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Group 'MEDIUM' has 1 source(s) => medium@abcxyz.pl
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]=>(group:MEDIUM): - Resolved source 'medium@abcxyz.pl' to a email address specification, match = 0
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]=>(group:MEDIUM): Source group result: matched=0
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Group 'HIGH' has 1 source(s) => high@abcxyz.pl
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]=>(group:HIGH): - Resolved source 'high@abcxyz.pl' to a email address specification, match = 0
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]=>(group:HIGH): Source group result: matched=0
- [2015/07/01-14:20:18 - 2633] [POLICIES] INFO: [ID:1/Name:Low Message Count.]: Source matching result: matched=1
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Destination not defined or 'any', explicit match: matched=1
- [2015/07/01-14:20:18 - 2633] [POLICIES] INFO: [ID:1/Name:Low Message Count.]: Destination matching result: matched=1
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:2/Name:Medium Message Count.]: Main policy sources '!%LOW,%MEDIUM,!%HIGH'
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:2/Name:Medium Message Count.]: Group 'LOW' has 1 source(s) => @abcxyz.pl
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:2/Name:Medium Message Count.]=>(group:LOW): - Resolved source '@abcxyz.pl' to a email address specification, match = 1
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:2/Name:Medium Message Count.]=>(group:LOW): Source group result: matched=1
- [2015/07/01-14:20:18 - 2633] [POLICIES] INFO: [ID:2/Name:Medium Message Count.]: Source matching result: matched=0
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:3/Name:High Message Count.]: Main policy sources '!%LOW,!%MEDIUM,%HIGH'
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:3/Name:High Message Count.]: Group 'LOW' has 1 source(s) => @abcxyz.pl
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:3/Name:High Message Count.]=>(group:LOW): - Resolved source '@abcxyz.pl' to a email address specification, match = 1
- [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:3/Name:High Message Count.]=>(group:LOW): Source group result: matched=1
- [2015/07/01-14:20:18 - 2633] [POLICIES] INFO: [ID:3/Name:High Message Count.]: Source matching result: matched=0[2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: END RESULT: prio=30 => policy ids: 1
- [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Policy resolved into: $VAR1 = {
- '30' => [1]}; [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Request translated into session data: $VAR1 = {
- 'SASLMethod' => 'PLAIN',
- 'Timestamp' => 1435753218,
- 'ClientReverseName' => '22-222-22-222.dynamic.chello.pl', 'Policy' => {
- '30' => [1 ]}, 'EncryptionProtocol' => 'TLSv1.2',
- 'Sender' => 'guest@abcxyz.pl',
- 'ClientAddress' => '22.222.22.222',
- 'ClientName' => '22-222-22-222.dynamic.chello.pl',
- 'ParsedClientAddress' => {
- 'Mask_Long' => 4294967295,
- 'Broadcast' => '22.222.22.222',
- 'Network_Long' => 1440632779,
- 'Broadcast_Long' => 1440632779,
- 'IP' => '22.222.22.222',
- 'IP_Long' => 1440632779,
- 'Network' => '22.222.22.222'
- },
- 'Instance' => 'aab.5593db02.d39f9.0',
- 'Protocol' => 'ESMTP',
- 'SASLSender' => '',
- 'EncryptionCipher' => 'ECDHE-RSA-AES256-SHA',
- 'EncryptionKeySize' => '256',
- 'SASLUsername' => 'guest@abcxyz.pl',
- 'ProtocolState' => 'RCPT',
- 'ProtocolTransport' => 'Postfix',
- 'Size' => '1',
- 'RecipientData' => '',
- 'Helo' => '[192.168.0.10]',
- 'QueueID' => '',
- 'Recipient' => '2222222@gmail.com'
- };
- [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Got request, running modules...
- [2015/07/01-14:20:18 - 2633] [CBPOLICYD] INFO: Got request #1
- [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Running module: Quotas Plugin
- [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Module 'Quotas Plugin' returned CBP_CONTINUE
- [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Done with modules
- [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Protocol state is 'END-OF-MESSAGE', decoding policy...
- [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Decoded into: $VAR1 = {
- '2222222@gmail.com' => {
- '30' => ['1']}
- };
- [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Request translated into session data: $VAR1 = {
- 'SASLMethod' => 'PLAIN',
- 'ClientReverseName' => '22-222-22-222.dynamic.chello.pl',
- 'Timestamp' => 1435753218,
- 'ClientAddress' => '22.222.22.222',
- 'Sender' => 'guest@abcxyz.pl',
- 'ClientName' => '22-222-22-222.dynamic.chello.pl',
- 'EncryptionProtocol' => 'TLSv1.2',
- 'SASLSender' => '',
- 'EncryptionKeySize' => '256',
- 'EncryptionCipher' => 'ECDHE-RSA-AES256-SHA',
- 'ParsedClientAddress' => {
- 'Broadcast_Long' => 1440632779,
- 'Network' => '22.222.22.222',
- 'IP' => '22.222.22.222',
- 'IP_Long' => 1440632779,
- 'Network_Long' => 1440632779,
- 'Broadcast' => '22.222.22.222',
- 'Mask_Long' => 4294967295
- },
- 'Protocol' => 'ESMTP',
- 'Instance' => 'aab.5593db02.d39f9.0',
- 'Helo' => '[192.168.0.10]',
- '_Recipient_To_Policy' => {
- '2222222@gmail.com' => {
- '30' => ['1']}},
- 'QueueID' => 'E258BC4B0C',
- 'SASLUsername' => 'guest@abcxyz.pl',
- 'ProtocolState' => 'END-OF-MESSAGE',
- 'ProtocolTransport' => 'Postfix',
- 'Size' => '1',
- 'RecipientData' => '/<2222222@gmail.com>#30=1;'}; [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Got request, running modules...
- [2015/07/01-14:20:18 - 2633] [CBPOLICYD] INFO: Got request #2 (pipelined)
- [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Running module: Quotas Plugin
- [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Module 'Quotas Plugin' returned CBP_CONTINUE
- [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Done with modules
- A a35.5593da7e.a9071.0|C2F73C4B0C|1435753086|22.222.22.222|22-222-22-222.dynamic.chello.pl|22-222-22-222.dynamic.chello.pl|ESMTP|TLSv1.2|ECDHE-RSA-AES256-SHA|256|PLAIN||guest@abcxyz.pl|[192.168.0.10]|guest@abcxyz.pl|1|/<2222222@gmail.com>#30=1;/<2222222@gmail.com>#30=1;
- B aab.5593db02.d39f9.0|E258BC4B0C|1435753218|22.222.22.222|22-222-22-222.dynamic.chello.pl|22-222-22-222.dynamic.chello.pl|ESMTP|TLSv1.2|ECDHE-RSA-AES256-SHA|256|PLAIN||guest@abcxyz.pl|[192.168.0.10]|guest@abcxyz.pl|1|/<2222222@gmail.com>#30=1;
- C add.5593dbce.57f9d.0|6A6FBC4B14|1435753422|22.222.22.222|22-222-22-222.dynamic.chello.pl|22-222-22-222.dynamic.chello.pl|ESMTP|TLSv1.2|ECDHE-RSA-AES256-SHA|256|PLAIN||guest@abcxyz.pl|[192.168.0.10]|medium@abcxyz.pl|1|/<2222222@gmail.com>#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement