Learning about Informix and the Open Admin Tool (OAT) - With Tom Beebe - Webcast on Feb 11, 2014

Sep 17, 2026

An overview of Informix Open Admin Tool (OAT) presented by Tom Beebe, including what OAT is, its open-source PHP foundation, and how it enables monitoring and managing Informix instances via a web browser. The session covers supported Informix versions, multiple installation paths (virtual appliance, integration with engine/CSDK, or standalone PHP webserver), and required/recommended PHP modules. It also details OAT stand-alone configuration needs (INFORMIXDIR, matching 32/64-bit binaries) and begins a Linux CLI install workflow with host and security setup, plus an example Apache startup error related to libpcre.

LanguageEnglish

CategoryTechnology

FormatPDF

Pages33

Reading Time1 h 23 min

AccessFree to download

What is OAT?

How to get OAT

Stand Alone Webserver

Stand Alone INFORMIXDIR

Linux CLI Install

Learning about Informix and the Open Admin Tool (OAT) With Tom Beebe Webcast on Feb 11, 2014 Starts at 2pm (EST) What is it? • OAT – Open Admin Tool • Open source, PHP based • Free • Allows you to monitor and manage many aspects of Informix instance(s) through a web browser • Regularly being updated. • Informix version 11.1 and later (some features are only for 11.7 and 12) How do I get it? Three ways to get it – Informix Virtual Appliance – Install it as part of the engine or the CSDK – Install it stand alone on a webserver running PHP • The CSDK version is shipped with Linux Windows and Mac versions. (Some limitations) • The stand alone should work with any OS running awebserver, PHP, and the necessary PHP modules Stand Alone Webserver • Needs to have PHP5 or later • Required PHP Modules – pdo_informix – pdo_sqlite – Soap • Recommended PHP Modules – Gd –Zip • Just unpack the tar or zip file on your server and point your web browser to the directory to start the install. (The webserver will need write access to several of the directories) • The latest stand alone Community Edition version is 3.1.1 • The latest CSDK version is 3.1.2 that includes some bug fixes and json support for IDS12xC2 Stand Alone INFORMIXDIR • Your stand alone Webserver/PHP installation will need to be running with INFORMIXDIR set. • Modify your webserver to add INFORMIXDIR to the environment and $INFORMIXDIR/bin to the PATH env. • Note, the INFORMIXDIR binaries must match (32/64bit) the webserver. • The OAT readme has a good description of how to set this. Linux CLI Install Choose Product Features ENTER A COMMA_SEPARATED LIST OF NUMBERS REPRESENTING THE FEATURES YOU WOULD LIKE TO SELECT, OR DESELECT. TO VIEW A FEATURE'S DESCRIPTION, ENTER'?' . PRESS WHEN YOU ARE DONE: 1- [ ] IBM Informix Client SDK 2- |-[ ] IBM Informix Object Interface for C++ 3- |-[ ] IBM Informix Object Interface for C++ Demos 4- |-[ ] IBM Informix ESQL/C 5- |-[ ] IBM Informix ESQL/C Demos 6- |-[ ] 7.2 Application Compatibility Module 7- |-[ ] IBM Informix LIBDMI for Client Applications 8- |-[ ] IBM Informix ODBC Driver 9- |-[ ] IBM Informix ODBC Driver Demos 10- |-[ ] IBM Informix Common Database Utilities 11- [X] Global Language Support (GLS) 12- |-[X] West European and Americas 13- |-[X] East European and Cyrillic 14- |-[X] Chinese 15- |-[X] Japanese 16- |-[X] Korean 17- |-[X] Thai 18- [X] IBM Informix OpenAdmin Tool 19- |-[X] IBM Informix Replication Plug-in for OpenAdmin Tool 20- |-[X] IBM Informix Schema Manager Plug-in for OpenAdmin Tool 21- |-[X] IBM Informix TimeSeries Plug-in for OpenAdmin Tool 22- |-[X] IBM Informix Health Advisor Plug-in for OpenAdmin Tool 23- |-[X] IBM Informix JSON Plug-in for OpenAdmin Tool Please choose the Features to be installed by this installer.: 1 Linux CLI Install =============================================================================== Host Name --------- Enter the host name for your machine. Host Name: (DEFAULT: ): webmail =============================================================================== Specify Apache Port Number Please specify the port number for the Apache webserver. Specify the port number for the Apache web server. Port Number (DEFAULT: 8080): =============================================================================== Security Features With OAT password protection, only OAT administrators can add and edit connection groups and change OAT configurations. Other users can manage IBM Informix database servers, but they cannot modify connection groups and OAT configurations. Enable OAT Password Protection? (DEFAULT: yes): =============================================================================== OAT Administrator login setup ----------------------------- Enter the user name and password for accessing the OAT Admin pages. User name: (DEFAULT: admin):=============

FAQs

What is OAT and what can it do for Informix instances?

OAT (Open Admin Tool) is an open-source, PHP-based tool that lets users monitor and manage many aspects of one or more Informix instances through a web browser. It is regularly updated.

What are the requirements to run the stand-alone OAT webserver?

The stand-alone webserver must have PHP5 or later and required PHP modules including pdo_informix, pdo_sqlite, and Soap. Gd and Zip are recommended.

How do you prepare a Linux environment for the OAT stand-alone INFORMIXDIR setup?

The webserver/PHP installation must run with INFORMIXDIR set, with INFORMIXDIR/bin added to the PATH environment variable. Ensure the INFORMIXDIR binaries match the webserver architecture (32-bit vs 64-bit).

What does OAT password protection change during administration?

With OAT password protection enabled, only OAT administrators can add/edit connection groups and change OAT configurations. Other users can manage Informix database servers but cannot modify connection groups and OAT configurations.

Sep 17, 2026

Upload by Berry Peter