Hello, On Saturday, 2008 April 12 at 12:43:08 +0500, Anton wrote: > Erik, > > Seems it fixes ICMP inserts. Ok, fine. > Just for testing I tried MYSQL > logging too - it works without errors in log file, and > looks it logs more data than PGSQL. Yes, we're working on this issue. It seems PGSQL do not manage to find the called SQL function due to type detection problem. This cause PGSQL to loose some packets. BR, > > 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, > -- > To unsubscribe from this list: send the line "unsubscribe netfilter-devel" in > the body of a message to majordomo@xxxxxxxxxxxxxxx > More majordomo info at http://vger.kernel.org/majordomo-info.html -- Eric Leblond INL: http://www.inl.fr/ NuFW: http://www.nufw.org/
Attachment:
signature.asc
Description: Digital signature
