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:

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

    2. Extract the files:

      tar -jxvf apache-VCL-2.2.1-incubating.tar.bz2

  2. Install MySQL Server

    1. Install MySQL Server 5.x:

      yum install mysql-server -y

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

      /sbin/chkconfig --level 345 mysqld on

    3. Start the MySQL daemon:

      /sbin/service mysqld start

    4. 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:

      mysql

    2. Create a database:

      CREATE DATABASE vcl;

    3. Create a user with SELECT, INSERT, UPDATE, DELETE, and CREATE TEMPORARY TABLES privileges on the database you just created:

      GRANT SELECT,INSERT,UPDATE,DELETE,CREATE TEMPORARY TABLES ON vcl.* TO 'vcluser'@'localhost' IDENTIFIED BY 'vcluserpassword';

      Replace vcluser and vcluserpassword with that of the user you want to use to connect to the database

      The GRANT command will automatically create the user if it doesn't already exist

    4. Exit the MySQL command-line client:

      exit

    5. Import the vcl.sql file into the database:

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

      The vcl.sql file is included in the mysql directory within the Apache VCL source code

  4. Install & Configure phpMyAdmin (Optional):

    phpMyAdmin is a free and optional tool which allows MySQL to be administered using a web browser. It makes administering the VCL database easier. This tool can be installed on the VCL web server. To install phpMyAdmin, follow the instructions on: VCL 2.2.1 phpMyAdmin Installation & Configuration

Next step: VCL 2.2.1 Web Code Installation

  • No labels