OpenLink Multi-tier Server Side Components (Unix) for ODBC

Aims and Intentions

This guide is intended to enable competent system administrators to install and configure OpenLink Multi-tier client side components on *nix style operating systems in a few steps as possible.

This guide does not explain any of the non-pertinent features encountered along the way. Such explanations may be found in the full documentation.

Prerequisites

You MUST be proficient in using a Unix shell.
You MUST have the relevant ODBC Driver and any dependent software installed and an ODBC data-source configured.
NOTE: ODBC Drivers and ODBC data-sources may be installed/added at a later time.

Installation

Log onto the machine and create a suitable OpenLink installation directory ($OPENLINK_INSTALL).
Copy all relevant components to $OPENLINK_INSTALL.

As a bare minimum, these will include; the OpenLink Request Broker, the OpenLink Agent for ODBC and finally an OpenLink license file (oplrqb.lic).
Install using the "install.sh" shell script --
```
 #sh install.sh
```
You should take care to enter correct information when prompted pertaining to ports, passwords, etc and ensure that you note these down for future use.
The installation should finish without error.

Licensing

OpenLink Multi-tier licensing is handled on the server side so you should place the OpenLink license file (oplrqb.lic) in the $OPENLINK_INSTALL/bin directory.

Configuration

ODBC needs no additional configuration.

Start the OpenLink Request Broker

Starting in foreground debug mode

It is often best to initially start the Request Broker in (f)oreground (d)ebug in order to diagnose problems--


 #cd $OPENLINK_INSTALL
 #. ./openlink.sh
 #oplrqb -fd
 OpenLink Request Broker
 Version 2.47 as of Tue Jan 08 2008 (Release 6.2 cvsid 00089).
 Compiled for Solaris 5.8 (sparc-sun-solaris2.8-32)
 Copyright (C) OpenLink Software.  

 Registered to OpenLink US Lab - INTERNAL USE ONLY
 with product serial number OPL-US-INTERNAL
 This is a 5 concurrent users license
 restricted to 5 concurrent connections
 Issued by OpenLink Software
 This license will expire on Thu May 22 01:52:13 2008 GMT

 oplrqb: using rulebook $OPENLINK_INSTALL/bin/oplrqb.ini
 oplrqb: bound TCP protocol to 0.0.0.0.5000
 oplrqb: request broker started by openlink
 oplrqb: spawning $OPENLINK_INSTALL/bin/w3config/www_sv www_sv +debug
 www_sv: started http://hostname:5000
 oplrqb: started persistent www_sv (pid=25896)
 oplrqb: ZeroConfig thread started
 oplrqb: ZeroConfig registration MySQL (oplussol4)

The OpenLink Request Broker will continue to run, taking over the session, until <Ctrl-C> is entered which stops the Broker

Starting Normally


 #cd $OPENLINK_INSTALL
 #. ./openlink.sh
 #oplrqb

Testing

You are now ready to test the connection which now requires that you read the relevant quick start guide for client component on the chosen operating system.

Additional Information

Any changes made to $OPENLINK_INSTALL/bin/oplrqb.ini whilst the Request Broker is running will require the Request Broker to be re-initialised --
```
 #cd $OPENLINK_INSTALL
 #. ./openlink.sh
 #oplshut +reinit
```

To stop a Request Broker running normally --


 #cd $OPENLINK_INSTALL
 #. ./openlink.sh
 #oplshut +force