On Mon, 28 Sep 2009, Shelley Waltz wrote:
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
My goal here is to have quotas(cumulative) for entire domain outgoing
and to monitor this for some time before instituting a limit. I have the
message count at 1800/hour and wish to view the counter in the database
or the log file so I can determine a realistic limit.
I do not seem to be able to locate the value in the database so I can see
that my outbound policy is working and what the outgoing count is.
Any help getting the number is appreciated.
S
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users
