Re: [jffnms-users] syslog-ng on Ubuntu

2013-06-11 Thread Craig Small
On Tue, Jun 11, 2013 at 01:39:55PM +, Ruud Hop wrote: > And voila, the messages are appearing in the database :-) > > Thanks for pointing me in the right direction, I'm still in the Linux > learning phase :-) Can you send me the relevant parts of your config direct? Remove/reset the passwords

Re: [jffnms-users] syslog-ng on Ubuntu

2013-06-11 Thread Ruud Hop
Craig, I changed the syslog-ng configuration to 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', '$MSG'); \n") template-escape(yes)); }; And s

Re: [jffnms-users] syslog-ng on Ubuntu

2013-06-11 Thread Ruud Hop
Craig Small writes: > > On Fri, Jun 07, 2013 at 07:56:13AM +, Ruud Hop wrote: > > and everything (local machine and remote machine) is logging to this file. > > Now how to get this logging into mysql? > I had another look at it. > Is the pipe file being made? you have to run mkfifo > > You