Syslog (syslog-ng.conf) example

Addons for Cacti and discussion about those addons

Moderators: Moderators, Developers

Post Reply
Author
Message
itkroplis
Posts: 17
Joined: Sun Jun 04, 2017 6:25 am

Syslog (syslog-ng.conf) example

#1 Post by itkroplis » Sun Jun 04, 2017 6:49 am

Hi!

After CACTI update from 0.8x to 1.1.7 version (Debian8+MySql 5.5.54), Not work syslog-ng rightly, Not show syslog message in webpage, but show Syslog Message Filter [ Start: '2017-06-02 05:39' to End: '2017-06-04 05:39', Unprocessed Messages: 3
After test syslog sending (udp:514)

My syslog-ng.conf :
@version: 3.1
#Bare minimum syslog-ng configuration

options { long_hostnames(off); flush_lines(0); use_dns(no); use_fqdn(no);
owner("root"); group("adm"); perm(0640); stats_freq(0);
bad_hostname("^gconfd$");
};

# we are using udp, and this is a collector for net traffic only
#
source s_all {
udp();
# internal();
# unix-stream("/dev/log");
# file("/proc/kmsg" log_prefix("kernel: "));
};

destination d_mysql {
sql(type(mysql)
host("localhost") username("root") password("password")
database("syslog")
table("syslog_incoming")
columns("facility", "priority", "date", "time", "host", "message")
values("$FACILITY", "$PRIORITY", "$YEAR-$MONTH-$DAY", "$HOUR:$MIN:$SEC", "$HOST_FROM", "$MSG")
indexes("facility", "priority", "date", "time", "host", "msg"));
};

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


Maybe for problem resolved need changes in syslog-ng.conf ?
Please show my, full working syslog-ng.conf for cacti 1.1.7+ Mysql

XforceTR69
Posts: 4
Joined: Fri Jun 02, 2017 4:15 pm

Re: Syslog (syslog-ng.conf) example

#2 Post by XforceTR69 » Sun Jun 04, 2017 2:34 pm

try this

destination d_mysql {
sql(type(mysql)
host("localhost") username("root") password("password")
database("cactidb") table("syslog_incoming")
columns("facility_id", "priority_id", "program", "date", "time", "host", "message")
values("$FACILITY_NUM","$LEVEL_NUM","$PROGRAM","$YEAR-$MONTH-$DAY","$HOUR:$MIN:$SEC","$HOST","MSGONLY"));
};

if it doesnt work with your syslog db create a cactidb database like in the example

itkroplis
Posts: 17
Joined: Sun Jun 04, 2017 6:25 am

Re: Syslog (syslog-ng.conf) example

#3 Post by itkroplis » Tue Jun 06, 2017 7:45 am

No, not work :(
I reinstall syslog plugin, and recreate syslog DB + import tables from syslog.sql

How to work syslog chain.
syslog-ng listen UDP:514, if recives syslog message, It send their to MySQL db syslog table ''syslog_incomming"

Whats happens next? Whats processing next? syslog plugins .PHP files or DB?

Post Reply