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?
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