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.