Statistics

Hello,

I'm just curious if anyone has developed some sort of
statistics that 
shows the total statistics for a domain each month?

We have some customers that would like to have a monthly
statistics for 
their domain(s), it doesn't have to be dynamic but could be
a snapshot 
made once each month.

I see there's a ticket for it (#110), but I get a question
about 
authentication when I try to read it..

-- 
Erik Weber
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Jan 17, 2008, at 3:43 AM, Erik Weber wrote:

> Hello,
>
> I'm just curious if anyone has developed some sort of
statistics that
> shows the total statistics for a domain each month?
>
> We have some customers that would like to have a
monthly statistics  
> for
> their domain(s), it doesn't have to be dynamic but
could be a snapshot
> made once each month.
>
> I see there's a ticket for it (#110), but I get a
question about
> authentication when I try to read it..
>


It's top secret.  Now I gotta shoot ya.

No, actually, it was a popular target for spam before I
locked down  
anonymous posting in the ticket system, so I had blocked it,
and I  
guess I never got it opened up.

Should work for you now.


David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (Darwin)

iD8DBQFHjy9AUy30ODPkzl0RAvhyAJ422vodVa1aQ+rcFSvQXwnTAfeOhACg
lX0E
AKZlsZccAtUxPESkGUfyi1w=
=ksrl
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

David Morton wrote:
> On Jan 17, 2008, at 3:43 AM, Erik Weber wrote:
>> Hello,
>>
>> I'm just curious if anyone has developed some sort
of statistics that
>> shows the total statistics for a domain each
month?
>>
>> We have some customers that would like to have a
monthly statistics for
>> their domain(s), it doesn't have to be dynamic but
could be a snapshot
>> made once each month.
>>
>> I see there's a ticket for it (#110), but I get a
question about
>> authentication when I try to read it..
>>
>
> It's top secret.  Now I gotta shoot ya.
>
> No, actually, it was a popular target for spam before I
locked down 
> anonymous posting in the ticket system, so I had
blocked it, and I 
> guess I never got it opened up.
>
> Should work for you now.

Great, thanks! Not really what I was looking for though.. I
took a quick 
look at the database and it seems that suspected_ham /
suspected_spam 
never gets stored after it expires.. In the ultimate world
one could 
assume that everyone keep their quarantine up to date, but
we can't do 
that in the real word (take vacation for example, I sure
don't manage my 
quarantine when I'm away..).

Any ideas how I could solve my mission ?

-- 
Erik Weber
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Jan 17, 2008, at 6:15 AM, Erik Weber wrote:

> David Morton wrote:
>> On Jan 17, 2008, at 3:43 AM, Erik Weber wrote:
>>> Hello,
>>>
>>> I'm just curious if anyone has developed some
sort of statistics  
>>> that
>>> shows the total statistics for a domain each
month?
>>>
>>> We have some customers that would like to have
a monthly  
>>> statistics for
>>> their domain(s), it doesn't have to be dynamic
but could be a  
>>> snapshot
>>> made once each month.
>>>
>>> I see there's a ticket for it (#110), but I get
a question about
>>> authentication when I try to read it..
>>>
>>
>> It's top secret.  Now I gotta shoot ya.
>>
>> No, actually, it was a popular target for spam
before I locked down  
>> anonymous posting in the ticket system, so I had
blocked it, and I  
>> guess I never got it opened up.
>>
>> Should work for you now.
>
> Great, thanks! Not really what I was looking for
though.. I took a  
> quick look at the database and it seems that
suspected_ham /  
> suspected_spam never gets stored after it expires.. In
the ultimate  
> world one could assume that everyone keep their
quarantine up to  
> date, but we can't do that in the real word (take
vacation for  
> example, I sure don't manage my quarantine when I'm
away..).
>
> Any ideas how I could solve my mission ?

Well, that's the goal of the 1.1 milestone, now in trunk. 
The stats  
columns for suspected* are now ever increasing counters, not
just a  
repeat of the count in the current cache.  It's stored per
address,  
which means the stats for a domain is just a SUM() away.

See the links under htt
p://www.maiamailguard.org/maia/milestone/1.1.0



David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (Darwin)

iD8DBQFHj1mMUy30ODPkzl0RAl3JAJ4tYsleEvooTmzrSScAHjqWZlb+VQCg
j4Nv
eYskR5zuTB4Scsu5zA3Wzlc=
=z1JA
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

David Morton wrote:
> On Jan 17, 2008, at 6:15 AM, Erik Weber wrote:
>> David Morton wrote:
>>> On Jan 17, 2008, at 3:43 AM, Erik Weber wrote:
>>>> Hello,
>>>>
>>>> I'm just curious if anyone has developed
some sort of statistics that
>>>> shows the total statistics for a domain
each month?
>>>>
>>>> We have some customers that would like to
have a monthly statistics 
>>>> for
>>>> their domain(s), it doesn't have to be
dynamic but could be a snapshot
>>>> made once each month.
>>>>
>>>> I see there's a ticket for it (#110), but I
get a question about
>>>> authentication when I try to read it..
>>>>
>>>
>>> It's top secret.  Now I gotta shoot ya.
>>>
>>> No, actually, it was a popular target for spam
before I locked down 
>>> anonymous posting in the ticket system, so I
had blocked it, and I 
>>> guess I never got it opened up.
>>>
>>> Should work for you now.
>>
>> Great, thanks! Not really what I was looking for
though.. I took a 
>> quick look at the database and it seems that
suspected_ham / 
>> suspected_spam never gets stored after it expires..
In the ultimate 
>> world one could assume that everyone keep their
quarantine up to 
>> date, but we can't do that in the real word (take
vacation for 
>> example, I sure don't manage my quarantine when I'm
away..).
>>
>> Any ideas how I could solve my mission ?
>
> Well, that's the goal of the 1.1 milestone, now in
trunk.  The stats 
> columns for suspected* are now ever increasing
counters, not just a 
> repeat of the count in the current cache.  It's stored
per address, 
> which means the stats for a domain is just a SUM()
away.
>
> See the links under htt
p://www.maiamailguard.org/maia/milestone/1.1.0

I just did that, and took a look at the branch.. I noticed a
comment 
(think it was the expire-quarantine script) that said
"DO NOT USE!!", so 
my next question is: is this safe/possible to backport to
1.0.2a?

All I need is the change that actually make sure that all
values are 
stored so that I can make my own report, the rest of the
functionality I 
can wait for like the rest..

-- 
Erik Weber
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Jan 17, 2008, at 8:03 AM, Erik Weber wrote:
>
> I just did that, and took a look at the branch.. I
noticed a comment  
> (think it was the expire-quarantine script) that said
"DO NOT  
> USE!!", so my next question is: is this
safe/possible to backport to  
> 1.0.2a?
>
> All I need is the change that actually make sure that
all values are  
> stored so that I can make my own report, the rest of
the  
> functionality I can wait for like the rest..
>


No, it cannot be backported - it's a major database schema
change. In  
fact, while upgrading, it will probably be recommended to
drop the  
stats and start over, because the current stats will not be
correct  
with the new calculations.

Trunk is working fairly well right now, but I don't have the
upgrade  
path finished. :(

David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (Darwin)

iD8DBQFHj2KdUy30ODPkzl0RAizeAJ9L/OL7DoOnGP40rjYe/343Wd9+UQCg
sJ0U
R7nrDs8zb8wlS8iFDMzr0tg=
=kspf
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users