[syslog-ng]mysql pipe not working!

TIM MOORE syslog-ng@lists.balabit.hu
Thu, 11 Mar 2004 13:33:40 -0500


I setup syslog-ng to pipe to a fifo (/tmp/mysql.pipe).  I copied and =
pasted the configs exactly as was given and no data is written to the =
pipe.  It always remains "0" in size.  I have since tried the config in =
many different ways, but still cannot get the data to pipe to the file.  =
Is there something wrong with the config?  Has anyone else run into this =
problem?  Here is a copy of my config.

 root@syslog1 ~ # cat /etc/syslog-ng/syslog-ng.conf
#
# Syslog-ng configuration for for ODJFS-NOC Syslog
#
# Copyright (c) 1999 anonymous
# Copyright (c) 1999 Balazs Scheidler
# $Id: syslog-ng.conf.sample,v 1.2 1999/11/15 12:30:41 bazsi Exp $
#
# Syslog-ng configuration file, compatible with default Debian syslogd
# installation.
#

options {
        use_fqdn(yes);
        use_dns(yes);
        keep_hostname(yes);
        long_hostnames(off);
        use_time_recvd(yes);
        sync(0);
 };
######################################
#Source Section
#source for local data
source src { unix-dgram("/etc/log/log"); internal(); };
#source src { pipe("/proc/kmsg" log_prefix("kernel: "));
#       unix-stream("/dev/log");
#       internal();
#};

#source for PIX firewalls
#source pix {
#       udp(ip("10.3.250.5") port (514));
#       udp(ip("10.x.x.x") port (514));
#       udp(ip("10.x.x.x") port (514));
#       udp(ip("10.x.x.x") port (514));
#       udp(ip("10.x.x.x") port (514));
#};

#source for network devices
source net {
        udp();
};

#####################################
#Destination Section
#Standard destination
destination std {
        file("/var/log/$HOST/$FACILITY/$DAY"
                remove_if_older(172800)
                owner(root)
                group(root)
                perm(0600)
                dir_perm(0700)
               create_dirs(yes));
};

## Log syslog-ng to mysql database
##
destination d_mysql {
pipe("/tmp/mysql.pipe"
template("INSERT INTO logs (host, facility, priority, level, tag, date,
time, program, msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', =
'$TAG',
'$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n") =
template-escape(yes));
};

#log for src
log {
        source(src);
        destination(std);
        destination(d_mysql);
};

#log for net
log {
        source(net);
        destination(std);
        destination(d_mysql);
};

########END OF FILE########
=20
Any ideas?

Tim M.
ODJFS