SQL/R A.04.20 Release Notes - Installation on HP-UX

SQL/R A.04.20 Installation on HP-UX

This document contains installation instructions specific to the HP-UX platform.

Supported HP-UX releases
Installation directory
Installation
Updating from a previous SQL/R release
Uninstalling SQL/R A.04.20
sqlrodbc TCP service name
Encryption Support
LDAP Support
Configuring the Server

Supported HP-UX releases

SQL/R is available for HP-UX 11.31 on Itanium hardware (Integrity). This version no longer includes the PA-RISC driver libraries for use with the Aries emulation. Please let us know if you require the SQL/R PA-RISC driver libraries on Itanium.

The SQL/R A.04.20 release no longer supports PA-RISC hardware and HP-UX versions before 11.31.

Installation directory

Starting with SQL/R A.04.00, multiple SQL/R versions may be installed and used in parallel. Each major version is installed into a separate directory while minor updates will update an existing version.

The SQL/R A.04.20 software is installed in the "/opt/sqlr/4.2/" directory. The SQL/R configuration files are installed in the "/etc/opt/sqlr/4.2/" directory.

Modified configuration files are retained on updates and deinstallation and are not deleted.

Installation

SQL/R uses the HP-UX OpenSSL software for cryptographic functions, such as encrypted passwords or communication and the sqlictool to install a license key. The installation process creates symlinks to the libcrypto and libssl shared libraries that are used by SQL/R. It is recommened to install the OpenSSL software before SQL/R.

SQL/R is available as a depot package and is installed with the HP-UX swinstall utility.

SQL/R installation files available for download from the marxmeier.com web site are compressed with gzip and must be uncompressed before installation.

https://www.marxmeier.com/download/sqlr/A0420/hpux/
SQLR-A04xx-x-ia64.depot.gz

SQL/R depot file for the IA64 platform where A04xx-y indicates the release and depot file version. Higher numbers indicate a newer installation archive.

As "superuser" (root), follow the steps below to install the SQL/R software.

Unpack the archive at a temporary location, such as /var/tmp
```
/usr/contrib/bin/gzip -d SQLR-A04xx-x-ia64.depot.gz
```
This uncompresses the depot file SQLR-A04xx-x-ia64.depot.gz to SQLR-A04xx-x-ia64.depot. The compressed archive file is deleted.
Run "swinstall" by typing:
```
/usr/sbin/swinstall -s /var/tmp/SQLR-A04xx-x-ia64.depot
```
where /var/tmp/SQLR-A04xx-x-ia64.depot is the absolute path of the SQLR-A04xx-x-ia64.depot file.
By default swinstall is interactive. The additional argument as shown below performs the installation without interaction and the following steps can be skipped.
```
/usr/sbin/swinstall -s /var/tmp/SQLR-A04xx-x-ia64.depot \*
```
In the Software Selection Window, select/highlight the product options you would like to install then choose the "Mark for Install" item from the Actions Menu. The "Marked?" column will automatically be set to "Yes".
Select the "Install (analysis...)" item from the Actions Menu. When the analysis is finished with no error, i.e. Status:Ready, choose OK.
Choose Yes in the Confirmation window to begin the actual installation process. When the installation is completed, a dialog is displayed to notify you that the install task is completed. You may exit then.

If necessary, install or update the SQL/R license key.

Updating from a previous SQL/R release

Starting with SQL/R A.04.00, multiple SQLR versions may be installed and used in parallel. Each major version is installed into a separate directory while minor updates will update an existing version.

When updating from a SQL/R version before A.04.20 the previous SQL/R version is not affected. Any previous configuration files need to be copied or linked manually. When updating SQL/R A.04.20 any modified configuration files are retained and not deleted.

To update an existing SQL/R A.04.20 installation, please shut down SQL/R using the command below:

/sbin/init.d/sqlr42 stop

Then install the depot file. If necessary, update the license key. After the update has finished SQL/R can be started with the command below:

/sbin/init.d/sqlr42 start

Automatic startup of SQL/R servers during boot is configured in the /etc/rc.config.d/sqlr42 configuration file.

Uninstalling SQL/R A.04.20

To uninstall SQL/R A.04.20 from your system, please make sure the software is not currently used. The following command may be used to shut down the SQL/R background processes.

/sbin/init.d/sqlr42 stop

The software is removed using the HP-UX swremove utility. Please login as root and run swremove as below

/usr/sbin/swremove SQLR42

Please note that any modified configuration files (typically customized configuration files) are not removed. If necessary, they need to be removed manually.

sqlrodbc TCP service name

The SQL/R installation adds an entry like below in the /etc/services file:

sqlrodbc        8003/tcp    # SQL/R ODBC

The first column specifies the service name ("sqlrodbc"), the second column the associated port number and protocol ("8003/tcp"). This entry associates the service name "sqlrodbc" with the TCP port number 8003. The service name "sqlrodbc" is used as a default.

SQL/R may also install additional Eloquence specific TCP service names, such as eloqdb, the default database service and eloqld, the default service used by the Eloquence license server.

eloqdb          8102/tcp    # Eloquence data base server
eloqld          8104/tcp    # Eloquence license server

In rare cases it might be necessary to modify the default configuration, for example if the port number is already in use or does not match the one configured on other systems.

Encryption Support

SQL/R uses the HP-UX OpenSSL software for cryptographic functions. The OpenSSL software is optional but must be installed to use SQL/R cryptographic functionality, such as encrypted passwords, encrypted communication and the sqlictool utility.

The HP-UX OpenSSL software may be obtained from the HPE Software Center web site → https://myenterpriselicense.hpe.com/cwp-ui/free-software/OPENSSL11I.

At the time of this writing openSSL version 3.0 is current. (In case that the link becomes invalid, go to https://myenterpriselicense.hpe.com/ and search for OPENSSL11I).

SQL/R was tested with the OpenSSL 1.0, 1.1 and 3.0 library versions. SQL/R dynamically adapts to the OpenSSL library and does not depend on a specific version.

The installation process creates a symlink to the libcrypto and libssl shared libraries that are used by SQL/R. It is recommened to install the OpenSSL software before SQL/R so the relevant symlinks are created automatically. Alternatively the symlinks to the libcrypto.so and libssl.so shared libraries can be created manually.

ln -sf /opt/openssl/lib/hpux32/libcrypto.so /opt/sqlr/4.2/lib/hpux32/libcrypto.so
ln -sf /opt/openssl/lib/hpux64/libcrypto.so /opt/sqlr/4.2/lib/hpux64/libcrypto.so
ln -sf /opt/openssl/lib/hpux32/libssl.so /opt/sqlr/4.2/lib/hpux32/libssl.so

The LD_LIBRARY_PATH environment variable may be used to specify the location of the libcrypto.so library. Otherwise, the version designated in the SQL/R lib directory take precedence.

LDAP Support

The SQL/R LDAP support on HP-UX uses the HP-UX LDAP client. The HP-UX LdapUxClient product must be installed to use the LDAP support.

The LdapUxClient product is used by the sqlrodbc process. Installation is only required on systems running the sqlrodbcd server process.

The LdapUxClient product is part of the "J4269AA: LDAP-UX Client Services" bundle from the HP-UX application DVD or is already installed as part of the HP-UX OE. SQL/R was tested with LdapUxClient version B.04.15.

LDAP-UX Integration is also available from the HPE Software Center web site → https://myenterpriselicense.hpe.com/cwp-ui/free-software/LDAP-UX.

Configuring the Server

Configuring SQL/R startup

Automatic startup of SQL/R servers during boot is configured in the /etc/rc.config.d/sqlr42 configuration file. By default the SQL/R server is started during the HP-UX boot process. Autostart should be disabled when the SQL/R server component is not used (eg. only the ODBC driver is used to access a remote database).

The startup script supports multiple instances and may be configured to not require root access to start or stop the odbcd server. Please refer to the comments in the /etc/rc.config.d/sqlr42 configuration file for details.

Configuring the server

The SQL/R ODBC server is configured with the configuration file odbc.cfg. The configuration file is read by the SQL/R ODBC server when it is started.

The odbc.cfg configuration file is located in the /etc/opt/sqlr/4.2/ directory.

User and Group

The User and Group configuration items in the odbc.cfg specify a user and group that is used to run the SQL/R server process. The default account and group is sqlr.
These options are ignored if the server is not started with root privileges.
A configuration value is required when the server is started with root privileges.

User = sqlr
Group = sqlr

MaxUsers

The MaxUsers configuration item in the odbc.cfg file specifies the maximum number of concurrent processes connecting to the SQL/R ODBC server. The default is 40 simultaneous connections.

MaxUsers = 40