Am 15.03.2013 07:59, schrieb Ram: > I have a postfix server sending out mails and we are creating reports by > parsing the maillogs using a couple of perl cron scripts > (linux machine with mysql ) > > Now the requirement is of realtime reporting. > I tried using rsyslog with a mysql table. But the performance is far too > bad. Rsyslog seems to have some memory leak and it brings down the machine. > > I guess realtime logging should be a very common requirement. What is > the best way for this > > > Thanks > Ram > > > > >
real time reporting is easy done with over ssh and tail -f /var/log/mail.log without ssh you may use webmin over https, then create some unprivileged webmin user , do local login in the webmin gui, give the user enough permission to read tail -f /var/log/mail.log you may also use webmins inbuild read syslog log stuff, or write some own scripts for grep/tail etc there are some other solutions with http guis but as i dont like them after testing, but it would be nice to here some more xymon has limited stuff to read log files, but it may enough to create alarms to special events in mail log, guess nagios etc have equal you may also try some other syslog compatible servers with guis for real time search and display Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Joerg Heidrich