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?

Andrea


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

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.
======


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

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 to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

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 query is totally wrong to me, but i can't figure why...

Could you post the offending query? Hiding any sensitive data if
necessary.

--
Chris.
======


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

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.
as soon as i create the table structure the insert query works.
sorry, thanks for your time.

Andrea


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org