Rsyslog mysql log to master analyzer

# Rsyslog mysql analyzer

---

## install lib

# yum install httpd -y
    # chkconfig httpd on

# yum install mysql mysql-server -y
    # chkconfig msyqld on

# mysqladmin -u root password 'tester'
    # /etc/init.d/mysqld start

# mysql_secure_installation 
    # yum install php php-mysql php-gd -y

# yum install rsyslog rsyslog-mysql -y

# ll /usr/share/doc/rsyslog-mysql-5.8.10

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

# grant all on Syslog.* to rsyslog@localhost identified by 'tester';

# flush privileges;
    # mysql -ursyslog -p
    #　grep -v '^$|^#' /etc/rsyslog.conf
    #　wget -c http://download.adiscon.com/loganalyzer/loganalyzer-3.6.6.tar.gz

## 解压

#　tar zxvf loganalyzer-3.6.6.tar.gz

## 复制文件到

# cp -r loganalyzer-3.6.6/src/ /var/www/html/loganalyzer
    # cp -r loganalyzer-3.6.6/contrib/* /var/www/html/loganalyzer/

## 进入到loganalyzer 程序中，将以下脚本赋予执行权限

# cd /var/www/html/loganalyzer/
    # chmod +x configure.sh secure.sh

## 运行configure.sh，将创建一个空白的config.php配置文件

# ./configure.sh