1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
<HTML><HEAD>
<TITLE>dbengine installation</TITLE>
</HEAD>
<BODY>
<A HREF="index.html"><IMG SRC="images/prev.gif" ALT="PREV"></A>
<A HREF="index.html"><IMG SRC="images/toc.gif" ALT="TOC"></A>
<A HREF="configuration.html"><IMG SRC="images/next.gif" ALT="NEXT"></A>
<P>
<H2>Installation</H2>
There are only a few steps neccessary to install <B>dbengine</B> on your system, once the basics like PostgreSQL, MySQL, or Oracle, a HTTP server and Perl are available. <I>However - you'll need a browser that's able to handle frames.</I><P>
I'll describe the neccessary steps and provide links to the appropriate sources here:<P>
<UL>
<H4>Software packages</H4>
<LI>Install PostgreSQL, MySQL, or Oracle on your system. You can download the latest PostgreSQL relase from <A HREF="ftp://ftp.postgreSQL.org/pub/">ftp://ftp.postgreSQL.org/pub/</A>. You can download the latest MySQL release from <A HREF="http://www.mysql.com/downloads/">http://www.mysql.com/downloads/</A>. After unpacking the archive follow the provided instructions and install it on your machine.
<LI>Install Perl 5.005 or later which can be downloaded from <A HREF="http://www.perl.com/CPAN/src/latest.tar.gz">http://www.perl.com/CPAN/src/latest.tar.gz</A>.
<LI> Install a HTTP server unless you already have one in use. I'm currently working with the Apache server which can be found at <A HREF="http://www.apache.org">http://www.apache.org</A>, but of course everything should work with any CGI capable server. <BR>
<UL>
<LI> Make sure it works ! Try to create a few Web pages and see that
you can retrieve them with your Web client. Also make sure that
your HTTP server is configured properly to run CGI scripts.
Normally you have to tell the server that a special directory
contains scripts, so the files there will be executed rather than
retrieved as text files !
</UL>
<H4>Perl extensions</H4>
<LI>Install the DBI generical database interface package for perl (version 1.15 or later). The source archive is available from any CPAN mirror like <A HREF="ftp://ftp.rz.ruhr-uni-bochum.de/pub/CPAN/modules/by-category/07_Database_Interfaces/DBI/">ftp://ftp.rz.ruhr-uni-bochum.de/pub/CPAN/modules/by-category/07_Database_Interfaces/DBI/</A>. Use <a href="http://search.cpan.org/">http://search.cpan.org/</a> to access a mirror close to you. You can also use the CPAN module to simplify the process. See the <a href="http://theoryx5.uwinnipeg.ca/CPAN/perl/CPAN.html#Interactive_Mode">CPAN module documentation</a> for more details. If you are installing onto a multi-host environment (such as an ISP), you'll need to take a few extra steps to install Perl Modules. See <a href="http://perl.about.com/library/nosearch/P030500.htm?once=true&">How to Install Modules</a> for details.<BR>
Installation of this is like for any perl module as follows:
<UL>
<LI>tar xfz <Filename>
<LI>cd <new directory>
<LI>perl Makefile.PL
<LI>make
<LI>make test
<LI>make install
</UL>
<LI>For access to PostgreSQL install the DBD database interface package DBD-Pg (version 0.90 or later). The source archive is available from any CPAN mirror like <A HREF="ftp://ftp.rz.ruhr-uni-bochum.de/pub/CPAN/modules/by-category/07_Database_Interfaces/DBD/">ftp://ftp.rz.ruhr-uni-bochum.de/pub/CPAN/modules/by-category/07_Database_Interfaces/DBD/</A>. Installation of this is similar to the above.
<LI>For access to Oracle install the DBD database interface package DBD-Oracle (version 0.59 or later). The source archive is available from any CPAN mirror like <A HREF="ftp://ftp.rz.ruhr-uni-bochum.de/pub/CPAN/modules/by-category/07_Database_Interfaces/DBD/">ftp://ftp.rz.ruhr-uni-bochum.de/pub/CPAN/modules/by-category/07_Database_Interfaces/DBD/</A>. Installation of this is similar to the above.
<LI>For access to MySQL install the DBD database interface package Msql-Mysql-Modules (version 1.2216 or later). The source archive is available from any CPAN mirror like <A HREF="ftp://ftp.rz.ruhr-uni-bochum.de/pub/CPAN/modules/by-category/07_Database_Interfaces/Mysql/">ftp://ftp.rz.ruhr-uni-bochum.de/pub/CPAN/modules/by-category/07_Database_Interfaces/Mysql/</A>. Installation of this is similar to the above.
<LI>Make sure that these perl extensions and your Perl system work. All "make test" calls should have been proceeded successfully.
<LI>For logging to work you have to make sure that h2ph has been run before starting dbengine. Otherwise you'll get an error...<BR> On my linux system I do this using the following commands:
<UL>
<LI>cd /usr/include; h2ph -r -l .
<LI>cd /usr/lib/gcc-lib/i486-linux/2.7.2.3/include; h2ph -r -l .
</UL>
<H4>dbengine</H4>
<LI>To install dbengine go ahead and download <B>dbengine</B> from our ftp server <A HREF="ftp://ftp.cis-computer.com/pub/dbengine-latest.tar.gz">ftp://ftp.cis-computer.com/pub/dbengine-latest.tar.gz</A>.
<UL>
<LI><CODE>tar xvfz dbengine-latest.tar.gz</CODE> as root on your local system.
<LI><CODE>cd dbengine-<Version></CODE>
<LI>Have your system information ready and type <BR><CODE>perl Makefile.PL</CODE>
<LI><CODE>make</CODE>
<LI>If you want the test database to be installed type <BR><CODE>make test</CODE>
<LI><CODE>make install</CODE>
</UL>
Now you're done. The installation is complete and you'll be able to access your databases from your local host with <A HREF="http://localhost/cgi-bin/dbengine/dbengine.cgi">http://localhost/cgi-bin/dbengine/dbengine.cgi</A>.
<LI>Additional information about all those informations asked for during the installation process is provided on the <A HREF="configuration.html">following page</A>.
</UL>
<P>
<A HREF="index.html"><IMG SRC="images/prev.gif" ALT="PREV"></A>
<A HREF="index.html"><IMG SRC="images/toc.gif" ALT="TOC"></A>
<A HREF="configuration.html"><IMG SRC="images/next.gif" ALT="NEXT"></A>
</BODY>
</HTML>
|
