Difference: SandboxTestPage (6 vs. 7)

Revision 72011-07-07 - JoeOrtagus

Line: 1 to 1
 

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

Added:
>
>

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

Line: 9 to 12
 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

Changed:
<
<		The 64-bit ODBC connectors can be installed from the package manager with the command: 
yum install mysql-connector-odbc.x86_64

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

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

Line: 21 to 20
 

Configuring odbc.ini and odbcinst.ini

Changed:
<
<		The odbcinst.ini file, found in /etc, must be configured to point to the 64-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.
>
>		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
Deleted:
<
<		# Driver from the postgresql-odbc package # Setup from the unixODBC package [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/psqlodbc.so Setup = /usr/lib/libodbcpsqlS.so Driver64 = /usr/lib64/psqlodbc.so Setup64 = /usr/lib64/libodbcpsqlS.so FileUsage = 1
  # Driver from the mysql-connector-odbc package # Setup from the unixODBC package
Line: 42 to 31
 Description = ODBC for MySQL Driver = /usr/lib/libmyodbc5.so Setup = /usr/lib/libodbcmyS.so
Changed:
<
<		Driver64 = /usr/lib64/libmyodbc5.so Setup64 = /usr/lib64/libodbcmyS.so
>
>		#Driver64 = /usr/lib64/libmyodbc5.so #Setup64 = /usr/lib64/libodbcmyS.so
 FileUsage = 1 [root@localhost etc]#
View topic | History: r26 < r25 < r24 < r23 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback