一、准备 rsyslog 用的主机(192.168.30.108)
# 系统默认安装有rsyslog服务
rpm -q rsyslog
rsyslog-8.24.0-34.el7.x86_64
# 安装日志保存到mysql数据库对应的软件包
yum -y install rsyslog-mysql
rpm -ql rsyslog-mysql
/usr/lib64/rsyslog/ommysql.so
/usr/share/doc/rsyslog-8.24.0/mysql-createDB.sql
# 将对应的sql脚本发送到mysql服务器上
scp /usr/share/doc/rsyslog-8.24.0/mysql-createDB.sql 192.168.30.106:/root
# 修改rsyslog配置文件
vim /etc/rsyslog.conf
$ModLoad ommysql # 加载模块
*.info;mail.none;authpriv.none;cron.none :ommysql:192.168.30.17,Syslog,log,centos
配置rsyslog将日志保存到mysql中,需要设置rsyslog.conf
#### MODULES ####
$ModLoad ommysql
#### RULES ####
facility.priority :ommysql:DBHOST,DBNAME,DBUSER, PASSWORD
二、准备 mysql 服务器(192.168.30.106)
yum install -y mariadb-server
systemctl start mariadb
mysql < /root/mysql-createDB.sql
# 创建日志保存用的数据库帐号
mysql > GRANT ALL ON Syslog.* TO 'log'@'192.168.30.%' IDENTIFIED BY 'centos';
mysql > select user,host,password from mysql.user;
+------+----------------+-------------------------------------------+
| user | host | password |
+------+----------------+-------------------------------------------+
| root | localhost | |
| root | mysql | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | mysql | |
| log | 192.168.30.% | *128977E278358FF80A246B5046F51043A2B1FCED |
+------+----------------+-------------------------------------------+
三、准备 loganalyzer 主机(192.168.30.117)
yum -y install httpd php php-mysql php-gd
# 准备loganalyzer 应用数据
wget http://download.adiscon.com/loganalyzer/loganalyzer-4.1.7.tar.gz
tar xf loganalyzer-4.1.7.tar.gz
cp -a loganalyzer-4.1.7/src/* /var/www/html/
cd /var/www/html/loganalyzer
touch config.php
chmod 666 config.php
# 应为php包硬件带有php相关的配置文件了,所以这里不用其他设置。如果是php-fpm 包,这里还是需要手动配置的
systemctl start httpd
# 配置loganalyzer
http://192.168.30.117/install.php
根据下图配置数据库