Hvordan få PIX logg inn i PostgreSQL?

[Gauda]

Hei,

 

Skal lage en Postgres-database som skal importere PIX logger (f.eks en gang om dagen), og sortere disse - for senere å kunne hente ut disse igjen i et javagrensesnitt (klientprogram).

 

Noen som sitter på idèer om hvordan dette kan gjøres?

 

PIXloggoutput ser sånn ut;

 

[root@snortids 30]# cat pixlog-2005-03-30.log |more
2005-03-30 00:00:31 192.168.1.105 %PIX-6-302015: Built outbound UDP connection 4
906729 for outside:212.20.204.5/53 (212.20.204.5/53) to inside:192.168.1.111/165
96 (212.20.204.111/16596)
2005-03-30 00:00:31 192.168.1.105 %PIX-6-302016: Teardown UDP connection 4906729
for outside:212.20.204.5/53 to inside:192.168.1.111/39622 duration 0:00:01 byte
s 181
2005-03-30 00:01:33 192.168.1.105 %PIX-6-302013: Built inbound TCP connection 49
06730 for outside:211.112.229.99/264 (211.112.229.99/264) to inside:192.168.1.10
8/22 (212.20.204.108/22)
2005-03-30 00:01:33 192.168.1.105 %PIX-6-302014: Teardown TCP connection 4906730
for outside:211.112.229.99/264 to inside:192.168.1.108/22 duration 0:00:00 byte
s 0 TCP Reset-I
2005-03-30 00:01:33 192.168.1.105 %PIX-6-302015: Built outbound UDP connection 4
906731 for outside:212.20.204.5/53 (212.20.204.5/53) to inside:192.168.1.111/566
15 (212.20.204.111/56615)
2005-03-30 00:01:33 192.168.1.105 %PIX-6-302013: Built inbound TCP connection 49
06732 for outside:211.112.229.99/264 (211.112.229.99/264) to inside:192.168.1.10
9/22 (212.20.204.109/22)
2005-03-30 00:01:33 192.168.1.105 %PIX-6-302016: Teardown UDP connection 4906731
for outside:212.20.204.5/53 to inside:192.168.1.111/39622 duration 0:00:01 byte
s 181

 

Jeg setter pris på all feedback!

 

 

- Gauda