Page History

Prerequisites

1. Install MySQL Server

   1. Install MySQL Server
   You should have mysql server
   1. 5.x
   installed. If mysql server is not installed
   1. : code

      Panel

   1. yum

   1. install

   1. mysql-server

   1. -y

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

      Panel
      /sbin/chkconfig

   1. --level

   1. 345

   1. mysqld

   1. on

   1. /sbin/service

   1. mysqld

   1. start

   Your host based firewall (IPTables) should be
   2. Make sure the firewall on the database server is 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:

      Panel
      man iptables

2. Create the VCL Database

   1. Run the MySQL command-line client:

      Panel
      mysql

   2. Create a database:

      Panel
      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, and DELETE privileges on the database you just created:
      NOTE: Replace 'vcluserpassword' with your own password
   !
   1. code

      Panel

   1. GRANT

   1. SELECT,INSERT,UPDATE,DELETE

   1. ON

   1. vcl.*

   1. TO

   1. 'vcluser'@'localhost'

   1. IDENTIFIED

   1. BY

   1. 'vcluserpassword';

   exit from
   1. Exit the
   mysql
   1. MySQL command-line client: code

      Panel

   1. exit

   locate
   1. Import the vcl.sql file
   
   The
   1. into the database:
      Note: 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

      Panel
      mysql vcl < mysql/vcl.sql

Next step: VCL 2.2.1 Next step: Web Code Installation