How To:
This installation requires
that the computer have a web server (IAS), Perl and Oracle installed. The first
three sections explain how to install and configure these items
before PARPs-DB is installed. If these
items are installed already, there will be some configuration to do, so make
sure you read all sections before installing PARPs-DB.
There are a couple of other things that are
done differently for PARPs-DB and will be noted as we go along.
I.
Windows
- Download and install ActiveState Perl.
- It is recommended to install at c:\perl if
possible as the perl scripts expect to find the perl executable there. If installed somewhere else,
the first line of each perl script will need to
be changed to point to the correct location of perl.
- Install the dbi and dbd perl modules needed for
database communication. See here for
pointers or enter the commands below at the command prompt.
c:\> cd perl\bin
c:\perl\bin> ppm
ppm>
install DBI
ppm>
install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd
II.
Unix/Linux
- In general, Perl is
installed in the most Linux / Unix distribution.
· Install the dbi and dbd perl
modules needed for database communication.
Installation of Oracle database is not easy. We suggest installing this database
with database administrator.
We have prepared guidelines to install Oracle (see How to install Oracle
for windows or Unix systems).
If you want more information, we suggest consulting Oracle documentation.
Once Perl and Oracle
and IAS have been installed and configured, the database can be created.
PARPS scripts are available
on SourceForge.net CVS repository. This can be checked out through anonymous (pserver) CVS with the following instruction set.
The module you wish to check
out must be specified as the modulename. When
prompted for a password for anonymous, simply press the Enter key.
I.
We suggest downloading tortoise cvs
software at the following address for Windows operating systems: (http://www.tortoisecvs.org/).
a. Install tortoise
software
b.
Create
a folder on your local disk to download files (eg. PARPS_DB)
c.
Click
right on PARPS_DB folder
d.
Select
CVS checkout
e.
A
new windows appears and fill like figure 2
f.
Press
ok
All CVS contents are downloaded in PARPD_DB folder.
II.
With
Unix or Linux operating systems, use this following command.
cvs
-d:pserver:anonymous@parpdb.cvs.sourceforge.net:/cvsroot/parpdb login
1.
So,
we have downloaded all scripts for PARPS-DB systems. All scripts are open
source and if you need help, contact me.
2. Open a command
prompt and navigate to 'scripts_DB' folder in PARPS_DB_scripts directory.
3. Open a SQL
prompt
4. Open create_PARPsDB.sql
file.
5. Copy each tables
in SQL prompt (e.g.
create table project (
project_id
INTEGER PRIMARY KEY,
nom_project varchar2(10)
);
6.
You
should see :
Query OK, 0
rows affected (0.48 sec)
7.
An
empty PARPs_DB has been created.
8.
The next step is
to install PL scripts. Each scripts must be loaded on sql prompt.
Query OK
9.
Open
the script called: parp_admin.txt and copy each lines on sql
prompt to grand privileges.
PARPs-Db is now ready to use. Point your browser to http://servername/index.html.
You should see PARPs-DB start page.
If you get the error:
Check IAS configuration.
This set of instructions is
not a rigid formula: you may have to adjust the way it is installed based on
existing web servers on your computer,
or just to make it more convenient for
you. If you have any problems or questions email us at
arnaud.droit@crchul.ulaval.ca.