GeoIP aware SMTP service – 3

Building Central Hub

Component list:
Postfix (build from rpm source);
QMail (mini version);
MySQL for SASL authentication;
PAM_MySQL PAM module support mysql password db;
GeoIP database;
GeoIP perl module;
perl scripting;

Build Postfix

Postfix 2.6 support tcp_table, the feature I needed in this project, but it does not build into standard rpm package. So, what I need to do is download source rpm and build it. Continue reading

IP accounting using pmacct and NetFlow – 2

After successfully capture Netflow data, my boss remind me to split IN and OUT traffic data…(read previous story)

Lets find answer from official documents …read~ read~ read~

Oh…the first sample..aggregate can be multiple exists in following style. Continue reading

IP accounting using pmacct and NetFlow – 1

I have several subnet need ip accounting for billing network traffic consumption. Since we have Netflow setup in our network, it would be easy to reuse those information collected.

I’ve found pmacct (Official website: can read Netflow data and store into MySQL, Nice!!!!
Continue reading