Hi, i've installed the 1.5.21 version of syslog-ng with postgresql 7.2.2 But if i try to log anything nothing happened, neither in files nor in database. i've made a test with the debug (-d) option and here is the resulting log in log.log file joined to this mail. I've joined also my syslog-ng.conf Laurent Mesuré #*********************************************************************** # Fichier de configuration pour syslog-ng # Voir syslog-ng(8) et syslog-ng.conf(5) pour plus d'informations # #*********************************************************************** # Versions Date Auteur # 1.0 25/09/2002 gb@sysfive.com # 2.0 24/04/2002 ben@pleasenospam.tnsi.com # 3.0 16/10/2002 Laurent Mesure <lmesure@nerim.net> #*********************************************************************** # Versions Description # 1.0 Original # 2.0 Modifie # 3.0 Francisation et adaptation #*********************************************************************** options { sync (0); time_reopen (10); log_fifo_size (100); long_hostnames (on); use_dns (yes); use_fqdn (yes); create_dirs (yes); keep_hostname (yes); time_reap(12); gc_busy_threshold(768); }; #*********************************************************************** source s_sys { unix-stream ("/dev/log"); internal(); }; source s_udp { udp(); }; source s_tcp { tcp(); }; source s_local { internal(); }; #*********************************************************************** # destination d_files { file("/var/log/syslog-ng/$HOST/$FACILITY.$LEVEL" # template{"$ISODATE $HOST $FACILITY $PRIORITY $PROCESS $MSG\n")); # }; destination d_local { file("/var/log/syslog-ng.$MONTH"); }; destination d_msgs { file("/var/log/messages" template("$FULLDATE $HOST $FACILITY.PRIORITY $MSG\n")); }; destination d_mail { file("/var/log/maillog" template("$FULLDATE $HOST mail.$PRIORITY $MSG\n")); }; destination d_secure { file("/var/log/secure" template("$FULLDATE $HOST authpriv.$PRIORITY $MSG\n")); }; destination d_cron { file("/var/log/cron" template("$FULLDATE $HOST cron.$PRIORITY $MSG\n")); }; destination d_bootlog { file("/var/log/boot.log" template("$FULLDATE $HOST local7.$PRIORITY $MSG\n")); }; destination d_postgres { file("/mnt/disk2/spooldir/syslog2pgsql/fulllog.$YEAR.$MONTH.$DAY.$HOUR.$MIN.$SEC" template("INSERT INTO msg_table VALUES\( '$R_ISODATE', '$S_ISODATE', '$HOST', '$FACILITY', $PRIORITY', '$MSG'\)\;\n") template_escape(yes) owner(postgres)); }; #*********************************************************************** #*********************************************************************** filter f_msgs { host("syslogdb") and level(warning,err,crit,alert,emerg) and not facility(mail,authpriv,cron); }; filter f_mail { host("syslogdb") and facility(mail); }; filter f_cron { host("syslogdb") and facility(cron); }; filter f_secure { host("syslogdb") and facility(authpriv); }; filter f_bootlog { host("syslogdb") and facility(local7); }; filter f_postgres { host("syslogdb"); }; #*********************************************************************** #*********************************************************************** # log { source(s_sys); source(s_udp); destination(d_files); }; log { source(s_sys); source(s_udp); filter(f_msgs); destination(d_msgs); }; log { source(s_sys); source(s_udp); filter(f_mail); destination(d_mail); }; log { source(s_sys); source(s_udp); filter(f_secure); destination(d_secure); }; log { source(s_sys); source(s_udp); filter(f_cron); destination(d_cron); }; log { source(s_sys); source(s_udp); filter(f_bootlog); destination(d_bootlog); }; log { source(s_sys); source(s_udp); source(s_tcp); filter(f_postgres); destination(d_postgres); }; log { source(s_local); destination(d_local); };