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 leased line and broadband connection

Software Prerequisites


1. Java (tm) 2 SDK, Standard Edition - version 1.4.1 or higher.
Download it at:      http://java.sun.com/j2se/1.4.1/download.html  
Download and/or follow the installation instructions

2. Java Web Services Developer Pack 1.2 with Tomcat standalone server
Download it at:      http://java.sun.com/webservices/downloads.html   
Download and/or follow the installation instructions
http://java.sun.com/webservices/downloads/install-unix.html

3. MySQL Version 4.1.x  Database Server
Download it at:     http://www.mysql.com/downloads/ 
Download and/or follow the installation instructions.
http://www.mysql.com/doc/en/Linux-RPM.html

4. Web Browser
Mozilla 1.3
Any browser that works on LINUX


5. OPA-JAVA Version 2.0 .
Download it at:        http://www.omoli.com/downloads/opajava/opa-java20.zip.
It includes JDBC driver for MySQL


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 archive contents as follows:

======================================================
mysql_connector  Folder.
======================================================

This contains JDBC drivers necessary for MYSQL Tables

1. Copy " mysql-connector-java-3.0.8-stable-bin.jar " to
    <JWSDP HOME>/shared/lib/

2 Copy " com " subdirectory and all of its contents (including sub-directories) to  <JWSDP HOME>/common/classes/
      
* <JWSDP HOME> is the Java Web Services Developer Pack home folder
            

=========================================
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 LINUX Shell to accept commands
      Shell> cd $MYSQL_HOME   <Enter>
      Shell> mysql -u root - p  <Enter>
      Enter password:                   (Enter your 'root' password and hit Enter)
      mysql> create database opajava;   <Enter>
      mysql> use opajava;  <Enter>
     
 
a. Run the create_db.sql script

mysql> source /folder/create_db.sql;  <Enter>    
where /folder/ is the path to the location of the " database " folder  
The database tables are created.

b.   In similar fashion run all the scripts in /database/data_inserts folder.
These scripts insert initial data in the database like languages, phrases, etc.
     
============================================
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.

=======================================
opav.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=" /opajava/" docbase="opajava" if your OPA application directory root is "opajava".

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 LINUX root password "abcd", 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>abcd</value>
      </parameter>

Save opav.xml.


==========================================
Modifications For Lists Management
==========================================

Look into each of these modules in the /admin/communication/ folder:

dsp_comm_email_archive.jsp
dsp_comm_email_members.jsp
dsp_comm_email_message.jsp

In each, look for the section that has this code:

<sql:setDataSource
var="lyrics"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/opadev"
user="root"
password=""
/>

Make changes as appropriate to be able to locate the database
that has the LISTS, MEMBERS, and MESSAGES tables, even if these tables
are already part of the OPA database.

 

===========================================================================

Restart your computer.

Start Tomcat Servlet Container and Web Server

 At the LINUX Shell

 Shell> cd $CATALINA_HOME/bin  <enter>
 Shell> catalina.sh  start <enter>

This starts the services needed to serve the web pages


 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)