search

Cacti / plugin_syslog

Syslog Plugin for Cacti
GNU General Public License v2.0
21 stars 16 forks source link

Documentation correction for rsyslogd config for version above 2.4 #216

Closed arno-st closed 5 months ago

arno-st commented 10 months ago

In the README.md the section explaining how to configure the /etc/rsyslog.d/cacti.conf

The same is indicated for rsyslog below 2.0 ` console $ModLoad imudp $UDPServerRun 514 $ModLoad ommysql

$template cacti_syslog,"INSERT INTO syslog_incoming(facility_id, priority_id, program, logtime, host, message) \ values (%syslogfacility%, %syslogpriority%, '%programname%', '%timegenerated:::date-mysql%', '%HOSTNAME%', TRIM('%msg%'))", SQL

. >localhost,my_database,my_user,my_password;cacti_syslog `

For the version 2.4 and above it should be: ` module(load="ommysql") action(type="ommysql" server="localhost" serverport="3306" db="syslogDB" uid="userID" pwd="passwdID")

$template cacti_syslog,"INSERT INTO syslog_incoming(facility_id, priority_id, program, logtime, host, message) \ values (%syslogfacility%, %syslogpriority%, '%programname%', '%timegenerated:::date-mysql%', '%HOSTNAME%', TRIM('%msg%'))", SQL `

TheWitness commented 5 months ago

This is resolved.