Hi Drew, Can you post the content of the other tables? like: *quotas*, *quotas_limits*, *policy_groups*, *policy_members*, *policy_group_members* and *policies*
Best, Diogo Em qua., 1 de abr. de 2020 às 11:08, Drew Weaver via Users < [email protected]> escreveu: > 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 <[email protected]> *On Behalf Of *Drew > Weaver via Users > *Sent:* Tuesday, March 31, 2020 12:32 PM > *To:* '[email protected]' <[email protected]> > *Cc:* Drew Weaver <[email protected]> > *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 > [email protected] > http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org >
_______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
