#
#
#

1. Create DB User:
(mysql -u root -p)

CREATE DATABASE odin;
GRANT ALL ON odin TO odin@localhost;
FLUSH PRIVILEGES;
mysql -u odin -D odin < ./odin.sql

2. Install Perl-DBI-Interface. 
tar -xzf DBI-1.30.tar.gz
cd DBI-1.30
perl Makefile.PL
make
make install
cd ..

tar -xzf Msql-Mysql-modules-1.2219.tar.gz
cd Msql-Mysql-modules-1.2219
perl Makefile.PL
make install

3. Starting 

On the firewall issue the following command:

(echo "SENSOR_NAME"; tcpdump -i pflog0 -n -e -ttt -l) | ssh root@loghost "cat | /path/to/odin/pf2mysql.pl"

# (echo "JAIL.CRYPTOJAIL.NET"; ./tcpdump -i pflog0 -n -e -ttt -l) | ssh root@213.144.137.82 "cat | /home/ram/odin/pf2mysql.pl"
# (echo "WSCWALL"; ./tcpdump -i pflog0 -n -e -ttt -l) | ssh root@213.144.137.82 "cat | /home/ram/odin/pf2mysql.pl"