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 <skib...@wrladv.com> 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==?= <jiri.hli...@gmail.com> > > > 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 > > > > > > - --0016e6d96751af30e4046e570fef > > > Content-Type: text/html; charset=ISO-8859-1 > > > Content-Transfer-Encoding: quoted-printable > > > > > > Hi,<br>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:<br>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:<br> > > > recieved, sent, bounced, rejected, may be spam and virus (spamassassin > > > > and > > > > > = clamav via amavis) too.<br><br>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 g= et 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.<br> <br>Did someone solve this? <br>Thanks for any help > > > or ideas<br><br>Jiri<br= > > > > > > > > > - --0016e6d96751af30e4046e570fef-- > > > > > > ------------------------------ > > > > 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.
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. -- Sean Kibler Network Admin/Web Programmer WRL Advertising, Inc. skib...@wrladv.com 330.493.8866
