[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

syslog-ng pipe to mysql keeps breaking..



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 gmail com
www.linuxpro.co.za
[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]