Your message dated Sat, 22 Nov 2014 18:22:40 +0000 with message-id <[email protected]> and subject line Bug#770532: Removed package(s) from unstable has caused the Debian Bug report #584299, regarding lire: Perl problems with SQLite2::{st,db} in analyzing iptables 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 this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 584299: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=584299 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: lire Version: 2:2.0.3-1.1 Severity: normal Subject: lire: Perl problems with SQLite2::{st,db} in analyzing iptables Package: lire Version: 2:2.0.3-1.1 Severity: important I've stopped receiving the iptables report with the following messages in syslog: May 30 22:47:24 argonath lire: Parsing log file using iptables DLF Converter... May 30 22:47:24 argonath lire: all all UNSET lr_log2mail info Lire::Syslog: log seems from BSD syslog daemon May 30 22:59:00 argonath lire: lr_log2mail: WARNING DBD::SQLite2::st execute failed: disk I/O error(1) at dbdimp.c line 419 at /usr/share/perl5/Lire/DlfStream.pm line 283, <$fh> line 669108. May 30 22:59:00 argonath lire: May 30 22:59:00 argonath lire: lr_log2mail: WARNING DBD::SQLite2::st execute failed: no such table: dlf_lire_import_log(1) at dbdimp.c line 412 at /usr/share/perl5/Lire/DlfStream.pm line 283, <$fh> line 669108. May 30 22:59:00 argonath lire: May 30 22:59:00 argonath lire: lr_log2mail: ERROR DBD::SQLite2::st execute failed: no such table: dlf_lire_import_log(1) at dbdimp.c line 412 at /usr/share/perl5/Lire/DlfStream.pm line 283, <$fh> line 669108. May 30 22:59:00 argonath lire: May 30 22:59:00 argonath lire: lr_log2mail: WARNING DBD::SQLite2::db commit failed: SQL logic error or missing database(1) at dbdimp.c line 180 at /usr/share/perl5/Lire/DlfStore.pm line 164 during global destruction. May 30 22:59:00 argonath lire: May 30 22:59:00 argonath lire: lr_log2mail: WARNING #011(in cleanup) DBD::SQLite2::db commit failed: SQL logic error or missing database(1) at dbdimp.c line 180 at /usr/share/perl5/Lire/DlfStore.pm line 164 during global destruction. May 30 22:59:00 argonath lire: May 30 22:59:02 argonath lire: Parsing log file using syslog DLF Converter... May 30 22:59:58 argonath lire: Extracted 86361 DLF records on 86361 lines. May 30 22:59:58 argonath lire: Encountered 0 errors and ignored 0 lines. May 30 22:59:58 argonath lire: Running analysers... May 30 22:59:58 argonath lire: Generating XML report... May 30 23:01:34 argonath lire: Formatting report as txt and emailing it to root... May 30 23:01:46 argonath postfix/pickup[29234]: 8B6A97B4B7: uid=107 from=<lire> May 30 23:01:46 argonath postfix/cleanup[29282]: 8B6A97B4B7: message-id=<20100531030146.8B6A97B4B7@argonath> May 30 23:01:46 argonath postfix/qmgr[10625]: 8B6A97B4B7: from=<[email protected]>, size=645968, nrcpt=1 (queue active) May 30 23:01:46 argonath postfix/cleanup[29282]: D4B957B4AB: message-id=<20100531030146.8B6A97B4B7@argonath> May 30 23:01:47 argonath postfix/local[29284]: 8B6A97B4B7: to=<[email protected]>, orig_to=<root>, relay=local, delay=1.2, delays=0.32/0.18/0/0.73, dsn=2.0.0, status=sent (forwarded as D4B957B4AB) May 30 23:01:47 argonath postfix/qmgr[10625]: D4B957B4AB: from=<[email protected]>, size=646098, nrcpt=1 (queue active) May 30 23:01:47 argonath postfix/qmgr[10625]: 8B6A97B4B7: removed May 30 23:01:48 argonath postfix/smtp[29285]: D4B957B4AB: to=<[email protected]>, orig_to=<root>, relay=smtp.kikisoso.org[192.168.2.7]:25, delay=1.6, delays=0.71/0.05/0.45/0.37, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 797A846500) May 30 23:01:48 argonath postfix/qmgr[10625]: D4B957B4AB: removed So, it parses and sends the (sys)log file okay but not iptables. I do receive the email for the syslog report. % cat /etc/default/lire.d/iptables.cfg # see lr_vendor_cron(1) service=iptables daemon=/sbin/iptables rotateperiod=weekly logfile=/var/log/ulog/syslogemu.log.1 filter=cat % ls -l /var/log/ulog/syslogemu.log.1 -rw-r----- 1 root adm 320192364 2010-05-30 00:26 /var/log/ulog/syslogemu.log.1 -- System Information: Debian Release: 5.0.4 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.26-2-686 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages lire depends on: ii adduser 3.110 add and remove users and groups ii debconf [debconf-2.0] 1.5.24 Debian configuration management sy ii libcurses-ui-perl 0.9605-1 curses-based OO user interface fra ii libdbd-sqlite2-perl 2:0.33-8 Perl DBI driver with a self-contai ii libintl-perl 1.16-4 Uniforum message translations syst ii libmime-perl 5.427-1 transitional dummy package ii libmime-tools-perl [libm 5.427-1 Perl5 modules for MIME-compliant m ii libtime-modules-perl 2006.0814-2 Various Perl modules for time/date ii libxml-parser-perl 2.36-1.1+b1 Perl module for parsing XML files ii perl 5.10.0-19lenny2 Larry Wall's Practical Extraction ii postfix [mail-transport- 2.5.5-1.1 High-performance mail transport ag Versions of packages lire recommends: ii libterm-readline-perl-perl 1.0302-1 Perl implementation of Readline li ii ploticus 2.40-2 script driven business graphics pa Versions of packages lire suggests: pn libspreadsheet-writeexcel-per <none> (no description available) pn lire-doc <none> (no description available) -- debconf information: * lire/use_existing_user: true * lire/purge_user_files: true * lire/use_existing_group: true -- System Information: Debian Release: 5.0.4 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.26-2-686 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages lire depends on: ii adduser 3.110 add and remove users and groups ii debconf [debconf-2.0] 1.5.24 Debian configuration management sy ii libcurses-ui-perl 0.9605-1 curses-based OO user interface fra ii libdbd-sqlite2-perl 2:0.33-8 Perl DBI driver with a self-contai ii libintl-perl 1.16-4 Uniforum message translations syst ii libmime-perl 5.427-1 transitional dummy package ii libmime-tools-perl [libm 5.427-1 Perl5 modules for MIME-compliant m ii libtime-modules-perl 2006.0814-2 Various Perl modules for time/date ii libxml-parser-perl 2.36-1.1+b1 Perl module for parsing XML files ii perl 5.10.0-19lenny2 Larry Wall's Practical Extraction ii postfix [mail-transport- 2.5.5-1.1 High-performance mail transport ag Versions of packages lire recommends: ii libterm-readline-perl-perl 1.0302-1 Perl implementation of Readline li ii ploticus 2.40-2 script driven business graphics pa Versions of packages lire suggests: pn libspreadsheet-writeexcel-per <none> (no description available) pn lire-doc <none> (no description available) -- debconf information: * lire/use_existing_user: true * lire/purge_user_files: true * lire/use_existing_group: true
--- End Message ---
--- Begin Message ---Version: 2:2.1.1-2.1+rm Dear submitter, as the package lire has just been removed from the Debian archive unstable we hereby close the associated bug reports. We are sorry that we couldn't deal with your issue properly. For details on the removal, please see https://bugs.debian.org/770532 The version of this package that was in Debian prior to this removal can still be found using http://snapshot.debian.org/. This message was generated automatically; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]. Debian distribution maintenance software pp. Scott Kitterman (the ftpmaster behind the curtain)
--- End Message ---

