The OpenAdmin Tool (OAT) for IDS is a PHP-based console used to administer one or more instances of IBM® Informix® Dynamic Server Version 11.10 or later.
These files are available to download:
Download | Description |
---|---|
OAT_2.27_install_windows.exe | OpenAdmin Tool for IDS automated installer for Windows®. Includes OAT, the ER plug-in, the Schema Manager plug-in, and all necessary software to run OAT, including pre-configured Apache, PHP, PDO_informix, and Informix I-Connect. |
OAT_2.27_install_linux.bin | OpenAdmin Tool for IDS automated installer for Linux®. Includes OAT, the ER plug-in, the Schema Manager plug-in, and all necessary software to run OAT, including pre-configured Apache, PHP, PDO_informix, and Informix I-Connect. |
OAT_2.27_install_macOSX64.zip | OpenAdmin Tool for IDS automated installer for Mac OS X 64-bit. Includes OAT, the ER plug-in, the Schema Manager plug-in, and all necessary software to run OAT including pre-configured Apache, PHP, PDO_informix, and Informix I-Connect. |
oatidsV2.27.tar | OpenAdmin Tool for IDS packaged as a tar file. Includes the ER plug-in and the Schema Manager plug-in. Does not include Apache, PHP, PDO_informix, or Informix I-Connect. |
oatidsV2.27.zip | OpenAdmin Tool for IDS packaged as a compressed file. Includes the ER plug-in and the Schema Manager plug-in. Does not include Apache, PHP, PDO_informix, or Informix I-Connect. |
README.html | Instructions on how to install. (This document.) |
RELEASENOTES.html | New features and fixed defects for the release. |
The automated install for OpenAdmin Tool is available for Windows, Linux, and Mac OS X (64-bit only).
The following products are installed on your machine during the automated installation:
The automated install extracts a copy of the JRE into your installation directory. The JRE is used only for the automated install and uninstall of OpenAdmin Tool and can be deleted when the installation is complete. The JRE has no impact on the function of OpenAdmin Tool or any of the applications it relies on. However, to use the automated uninstall program, you must reinstall the JRE (minimum JRE 1.4.2).
The PHP and Apache that come with OpenAdmin Tool automated installer have only a limited set of modules. If you want to do other development work with OpenAdmin Tool PHP, you might have to download the other extensions. The available modules for PHP and Apache are described in table Table 2.
Operating System | PHP Modules | Apache Modules |
---|---|---|
Windows and Linux |
|
|
Windows only |
|
|
On Windows, the following prerequisites must be met for the automated install:
On Linux and Mac OS X, the following libraries must be installed in /lib/ or /usr/lib/ for the automated install:
Use this procedure only if you used the automated installation procedure.
To uninstall OpenAdmin Tool:
Prerequisite: To manually install OpenAdmin Tool for IDS, you must have working knowledge of Web servers and PHP. If you do not have this knowledge, you might need assistance from a Web server administrator in your organization.
The OpenAdmin Tool is platform independent. You can install and run the OpenAdmin Tool on any operating system for which you can set up and run the prerequisites listed in this section.
The OpenAdmin Tool requires the following products to be installed. The versions in parenthesis indicate the versions with which the OpenAdmin Tool has been tested.
Important: The PHP and the PDO must come from the same PHP version.
For further help, consult the Web server product documentation for installation instructions, or contact the product customer service representatives for assistance.
If you are using XAMPP:
If you are not sure about the location of the correct php.ini configuration file, run the phpinfo() command within a PHP script on your Web server to determine the location of the correct php.ini file.
Important: These lines must follow the extension=php_pdo.dll.
Important: For security reasons, set password protection for the OpenAdmin Tool administration Web pages. For more information and an example, see "Providing password protection for the Admin configuration pages: Apache example" in the OpenAdmin Tool for IDS Help.
The syntax for changing the ownership and permissions is:
chown <user>:<OATINSTALL>; chmod +w <OATINSTALL>;
Where <OATINSTALL> is the root directory for OpenAdmin Tool, the same directory that you used in step 4.
If you started the Web server before modifying the php.ini file or setting INFORMIXDIR in the environment, restart the Web server for the changes to take effect.
Where:
For example: http://localhost/oat/install
Important: For security purposes, specify a secure directory for the connections.db file. Do not use the Web server document root directory. Additionally, ensure that the directory in which the connections.db file is located is accessible by the user who runs Apache.
For example: http://localhost:8080/OAT
If you are using an I-Connect or Client SDK version before V3.0, for each new connection that you add, ensure that there is a corresponding SQLHOSTS entry for that connection on the Web server machine.
To connect to a server, after a connection is created, click Login. Click Get Servers to retrieve the list of connections that you have created, and then select the server.
To manually uninstall OpenAdmin Tool, delete the OATINSTALL directory.
If you are using the high availability clusters (MACH) features from OpenAdmin Tool to start and stop secondary servers or to add SD secondary servers, you must configure the following daemons on the IDS server:
Prerequisite: IDS Version 11.50.xC1 and later is required to use idsd. Also, idsd is not currently available on Mac OS X or Windows. Without idsd, OAT’s high availability cluster management (MACH) interface is available, but the feature set is limited.
To upgrade to OpenAdmin Tool 2.27 from a previous version:
You can add plug-ins created by IBM or by other organizations to the OpenAdmin Tool. Plug-ins created by IBM are included in the automated and manual installations for OAT. For instructions on adding a plug-in from another organization, see the OpenAdmin Tool for IDS Help.
The following section provides additional information about configuring the OpenAdmin Tool and other support resources.
Set the CSDK/I-Connect variables INFORMIXCONRETRY and INFORMIXCONTIME to avoid page timeout errors for invalid connection information. The recommended settings are:
For manual installation, XAMPP is an easy-to-install Apache distribution containing MySQL, PHP, and Perl. You can download XAMPP from the following Web site: http://www.apachefriends.org/en/xampp.html.
For more detailed instructions on how to install OpenAdmin Tool for IDS by using XAMPP, refer to the following articles:
The following developerWorks® article contains useful information to assist with building an Informix PDO driver: A step-by-step how-to guide to install, configure, and test a Linux, Apache, Informix, and PHP server.
Table 3 describes the minimum version requirements for products that the OpenAdmin Tool uses:
Product | Version |
---|---|
Mozilla Firefox Web browser (Recommended) | 2.0 |
Microsoft® Internet Explorer Web browser | 7.0 |
Apple Safari Web browser | 3.0.2 |
IBM Informix Database Server | 11.10 |
PHP | 5.2.4 |
Adobe Flash Player | 9.0.115.0 |
Forums are the only support mechanism for OpenAdmin Tool for IDS. To ask questions, exchange ideas, and share solutions with your peers in the Informix Dynamic Server community, visit the following forums:
This information was developed for products and services offered in the U.S.A.
IBM may not offer the products, services, or features discussed in this document in all countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user’s responsibility to evaluate and verify the operation of any non-IBM product, program, or service.
IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:
IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A.
For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:
Intellectual Property Licensing Legal and Intellectual Property Law IBM Japan Ltd. 1623-14, Shimotsuruma, Yamato-shi Kanagawa 242-8502 Japan
The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.
This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.
Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.
IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.
Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact:
IBM Corporation J46A/G4 555 Bailey Avenue San Jose, CA 95141-1003 U.S.A.
Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.
The licensed program described in this information and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us.
Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.
Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.
All statements regarding IBM’s future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.
All IBM prices shown are IBM’s suggested retail prices, are current and are subject to change without notice. Dealer prices may vary.
This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.
This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. The sample programs are provided "AS IS", without warranty of any kind. IBM shall not be liable for any damages arising out of your use of the sample programs.
Each copy or any portion of these sample programs or any derivative work, must include a copyright notice as follows:
If you are viewing this information softcopy, the photographs and color illustrations may not appear.
IBM, the IBM logo, and ibm.com® are trademarks or registered trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at “Copyright and trademark information" at http://www.ibm.com/legal/copytrade.shtml.
Adobe, the Adobe logo, and PostScript® are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States, and/or other countries.
Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.
Microsoft, Windows, and Windows NT® are trademarks of Microsoft Corporation in the United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Other company, product, or service names may be trademarks or service marks of others.
© Copyright IBM Corp. 2007, 2009