Page History

1. Download & Extract the Apache VCL Source

   If you have not already done so, download and extract the source files on the database server:

   Panel
   % wget http://www.apache.org/dist/incubator/vcl/apache-VCL-2.2.1-incubating.tar.bz2 % tar -jxvf apache-VCL-2.2.1-incubating.tar.bz2

2. Install MySQL Server

   1. Install MySQL Server 5.x:

      Panel
      % yum install mysql-server -y

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

      Panel
      % /sbin/chkconfig --level 345 mysqld on % /sbin/service mysqld start

   3. Make sure the firewall on the database server is configured to allow traffic from the web server and management node servers to connect to the MySQL daemon TCP port: 3306.  See the firewall documentation for more information. (man iptables)

3. Create the VCL Database

   1. Run the MySQL command-line client:

      Panel
      % mysql

   2. Create a database:

      Panel
      % CREATE DATABASE vcl;

   3. Create a user with SELECT, INSERT, UPDATE, and DELETE privileges on the database you just created:
      IMPORTANT: Replace 'vcluserpassword' with your own password

      Panel
      mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON vcl.* TO 'vcluser'@'localhost' IDENTIFIED BY 'vcluserpassword';

   4. Exit the MySQL command-line client:

      Panel
      mysql> exit

   5. Import the vcl.sql file into the database:
      Note: The vcl.sql file is included in the mysql directory within the Apache VCL source code

      Panel
      % mysql vcl < apache-VCL-2.2.1-incubating/mysql/vcl.sql

      
      

...