This article is second part of the article Setup Rsyslog with MySQL and LogAnalyzer on CentOS/RHEL systems. In the first part we have integrated Rsyslog with MySQL database server, and all the logs are now saving in database. For recalling below is few configuration details which we used in part-1 to setup it.
Rsyslog MySQL Database: Syslog
Rsyslog MySQL Username: rsyslog
Rsyslog MySQL Password: MYSQLPASSWORD
Let’s start the setup of LogAnalyzer on your Linux system with rsyslog database using following steps.
Step 1 – Download LogAnalyzer Source
Download the LogAnalyzer latest version from its official download site or use the following command to download 4.1.5 (Current latest version) version and extract it.
$ cd /tmp $ wget http://download.adiscon.com/loganalyzer/loganalyzer-4.1.5.tar.gz $ tar xzf loganalyzer-4.1.5.tar.gz
After extracting copy the required files to web server default document root as below.
$ mv loganalyzer-4.1.5/src /var/www/html/loganalyzer
Step 2 – Create Config File
Now create a blank configuration file named config.php in loganalyzer directory and setup write permission to apache user.
$ cd /var/www/html/loganalyzer $ touch config.php $ chown www-data:www-data config.php # Use apache for redhat system $ chmod 777 config.php
Step 3 – Start Loganalyzer Web Installer
After completing above steps open following url in your favorite web browser to start LogAnalyzer web installer.
Now follow the web installer steps as per below given screen shots.
Step 3.1: Just click Next.
Step 3.2: Make sure config.php is writable and click Next.
Step 3.3: Fill the database details for loganalyzer, we can also use same database used for Rsyslog and click Next.
Step 3.4: In this step installer will create database table, if tables already found, you will get an warning of data overwritten. We just need to click Next.
Step 3.5: This screen will show the result of table creation’s. Just click Next
Step 3.6: Create an Administrator account and click Next.
Step 3.7: Fill the Rsyslog database details and click Next.
Step 3.8: LogAnalyzer installation has been completed. We just need to click Finish.
Step 3.9: Login to LogAnalyzer using Administrator credentials created in Step 3.6.
Congratulation’s! on successful configuration of LogAnalyzer with Rsyslog MySQL database. Read other article to configure Rsyslog to collect logs on central server. So we can monitor all server logs at on place using LogAnalyzer.