Difference: SandboxTestPage (7 vs. 8)

Revision 82011-07-08 - ChrisBrower

Line: 1 to 1
 

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

Overview

Changed:
<
<		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.
>
>		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

Deleted:
<
<

Instructions

 

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

Changed:
<
<		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.
>
>		APPX can connect to 64-bit MySQL using 32-bit ODBC connector drivers and some 32-bit libraries that 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

Line: 20 to 19
 

Configuring odbc.ini and odbcinst.ini

Changed:
<
<		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.
>
>		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 32-bit driver is correct.
 
[root@localhost etc]# cat odbcinst.ini
# Example driver definitions
Line: 59 to 58
 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
Added:
>
>

Testing/Troubleshooting

32-bit

64-bit

ISQL can be used to test the connection between MySQL and unixODBC using the 32-bit MySQL ODBC Connector driver. ISQL isn't necessary for APPX to connect to MySQL, but it can be a useful tool for testing the driver APPX will be using. You will need to have the 32-bit ISQL file for it to be a valid test, otherwise it will be testing the 64-bit driver, which is not used in APPX. To find out the bitness of ISQL, run the file command on it. This is how it should look(ELF 32-bit): 

[root@localhost ~]# file /usr/bin/isql
/usr/bin/isql: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.18, stripped

If it looks like this(ELF 64-bit), you will need to get the 32-bit version: 

[root@localhost ~]# file /usr/bin/isql
/usr/bin/isql: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.18, stripped
 

Comments:

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

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