And to know if it's information, a warning or an error is also helpfull :-)
So the destination in syslog-ng config now looks like: destination d_jffnms { pipe ("/tmp/mysql.pipe" template("INSERT INTO syslog (date, date_logged, host, message) VALUES ('$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC', NOW\(\), '$FULLHOST', '$LEVEL: $MSGHDR$MSG');\n") template-escape(yes) ); program ("mysql -u jffnms --password=<pass> jffnms < /tmp/ mysql.pipe"); }; Now I just have to create a syslog message rule to log the messages the right way into the events table. ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users