Hello! There is some misbehaviour of ULOGD2. I managed to log connection data to the DB - but while it's logging something - at the same time I see this output in the ulogd.log - Looks abnormal. The following I use to get logging. RANGE="--nflog-range 100" THRESHOLD="--nflog-threshold 10" iptables -F INPUT iptables -F OUTPUT iptables -A INPUT -j NFLOG -s 82.198.21.17/32 --nflog-group 0 --nflog-prefix ANTON_IN $RANGE $THRESHOLD iptables -A OUTPUT -j NFLOG -d 82.198.21.17/32 --nflog-group 0 --nflog-prefix ANTON_OUT $RANGE $THRESHOLD Database is PGSQL 8.3 Kernel 2.6.24.4 with NFLOG NFLOG libraries are the latest from the netfilter.org ULOGD - Latest SVN (7450) Iptables 1.4.0 Please let me know if you need any additional info. 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. ) Fri Apr 11 16:00:12 2008 <7> ../../util/db.c:185 no connection to database, attempting to reconnect after 2 seconds Fri Apr 11 16:00:12 2008 <5> ulogd.c:488 error during propagate_results Fri Apr 11 16:00:14 2008 <1> ulogd_output_PGSQL.c:99 SELECT nspname FROM pg_namespace n WHERE n.nspname='public' Fri Apr 11 16:00:14 2008 <1> ulogd_output_PGSQL.c:109 using schema public Fri Apr 11 16:00:14 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. ) 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 )" PL/pgSQL function "insert_packet_full" line 10 at PERFORM ) Fri Apr 11 16:00:17 2008 <7> ../../util/db.c:185 no connection to database, attempting to reconnect after 2 seconds Fri Apr 11 16:00:17 2008 <5> ulogd.c:488 error during propagate_results -- 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
