I can pay for someone to take a look at this... we run an MTA for a bunch of
elderly people in rural Ohio and their accounts keep getting compromised
because they use easy passwords and then the MTA's reputation gets impacted by
the volume of mail before we can shut down the compromised account and then
they cannot communicate with their families.
From: Users <users-boun...@lists.policyd.org> On Behalf Of Drew Weaver via Users
Sent: Tuesday, March 31, 2020 12:32 PM
To: 'users@lists.policyd.org' <users@lists.policyd.org>
Cc: Drew Weaver <drew.wea...@thenap.com>
Subject: [policyd-users] quotas_tracking table empty on new server
Hi,
We migrated a postfix server from CentOS 6 to CentOS 7.
We basically just copied all of the settings for postfix and policyd.
All we are trying to do is limit outbound mail for SASL users to 100 messages
per hour:
MariaDB [policyd]> select * from quotas;
+----+----------+----------------+--------------+--------+---------+------+-----------+---------+----------+
| ID | PolicyID | Name | Track | Period | Verdict | Data |
LastQuota | Comment | Disabled |
+----+----------+----------------+--------------+--------+---------+------+-----------+---------+----------+
| 3 | 2 | Outbound Quota | SASLUsername | 3600 | REJECT | 0 |
0 | | 0 |
+----+----------+----------------+--------------+--------+---------+------+-----------+---------+----------+
1 row in set (0.00 sec)
MariaDB [policyd]> select * from quotas_limits;
+----+----------+--------------+--------------+---------+----------+
| ID | QuotasID | Type | CounterLimit | Comment | Disabled |
+----+----------+--------------+--------------+---------+----------+
| 4 | 3 | MessageCount | 100 | | 0 |
+----+----------+--------------+--------------+---------+----------+
1 row in set (0.00 sec)
MariaDB [policyd]> select * from quotas_tracking;
Empty set (0.00 sec)
MariaDB [policyd]> select * from policies JOIN policy_members on policies.ID =
policy_members.PolicyID where name = 'Default Outbound';
+----+------------------+----------+--------------------------------+----------+----+----------+--------+--------------------+---------+----------+
| ID | Name | Priority | Description | Disabled
| ID | PolicyID | Source | Destination | Comment | Disabled |
+----+------------------+----------+--------------------------------+----------+----+----------+--------+--------------------+---------+----------+
| 2 | Default Outbound | 10 | Default Outbound System Policy | 0
| 2 | 2 | $* | !%internal_domains | NULL | 0 |
+----+------------------+----------+--------------------------------+----------+----+----------+--------+--------------------+---------+----------+
1 row in set (0.00 sec)
MariaDB [policyd]> select * from policy_groups JOIN policy_group_members on
policy_groups.ID = policy_group_members.PolicyGroupID where policy_groups.Name
= "internal_domains";
+----+------------------+----------+---------+----+---------------+---------+----------+---------+
| ID | Name | Disabled | Comment | ID | PolicyGroupID | Member |
Disabled | Comment |
+----+------------------+----------+---------+----+---------------+---------+----------+---------+
| 2 | internal_domains | 0 | NULL | 3 | 2 |
@ouractualdomain.net | 0 | NULL |
+----+------------------+----------+---------+----+---------------+---------+----------+---------+
1 row in set (0.00 sec)
Here are the log entries:
[2020/03/31-12:27:33 - 24534] [CORE] NOTICE: Process Backgrounded
[2020/03/31-12:27:33 - 24534] [CBPOLICYD] NOTICE: PolicyD v2 / Cluebringer -
v2.1.x-201205100639
[2020/03/31-12:27:33 - 24534] [CBPOLICYD] NOTICE: Initializing system modules.
[2020/03/31-12:27:33 - 24534] [CBPOLICYD] NOTICE: System modules initialized.
[2020/03/31-12:27:33 - 24534] [CBPOLICYD] NOTICE: Module load started...
[2020/03/31-12:27:33 - 24534] [CORE] NOTICE: => Quotas: enabled
[2020/03/31-12:27:33 - 24534] [CORE] NOTICE: => Protocol(Postfix): enabled
[2020/03/31-12:27:33 - 24534] [CBPOLICYD] NOTICE: Module load done.
[2020/03/31-12:27:33 - 24534] [CBPOLICYD] NOTICE: Session tracking is ENABLED.
[2020/03/31-12:27:33 - 24534] [CBPOLICYD] DEBUG: Opening syslog, destination =
'native', facility = 'mail'.
[2020/03/31-12:27:33 - 24534] [CORE] NOTICE: 2020/03/31-12:27:33 cbp (type
Net::Server::PreFork) starting! pid(24534)
[2020/03/31-12:27:33 - 24534] [CORE] NOTICE: Resolved [*]:10031 to
[0.0.0.0]:10031, IPv4
[2020/03/31-12:27:33 - 24534] [CORE] NOTICE: Binding to TCP port 10031 on host
0.0.0.0 with IPv4
[2020/03/31-12:27:33 - 24534] [CORE] NOTICE: Setting gid to "1899 1899"
[2020/03/31-12:27:33 - 24534] [CORE] NOTICE: Setting uid to "1899"
[2020/03/31-12:27:33 - 24534] [CORE] INFO: Setting up serialization via flock
[2020/03/31-12:27:33 - 24534] [CORE] INFO: Beginning prefork (4 processes)
[2020/03/31-12:27:33 - 24534] [CORE] INFO: Starting "4" children
[2020/03/31-12:27:33 - 24536] [CORE] DEBUG: Child Preforked (24536)
[2020/03/31-12:27:33 - 24536] [CBPOLICYD] DEBUG: Starting up caching engine
[2020/03/31-12:27:33 - 24537] [CORE] DEBUG: Child Preforked (24537)
[2020/03/31-12:27:33 - 24537] [CBPOLICYD] DEBUG: Starting up caching engine
[2020/03/31-12:27:33 - 24534] [CORE] DEBUG: Parent ready for children.
[2020/03/31-12:27:33 - 24538] [CORE] DEBUG: Child Preforked (24538)
[2020/03/31-12:27:33 - 24538] [CBPOLICYD] DEBUG: Starting up caching engine
[2020/03/31-12:27:33 - 24539] [CORE] DEBUG: Child Preforked (24539)
[2020/03/31-12:27:33 - 24539] [CBPOLICYD] DEBUG: Starting up caching engine
[2020/03/31-12:27:36 - 24534] [CORE] INFO: Starting "1" children
[2020/03/31-12:27:36 - 24536] [CORE] INFO: 2020/03/31-12:27:36 CONNECT TCP
Peer: "[127.0.0.1]:56756" Local: "[127.0.0.1]:10031"
[2020/03/31-12:27:36 - 24552] [CORE] DEBUG: Child Preforked (24552)
[2020/03/31-12:27:36 - 24552] [CBPOLICYD] DEBUG: Starting up caching engine
[2020/03/31-12:27:36 - 24536] [CBPOLICYD] INFO: Got request #1
[2020/03/31-12:27:36 - 24536] [CBPOLICYD] INFO: Got request #2 (pipelined)
[2020/03/31-12:27:46 - 24537] [CORE] INFO: 2020/03/31-12:27:46 CONNECT TCP
Peer: "[127.0.0.1]:56758" Local: "[127.0.0.1]:10031"
[2020/03/31-12:27:46 - 24534] [CORE] INFO: Starting "1" children
[2020/03/31-12:27:46 - 24575] [CORE] DEBUG: Child Preforked (24575)
[2020/03/31-12:27:46 - 24575] [CBPOLICYD] DEBUG: Starting up caching engine
[2020/03/31-12:27:46 - 24537] [CBPOLICYD] INFO: Got request #1
[2020/03/31-12:27:46 - 24534] [CORE] INFO: Starting "1" children
[2020/03/31-12:27:46 - 24552] [CORE] INFO: 2020/03/31-12:27:46 CONNECT TCP
Peer: "[127.0.0.1]:56760" Local: "[127.0.0.1]:10031"
[2020/03/31-12:27:46 - 24579] [CORE] DEBUG: Child Preforked (24579)
[2020/03/31-12:27:46 - 24579] [CBPOLICYD] DEBUG: Starting up caching engine
[2020/03/31-12:27:46 - 24552] [CBPOLICYD] INFO: Got request #1
[2020/03/31-12:27:46 - 24552] [CBPOLICYD] INFO: Got request #2 (pipelined)
[2020/03/31-12:27:46 - 24537] [CBPOLICYD] INFO: Got request #2 (pipelined)
Does anyone know why the quotas_tracking table is not being populated?
_______________________________________________
Users mailing list
Users@lists.policyd.org
http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
