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.
c:\> cd perl\bin
ppm> install DBI
ppm> install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd
· 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:email@example.com:/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.
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 firstname.lastname@example.org.Download documentation How to install Oracle on windows XP How to install Oracle on Linux