[PlanetJ Corporation

[support@planetJavaInc.com]

[www.PlanetJavaInc.com]

 


WEB OBJECT WIZARD: Installation Instructions 6.x - 7.0

 

*NOTE: Screen shots provided as examples and may change with release versions.

Understanding WOW Installation Components

WOW Prerequisites

WOW Prerequisites (i5 only)

Required Files for Apache Tomcat

Component Description

WOW Metadata Installation:

Required Files for MySQL

Component Description

Required Files for AS/400

Component Description

Installing WOW

Upgrading WOW

Starting WOW

Starting/Stopping MySQL

Starting/Stopping Apache Tomcat

Optimizing Apache Tomcat

Accessing the WOW Builder

PlanetJ Confidentiality and Proprietary Information

Understanding WOW Installation Components

Installing WOW takes 30 - 60 minutes.  

  1. WOW Metadata
    a. This component contains stored application data such as field descriptors, JDBC connections, applications, and operations.
    b. “WOW Metadata” is simply a set of database tables.  WOW Metadata can be stored in MYSQL or DB2/400.  

  1. WOW Application Code
    a. For WOW trial and Community Editions, this guide only covers running WOW on the Apache Tomcat application server on a Micorosoft Windows PC.  Other application servers such as WebSphere can be configured to work with WOW but require additional setup (not covered in this guide).  WOW can run on ANY Java platform and any system; including Windows,  IBM i/ iSeries, Linux, Unix, etc...  We recommend using a Windows PC for the initial installation, WOW can be moved to other systems when appropriate.

WOW Prerequisites

  1. A Windows PC (NT, 2000, XP, 2003, Vista, 2008, Windows 7).
  2. At least 256 MB of RAM.
  3. A 400 Mhz or faster processor.
  4. WOW components require ~150MB of disk storage.

*NOTE:  A Windows server with 1GB of RAM and 1.5 or larger Ghz processor is recommended.

WOW Prerequisites (i5 only)

  1. We recommend you create a new user profile PHO20717  (Use the letter O after PH not the zero digit)  using CL command CRTUSRPRF with a password of "wowISfast".  WOW metadata is owned by this userprofile.  The default connection also includes these credentials by default.  You can change the password after initial WOW installation.  Also, make sure the profile has the CCSID set to 037.  For example:

CRTUSRPRF USRPRF(PHO20717) PASSWORD(wowISfast)  INLMNU(*SIGNOFF) CCSID(037)

TEXT('Profile used to run WOW') PWDEXPITV(*NOMAX) 

Required Files for Apache Tomcat

There are three main components that must be installed to run WOW on the PC using Apache Tomcat

Component Description

  1. Java JDK (we recommend Java6): This file contains all of the necessary files to run Java applications on your PC and is required by Apache Tomcat.
  2. Apache Tomcat (we recommend Tomcat6): This is the installation file for Apache Tomcat Web Application Server.  We recommend using the Windows Service Installer version of the Tomcat install for ease of use.
  3. WOW Resource Files: The wow70 directory contains all the necessary files for WOW to run correctly.

WOW Metadata Installation:

WOW Metadata stores all configuration information such as connections, applications, and operations.  Metadata is stored in standard database tables.  WOW supports stored Metadata in either MYSQL or DB2/400/IBM i  (only 1 is needed).  For either option, you may connect to any database on your network.  We recommend using MYSQL unless your organization is an IBM AS/400 user.  

Required Files for MySQL

There are two main components (and an optional component) that must be installed to run WOW on a PC using MySQL to store WOW Metadata.

Component Description

  1. MySQL Server (we recommend MySQL 5.5 or higher):  This is the installation file for MySQL.
    *NOTE: DON’T get the essentials version, get the full version of MySQL.
  2. MySQL Data Folder: The installation package contains a folder called “Data” that contains the MySQL tables for the WOW Metadata
  3. (OPTIONAL) MySQL Workbench or MYSQL GUI tools(most recent version): MySQL Workbench contains many tools that will be beneficial while working with the MySQL server and SQL.  It contains a Query Browser, EEP Mapping and also contains a Server Administration tool.

Required Files for AS/400

There are two AS/400  libraries that must be restored to your AS400 if you wish to host your Metadata on your AS/400.

Component Description

  1. AS400 SaveFiles:  The installation package contains a folder called “AS400 SaveFiles”.  This folder contains the PJUSER70.savf and the PJSYS70.savf.  These SaveFiles need to be FTP’d and restored to the AS/400.

Installing WOW

NOTE:  If you have already installed WOW and need instructions on updating, please see Upgrading WOW.

  1. If you do not have the recommended version of the Java JDK already installed, please download it from Oracle’s website HERE and install it.  You can install it in the default directory or a different directory if you wish.  Just install the program with any other default values.  DO NOT restart your system if prompted to do so.
  2. If you do not have the recommended version of Apache Tomcat already installed, please download and install it.  You can download Apache Tomcat 6 from the official Apache Software Foundation website HERE.
    We recommend the 32-bit/64-bit Windows Service Installer for ease of use.  If you already have Apache Tomcat 6 installed, we recommend backing up all critical files located in the Tomcat X.X (with X.X being the version) directory.  
    THIS IS VERY IMPORTANT!  In the WOW installation procedure, we will be writing files to: ~\Apache Software Foundation\Tomcat X.X\webapps\  If you already have Tomcat installed, make sure it is not running.
    *NOTE: If you currently have a previous version of Apache Tomcat installed, we recommend you back up all critical files associated with this version before installing WOW.
  3. If installing Apache Tomcat, continue reading.  If not, please skip to Step 8.
    The initial Apache Tomcat setup wizard screen will appear once you double-click on the installer.  Click the [Next] button to proceed.  A screen will then appear, asking you to review the license agreement.  After reviewing the license agreement, click the [I Agree] button.  This will bring you to a form similar to the image below.  Expand the ‘Tomcat’ menu if it isn’t already, and be sure the ‘Service’ option has been checked, then click the [Next >] button.
  4. After clicking the [Next >] button, the installer will ask where to actually install the Apache Tomcat server.  The default value is sufficient, but you may change it to your root drive as well (see examples below).  Click the [Install] button to begin the actual installation of Apache Tomcat.
    *NOTE: It is best to install Apache Tomcat in its default directory (defaults to C:\Program Files\Apache Software Foundation\Tomcat X.X\), though installing Apache Tomcat to a root drive (such as D:\Apache Software Foundation\Tomcat X.X\) is also acceptable.
  5. After clicking the [Next >] button, the installer will prompt you for a password to access Tomcat (as shown below).  Enter a password and record it for your future use.  Keep the rest of the default values the same.  If you have another program using port 8080, change the port number and continue.  DO NOT restart your system if you are prompted to do so.  The port specified will affect the URL used to access WOW through Tomcat.  For example, leaving the port default value as 8080 would mean that you would access WOW using a URL similar to:  http://localhost:8080/wow70/wow
    This port can be changed at any time by modifying the Tomcat config file found at ~/Apache Software Foundation/Tomcat X.X/conf/server.xml
    *NOTE: Remember the port number because you will need it later (when configuring WOW).  We recommend using any port between 8080 and 8090 OR port 80 if you know it isn’t being used.  Often Windows servers will come with Microsoft IIS running on port 80, which will cause a conflict if Tomcat is set up to use the same port (which is why we recommend port 8080).  To check, simply open a browser and enter this URL:  http://localhost/  (this will check port 80).
  6. After clicking the [Next >] button, the installer will prompt for the location of the JVM.  It is important that you specify the location of a JDK rather than a JRE.  A JRE does not contain the files needed to compile the JSPs that WOW uses (specifically javac).  Depending on which JDK you have installed, the location specified here may vary.
  7. After clicking the [Next >] button, the installer will ask you if you want to “Run Apache Tomcat”.  YOU MUST UNCHECK THIS OPTION for the WOW installation to complete properly!  If Tomcat is started automatically in this step, you MUST STOP AND RESTART Tomcat before WOW will be operational.  It is up to you whether or not you show the readme file.  Click the [Finish] button to complete the Tomcat install.
  8. If you want to use AS/400 for metadata, skip to step 11.  If you do not already have MySQL installed, please install it.  If you already have MySQL installed, be sure you back up ALL of your data.  THIS IS VERY IMPORTANT!  During the final WOW installation steps, we will be placing WOW metadata in the MySQL “Data” folder.  You may also want to back up the my.ini file located in C:\Windows\ or C:\WINNT\.  The current my.ini file can be renamed myOLD.ini and also make sure the MySQL service is stopped.
    You can download the most recent version of MySQL at the MySQL website
    HERE.
  9. If you need to install MySQL, please read on.  If you already have MySQL installed, please continue on to the next step.  You will be presented with the following screens when installing MySQL.  Select an installation type (we recommend Typical for beginning users) on the second installer screen and hit the [Next >] button.



    Make sure you are installing MySQL to a root drive (D:\mysql\) OR in the program files directory (C:\Program Files\mysql\), then click the [Install] button.
    After the server itself is installed on your system, you will then need to configure the MySQL instance on your computer.  Step through the installer (default settings will work just fine) but be sure to note the system path to your “Data” folder (for MyISAM tables, which all the WOW Metadata tables are).  When prompted to enter a password for the ‘root’ user, be sure to enter “wowISfast” (without the quotation marks).  This will come into play later when we go to start up WOW.
    *NOTE: If you cannot find, or do not remember the path to your “Data” folder, you can find it by going to your installation directory of MySQL and editing the my.ini file.  Inside this file there is a section called SERVER SECTION.  In this section, there is a property called:

                  #Path to the database root
    The property below it should look something like this in Windows 7/Windows Server 2008/Vista:

datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"

Windows XP:

datadir=”C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.5/Data/”

*NOTE:  The MYSQL data folder may be HIDDEN.  The C:\ProgramData directory is hidden by default. You need to change your folder options to see the directory and contents.   From Windows explorer -> Folder->View and enable hidden files and folders to be seen.

This is where your data directory can be found and where you need to copy the “Data” folder in the step below

  1. Once installation is finished (or if you will be using an existing copy of MySQL server), we will need to place our WOW Metadata into the server’s “Data” folder.  The installation package for WOW Community Edition includes a “Data” folder that houses all this Metadata.  Browse to the “Data” folder on your hard drive and copy the contents of the “Data” folder from the installation package into the servers “Data” folder.
    *NOTE: Please back up your “Data” folder before merging our WOW Metadata into it.
  2. (OPTIONAL - AS400/iSeries/IBM i ONLY) If an iSeries is being used to house WOW metadata, the .savf will need to be FTP’d to the iSeries and restored to the database.
    To FTP the file to the iSeries:
  1. Create 2 save files on the iSeries (this is where the files will be FTP’d to):
  1. CRTSAVF FILE(QGPL/PJSYS70)
  2. CRTSAVF FILE(QGPL/PJUSER70)
  1. On your PC (where the WOW save files are available), bring up a Command Prompt window.
  2. From Command Prompt, change directories (cd) to the folder containing the 2 save files.
  3. FTP to the iSeries:
  1. ftp <iSeries ipaddress>
  2. <iSeries User Id>
  3. <iSeries Password>
  4. Set to binary mode: bin
  5. Send both WOW save files to the iSeries:
  1. put pjsys70.savf /QSYS.LIB/QGPL.LIB/PJSYS70.FILE
  2. put pjuser70.savf /QSYS.LIB/QGPL.LIB/PJUSER70.FILE
  1. End FTP session: quit
  2. Close Command Prompt window.

        To Restore the libraires on the iSeries:

  1. RSTLIB SAVLIB(PJSYS70) DEV(*SAVF) SAVF(QGPL/PJSYS70) MBROPT(*ALL) ALWOBJDIF(*ALL)
  2. RSTLIB SAVLIB(PJUSER70) DEV(*SAVF) SAVF(QGPL/PJUSER70) MBROPT(*ALL) ALWOBJDIF(*ALL)
  1. Once we have our WOW Metadata installed and Apache Tomcat installed, we can then install the WOW Webapp.  There is a folder in the installation package called “wow70”.  This is the webapp that goes on your Apache Tomcat server.  To install, copy the “wow70” folder and browse to your Apache Tomcat’s “webapps” directory (if installed to the default directory, it should be something like: C:\Program Files\Apache Software Foundation\Tomcat X.X\webapps\).  Paste the “wow70” folder into the “webapps” folder, so your file structure looks similar to this:
    C:\Program Files\Apache Software Foundation\Tomcat X.X\webapps\wow70
  2. (OPTIONAL - AS400/iSeries ONLY) If the WOW Metadata is housed on an iSeries, the web.xml file will also need to be modified to point to the AS/400 in which the Metadata was restored to.  The web.xml file can be found in the WEB-INF folder inside the wow70 webapp.  There is already an AS400-web.xml file located inside the folder but it will need to be modified.  First, the file needs to be renamed from AS400-web.xml to “web.xml” (without the quotes, you may need to remove the existing web.xml file before you can rename).  Next, edit the file with a notepad program.  Inside the web.xml file you will find this:
    <!-- Below are the initial parameters for the WOW metadata system.  Please note that the

         System URL must begin with a prefix such as jdbc:as400: or jdbc:db2: followed by the IP  address or an alias if you have the alias mapping set up in your hosts file.-->

          <init-param id="WOW_Metadata_System_URL">

            <param-name>PJ_SYSTEM_URL</param-name>

            <param-value>jdbc:as400://YOUR_SYSTEM_HERE/pjsys70</param-value>

            <description>Replace YOUR_SYSTEM_HERE with the IP or alias of the WOW metadata system</description>

         </init-param>

         <!-- We default the User ID to WOW-->

         <init-param id="WOW_Metadata_System_User_ID">

            <param-name>PJ_USER_ID</param-name>

            <param-value>YOUR_AS400_USER_HERE</param-value>

        <description>Replace YOUR_AS400_USER_HERE with a valid profile on your AS400 system</description>

         </init-param>

         <init-param id="WOW_Metadata_System_Password">

            <param-name>PJ_PASSWORD</param-name>

            <param-value>YOUR_AS400_PASS_HERE</param-value>

        <description>Replace YOUR_AS400_PASS_HERE with the password for the valid profile you used above</description>

         </init-param>

Replace the YOUR_SYSTEM_HERE, YOUR_AS400_USER_HERE and YOUR_AS400_PASS_HERE parameter values with the appropriate values for your system and save it.

NOTE:  It is recommended that the IBM i profile used have it’s CCSID set to either 037.

Upgrading WOW

NOTE:  Skip this step if you are NOT upgrading to a newer version of WOW.

From time to time PlanetJ will release Upgrades for WOW.  The upgrade will be downloaded in the same manner as WOW CE.  The newly downladed CE package should contain numerous folders, including a Tomcat webapp (really just a folder)  named “wow70”.

Inside this folder (wow70) there are numerous other folders, including “dataengine” and “wow” (the two we will need) but also including a folder named WEB-INF.  First, copy the “dataengine” and “wow” folders and put them in a safe and easily accessible location.  Then, drill into the WEB-INF folder and again into the lib folder inside this WEB-INF folder.  There should be numerous .jar files inside the “lib” folder.  You will need to find the one labelled wow-7.X.XX.jar (X.XX being the version and fixpack level) and copy this as well.

Once you have all the files copied from the “wow70” webapp (you need the “dataengine” and “wow” folder and all their contents, as well as the wow-7.X.XX.jar), you’ll need to MERGE them into your existing WOW webapp, overwriting any files that did exist with the new files.

NOTE:  It is recommended that you back up your current webapp and WOW User Libraries before you try to Upgrade, in case of issues.

To do so, browse to your current Tomcat/WOW installation directory (defaults to C:\Program Files\Apache Software Foundation\Tomcat X.X\webapps\wow70).  Take the “dataengine” and “wow” folders you had made copies of and MERGE them into your WOW webapp (wow70), overwriting any files that did exist with the new files.  Also, navigate to the WEB-INF\lib folder and paste the wow-7.X.XX.jar into this folder.  You will also need to DELETE the other wow-7.X.XX.jar that is in that directory.

Once you have the 2 folders merged and the .jar moved, restart Tomcat to pick up the changes.

Starting WOW

Starting/Stopping MySQL

MySQL runs as a Service on your computer, so all your metadata is stored locally.  When installation of MySQL completes, the MySQL server should have started up automatically.  Since MySQL is installed as a Windows Service, you can start and stop it through Windows by navigating to Control Panel > Administrative Tools > Services.  Locate the appropriate MySQL service (generally named mysqlX.X where X.X is the version of the server that was installed) and use the Start, Stop or Restart links to manage your MySQL server.

Starting/Stopping Apache Tomcat

Similar to MySQL, the Apache Tomcat Server runs as a Windows service and can be controlled through Windows by navigating to Control Panel > Administrative Tools > Services and locating the appropriate Tomcat service.  If you checked the ‘Service’ box during the initial Apache Tomcat installation, the Tomcat service will begin automatically when you start Windows.  You can check if the service has started by using the “Configure Tomcat” shortcut that is provided for your convenience.  To access this shortuct, navigate through the Start Menu to All Programs > Apache Tomcat X.X > Configure Tomcat.

As seen above, using the Configure Tomcat program, you can Start, Stop, Pause and Restart tomcat.  You can also set minimum and maximum memory values here as well as manage and configure other Tomcat options.

After you’ve started Tomcat, open a web browser (IE, Firefox, Opera, Chrome, etc..) and enter the URL of your Tomcat server (if you have kept the factory default settings, it’d be something like:  http://localhost:8080/).  If you arrive at the screen shown below, you’ve successfully set up Tomcat.

Optimizing Apache Tomcat

Tomcat ships with the maximum memory set to 64MB, which is usually not large enough to handle most large web applications.  We recommend increasing the maximum amount of memory to 80% of the total RAM available on your server.  This can be done in the Configure Tomcat program that we accessed above.  To access the Tomcat properties allowing changes to the maximum memory, select the Java tab in the Apache Tomcat Properties screen.  You can then change the maximum memory to whatever you deem necessary for your situation.

The Initial memory pool value can be set to anything, but we advise starting with at least 64 to 100 MB.  The maximum memory pool should be up to 80% of your computers RAM.  For example, if you have 512 MB of RAM, then your maximum memory pool value should be set to around 400 MB.  This will change the default allocation of memory for Tomcat and allow the server to handle much heavier data loads.

Accessing the WOW Builder

The WOW Builder is accessed by web browser.  Open a browser (IE or Firefox are recommended, but WOW also works with Google’s Chrome browser as well) and start by entering the URL of your Tomcat server (http://localhost:8080/  from the example above), then attach the name of the webapp we installed (wow70) followed by a /, then wowBuilder (so the full URL of this example should look like this:  http://localhost:8080/wow70/wowBuilder ) and hit the [Enter] key.  If a website similar to the screen below loads, you have successfully set up the WOW Builder.

More information:

WOW Videos and Manuals:  http://planetjavainc.com/support.htm 

Assistance:  support@planetJavaInc.com 

Additional WOW Products: http://planetjavainc.com/products.htm

 

PlanetJ Confidentiality and Proprietary Information

PLANETJ is a registered trademark of PLANETJ Incorporated in the United States and may be registered in other countries. Other product and brand names may be trademarks or registered trademarks of their respective owners.  This technical data may be subject to U.S. and international export, re-export, or transfer (“export”) laws. Diversion contrary to U.S. and international law is strictly prohibited.

PLANETJ Incorporated

Copyright © 2011 PLANETJ Incorporated.

All Rights Reserved