Re: ulogd postgreSQL module problem

[Chris Bannister <mockingbird@earthlight.co.nz>]

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 logfile i get:
> 
> Thu Jun 14 00:59:15 2007 <7> ulogd_PGSQL.c:216 sql error during insert:
> ERROR:  syntax error at or near ")"
> LINE 1: insert into public.ulog ) values )
> 
> and in postgreSQL log i get:
> 
> 2007-06-14 00:59:15 CEST ERROR:  syntax error at or near ")" at character 25
> 
> 
> postgreSQL configuration in ulogd config file is correct infact i can 
> log in using the same username and password.
> ulogd-pgsql packet is installed.
> Any hints?

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?

-- 
Chris.
======