[syslog-ng] Re: NewBe syslog-ng and fedora core 5 64+bit

[Gregory Machin]

ok ...

I have it logging to file ... But still not to mysql ...

this is the back script 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

this is the config file ...

# syslog-ng configuration file.
#
# This should behave pretty much like the original syslog on RedHat. But
# it could be configured a lot smarter.
#
# See syslog-ng(8) and syslog-ng.conf(5) for more information.
#
# 20000925 gb at sysfive.com
#
# Updated by Frank Crawford (<Frank.Crawford at ac3.com.au>) - 10 Aug 2002
#     - for Red Hat 7.3
#    - totally do away with klogd
#    - add message "kernel:" as is done with klogd.
#
# Updated by Frank Crawford (<Frank.Crawford at ac3.com.au>) - 22 Aug 2002
#    - use the log_prefix option as per Balazs Scheidler's email
#
# Updated by Jose Pedro Oliveira (<jpo at di.uminho.pt>) - 05 Apr 2003
#    - corrected filters 'f_filter2' and 'f_filter6'
#     these filters were only allowing messages of one specific
#     priority level; they should be allowing messages from that
#     priority and upper levels.
#
# Updated by Jose Pedro Oliveira (<jpo at di.uminho.pt>) - 25 Jan 2005
#   - Don't sync the d_mail destination
#
# Updated by Jose Pedro Oliveira (<jpo at di.uminho.pt>) - 01 Feb 2005
#   - /proc/kmsg is a file not a pipe.
#     (
https://lists.balabit.hu/pipermail/syslog-ng/2005-February/006963.html)
#

options {
#    sync (0);
#    time_reopen (10);
#    log_fifo_size (1000);
#    long_hostnames (off);
#    use_dns (no);
#    use_fqdn (no);
#    create_dirs (no);
    chain_hostnames(no);
    check_hostname(yes);
    keep_hostname (yes);
};

source s_sys {
    file ("/proc/kmsg" log_prefix("kernel: "));
    unix-stream ("/dev/log");
    internal();
    # udp(ip(0.0.0.0) port(514));
};

destination d_cons { file("/dev/console"); };
destination d_mesg { file("/var/syslog-ng/messages"); };
destination d_auth { file("/var/syslog-ng/secure"); };
destination d_mail { file("/var/syslog-ng/maillog" sync(10)); };
destination d_spol { file("/var/syslog-ng/spooler"); };
destination d_boot { file("/var/syslog-ng/boot.log"); };
destination d_cron { file("/var/syslog-ng/cron"); };
destination d_mlal { usertty("*"); };
destination d_mysql { pipe("/var/run/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));
};


filter f_filter1   { facility(kern); };
filter f_filter2   { level(info..emerg) and
                     not facility(mail,authpriv,cron); };
filter f_filter3   { facility(authpriv); };
filter f_filter4   { facility(mail); };
filter f_filter5   { level(emerg); };
filter f_filter6   { facility(uucp) or
                     (facility(news) and level(crit..emerg)); };
filter f_filter7   { facility(local7); };
filter f_filter8   { facility(cron); };

log { source(s_sys); filter(f_filter1); destination(d_cons); };
log { source(s_sys); filter(f_filter2); destination(d_mesg); };
log { source(s_sys); filter(f_filter3); destination(d_auth); };
log { source(s_sys); filter(f_filter4); destination(d_mail); };
log { source(s_sys); filter(f_filter5); destination(d_mlal); };
log { source(s_sys); filter(f_filter6); destination(d_spol); };
log { source(s_sys); filter(f_filter7); destination(d_boot); };
log { source(s_sys); filter(f_filter8); destination(d_cron); };
# MySQL Database

log { source(s_sys);
    filter(f_filter1);
    filter(f_filter2);
    filter(f_filter3);
    filter(f_filter4);
    filter(f_filter5);
    filter(f_filter6);
    filter(f_filter7);
    filter(f_filter8);
      destination(d_mysql); };

Any ideas on what I have missed  ?

Many Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20060921/5e985538/attachment.htm