API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 2nd, 2015
279
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.27 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO policy_groups (Name) VALUES ('LOW');
  2. INSERT INTO policy_groups (Name) VALUES ('MEDIUM');
  3. INSERT INTO policy_groups (Name) VALUES ('HIGH');
  4.  
  5. INSERT INTO policy_group_members (PolicyGroupID,Member) VALUES (1,'@abcxyz.pl');
  6. INSERT INTO policy_group_members (PolicyGroupID,Member) VALUES (2,'medium@abcxyz.pl');
  7. INSERT INTO policy_group_members (PolicyGroupID,Member) VALUES (3,'high@abcxyz.pl');
  8.  
  9. INSERT INTO policies (Name,Priority,Description) VALUES ('Low Message Count.', 30,'Low mail message count');
  10. INSERT INTO policies (Name,Priority,Description) VALUES ('Medium Message Count.', 30,'Medium mail message count');
  11. INSERT INTO policies (Name,Priority,Description) VALUES ('High Message Count.', 30,'High mail message count');
  12.  
  13. INSERT INTO policy_members (PolicyID,Source,Destination) VALUES (1,'!%MEDIUM,!%HIGH,%LOW',NULL);
  14. INSERT INTO policy_members (PolicyID,Source,Destination) VALUES (2,'%MEDIUM',NULL);
  15. INSERT INTO policy_members (PolicyID,Source,Destination) VALUES (3,'%HIGH',NULL);
  16.  
  17. INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (1,'LOW Outgoing messages per minute.','Sender:user@domain',60,'REJECT');
  18. INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (1,'LOW Outgoing messages per hour.','Sender:user@domain',3600,'REJECT');
  19. INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (1,'LOW Outgoing messages per day.','Sender:user@domain',86400,'REJECT');
  20.  
  21. INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (2,'MEDIUM Outgoing messages per minute.','Sender:user@domain',60,'REJECT');
  22. INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (2,'MEDIUM Outgoing messages per hour.','Sender:user@domain',3600,'REJECT');
  23. INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (2,'MEDIUM Outgoing messages per day.','Sender:user@domain',86400,'REJECT');
  24.  
  25. INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (3,'HIGH Outgoing messages per minute.','Sender:user@domain',60,'REJECT');
  26. INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (3,'HIGH Outgoing messages per hour.','Sender:user@domain',3600,'REJECT');
  27. INSERT INTO quotas (PolicyID,Name,Track,Period,Verdict) VALUES (3,'HIGH Outgoing messages per day.','Sender:user@domain',86400,'REJECT');
  28.  
  29.  
  30. INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (1,'MessagesCount',60);
  31. INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (2,'MessagesCount',300);
  32. INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (3,'MessagesCount',2400);
  33.  
  34. INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (4,'MessagesCount',120);
  35. INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (5,'MessagesCount',600);
  36. INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (6,'MessagesCount',4800);
  37.  
  38. INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (7,'MessagesCount',180);
  39. INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (8,'MessagesCount',900);
  40. INSERT INTO quotas_limits (QuotasID,Type,CounterLimit) VALUES (9,'MessagesCount',7200);
  41.  
  42. 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%)
  43. 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%)
  44. 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%)
  45.  
  46. [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"
  47. [2015/07/01-14:20:18 - 2632] [CORE] INFO: Starting "1" children
  48. [2015/07/01-14:20:18 - 2737] [CORE] DEBUG: Child Preforked (2737)
  49. [2015/07/01-14:20:18 - 2737] [CBPOLICYD] DEBUG: Starting up caching engine
  50. [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: No session tracking data exists for request: $VAR1 = {'size' => '366',
  51. 'client_name' => '22-222-22-222.dynamic.chello.pl',
  52. 'client_address' => '22.222.22.222',
  53. 'request' => 'smtpd_access_policy',
  54. 'protocol_state' => 'RCPT',
  55. 'encryption_cipher' => 'ECDHE-RSA-AES256-SHA',
  56. '_timestamp' => 1435753218,
  57. 'sasl_sender' => '',
  58. 'instance' => 'aab.5593db02.d39f9.0',
  59. 'etrn_domain' => '',
  60. 'reverse_client_name' => '22-222-22-222.dynamic.chello.pl',
  61. '_protocol_transport' => 'Postfix',
  62. 'stress' => '',
  63. 'sasl_method' => 'PLAIN',
  64. 'sender' => 'guest@abcxyz.pl',
  65. 'helo_name' => '[192.168.0.10]',
  66. 'ccert_fingerprint' => '',
  67. 'ccert_pubkey_fingerprint' => '',
  68. 'encryption_keysize' => '256',
  69. 'protocol_name' => 'ESMTP',
  70. 'sasl_username' => 'guest@abcxyz.pl',
  71. 'recipient' => '2222222@gmail.com',
  72. 'recipient_count' => '0',
  73. 'queue_id' => '',
  74. 'ccert_subject' => '',
  75. 'ccert_issuer' => '',
  76. 'encryption_protocol' => 'TLSv1.2'
  77. };
  78. [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',
  79. 'client_address' => '22.222.22.222',
  80. 'request' => 'smtpd_access_policy',
  81. 'protocol_state' => 'RCPT',
  82. 'encryption_cipher' => 'ECDHE-RSA-AES256-SHA',
  83. '_timestamp' => 1435753218,
  84. 'sasl_sender' => '',
  85. 'instance' => 'aab.5593db02.d39f9.0',
  86. 'etrn_domain' => '',
  87. 'reverse_client_name' => '22-222-22-222.dynamic.chello.pl',
  88. '_protocol_transport' => 'Postfix',
  89. 'stress' => '',
  90. 'sasl_method' => 'PLAIN',
  91. 'sender' => 'guest@abcxyz.pl',
  92. 'helo_name' => '[192.168.0.10]',
  93. 'ccert_fingerprint' => '',
  94. 'ccert_pubkey_fingerprint' => '',
  95. 'encryption_keysize' => '256',
  96. 'protocol_name' => 'ESMTP',
  97. 'sasl_username' => 'guest@abcxyz.pl',
  98. 'recipient' => '2222222@gmail.com',
  99. 'recipient_count' => '0',
  100. 'queue_id' => '',
  101. 'ccert_subject' => '',
  102. 'ccert_issuer' => '',
  103. 'encryption_protocol' => 'TLSv1.2'};
  104. [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Protocol state is 'RCPT', resolving policy...
  105. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: Going to resolve session data into policy: $VAR1 = {
  106. 'Recipient' => '2222222@gmail.com',
  107. 'Helo' => '[192.168.0.10]',
  108. 'QueueID' => '',
  109. 'Size' => '1',
  110. 'RecipientData' => '',
  111. 'SASLUsername' => 'guest@abcxyz.pl',
  112. 'EncryptionKeySize' => '256',
  113. 'EncryptionCipher' => 'ECDHE-RSA-AES256-SHA',
  114. 'SASLSender' => '',
  115. 'Protocol' => 'ESMTP',
  116. 'Instance' => 'aab.5593db02.d39f9.0',
  117. 'ClientName' => '22-222-22-222.dynamic.chello.pl',
  118. 'Sender' => 'guest@abcxyz.pl',
  119. 'ClientAddress' => '22.222.22.222',
  120. 'EncryptionProtocol' => 'TLSv1.2',
  121. 'ClientReverseName' => '22-222-22-222.dynamic.chello.pl',
  122. 'SASLMethod' => 'PLAIN' };
  123. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: Found policy member with ID '1' in policy 'Low Message Count.'
  124. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: Found policy member with ID '2' in policy 'Medium Message Count.'
  125. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: Found policy member with ID '3' in policy 'High Message Count.'
  126. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Main policy sources '%LOW,!%MEDIUM,!%HIGH'
  127. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Group 'LOW' has 1 source(s) => @abcxyz.pl
  128. [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
  129. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]=>(group:LOW): Source group result: matched=1
  130. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Group 'MEDIUM' has 1 source(s) => medium@abcxyz.pl
  131. [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
  132. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]=>(group:MEDIUM): Source group result: matched=0
  133. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Group 'HIGH' has 1 source(s) => high@abcxyz.pl
  134. [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
  135. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]=>(group:HIGH): Source group result: matched=0
  136. [2015/07/01-14:20:18 - 2633] [POLICIES] INFO: [ID:1/Name:Low Message Count.]: Source matching result: matched=1
  137. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:1/Name:Low Message Count.]: Destination not defined or 'any', explicit match: matched=1
  138. [2015/07/01-14:20:18 - 2633] [POLICIES] INFO: [ID:1/Name:Low Message Count.]: Destination matching result: matched=1
  139. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:2/Name:Medium Message Count.]: Main policy sources '!%LOW,%MEDIUM,!%HIGH'
  140. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:2/Name:Medium Message Count.]: Group 'LOW' has 1 source(s) => @abcxyz.pl
  141. [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
  142. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:2/Name:Medium Message Count.]=>(group:LOW): Source group result: matched=1
  143. [2015/07/01-14:20:18 - 2633] [POLICIES] INFO: [ID:2/Name:Medium Message Count.]: Source matching result: matched=0
  144. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:3/Name:High Message Count.]: Main policy sources '!%LOW,!%MEDIUM,%HIGH'
  145. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:3/Name:High Message Count.]: Group 'LOW' has 1 source(s) => @abcxyz.pl
  146. [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
  147. [2015/07/01-14:20:18 - 2633] [POLICIES] DEBUG: [ID:3/Name:High Message Count.]=>(group:LOW): Source group result: matched=1
  148. [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
  149. [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Policy resolved into: $VAR1 = {
  150. '30' => [1]}; [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Request translated into session data: $VAR1 = {
  151. 'SASLMethod' => 'PLAIN',
  152. 'Timestamp' => 1435753218,
  153. 'ClientReverseName' => '22-222-22-222.dynamic.chello.pl', 'Policy' => {
  154. '30' => [1 ]}, 'EncryptionProtocol' => 'TLSv1.2',
  155. 'Sender' => 'guest@abcxyz.pl',
  156. 'ClientAddress' => '22.222.22.222',
  157. 'ClientName' => '22-222-22-222.dynamic.chello.pl',
  158. 'ParsedClientAddress' => {
  159. 'Mask_Long' => 4294967295,
  160. 'Broadcast' => '22.222.22.222',
  161. 'Network_Long' => 1440632779,
  162. 'Broadcast_Long' => 1440632779,
  163. 'IP' => '22.222.22.222',
  164. 'IP_Long' => 1440632779,
  165. 'Network' => '22.222.22.222'
  166. },
  167. 'Instance' => 'aab.5593db02.d39f9.0',
  168. 'Protocol' => 'ESMTP',
  169. 'SASLSender' => '',
  170. 'EncryptionCipher' => 'ECDHE-RSA-AES256-SHA',
  171. 'EncryptionKeySize' => '256',
  172. 'SASLUsername' => 'guest@abcxyz.pl',
  173. 'ProtocolState' => 'RCPT',
  174. 'ProtocolTransport' => 'Postfix',
  175. 'Size' => '1',
  176. 'RecipientData' => '',
  177. 'Helo' => '[192.168.0.10]',
  178. 'QueueID' => '',
  179. 'Recipient' => '2222222@gmail.com'
  180. };
  181. [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Got request, running modules...
  182. [2015/07/01-14:20:18 - 2633] [CBPOLICYD] INFO: Got request #1
  183. [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Running module: Quotas Plugin
  184. [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Module 'Quotas Plugin' returned CBP_CONTINUE
  185. [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Done with modules
  186. [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Protocol state is 'END-OF-MESSAGE', decoding policy...
  187. [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Decoded into: $VAR1 = {
  188. '2222222@gmail.com' => {
  189. '30' => ['1']}
  190. };
  191. [2015/07/01-14:20:18 - 2633] [TRACKING] DEBUG: Request translated into session data: $VAR1 = {
  192. 'SASLMethod' => 'PLAIN',
  193. 'ClientReverseName' => '22-222-22-222.dynamic.chello.pl',
  194. 'Timestamp' => 1435753218,
  195. 'ClientAddress' => '22.222.22.222',
  196. 'Sender' => 'guest@abcxyz.pl',
  197. 'ClientName' => '22-222-22-222.dynamic.chello.pl',
  198. 'EncryptionProtocol' => 'TLSv1.2',
  199. 'SASLSender' => '',
  200. 'EncryptionKeySize' => '256',
  201. 'EncryptionCipher' => 'ECDHE-RSA-AES256-SHA',
  202. 'ParsedClientAddress' => {
  203. 'Broadcast_Long' => 1440632779,
  204. 'Network' => '22.222.22.222',
  205. 'IP' => '22.222.22.222',
  206. 'IP_Long' => 1440632779,
  207. 'Network_Long' => 1440632779,
  208. 'Broadcast' => '22.222.22.222',
  209. 'Mask_Long' => 4294967295
  210. },
  211. 'Protocol' => 'ESMTP',
  212. 'Instance' => 'aab.5593db02.d39f9.0',
  213. 'Helo' => '[192.168.0.10]',
  214. '_Recipient_To_Policy' => {
  215. '2222222@gmail.com' => {
  216. '30' => ['1']}},
  217. 'QueueID' => 'E258BC4B0C',
  218. 'SASLUsername' => 'guest@abcxyz.pl',
  219. 'ProtocolState' => 'END-OF-MESSAGE',
  220. 'ProtocolTransport' => 'Postfix',
  221. 'Size' => '1',
  222. 'RecipientData' => '/<2222222@gmail.com>#30=1;'}; [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Got request, running modules...
  223. [2015/07/01-14:20:18 - 2633] [CBPOLICYD] INFO: Got request #2 (pipelined)
  224. [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Running module: Quotas Plugin
  225. [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Module 'Quotas Plugin' returned CBP_CONTINUE
  226. [2015/07/01-14:20:18 - 2633] [CBPOLICYD] DEBUG: Done with modules
  227.  
  228. 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;
  229. 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;
  230. 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
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!