Menu

Tree [r24] /
 History

HTTPS access


File Date Author Commit
 clients 2008-09-17 heron [r23] added maillog_check_sender.sh and maillog_check...
 log2sql 2011-11-09 heron [r24] default year now "date +%Y"
 COPYING 2008-02-22 heron [r1] initial import
 README 2008-07-24 heron [r21] updated README
 TODO 2008-02-22 heron [r1] initial import

Read Me

Basically this should consist of 2 parts:
- one to parse the logfiles and stuff them into some sql server
  it is called log2sql.pl and resides in the log2sql directory
- one to provide a frontend to do common queries, e.g.
  - transfer statistics
  - transfer statistics by user groups
  - transfer statistics target/source hosts
  - check where a mail to user x actually hangs/bounced

Unfortunately the query-tool atm is your favourite SQL client.
'some sql server' spells MySQL atm.

Current requirements:
  log2sql: perl with DBI::MySQL, Date::Calc, Getopt::Std
    and obviously postfix logfiles

log2sql capabilities:
  - can read a pipe, e.g. a named pipe syslog logs into
  - syslog-ng can pipe directly into it
  - understands various postfix/smtp and postfix/smtpd loglines,
    should be all that have to do with actual mails being sent/recieved/bounced
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.