Page History

Prerequisites

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

2. Your host based firewall (IPTables) should be configured to allow traffic from the web server and management server to connect to TCP port 3306 (mysqld).

Setting Up the Database for VCL

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

   Code Block
   CREATE DATABASE vcl;

2. create a user with SELECT, INSERT, UPDATE, and DELETE privileges on the database you just created
   NOTE: Replace vcluserpassword with your own password!

   Code Block
   GRANT SELECT,INSERT,UPDATE,DELETE ON vcl.* TO 'vcluser'@'localhost' IDENTIFIED BY 'vcluserpassword';

3. get vcl.sql file

   Code Block
   svn export https://svn.apache.org/repos/asf/incubator/vcl/trunk/mysql/vcl.sql

4. import vcl.sql file into database

   Code Block
   mysql vcl < vcl.sql