Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Server \ Logging information through the web GUI (LogAnalyzer)     - MySQL appears data too long for column 'name' at row 1 to solve (Database)

- Vi (Vim) keyboard map and its basic commands (Linux)

- Installation and Configuration OpenVPN server and client on Ubuntu 15.04 (Server)

- Remove old kernel on Ubuntu (Linux)

- RedHat install GCC problem --- Depends (Linux)

- On the Web application attack techniques Common (Linux)

- Linux directory permissions to read and execute permissions difference (Linux)

- Ubuntu study notes and related problem solving (Linux)

- The difference between equals and == in Java (Programming)

- Linux gprof oprofiling and performance testing tools (Linux)

- To_teach you three strategies to prevent the LAN IP address theft (Linux)

- Zend Studio PHP syntax color scheme to export (Linux)

- How to clear the DNS query cache under Linux / Unix / Mac (Linux)

- Ubuntu Tutorial: E: Failed to get lock / var / lib / apt / lists / lock - open (Linux)

- MySQL EXPLAIN SQL output description (Database)

- Java memory area and memory overflow exception (Programming)

- Binding multiple network cards in Linux using command nmcli (Linux)

- Linux boot process and run level (Linux)

- Why everybody ought to know LLVM (Linux)

- MySQL and MariaDB traditional master-slave cluster configuration (Database)

  Logging information through the web GUI (LogAnalyzer)
  Add Date : 2017-08-31      
  Display log information via webGUI (LogAnalyzer)

1. Install the package and see if php is working properly

[Root @ abctest~] # yum-y install httpd php php-mysql mysql-server rsyslog-mysql

[Root @ abctest~] # service httpd start

[Root @ abctest~] # cd / var / www / html /

[Root @ abctest html] # vim index.php

< ? Php
        Phpinfo ();

Open the browser If the php page shows no problem, you can delete the index.php document

2. Configure the rsyslog dependent database

[Root @ abctest ~] # service mysqld start

[Root @ abctest ~] # mysql

3. Create a database user and authorize it

Mysql> use Syslog
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
Mysql> grant all on Syslog. * To rsysloguser@ identified by 'rsyslogpwd';
Query OK, 0 rows affected (0.00 sec)
Mysql> grant all on Syslog. * To rsysloguser @ localhost identified by 'rsyslogpwd';
Query OK, 0 rows affected (0.00 sec)
Mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

4. Configure the rsyslog enablement module

5. Configure rsyslog to connect to the database

The configuration parameters are:

Facility.oriority: ommysql: SERVER_IP, DATABASE, USERNAME, PASSWORD

6. Restart the rsyslog service and test

No new logs were found after installing the software

View the database, found that the letter log records

7. Download loganalyzer and rz upload to the server (rz command needs to install lrzsz package), and extract

[Root @ abctest~] # tar xf loganalyzer-4.1.2.tar.gz -C / var / www / html /

[Root @ abctest~] # cd / var / www / html /

[Root @ abctest html] # ll

Total 4

Drwxrwxr-x. 5 root root 4096 Feb 23 2015 loganalyzer-4.1.2

8. Review the installation documentation

[Root @ abctest loganalyzer-4.1.2] # less INSTALL

9. Create a log folder, and loganalyzer / src all the files under the log, and the contrib under the configure.sh and secure.sh moved to the log

[Root @ abctest html] # mkdir log

[Root @ abctest html] # mv loganalyzer-4.1.2 / src / * log

[Root @ abctest html] # cd log

[Root @ abctest log] # cp ../loganalyzer-4.1.2/contrib/*.

10. To configure.sh and secure.sh execute permissions and execute, and change config.php permissions. And to log all the files under the implementation of apache

[Root @ abctest log] # chmod + x configure.sh secure.sh

[Root @ abctest log] # ./configure.sh

[Root @ abctest log] # ./secure.sh

[Root @ abctest log] # chmod 666 config.php

[Root @ abctest log] # chown apache.apache ./* -R

11. Enter the address of the browser, such as the following figure shows the above steps are no problem, and click here

This step is to check the dependencies, click next can

This step is to ask config.php whether to write, we have given authority before, so directly click next

The first option in Step 3 is how many logs are displayed per page;

The second is the maximum number of characters per message;

The third item is the maximum number of characters displayed for all other class characters;

The fifth is whether to automatically resolve the ip address, select the host name is displayed here, first select No. Then click Next.

Select the data type mysql native, and then fill in the corresponding database information

Then click next to complete

You can see that loganalyzer has read the logs in the database.
- About Java 7 module system (Programming)
- Four safety delete files under Linux tools (Linux)
- The Gitlab migrated to Docker container (Server)
- Try the command ip, ifconfig is obsolete under Linux (Linux)
- Use MongoDB C # MongoDB official driving operation (Database)
- On the design of Oracle database backup (Database)
- The REVERSE function of DB2 (Database)
- Github Remote Assistance (Linux)
- Android WebView use layman (Programming)
- Linux POST fstab configuration file read-only variable can not be modified problem (Linux)
- Linux command line to put on your coat GUI (Linux)
- Ubuntu 14.04 running ASP.NET Configuration Mono + Jexus (Server)
- Mac OS X command line to submit the local project to Git (Server)
- Print Linux system error codes (Linux)
- Linux create and delete user step (Linux)
- Linux Services Comments (Linux)
- To compile and install OpenCV-2.3.1 FFmpeg-2.1.2 under CentOS (Linux)
- Oracle Database routine inspection (Database)
- Incremental garbage collection mechanism for Ruby 2.2 (Programming)
- ARP Linux-related operations (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.