Installing OPA-JAVA on LINUX



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
* LINUX 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.
http://www.mysql.com/doc/en/Linux-RPM.html

5. Web Browser
Mozilla 1.3
Any browser that works on LINUX, eg Firefox

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 Enter
 
a. 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 User

          Start 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)