Re: ULOGD2 PostgresSql errors

[Anton <anton.vazir@gmail.com>]

Erik,

Seems it fixes ICMP inserts. Just for testing I tried MYSQL 
logging too - it works without errors in log file, and 
looks it logs more data than PGSQL. 

Regards,
Anton.

On Saturday 12 April 2008 00:33, Eric Leblond wrote:
> Hello,
>
> On Friday, 2008 April 11 at 16:05:39 +0500, Anton wrote:
> > Hello!
> >
> > ulogd.log output is below:
> >
> > Fri Apr 11 16:00:10 2008 <7> ../../util/db.c:185 no
> > connection to database, attempting to reconnect after 2
> > seconds Fri Apr 11 16:00:10 2008 <5> ulogd.c:488 error
> > during propagate_results Fri Apr 11 16:00:12 2008 <1>
> > ulogd_output_PGSQL.c:99 SELECT nspname FROM
> > pg_namespace n WHERE n.nspname='public' Fri Apr 11
> > 16:00:12 2008 <1> ulogd_output_PGSQL.c:109 using schema
> > public Fri Apr 11 16:00:12 2008 <7>
> > ulogd_output_PGSQL.c:295 execute failed (ERROR: 
> > function insert_packet_full(unknown, unknown, integer,
> > unknown, integer, unknown, unknown, integer, unknown,
> > unknown, integer, integer, integer, integer, integer,
> > integer, integer, integ er, integer, integer, integer,
> > bigint, integer, unknown, unknown, unknown, unknown,
> > unknown, unknown, unknown, unknown, unknown, unk nown,
> > unknown, unknown, unknown, unknown, unknown, unknown,
> > unknown, unknown, unknown, unknown, unknown, unknown,
> > integer) does not exist at character 8
> > HINT:  No function matches the given name and argument
> > types. You might need to add explicit type casts. )
>
> This one is already spotted, we will try to work on this
> next week.
>
> > Fri Apr 11 16:00:14 2008 <7> ../../util/db.c:185 no
> > connection to database, attempting to reconnect after 2
> > seconds Fri Apr 11 16:00:14 2008 <5> ulogd.c:488 error
> > during propagate_results Fri Apr 11 16:00:17 2008 <1>
> > ulogd_output_PGSQL.c:99 SELECT nspname FROM
> > pg_namespace n WHERE n.nspname='public' Fri Apr 11
> > 16:00:17 2008 <1> ulogd_output_PGSQL.c:109 using schema
> > public Fri Apr 11 16:00:17 2008 <7>
> > ulogd_output_PGSQL.c:295 execute failed (ERROR: 
> > smallint out of range CONTEXT:  SQL function
> > "insert_icmp" statement 1 SQL statement "SELECT 
> > INSERT_ICMP( $1 , $2 , $3 , $4 , $5 , $6 , $7 )"
>
> This one is new, could you try the attached patch ? It
> should fix this last problem.
>
> BR,