#useradd cacti
#mysql
mysql>create database cacti;
mysql>GRANT ALL ON cacti.* TO cacti@localhost IDENTIFIED BY 'cacti';
mysql>flush privileges;
mysql>exit;
#cd /var/www/html/cacti
#vi cacti.sql(第四行添加如下)
use cacti;
#yum -y install librelp librelp-devel rsyslog rsyslog-gnutls rsyslog-mysql
[iyunv@syslogd etc]# mysql -uroot -p
mysql> create database syslog;
mysql> GRANT ALL ON syslog.* TO cacti@localhost IDENTIFIED BY 'cacti';
mysql> flush privileges;
# vi /etc/rsyslog.conf
# provides UDP syslog reception
$ModLoad imudp
# start a UDP syslog server at standard port 514
$UDPServerRun 514
# Provides kernel logging support (previously done by rklogd)
$ModLoad imklog
# Provides support for local system logging (e.g. via logger command)
$ModLoad imuxsock
# provides --MARK-- message capability
$ModLoad immark
# provides UDP syslog reception
$ModLoad imudp
# provides TCP syslog reception and GSS-API (if compiled to support it)
$ModLoad imtcp
# provides mysql
$ModLoad ommysql
# Use costomer timestamp format
$template cacti_syslog,"INSERT INTO syslog_incoming(facility, priority, date, time, host, message) values (%syslogfacility%, %syslogpriority%, '%timereported:::date-mysql%', '%timereported:::date-mysql%', '%HOSTNAME%', '%msg%')", SQL
# Insert the log's text into the Syslog database by the costomer timestamp format of the cacti_syslog template
*.* :ommysql:localhost,Syslog,cacti,cacti;cacti_syslog
# chkconfig rsyslog on
# /etc/init.d//syslog restart