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, -- Eric Leblond INL: http://www.inl.fr/ NuFW: http://www.nufw.org/
diff --git a/doc/pgsql-ulogd2.sql b/doc/pgsql-ulogd2.sql index fc4aa1b..a451b5e 100644 --- a/doc/pgsql-ulogd2.sql +++ b/doc/pgsql-ulogd2.sql @@ -112,8 +112,8 @@ CREATE TABLE icmp ( _icmp_id bigint PRIMARY KEY UNIQUE NOT NULL, icmp_type smallint default NULL, icmp_code smallint default NULL, - icmp_echoid smallint default NULL, - icmp_echoseq smallint default NULL, + icmp_echoid integer default NULL, + icmp_echoseq integer default NULL, icmp_gateway integer default NULL, icmp_fragmtu smallint default NULL ) WITH (OIDS=FALSE); @@ -122,8 +122,8 @@ CREATE TABLE icmpv6 ( _icmpv6_id bigint PRIMARY KEY UNIQUE NOT NULL, icmpv6_type smallint default NULL, icmpv6_code smallint default NULL, - icmpv6_echoid smallint default NULL, - icmpv6_echoseq smallint default NULL, + icmpv6_echoid integer default NULL, + icmpv6_echoseq integer default NULL, icmpv6_csum integer default NULL ) WITH (OIDS=FALSE); @@ -284,7 +284,7 @@ DROP TABLE IF EXISTS nufw; CREATE TABLE nufw ( _nufw_id bigint PRIMARY KEY UNIQUE NOT NULL, username varchar(30) default NULL, - user_id smallint default NULL, + user_id integer default NULL, client_os varchar(100) default NULL, client_app varchar(256) default NULL ) WITH (OIDS=FALSE);
Attachment:
signature.asc
Description: Digital signature
