OpenAdmin Tool for IDS, the PHP-based administration console for IDS, is now available for downloadfrom the Open Source download site.
Updated 2/14/08 with new recommended PHP and XAMPP versions which are good for Cheetah and Cheetah 2.
Note: This article is based upon the “Installing IDSAdmin in a Windows XAMPP environment” article by Guy Bowerman and Inge Halilovic. The Windows version of this article is available on the IBM IDS Experts Blog.
Installation of OpenAdmin can appear complex - this article provides anexample of one way of installing OpenAdmin. This example uses an XAMPP package on Linux. XAMPP is a bundle of open-source utilities (such as Apache, PHP and PEAR) thatare used by OpenAdmin. Installing XAMPP simplifies the OpenAdmin install,but many other installation and configuration options are possible.
High-level Summary of Install steps
Detailed steps are provided below. This is the high-level sequence of stepsyou will follow:
- Install CSDK 3.00.UC1 (or later)
- Download and extract the XAMPP 1.6.4 runtime package and development package
- Download and extract PDO_INFORMIX 1.1.0
- Configure PDO_INFORMIX
- Update the php configuration file
- Download and extract the OpenAdmin package
- Start the Apache web server
- Install and configure OpenAdmin
If not already installed, install the Informix Client SDK and set INFORMIXDIR in your environment to be the location where CSDK is installed. (Note: CSDK 3.00.UC1 or later is recommended.)
To install Informix CSDK, extract the product files and run as root installclientsdk. Follow the instructions on screen to install CSDK.
Important: Even if you are installing on a Linux-x86_64 machine, you will need a Linux 32-bit version of Informix CSDK. This is because Linux XAMPP is a 32-bit build; so to build a compatible PDO_INFORMIX module, you will need the Linux 32-bit version of Informix CSDK.2. Download XAMPP and extract files.
- Download both the Linux XAMPP Runtime Package version 1.6.4 ( http://www.apachefriends.org/download.php?xampp-linux-1.6.4.tar.gz) and the Linux XAMPP Development Package version 1.6.4 ( http://www.apachefriends.org/download.php?xampp-linux-devel-1.6.4.tar.gz) to a temporary location
Important: You must download both the Linux runtime and development packages; the development package is necessary in order to be able to compile the PDO_INFORMIX driver.
- To install, all you need to do is untar both XAMPP packages in the /opt directory. (If you do not want to install directly in the /opt directory, you can create a symbolic link which links /opt/lampp to the directory you choose for installation.)
tar xvfz xampp-linux-1.6.4.tar.gz –C /opttar xvfz xampp-linux-devel-1.6.4.tar.gz –C /opt
- Now XAMPP is installed in the /opt/lampp directory
3. Download and extract PDO_INFORMIX
- Download the PDO_INFORMIX driver version 1.1.0 (http://pecl.php.net/get/PDO_INFORMIX-1.1.0.tgz) to a temporary location.
- Untar the PDO_INFORMIX tar file into the /opt/lampp/lib/php/extensions directory.
tar xvfz PDO_INFORMIX-1.1.0.tgz –C /opt/lampp/lib/php/extensions
4. Configure PDO_INFORMIX
- Set INFORMIXDIR in your environment to the directory where Informix Client SDK is installed.
- Make sure your PATH is set so that the php and phpize executables are picked up from the /opt/lampp/bin directory. If you have another version of PHP installed and your PATH is not set correctly to pick up php from /opt/lampp/bin, you may get errors when executing make for PDO_INFORMIX due to version incompatibility.
- Important: If you are installing on a Linux-x86_64 machine, you also need to set CFLAGS in your environment to “-m32”. This is because XAMPP for Linux is a 32-bit build and therefore you will need to compile PDO_INFORMIX into a 32-bit shared object file instead the default 64-bit version. This also means that the version of Informix CSDK must be the Linux 32-bit version.
- To configure the PDO_INFORMIX module, execute the following 5 commands:
cd /opt/lampp/lib/php/extensions/PDO_INFORMIX-1.1.0/opt/lampp/bin/phpize./configuremakemake install
Example output for these commands are shown below.
Sample output after the “/opt/lampp/bin/phpize” command:
Sample output after the “./configure” command:
Sample output after the "make” and “make install” commands:
- After executing “make install”, verify that pdo_informix.so was copied into your extension directory /opt/lampp/lib/php/extensions/no-debug-non-zts-20060613/
Note: For more information about building the PDO_INFORMIX module, go to the DeveloperWorks article on that topic.
5. Update the php configuration file (php.ini)
Navigate to the /opt/lampp/etc directory, and open the php.ini file in a text editor.
Edit php.ini to enable the Informix PDO driver:
- Locate the “Dynamic Extensions” section in the php.ini file and add the pdo_informix extension.
- Modify the memory_limit parameter to be at least 256M.
Memory_limit = 256M
6. Download and Extract the OpenAdmin tar file in the htdocs directory.
- Download the OpenAdmin tar file from the Open Source download site to a temporary location.
- Create a new directory under /opt/lampp/htdocs to contain the OpenAdmin Tool files (For example: /opt/lampp/htdocs/openadmin)
- Untar oatids.tar to this new directory.
- Within the OpenAdmin directory, grant write permissions to the conf and install directories and all of their contents.
cd /opt/lampp/htdocs/openadminchmod ugo+w install conf -R
7. Start the Apache web server.
- Verify INFORMIXDIR is set to the Informix CSDK directory.
- Start the web server by running /opt/lampp/lampp start as root.
You should see output similar to the following:
Starting XAMPP for Linux 1.6.4...XAMPP: Starting Apache with SSL (and PHP5)...XAMPP: Starting MySQL...XAMPP: Another FTP daemon is already running.XAMPP for Linux started.
Using a web browser, go to http://< machine_name >/openadmin/install where < machine_name > is the name of the machine where you have installed the products. Follow the installation instructions to install OpenAdmin Tool. After the first install screen a check will be made to ensure you have the correct PDO drivers:
Enter the base URL for your machine, language defaults, and optionallythe Google maps key for your machine URL:
8. Start using OpenAdmin
Once installation is complete you can go to the main page (http://< machine_name >/openadmin in this example), click Admin and start adding IDS 11.10 connections. Important: If you are using a version of CSDK prior to 3.00.UC1, there must be aSQLHOSTS entry on the web server machine for each connection you add .
Once a connection is defined you can return to the main screen and connect:
The connection administration allows you to create groups of connections, and assign a password for each group, making it easier to administer a large number of instances.
Erika Von Bargen