[syslog-ng] No such DBI driver; type='pgsql'
ml at bortal.de
ml at bortal.de
Mon Nov 3 17:09:17 CET 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
More information about the syslog-ng
mailing list