Resources Available

• APPX User - Resources for users of APPX
• APPX Developer - Resources for Developers who use APPX
• APPX Administrator - Resources for APPX Administrators
• Medicaid Billing - Resources for the Medicaid Payment Reconciliation Application

Main Web Utilities

• WelcomeGuest - for first time visitors
• Registration - become a TWiki user
• Twiki Users - list of users of this TWiki site
• TWikiGroups - list of groups used for access control
• advanced search
• WebTopicList - all topics in alphabetical order
• WebChanges - recent topic changes in this web
• WebNotify - subscribe to an e-mail alert sent when topics change
• WebRss, WebAtom - RSS and ATOM news feeds of topic changes
• WebStatistics - listing popular topics and top contributors
• WebPreferences - preferences of this web

• Online Manuals - A full set of APPX manuals, fully browsable with indexes and hyperlinks
• Special Topics -FAQ's, "How-To" Guides, and general installation, configuration, and operation instructions
• Interactive Support - A message board, email support, and more interactive support options
• Premium Support - Advanced (paid) support options on either an annual or per-incident basis

• LinkHere
• LinkHere
• LinkHere
• LinkHere
• LinkHere

Resources Available:

Welcome to the APPX-WIKI web

Welcome to the APPX Software, Inc. TWiki site. This web site is dedicated to all things APPX.

This web site is intended to be for the benefit of all members of the APPX community. All members of the APPX community are encouraged to contribute to the content of this site. If you see an error, please correct it. If you can't find what you need on this site, please take the time to return and contribute to the content of the site when you do find what you need. Hopefully, the APPX community can collaborate to produce a comprehensive resource covering all aspects of the APPX product.

Resources Available:

• APPXUser - Resources for users of APPX
• APPXDeveloper - Resources for Developers who use APPX
• APPXAdministrator - Resources for APPX Administrators
• APPX 5 - All about APPX 5
• Medicaid Billing - Resources for the Medicaid Payment Reconciliation Application
• Support - Technical support for APPX

Sandbox Web Utilities

APPX 4.2.9, PostgreSQL, and UnixODBC on RHEL 5/Scientific Linux 5/Oracle Linux 5/CentOS 5

Testing/Troubleshooting

64 Bit

ISQL can be used to test the connection between PostgreSQL and unixODBC using the 32-bit ODBC Connector driver. ISQL isn't necessary for APPX to connect to PostgreSQL, but it can be a useful tool for testing the driver APPX will be using. You will need to have the 32-bit ISQL file for it to be a valid test, otherwise it will be testing the 64-bit driver, which is not used in APPX. To find out the bitness of ISQL, run the file command on it. This is how it should look(ELF 32-bit):

[root@slinux bin]# file isql
isql.32: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, stripped
[root@slinux bin]#

If it says ELF 64-bit, the 32 bit version needs to be installed.

APPX 4.2.9, PostgreSQL, and UnixODBC on RHEL 5/Scientific Linux 5/Oracle Linux 5/!CentOS 5

64 Bit

Installing PostgreSQL

postgresql.x86_64 : PostgreSQL client programs and libraries.
postgresql-server.x86_64 : The programs needed to create and run a PostgreSQL
                         : server.

Installing UnixODBC

unixODBC.i386 : A complete ODBC driver manager for Linux.

Installing the ODBC Connector

yum localinstall path-to-file

The odbc.ini file, however, was blank by default. Here is how mine is set up. You'll need to fill in your servername, username, password, and port, along with any other information that may need to be changed to match your system.

[root@slinux ~]# cat /etc/odbc.ini
[postgresql]
Description        = postgresql
Driver             = postgresql
Trace              = Yes
TraceFile          = sql.log

#APPX_ODBC_LIB=/usr/lib/libmyodbc5.so

APPX 4.2.9, MySQL, and UnixODBC on RHEL 6/Scientific Linux 6/Oracle Linux 6/CentOS 6

Installing MySQL

MySQL can be installed with yum by installing the following packages:

mysql.i686 : MySQL client programs and shared libraries
mysql-server.i686 : The MySQL server and related files

Installing unixODBC and the MySQL ODBC Connector

UnixODBC can also be installed using yum by installing the following packages:

unixODBC.i686 : A complete ODBC driver manager for Linux
mysql-connector-odbc.i686 : ODBC driver for MySQL

Configuring odbc.ini and odbcinst.ini

The odbcinst.ini file, found in /etc, must be configured to point to the 32-bit MySQL ODBC Connector driver. I didn't need to make any changes to this file, but if you are unable to connect, make sure the path to the 32-bit driver is correct. For APPX, the path to the 64 bit driver is not important.

[root@localhost ~]# cat /etc/odbcinst.ini
# Example driver definitions

# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description    = ODBC for MySQL
Driver         = /usr/lib/libmyodbc5.so
Setup          = /usr/lib/libodbcmyS.so
Driver64       = /usr/lib64/libmyodbc5.so
Setup64        = /usr/lib64/libodbcmyS.so
FileUsage      = 1
[root@localhost ~]#

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 database 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.

[root@localhost ~]# cat /etc/odbc.ini
[mysql]
Description     = mysql
Driver          = mysql
Server          = localhost
Database        = test
Port            =
Socket          =
Option          =
Stmt            =
[root@localhost ~]#

Configuring appx.env

The appx.env file needs to be configured to point APPX to the 32-bit MySQL ODBC Connector drivers. I didn't have to make any changes to this file when I installed the connector using the package manager. The line beginning with APPX_ODBC_LIB should contain the path to the 32-bit connector driver. It should look something like this:

APPX_ODBC_LIB=/usr/lib/libmyodbc5.so

Installing MySQL

mysql.x86_64 : MySQL client programs and shared libraries
mysql-server.x86_64 : The MySQL server and related files

[root@localhost ~]# isql mysql
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

Installing MySQL

MySQL can be installed with yum by installing the following packages:

mysql.i686 : MySQL client programs and shared libraries
mysql-server.i686 : The MySQL server and related files

Installing unixODBC

UnixODBC can also be installed using yum by installing the following packages:

unixODBC.i686 : A complete ODBC driver manager for Linux
mysql-connector-odbc.i686 : ODBC driver for MySQL

[root@localhost ~]# isql mysql
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

Testing/Troubleshooting

32-bit

64-bit

ISQL can be used to test the connection between MySQL and unixODBC using the 32-bit MySQL ODBC Connector driver. ISQL isn't necessary for APPX to connect to MySQL, but it can be a useful tool for testing the driver APPX will be using. You will need to have the 32-bit ISQL file for it to be a valid test, otherwise it will be testing the 64-bit driver, which is not used in APPX. To find out the bitness of ISQL, run the file command on it. This is how it should look(ELF 32-bit):

[root@localhost ~]# file /usr/bin/isql
/usr/bin/isql: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.18, stripped

If it looks like this(ELF 64-bit), you will need to get the 32-bit version:

[root@localhost ~]# file /usr/bin/isql
/usr/bin/isql: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.18, stripped

Overview

This document will demonstrate how to configure APPX 4.2.9 and MySQL 64 bit on a 64 bit Red Hat based Linux server using 32 bit unixODBC drivers.

APPX 4.2.9, MySQL, and UnixODBC on RHEL 6/Scientific Linux 6/Oracle Linux 6

32-Bit Red Hat/Scientific Linux/Oracle Linux 6

Instructions

64-Bit Red Hat/Scientific Linux/Oracle Linux 6

APPX, MySQL, and UnixODBC will all work under 64-bit Red Hat 6, but because Red Hat is 64-bit and APPX is 32-bit, it will require both the 32-bit and 64-bit MySQL ODBC Connectors, and some additional 32-bit libraries, which can be installed through the package manager.

Installing the ODBC Connectors

The 64-bit ODBC connectors can be installed from the package manager with the command:

yum install mysql-connector-odbc.x86_64

The 32-bit connectors might not be included in the repository. If they are, you would find them under

mysql-connector-odbc.i686

If they are not there, they can be installed with: (You may want to modify this link to match your distro. I was running Scientific Linux 6, so I went to Scientific Linux's site and found the package there.)

yum install http://ftp1.scientificlinux.org/linux/scientific/6.0/i386/os/Packages/mysql-connector-odbc-5.1.5r1144-7.el6.i686.rpm

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. I didn't need to make any changes to this file, but if you are unable to connect, make sure the path to the driver is correct.

[root@localhost etc]# cat odbcinst.ini
# Example driver definitions

# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description    = ODBC for PostgreSQL
Driver         = /usr/lib/psqlodbc.so
Setup          = /usr/lib/libodbcpsqlS.so
Driver64       = /usr/lib64/psqlodbc.so
Setup64        = /usr/lib64/libodbcpsqlS.so
FileUsage      = 1


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description    = ODBC for MySQL
Driver         = /usr/lib/libmyodbc5.so
Setup          = /usr/lib/libodbcmyS.so
Driver64       = /usr/lib64/libmyodbc5.so
Setup64        = /usr/lib64/libodbcmyS.so
FileUsage      = 1
[root@localhost etc]#

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 database 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.

[root@localhost etc]# cat odbc.ini
[mysql]
Description     = mysql
Driver          = mysql
Server          = localhost
Database        = test
Port            =
Socket          =
Option          =
Stmt            =
[root@localhost etc]#

Configuring appx.env

The appx.env file needs to be configured to point APPX to the 32-bit MySQL ODBC Connector drivers. I didn't have to make any changes to this file when I installed the 32-bit connector using the package manager. The line beginning with APPX_ODBC_LIB should contain the path to the 32-bit connector driver. Here is an example, but the path may be different for your system.

APPX_ODBC_LIB=/usr/lib/libmyodbc5.so

Additional 32-bit Libraries

Because APPX is 32-bit, it will need some libraries that aren't found in 64-bit Red Hat by default. They can all be installed through the package manager. APPX will need the glibc, zlib, and libgcc libraries.

yum install glibc-2.12-1.7.el6_0.5.i686 zlib-1.2.3-25.el6.i686 libgcc.i686

Comments:

Read what other users have said about this page or add your own comments.

<--/commentPlugin-->

APPX 4.2.9, MySQL, and UnixODBC on RHEL 6

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# 

APPX 4.2.9, MySQL, and UnixODBC on 64-bit Debian 5

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.

<--/commentPlugin-->

APPX Financials Manuals

Manuals for all of the new APPX Financials are under development, and will be made available here as each one is completed. If the manual you are seeking is not yet available, you may want to refer to the manuals for the old non-graphical applications for reference and an understanding of some basic principles and procedures.

On-line Manuals for New APPX Financials

Accounts Payable	Initial Setup
General Ledger	Initial Setup

Old "T-apps" Manuals

The manuals linked below are for the character-mode APPX Financial Applications (the "T-apps"), and not for the new graphical APPX Financials. These manuals contain obsolete screen shots, and are provided only as a reference for users of the old applications or for others who wish to gain an understanding of the basic workings of the apps. We apologize for any inaccurate or missing information, and we hope and expect to have manuals available shortly for all of the new applications.

Warning!

APPX Software, Inc. does not assert or guarantee that the information contained in these manuals is accurate or relevant to the applications that a given customer may be running. APPX applications are designed to be customized, and any customization will naturally alter the look, operation, and work flow of an application. Furthermore, these manuals are several years old, and have not been reviewed for many years. They are not intended to be a reliable reference source for the new graphical APPX Financials.

• Accounts Payable User Manual
• Accounts Payable System Administration
• Accounts Receivable User Manual
• Accounts Receivable System Administration
• Budget Analysis User Manual
• Commission Accounting User Manual
• Commission Accounting System Administration
• General Ledger User Manual
• General Ledger System Administration
• General Subsidiary User Manual
• General Subsidiary System Administration
• Inventory Control User Manual
• Inventory Control System Administration
• Order Entry User Manual
• Order Entry System Administration
• Purchase Orders User Manual
• Purchase Orders System Administration
• Sales Analysis User Manual
• Sales Analysis System Administration

-- ChrisBrower - 2011-06-06