Difference: SandboxTestPage (3 vs. 4)

Revision 42011-07-05 - ChrisBrower

   Resources Available
   Main Web Utilities
   APPX 5
   New Features in APPX 5.1
   Support
   
 

 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.
->
>
+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 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/.
->
>
+The 32-bit ODBC connectors can be downloaded 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
-<
<
+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.
->
>
+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.
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# 


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.

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#

 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:
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#
-<
<
+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.
->
>
+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
  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.

View topic | History: r26 < r25 < r24 < r23 | More topic actions...