On Mon, 28 Sep 2009, Hugo Monteiro wrote: Shelley Waltz wrote: > 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 > > Try in mysql: desc quotas_tracking; Regards, Hugo Monteiro. OK, thanks ... mysql> desc quotas_tracking; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | QuotasLimitsID | bigint(20) unsigned | YES | MUL | NULL | | | TrackKey | varchar(512) | YES | | NULL | | | LastUpdate | bigint(20) unsigned | YES | MUL | NULL | | | Counter | decimal(10,4) | YES | | NULL | | +----------------+---------------------+------+-----+---------+-------+ 4 rows in set (0.00 sec)
Does this say the counter is zero or NULL - which field is the counter - Counter? _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
