Re: ulogd postgreSQL module problem

2007-06-21 Thread vizze
Chris Bannister wrote: Could you post the offending query? Hiding any sensitive data if necessary. solved...i did't read man very well, the problem was that ulog table wasn't created. Error reporting is not so clear but... somewhere in the pc ulogd place a file for every db, called *.dump.

Re: ulogd postgreSQL module problem

2007-06-20 Thread Chris Bannister
On Sun, Jun 17, 2007 at 11:26:10AM +0200, vizze wrote: > Chris Bannister wrote: > > > >Yup. ulogd_PGSQL.c LINE 1: insert into public.ulog ) values ) > > > >Without seeing the line, I'm guessing it should be ") values (" > >instead of ") values )" > > > >Does this make any sense? > > > Yes, the que

Re: ulogd postgreSQL module problem

2007-06-17 Thread vizze
Chris Bannister wrote: Yup. ulogd_PGSQL.c LINE 1: insert into public.ulog ) values ) Without seeing the line, I'm guessing it should be ") values (" instead of ") values )" Does this make any sense? Yes, the query is totally wrong to me, but i can't figure why... -- To UNSUBSCRIBE, email

Re: ulogd postgreSQL module problem

2007-06-16 Thread Chris Bannister
On Sat, Jun 16, 2007 at 01:18:11PM +0200, vizze wrote: > I'm trying to configure ulogd to put iptables log into postgreSQL, but i > can't make ulogd to insert data into the database. > tail -f /var/log/ulog/syslogemu.log tell me that ulogd is receiving ip > details from iptables but in ulogd logf