Prerequisites

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 http://www.apache.org/dist/incubator/vcl/apache-VCL-2.2.1-incubating.tar.bz2

   2. Extract the files:

      Tip
      tar -jxvf apache-VCL-2.2.1-incubating.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. Make sure the firewall on the database server is
3. You should have mysql server 5.x installed. If mysql server is not installed:

   Code Block
   yum install mysql-server -y /sbin/chkconfig --level 345 mysqld on /sbin/service mysqld start

4. Your host based firewall (IPTables) should be
   1. configured to allow traffic from the web server and management
   server
   1. node servers to connect to the MySQL daemon TCP port: 3306
   (mysqld).

Setting Up the Database for VCL

1. 1. .  See the firewall documentation for more information.

      Info
      man iptables

2. Create the VCL Database

   1. Run the MySQL command-line client:

      Tip
      mysql

   2. Create a database:

      Tip
      CREATE DATABASE vcl;

   3. Create
3. start the mysql command line client by running

   Code Block
   mysql

4. create a database in mysql named for use with VCL

   Code Block
   CREATE DATABASE vcl;

5. create
   1. a user with SELECT, INSERT, UPDATE, DELETE, and
   DELETE
   1. CREATE TEMPORARY TABLES privileges on the database you just created
   
   NOTE
   1. :
   Replace vcluserpassword with your own password! Code Block GRANT

   1. Tip
      GRANT SELECT,INSERT,UPDATE,DELETE

   1. ,CREATE TEMPORARY TABLES ON

   1. vcl.*

   1. TO

   1. 'vcluser'@'localhost'

   1. IDENTIFIED

   1. BY

   1. 'vcluserpassword';

   exit from the mysql command

   1. 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

   2. Exit the MySQL command-line client: code

      Tip

   1. exit

   locate
   1. Import the vcl.sql file into the database:

      Tip
      mysql vcl < apache-VCL-2.2.1-incubating/mysql/vcl.sql

      Info
      The vcl.sql file

   should be contained in the release artifact you should have downloaded already. After extracting it, look in the mysql directory.
6. import vcl.sql file into database

   Code Block
   mysql vcl < vcl.sql

7. 1. is included in the mysql directory within the Apache VCL source code

8. Install & Configure phpMyAdmin (Optional):

   Excerpt Include
   VCL 2.2.1 phpMyAdmin Installation & Configuration VCL 2.2.1 phpMyAdmin Installation & Configuration nopanel true

   To install phpMyAdmin, follow the instructions on: VCL 2.2.1 phpMyAdmin Installation & Configuration

...

Next step: VCL 2.2.1 Next step: Web Code Installation