Before you begin: Remember that these are sample applications designed to help you develop your own complete applications. These applications may not suit your real-time production requirements "as is," as explained in our Netscape AppFoundry FAQ. Please be sure to make backups of any HTML documents you use, and carefully review the technical notes in this document.

If you encounter any difficulties downloading or installing the software, please go to our AppFoundry Troubleshooting FAQ or Forums page.

• Required Software
• The Installation Process
• Unix Environment Download and Setup
• Windows NT Environment Download and Setup
• Installing the Applications
• Other Ways to Obtain Netscape Software
• Technical Resources

	System Requirements	Web and Database Software Requirements
Unix	Sun (Solaris 2.4, 2.5), HP (HP-UX 10.01), DEC (OSF/1 3.2c), or SGI (IRIX 5.3, 6.2) operating system Minimum 32MB RAM (more RAM is recommended for serving large numbers of clients or high levels of transactions) 80MB of hard disk space for the server and database 30MB hard disk for log files	Netscape Navigator, version 3.0 or higher Netscape Enterprise Server or FastTrack Server INFORMIX-OnLine Workgroup Server database for HP and Solaris 7.13.UC2, for DEC (OSF/1 3.2C) 7.12.UC1, and for SGI (IRIX 5.3, 6.2) 7.12.UC1
NT	Windows NT workstation with a 486 or a Pentium chip Windows NT version 3.5.1 (including Service Pack 4) Minimum 32MB RAM (more RAM is recommended for serving large numbers of clients or high levels of transactions) 80MB hard disk space for the server and database 30MB hard disk space for log files	Netscape Navigator version 3.0 or higher Netscape Enterprise Server or FastTrack Server INFORMIX-OnLine Workgroup Server database V7.12.TC3

TIME TO INSTALL

Depending on the software you already have on your system, it will take an hour to several hours to download, install, and configure Netscape Enterprise Server and the INFORMIX-OnLine Workgroup Server database. We think you'll find the range of functionality these JavaScript applications provide very useful as a quick start in building an intranet with advanced applications.

• Install Netscape Enterprise Server 2.0 and enable Server-side JavaScript.
• Install and create the database (Informix).
• Test Enterprise Server-to-database connectivity by installing and using the Video Sample application.
• Install and run the applications.

1. If you already have the latest version of Netscape Enterprise Server installed and configured, go to step 4 below. Otherwise, go to the download area and complete the registration form to begin the download. Note that any Netscape and Informix software you download is 60-day evaluation software. See below for other ways to obtain Netscape software.

2. After completing the download registration form, choose a user name and password that you will use to access the download area. Take note of your user name and password because you will need them to download the other software components (INFORMIX-OnLine Workgroup Server and the sample applications).

3. After successfully downloading Netscape Enterprise Server, follow the instructions in the Netscape Enterprise Server README file to install and configure Netscape Enterprise Server. Note that Netscape Enterprise Server includes a Netscape LiveWire runtime.

   Manually Installing Netscape LiveWire Compiler
   The ns-setup program does not install the LiveWire compiler into the directory structure of Enterprise Server. To use the LiveWire compiler, you must manually copy the LiveWire compile, lwcomp, into the proper LiveWire bin directory after you have installed Enterprise Server.

   a. Create a directory under the server root directory called: [Server-root]/LiveWire/bin

   # mkdir /usr/ns-home/LiveWire/bin/

   b. Copy the lwcomp file to the [Server-root]/LiveWire/bin directory

   # cp lwcomp /usr/ns-home/LiveWire/bin/

   If you installed Enterprise Server from the Netscape Test Drive download file, lwcomp will be located in the same directory as the ns-setup installation program. If you installed Enterprise Server from CD-ROM, lwcomp will be located under the [cdrom mount directory]/LIVEWIRE subdirectory. If you want to run the LiveWire compiler from any directory on your computer, add the directory to your PATH environment variable. For more information on LiveWire, please refer to the Netscape LiveWire release notes.

   Enabling Netscape LiveWire
   After successfully installing and configuring Netscape Enterprise Server, make sure you enable the Netscape LiveWire runtime (included in Netscape Enterprise Server) by using Netscape Enterprise Server's administration interface. You can do this from the Netscape administration server. Select Programs, select LiveWire, and then select to Enable LiveWire applications. Save and apply the change.

   Solaris 2.4 Patches
   For the Solaris 2.4 operating system, ensure that all patches up to and including Patch 34 and Patch 101242-10 have been applied. Patches can be obtained from Sun.

4. If you already have the latest version of the INFORMIX-OnLine Workgroup Server installed and configured, go to step 7. If not, create a directory to install Informix. This directory will be called informix_path in this document. Download INFORMIX-OnLine Workgroup Server into this directory.

   For general information and documentation on the Informix database, check out Informix's Knowledge Base.

5. Uncompress the Informix database. Before installing the Informix database, please read the following notes:

   Hosts File
   You must ensure that a valid HOSTS file exists on the machine on which the INFORMIX-OnLine Workgroup Server will be installed. The HOSTS file should contain a fully qualified domain specification for the host system in addition to the LOCALHOST entry. For example:

   127.0.0.1 localhost

   160.184.145.36 pctest..my_company.com

   If a valid HOSTS file is not present, the Informix installation will abort the first time it tries to connect to the Informix server, when it attempts to build the "sysmaster" database. The Informix README file for Solaris contains more detailed information about the HOSTS file requirements.

   Kernel Parameters for Solaris 2.4
   When installing the INFORMIX-OnLine Workgroup Server, a small number of kernel parameters must be set. These are specified in the README file included with the Informix software. A reboot may also be necessary for the kernel to be rebuilt with the appropriate parameters. The following are the parameters for Solaris. They should be added to the /etc/system file:

   set enable_sm_wa = 1 (Note: This line is required only for Solaris 2.4, not for 2.5 or 2.5.1.)

   set semsys:seminfo_semmap=64

   set semsys:seminfo_semmni=4096

   set semsys:seminfo_semmns=4096

   set semsys:seminfo_semmnu=4096

   set semsys:seminfo_semume=64

   set shmsys:shminfo_shmmin=100

   set shmsys:shminfo_shmmni=100

   set shmsys:shminfo_shmseg=100

   Kernel Parameters for HP
   Make sure that SHLIB_PATH includes $INFORMIXDIR/lib and $INFORMIX/lob/esql.

   Also, the following HP kernel parameters are recommended:

   SHMMAX: 805306367

   SHMMIN: 1

   SHMALL: Not applicable

   SHMMNI: 256 SHMSEG: 100

   SHMBRK: Not applicable

   MAXMEM: Not applicable

   SEMMNI: 4096

   SEMMNS: 4096

   SEMMSL: Not applicable

   NFILES: 8192

   Kernel Parameters for DEC Unix 3.2C
   The following kernel parameters must be adjusted to the indicated values for minimally acceptable Informix Online performance. See your DEC OSF/1 System Administrators Guide or the doconfig (8) man page, for information on adjusting these kernel parameters.

   SHMMAX: 2097152000

   SHMMNI: 150

   SHMSEG: 150

   SEMMNI: 400

   SEMMNS: 100

   SEMMSL: 1600

   The default values for the following kernel parameters will usually suffice, but if necessary they may be increased to the indicated values:

   DFLDSIZ 134217728

   MAXDSIZ 8589934592

   DFLSSIZ 8388608

   MAXSSIZ 33554432

   MAXVAS 17179869184

   SEMOPM 400

   SEMUME 400

   HEAPPERCENT 60

   After adding these parameters, reboot the system and proceed with Informix installation.

   Go to the informix_path directory and enter the commands:

   uncompress [informix_distribution].tar.Z
   tar xvf [informix_distribution].tar

   Kernal Parameters for SGI IRIX 5.3 and 6.2
   

   Informix requires the following minimum system configuration changes. Before running the database, make these changes via the system command and reboot the system. The database will start up automatically at reboot.

   The following kernal parameters are recommended:

   SHMMAX: 536870912

   SHMMIN: 1

   SHMALL: 512

   SHMMNI: 100

   SHMSEG: 100

   SHMBRK: Not applicable

   SEMMNI: 400

   SEMMNS: 2500

   SEMMSL: 25

   MAXMEM: Not applicable

   NFILES: Not applicable

   Install the Informix database. Review the following installation notes and follow the INFORMIX-OnLine Workgroup Server instructions in the informix_path/README file to install and configure the database.

   Informix Directory and Installation program

   Decide where you want to install Informix (INFORMIXDIR), log in as root, and execute the automatic install:

   % sh install.[x].shar

   where [x] is Sun, DEC, or HP.

   
   The installation program will automatically configure your system to work with Informix and install and configure the Informix database for use with LiveWire. You will be asked to supply the following information:

   1. Installation path (INFORMIXDIR). This should have at least 50MB free space.
   2. Size of the database space. This defaults to 20MB, which is sufficient to get you started with the applications.
   3. Contact information.
   4. Express or manual installation. Choose Express unless you are already an experienced Informix user and want to install it manually. The installation should then complete successfully. To use Informix with LiveWire, you will need to know the server name. The server name is set to infmx_online by the installation setup script.

   Informix Environment Variables
   The INFORMIX-OnLine Workgroup Server installation procedure defines a number of Informix environment variables (most importantly, INFORMIXDIR and INFORMIXSERVER). To connect to Informix, the HTTP server (for example, Netscape Enterprise Server) needs to be aware of these. If you install the HTTP server before installing Informix, Netscape LiveWire Pro will not be able to open the connection to Informix. A message will indicate that it can't locate the required Informix files. The solution is to stop and then restart the HTTP server.

   The following installation script creates two files to assist in this procedure:

   • ifmx.csh - Add the contents of this file to .cshrc for relevant accounts
   • ifmx.sh - Add the contents of this file to .profile for relevant accounts

   Also, the Netscape server environment needs to include the INFORMIX environment variables contained in the above files. You may choose to do this either by adding the file contents to the "start" file for your Netscape Server or by ensuring that the user who runs the Netscape Server has the INFORMIX environment variables set.

   Database User, Password, and Database Server Name
   During the INFORMIX-OnLine Workgroup Server installation process, you will need to create a database user, assign a password, and name the database server. As downloaded, the applications are compiled to use a database of type INFORMIX, informix  for both user name and password, and appalanche_db as the database server name. If you use these values for user name, password, and database server name, you will not need to modify each application's database connect string and recompile. (Note that some of the applications may need recompilation for different reasons; please be sure to read each application's README file.)

   Serial Number and Key

   When prompted for a serial number and key, enter the following:

   HP-UX 10.01

   • Serial Number: AAB#J508168
   • Key: DGCIIQ

   Solaris 2.4, 2.5

   • Serial Number: AAB#J508171
   • Key: AWFQJI

   OSF/1 3.2

   • Serial Number: AAB#J442495
   • Key: AYNLJT

   IRIX 5.3, 6.2

   • Serial Number: AAB#J508167
   • Key: XHTJKC

   NIS and Informix
   The setup script adds an entry to /etc/services for INFORMIX. If your system is configured to use a remote services database only (therefore ignoring any local /etc/services entries), then you should have a services entry added to your central NIS services database machine before running the setup script.

   The services entry should look like this:

   ifmx_srvc 2055/tcp # Service used by INFORMIX

   If the 2055 port number is already in use by another service, then choose another port number.

   Starting and Stopping the Informix Database
   Make sure you start up the Informix database before you start the Enterprise Server. You can check that Informix is running by issuing the command

   % onstat -

   You can stop Informix by issuing the command

   % onmode -ky

   You can start Informix by issuing the command

   % oninit

   If you chose to have the installation script add Informix startup and stop to your operating system's startup files, you will not normally need to start or stop Informix manually.

   Troubleshooting the Informix Installation
   If you have any problems, examine the following files:

   • $INFORMIX/dbspace/online.log - the informix server log
   • /tmp/install.log - the installation script log

   To get more information about the Informix error number shown in online.log, use the Informix "finderr" utility located in $INFORMIX/bin. For example, if you find that error -956 is mentioned in the online.log file you can find out more about the error by running the following command:

   % finderr -956

   Informix Electronic Documentation
   Visit the Informix Workgroup Solutions Web Site at http://www.informix.com/wgs to obtain electronic copies of product documentation.

   Before you continue downloading and running the applications, make sure you can run the Video Sample application, which should have been installed when you installed Netscape Enterprise Server. Successfully running the Video Sample application will ensure that you have the necessary components to run the other applications. If you have problems running this sample program using an Informix database, refer to the Netscape LiveWire release notes.

   You are now ready to proceed with installing the applications.

   ---

   WINDOWS NT ENVIRONMENT DOWNLOAD AND SETUP

   1. If you already have the latest version of Netscape Enterprise Server installed and configured, go to step 4 below. Otherwise, go to the download area and complete the registration form to begin the download. Note that any Netscape and Informix software you download is 60-day evaluation software. See below for other ways to obtain Netscape software.

   2. After completing the download registration form, choose a user name and password that you will use to access the download area. Take note of your user name and password because you will need them to download the other required software components (INFORMIX-OnLine Workgroup Server and the sample applications).

   3. After successfully downloading Netscape Enterprise Server, run enterprise.ntintel.exe to install and configure the Netscape Enterprise server. Note that Netscape Enterprise Server includes a Netscape LiveWire runtime.

      Fixed IP Address for Netscape Enterprise Server
      When installing Netscape Enterprise Server, make sure you are using a fixed IP address. Netscape Enterprise Server will not install properly if you are using dynamic IP addressing.

      Enabling Netscape LiveWire
      After successfully installing and configuring Netscape Enterprise Server, make sure you enable the Netscape LiveWire runtime (included in Netscape Enterprise Server) by using the Netscape Enterprise Server's administration tool. You can do this from the Netscape administration server. Select Programs, select LiveWire, and then select to enable LiveWire applications. Save and apply the change.

   4. If you already have the latest version of INFORMIX-OnLine Workgroup Server installed and configured, go to step 7 below. If not, create a directory to install Informix. This directory will be called informix_path in this document. Download INFORMIX-OnLine Workgroup Server into this directory.

      For general information and documentation on the Informix database, check out Informix's Knowledge Base.

   5. Go to the informix_path directory and do the following:
      • Unzip the Informix file while making sure you maintain the subdirectory structure (for example, pkunzip [filename] -d).
      • Run setup.exe to begin the installation.
      • Refer to the Serial Number and Key section below to get the the serial number and key.
      • Enter your registration information when requested.
      • Select your installation type (we recommend a typical installation). To use the default database connect string information in the AppFoundry applications, we recommend you use the following parameters during the informix database setup:
      • appalanche_db  for the database server name, and
      • informix  as the password for the user informix.

      At this point you should be able to access the Informix database using the tools in the INFORMIX-OnLine Workgroup Server program group. To access Informix from the Enterprise Server (to run dbadmin), you will need to run regcopy (in /informix/bin) and reboot the server to make sure the database is online (command center in the INFORMIX-OnLine Workgroup Server program group).

   6. Install the Informix database. Review the following installation notes and follow the INFORMIX-OnLine Workgroup Server instructions in the informix_path/README file to install and configure the database.

      Unzipping the Download File
      Make sure you unzip the download file using the -d option, for example:

      pkunzip -d olwgs712.zip

      NT File System and DHCP
      When prompted for a location in which to install Informix, enter a directory on an NTFS disk partition. You must install on an NTFS partition. Also, make sure you are not using DHCP.

      Conserving Disk Space
      To reduce the amount of disk space used by the OnLine Workgroup Server, choose Custom and specify the database size. The suggested minimum size is 20MB.

      Hosts File
      You need to ensure that a valid HOSTS file exists on the machine on which the INFORMIX-OnLine Workgroup Server is going to be installed. On Windows NT, this is typically located in the \WINNT35\system32\drivers\etc directory. The HOSTS file should contain a fully qualified domain specification for the host system in addition to the LOCALHOST entry, for example:

      127.0.0.1 localhost

      160.184.145.36 pctest..my_company.com

      If a valid HOSTS file is not present, the Informix installation will abort the first time it tries to connect to the Informix database server, when it attempts to build the sysmaster database.

      You will also need to configure your hosts.equiv file located in the WINNT35\system32\drivers\etc directory. It should contain a complete list of domain names for the local machine, so if your machine name is neuromancer.mcom.com and you have beavis.mcom.com mapped to that same IP address, then the file should include both those names.

      Informix Environment Variables
      The INFORMIX-OnLine Workgroup Server installation procedure defines a number of Informix environment variables (most importantly, INFORMIXDIR and INFORMIXSERVER). To connect to Informix, the HTTP server (for example, Netscape Enterprise Server) needs to be aware of these. If you install the HTTP server before installing Informix, Netscape LiveWire Pro will not be able to open the connection to Informix. A message will indicate that it can't locate the required Informix files. The solution is to stop and then restart the HTTP server.

      Database User, Password, and Database Server Name
      During the INFORMIX-OnLine Workgroup Server installation process, you will need to create a database user, assign a password, and name the database server. As downloaded, the applications are compiled to use a database of type INFORMIX, informix for both user name and password, and appalanche_db as the database server name. If you use these values for user name, password, and database server name, you will not need to modify each application's database connect string and recompile. (Note that some of the applications may need recompilation for different reasons; please be sure to read each application's README file.)

      Serial Number and Key
      When prompted for a serial number and key, enter the following:

      • Server license serial number: AAB#J556877
      • Key: ZYTAKX

      Running as a User Service
      By default, the Netscape HTTPD OR HTTPS service runs as a system service. To use Informix, it is recommended that you change the service to run as a user service (generally, your normal logon name): In Control Panel | Services, select the Netscape Enterprise service and choose Startup. In the dialog box that appears, choose Log On As - This Account, and enter your account name.

      Starting the Informix Database
      Be sure to start up the Informix database before starting the Enterprise Server.

      Database Access Problems
      If after installing all platform components (Netscape Enterprise Server and Informix database) you experience problems with database access through Netscape LiveWire, perform the following steps:

      • Uninstall all components and delete all disk files.
      • Run the regedt32.exe program and manually remove all references to either Netscape or Informix. (The uninstall routines do not do this properly and Informix will not install unless this step is performed.)
      • Install Netscape Enterprise Server and verify that Netscape LiveWire is turned off (disabled) in the server setup.
      • Install INFORMIX-OnLine Workgroup Server.
      • Open the control panel and examine the startup parameters for the following Netscape and Informix services:
      • Informix Message Service
      • start as system account
        Informix Server Agent
      • start as user informix (or admin user specified when Informix was installed)
        Informix Workgroup Server
      • start as user informix (or admin user specified when Informix was installed)
        Netscape Administrator Server
      • start as system account
        Netscape Enterprise Server
      • start as user with administrative privileges for NT and the Informix Workgroup Server
      • Examine the user settings. Verify that the Informix administration user (default: informix) is included in both the Informix-admin group and the Administrators group.
      • Restart the NT server and enable LiveWire.

      Troubleshooting the Informix Installation
      If you experience any problems during the Informix installation, check the "online.log" file in the Informix directory. Be sure to read the Release Notes document (README.WRI) that is included with the Informix installation.

      If you encounter the error

      21:04:05 listener-thread: err = -956: Client host or user (informix@informix1.mcom.com) is not trusted by the server

      do the following:

      1. Add the domain name (informix1.mcom.com in the example above) to the hosts.equiv file in WINNT351\system32\drivers\etc.
      2. Reinstall by rerunning the OWSsetup.exe file provided with the distribution (not SETUP.EXE).
      3. When reinstalling, elect to copy files and reconfigure the installation.
      4. Run REGCOPY.EXE after the installation has completed. You will find this executable file in the Informix bin directory.

      If you encounter the error

      21:04:05 listener-thread: err = -956: Client host or user (informix@h207-1-136-188.mcom.com) is not trusted by the server

      then you are almost certainly using DHCP. The best solution is to turn DHCP off and reinstall. If you cannot do this, you may try the workaround described above.

      7. A sample program, called Video Sample application, is included with Netscape LiveWire. Successfully running the Video Sample application is a prerequisite for running the applications. If you have problems running this sample program using an Informix database on NT, refer to the Netscape LiveWire release notes. If you continue to have problems, run the regcopy.exe file in the informix\bin subdirectory on your Windows NT Server.

      You are now ready to proceed with installing the applications.

      ---

      INSTALLING THE APPLICATIONS

      The following installation instructions assume that the database environment uses the following values in the connect string:
      • Database type = informix
      • Database server name = appalanche_db
      • Userid = informix
      • Password = informix
      • app_directory = applications directory
      • app_db = application database (refer to the application README file for specific database name)
      • start.htm = file that contains parameters that need to be included in the database.connect() statement

      Assuming that the above database environment is being used, a typical application is installed as follows (please refer to the application's README file for application-specific details):

      1. Create an application directory, for example /LiveWire/samples/appdir. This directory will be called app_directory  in this document.

      2. Download the application file, for example 401kpln.exe for the 401(k) Plan Evaluator application. This file will be called app_file  in this document.

      3. Extract the app_file  into the app_directory  directory.

      4. Review the application's README file.

      5. Use Informix's dbaccess tool to create the database, database structures, and populate base and sample data.

         a. The SQL files for creating the database are in the app_directory/dbms/ifx directory. For NT, double-click the Command Line Utilities icon in the INFORMIX-OnLine Workgroup Server program group. This will bring up a DOS window where you will need to enter the following command:

         cd app_directory\ifx
dbaccess

         b. Once inside the dbaccess utility, select a highlighted choice by pressing Enter and move the highlight with the arrow keys. Make the following selections:

         • select Query Language;
         • select sysmaster@appalanche_db;
         • select Choose;
         • select "db_create.sql";
         • select Run (this will create the application database);
         • select Choose;
         • select "base_data.sql";
         • select Run (this will populate the application database with base data);
         • select Choose;
         • select "sample_data.sql";
         • select Run (this will create the sample data);
         • select Exit (to exit the SQL menu); and
         • select Exit (to exit the command-line utilities)

      6. Modify the application's database connect string and recompile if necessary by using build.bat. Note that if you used the recommended database environment parameters specified above (that is, database name = informix, and so on), you do not need to perform the following steps. Otherwise, you will need to refer to the application README file to determine what file must be modified. A typical modification would be as follows:
         • Go to the app_directory  and edit start.htm.
         • Change the "appalanche_db" in the database.connect statement to the server name you want to use.
         • If you changed the Informix default user name and password, you will also need to change the third and fourth arguments accordingly. If you kept the default, leave them as "informix," "informix."
         • Recompile the application (for example, on NT):
           • select the program group Main;
           • select File Manager;
           • select the directory app_directory; and
           • double-click the build.bat to recompile the application.

      7. Register and start the application in the LiveWire Application Manager (reached via the Netscape Admin Server).
         • In the left-hand frame of the LiveWire Application Manager, click Add to add the application.
         • Fill in the parameters as follows:
           • Name = app_name (URL) you want for the application
           • Web File Path = .../LiveWire/samples/app_name (refer to the application README for details)
           • Default Page = .../LiveWire/samples/app_name (refer to the application README for details)
           • Initial Page = .../LiveWire/samples/app_name (refer to the application README for details)
           • Maximum Database Connections = 1
           • External Libraries =        (leave this field blank)
           • Client Object Maintenance = client-cookie
         • Click Enter.
         • In the left-hand frame, click Run to run the application.

      When your applications are ready to share with users, an easy way to get them started is by emailing the home page through Netscape Navigator Mail (choose File, Mail Document). Within the email message, the hyperlinks and form cells remain live and hooked to the database; no need to distribute the application!

      ---

      OTHER WAYS TO OBTAIN NETSCAPE SOFTWARE

      • Order a Test-Drive CD and use the products for 60 days through the Test-Drive Program.

      • For small orders, purchase through our online General Store.

      • For large orders, contact Corporate Sales at 415/937-2555 or at moresales@netscape.com.

      • You can also purchase through our resellers and hardware partners.

      ---

      TECHNICAL RESOURCES

      For general technical information on Netscape products, developer resources, and links to user groups, please visit our Resources and Forums areas.

      ---

      Corporate Sales: 415/937-2555; Personal Sales: 415/937-3777; Government Sales: 415/937-3678
      If you have any questions, please visit Customer Service.

      Copyright © 1997 Netscape Communications Corporation