Cacti的套件安裝-SYSLOG

前置作業：cacti請參考CentOS 6.2安裝Cacti
使用環境
OS：CentOS 6.3
Cacti版本0.8.8a
說明：本案例使用rsyslog作為各設備的syslog

安裝rsyslog

1、yum install -y rsyslog rsyslog-mysql

下載套件syslog及相關環境設定

1、wget http://docs.cacti.net/_media/plugin:syslog-v1.22-2.tgz

2、mv plugin:syslog-v1.22-2.tgz syslog-v1.22-2.tgz

3、tar zxvf syslog-v1.22-2.tgz

4、mv syslog /var/www/html/cacti/plugins/

創建資料庫及匯入syslog.sql

5、mysqladmin --user=root --password create syslog 

6、mysql --user=root --password syslog < /var/www/html/cacti/plugins/syslog/syslog.sql

設定使用syslog資料庫、設定帳號密碼

7、cd /var/www/html/cacti/plugins/syslog/

8、vi config.php

更改下列資料

#################################################################################

$use_cacti_db = true;

to

$use_cacti_db = false;

Then, edit lines 31 - 37 to reflect your configuration:

if (!$use_cacti_db) {

        $syslogdb_type     = 'mysql';

        $syslogdb_default  = 'syslog';

        $syslogdb_hostname = 'localhost';

        $syslogdb_username = 'cactiuser'; -----------使用者

        $syslogdb_password = 'cactiuser'; -----------使用者密碼

        $syslogdb_port     = 3306;

################################################################################# 

給予cacti使用syslog資料庫的權限

9、mysql --user=root --password mysql

mysql> GRANT ALL ON syslog.* TO cacti@localhost IDENTIFIED BY 'cactip@ssw)rd';
mysql> flush privileges;
mysql> exit

10、修改rsyslog是其可接收設備資料

以下為官方說明檔

#################################################################################

Red Hat: Edit '/etc/rsyslog.conf' and add the following lines to the top:

$ModLoad ommysql
$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
*.*             >{mysql_server},{db_name},{db_users},{db_pass};cacti_syslog
Ensure you replace
{mysql_server},etc with your settings, for example: 



$ModLoad ommysql
$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
*.*            
>localhost,syslog,cactiuser,cactiuser;cacti_syslog

拿掉註解： 

# Provides UDP syslog reception

$ModLoad imudp.so

$UDPServerRun 514

 #################################################################################

11、更改權限

chown -R apache:apache /var/www/html/cacti/plugins/syslog

12、安裝Setting

wget http://docs.cacti.net/_media/plugin:settings-v0.71-1.tgz

mv plugin:settings-v0.71-1.tgz settings-v0.71-1.tgz

tar zxvf settings-v0.71-1.tgz

13、更改權限 

chown -R apache:apache /var/www/html/cacti/plugins/settings/

14、去Web點選安裝並Enable，及安裝完成。

參考網站：Cacti官方網站