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