Re: [vchkpw] logging into db

2007-01-27 Thread Bob Hutchinson
On Saturday 27 January 2007 16:30, Miki wrote:
 Hello,

 I want ask you if there is any method or idea how can be multilog
 output redirected to write into database, I was thinking about
 pipelining thru some script, but there are many lines different, and on
 high rate it can slow down server a lot, second is some postprocessing of
 log files and put result into db, for example some perl periodically
 scanning thru current file.
 specially for parsing simscan to have some stat in db.

 does anyone idea how to do it or know if its there such thing ?
 I was googling but cannot find working combination of words in
 question ;)

not sure if this is what you want, but you might try
http://download.midwales.net/pub/lin/various/avstats-1.0.8.tar.gz

It won't 'just work' though, first you need to get the script 
app/cron/parse_clamav.pl set up and running, it will create the tables in a 
mysql database which has already been created with the right permissions.

To run the php you need to have jpgraph installed, see
http://www.aditus.nu/jpgraph/index.php
You will also want the msttcorefonts

You will also need to create a config.php, there is an example in app/src.

Access it through the index.php in the 'html' directory, so set that up in a 
virtual host container or Apache alias or with a symlink. All the other dirs 
should be outside the Apache document root.

You can point it to more than one database on different servers.

It uses Smarty templates and css so play with them to change looks and layout.

It uses adodb to handle the queries so it *might* work with another type of 
database, I haven't tried. The cron script would have to be rewritten, 
probably in php.

The directories under app/data must have either global or webserver write 
permissions so that the Smarty engine can operate.

I don't know if it will work with php 5...


-- 
-
Bob Hutchinson
Midwales dot com
-


RE: [vchkpw] logging into db

2007-01-27 Thread shadowplay.net


take a look at splunk 
u might find it very useful



kenneth gf brown
ceo shadowplay.net