WOW Community Edition Installation Instructions

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. As of WOW version 7.3, BETA support for H2 metadata has been included.

WOW Application Code
a. For WOW trial and Community Editions, this guide only covers running WOW on the Apache Tomcat application server on a Microsoft 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

A Windows PC (NT, 2000, XP, 2003, Vista, 2008, Windows 7).
At least 256 MB of RAM.
A 400 Mhz or faster processor.
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 (IBM i5 only)

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

Java JDK (we recommend Java JDK 1.7): This file contains all of the necessary files to run Java applications on your PC and is required by Apache Tomcat.
Apache Tomcat (we recommend Tomcat 7): 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.
WOW Resource Files: The wow75 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). As of WOW version 7.3, BETA support for H2 database is included. For any of these options, you may connect to any database on your network for data. 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

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.
MySQL Data Folder: The installation package contains a folder called “Data” that contains the MySQL tables for the WOW Metadata
(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 (aka IBM i)

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

AS400 SaveFiles: The installation package contains a folder called “AS400 SaveFiles”. This folder contains the WOWUSER75.SAVF and the WOWSYS75.SAVF. These SaveFiles need to be FTP’d and restored to the AS/400.

Required Files for H2

NOTE: H2 database support is currently (as of WOW version 7.3) a BETA feature.

There is very little setup required to run WOW on the included H2 Metadata. There is a single optional component that can be created to allow HTTP access to your H2 Metadata.

Component Description

Configuration files: To configure the WOW webapp to allow HTTP access to the H2 Metadata server, simply create a folder called ‘wowconf’ (no quotes). This folder goes inside the wow75/WEB-INF folder. Inside the wowconf folder, create a file called wow.properties. Edit this file with a text editor, add the following lines, save and restart your Tomcat.
        h2.server.enabled = true

        h2.server.web = 8280
        h2.server.tcp = 9190

You can now access your H2 metadata through a web browser which acts as an SQL Query Browser. To access, use the following URL on the server in which you installed Tomcat and WOW: http://localhost:8280/

NOTE: Only 1 instance of H2 metadata with HTTP enabled can be running on any single Tomcat instance at once.

Installing WOW

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

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.
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.
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.
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.
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/wow75/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).
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.
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.
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 backup 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.
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

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 (which are 2 folders: wowuser75 and wowsys75) from the installation package into the servers “Data” folder.
*NOTE: Please backup your “Data” folder before merging our WOW Metadata into it.
(OPTIONAL - AS400/iSeries/IBM i ONLY) If you wish to use H2 Metadata, skip to step 14. 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:

Create 2 save files on the iSeries (this is where the files will be FTP’d to):

CRTSAVF FILE(QGPL/WOWSYS75)
CRTSAVF FILE(QGPL/WOWUSER75)

On your PC (where the WOW save files are available), bring up a Command Prompt window.
From Command Prompt, change directories (cd) to the folder containing the 2 save files.
FTP to the iSeries:

ftp <iSeries ipaddress>
<iSeries User Id>
<iSeries Password>
Set to binary mode: bin
Send both WOW save files to the iSeries:

put wowsys75.savf /QSYS.LIB/QGPL.LIB/WOWSYS75.FILE
put wowuser75.savf /QSYS.LIB/QGPL.LIB/WOWUSER75.FILE

End FTP session: quit
Close Command Prompt window.

To Restore the libraries on the iSeries:

RSTLIB SAVLIB(WOWSYS75) DEV(*SAVF) SAVF(QGPL/WOWSYS75) MBROPT(*ALL) ALWOBJDIF(*ALL)
RSTLIB SAVLIB(WOWUSER75) DEV(*SAVF) SAVF(QGPL/WOWUSER75) MBROPT(*ALL) ALWOBJDIF(*ALL)

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 “wow75”. This is the webapp that goes on your Apache Tomcat server. To install, copy the “wow75” 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\wow75
(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 wow75 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: 
<init-param id="WOW_Metadata_System_URL">
<param-name>PJ_SYSTEM_URL</param-name>
<param-value>jdbc:as400://YOUR_SYSTEM_HERE/wowsys75</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 037.
(OPTIONAL - H2 Metadata ONLY) If you wish to use the H2 Metadata that comes with wow75, the web.xml file will need to be modified to point to the pre-installed H2 database. The web.xml file can be found in the WEB-INF folder inside the wow75 webapp. There is already an h2-web.xml file located inside the folder but it will need to be renamed. The file needs to be renamed from h2-web.xml to “web.xml” (without the quotes, you may need to remove the existing web.xml file before you can rename). Once renamed, restart Tomcat (if already running) and WOW will be using H2 database to store your metadata. All metadata is stored in the h2.wow.metadata.h2.db file that can be found in the WEB-INF folder.

Upgrading WOW

Information on upgrading to a newer version of WOW can be found in our Upgrade Document.

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 (wow75) followed by a /, then wowBuilder (so the full URL of this example should look like this: http://localhost:8080/wow75/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