Bug#582948: syslog-ng: dbi sql driver does not work
Jens Meißner
Version: 3.1.1-1
Severity: normal
-- System Information:
Debian Release: 5.0.4
APT prefers stable
APT policy: (500, 'stable')
Architecture: i386 (i686)
Kernel: Linux 2.6.18-6-xen-686 (SMP w/1 CPU core)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages syslog-ng depends on:
ii libc6 2.7-18lenny2 GNU C Library: Shared libraries
ii libdbi0 0.8.2-3 Database Independent Abstraction L
ii libevtlog0 0.2.8~1-2 Syslog event logger library
ii libglib2.0-0 2.16.6-3 The GLib library of C routines
ii libpcre3 7.6-2.1 Perl 5 Compatible Regular Expressi
ii lsb-base 3.2-20 Linux Standard Base 3.2 init scrip
Versions of packages syslog-ng recommends:
ii logrotate 3.7.1-5 Log rotation utility
syslog-ng suggests no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Jens Meißner
schrieb ow...@bugs.debian.org (Debian Bug Tracking System):
The bug description is lost, sorry.
Since version 3 the sql destination are included in the open source
edition of syslog-ng.
If I using the configuration directive
destination d_mysql { sql(type(pgsql) host("localhost")
username("syslog") password("secret") database("syslog")
table("messages_${HOST}_${R_YEAR}${R_MONTH}${R_DAY}") columns("datetime
varchar(16)", "host varchar(32)", "program varchar(20)", "pid
varchar(8)", "message varchar(200)") values("$R_DATE", "$HOST",
"$PROGRAM", "$PID", "$MSGONLY") indexes("datetime", "host", "program",
"pid", "message") ); };
no message are written in the database and error message
May 24 19:46:32 technik syslog-ng[3367]: No such DBI driver;
type='mysql'
respectively
May 24 19:47:16 technik syslog-ng[3508]: No such DBI driver;
type='pgsql'
for postgres are written in the logfile /var/log/syslog.
Laszlo Boszormenyi
On Mon, 2010-05-24 at 21:49 +0200, Jens Meißner wrote:
> The bug description is lost, sorry.
Noticed. Now it's more descriptive.
> Since version 3 the sql destination are included in the open source
> edition of syslog-ng.
[...]
> no message are written in the database and error message
>
> May 24 19:46:32 technik syslog-ng[3367]: No such DBI driver;
> type='mysql'
>
> respectively
>
> May 24 19:47:16 technik syslog-ng[3508]: No such DBI driver;
> type='pgsql'
Do you have the DBI drivers installed?
You need libdbd-mysql and libdbd-pgsql packages for MySQL and PostgreSQL
support respectively.
Regards,
Laszlo/GCS
Laszlo Boszormenyi
thanks
Hi Jens,
On Mon, 2010-05-24 at 21:02 +0200, Jens Meißner wrote:
> Package: syslog-ng
> Version: 3.1.1-1
> Severity: normal
[...]
> -- System Information:
> Debian Release: 5.0.4
> APT prefers stable
> APT policy: (500, 'stable')
> Architecture: i386 (i686)
Where did you get the package for Lenny/stable? I don't see any
official backported package of syslog-ng.
Can you try testing/unstable instead?
Regards,
Laszlo/GCS
Jens Meißner
schrieb Laszlo Boszormenyi <g...@debian.hu>:
> Hi Jens,
>
> On Mon, 2010-05-24 at 21:49 +0200, Jens Meißner wrote:
>> The bug description is lost, sorry.
> Noticed. Now it's more descriptive.
>
>> Since version 3 the sql destination are included in the open source
>> edition of syslog-ng.
>[...]
>> no message are written in the database and error message
>>
>> May 24 19:46:32 technik syslog-ng[3367]: No such DBI driver;
>> type='mysql'
>>
>> respectively
>>
>> May 24 19:47:16 technik syslog-ng[3508]: No such DBI driver;
>> type='pgsql'
> Do you have the DBI drivers installed?
> You need libdbd-mysql and libdbd-pgsql packages for MySQL and
> PostgreSQL support respectively.
OK, the installation of libdbd-mysl and libdbd-pgsql solves the
problem.
I think, syslog-ng_3 should suggest the libdbd-* packages.
Regards,
Jens