OpenLink Single-tier Components (*nix) for MySQL

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

Installation

  1. Log onto the machine and create a suitable OpenLink installation directory <OPENLINK_INSTALL>

  2. Copy all relevant components to <OPENLINK_INSTALL>

    At bare minimum, these will be the OpenLink ODBC Driver for MySQL, OpenLink Http Administration Assistant
    and OpenLink license file.

  3. Install using the "install.sh" shell script --


    #sh install.sh

  4. 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.

  5. The installation should finish without error.

Configuration


Data Souce


Open the file <OPENLINK_INSTALL>/bin/odbc.ini with a suitable text editor such as vi.

Locate and edit the sample OpenLink MySQL? ODBC data source (DSN) created during the installation process and edit as follows--

Sample MySQL 3.x Data Source



 
 [mysql]
 Driver            = <OPENLINK_INSTALL>/lib/mys3_mt_lt.so
 ServerType        = MySQL 3.x
 Options           = -H mysql3.hostname
 Database          = database
 UserName          = mysql
 Password          = **********
 FetchBufferSize   = 99
 ReadOnly          = no
 DeferLongFetch    = no
 JetFix            = no
 Description       = Sample MySQL 3.x Lite Connection

Sample MySQL 4.x Data Source



 
 [mysql]
 Driver            = <OPENLINK_INSTALL>/lib/mys4_mt_lt.so
 ServerType        = MySQL 4.x
 Options           = -H mysql4.hostname
 Database          = database
 UserName          = mysql
 Password          = **********
 FetchBufferSize   = 99
 ReadOnly          = no
 DeferLongFetch    = no
 JetFix            = no
 Description       = Sample MySQL 5.x Lite Connection

Sample MySQL 5.x Data Source



 
 [mysql]
 Driver            = <OPENLINK_INSTALL>/lib/mys5_mt_lt.so
 ServerType        = MySQL 5.x
 Options           = -H mysql5.hostname
 Database          = database
 UserName          = mysql
 Password          = **********
 FetchBufferSize   = 99
 ReadOnly          = no
 DeferLongFetch    = no
 JetFix            = no
 Description       = Sample MySQL 5.x Lite Connection

Testing


Use the iodbctest tool which is packaged with the HTTP-based OpenLink ODBC Administrator as follows --

 
 #cd <OPENLINK_INSTALL>
 #. ./openLink.sh
 # iodbctest mysql
 iODBC Demonstration program
 This program shows an interactive SQL processor
 Driver Manager: 03.52.0507.0105
 Driver: 06.02.1217 OpenLink Generic ODBC Driver (oplodbc.so) 

 SQL>


You should now be able to issue SQL statements directly against the target database.

Additional Information