Postfix Logs parser to MySQL
Get nice postfix logs in MySQL database realtime.
MainView (View) - today's mail logs that contains: Postfix Queue ID, Date, Time, Email From, Email To, Size, Status, Comment
smtp_logs (Table) - archived mail logs.
NoQueue (View) - today's error logs: Date, Time, Email From, Email To, Error Message.
noqueue_logs (Table) - archived error logs.
Before using this script:
- use rsyslogd
- configure postfix log to MySQL database (usually, SystemEvents table)
- import base.sql to MySQL
- import view.sql to MySQL
- edit parser.php mysql connect username and password
./run-parser.sh should be run by cron daily.