centos rsyslog mysql_CentOS利用Rsyslog+LogAnalyzer+MySQL部署日志服务器centos

一、安装并设置LAMP环境

yum -y install httpd mysql* php*

二、安装Rsyslog

服务器端：

yum install  rsyslog rsyslog-mysql

rsyslog-mysql :将日志传送到MySQL 数据库

mysql -uroot -p1234 < /usr/share/doc/rsyslog-mysql-5.8.10/createDB.sql

配置数据权限

# mysql -uroot –p

mysql> grant all on Syslog.* to syslog@localhost identified by "syslog";

mysql> flush privileges;

mysql> exit

修改配置文件

more /etc/rsyslog.conf

#### MODULES ####

$ModLoad imuxsock # provides support for local system logging (e.g. via logger command)

$ModLoad imklog   # provides kernel logging support (previously done by rklogd)

$ModLoad immark  # provides --MARK-- message capability

###Mysql####

$ModLoad ommysql.so

*.* :ommysql:localhost,Syslog,syslog,syslog

# Provides UDP syslog reception

$ModLoad imudp