On Mon, 28 Sep 2009, Nigel Kukard wrote: On 09/28/09 14:53, Shelley Waltz wrote: > On Mon, 28 Sep 2009, Shelley Waltz wrote: > > I have set up policyd to use quotas. I wish to have a limit on > the number of outgoing emails from my domain. I have set up the > Default Outbound Policy to track Sender:u...@domain and have defined > my domain. The limit is set at MessageCount with a CounterLimit of 1800. > > I set the counter limit high as I wish to monitor for a period in order > to set a realistic value. > > My question is - where/what value in the mysql database holds the information > on the current value of the counter for outgoing messages? > > I look at the database, but cannot determine which field this is. > > thanks for any help or advise, > Shelley > > > > Actually my tracking is Sender:@domain as I wished a cumulative outgoing > quota for the entire domain, not by user. I see data in session_tracking, > but where is the cummulative count stored for the period? Its a rolling counter in table quota_tracking :) -N _____________________________________________
I cannot seem to see what is in this table ... mysql> show tables; +---------------------------+ | Tables_in_policyd | +---------------------------+ | access_control | | amavis_rules | | checkhelo | | checkhelo_blacklist | | checkhelo_tracking | | checkhelo_whitelist | | checkspf | | greylisting | | greylisting_autoblacklist | | greylisting_autowhitelist | | greylisting_tracking | | greylisting_whitelist | | policies | | policy_group_members | | policy_groups | | policy_members | | quotas | | quotas_limits | | quotas_tracking | | session_tracking | +---------------------------+ 20 rows in set (0.00 sec) mysql> select * from quotas; +----+----------+-------------------+-----------------------+--------+---------+------+---------+----------+ | ID | PolicyID | Name | Track | Period | Verdict | Data | Comment | Disabled | +----+----------+-------------------+-----------------------+--------+---------+------+---------+----------+ | 1 | 5 | Recipient quotas | Recipient:u...@domain | 3600 | REJECT | NULL | NULL | 1 | | 2 | 5 | Quota on all /24s | SenderIP:/24 | 3600 | REJECT | NULL | NULL | 1 | | 3 | 2 | Throttle Outbound | Sender:@domain | 3600 | REJECT | | | 0 | +----+----------+-------------------+-----------------------+--------+---------+------+---------+----------+ 3 rows in set (0.00 sec) mysql> select * from quotas_limits; +----+----------+-----------------------+--------------+---------+----------+ | ID | QuotasID | Type | CounterLimit | Comment | Disabled | +----+----------+-----------------------+--------------+---------+----------+ | 1 | 1 | MessageCount | 10 | NULL | 0 | | 2 | 1 | MessageCumulativeSize | 8000 | NULL | 0 | | 3 | 2 | MessageCount | 12 | NULL | 0 | | 4 | 3 | MessageCount | 1800 | | 0 | +----+----------+-----------------------+--------------+---------+----------+ 4 rows in set (0.00 sec) mysql> select * from quotas_tracking; Empty set (0.00 sec) mysql> Did this not get set up properly? _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
