Install squidalyser log analysis software in debianetch4.0

Debianetch4.0 install squidalyser log analysis software-Linux Release Technology-Debian information. The following is a detailed description. 1. First, download Squidalyser 0.2.55 and expand it:
# Tar-zxvf squidalyser-0.2.55.tar.gz

(If DebianLinux is newly installed, Squidparse works normally only after the following software packages are installed. Otherwise, an error is reported. The software package is: libdbi-perl, libdbd-mysql-perl, libgd-graph-perl, and libtime-modules-perl), run the following command to install:

# Apt-get install libdbi-perl
# Apt-get install libdbd-mysql-perl
# Apt-get install libgd-graph-perl
# Apt-get install libtime-modules-perl

2. Because we only use its log collection function, we only copy the Squidparse directory and its content to/usr/local /:
# Cp-r squidalyser-0.2.55/squidparse/usr/local /.

3. Then we need to modify the configuration file squidalyser. conf. The modified content is the setting options for connecting to the database:
# Cd/usr/local/squidparse
# Vi squidalyser. conf
Dbname squid: enter your database name. squid is used by default.
Dbhost 10. x enter the IP address of the MySQL database.
Dbuser squidalyser the user accessing the database
Dbpass password: password used to access the database

4. Finally, we create a crontab entry so that squidparse. pl collects squid logs to the database every early morning and runs:
# Crontab-e
Enter the following content in the Editor:
00 03 ***/usr/local/squidparse. pl

5. Install mysql 3.2.3 and prepare the msyql Database
Mysql-u root-p
Mysql> create database squid;
Mysql> grant all privileges on squid. * to squidalyser @ localhost identified by 'Password ';
Cd/root/squidalyser-0.2.55
Mysql squid-u squidalyser-p