Install & Configure the Database

1. Download & Extract the Apache VCL Source

   1. If you have not already done so, download and the Apache VCL source to the database server:

      Tip
      wget --trust-server-names ''

   2. Extract the files:

      Tip
      tar -jxvf apache-VCL-2.3.tar.bz2

2. Install MySQL Server

   1. Install MySQL Server 5.x:

      Tip
      yum install mysql-server -y

   2. Configure the MySQL daemon (mysqld) to start automatically:

      Tip
      /sbin/chkconfig --level 345 mysqld on

   3. Start the MySQL daemon:

      Tip
      /sbin/service mysqld start

   4. If the iptables firewall is being used and the web server and management nodes will be on different machines, port 3306 should be opend up

      Tip
      vi /etc/sysconfig/iptables

      No Format
      -A RH-Firewall-1-INPUT -m state --state NEW -s <web server IP> -p tcp --dport 3306 -j ACCEPT -A RH-Firewall-1-INPUT -m state --state NEW -s <management node IP> -p tcp --dport 3306 -j ACCEPT service iptables restart

3. Create the VCL Database

   1. Run the MySQL command-line client:

      Tip
      mysql

   2. Create a database:

      Tip
      CREATE DATABASE vcl;

   3. Create a user with SELECT, INSERT, UPDATE, DELETE, and CREATE TEMPORARY TABLES privileges on the database you just created:

      Tip
      GRANT SELECT,INSERT,UPDATE,DELETE,CREATE TEMPORARY TABLES ON vcl.* TO 'vcluser'@'localhost' IDENTIFIED BY 'vcluserpassword';

      Note
      Replace vcluser and vcluserpassword with that of the user you want to use to connect to the database

      Info
      The GRANT command will automatically create the user if it doesn't already exist

   4. Exit the MySQL command-line client:

      Tip
      exit

   5. Import the vcl.sql file into the database:

      Tip
      mysql vcl < apache-VCL-2.3/mysql/vcl.sql

      Info
      The vcl.sql file is included in the mysql directory within the Apache VCL source code

Next step: VCL 2.3 Web Code Installation