postfixsqlstats Code
Status: Alpha
Brought to you by:
heron
| 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 |
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