%TOC% ---+ 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 [[http://mysql.mirrors.hoobly.com/Downloads/Connector-ODBC/5.1/mysql-connector-odbc-5.1.8-linux-glibc2.3-x86-64bit.tar.gz][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 [[http://mysql.mirrors.hoobly.com/Downloads/Connector-ODBC/5.1/mysql-connector-odbc-5.1.8-linux-glibc2.3-x86-32bit.tar.gz][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* <br /> #[MySQL ODBC 5.1 Driver]<br /> [mysql]<br /> #Driver = /usr/lib/libmyodbc5.so<br /> Driver = /usr/lib/odbc/libmyodbc5.so<br /> !UsageCount = 1 debian-64:/usr/local/appx.429# <strong>cat /etc/odbc.ini</strong><br /> [mysql]<br /> Description = mysql<br /> Driver = mysql<br /> Server = localhost<br /> Database = test<br /> Port =<br /> Socket =<br /> Option =<br /> 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<br /> <strong>APPX_ODBC_LIB=/emul/ia32-linux/lib/libmyodbc5.so</strong><br /> #APPX_SQL_CMD=/usr/local/appx.429/appx_sql_cmd.txt<br /> #APPX_DBG_CODE=0xFFFFFFFF<br /> ###############################################################################<br /> #<br /> # APPX Configuration File<br /> # -----------------------<br /> #<br /> # This file can be used to configure your APPX environment. Upon startup, <br /> 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._ --- %COMMENT%
This topic: Sandbox
>
SandboxTestPage
Topic revision: r3 - 2011-07-01 - ChrisBrower
Copyright © 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