標籤：
一、安裝程式和組件系統為CentOS6.6# yum install httpd php php-mysql php-gd mysql mysql-server rsyslog-mysql
二、準備相關配置並測試環境
1、啟動http，mysql服務# service mysqld start
# chkconfig mysqld on
# service httpd start
# chkconfig httpd on
# vim /var/www/html/index.php
2、建立資料庫，建立使用者並授權
# rpm -ql rsyslog-mysql =>查看安裝產生的檔案擷取createDB.sql位置mysql < /usr/share/doc/rsyslog-mysql-5.8.10/createDB.sql ==>建立rsyslog的資料庫和表
mysql> grant all on Syslog.* to [email protected] identified by ‘slpass‘; ==>建立賬戶並授權
mysql> grant all on Syslog.* to [email protected] identified by ‘slpass‘;
mysql> flush privileges;
三、配置rsyslog
1、vim /etc/rsyslog.conf
2、在#### Modules #####啟用模組：$ModLoad ommysql ==>在設定檔添加
3、在####rules####段中定義記錄日誌資訊於資料庫中facility.priority :ommysql:SERVER_IP,DATABASE,USERNAME,PASSWORD*.info;mail.none;authpriv.none;cron.none :ommysql:127.0.0.1,Syslog,sl,slpass ==>在設定檔修改 # service rsyslog restart# yum -y reinstall zsh
四、安裝loganalyzer（loganalyzer-3.6.5）# tar xf loganalyzer-3.6.5# cp /var/www/html/loganalyzer-3.6.5/contrib/* /var/www/html//
# cd /var/www/html/# chmod +x configure.sh secure.sh# ./configure.sh# ./secure.sh# chmod 666 config.php# chown -R apache.apache ./*
rsyslog日誌儲存於MySQL中
