Tags:
tag this topic
create new tag
view all tags
---+ APPX 4.2.9, !MySQL, and !UnixODBC on 64-bit Debian 5 %TOC% APPX, !MySQL, and !UnixODBC will all work under 64-bit Debian, but because Debian is 64-bit and APPX is 32-bit, it will require two sets of drivers and some additional 32-bit libraries. ---++ Installing !MySQL !MySQL client and server can be found in apt-get. The packages are mysql-client and mysql-server. <pre><verbatim>apt-get install mysql-client mysql-server</verbatim> </pre> ---++ Installing !UnixODBC The unixODBC packages you will need are unixodbc, unixodbc-bin, and unixodbc-dev. <verbatim>apt-get install unixodbc unixodbc-bin unixodbc-dev </verbatim> ---++ 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 drivers from the lib directory within it to /emul/ia32-linux/lib/. ---++ Configuring odbc.ini and odbcinst.ini The odbcinst.ini file, found in /etc, must be configured to point to the 64-bit !MySQL ODBC Connector driver, which was placed in /usr/lib/odbc. Here's an example of what it should look like, but check your system to make sure the path to the driver is correct. <pre><verbatim>debian-64:/usr/local/appx.429# cat /etc/odbcinst.ini #[MySQL ODBC 5.1 Driver] [mysql] Driver = /usr/lib/odbc/libmyodbc5.so UsageCount = 1 debian-64:/usr/local/appx.429# </verbatim> </pre> The odbc.ini file is another one that may need to be configured. It is also found in /etc. Make sure all the information there is correct. The databse should match the database you are trying to connect to. Here's an example of what this file should look like, but check to make sure it is correct for your system. <verbatim>debian-64:/usr/local/appx.429# cat /etc/odbc.ini [mysql] Description = mysql Driver = mysql Server = localhost Database = test Port = Socket = Option = Stmt = debian-64:/usr/local/appx.429#</verbatim> ---++ Configuring appx.env The appx.env file needs to be configured to point APPX to the 32-bit !MySQL ODBC Connector drivers. To do this, open up the file, located in the data directory of APPX, and edit the APPX_ODBC_LIB line to point to the 32-bit driver that was placed in /emul/ia32-linux/lib. It should look something like this: <pre><verbatim> APPX_ODBC_LIB=/emul/ia32-linux/lib/libmyodbc5.so </verbatim> </pre> ---++ Additional 32-bit Libraries Because APPX is 32-bit, it will need some libraries that aren't found in 64-bit Debian by default. They can be copied from the /lib and /usr/lib directories of a 32-bit installation or 32-bit live cd of Debian. Copy them into the /emul/ia32-linux/lib/ directory of your 64-bit Debian install. Here's a list of all the libraries APPX will need to work properly: * 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 ---++ Comments: _Read what other users have said about this page or add your own comments._ --- <br />%COMMENT%
E
dit
|
A
ttach
|
Watch
|
P
rint version
|
H
istory
: r3
<
r2
<
r1
|
B
acklinks
|
V
iew topic
|
Ra
w
edit
|
M
ore topic actions
Topic revision: r3 - 2016-02-12
-
JeanNeron
Home
Site map
Main web
MedicaidBilling web
Sandbox web
TWiki web
Main Web
Users
Groups
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences
P
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
E
dit
A
ttach
Copyright © 2008-2025 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback