APPX 4.2.9, MySQL, and UnixODBC on RHEL 6/Scientific Linux 6/Oracle Linux 6

Overview

This document will demonstrate how to configure APPX 4.2.9 and MySQL 64 bit on a 64 bit Red Hat based Linux server using 32 bit unixODBC drivers.

32-Bit Red Hat/Scientific Linux/Oracle Linux 6

Instructions

64-Bit Red Hat/Scientific Linux/Oracle Linux 6

APPX, MySQL, and UnixODBC will all work under 64-bit Red Hat 6, but because Red Hat is 64-bit and APPX is 32-bit, it will require both the 32-bit and 64-bit MySQL ODBC Connectors, and some additional 32-bit libraries, which can be installed through the package manager.

Installing the ODBC Connectors

The 32-bit connectors might not be included in the repository. If they are, you would find them under a name like

mysql-connector-odbc.i686

If they are not there, they can be installed with: (You may want to modify this link to match your distro. I was running Scientific Linux 6, so I went to Scientific Linux's site and found the package there.)

yum install http://ftp1.scientificlinux.org/linux/scientific/6.0/i386/os/Packages/mysql-connector-odbc-5.1.5r1144-7.el6.i686.rpm

Configuring odbc.ini and odbcinst.ini

The odbcinst.ini file, found in /etc, must be configured to point to the 32-bit MySQL ODBC Connector driver. I didn't need to make any changes to this file, but if you are unable to connect, make sure the path to the driver is correct.

[root@localhost etc]# cat odbcinst.ini
# Example driver definitions


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description    = ODBC for MySQL
Driver         = /usr/lib/libmyodbc5.so
Setup          = /usr/lib/libodbcmyS.so
#Driver64       = /usr/lib64/libmyodbc5.so
#Setup64        = /usr/lib64/libodbcmyS.so
FileUsage      = 1
[root@localhost etc]#

The odbc.ini file is another one that may need to be configured. It is also found in /etc. Make sure all the information there is correct. The database should match the database you are trying to connect to. Here's an example of what this file should look like, but check to make sure it is correct for your system.

[root@localhost etc]# cat odbc.ini
[mysql]
Description     = mysql
Driver          = mysql
Server          = localhost
Database        = test
Port            =
Socket          =
Option          =
Stmt            =
[root@localhost etc]#

Configuring appx.env

The appx.env file needs to be configured to point APPX to the 32-bit MySQL ODBC Connector drivers. I didn't have to make any changes to this file when I installed the 32-bit connector using the package manager. The line beginning with APPX_ODBC_LIB should contain the path to the 32-bit connector driver. Here is an example, but the path may be different for your system.

APPX_ODBC_LIB=/usr/lib/libmyodbc5.so

Additional 32-bit Libraries

Because APPX is 32-bit, it will need some libraries that aren't found in 64-bit Red Hat by default. They can all be installed through the package manager. APPX will need the glibc, zlib, and libgcc libraries.

yum install glibc-2.12-1.7.el6_0.5.i686 zlib-1.2.3-25.el6.i686 libgcc.i686

Comments:

Read what other users have said about this page or add your own comments.