Your message dated Sun, 19 Jun 2005 11:17:19 -0400
with message-id <[EMAIL PROTECTED]>
and subject line Bug#312507: fixed in ulogd 1.23-2
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 8 Jun 2005 13:40:56 +0000
>From [EMAIL PROTECTED] Wed Jun 08 06:40:56 2005
Return-path: <[EMAIL PROTECTED]>
Received: from 216-229-91-229-empty.fidnet.com (mail.icequake.net)
[216.229.91.229]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1Dg0ng-0002hC-00; Wed, 08 Jun 2005 06:40:56 -0700
Received: from iqrouter (iqrouter.icequake.net [216.229.91.225])
by mail.icequake.net (Postfix) with ESMTP id 7E30327B04;
Wed, 8 Jun 2005 08:40:54 -0500 (CDT)
Received: from sysop by iqrouter with local (Exim 3.36 #1 (Debian))
id 1Dg0n6-0001rD-00; Wed, 08 Jun 2005 08:40:20 -0500
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Philip Thiem <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: ulogd-sqlite3: Data "Corruption" and Mismatched fields.
X-Mailer: reportbug 2.63
Date: Wed, 08 Jun 2005 08:40:19 -0500
Message-Id: <[EMAIL PROTECTED]>
Sender: System Operator <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Package: ulogd-sqlite3
Version: 1.23-1
Severity: important
Tags: patch
After I installed that package I noticed that my queries within
the sqlite3 shell wasn't return the correct information.
For example
SELECT raw_mac, oob_prefix FROM ulog
Yeilds
NULL | 00:c0:f0:3b:a4:45:00:09:7b:8e:ec:70:08:00
While I was testing I also had the syslogemu plugin running
to verify the information in the db. Aside from obvious
issues with sqlite3 dumping unsigned ints as signed ints,
I had also found that if I did this.
SELECT sport, dport
and got the following on the screen
30 | 100
that the following might be in the syslog like file
SPT=57886 DPT=100
To be honest, I'm recompiled from the unstable
source package on sarge. However, the problems turned out
to be source code level programming bugs. I've include
a patch
---------------------------------------------------------------
--- ulogd_SQLITE3.orig.c 2005-06-07 17:46:06.000000000 -0500
+++ ulogd_SQLITE3.c 2005-06-07 17:50:48.000000000 -0500
@@ -34,6 +34,7 @@
#include <ulogd/conffile.h>
#include <sqlite3.h>
+#define DEBUG_SQLITE3
#ifdef DEBUG_SQLITE3
#define DEBUGP(x, args...) fprintf(stderr, x, ## args)
#else
@@ -96,7 +97,7 @@
struct in_addr addr;
#endif
- col_counter = 0;
+ col_counter = 1;
for (f = fields; f; f = f->next) {
res = keyh_getres(f->id);
@@ -128,7 +129,7 @@
sqlite3_bind_int(p_stmt,col_counter,res->value.ui8);
break;
case ULOGD_RET_UINT16:
-
sqlite3_bind_int(p_stmt,col_counter,res->value.ui8);
+
sqlite3_bind_int(p_stmt,col_counter,res->value.ui16);
break;
case ULOGD_RET_IPADDR:
#ifdef IP_AS_STRING
-- System Information:
Debian Release: testing/unstable
Architecture: i386 (i586)
Kernel: Linux 2.4.24-pt2
Locale: LANG=C, LC_CTYPE=C
Versions of packages ulogd-sqlite3 depends on:
ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an
ii libsqlite3-0 3.2.1-1 SQLite 3 shared library
ii ulogd 1.23-1 The Netfilter Userspace Logging Da
-- no debconf information
---------------------------------------
Received: (at 312507-close) by bugs.debian.org; 19 Jun 2005 15:21:37 +0000
>From [EMAIL PROTECTED] Sun Jun 19 08:21:37 2005
Return-path: <[EMAIL PROTECTED]>
Received: from newraff.debian.org [208.185.25.31] (mail)
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1Dk1c9-0006wM-00; Sun, 19 Jun 2005 08:21:37 -0700
Received: from katie by newraff.debian.org with local (Exim 3.35 1 (Debian))
id 1Dk1Xz-0001Bk-00; Sun, 19 Jun 2005 11:17:19 -0400
From: Achilleas Kotsis <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
X-Katie: $Revision: 1.56 $
Subject: Bug#312507: fixed in ulogd 1.23-2
Message-Id: <[EMAIL PROTECTED]>
Sender: Archive Administrator <[EMAIL PROTECTED]>
Date: Sun, 19 Jun 2005 11:17:19 -0400
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
X-CrossAssassin-Score: 3
Source: ulogd
Source-Version: 1.23-2
We believe that the bug you reported is fixed in the latest version of
ulogd, which is due to be installed in the Debian FTP archive:
ulogd-mysql_1.23-2_i386.deb
to pool/main/u/ulogd/ulogd-mysql_1.23-2_i386.deb
ulogd-pcap_1.23-2_i386.deb
to pool/main/u/ulogd/ulogd-pcap_1.23-2_i386.deb
ulogd-pgsql_1.23-2_i386.deb
to pool/main/u/ulogd/ulogd-pgsql_1.23-2_i386.deb
ulogd-sqlite3_1.23-2_i386.deb
to pool/main/u/ulogd/ulogd-sqlite3_1.23-2_i386.deb
ulogd_1.23-2.diff.gz
to pool/main/u/ulogd/ulogd_1.23-2.diff.gz
ulogd_1.23-2.dsc
to pool/main/u/ulogd/ulogd_1.23-2.dsc
ulogd_1.23-2_i386.deb
to pool/main/u/ulogd/ulogd_1.23-2_i386.deb
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Achilleas Kotsis <[EMAIL PROTECTED]> (supplier of updated ulogd package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Fri, 10 Jun 2005 05:11:35 +0300
Source: ulogd
Binary: ulogd-pgsql ulogd-mysql ulogd ulogd-sqlite3 ulogd-pcap
Architecture: source i386
Version: 1.23-2
Distribution: unstable
Urgency: low
Maintainer: Achilleas Kotsis <[EMAIL PROTECTED]>
Changed-By: Achilleas Kotsis <[EMAIL PROTECTED]>
Description:
ulogd - The Netfilter Userspace Logging Daemon
ulogd-mysql - MySQL extension to ulogd
ulogd-pcap - pcap extension to ulogd
ulogd-pgsql - PostgreSQL extension to ulogd
ulogd-sqlite3 - SQLite 3 extension to ulogd
Closes: 254511 309221 312507
Changes:
ulogd (1.23-2) unstable; urgency=low
.
* debian/include/netfilter_ipv4/ipt_ULOG.h:
New version taken from kernel 2.6.8, two new #defines.
* debian/patches/pgsql_table.patch:
Fixed bug in documentation: example pgsql.table defaults to wrong type
for ip address fields (Closes: #254511).
* debian/po/fr.po:
French debconf templates translation, posted by Jean-Luc Coulon
(Closes: #309221).
* debian/control:
Build-Depends: Added: libpq-dev Removed: postgresql-dev
* debian/patches/ulogd_SQLITE3_c.patch:
Fixed off-by-one error in table columns, wrong size for u16 integers.
(Thanks to Philip Thiem for the patch)
Fixed handling of NULL fields.
(Closes: #312507)
* debian/rules:
Removed call to dh_installlogratote for CDBS does it now correctly.
* debian/patches/configure.patch, debian/patches/configure.in.patch:
Patched configure to use pg_config to find postgres lib and include paths.
Package now builds OK with postgresql-8.0.
Files:
7d5f32d7ca60a1ca7253c2c768c7b0e2 699 net optional ulogd_1.23-2.dsc
4fd391024c30de47fb1028da8d08e536 37117 net optional ulogd_1.23-2.diff.gz
2277ebb534719ec0c0a5f6e03e0113a3 98854 net optional ulogd_1.23-2_i386.deb
28c22af16aee67ae8f14bcabea05473d 14870 net optional ulogd-mysql_1.23-2_i386.deb
f87cb5a4ba61332ba32ea758963c5643 15484 net optional ulogd-pgsql_1.23-2_i386.deb
868d0e08376cb0c2387e6044ca597827 13172 net optional ulogd-pcap_1.23-2_i386.deb
61f7ebbe3df2dd21326ac915d2cee065 14536 net optional
ulogd-sqlite3_1.23-2_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
iD8DBQFCtYiLIU9oQVFfm3QRAlgzAJ4z14Kb9N7Ytb8KrYnIJ0QbbLvPLgCghxl6
dIgsTu9HD+IuO+Nb66Aj3C0=
=XF7D
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
