🚀 go-pugleaf

Hi @all!

I have a really special problem and I hope one of you can help me very
quickly.

I have do search for or develop a tool, that can generate one report out of
different kinds of LOG-files.

hese kind of LOG-files are:
    MS Exchange SMTP-log or sendmail log
    squid log
    nacctd log
    IIS NCSA log

The tool I'm searching for has to analyse these log-files and generate one
report out of it, if possible in HTML or PDF.


A few words, why I need such a tool:

We operate here at the location a computing centre for our parent
company. At this computing centre further subsidiaries are attached.
In order to make now an exact account over the developed traffic, we
need the analysis of these different log files, because the account has to
be
for each company, arranged according to user and service (Web, email,
VPN etc..).

The different log files are in addition also still on different
servers distributed. Everyone the log file types specified above is on
another server.

The different information, which service which user used and how much
traffic it produced thereby, are also only in the different log files
to find.

My target is it now to summarize all these data either in only one
report or in a database (esp. MySQL).

Now does one of you know a tool, which can complete this work for me? Or
does one of you have an idea, how one can implement relatively simply such a
tool? Perhaps one of you wrote already a similar Tool and can help me.

Or is it possible to install one sniffing-tool on the firewall, which logs
all the information I need (user (or internal host) -> service (web, email,
vpn) -> bytes send/recieved). At the moment the nacctd is running on our
firewall to report the vpn-traffic, but it is not possible to report the
other services, because only the internal host of our squid is showing in
these log-files.

Maybe I can modify the squid to send the users host to the firewall. In the
nacctd-log the ports of the connection is logged and so I can see, what
service is used.


Please help me, it is really important. Post your answer here in the
Newsgroup or send me a mail.


Thanks for all your help.

Michael Ruck