Installation information for Windows
Hardware, Operating System and Networking Requirements¶
- Pentium III PC with 733 MHz CPU, or higher
- 512 MB RAM, or higher
- 10 GB free hard disk space
- Window 2000/2003 Server Operating System
- Access to Internet with lease line and broadband connection
Software Prerequisites
Software Components
1. Java (tm) 2 SDK, Standard Edition - version 1.4.2 or higher.
Download it at: http://java.sun.com/j2se/1.4.2/download.html
Download and/or follow the installation instructions
2. TOMCAT 5 or higher
Download it from: http://jakarta.apache.org/tomcat/index.html
3. Java Web Services Developer Pack 1.5 or higher
Download it from: http://java.sun.com/webservices/
Download and/or follow the installation instructions. Use TOMCAT as the container.
4.MySQL Version 4.1.x Database Server
Download it at:
http://www.mysql.com .Download and/or follow the installation instructions.
Also download the JDBC driver(s) for MySQL - mysql-connector-java-3.0.x-stable-bin.jar -
where 'x' is 8,9,10,11, etc. You may have to try one or more of them to find the one that
works for your installation. Download all and delete those not needed later.
5. Web Browser
Internet Explorer Version 6.0 or higher;
or Netscape 7.0 or higher; or FireFox 1.0 or higher
6. Download OPA
There are usually two zip files: the main application file and the help file. Download both
Important: Install required software in the order shown above, except for Web Browser
which probably was installed with the Operating System.
=======================================================================================
OPA-JAVA Installation
=======================================================================================
1. Unzip the zip file to some temporary folder.
2.Copy the MySQL driver ("mysql-connector-java-3.0.x-stable-bin.jar") downloaded above
to <JWSDP HOME>\common\lib\
- <JWSDP HOME> is the Java Web Services Developer Pack home folder
If there is difficulty connecting to the OPA database, it may be related to the
version of the driver. Download and try versions until you get the one that works
for your installation.
3. Copy the archive contents as follows:
=======================================================================================
database\ Folder
=======================================================================================
This folder contains the SQL scripts for creating tables and populating those
needed for initial startup. To run these scripts
1. Create the OPA-JAVA database
Start DOS Command Prompt
Change directory to the directory <MYSQL HOME>\bin
Enter the command "mysql -u root -p" and hit Enter.
Hit Enter again without entering a password.
Enter "create database opa;" and hit Enter
Enter "use opa;" and hit Entera. Run the create_db.sql script
Enter "source /folder/create_db.sql;" where /folder/ is the path to
the location of the SQL scripts. Hit Enter. The database tables are created.
NOTE: If your database is not named 'opa', edit the script and substitute the proper name.
b. In similar fashion run all the scripts in \database\data_inserts folder.
These scripts insert initial data in the database like languages, phrases, and default values.
=============================================================================================
opa\ Folder
==============================================================================================
This folder contains the OPA application files.
Copy "opa" subdirectory and paste as a subdirectory of <JWSDP HOME>\webapps\
The OPA directory now looks like
\opa\
\opa\admin\
\opa\archive\
and so on.
=============================================================================================
Help Files
==============================================================================================
Unzip the help zip file to some temporary folder.
Copy its content to
\opa\help\html\
where \opa\ is your application folder.
=============================================================================================
opa.xml file.
=============================================================================================
This is the configuration file for OPA Application
Copy this file to <JWSDP HOME>\webapps\ folder.
Edit the file using a text editor.
Use the "path" and "docBase " attributes to define the path to OPA application.
Example: path="/opa" docbase="opa" if your OPA application directory root is "opa".
Edit the database connections attributes.
For example if you are hosting you application on "localhost" and your database name is
"opajava" and your user id is "root" and you have no password, this section will look like:
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/opajava</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>Save opa.xml.
If TOMCAT does not appear to recognize your application, edit /conf/server.xml.
Copy the contents of opa.xml into the section between the <Logger> tag and the </Host> tag.
===========================================================================================
1. Restart your computer.
2. Start Tomcat Servlet Container and Web Server
At the DOS prompt (Assume c:>C:> cd <JWSDP HOME>\bin <enter>
C:><JWSDP HOME>\bin >catalina start <enter>
This starts the services needed to serve the web pages
3. Start OPA as Administrator/Reviewer
Start your Web Browser (Internet Explorer, Netscape , ...)Enter on the address line:http://localhost:8080/opa/admin (if using localhost)
http://nnn.nnn.nnn.nnn:8080/opa/admin (if using IP Address nnn.nnn.nnn.nnn)
http://abc.com:8080/opa/admin (if using Web Address abc.com)Start OPA as Public UserStart your Web Browser (Internet Exploree, Netscape , ...)Enter on the address line:http://localhost:8080/opa/(if using localhost)
http://nnn.nnn.nnn.nnn:8080/opa/(if using IP Address nnn.nnn.nnn.nnn)
http://abc.com:8080/opa/(if using Web Address abc.com)