Donate Share

P3Scan

Tracker: Software Contributions

5 Another log analyzer with output to mysql - ID: 1252635
Last Update: Settings changed ( laitcg )

A log analyzer that use mysql to store info.
It use two tables, one for user activity and other for
viruses found..
All the info is read from /var/log/messages

This script es in incredible RAW and beta state, and
require the use of primary keys on both tables to avoid
duplicate entries..

You are very welcome to improve it.


Facundo Garat ( fgarat ) - 2005-08-05 14:37

5

Closed

Accepted

Nobody/Anonymous

None

None

Public


Comments ( 3 )

Date: 2009-05-28 13:25
Sender: laitcgProject Admin

Nice work!



Date: 2005-08-05 14:57
Sender: fgarat

Logged In: YES
user_id=643725

Now the web part.
Here are 4 perl script to put on your webserver with access
to the mysql database.
This scripts show last month pop3 usage with a nice graph,
for all users, and when you click on a user address it will
show this user usage with a graph too..
both graphs are generated on the fly.

All the scripts should go on the same directory.
The script you have to call from the browser is pop3stat.pl



Date: 2005-08-05 14:43
Sender: fgarat

Logged In: YES
user_id=643725

Sorry, the file tabla_p3scan.pl inside the ZIP, is a SQL
instead of a perl script.
And i forgot the p3scan_virus tables definition... (it's
comming now!!)


Attached Files ( 3 )

Filename Description Download
p3scan_analyzer.zip P3scan analyzer Download
p3scan_virus.ddl p3scan virus detect table definition. Download
webp3scanstas.zip Web part of the p3scan log analyzer Download

Changes ( 8 )

Field Old Value Date By
close_date - 2009-05-28 13:34 laitcg
data_type 1127652 2009-05-28 13:34 laitcg
status_id Open 2009-05-28 13:34 laitcg
allow_comments 1 2009-05-28 13:34 laitcg
resolution_id None 2009-05-28 13:25 laitcg
File Added 144558: webp3scanstas.zip 2005-08-05 14:57 fgarat
File Added 144554: p3scan_virus.ddl 2005-08-05 14:43 fgarat
File Added 144553: p3scan_analyzer.zip 2005-08-05 14:37 fgarat