Howdy,
I'm trying to set up cluebringer v2.0.14-1 to do quotas on a mail server
that's outgoing mail only. I think I have the policies set up
correctly, but I'm getting a lot of NULL values in the Counter column of
quotas_tracking, which is causing arithmetic errors in the log ("Use of
uninitialized value..."). Deleting the NULL entries doesn't appear to
change anything.
Note also that a previously numeric value occasionally changes to NULL.
Configurations and tables follow.
Names, Domains, and IP information has been removed to protect the innocent.
cluebringer.conf :
[server]
protocols=<<EOT
Postfix
Bizanga
EOT
modules=<<EOT
Core
AccessControl
CheckHelo
CheckSPF
Greylisting
Quotas
EOT
min_servers=4
min_spare_servers=4
max_spare_servers=12
max_servers=25
max_requests=1000
log_level=4
log_mail=maillog
[database]
DSN=DBI:mysql:database=policyd;host=localhost
Username=USERNAME
Password=PASSWORD
bypass_mode=pass
bypass_timeout=30
[AccessControl]
enable=0
[Greylisting]
enable=0
[CheckHelo]
enable=0
[CheckSPF]
enable=0
[Quotas]
enable=1
---------------------------------------
mysql> select * from policies;
+----+------------+----------+-----------------------+----------+
| ID | Name | Priority | Description | Disabled |
+----+------------+----------+-----------------------+----------+
| 1 | Default | 0 | Default System Policy | 1 |
| 7 | SASL users | 10 | SASL users | 0 |
+----+------------+----------+-----------------------+----------+
mysql> select * from policy_group_members;
+----+---------------+----------------------+----------+---------+
| ID | PolicyGroupID | Member | Disabled | Comment |
+----+---------------+----------------------+----------+---------+
| 1 | 1 | 10.0.0.0/8 | 0 | NULL |
| 2 | 2 | @domain1.com | 0 | NULL |
| 3 | 2 | @domain2.com | 0 | NULL |
| 4 | 1 | 199.99.193.38 | 0 | |
| 6 | 1 | 127.0.0.1 | 0 | |
| 8 | 4 | 199.99.192.0/19 | 0 | |
| 9 | 3 | [email protected] | 0 | |
| 10 | 3 | $zen-notes | 0 | |
| 11 | 2 | @domain3.com | 0 | |
| 12 | 2 | @domain4.net | 0 | |
| 13 | 1 | 199.99.193.57 | 0 | |
| 14 | 4 | 2608:3600::/32 | 1 | |
| 15 | 3 | $hanrahan | 0 | |
+----+---------------+----------------------+----------+---------+
mysql> select * from policy_members;
+----+----------+---------------+-------------+---------+----------+
| ID | PolicyID | Source | Destination | Comment | Disabled |
+----+----------+---------------+-------------+---------+----------+
| 1 | 1 | NULL | NULL | NULL | 0 |
| 8 | 7 | $* | any | | 0 |
| 9 | 7 | !%hi-vol-sasl | any | | 0 |
| 10 | 7 | !%My_Network | any | | 0 |
| 15 | 7 | !$- | any | any | 0 |
+----+----------+---------------+-------------+---------+----------+
mysql> select * from policy_groups;
+----+------------------+----------+---------+
| ID | Name | Disabled | Comment |
+----+------------------+----------+---------+
| 1 | internal_ips | 0 | NULL |
| 2 | internal_domains | 0 | NULL |
| 3 | hi-vol-sasl | 0 | |
| 4 | My_Network | 0 | |
+----+------------------+----------+---------+
mysql> select * from quotas;
+----+----------+---------------------------+--------------+--------+---------+------+-------------------------------------------------------+----------+
| ID | PolicyID | Name | Track | Period |
Verdict | Data | Comment |
Disabled |
+----+----------+---------------------------+--------------+--------+---------+------+-------------------------------------------------------+----------+
| 3 | 7 | SASL Sending Restrictions | SASLUsername | 3600 |
REJECT | 300 | Limit outgoing mail per sasl_username to 300 per hour |
0 |
+----+----------+---------------------------+--------------+--------+---------+------+-------------------------------------------------------+----------+
mysql> select * from quotas_tracking;
+----------------+-------------------------------------+------------+---------+
| QuotasLimitsID | TrackKey | LastUpdate |
Counter |
+----------------+-------------------------------------+------------+---------+
| 4 | SASLUsername: | 1395171854 |
6.8409 |
| 4 | SASLUsername:[email protected] | 1395171616 |
1.0000 |
| 4 | SASLUsername:mpomeroy | 1395171673 |
1.0000 |
| 4 | SASLUsername:pathansen | 1395171675 |
1.0000 |
| 4 | SASLUsername:shbats | 1395171952 |
NULL |
| 4 | SASLUsername:madreiya | 1395171686 |
1.0000 |
| 4 | SASLUsername:cheetahs | 1395171688 |
1.0000 |
| 4 | SASLUsername:[email protected] | 1395171768 |
1.0000 |
| 4 | SASLUsername:jcw | 1395171713 |
1.0000 |
| 4 | SASLUsername:kps | 1395171718 |
1.0000 |
| 4 | SASLUsername:[email protected] | 1395171777 |
1.0000 |
| 4 | SASLUsername:[email protected] | 1395171789 |
NULL |
| 4 | SASLUsername:kcwhitaker | 1395171840 |
NULL |
| 4 | SASLUsername:aauser | 1395171819 |
NULL |
| 4 | SASLUsername:deana | 1395171829 |
NULL |
--------------
/var/log/cbpolicyd.log:
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: Process Backgrounded
[2014/03/18-12:38:14 - 19489] [CBPOLICYD] NOTICE: Policyd v2 /
Cluebringer - v2.0.14-1
[2014/03/18-12:38:14 - 19489] [CBPOLICYD] NOTICE: Initializing system
modules.
[2014/03/18-12:38:14 - 19489] [CBPOLICYD] NOTICE: System modules
initialized.
[2014/03/18-12:38:14 - 19489] [CBPOLICYD] NOTICE: Module load started...
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: => AccessControl: enabled
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: => CheckHelo: enabled
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: => CheckSPF: enabled
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: => Greylisting: enabled
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: => Quotas: enabled
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: => Protocol(Postfix): enabled
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: => Protocol(Bizanga): enabled
[2014/03/18-12:38:14 - 19489] [CBPOLICYD] NOTICE: Module load done.
[2014/03/18-12:38:14 - 19489] [CBPOLICYD] DEBUG: Opening syslog,
destination = 'unix', facility = 'mail'.
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: 2014/03/18-12:38:14 cbp
(type Net::Server::PreFork) starting! pid(19489)
[2014/03/18-12:38:14 - 19489] [CORE] NOTICE: Binding to TCP port 10031
on host *
[2014/03/18-12:38:14 - 19489] [CORE] WARNING: Group Not Defined.
Defaulting to EGID '5002 5002'
[2014/03/18-12:38:14 - 19489] [CORE] INFO: Setting up serialization via
flock
[2014/03/18-12:38:14 - 19489] [CORE] INFO: Beginning prefork (4 processes)
[2014/03/18-12:38:14 - 19489] [CORE] INFO: Starting "4" children
[2014/03/18-12:38:14 - 19490] [CORE] DEBUG: Child Preforked (19490)
[2014/03/18-12:38:14 - 19490] [CBPOLICYD] DEBUG: Starting up caching engine
[2014/03/18-12:38:14 - 19491] [CORE] DEBUG: Child Preforked (19491)
[2014/03/18-12:38:14 - 19491] [CBPOLICYD] DEBUG: Starting up caching engine
[2014/03/18-12:38:14 - 19492] [CORE] DEBUG: Child Preforked (19492)
[2014/03/18-12:38:14 - 19492] [CORE] DEBUG: Child Preforked (19492)
[2014/03/18-12:38:14 - 19492] [CBPOLICYD] DEBUG: Starting up caching engine
[2014/03/18-12:38:14 - 19489] [CORE] DEBUG: Parent ready for children.
[2014/03/18-12:38:14 - 19493] [CORE] DEBUG: Child Preforked (19493)
[2014/03/18-12:38:14 - 19493] [CBPOLICYD] DEBUG: Starting up caching engine
[2014/03/18-12:39:40 - 19489] [CORE] INFO: Starting "1" children
[2014/03/18-12:39:40 - 19490] [CORE] INFO: 2014/03/18-12:39:40 CONNECT
TCP Peer: "127.0.0.1:59558" Local: "127.0.0.1:10031"
[2014/03/18-12:39:40 - 20440] [CORE] DEBUG: Child Preforked (20440)
[2014/03/18-12:39:40 - 20440] [CBPOLICYD] DEBUG: Starting up caching engine
[2014/03/18-12:39:40 - 19490] [CBPOLICYD] INFO: Got request #1
[2014/03/18-12:39:40 - 19490] [CBPOLICYD] INFO: Got request #2 (pipelined)
[2014/03/18-12:40:08 - 19491] [CORE] INFO: 2014/03/18-12:40:08 CONNECT
TCP Peer: "127.0.0.1:59560" Local: "127.0.0.1:10031"
[2014/03/18-12:40:08 - 19489] [CORE] INFO: Starting "1" children
[2014/03/18-12:40:08 - 20679] [CORE] DEBUG: Child Preforked (20679)
[2014/03/18-12:40:08 - 20679] [CBPOLICYD] DEBUG: Starting up caching engine
[2014/03/18-12:40:08 - 19491] [CBPOLICYD] INFO: Got request #1
[2014/03/18-12:40:09 - 19491] [CBPOLICYD] INFO: Got request #2 (pipelined)
[2014/03/18-12:40:10 - 20440] [CORE] INFO: 2014/03/18-12:40:10 CONNECT
TCP Peer: "127.0.0.1:59563" Local: "127.0.0.1:10031"
[2014/03/18-12:40:10 - 19489] [CORE] INFO: Starting "1" children
[2014/03/18-12:40:10 - 20713] [CORE] DEBUG: Child Preforked (20713)
[2014/03/18-12:40:10 - 20713] [CBPOLICYD] DEBUG: Starting up caching engine
[2014/03/18-12:40:11 - 20440] [CBPOLICYD] INFO: Got request #1
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 310, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 310, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 310, <_READ> line 1.
[2014/03/18-12:40:12 - 20440] [CBPOLICYD] INFO: Got request #2 (pipelined)
[2014/03/18-12:40:12 - 20440] [CBPOLICYD] INFO: Got request #3 (pipelined)
Use of uninitialized value in multiplication (*) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 177, <_READ> line 1.
Use of uninitialized value in subtraction (-) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 182, <_READ> line 1.
Use of uninitialized value in multiplication (*) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 177, <_READ> line 1.
Use of uninitialized value in multiplication (*) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 177, <_READ> line 1.
Use of uninitialized value in multiplication (*) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 177, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 310, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 310, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 310, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 310, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 310, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
Use of uninitialized value in addition (+) at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 253, <_READ> line 1.
<snipped... you get the idea>
-----------------------------
'/var/log/mail.log |grep cbpolicyd' for single user:
Mar 18 12:43:40 white cbpolicyd[20679]: module=Quotas, mode=create,
host=50.39.227.43, helo=aauser, [email protected],
[email protected], reason=quota_create, policy=7, quota=3, limit=4,
track=SASLUsername:aauser, counter=MessageCount, quota=4.00/300 (1.3%)
Mar 18 12:43:40 white cbpolicyd[20679]: module=Quotas, mode=update,
host=50.39.227.43, helo=aauser, [email protected],
[email protected], reason=quota_update, policy=7, quota=3, limit=4,
track=SASLUsername:aauser, counter=MessageCount, quota=0.00/300 (0.0%)
Mar 18 12:43:40 white cbpolicyd[20679]: module=Quotas, mode=update,
host=50.39.227.43, helo=aauser, [email protected],
[email protected], reason=quota_update, policy=7, quota=3, limit=4,
track=SASLUsername:aauser, counter=MessageCount, quota=0.00/300 (0.0%)
Mar 18 12:43:40 white cbpolicyd[20679]: module=Quotas, mode=update,
host=50.39.227.43, helo=aauser, [email protected],
[email protected], reason=quota_update, policy=7, quota=3, limit=4,
track=SASLUsername:aauser, counter=MessageCount, quota=0.00/300 (0.0%)
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
