[syslog-ng] No such DBI driver; type='pgsql'

[Balazs Scheidler]

On Mon, 2008-11-03 at 17:09 +0100, ml at bortal.de wrote:
> Hello List,
> 
> i successfully compiled version 2.9.0+20081022.  I used: 
> LDFLAGS=-L/usr/local/lib LIBS=-ldbi ./configure --enable-sql
> 
> But when i start syslog-ng i get this error:
> -------------------------------------------------------------------------
> syslog-db:~# syslog-ng -F -v -f /etc/syslog-ng.conf -e -v   
> Configuration file has no version number, assuming syslog-ng 2.1 format. 
> Please add @version: maj.min to the beginning of the file;
> WARNING: global: the default value of chain_hostnames is changing to 
> 'no' in version 3.0, please update your configuration accordingly;
> Your configuration file uses an obsoleted keyword, please update your 
> configuration; keyword='sync', change='flush_lines'
> Your configuration file uses an obsoleted keyword, please update your 
> configuration; keyword='stats', change='stats_freq'
> WARNING: input: sources do not remove new-line characters from messages 
> by default in version 3.0, please add 'no-multi-line' flag to your 
> configuration if you want to retain this functionality;
> WARNING: file source: default value of follow_freq in file sources is 
> changing in 3.0 to '1' for all files except /proc/kmsg;
> WARNING: template: the default value for template-escape is changing to 
> 'no' in version 3.0, please update your configuration file accordingly;
> syslog-ng starting up; version='2.9.0+20081022'
> Database thread started;
> No such DBI driver; type='pgsql'
> 
> 

you probably lack the PostgreSQL database driver for libdbi. Have you
installed libdbi-drivers?

libdbi-drivers.sourceforge.net

The warnings report the incompatible changes between the configuration
file format of syslog-ng 2.1->3.0

> My Syslog Config looks like this:
> ==========================
> 
> options {
>         chain_hostnames(off);
>         sync(0);
>         stats(43200);
> };
> 
> source src { unix-stream("/dev/log"); internal(); pipe("/proc/kmsg"); };
> source src_remote { tcp(ip("foo") port(514) max-connections(20)); };
> 
> destination d_sql {
> 
> #  source s_net { udp(encoding("iso-8859-1")); };
> #  source s_net { udp(flags(validate-utf8)); };
> 
>   sql(type(pgsql)
>   host("212.87.146.204") username("foo") password("bar")
>   database("syslogng")
>   table("msg_table")
>   columns("msg_rcv_time", "msg_sent_time", "hostname", "msg_facility", 
> "msg_priority", "msg_text")
>   values($R_ISODATE, $S_ISODATE, $HOST, $FACILITY, $PRIORITY, $MSG)
>   );
>   };
> 
> 
> 
> destination messages { file("/var/log/messages"); };
> 
> log {
>         source(src_remote); source(src);
>         destination(messages);
>         destination(d_sql);
> };
> 
> 
> Any Idea how to fix this?
> 
> Cheers,
> Mario
> ______________________________________________________________________________
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
> FAQ: http://www.campin.net/syslog-ng/faq.html
> 
> 
-- 
Bazsi