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, -- 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
