Here are a couple of benefits for throwing the logs into a database.
1) You can be dumb and create killer reports using Crystal Reports. (IE your
BOSS who dont know anything about qmail or unix)
2) If you have more then one server then you have a central repository for
all your logs.
Sean
----- Original Message -----
From: Bill Carlson <[EMAIL PROTECTED]>
To: Clemens Hermann <[EMAIL PROTECTED]>
Cc: qmail mailinglist <[EMAIL PROTECTED]>
Sent: Wednesday, September 06, 2000 9:28 AM
Subject: Re: log database
> On Wed, 6 Sep 2000, Clemens Hermann wrote:
>
> > Hi
> >
> > now I have been running qmail fore a while. The logs keep on growing,
> > the mail-traffic increases. It now becomes necessary to evaluate the
> > logs to know who produced how much traffic. There will be some thousand
> > pop users and so I guess it might be a really good idea to put all the
> > logs in a database and query the database for needed information.
> > So I would be glad if someone could give me a hint on how to solve the
> > following two problems:
> > 1. How can I get the qmail logs into a database? Is there a wesite
> > onthis issue? I really would like to use MySQL.
> > 2. How do I generate a log analysis from the database (all the tools use
> > textfiles). Any tool evaluationg the logs might be o.k.
> >
> > It would be great if anyone could give me a hint, website, etc.
> >
> > thanks a lot in advance
>
> 1. What purpose is there in having the logs in a MySQL database?
> Aside from that, one could write a perl script to do just that.
>
> 2. You seek qmailanalog, which can be found at
> http://cr.yp.to/qmailanalog.html, as well as qlogtools, at
> http://em.ca/~bruceg/qlogtools/.
>
> Check http://www.qmail.org/ and do a find for 'log' or 'statistic', that
> might turn up more than my cursory look.
>
> Later,
>
> Bill Carlson
> ------------
> Systems Programmer [EMAIL PROTECTED] | Opinions are mine,
> Virtual Hospital http://www.vh.org/ | not my employer's.
> University of Iowa Hospitals and Clinics |
