Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

Excerpt

This page describes how to create the VCL MySQL database and import the VCL database schema.

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. 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 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';
    
  4. exit from the mysql command line client:
    Code Block
    exit
    
  5. locate vcl.sql file
    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
    

Next step: Web Code Installation