Installing OPA-JAVA on 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

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
http://java.sun.com/webservices/    Download and/or follow the installation instructions


3. MySQL Version 4.1.x  Database Server
Download it at:
http://www.mysql.com  .Download and/or follow the installation instructions.


4. Web Browser.
Internet Explorer  Version 6.0 or higher;
or Netscape 7.0 or higher


5. OPA-JAVA Version 2.0 .
Download it at:  http://www.omoli.com/downloads/opa/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 DOS Command Prompt
      Change directory to the directory <MYSQL HOME>\bin
      Enter the command " mysql "  and hit Enter.
      Enter " create database opajava; "  and hit Enter
      Enter " use opajava; " 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.

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="/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 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 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


 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)