> From: skib...@wrladv.com > > On Friday 10 July 2009 09:24:33 am you wrote: >> Hello Sean, >> thanks for your answer. I already know about mailgraph. I read about cacti >> templates based on mailgraph scripts too, but all tools i heard about are >> monitoring "just" overall statistics. >> >> If there is no script for this purpose yet, my idea is to run rsyslog on >> the same server, filter exact syslog messages from postfix/amavis and via >> custom rsyslog template i could save the necessary data into database. From >> database i could regulary count database records for each of >> sent/received/bounced/... and save informations into rrd - i could use rrd >> in cacti, but in situation i have around thousand of mail users im afraid >> of performance. >> >> Maybe simpler solution is to modify mailgraph scripts to produce rrd for >> each user, but how to present it with a thousand mail users? >> >> Maybe the best will be to save information (just count of >> sent/received/...) and via php present it in simple self-made web app (with >> some graphing library to produce time-based graphs). >> >> Anyone have better idea? >> >> Jiri >> >> On Fri, Jul 10, 2009 at 2:36 PM, Sean Kibler wrote: >>> On Friday 10 July 2009 07:15:08 am Digest of postfix-users list wrote: >>>> Date: Fri, 10 Jul 2009 12:01:51 +0200 >>>> From: =?UTF-8?B?SmnFmcOtIEhsaW5rYQ==?= >>>> Subject: Per user graph statistics >>>> >>>> - --0016e6d96751af30e4046e570fef >>>> Content-Type: text/plain; charset=ISO-8859-1 >>>> Content-Transfer-Encoding: 7bit >>>> >>>> Hi, >>>> im curious if there is a way how to present a per user statistics of >>>> incoming/outgoing e-mails in time by graph. This is the situation: >>>> postfix relay for a few domains and many users. I want to present (the >>> >>> best >>> >>>> will be via web, cacti for example...) these informations: >>>> recieved, sent, bounced, rejected, may be spam and virus (spamassassin >>> >>> and >>> >>>> clamav via amavis) too. >>>> >>>> These informations are in mail log already. For example pflogsumm >>>> gather these informations, but i want to present these informations via >>>> web, >>> >>> where >>> >>>> i can choose a exact e-mail address and ill get informations mentioned >>>> above. Of course, there should be a graph monitored data per each user >>>> in time, so that rrd will be probably used. >>>> >>>> Did someone solve this? >>>> Thanks for any help or ideas >>>> >>>> Jiri >>>> >>>> Hi, im curious if there is a way how to present a per user >>>> statistics of= incoming/outgoing e-mails in time by graph. This is the >>>> situation: post= fix relay for a few domains and many users. I want >>>> to present (the best wil= l be via web, cacti for example...) these >>>> informations:
>>>> recieved, sent, bounced, rejected, may be spam and virus (spamassassin >>> >>> and >>> >>>> = clamav via amavis) too. These informations are in mail log >>>> already. = For example pflogsumm gather these informations, but i want >>>> to present thes= e informations via web, where i can choose a exact >>>> e-mail address and ill get informations mentioned above. Of course, >>>> there >>> >>> should >>> >>>> be a graph monitor= ed data per each user in time, so that rrd will be >>>> probably used. Did someone solve this? Thanks for any help >>>> or ideas Jiri >>> Per user I am not aware of. There is however mailgraph >>> http://mailgraph.schweikert.ch/ but this may not give you exactly what >>> your >>> after. I wouldn't mind knowing if there is such a utility, however I >>> might as >>> well be interested in writing a custom statistics gathering tool. >>> -- >>> Sean Kibler >>> Network Admin/Web Programmer >>> WRL Advertising, Inc. >>> skib...@wrladv.com >>> 330.493.8866 > I think regardless of the logic of the system generating thousands of rrd > graphs is going to be a performance problem. That is assuming these statistics > are to be updated on a daily basis. Perhaps that is the reason there is no > such tool currently. Not if your machine is already specked out for this purpose and perhaps running on separate hardware. > I don't find a need for anything more than text based statistics perhaps using > some simple tools like AWK for more simple statistics or for more advanced > statistics some Perl magic. I also do not deal with thousands of mail > accounts. You obviously do not have to show reports to senior management, who demand such reports, I do :\% I've personally looked into David Schweikert's Mailgraph (http://mailgraph.schweikert.ch/) but found myself taking too long to figure out how to customize to suit my needs, my needs are where my countermeasures exist on more than one machine, where I use more than one RBL and where my AV is proprietary. Perhaps running scripts to gather the data, then piping into a spreadsheet? .vp
