[syslog-ng]Ca ne marche pas

19 Oct 2002

      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); };