|
|
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 "System Requirements."
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 "Server Installation: Control System," and "Client Installation."
The actions for this installation are organized into the following categories that should be implemented in this order:
The preinstallation actions are the following:
One group and three users are required for the correct operation of the WSA product.
Group:
Users:
 | 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.
# grep informix /etc/groupinformix::1001:
# egrep -e wsa\|informix /etc/passwdinformix: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
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
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:___________________________
The installation actions are the following:
If you are not already logged in as root, do so now and invoke a Korn shell.
# ksh
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
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
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
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.
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.
The post installation actions are the following:
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
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
Now that the database engine is installed, the WSA database must be created by taking the following actions:
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, 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.
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.
The database engine and WSA database are now fully installed. You are now in a position to install the control system, as described in "Server Installation: Control System."
Posted: Fri Apr 23 14:09:15 PDT 1999
Copyright 1989-1999©Cisco Systems Inc.