Author: buildbot
Date: Thu Jan 31 14:28:00 2013
New Revision: 848765
Log:
Staging update by buildbot for vcl
Modified:
websites/staging/vcl/trunk/content/ (props changed)
websites/staging/vcl/trunk/content/confluence_export/apache-derby-database.html
Propchange: websites/staging/vcl/trunk/content/
------------------------------------------------------------------------------
--- cms:source-revision (original)
+++ cms:source-revision Thu Jan 31 14:28:00 2013
@@ -1 +1 @@
-1438729
+1440976
Modified:
websites/staging/vcl/trunk/content/confluence_export/apache-derby-database.html
==============================================================================
---
websites/staging/vcl/trunk/content/confluence_export/apache-derby-database.html
(original)
+++
websites/staging/vcl/trunk/content/confluence_export/apache-derby-database.html
Thu Jan 31 14:28:00 2013
@@ -78,111 +78,132 @@
<div id="content">
<h1 class="title">Apache Derby Database</h1>
- <p><a name="ApacheDerbyDatabase-UsingApacheDerbyDatabase"></a></p>
-<h1 id="using-apache-derby-database">Using Apache Derby Database</h1>
-<p>h4.{color:red} NOTE: The current code in the trunk does not support Derby
-(21 Aug 2009) {color}</p>
-<p><a name="ApacheDerbyDatabase-*Prerequisites*"></a></p>
-<h2 id="prerequisites"><em>Prerequisites</em></h2>
-<p>You should have installed:
-* JDK (it is maybe possible to work with jre only)</p>
-<p><a
name="ApacheDerbyDatabase-*DownloadingandSettingUptheDatabaseforVCL*"></a></p>
-<h2 id="downloading-and-setting-up-the-database-for-vcl"><em>Downloading and
Setting Up the Database for VCL</em></h2>
+ <h1 id="using-apache-derby-database">Using Apache Derby Database</h1>
+<p><big><font color="red"><strong>NOTE: The current code in the trunk does not
support Derby
+(21 Aug 2009)</strong></font></big></p>
+<h2 id="prerequisites">Prerequisites</h2>
+<p>You should have installed:</p>
+<ul>
+<li>JDK (it is maybe possible to work with jre only)</li>
+</ul>
+<h2 id="downloading-and-setting-up-the-database-for-vcl">Downloading and
Setting Up the Database for VCL</h2>
<ol>
<li>
<p>Download Apache Derby and install it.</p>
-<p>cd ~
-wget
-http://apache.g5searchmarketing.com/db/derby/db-derby-10.5.1.1/db-derby-10.5.1.1-bin.tar.gz
+<div class="codehilite"><pre>cd ~
+wget
http://apache.g5searchmarketing.com/db/derby/db-derby-10.5.1.1/db-derby-10.5.1.1-bin.tar.gz
tar -xzf db-derby-10.5.1.1-bin.tar.gz
mkdir /opt/Apache
mv db-derby-10.5.1.1-bin /opt/Apache/derby
-export DERBY_HOME="/opt/Apache/derby"
-export
-CLASSPATH="${DERBY_HOME}/lib/derby.jar:${DERBY_HOME}/lib/derbytools.jar:${CLASSPATH}"
-PATH="$DERBY_HOME/bin:$PATH"</p>
+export DERBY_HOME="/opt/Apache/derby"
+export CLASSPATH="<span class="cp">${</span><span
class="n">DERBY_HOME</span><span class="cp">}</span>/lib/derby.jar:<span
class="cp">${</span><span class="n">DERBY_HOME</span><span
class="cp">}</span>/lib/derbytools.jar:<span class="cp">${</span><span
class="n">CLASSPATH</span><span class="cp">}</span>"
+PATH="<span class="nv">$DERBY_HOME</span>/bin:<span
class="nv">$PATH</span>"
+</pre></div>
+
+
</li>
<li>
<p>Create a database in Apache Derby. The database has to be placed in the
path <em>/opt/</em>.
Replace <em>'vcluser'</em> and <em>'vcluserpassword'</em> with the user and
password
you want.</p>
-<p>cd /opt/
-ij
-connect
-'jdbc:derby:vcl1;create=true;user='vcluser';password='vcluserpassword';';
-exit;</p>
+<div class="codehilite"><pre><span class="n">cd</span> <span
class="sr">/opt/</span>
+<span class="n">ij</span>
+<span class="nb">connect</span> <span
class="s">'jdbc:derby:vcl1;create=true;user='</span><span
class="n">vcluser</span><span class="s">';password='</span><span
class="n">vcluserpassword</span><span class="s">';'</span><span
class="p">;</span>
+<span class="nb">exit</span><span class="p">;</span>
+</pre></div>
+
+
</li>
<li>
-<p>Download <em>'vcl.sql'</em> file and the <em>'derby-parser.pl'</em>.
- The <em>'derby-parser.pl'</em> can be found as an attachment to this page and
-<em>'vcl.sql'</em> fron repositories.
- Edit the file <em>'derby-parser.pl'</em>. the variables corresponding to the
+<p>Download <a
href="https://svn.apache.org/repos/asf/vcl/trunk/mysql/vcl.sql";>vcl.sql</a>
+and the
+<a href="/comm/commprojects/derby-parser.pl">derby-parser.pl</a>.
+ Edit the file <em>'derby-parser.pl'</em>. The variables corresponding to the
<em>'user'</em> and <em>'password'</em> should match your database.</p>
-<p>svn export https://svn.apache.org/repos/asf/vcl/trunk/mysql/vcl.sql
-chmod a+x derby-parser.pl
-./derby-parser.pl</p>
+<div class="codehilite"><pre><span class="n">svn</span> <span
class="n">export</span> <span class="n">https:</span><span
class="sr">//s</span><span class="n">vn</span><span class="o">.</span><span
class="n">apache</span><span class="o">.</span><span class="n">org</span><span
class="sr">/repos/</span><span class="n">asf</span><span
class="sr">/vcl/</span><span class="n">trunk</span><span
class="sr">/mysql/</span><span class="n">vcl</span><span
class="o">.</span><span class="n">sql</span>
+<span class="n">wget</span> <span class="n">http:</span><span
class="sr">//</span><span class="n">vcl</span><span class="o">.</span><span
class="n">apache</span><span class="o">.</span><span class="n">org</span><span
class="sr">/comm/comm</span><span class="n">projects</span><span
class="o">/</span><span class="n">derby</span><span class="o">-</span><span
class="n">parser</span><span class="o">.</span><span class="n">pl</span>
+<span class="nb">chmod</span> <span class="n">a</span><span
class="o">+</span><span class="n">x</span> <span class="n">derby</span><span
class="o">-</span><span class="n">parser</span><span class="o">.</span><span
class="n">pl</span>
+<span class="o">./</span><span class="n">derby</span><span
class="o">-</span><span class="n">parser</span><span class="o">.</span><span
class="n">pl</span>
+</pre></div>
+
+
</li>
<li>
<p>Import vcl-derby.sql file into database. It is a good idea to direct the
output to file and check if there were any errors.</p>
-<p>ij vcl-derby.sql > import.log</p>
+<div class="codehilite"><pre><span class="n">ij</span> <span
class="n">vcl</span><span class="o">-</span><span class="n">derby</span><span
class="o">.</span><span class="n">sql</span> <span class="o">></span> <span
class="nb">import</span><span class="o">.</span><span class="nb">log</span>
+</pre></div>
+
+
</li>
</ol>
-<p><a name="ApacheDerbyDatabase-Settingupthedbd_jdbcServer"></a></p>
<h2 id="setting-up-the-dbd_jdbc-server">Setting up the dbd_jdbc Server</h2>
<ol>
<li>
<p>Install log4j</p>
-<p>cd ~
-wget
-http://www.apache.org/dyn/closer.cgi/logging/log4j/1.2.15/apache-log4j-1.2.15.tar.gz
-tar -zxf apache-log4j-1.2.15.tar.gz
-mv apache-log4j-1.2.15 /opt/Apache/derby/lib/</p>
+<div class="codehilite"><pre><span class="n">cd</span> <span class="o">~</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">/dyn/c</span><span class="n">loser</span><span
class="o">.</span><span class="n">cgi</span><span
class="sr">/logging/</span><span class="n">log4j</span><span
class="sr">/1.2.15/</span><span class="n">apache</span><span
class="o">-</span><span class="n">log4j</span><span class="o">-</span><span
class="mf">1.2.15</span><span class="o">.</span><span class="n">tar</span><span
class="o">.</span><span class="n">gz</span>
+<span class="n">tar</span> <span class="o">-</span><span class="n">zxf</span>
<span class="n">apache</span><span class="o">-</span><span
class="n">log4j</span><span class="o">-</span><span
class="mf">1.2.15</span><span class="o">.</span><span class="n">tar</span><span
class="o">.</span><span class="n">gz</span>
+<span class="n">mv</span> <span class="n">apache</span><span
class="o">-</span><span class="n">log4j</span><span class="o">-</span><span
class="mf">1.2.15</span> <span class="sr">/opt/</span><span
class="n">Apache</span><span class="sr">/derby/</span><span
class="n">lib</span><span class="o">/</span>
+</pre></div>
+
+
</li>
<li>
<p>When installing the perl modules using the <em>'install_perl_libs.pl'</em>
(<em>/usr/local/vcl/bin/install_perl_libs.pl</em>) two extra modules need to
the
installed for Derby. Open the file <em>'install_perl_libs.pl'</em> and in the
list
of modules to download add the following two modules.</p>
-<p>http://search.cpan.org/CPAN/authors/id/G/GB/GBARR/Convert-BER-1.3101.tar.gz
-http://search.cpan.org/CPAN/authors/id/V/VI/VIZDOM/DBD-JDBC-0.71.tar.gz</p>
+<div class="codehilite"><pre><span class="n">http:</span><span
class="sr">//s</span><span class="n">earch</span><span class="o">.</span><span
class="n">cpan</span><span class="o">.</span><span class="n">org</span><span
class="sr">/CPAN/</span><span class="n">authors</span><span
class="sr">/id/</span><span class="n">G</span><span class="sr">/GB/</span><span
class="n">GBARR</span><span class="o">/</span><span
class="n">Convert</span><span class="o">-</span><span class="n">BER</span><span
class="o">-</span><span class="mf">1.3101</span><span class="o">.</span><span
class="n">tar</span><span class="o">.</span><span class="n">gz</span>
+<span class="n">http:</span><span class="sr">//s</span><span
class="n">earch</span><span class="o">.</span><span class="n">cpan</span><span
class="o">.</span><span class="n">org</span><span class="sr">/CPAN/</span><span
class="n">authors</span><span class="sr">/id/</span><span
class="n">V</span><span class="sr">/VI/</span><span
class="n">VIZDOM</span><span class="o">/</span><span class="n">DBD</span><span
class="o">-</span><span class="n">JDBC</span><span class="o">-</span><span
class="mf">0.71</span><span class="o">.</span><span class="n">tar</span><span
class="o">.</span><span class="n">gz</span>
+</pre></div>
+
+
</li>
<li>
<p>Run the scrips as normal</p>
-<p>perl /usr/local/vcl/bin/install_perl_libs.pl</p>
+<div class="codehilite"><pre><span class="n">perl</span> <span
class="sr">/usr/</span><span class="nb">local</span><span
class="sr">/vcl/</span><span class="n">bin</span><span class="o">/</span><span
class="n">install_perl_libs</span><span class="o">.</span><span
class="n">pl</span>
+</pre></div>
+
+
</li>
<li>
<p>Copy some file from the modules to Derby directory</p>
-<p>cp /tmp/perl-modules/DBD-JDBC-0.71/dbd_jdbc.jar /opt/Apache/derby/lib/
-cp /tmp/perl-modules/DBD-JDBC-0.71/log4j.properties
-/opt/Apache/derby/lib/apache-log4j-1.2.15</p>
+<div class="codehilite"><pre><span class="n">cp</span> <span
class="sr">/tmp/</span><span class="n">perl</span><span class="o">-</span><span
class="n">modules</span><span class="sr">/DBD-JDBC-0.71/</span><span
class="n">dbd_jdbc</span><span class="o">.</span><span class="n">jar</span>
<span class="sr">/opt/</span><span class="n">Apache</span><span
class="sr">/derby/</span><span class="n">lib</span><span class="o">/</span>
+<span class="n">cp</span> <span class="sr">/tmp/</span><span
class="n">perl</span><span class="o">-</span><span
class="n">modules</span><span class="sr">/DBD-JDBC-0.71/</span><span
class="n">log4j</span><span class="o">.</span><span class="n">properties</span>
<span class="sr">/opt/</span><span class="n">Apache</span><span
class="sr">/derby/</span><span class="n">lib</span><span
class="o">/</span><span class="n">apache</span><span class="o">-</span><span
class="n">log4j</span><span class="o">-</span><span class="mf">1.2.15</span>
+</pre></div>
+
+
</li>
<li>
<p>Create a script file which will launch the dbd_jdbc Server. Save it under
any name and directory (e.g. /opt/server.sh), only remember that this
scrips needs to be executed every time you start up the server. The file
should contain</p>
-<h1 id="usrbinbash">!/usr/bin/bash</h1>
-<p>java -Djdbc.drivers=org.apache.derby.EmbeddedDriver -Ddbd.port=12345
--classpath
-/opt/Apache/derby/lib/derby.jar:/opt/Apache/derby/lib/dbd_jdbc.jar:/opt/Apache/derby/lib/apache-log4j-1.2.15/log4j-1.2.15.jar:/opt/Apache/derby/lib/apache-log4j-1.2.15/
- com.vizdom.dbd.jdbc.Server &</p>
-</li>
-</ol>
+<div class="codehilite"><pre><span class="c">#!/usr/bin/bash</span>
+java -Djdbc.drivers<span class="o">=</span>org.apache.derby.EmbeddedDriver
-Ddbd.port<span class="o">=</span>12345 -classpath
/opt/Apache/derby/lib/derby.jar:/opt/Apache/derby/lib/dbd_jdbc.jar:/opt/Apache/derby/lib/apache-log4j-1.2.15/log4j-1.2.15.jar:/opt/Apache/derby/lib/apache-log4j-1.2.15/
com.vizdom.dbd.jdbc.Server &
+</pre></div>
+
+
<p>Note1: if some of your paths are different you need make the changes in
-this scrips file as well
+this scrips file as well<br>
Note2: currently port 12345 is used for connecting to Derby, this is hard
-coded. Can be changed on a later stage.
-1. Make the script executable</p>
+coded. Can be changed on a later stage.</p>
+</li>
+<li>
+<p>Make the script executable</p>
<div class="codehilite"><pre><span class="nb">chmod</span> <span
class="n">a</span><span class="o">+</span><span class="n">x</span> <span
class="sr">/opt/s</span><span class="n">erver</span>
</pre></div>
-<ol>
+</li>
<li>
<p>Start the Server</p>
-<p>/opt/server</p>
+<div class="codehilite"><pre><span class="sr">/opt/s</span><span
class="n">erver</span>
+</pre></div>
+
+
</li>
</ol>
</div>
