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
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
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