Page History

Prerequisites

1. You should have mysql server

   Install MySQL Server

   Install MySQL Server 5.x installed. If mysql server is not installed: panel

   Code Block
   yum install mysql-server -y

   Configure the MySQL daemon (mysqld) to start automatically: Panel

   /sbin/chkconfig --level 345 mysqld on

   
   

   /sbin/service mysqld start

2. Your host based firewall (IPTables) should be Make sure the firewall on the database server is configured to allow traffic from the web server and management node servers server to connect to the MySQL daemon TCP port : 3306 .  See the firewall documentation for more information:

   Panel
   man iptables

   (mysqld).

Setting Up the Database for VCL

1. start the mysql command line client by running

   Code Block
   mysql

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

   Code Block
   CREATE DATABASE vcl;

3. create

   Create the VCL Database

4. Run the MySQL command-line client:

   Panel
   mysql

5. Create a database:

   Panel
   CREATE DATABASE vcl;

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

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

6. Exit exit from the MySQL mysql command - line client: panel

   Code Block
   exit

7. Import the locate vcl.sql file into the database:
   Note: The
   The vcl.sql file is included should be contained in the release artifact you should have downloaded already. After extracting it, look in the mysql directory within the Apache VCL source code.
8. import vcl.sql file into database

   Code Block
   mysql vcl <

   Panelmysql vcl < mysql/

   vcl.sql

Next step: VCL 2.2.1 Web Code Installation