RE: Sa stats using rrdtool?
Hi Try MailGraph :) That's what I'm using for my servers.. Google for mailgraph, first hit :) See ya -Original Message- From: MIKE YRABEDRA [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 12:04 PM To: users@spamassassin.apache.org Subject: Sa stats using rrdtool? Hello, I have googled far and wide and kind not find an answer. Does anyone know of a solution that will process a spamd log and then output the stats using rrdtool? There are tons of things using mrtg, but even by the developers opinion, mrtg is dead, rrd will take it's place.
Re: Sa stats using rrdtool?
on 6/13/05 6:07 AM, Bart Verwilst at [EMAIL PROTECTED] wrote: Hi Try MailGraph :) That's what I'm using for my servers.. Google for mailgraph, first hit :) See ya Looks good, but I think I passed it over because I am not using postfix. I am using Communigate Pro. However, my spamd writes to it's own log so maybe it will still work. Only one way to find out ;-) -Original Message- From: MIKE YRABEDRA [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 12:04 PM To: users@spamassassin.apache.org Subject: Sa stats using rrdtool? Hello, I have googled far and wide and kind not find an answer. Does anyone know of a solution that will process a spamd log and then output the stats using rrdtool? There are tons of things using mrtg, but even by the developers opinion, mrtg is dead, rrd will take it's place.
Re: Sa stats using rrdtool?
MIKE YRABEDRA wrote: on 6/13/05 6:07 AM, Bart Verwilst at [EMAIL PROTECTED] wrote: Hi Try MailGraph :) That's what I'm using for my servers.. Google for mailgraph, first hit :) See ya Looks good, but I think I passed it over because I am not using postfix. I am using Communigate Pro. However, my spamd writes to it's own log so maybe it will still work. Only one way to find out ;-) you could also try gnu plot... i was also looking for a 'drop in' graphing program and found GNUplot was exactly what i wanted... i use sa-stats.pl to read the log file then simply grep on the day pipe to a file and plot on the basis of that. v simple, clean and pretty :) ill show u the script if u want.. its only 10 or so lines long :) easy Ronan -Original Message- From: MIKE YRABEDRA [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 12:04 PM To: users@spamassassin.apache.org Subject: Sa stats using rrdtool? Hello, I have googled far and wide and kind not find an answer. Does anyone know of a solution that will process a spamd log and then output the stats using rrdtool? There are tons of things using mrtg, but even by the developers opinion, mrtg is dead, rrd will take it's place. -- Regards Ronan McGlue Info. Services QUB
Re: Sa stats using rrdtool?
on 6/13/05 8:01 AM, Ronan McGlue at [EMAIL PROTECTED] wrote: MIKE YRABEDRA wrote: on 6/13/05 6:07 AM, Bart Verwilst at [EMAIL PROTECTED] wrote: Hi Try MailGraph :) That's what I'm using for my servers.. Google for mailgraph, first hit :) See ya Looks good, but I think I passed it over because I am not using postfix. I am using Communigate Pro. However, my spamd writes to it's own log so maybe it will still work. Only one way to find out ;-) you could also try gnu plot... i was also looking for a 'drop in' graphing program and found GNUplot was exactly what i wanted... i use sa-stats.pl to read the log file then simply grep on the day pipe to a file and plot on the basis of that. v simple, clean and pretty :) ill show u the script if u want.. its only 10 or so lines long :) easy Ronan That would be awesome! Feel free to contact me off-list if you want. :-) -Mike
Re: Sa stats using rrdtool?
MIKE YRABEDRA wrote:
on 6/13/05 8:01 AM, Ronan McGlue at [EMAIL PROTECTED] wrote:
MIKE YRABEDRA wrote:
on 6/13/05 6:07 AM, Bart Verwilst at [EMAIL PROTECTED] wrote:
Hi
Try MailGraph :) That's what I'm using for my servers..
Google for mailgraph, first hit :)
See ya
Looks good, but I think I passed it over because I am not using postfix. I
am using Communigate Pro.
However, my spamd writes to it's own log so maybe it will still work.
Only one way to find out ;-)
you could also try gnu plot... i was also looking for a 'drop in'
graphing program and found GNUplot was exactly what i wanted...
i use sa-stats.pl to read the log file then simply grep on the day
pipe to a file and plot on the basis of that. v simple, clean and pretty :)
ill show u the script if u want.. its only 10 or so lines long :)
easy
Ronan
That would be awesome! Feel free to contact me off-list if you want. :-)
ive no probs showing the clunkyness of my bash'ing ability... just dont
comoment if its negative :D
feel free to note the name of the spamd server ;)
i have two scripts... one for hourly 'live' stats and one for 'yesterday'
LIVE
=
[EMAIL PROTECTED]:/home/ronan/stats# cat /etc/cron.hourly/live.sh
#!/bin/bash
# to be run every hour to give live updated stats
hour=`date +%k`
#let hour -= 1
date=`date +%d/%m/%y`
/usr/local/bin/sa-stats.pl -l /var/log/maillog -s 'today midnight' 1
/home/ronan/stats/spam_live.txt
/bin/grep % /home/ronan/stats/spam_live.txt |egrep -v :|awk '{print
$2,$3+$6,$3,$6}' /home/ronan/stats/daily_live.tmp
cat /home/ronan/stats/daily_live.tmp | head -$hour
/home/ronan/stats/daily_live.txt
cat /home/ronan/stats/gnuplot.live EOFEOF
set terminal png small color picsize 1000 200
set grid
set title Hourly Live Mail Stats (GMT)
set xtics 0,1,23
set time
set output '/var/www/htdocs/spam_live.png'
set xr [0:23]
plot \
'/home/ronan/stats/daily_live.txt' using 1:2 title 'total' with lines, \
'/home/ronan/stats/daily_live.txt' using 1:3 title 'tagged spam' with
lines, \
'/home/ronan/stats/daily_live.txt' using 1:4 title 'tagged ham' with lines
EOFEOF
gnuplot /home/ronan/stats/gnuplot.live
#rm /home/ronan/stats/spam_live.txt /home/ronan/stats/daily_live.tmp
/home/ronan/stats/daily_live.txt /home/ronan/stats/gnuplot.live
DAILY
=
[EMAIL PROTECTED]:/home/ronan/stats# cat /etc/cron.daily/sa.sh
#!/bin/bash
# to be run after 12 at night so that the day -1 is correct
suff=`date +%m_%Y`
day=`date +%e`
let day -= 1
/usr/local/bin/sa-stats.pl -l /var/log/maillog.1 -s 'yesterday midnight'
1 /home/ronan/stats/spam${suff}_${day}.txt
/bin/grep % /home/ronan/stats/spam${suff}_${day}.txt|/bin/egrep -v :
|awk '{print $2,$3+$6,$3,$6}' /home/ronan/stats/daily${suff}_${day}.txt
cat /home/ronan/stats/gnuplot.${suff}_${day} EOFEOF
set terminal png small color picsize 1000 200
set time
set grid
set xtics 0,1,23
set title Spam vs Ham for ${day}_${suff}
set output '/var/www/htdocs/spam${suff}_${day}.png'
set xr [0:23]
plot \
'/home/ronan/stats/daily${suff}_${day}.txt' using 1:2 title 'Total
Messages' with lines, \
'/home/ronan/stats/daily${suff}_${day}.txt' using 1:3 title 'tagged
spam' with lines, \
'/home/ronan/stats/daily${suff}_${day}.txt' using 1:4 title 'tagged ham'
with lines
EOFEOF
gnuplot /home/ronan/stats/gnuplot.${suff}_${day}
cat /var/www/htdocs/index.html HTMLEOF
HTMLBODYtabletrtd
img src=spam_live.png alt=live spam stats
/td/trtrtd
img src=spam${suff}_${day}.png alt=yesterdays spam stats
/td/tr/table/BODY/HTML
HTMLEOF
HAM=`/bin/grep -i total ham
/home/ronan/stats/spam${suff}_${day}.txt|awk '{print $5}'`
SPAM=`/bin/grep -i total spam
/home/ronan/stats/spam${suff}_${day}.txt|awk '{print $5}'`
cat /home/ronan/stats/weekly.totals STATS
${suff}_${day},$HAM,$SPAM
STATS
#rm -f /home/ronan/stats/spam${suff}_${day}.txt
/home/ronan/stats/daily${suff}_${day}.txt
/home/ronan/stats/gnuplot.${suff}_${day}
HTH
Ronan
-Mike
--
Regards
Ronan McGlue
Info. Services
QUB
Re: Sa stats using rrdtool?
Ronan,
Do you have a sample of what they look like, the graphs?
on 6/13/05 8:01 AM, Ronan McGlue at [EMAIL PROTECTED] wrote:
MIKE YRABEDRA wrote:
on 6/13/05 6:07 AM, Bart Verwilst at [EMAIL PROTECTED] wrote:
Hi
Try MailGraph :) That's what I'm using for my servers..
Google for mailgraph, first hit :)
See ya
Looks good, but I think I passed it over because I am not using postfix. I
am using Communigate Pro.
However, my spamd writes to it's own log so maybe it will still work.
Only one way to find out ;-)
you could also try gnu plot... i was also looking for a 'drop in'
graphing program and found GNUplot was exactly what i wanted...
i use sa-stats.pl to read the log file then simply grep on the day
pipe to a file and plot on the basis of that. v simple, clean and pretty :)
ill show u the script if u want.. its only 10 or so lines long :)
easy
Ronan
-Original Message-
From: MIKE YRABEDRA [mailto:[EMAIL PROTECTED]
Sent: Monday, June 13, 2005 12:04 PM
To: users@spamassassin.apache.org
Subject: Sa stats using rrdtool?
Hello,
I have googled far and wide and kind not find an answer.
Does anyone know of a solution that will process a spamd log and then
output
the stats using rrdtool?
There are tons of things using mrtg, but even by the developers opinion,
mrtg is dead, rrd will take it's place.
++
Mike Yrabedra (President) :-)
323 Inc.
Our Sites:
MacDock.com
MacAgent.com
++
W: http://www.323inc.com/
P: 770.382.1195
F: 734.448.5164
E: [EMAIL PROTECTED]
I: ichatmacdock
++
Whatever you do, work at it with all your heart,
as working for the Lord, not for men.
~Colossians 3:23 {{{
++
Scanned by the MPP v2.1, http://www.messagepartners.com
