Syslog

[ddonohue]

Cacti Version - 0.8.6j
Plugin Architecture - 1.1
Poller Type - CMD.php
Server Info - Linux 2.6.15-1.2054_FC5smp
Web Server - Apache/2.2.2 (Fedora)
b]MySQL[/b] - 5.0.27
RRDTool - 1.2.23
SNMP - 5.4.1
Plugins

• Network Discovery (discovery - v0.7)
  FlowView (flowview - v0.3)
  Real-time statistics (zond - v0.3)
  Network Tools (tools - v0.2)
  Update Checker (update - v0.3)
  Host Info (hostinfo - v0.1)
  ReportIt (ReportIt - v0.5.1)
  Device Tracking (mactrack - v1.0)
  PHP Network Weathermap (weathermap - v0.93)
  Syslog Monitoring (syslog - v0.5.1)
  Global Plugin Settings (settings - v0.3)

I'm Running the above version of Syslog, and i'm having real problems trying to get the syslog portion of it working. Below is the sylog-ng.conf

source net {
udp( ip(0.0.0.0) port(514) ); internal();};

destination d_mysql {
pipe("/var/log/mysql.pipe"
template("INSERT INTO syslog_incoming (host, date, time, message, priority, facility) VALUES ( '$HOST', '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$MSG', '$PRIORITY', '$FACILITY' );\n") template-escape(yes)); };

log { source(net); destination(d_mysql); };


And here is the shell script that i have running to process the named pipe

#!/bin/bash

if [ ! -e /var/log/mysql.pipe ]
then
mkfifo /var/log/mysql.pipe
fi
while [ -e /var/log/mysql.pipe ]
do mysql -u sysloguser --password=PASSWORD syslog < /var/log/mysql.pipe >/dev/null
done

Now, my new pipe doesn't appear to be getting populated but i'm certainly getting syslog stuff to the machine..

13:29:55.532501 IP xxx.xxx.204.5.syslog > cacti.xxxxxxx.com.syslog: SYSLOG local7.warning, length: 140

I also have no content in syslog or syslog_incoming;

Any help would be appreciated.

[ddonohue]

I figured out what my problem was, i had forgotten to modify the iptables firewall to include a tcp and udp of 514 for the syslog stuff to function