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.8b6a97b...@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.8b6a97b...@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
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
