Hi sean,
> 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)
this is one of the reasons. I want to be able to query the database and
generate HTML-Reports. I tend to use PHP4 because it seems to be
relatively easy to generate such reports this way for someone who is not
very experienced with databases
> 2) If you have more then one server then you have a central repository for
> all your logs.
I only have one server but my log directory keeps on growing and for
this reason I want to get all logs into a database. Now I have the
problem that I have to set up 5000 Mail accounts and it is absolutely
necessary to get monthly traffic reports. Furtermore it might come up
that the customers want to know more about the accounts and I suppose it
might finally be easier to geth this information in an HTML document
from a database than from very large text log-files.
anyway, I still would appreciate it to get a hint how to get the job
done. The problem is not to analyze the logs but to get them into a
database. The tools mentioned (e.g. qmail analog) work with textfiles
but when I have set up the database I can generate my own queries and do
not necessarily need the tool, right?
Ho should this be done best?
No Text logs, only the database?
The text-logs get written into the database every few hours?
When should I get rid of old logs?
Thanks for any hint.
Clemens
> 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 |
