ODBC for Unix Installation Instructions

Server Installation on HP-UX

Prerequisites

You will need:

1. Eloquence B.08.20 (please install Patch PE82-1404140 or later)

Server

1. Place all files in the /opt/minisoft directory. Be sure that the directory is readable and executable from public.
2. Create a symbolic link to your system specific Eloquence library. Choose the ONE best library that matches your HPUX system.

   /opt/eloquence8.2/lib/pa11_32/libimage3k.sl
    /opt/eloquence8.2/lib/hpux32/libimage3k.sl
    /opt/eloquence8.2/lib/hpux64/libimage3k.sl
    /opt/eloquence8.2/lib/pa20_32/libimage3k.sl
    /opt/eloquence8.2/lib/pa20_64/libimage3k.sl

   If you have an Itanium system, use:
    ln -s /opt/eloquence8.2/lib/hpux32/libimage3k.sl \
    /usr/lib/hpux32/libimage3k.sl

   If you have a newer PA-RISC system, use:
    ln -s /opt/eloquence8.2/lib/pa20_32/libimage3k.sl \
    /usr/lib/libimage3k.sl

3. Append the following to your /etc/inetd.conf file:#

    # odbcsrvr.exe

    #

    odbcsrvr stream tcp nowait root /opt/minisoft/odbcsrvr.exe odbcsrvr.exe /S

    #

    # odbcsrvr.exe with trace enabled

    #

    #odbcsrvr stream tcp nowait root /opt/minisoft/odbcsrvr.exe odbcsrvr.exe /S /T

4. Append the following to your /etc/services file:

   #
   #
   Minisoft odbcsrvr.exe
   #
   odbcsrvr 30006/tcp

    oledbsrv 30009/tcp

    jdbcsrvr 30007/tcp

5. Append the following to your /etc/pam.conf file:#

    # PAM configuration

    #

    odbcsrvr.exe auth required /usr/lib/security/libpam_unix.1

    odbcsrvr.exe account optional /usr/lib/security/libpam_unix.1

    odbcsrvr.exe password required /usr/lib/security/libpam_unix.1

    #

    jdbcsrvr.exe auth required /usr/lib/security/libpam_unix.1

    jdbcsrvr.exe account optional /usr/lib/security/libpam_unix.1

    jdbcsrvr.exe password required /usr/lib/security/libpam_unix.1

    #

    oledbsrv.exe auth required /usr/lib/security/libpam_unix.1

    oledbsrv.exe account optional /usr/lib/security/libpam_unix.1

    oledbsrv.exe password required /usr/lib/security/libpam_unix.1

    #

6. For sam to work without error, append /opt/minisoft to the end of (/var/sam/ts/pam_dir.reg).
7. Report the System ID and System Name (see license.exe below) to your Minisoft sales office. Follow the directions returned to license the product.
8. Restart inetd using the command:

    #inetd -c

license.exe

Please report the value from this utility so that a License Number can be generated for your system.

This is a HP-UX (11) executable.  Place it in the directory “/opt/minisoft”. When run, it should display the System ID and System Name:

# /opt/minisoft/license.exe
 System ID = [541750568]
 System Name = [HP-UX B.11.00 9000/800]
 Use one of the following parameters:
 1 - View license information
 2 - License a product
 5 - Create license file
 6 - View license for a product
 #

Send this information to your Minisoft sales representative. When you receive your reply, follow the following directions:

1. Create an empty license file:

    #cd /opt/minisoft

    #touch MSLICFIL

    #./license.exe 5 "your company name"

2. Execute /opt/minisoft/license.exe with the parameters as supplied in the reply.

Troubleshooting a connection

If you are having problems, follow these steps:

1. From a terminal logon as root
2. cd /opt/minisoft
3. ./odbcsrvr.exe /T /P:3333
4. Create/Modify a DSN to use port 3333
5. Start a connection using this DSN
6. Stop odbcsrvr using Control-C
7. look for file with the name odbcjdbc.#.log in the current directory.

The log files will provide details about what is happening during the connection process. If the problem are not resolved after reviewing these files, please tar and send them to support@minisoft.com.