Author: buildbot
Date: Fri Aug 3 18:00:01 2012
New Revision: 827864
Log:
Staging update by buildbot for vcl
Modified:
websites/staging/vcl/trunk/content/ (props changed)
websites/staging/vcl/trunk/content/docs/VCL23Installation.html
Propchange: websites/staging/vcl/trunk/content/
------------------------------------------------------------------------------
--- cms:source-revision (original)
+++ cms:source-revision Fri Aug 3 18:00:01 2012
@@ -1 +1 @@
-1369119
+1369124
Modified: websites/staging/vcl/trunk/content/docs/VCL23Installation.html
==============================================================================
--- websites/staging/vcl/trunk/content/docs/VCL23Installation.html (original)
+++ websites/staging/vcl/trunk/content/docs/VCL23Installation.html Fri Aug 3
18:00:01 2012
@@ -88,73 +88,85 @@
</div>
<h1 id="database">Install & Configure the Database</h1>
<p>VCL currently supports the use of mysql database.</p>
-<div class="codehilite"><pre><span class="mi">1</span><span class="o">.</span>
<span class="n">Download</span> <span class="ow">and</span> <span
class="n">Extract</span> <span class="n">the</span> <span
class="n">Apache</span> <span class="n">VCL</span> <span class="n">Source</span>
- <span class="o">*</span> <span class="n">If</span> <span
class="n">you</span> <span class="n">have</span> <span class="ow">not</span>
<span class="n">already</span> <span class="n">done</span> <span
class="n">so</span><span class="p">,</span> <span class="n">download</span>
<span class="ow">and</span> <span class="n">the</span> <span
class="n">Apache</span> <span class="n">VCL</span> <span
class="n">source</span> <span class="n">to</span> <span class="n">the</span>
<span class="n">database</span> <span class="n">server:</span>
-
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="n">wget</span> <span class="n">http:</span><span
class="sr">//</span><span class="n">www</span><span class="o">.</span><span
class="n">apache</span><span class="o">.</span><span class="n">org</span><span
class="sr">/dist/</span><span class="n">vcl</span><span class="o">/</span><span
class="n">apache</span><span class="o">-</span><span class="n">VCL</span><span
class="o">-</span><span class="mf">2.3</span><span class="o">.</span><span
class="n">tar</span><span class="o">.</span><span class="n">bz2</span>
-
- <span class="o">*</span> <span class="n">Extract</span> <span
class="n">the</span> <span class="n">files:</span>
-
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="n">tar</span> <span class="o">-</span><span
class="n">jxvf</span> <span class="n">apache</span><span
class="o">-</span><span class="n">VCL</span><span class="o">-</span><span
class="mf">2.3</span><span class="o">.</span><span class="n">tar</span><span
class="o">.</span><span class="n">bz2</span>
-
-<span class="mi">2</span><span class="o">.</span> <span
class="n">Install</span> <span class="n">MySQL</span> <span
class="n">Server</span>
-
- <span class="o">*</span> <span class="n">Install</span> <span
class="n">MySQL</span> <span class="n">Server</span> <span
class="mi">5</span><span class="o">.</span><span class="n">x</span>
-
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="n">yum</span> <span class="n">install</span> <span
class="n">mysql</span><span class="o">-</span><span class="n">server</span>
<span class="o">-</span><span class="n">y</span>
-
- <span class="o">*</span> <span class="n">Configure</span> <span
class="n">the</span> <span class="n">MySQL</span> <span class="n">daemon</span>
<span class="p">(</span><span class="n">mysqld</span><span class="p">)</span>
<span class="n">to</span> <span class="n">start</span> <span
class="n">automatically:</span>
-
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="sr">/sbin/c</span><span class="n">hkconfig</span> <span
class="o">--</span><span class="n">level</span> <span class="mi">345</span>
<span class="n">mysqld</span> <span class="n">on</span>
-
- <span class="o">*</span> <span class="n">Start</span> <span
class="n">the</span> <span class="n">MySQL</span> <span class="n">daemon:</span>
-
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="sr">/sbin/s</span><span class="n">ervice</span> <span
class="n">mysqld</span> <span class="n">start</span>
-
- <span class="o">*</span> <span class="n">If</span> <span
class="n">the</span> <span class="n">iptables</span> <span
class="n">firewall</span> <span class="n">is</span> <span
class="n">being</span> <span class="n">used</span> <span class="ow">and</span>
<span class="n">the</span> <span class="n">web</span> <span
class="n">server</span> <span class="ow">and</span> <span
class="n">management</span> <span class="n">nodes</span> <span
class="n">will</span> <span class="n">be</span> <span class="n">on</span> <span
class="n">different</span> <span class="n">machines</span><span
class="p">,</span> <span class="n">port</span> <span class="mi">3306</span>
<span class="n">should</span> <span class="n">be</span> <span
class="n">opened</span> <span class="n">up</span>
-
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="n">vi</span> <span class="sr">/etc/s</span><span
class="n">ysconfig</span><span class="o">/</span><span class="n">iptables</span>
-
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="o">-</span><span class="n">A</span> <span
class="n">RH</span><span class="o">-</span><span class="n">Firewall</span><span
class="o">-</span><span class="mi">1</span><span class="o">-</span><span
class="n">INPUT</span> <span class="o">-</span><span class="n">m</span> <span
class="n">state</span> <span class="o">--</span><span class="n">state</span>
<span class="n">NEW</span> <span class="o">-</span><span class="n">s</span>
<span class="o"><</span><span class="n">web</span> <span
class="n">server</span> <span class="n">IP</span><span class="o">></span>
<span class="o">-</span><span class="n">p</span> <span class="n">tcp</span>
<span class="o">--</span><span class="n">dport</span> <span
class="mi">3306</span> <span class="o">-</span><span class="n">j</span> <span
class="n">ACCEPT</span>
- <span class="o">-</span><span class="n">A</span> <span
class="n">RH</span><span class="o">-</span><span class="n">Firewall</span><span
class="o">-</span><span class="mi">1</span><span class="o">-</span><span
class="n">INPUT</span> <span class="o">-</span><span class="n">m</span> <span
class="n">state</span> <span class="o">--</span><span class="n">state</span>
<span class="n">NEW</span> <span class="o">-</span><span class="n">s</span>
<span class="o"><</span><span class="n">management</span> <span
class="n">node</span> <span class="n">IP</span><span class="o">></span>
<span class="o">-</span><span class="n">p</span> <span class="n">tcp</span>
<span class="o">--</span><span class="n">dport</span> <span
class="mi">3306</span> <span class="o">-</span><span class="n">j</span> <span
class="n">ACCEPT</span>
- <span class="n">service</span> <span class="n">iptables</span> <span
class="n">restart</span><span class="sr"></code></pre></span>
-
-<span class="mi">3</span><span class="o">.</span> <span
class="n">Create</span> <span class="n">the</span> <span class="n">VCL</span>
<span class="n">Database</span>
-
- <span class="o">*</span> <span class="n">Run</span> <span
class="n">the</span> <span class="n">MySQL</span> <span
class="n">command</span><span class="o">-</span><span class="n">line</span>
<span class="n">client:</span>
-
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="n">mysql</span>
+<ol>
+<li>
+<p>Download and Extract the Apache VCL Source</p>
+<ul>
+<li>
+<p>If you have not already done so, download and the Apache VCL source to the
database server:</p>
+<p>:::BashLexer
+wget http://www.apache.org/dist/vcl/apache-VCL-2.3.tar.bz2</p>
+</li>
+<li>
+<p>Extract the files:</p>
+<p>:::BashLexer
+tar -jxvf apache-VCL-2.3.tar.bz2</p>
+</li>
+</ul>
+</li>
+<li>
+<p>Install MySQL Server</p>
+<div class="codehilite"><pre>* Install MySQL Server 5.x
- <span class="o">*</span> <span class="n">Create</span> <span
class="n">a</span> <span class="n">database:</span>
+ :::BashLexer
+ yum install mysql-server -y
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="n">CREATE</span> <span class="n">DATABASE</span> <span
class="n">vcl</span><span class="p">;</span>
+* Configure the MySQL daemon (mysqld) to start automatically:
- <span class="o">*</span> <span class="n">Create</span> <span
class="n">a</span> <span class="n">user</span> <span class="n">with</span>
<span class="n">SELECT</span><span class="p">,</span> <span
class="n">INSERT</span><span class="p">,</span> <span
class="n">UPDATE</span><span class="p">,</span> <span
class="n">DELETE</span><span class="p">,</span> <span class="ow">and</span>
<span class="n">CREATE</span> <span class="n">TEMPORARY</span> <span
class="n">TABLES</span> <span class="n">privileges</span> <span
class="n">on</span> <span class="n">the</span> <span class="n">database</span>
<span class="n">you</span> <span class="n">just</span> <span
class="n">created:</span>
+ :::BashLexer
+ /sbin/chkconfig --level 345 mysqld on
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="n">GRANT</span> <span class="n">SELECT</span><span
class="p">,</span><span class="n">INSERT</span><span class="p">,</span><span
class="n">UPDATE</span><span class="p">,</span><span
class="n">DELETE</span><span class="p">,</span><span class="n">CREATE</span>
<span class="n">TEMPORARY</span> <span class="n">TABLES</span> <span
class="n">ON</span> <span class="n">vcl</span><span class="o">.*</span> <span
class="n">TO</span> <span class="s">'**vcluser**'</span><span
class="nv">@</span><span class="err">'</span><span
class="nv">localhost</span><span class="s">' IDENTIFIED BY
'</span><span class="o">**</span><span
class="n">vcluserpassword</span><span class="o">**</span><span
class="err">'</span><span class="p">;</span>
+* Start the MySQL daemon:
- <span class="o">*</span> <span class="n">Exit</span> <span
class="n">the</span> <span class="n">MySQL</span> <span
class="n">command</span><span class="o">-</span><span class="n">line</span>
<span class="n">client</span>
+ :::BashLexer
+ /sbin/service mysqld start
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="nb">exit</span>
+* If the iptables firewall is being used and the web server and management
nodes will be on different machines, port 3306 should be opened up
- <span class="o">*</span> <span class="n">Import</span> <span
class="n">the</span> <span class="n">vcl</span><span class="o">.</span><span
class="n">sql</span> <span class="n">file</span> <span class="n">into</span>
<span class="n">the</span> <span class="n">database</span><span
class="o">.</span> <span class="n">The</span> <span class="o">**</span><span
class="n">vcl</span><span class="o">.</span><span class="n">sql</span><span
class="o">**</span> <span class="n">file</span> <span class="n">is</span> <span
class="n">included</span> <span class="n">in</span> <span class="n">the</span>
<span class="o">**</span><span class="n">mysql</span><span class="o">**</span>
<span class="n">directory</span> <span class="n">within</span> <span
class="n">the</span> <span class="n">Apache</span> <span class="n">VCL</span>
<span class="n">source</span> <span class="n">code</span>
+ :::BashLexer
+ vi /etc/sysconfig/iptables
- <span class="o">::</span><span class="p">:</span><span
class="n">BashLexer</span>
- <span class="n">mysql</span> <span class="n">vcl</span> <span
class="o"><</span> <span class="n">apache</span><span
class="o">-</span><span class="n">VCL</span><span class="o">-</span><span
class="mf">2.3</span><span class="sr">/mysql/</span><span
class="n">vcl</span><span class="o">.</span><span class="n">sql</span>
+ :::BashLexer
+ -A RH-Firewall-1-INPUT -m state --state NEW -s <span
class="nt"><web</span> <span class="err">server</span> <span
class="err">IP</span><span class="nt">></span> -p tcp --dport 3306 -j ACCEPT
+ -A RH-Firewall-1-INPUT -m state --state NEW -s <span
class="nt"><management</span> <span class="err">node</span> <span
class="err">IP</span><span class="nt">></span> -p tcp --dport 3306 -j ACCEPT
+ service iptables restart<span class="nt"></code></pre></span>
</pre></div>
+<ol>
+<li>
+<p>Create the VCL Database</p>
+<ul>
+<li>
+<p>Run the MySQL command-line client:</p>
+<p>:::BashLexer
+mysql</p>
+</li>
+<li>
+<p>Create a database:</p>
+<p>:::BashLexer
+CREATE DATABASE vcl;</p>
+</li>
+<li>
+<p>Create a user with SELECT, INSERT, UPDATE, DELETE, and CREATE TEMPORARY
TABLES privileges on the database you just created:</p>
+<p>:::BashLexer
+GRANT SELECT,INSERT,UPDATE,DELETE,CREATE TEMPORARY TABLES ON vcl.* TO
'<strong>vcluser</strong>'@'localhost' IDENTIFIED BY
'<strong>vcluserpassword</strong>';</p>
+</li>
+<li>
+<p>Exit the MySQL command-line client</p>
+<p>:::BashLexer
+exit</p>
+</li>
+<li>
+<p>Import the vcl.sql file into the database. The <strong>vcl.sql</strong>
file is included in the <strong>mysql</strong> directory within the Apache VCL
source code</p>
+<p>:::BashLexer
+mysql vcl < apache-VCL-2.3/mysql/vcl.sql</p>
+</li>
+</ul>
+</li>
+</ol>
+</li>
+</ol>
<hr />
<h1 id="web">Install and Configure the Web Components</h1>
<p><strong>Prerequisites</strong></p>
