Support

Table Of Contents

Server Installation: Database

Introduction

Preinstallation Actions

Creating Groups and Users

Allocating Space for the Installation

Installation Actions

Log in as root

Mount the Distribution Media

Set the Environment Variables

Read in the Distribution File

Run the Installation Script

Reboot the System

Post Installation Actions

Log in as informix and Initialize the Database Engine

Wait for Informix System Catalogs to be Created and Reboot

Creating the WSA Database

Log in as informix and Read in the Distribution

Run the Database Build Script

Check that the Build Worked

Installation Complete

Server Installation: Database

---

Introduction

This chapter describes how to install the relational database engine and the database that support the WSA product. However, before you start this procedure, be sure that your system is set up with the requirements specified in "."

The installation of the database engine is the first of three installations needed to support the WSA product. The instructions for the other two installations are given in "," and "."

The actions for this installation are organized into the following categories that should be implemented in this order:

•Preinstallation Actions

•Installation Actions

•Post Installation Actions

•Creating the WSA Database

•Installation Complete

Preinstallation Actions

The preinstallation actions are the following:

•Creating Groups and Users

•Allocating Space for the Installation

Creating Groups and Users

One group and three users are required for the correct operation of the WSA product.

Group:

•informix - all the WSA users belong to this group

Users:

•informix - the database engine super-user account

•wsa - the WSA Control System account

•wsauser - the WSA Client account, shared by all connected PCs

---

Note   Before creating this group and these users, decide what numeric identifiers you will give them. On an out-of-the-box installation of Solaris 2.5.1, the suggested group identifier of 1001and user identifiers of 1001, 1002, and 1003 are available. If these identifiers are already in use on your system, use any unused identifier greater than 1000. The following steps assume that the suggested group and user identifiers are available on your system.

---

---

Caution   These steps assume that you are not running NIS+. If you are running NIS+, consult your documentation for creating new local groups and local users. In certain situations, NIS+ may delete your locally created groups. In most situations this will not cause a problem for WSA. If this does cause a problem, contact Cisco Technical Support.

---

---

Step 1 Create the WSA group.

# groupadd -g 1001 informix

Step 2 Create the database engine super user account.

# useradd -u 1001 -g informix -s /bin/ksh -c 'Informix' -d
/export/home/informix informix

Step 3 Create the WSA Control System account.

# useradd -u 1002 -g informix -s /bin/ksh -c 'WSA' -d
/export/home/wsa wsa

Step 4 Create the WSA Client account.

# useradd -u 1003 -g informix -c 'WSA Client' -d /dev/null wsauser

Edit /etc/passwd and change the entry for wsauser to read as follows:

wsauser:x:1003:1001::/dev/null:/dev/null

Step 5 Create the home directories for the database engine and WSA Control System users, for example:

# mkdir /export/home/informix

# chown informix:informix /export/home/informix

# mkdir /export/home/wsa

# chown wsa:informix /export/home/wsa

Step 6 Set the user passwords. Make all three different and observe safe password guidelines.

---

Note   To check that the WSA group and users have been created correctly, execute the following commands and check that the output is similar to the output listed here:

# grep informix /etc/group
informix::1001:

# egrep -e wsa\|informix /etc/passwd
informix:x:1001:1001:Informix:/export/home/informix:/bin/ksh
wsa:x:1002:1001:WSA:/export/home/wsa:/bin/ksh
wsaclient:x:1003:1001:WSA Client:/dev/null:/dev/null

---

Allocating Space for the Installation

---

Note   200 MB of disk space is required for this installation, 100 MB for the database engine and 100 MB for the WSA database itself.

---

The installation can be done in any file system that has sufficient space available. To determine which file systems are suitable candidates, run the following command:

# df -k | egrep -v tmp\|Filesystem | awk '{if ($4 > 200*1024)
printf("%8s %s\n", $4, $6)}'

If this command returns without producing a list of file systems, your system does not have 200 MB of contiguous space available in which to install WSA.

The output is expected to be similar to this, indicating that the file systems mounted on /export and /spare have sufficient space to hold the installation:

992576 /export
320169 /spare

---

Note   The recommendation is NOT to install WSA on an NFS mounted file system.

---

Once you have decided where to do the installation, create a directory to hold the database engine and the WSA database. For example:

# mkdir /export/informix

# chown informix:informix /export/informix

---

Caution   Do NOT perform the installation in the Informix user's home directory.

---

When the installation directory has been created, make a note of where it is. Later, you will need to set the value of the environment variable $INFORMIXDIR to this location.

Location of installation directory:___________________________

Installation Actions

The installation actions are the following:

•Log in as root

•Mount the Distribution Media

•Set the Environment Variables

•Read in the Distribution File

•Run the Installation Script

•Reboot the System

Log in as root

If you are not already logged in as root, do so now and invoke a Korn shell.

# ksh

Mount the Distribution Media

WSA is distributed on CD-ROM. Insert the distribution media in your CD-ROM drive and close the door.

Wait a couple of seconds for the operating system auto-mounter to mount and then check that the CD-ROM has auto mounted correctly by entering a df command, as follows:

# df /cdrom/cdrom0/ciscowsa

The expected result is something like this:

/cdrom/cisco (/vol/dev/dsk/c0t6d0/cisco): -1 blocks -1 files

If the result is something like the following message, wait a few seconds and try again:

df: (/cdrom/cdrom0/ciscowsa) not a block device, directory or mounted resource

If the above result continues, then issue the following commands before trying the df command.

These commands stop and restart volume management:

# /etc/init.d/volmgt stop

# /etc/init.d/volmgt start

Wait ten seconds and type:

# volcheck

Set the Environment Variables

The database engine install script requires that the environment variable INFORMIXDIR be set correctly. Use the value noted in the section Allocating Space for the Installation.

# INFORMIXDIR=<your value goes here>

# export INFORMIXDIR

Read in the Distribution File

The WSA control system files are stored in an uncompressed cpio archive on the distribution media. To read the files, issue the following commands:

# cd $INFORMIXDIR

# cpio -icvBdum < /cdrom/cdrom0/ciscowsa/informix.cpi

Run the Installation Script

Issue the following command to run the installation script:

# ./installinformix

The output should appear similar to the following:

########################################################################

# INFORMIX-OnLine Dynamic Server 7.23.UC2                              #

# Copyright (C) 1986-1997 Informix Software, Inc.                      #

########################################################################

This installation procedure must be run by a privileged user (root)

There must be a user "informix" and a group "informix" known to the system.

Press RETURN to continue, or the interrupt key (usually CTRL-C or DEL)

to abort.

Press Return to continue, and the output should appear similar to the following:

########################################################################

# Installing INFORMIX-OnLine Dynamic Server                            #

########################################################################

Installing directory .

:

:

Installing Shared Libraries in System Directories ...

########################################################################

# Configuring INFORMIX-OnLine Dynamic Server                           #

########################################################################

########################################################################

# Configuring user profiles                                            #

########################################################################

########################################################################

# Configuring system files                                             #

########################################################################

########################################################################

# Final Configuration                                                  #

########################################################################

Installation Complete.

You must now re-boot to finish the configuration of the

INFORMIX-OnLine Dynamic Server database engine.

Once the system has re-booted, follow the post-installation

instructions in the printed documentation.

Reboot the System

---

Note   The system must now be restarted because the install script has altered the operating system kernel configuration. This new configuration will only be picked up when the system restarts.

For reference, the following kernel parameters have been set in /etc/system

shmsys:shminfo_shmmax=268435456
semsys:seminfo_semmap=64
semsys:seminfo_semmni=4096
semsys:seminfo_semmns=4096
semsys:seminfo_semmnu+4096
semsys:seminfo_semume=64
semsys:seminfo_semmsl=100
shmsys:shminfo_shmmin=100
shmsys:shminfo_shmmni=100
shmsys:shminfo_shmseg=100

---

Restart the system using the following command:

# /usr/sbin/shutdown -i6 -g0 -y

As the systems restarts, a warning about the database engine not starting will appear on the console as follows:

Starting Informix OnLine

oninit: cannot open chunk '/export/informix/DBSpaces/RootDBS'. Errno = 4

oninit: Fatal error in shared memory initialization

This is normal—you have not initialized the database yet, so ignore the message.

Post Installation Actions

The post installation actions are the following:

•Log in as informix and Initialize the Database Engine

•Wait for Informix System Catalogs to be Created and Reboot

Log in as informix and Initialize the Database Engine

Initializing the database engine creates a 100 MB file in the UNIX file system in which the databases will be stored.

When asked if you want to continue, answer y, as follows:

$ oninit -i

This action will initialize INFORMIX-OnLine;

any existing INFORMIX_OnLine databases will NOT be accessible -

Do you wish to continue (y/n) ? y

Wait for Informix System Catalogs to be Created and Reboot

The database engine is now fully installed and configured, but is building two system configuration databases in the background. Wait 5 minutes for them to build.

---

Step 1 Log in as root. To test that the operating system will stop and start the database engine when it is rebooted, you will want to restart your machine now.

Use the following command:

# /usr/sbin/shutdown -i6 -g0 -y

Step 2 Once restarted, log in as informix and run the onstat command to check that the engine is running. The output will be something like the following (you are looking for the top line that says "On-Line"):

$ onstat

INFORMIX-OnLine Version 7.23.UC2 -- On-Line -- Up 00:00:42 -- 8968 Kbytes

Userthreads

address flags sessid user tty wait tout locks nreads nwrites

a12a018 ---P--D 1 root - 0 0 0 12 5

a12a458 ---P--F 0 root - 0 0 0 0 2

a12a898 ---P--B 14 root - 0 0 0 0 0

a12b558 ---P--D 17 root - 0 0 0 0 0

4 active, 128 total, 17 maximum concurrent

Profile

dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached

23 41 298       92.28 7 7        2 0.00

isamtot open start read write rewrite delete commit rollbk

16 4 5 3 0 0 0 0 0

ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes

0 0             0          3.85 8.83 1 2

bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans

0 0 19           0         0     0         0 0

ixda-RA idx-RA da-RA RA-pgsused lchwaits

5 0 0 3 1

Step 3 Execute a process listing to look for the server processes, as follows:

$ ps -ef | grep oninit

root 250 227 0 11:42:27 ? 0:00 oninit

root 251 227 0 11:42:27 ? 0:00 oninit

root 228 227 0 11:42:16 ? 0:00 oninit

root 229 227 0 11:42:25 ? 0:00 oninit

root 227 1 0 11:42:16 ? 0:12 oninit

root 230 227 0 11:42:25 ? 0:00 oninit

root 231 227 0 11:42:25 ? 0:00 oninit

root 232 227 0 11:42:25 ? 0:00 oninit

root 233 227 0 11:42:25 ? 0:00 oninit

root 234 227 0 11:42:26 ? 0:00 oninit

root 235 227 0 11:42:26 ? 0:00 oninit

root 236 227 0 11:42:26 ? 0:00 oninit

root 237 227 0 11:42:26 ? 0:00 oninit

root 238 227 0 11:42:26 ? 0:00 oninit

root 239 227 0 11:42:26 ? 0:00 oninit

root 240 227 0 11:42:26 ? 0:00 oninit

root 241 227 0 11:42:26 ? 0:00 oninit

root 242 227 0 11:42:26 ? 0:00 oninit

root 243 227 0 11:42:26 ? 0:00 oninit

root 249 227 0 11:42:27 ? 0:00 oninit

root 252 227 0 11:42:27 ? 0:00 oninit

informix 273 262 1 11:44:59 pts/0 0:00 grep oninit

Creating the WSA Database

Now that the database engine is installed, the WSA database must be created by taking the following actions:

•Log in as informix and Read in the Distribution

•Run the Database Build Script

•Check that the Build Worked

Log in as informix and Read in the Distribution

If you are not already logged in as informix, do so now.

Enter the following commands to read in the WSA database installation files:

$ mkdir DBBuild

$ cd DBBuild

$ cpio -icvBdum < /cdrom/cdrom0/ciscowsa/database.cpi

Run the Database Build Script

Run the database build script, as follows:

$ ./Build.sh

The output from this command should be similar to the following:

Creating base database wsamain

   :

   :

Database wsamain build complete.

The build typically takes from 1 to 15 minutes, depending on the speed of your machine.

Check that the Build Worked

To check that the build worked, execute a query on the database to list all the built-in customers, as follows:

$ echo "select cust_name from customer" | dbaccess wsamain

The output should be something like this:

Database selected.

cust_name
--None--
--WSA--
--Audit--
--NNI--

4 row(s) retrieved.

Database closed.

Installation Complete

The database engine and WSA database are now fully installed. You are now in a position to install the control system, as described in "."