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

3 Nov 2008

      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'

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

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

ml＠bortal.de