APPX 4.2.9, MySQL, and UnixODBC on 64-bit Debian 5

APPX, MySQL, and UnixODBC will all work under 64-bit Debian, but because the OS is 64-bit and APPX is 32-bit, it will require two sets of drivers and some additional 32-bit libraries. Isql will only work with the 64-bit MySQL UnixODBC connector drivers, and APPX will only work with the 32-bit ones.

Installing the ODBC Connectors

The 64-bit ODBC connectors can be downloaded here. Untar the bundle and copy the drivers from the lib directory within it to /usr/lib/odbc/.

The 32-bit ODBC connectors can be downloaded here. Untar that bundle as well and copy the contents of the lib directory within it to /emul/ia32-linux/lib/.

Configuring odbc.ini and odbcinst.ini

Configured like this, the system will be able to make use of UnixODBC, but you will need to point APPX specifically to the 32-bit driver.

debian-64:/usr/local/appx.429# cat /etc/odbcinst.ini
#[MySQL ODBC 5.1 Driver]
[mysql]
#Driver = /usr/lib/libmyodbc5.so
Driver = /usr/lib/odbc/libmyodbc5.so
UsageCount = 1

debian-64:/usr/local/appx.429# cat /etc/odbc.ini
[mysql]
Description = mysql
Driver = mysql
Server = localhost
Database = test
Port =
Socket =
Option =
Stmt =

Pointing APPX to the 32-bit Driver

Open appx.env and configure it so that APPX is pointed to the driver located in /emul/ia32-linux/lib

debian-64:/usr/local/appx.429# head /usr/local/appx.429/data/appx.env
APPX_ODBC_LIB=/emul/ia32-linux/lib/libmyodbc5.so
#APPX_SQL_CMD=/usr/local/appx.429/appx_sql_cmd.txt
#APPX_DBG_CODE=0xFFFFFFFF
###############################################################################
#
# APPX Configuration File
# -----------------------
#
# This file can be used to configure your APPX environment. Upon startup,
debian-64:/usr/local/appx.429#

Additional 32-bit Libraries

Now, APPX will need some additional libraries that aren't found in 64-bit Debian 5 by default. They can be copied from the /lib and /usr/lib directories from a 32-bit installation of Debian 5. Here is a list of the libraries you will need. Copy them into your /emul/ia32-linux/lib/ directory.

  • libgcc_s.so.1
  • libltdl.a
  • libltdl.la
  • libltdl.so
  • libltdl.so.3
  • libltdl.so.3.1.6
  • libodbcinst.so.1
  • libz.so.1
  • libz.so.1.2.3.3

After everything is configured, it should all be working.

Comments:

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


Edit | Attach | Watch | Print version | History: r26 | r5 < r4 < r3 < r2 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r3 - 2011-07-01 - ChrisBrower
 
  • Edit
  • Attach
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