syslog-ng 写入数据库 数据库没有数据

litianshu

options {
long_hostnames(off);
log_msg_size(8192);
#sync(1);
log_fifo_size(20480);
time_reopen(10);
#use_dns(no);
#dns_cache(no);
#use_fqdn(no);
keep_hostname(yes);
chain_hostnames(no);
perm(0644);
stats(43200);

};

#source s_internal { internal(); };

#destination d_syslognglog { file("/var/log/syslog-ng.log"; };

#log { source(s_internal); destination(d_syslognglog); };


source s_local {

        unix-dgram("/dev/log";

        file("/proc/kmsg" log_prefix("kernel:");

};


filter f_messages { level(info..emerg); };

filter f_secure { facility(authpriv); };

filter f_mail { facility(mail); };

filter f_cron { facility(cron); };

filter f_emerg { level(emerg); };

filter f_spooler { level(crit..emerg) and facility(uucp, news); };

filter f_local7 { facility(local7); };


destination d_messages { file("/var/log/messages"; };

destination d_secure { file("/var/log/secure"; };

destination d_maillog { file("/var/log/maillog"; };

destination d_cron { file("/var/log/cron"; };

destination d_console { usertty("root"; };

destination d_spooler { file("/var/log/spooler"; };

destination d_bootlog { file("/var/log/boot.log"; };

destination d_hadoop { file("/var/log/hadoop/hadoop-hadoop-tasktracker-spock.log"); };



log { source(s_local); filter(f_emerg); destination(d_console); };

log { source(s_local); filter(f_secure); destination(d_secure); flags(final); };

log { source(s_local); filter(f_mail); destination(d_maillog); flags(final); };

log { source(s_local); filter(f_cron); destination(d_cron); flags(final); };

log { source(s_local); filter(f_spooler); destination(d_spooler); };

log { source(s_local); filter(f_local7); destination(d_bootlog); };

log { source(s_local); filter(f_messages); destination(d_messages); };


# Remote logging

source s_remote {

        tcp(ip(0.0.0.0) port(514));

        udp(ip(0.0.0.0) port(514));

};


destination r_console {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/console" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};

destination r_secure {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/secure" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};

destination r_cron {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/cron" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};

destination r_spooler {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/spooler" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};

destination r_bootlog {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/bootlog" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};

destination r_messages {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/messages" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};

destination r_hadoop {file("/var/log/syslog-ng/$YEAR$MONTH$DAY/$HOST/messages" owner("root") group("root") perm(0640) dir_perm(0750) create_dirs(yes));};



log { source(s_remote); filter(f_emerg); destination(r_console); };

log { source(s_remote); filter(f_secure); destination(r_secure); flags(final); };

log { source(s_remote); filter(f_cron); destination(r_cron); flags(final); };

log { source(s_remote); filter(f_spooler); destination(r_spooler); };

log { source(s_remote); filter(f_local7); destination(r_bootlog); };

log { source(s_remote); filter(f_messages); destination(r_messages); };


destination d_mysql {
       pipe("/var/log/mysql.pipe"
       template("INSERT INTO logs
       (host, facility, priority, level, tag, datetime, program, msg)
       VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY $HOURMINSEC','$PROGRAM', '$MSG' );\n")
template-escape(yes));
};

log {
       source(s_remote);
       destination(d_mysql);

};