VCL 2.3 Database Installation

{excerpt:hidden=true}How to install MySQL Server, create the VCL database, and import the VCL database schema{excerpt}

Install & Configure the Database¶

1. h2. Download & Extract the Apache VCL Source

2. If you have not already done so, download and the Apache VCL source to¶

   the database server: {tip}wget --trust-server-names '{nolink:http://vcl.apache.org/downloads/download.cgi?action=download&filename=%2Fvcl%2Fapache-VCL-2.3.tar.bz2}'{tip}

3. Extract the files:¶

   {tip}tar -jxvf apache-VCL-2.3.tar.bz2{tip}
4. h2. Install MySQL Server

5. Install MySQL Server 5.x: {tip}yum install mysql-server -y{tip}¶

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

   {tip}/sbin/chkconfig --level 345 mysqld on{tip}

7. Start the MySQL daemon:¶

   {tip}/sbin/service mysqld start{tip}

8. If the iptables firewall is being used and the web server and management¶

   nodes will be on different machines, port 3306 should be opend up {tip} vi /etc/sysconfig/iptables {tip}

   -A RH-Firewall-1-INPUT -m state --state NEW -s -p tcp --dport 3306 -j ACCEPT -A RH-Firewall-1-INPUT -m state --state NEW -s -p tcp --dport 3306 -j ACCEPT service iptables restart

9. h2. Create the VCL Database

10. Run the MySQL command-line client: {tip}mysql{tip}¶

11. Create a database:¶

    {tip}CREATE DATABASE vcl;{tip}

12. Create a user with SELECT, INSERT, UPDATE, DELETE, and CREATE TEMPORARY¶

    TABLES privileges on the database you just created: {tip}GRANT SELECT,INSERT,UPDATE,DELETE,CREATE TEMPORARY TABLES ON vcl.* TO 'vcluser'@'localhost' IDENTIFIED BY 'vcluserpassword';{tip} {note}Replace vcluser and vcluserpassword with that of the user you want to use to connect to the database{note} {info}The GRANT command will automatically create the user if it doesn't already exist{info}

13. Exit the MySQL command-line client: {tip}exit{tip}¶

14. Import the vcl.sql file into the database:¶

    {tip}mysql vcl < apache-VCL-2.3/mysql/vcl.sql{tip} {info}The vcl.sql file is included in the mysql directory within the Apache VCL source code{info}

---

Next step: VCL:VCL 2.3 Web Code Installation