Postfix monitoring with David Schweikert's Mailgraph?

amb_ · Joined: 06 Apr 2003 Posts: 1 Location: Canada

Hello,

David Schweikert has maintained a very handy comprehensive Postfix monitoring frontend for RRDtool called Mailgraph. It takes the form of a daemon Perl and a CGI to generate the graphs via the web. It can be found at http://people.ee.ethz.ch/~dws/software/mailgraph/.

Has anyone successfully adapted this to Cacti? I am about to attempt to do so myself but would like to avoid readapting the wheel, if at all possible.

Should no one in this community have already done the above, I will be sure to post my reworked Mailgraph in the User Contributions forum once I am through.

Many thanks to Ian Berry et al for a fantastic piece of software. Keep up the great work!

Chris Slothouber
Threshold Internet Solutions

Xanatos · Guest

I would LOVE to see this. Hell I didn't even know there was any monitoring solutions for Postfix. I moved over about 5 months ago from Qmail and LOVE IT. Definately the best MTA I've used. Have it integrated with MySQL, Courier, and SpamAssassin and it flys.

It would be nice seeing this adapted to cacti.

zachf · Guest

any luck with this yet?

would be awesome to see it working...

klavs · Joined: 01 Oct 2002 Posts: 18

I've got mailgraph running - and cacti makes graphs from the rrd's - only the numbers aren't exactly correct

- I'm working on getting the calculations that mailgraph.cgi does into cacti - but I don't know how?

How far have you gotten ? - what I need to get of calculations (CDEF's) are these:

"CDEF:rsent=sent,60,*",
"CDEF:rrecv=recv,60,*",
"CDEF:rmsent=msent,60,*",
"CDEF:rmrecv=mrecv,60,*",
they are done - now easy.

Here's the kickers I can't solve:

"CDEF:dsent=sent,UN,0,sent,IF,$step,*",
"CDEF:ssent=PREV,UN,dsent,PREV,IF,dsent,+",
"CDEF:drecv=recv,UN,0,recv,IF,$step,*",
"CDEF:srecv=PREV,UN,drecv,PREV,IF,drecv,+",

How do I get that into Cacti? any ideas?

cpdans · Joined: 28 Oct 2002 Posts: 43

Hello,

Has anyone gotten any closer to this? I too have been running mailgraph and would love to get the graphs into Cacti. Any help with this would be great.

Dan

Guest · Posted: Tue Feb 03, 2004 12:48 pm Post subject:

Any updates with this?

travisll · Joined: 08 Jul 2002 Posts: 7

I ave not been able to get all the DEFS correct yet but this is what I have so far.

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title="SA Messages" \
--base=1000 \
--height=150 \
--width=540 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="msgs/sec" \
DEF:a="/usr/local/apache/htdocs/cacti/rra/mailgraph.rrd":sent:AVERAGE \
DEF:b="/usr/local/apache/htdocs/cacti/rra/mailgraph.rrd":recv:AVERAGE \
CDEF:cdefa=a,60,* \
CDEF:cdefb=a,UN,0,a,IF,480,* \
CDEF:cdefc=PREV,UN,cdefb,PREV,IF,cdefb,+ \
CDEF:cdeff=b,60,* \
CDEF:cdefg=b,UN,0,b,IF,480,* \
CDEF:cdefh=PREV,UN,cdefg,PREV,IF,cdefg,+ \
AREA:cdefa#4123A1:"Sent" \
COMMENT:"" \
GPRINT:cdefc:MAX:" total\:%8.0lf" \
GPRINT:cdefa:AVERAGE:"average\: %.2lf msgs/min" \
GPRINT:cdefa:MAX:"max\: %.0lf msgs/min\n" \
LINE2:cdeff#009900:"Recieved" \
COMMENT:"" \
GPRINT:cdefh:MAX:"total\:%8.0lf" \
GPRINT:cdeff:AVERAGE:"average\: %.2lf msgs/min" \
GPRINT:cdeff:MAX:"max\: %.0lf msgs/min\n" \
HRULE:0#000000:"" \
COMMENT:"\s" \
COMMENT:"graph created on Tue 03 Feb 13:46:05 CST 2004 \r"

The graph is as follows. Notice the nax: msgs/min are goofed up. That is all I lack for the first graph.

dgman · Joined: 12 Nov 2003 Posts: 16

i got some templates from the master. feel free to email/pm me for it.

or aim tchmnkyz

--jeremy

maenu · Posted: Thu Apr 01, 2004 7:13 am Post subject: postfix-stuff

Hi there

is anyone having templates for postfix?

it would be very nice, if someone would post them..

thanx

mänu

Speedster · Joined: 11 Feb 2004 Posts: 27 Location: Perth, Australia

I modified the perl script for mailgraph to output the values to text files rather than create an RRD, then extended the net-snmp agent to include those files. Then I just pull the values with an snmp query and let cacti create it's own RRD files.

snmpd.conf:

..::BFS::.. · Posted: Fri Apr 02, 2004 4:02 am Post subject:

Is it possible to use this for Win32 environments to? So to port it to Exchange or Mdeamon?

maenu · Posted: Fri Apr 02, 2004 7:07 am Post subject:

veeery cool!!

thank you very much..

in addition, you have to add the following perl-moduls to run the script:
Time::HiRes (needed by Time::Local)
Time::Local
File::Tail
Getopt::Long

@Speedster:
Thanx for posting the script!!
it would be very nice, if you'd export the data-template and graph-template..

@BFS
this script is almost useless for mdaemon and exchange.
it parses the specific logfile of Postfix..
other MTA's like exchange have diffrent logfile-formats.

Exchange isn't a big problem.. (I hope so.. ) because there's a Performance MIB for the windows-integrated SNMP-Service.

I plan to realize the exchange-solution, in the next few weeks.
I'll post it here..

regards,
Mänu

..::BFS::.. · Posted: Fri Apr 02, 2004 8:43 am Post subject:

Enforcer · Joined: 08 Apr 2004 Posts: 10

Hi,

i saw what you did here. I liked it a lot but well i also had to create all the templates.
All that clicking and adjustment took me some time so i decided to make it public.

So here we go. That templates are working if you have the exec stuff in the snmpd at the top or the postfix stats entry’s are the only one.

Thx for that idea and script.

Speedster · Joined: 11 Feb 2004 Posts: 27 Location: Perth, Australia

Nice work enforcer

Sorry for not getting around to posting my templates! The data templates were just straight "Get SNMP Query" data sources (one for each type of data) so I'm not sure they could have helped anyone. It was one of the first things I did in Cacti and because the OID is different on each server I couldn't template it!