Rsyslog+mysql+loganalyzer Environment Build Log server

Source: Internet
Author: User
Tags syslog rsyslog

Environment: CentOS6.6

Rsyslog+mysql+loganalyzer Environment Build Log server


Client End: 192.168.2.10

MySQL Server: 192.168.2.11



# Client -side installation of prerequisite packages

Yum Install Rsyslog-mysql-y

generates a 2 Files:

/lib64/rsyslog/ommysql.so #rsyslog支持数据库的模块文件/usr/share/doc/rsyslog-mysql-5.8.10/createdb.sql #创建rsyslog日志的数据库命令


# MySQL Server Configuration MySQL Database

Universal Binary Format package installation mariadb , the installation configuration step is skipped.

> Grant all privileges onsyslog.* to ' syslog ' @ ' 192.168.2.% ' identified by ' 123456 ';> flush privileges;> exit

# mysql-u syslog-h 192.168.2.11-p # Enter Password 123456 to test for normal access

# Client -End Installation MySQL to connect to the database

Yum Install mysql-y # executes MySQL command, requires first installing MySQL package mysql-u syslog-h 192.168.2.11-p</usr/share/doc/rsyslog-mysql-5.8.10/ Createdb.sql # Execute Create rsyslog database command on remote MySQL

# perform the above Createdb.sql then you can log in to MySQL to see if the database and related data tables have been generated.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/73/DF/wKiom1YI6ajSElRYAACv1LSKJ3c697.jpg "title=" 1.png " alt= "Wkiom1yi6ajselryaacv1lskj3c697.jpg"/>


# Configuration Rsyslog to support MySQL

Vi/etc/rsyslog.conf

Under the Modules module, add a: $ModLoad Ommysql under the Rules module, modify the following: Comment out the original *.info;mail.none;authpriv.none;cron.none/var/log/mes Sages add a record: *.info;mail.none;authpriv.none;cron.none:ommysql:192.168.2.11,syslog,syslog,123456

Format Description : Ommysql: Database Address : Database name : user name of the database : Database Password

Service Rsyslog Restart # Restart Rsyslog Log service

now, we can Yum after installing a software test, you will find that you are not /var/log/messages in the record.

# MySQL Server to see if you are receiving Client log information for:

> Use syslog;> SELECT * from SystemEvents \g; Will find a similar look, stating that there is no problem with our configuration.


650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/73/DC/wKioL1YI6cjxTVO3AADv_fM4tUA091.jpg "title=" 1.png " alt= "Wkiol1yi6cjxtvo3aadv_fm4tua091.jpg"/>


in the Client Configure front-end presentation tools for logs:

# Configuration Web Server

Yum install httpd php php-mysql php-gd-y

Write a test.php to the /var/www/html/ directory under

<?php $conn =mysql_connect (' 192.168.2.11 ', ' syslog ', ' 123456 ');    if ($conn) echo "Success";    else echo "failure";    Mysql_close (); Phpinfo ();? >


650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/73/DF/wKiom1YI6dmTJSlrAADaz0FFa_0075.jpg "title=" 1.png " alt= "Wkiom1yi6dmtjslraadaz0ffa_0075.jpg"/>


appear, explain Lamp build success.

# installation Loganalyzer

Cd/var/www/html/tar xf/home/tools/loganalyzer-3.6.5.tar.gz-c./cp-r loganalyzer-3.6.5/src/*./CP loganalyzer-3.6.5/ CONTRIB/*.SH./RM-FR src/rm-rf loganalyzer-3.6.5/chmod +x *.sh./configure.sh./secure.shchmod 666 config.php

# Configure on the browser side Loganalyzer

The configuration process is roughly as shown.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/73/DF/wKiom1YI6gjROakAAACjsaE9O-A376.jpg "style=" float: none; "title=" 1.png "alt=" Wkiom1yi6gjroakaaacjsae9o-a376.jpg "/>

# Note that step7 () needs to select MySQL Native, and enter the corresponding database address, database name, data table name, user name, password below.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/73/DC/wKioL1YI6hHjNxx-AAGIZEZqOgA684.jpg "style=" float: none; "title=" 2.png "alt=" Wkiol1yi6hhjnxx-aagizezqoga684.jpg "/>



After the installation is complete, refresh the Ere page. Should look like the following:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/73/DF/wKiom1YI6gmAMrKsAAR0wCVsk3M834.jpg "style=" float: none; "title=" 3.png "alt=" Wkiom1yi6gmamrksaar0wcvsk3m834.jpg "/>


Statistics page can see statistics, such as. But there is only one client-side monitoring statistic. We're going to add the MySQL server in the back.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/73/DC/wKioL1YI6hGyWelvAAG1-dEWmR8724.jpg "style=" float: none; "title=" 4.png "alt=" Wkiol1yi6hgywelvaag1-dewmr8724.jpg "/>



# MySQL Server also configure the log to be sent to the MySQL Save in database:

# Installing Rsyslog-mysql

Yum Install Rsyslog-mysql-y

# Configuration Rsyslog to support MySQL

Vi/etc/rsyslog.conf

Under the Modules module, add a: $ModLoad Ommysql under the Rules module, modify the following: Comment out the original *.info;mail.none;authpriv.none;cron.none/var/log/ Messages Add a record: *.info;mail.none;authpriv.none;cron.none:ommysql:192.168.2.11,syslog,syslog,123456


Service Rsyslog Restart # Restart Rsyslog Service

again in MySQL on the server casually Yum Ann loads several software packages and does the logging test.

# when viewed in a browser, you will find that you already have MySQL The record information

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/73/DC/wKioL1YI6vLASIYmAAGecBmMTsg100.jpg "title=" 5.png " alt= "Wkiol1yi6vlasiymaagecbmmtsg100.jpg"/>


Loganalyzer More features await you to discover ...


The same way, we can also follow the tutorial above to add more hosts to come in.


Rsyslog+mysql+loganalyzer Environment Build Log server

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.