syslog-ng pipe to mysql keeps breaking..

Gregory Machin gregory.machin at gmail.com
Thu Sep 21 14:15:42 UTC 2006


Hi
Please advise on how to configure the pipe for syslog-ng to reliably pipe
data to mysl ...
Some how mine keeps breaking ... It works for awhile the stops for no reason
...
and syslog-ng stops logging to the pipe ... i  end up have to recreate the
pipe
and restart syslog-ng ...

what are the correct permitions / commands to use for fc 5 and centos 4 ?
I haven't worked with pipes before..

this the the code I used  ... to create the pipe ..

#!/bin/bash
#
# Script to create a named pipe so syslog-ng messages
# can be sent to a MySQL database

if [ -p /var/run/mysql.pipe ]; then
    /usr/bin/mysql -u syslog_ng --password=syslog_ng syslog_ng <
/var/run/mysql.pipe &
else
  mkfifo /var/run/mysql.pipe
fi


Many Thanks
-- 
Gregory Machin
gregory.machin at gmail.com
www.linuxpro.co.za
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20060921/55033f61/attachment-0001.htm>


More information about the fedora-list mailing list