Tags:
view all tags
%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%
Edit
|
Attach
|
Watch
|
P
rint version
|
H
istory
:
r26
|
r5
<
r4
<
r3
<
r2
|
B
acklinks
|
V
iew topic
|
Raw edit
|
More topic actions...
Topic revision: r3 - 2011-07-01
-
ChrisBrower
Home
Site map
Main web
MedicaidBilling web
Sandbox web
TWiki web
Sandbox Web
Create New Topic
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences
View
Raw View
Print version
Find backlinks
History
More topic actions
Edit
Raw edit
Attach file or image
Edit topic preference settings
Set new parent
More topic actions
Account
Log In
Edit
Attach
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