First, install the PostgreSQL server and Python library:
1apt-get install psycopg2 postgresql
Set up account and database:
1su postgres
2createuser -P #Fill out properly
3createdb -T template1 glastopf
4psql -U chosenusername
The PostgreSQL database structure:
1CREATE TABLE log (
2 id bigserial PRIMARY KEY,
3 domain varchar(255) NOT NULL,
4 ip varchar(25) NOT NULL,
5 attime timestamp DEFAULT LOCALTIMESTAMP NOT NULL,
6 tzone varchar(5) NOT NULL default '+0000',
7 req varchar(255) NOT NULL,
8 ref varchar(255) NOT NULL default _,
9 via varchar(255) NOT NULL,
10 forwardedfor varchar(255) NOT NULL,
11 xforwardedfor varchar(255) NOT NULL,
12 xvia varchar(255) NOT NULL,
13 onspdusr varchar(255) NOT NULL,
14 ac varchar(255) NOT NULL default _,
15 accha varchar(255) NOT NULL default _,
16 acla varchar(255) NOT NULL default _,
17 con varchar(255) NOT NULL default _,
18 keep varchar(255) NOT NULL default _,
19 agent varchar(255) NOT NULL default _,
20 host varchar(255) NOT NULL,
21 attmnt varchar(255) NOT NULL,
22 attmail varchar(255) NOT NULL,
23 vicmnt varchar(255) NOT NULL,
24 vicmail varchar(255) NOT NULL,
25 alive smallint NOT NULL default '1',
26 mail smallint NOT NULL default '0',
27 count bigint NOT NULL default '1',
28 filename varchar(32) NOT NULL,
29 victim varchar(255) NOT NULL
30);