1.4.15
Michael.Earls@chmcc.org 05/06/02 08:13AM >>> what ver of syslog-ng?
-----Original Message----- From: nelsotob@ohsu.edu Sent: Monday, May 06, 2002 11:14 AM To: <syslog-ng@lists.balabit.hu> Subject: Re: [syslog-ng]Syslog-ng and Mysql Yes that is actually what I have in my script is INSERT just a typo in the messages. Toby >>> sander@sanderscorner.com 05/04/02 04:39AM >>> (Response to message from Toby Nelson, nelsotob@ohsu.edu) Hello Toby, Should'nt it be 'template("INSERT INTO...'? Regards, Sander Saturday, May 04, 2002, 1:14:08 AM, you wrote: > Can someone help me?
I have syslog ng running perfectly getting all info from all of my hosts. I would like to take this one step farther and start adding it to a mysql data base. I have made the mysql.pipe using
> mkfifo and add the following lines to my syslog ng.conf: > destination d_mysql {
pipe("/etc/mysql.pipe" template("INSET INTO logs(host, facility, priority, level, tag, date, time, program, msg) VALUES('$HOST', '$FACILILITY', '$PRIORITY', '$LEVEL', '$TAG', > '$YEAR $MONTH $DAY', $HOUR:$MIN:$SEC', '$PROGRAM', $MSG');\n") template escape(yes));
};
_______________________________________________ syslog ng maillist syslog ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog ng _______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng