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 |
