What is the source of the syslog messages? Are you trying to log messages though UDP or local messages? michael PGP Info: KeyID 0x5EB59708 Fingerprint 108B A1D8 76F5 08A8 501A F28C 86F4 4BC5 5EB5 9708
james.fleet@upbna.com 01/13/03 01:57PM >>> Hello,
I have been trying to create a syslog server with MySQL and with several attempts it does not work. I have attached my configs for the system which runs on Linux RH 7.3.
This is my syslog-ng.conf file :
# # Syslog-ng example configuration file showing all the existing/future # features. # # Copyright (c) 1999 Balazs Scheidler # $Id: syslog-ng.conf.demo,v 1.2 1999/11/15 12:30:41 bazsi Exp $ # # Note that some of the keywords do _nothing_, this includes: # mac, authentication, encryption, compress #
#options { sync(0); time_reopen(10); log_fifo_size(100); }; ## Log syslog-ng to mysql database ## destination d_mysql { pipe("/tmp/mysql.pipe" template ("INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ( '$HOST', '$FACILITY',
'$PRIORITY','$LEVEL','$TAG','$YEAR-$MONTH-$DAY','$HOUR:$MIN:$SEC','$PROGRAM'
,'$MSG' );\n") template-escape(yes)); }; log { source(net); destination(d_mysql);
}; #source src { # unix-stream("/dev/log"); # udp(); # tcp(ip("127.0.0.1") port(1000) mac(allow) authentication(required) encrypt(allow)); # tcp(); # sun-streams("/dev/log" door("/etc/.syslog_door")); # internal(); #}; source src { unix-dgram("/etc/log/log"); internal(); }; source net { udp(); };
#log { source(src); destination(everything); };
I also have this script running which says that /tmp/msql.pipe is my fifo directory.
But I am still not receiving logs into the database but when I switch it will log to messages.
-James Fleet -
Systems Engineer Union Planters Bank
-- Bazsi PGP info: KeyID 9AF8D0A9 Fingerprint CD27 CFB0 802C 0944 9CFD 804E C82C 8EB1 _______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng Frequently asked questions at http://www.campin.net/syslog-ng/faq.html