Rsyslog+mysql+loganalyzer

Rsyslog+mysql+loganalyzer

On the Linux system, the system can record from boot to the current system when what happened, and classify it, classified into a specific log file, such as the system itself generated problems, user login information, network data information and so on.

On CentOS There is a rsyslog dedicated to record information on the system log, although Rsyslog is powerful enough, but the usual log files are only in the form of text, if we combine it with loganalyzer to achieve the graphical display of log information, Below we on a host simple implementation of Rsyslog+mysql+loganalyzer together to achieve the graphical display of log information.

Start the MARIADB service and verify

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/89/32/wKioL1gMEq3zRRADAABRR2XS5x4915.png "style=" float: none; "title=" 1 start mariadb and verify the. png "alt=" Wkiol1gmeq3zrradaabrr2xs5x4915.png "/>

Installing Rsyslog-mysql

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/89/35/wKiom1gMEq3Cy_Z1AAA0K3P1lFI282.png "style=" float: none; "title=" 2 install rsyslog-mysql.png "alt=" Wkiom1gmeq3cy_z1aaa0k3p1lfi282.png "/>

RPM command to view generated files

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/89/32/wKioL1gMEq2Sq_yMAAAUfnp_gr4939.png "style=" float: none; "Title=" 3 view the files that are generated by the installation. png "alt=" Wkiol1gmeq2sq_ymaaaufnp_gr4939.png "/>

Prepare Rsyslog dedicated user and account and reread

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/89/32/wKioL1gMEq7z_w9PAABZpVEY-0E936.png "style=" float: none; "title=" 4 prepare Rsyslog dedicated user and account and reread. png "alt=" Wkiol1gmeq7z_w9paabzpvey-0e936.png "/>

Verify that the authorized user is generating

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/89/35/wKiom1gMEq7SWzLPAABALJzWyCw269.png "style=" float: none; "Title=" 5 verifies whether an authorized user generates a. png "alt=" Wkiom1gmeq7swzlpaabaljzwycw269.png "/>

Execute SQL script with Rsyslog user

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/89/32/wKioL1gMEq6xnKlBAAARigV5944982.png "style=" float: none; "title=" 6 executes SQL script with Rsyslog user. png "alt=" Wkiol1gmeq6xnklbaaarigv5944982.png "/>

Verify

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/89/35/wKiom1gMEq6wzshVAAA7S_4Umd4871.png "title=" 7 authentication. png "style=" Float:none; "alt=" Wkiom1gmeq6wzshvaaa7s_4umd4871.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/89/35/wKiom1gMEq7SuIADAAARbCg6rwE609.png "style=" float: none; "Title=" 7.1 authentication. png "alt=" Wkiom1gmeq7suiadaaarbcg6rwe609.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/89/32/wKioL1gMEq7zJCAgAAAbllfQjEA150.png "style=" float: none; "title=" 7.2 authentication. png "alt=" Wkiol1gmeq7zjcagaaabllfqjea150.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/89/35/wKiom1gMEq6SOt1fAACGkcYWPKE923.png "style=" float: none; "Title=" 7.3 authentication. png "alt=" Wkiom1gmeq6sot1faacgkcywpke923.png "/>

Modifying the Rsyslog configuration file

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/89/32/wKioL1gMEq6CMcsRAAAHyziFEOI230.png "style=" float: none; "Title=" 8.1 Modify the Rsyslog configuration file. png "alt=" Wkiol1gmeq6cmcsraaahyzifeoi230.png "/>

Add Module

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/89/35/wKiom1gMEq-RIk5cAAASbXMSaUU773.png "style=" float: none; "title=" 8 Add module. png "alt=" Wkiom1gmeq-rik5caaasbxmsauu773.png "/>

Add rules

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/89/32/wKioL1gMEq_AYhadAAAYfuEI5nY704.png "style=" float: none; "title=" 9 Add rules.png "alt=" Wkiol1gmeq_ayhadaaayfuei5ny704.png "/>

Restart Service

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/89/35/wKiom1gMEq-Bi5PpAABD_uc09qQ539.png "style=" float: none; "title=" 10 restart service. png "alt=" Wkiom1gmeq-bi5ppaabd_uc09qq539.png "/>

Verify

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/89/32/wKioL1gMEq-AtXUWAABUo07iIXM319.png "style=" float: none; "Title=" 11 authentication. png "alt=" Wkiol1gmeq-atxuwaabuo07iixm319.png "/>

Deploy amp

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/89/35/wKiom1gMEq-jRjMLAAAmW2GgDng201.png "style=" float: none; "title=" 12 Department amp.png "alt=" Wkiom1gmeq-jrjmlaaamw2ggdng201.png "/>

Configuration

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/89/32/wKioL1gMEq-BnA8mAAB-SkENBBI066.png "style=" float: none; "title=" 13 configuration. png "alt=" Wkiol1gmeq-bna8maab-skenbbi066.png "/>

Execute script

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/89/35/wKiom1gMErDTvlwZAACJGkaQpPA765.png "style=" float: none; "Title=" 14 execute script. png "alt=" Wkiom1gmerdtvlwzaacjgkaqppa765.png "/>

Start the Web service and go to the Loganalyzer configuration interface

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/89/35/wKiom1gMErCB1e-iAAAqT1xKnzg344.png "style=" float: none; "title=" 15.png "alt=" Wkiom1gmercb1e-iaaaqt1xknzg344.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/89/32/wKioL1gMErDDVh0OAAAb9odpbwA085.png "style=" float: none; "title=" 16.png "alt=" Wkiol1gmerddvh0oaaab9odpbwa085.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/89/32/wKioL1gMErCDXG1wAABeWCfXYag236.png "style=" float: none; "title=" 17.png "alt=" Wkiol1gmercdxg1waabewcfxyag236.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/89/35/wKiom1gMErDwjKodAABZ6GRIdr0977.png "style=" float: none; "title=" 18.png "alt=" Wkiom1gmerdwjkodaabz6gridr0977.png "/>

Configuration Settings Complete

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/89/32/wKioL1gMErDBmu90AAAv85FE2t4183.png "style=" float: none; "title=" 19.png "alt=" Wkiol1gmerdbmu90aaav85fe2t4183.png "/>

Enter the Loganalyzer interface

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/89/35/wKiom1gMErHQPiTvAALTSvtNu3Y423.png "style=" float: none; "title=" 20.png "alt=" Wkiom1gmerhqpitvaaltsvtnu3y423.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/89/32/wKioL1gMErGQcgnHAACVnO7TMi8166.png "style=" float: none; "title=" 21.png "alt=" Wkiol1gmergqcgnhaacvno7tmi8166.png "/>

This article is from the "11798474" blog, please be sure to keep this source http://11808474.blog.51cto.com/11798474/1864686

Rsyslog+mysql+loganalyzer