Spam stats

[chasxmd]

Hello,

I've tried/am using Munin, AwStats, and MailGraph (which I highly recommend). I just can't seem to get the stat's I want. I want a graph or some kind of stats displaying how many valid e-mails vs. e-mail's tagged spam come through my server. Has anyone ran into something they really like or can recomment?

I recently installed ispconfig about a month ago and despite the long hours of trying to tweak it to my liking I'm very happy with it. I am running the latest stable on Fedora Core 8.

Thanks you,
Charles

[chasxmd]

Nevermind, I ran into this:
http://midnightcode.org/projects/spamstats/

I highly recommend it. Looks sharp and is fairly easy to install.

[mumbly]

Hi !
Thanx for the trick ...
but it seems it does not work with Ubuntu 8.04 Hardy Heron ...
this is not the same paths ... and there is no /etc/mail/spamassassin/ repository ...

The database is filled correctly (as i can see spam field increasing) but there is no graph on the Reports/spam statistics page !
Moreover, the summury are empty :

The summary of analysis for today (since midnight local time);
A total volume of 0 email messages have been processed in the past 10 hours.
Of these, 0 messages (0.00%) have been rejected as spam.
The remaining 0 messages were processed and routed as mail.

... but i know there are more than 15 spam in the last few minutes ...

Any idea ?
THANX !

[falko]

Did you switch off Apparmor?

[mumbly]

Yes !!!
Apparmor is switched off
I've redone /etc/init.d/apparmor stop to be sure ...
But the graphs and the stats are still empty
And that's what i have in MySQL :
day username domain spam ham
2008-05-09 web1_admins2ii 152 4
2008-05-09 web1_mumbly 68 1
2008-05-10 web1_admins2ii 79 0
2008-05-10 web1_mumbly 37 1

[falko]

Any errors in your logs?

[mumbly]

No errors in my logs ...
I've installed again spamstats on another server with Ubuntu 8.04 and this is the same result ...
Hard luck ...
PS : i must say that the .pkg file did not install the spam database correctly. I had to do it by hand ...

[mumbly]

IT WORKS !
In fact, the pkg file did not instal all the requested files : Stats.pm was not installed at all and local.cf was not updated with the spamstats SQL infos.
I have just read the readme file included in the pkg file and it was the clear for me !
Moreover, the readme file says that one must do some "changes" for the spamassassin "server" AND for the spamassassin ispconfig. as i have no spamassassin "server" following the perfect server setup, it has mistaken me for some times ...
But it's clearer now !
... and the mysql database was NOT installed at all ! I've done it by hand !
Do some other people had the same issue ???

[MTvermoes]

Problems after install (CentOS Perfect Setup):

Viewing report after install (Clicking 'Spam Statistics') :

MSIE : Stats is Reported OK, but the flash graphs just shows the loading anim.

Firefox : Left frame (where the 'Spam Statistics' Link is located) just turns blank.

Any Quick Fixes

/Mark