Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Changed: | ||||||||
< < | APPX 4.2.9, PostgreSQL, and UnixODBC on RHEL 5/Scientific Linux 5/Oracle Linux 5/CentOS 5OverviewThis document will demonstrate how to configure APPX 4.2.9 and PostgreSQL on a 64 bit or 32 bit Red Hat 5 based Linux server using 32 bit unixODBC drivers.64 BitInstalling PostgreSQLTo install PostgreSQL, use the package manager to install postgresql and postgresql-server.postgresql.x86_64 : PostgreSQL client programs and libraries. postgresql-server.x86_64 : The programs needed to create and run a PostgreSQL : server. Installing UnixODBCTo install unixODBC, install unixODBC.i386 using the package manager. The 32 bit version is needed, so be sure to specify that when installing it.unixODBC.i386 : A complete ODBC driver manager for Linux. Installing the ODBC ConnectorThe ODBC connector might not be included in the package manager by default. If it is, it would be named something like postgresql-odbc.i386. If not, it can be downloaded and installed from the internet. I went to Scientific Linux's website and found the package in the downloads section. You can download it here, but you may want to look on your distribution's website if you're not using Scientific Linux 5.6. Once the rpm is downloaded, install it with yum to take care of any dependencies automatically. The command is:yum localinstall path-to-file Configuring odbc.ini and odbcinst.iniThe odbcinst.ini file must be configured to point to the 32 bit PostgreSQL ODBC Connector driver. In my testing the default configuration was correct. 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 Database = test Servername = Username = Password = Port = Protocol = 6.4 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = [root@slinux ~]# Configuring appx.envThe appx.env file has a line beginning with APPX_ODBC_LIB, which points to the MySQL UnixODBC Connector driver. It can be remarked out. APPX should not have any trouble locating the driver without it.#APPX_ODBC_LIB=/usr/lib/libmyodbc5.so Testing/Troubleshooting64 BitISQL 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. | |||||||
> > |
Welcome to the APPX-WIKI webWelcome 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:
Sandbox Web Utilities |