OpenAdmin Tool (OAT) for Informix

You can use the OpenAdmin Tool (OAT) graphical-user interface to administer Informix®. How OAT is configured is dependent on the virtualization environment you are using.

If your virtual appliance is installed as a VMware image, follow the instructions here: Configuring OAT for VMware environments.

If your virtual appliance is installed in a cloud environment, refer to the instructions here: Configuring OAT for cloud environments.

Several PHP files for OAT are included with the Informix Virtual Appliance. If you want to modify the files, they are located in various directories under the following directory: 
/opt/IBM/OpenAdmin/OAT/Apache_version/htdocs
Substitute the correct Apache version number that is supplied with your Informix Virtual Appliance for the version in the previously shown path. Also included are PHP examples that work with the cluster demonstration instances that can be found in the following directory:

http://localhost/openadmin

If you are using a version of the Informix Virtual Appliance that supports high-availability clusters, you can create the cluster environment by running the createC1Cluster script.

Configuring OAT for VMware environments

If your virtual appliance is installed as a VMware image, use the following configuration information:
  1. Click this link to access OAT:

    http://localhost/openadmin

  2. In the Quick Login section, click Get Servers, choose the demo_on instance in the Select a Connection box, and click Login.
The following server details are completed automatically:
Table 1. OAT login information
Field Value
Informix Server demo_on
hostname informixva
Port 9088
User informix
Password informix

Installing the missing plugin (VMware images only)

The first time that you access an OAT page that requires the Adobe Flash Player plugin, you might receive a message that indicates that more plugins are required to display all the media on the page. If you receive the message, follow these steps to install the missing plugin. Internet connectivity is required to download the plugin.

  1. Click Install Missing Plugins.
  2. Click Next when the Plugin Finder Service window is displayed.
  3. Click I agree then click Next to accept the license agreement.
  4. If you receive a message that indicates that no plugins were installed, then click Manual Install.
    • For 32-bit versions of the Informix Virtual Appliance:

      In the Firefox window, select .tar.gz from the dropdown list and then click Agree and install now.

    • For 64-bit versions of the Informix Virtual Appliance:

      In the Firefox window, select and download the 64-bit version of the plugin, specifying the .tar.gz format.

  6. When asked whether to Open or Save the file, select Save File and click OK.
  7. Open a terminal window and log on as root.
  8. Change to the download directory:
    cd $HOME/Downloads
  9. Uncompress the file:
    tar -zxvf flash_player_filename.tar.gz
  10. Change the permissions on the plugin:
    chmod +x libflashplayer.so
  11. Copy the uncompressed file to the correct plugin directory:
    • For 32-bit versions of the Informix Virtual Appliance:
      cp libflashplayer.so /usr/lib/browser-plugins
    • For 64-bit versions of the Informix Virtual Appliance:
      cp libflashplayer.so /usr/lib64/browser-plugins
  12. Close all Firefox sessions and restart Firefox.

OAT configuration (VMware images only)

The single demonstration instance demo_on belongs to the Default connection group.

OAT is pre-configured as follows:

  • There is no OAT Group password.
  • The demo_on instance is in the Default group.
  • An OAT Group C1Cluster was created. All cluster demonstration instances are in this OAT Group. The cluster demonstration instances are:
    • c1primary
    • c1hdr1
    • c1sds1
    • c1sds2
    • c1rss1
    • c1rss2

Configuring OAT for cloud environments

If you are using the HCL Informix Virtual Appliance in a cloud environment, such as the IBM® Smart Business Development and Test Cloud environment, OAT must be configured for the cloud environment.

The following steps assume that a cloud instance is provisioned, that you generated and saved a copy of your key, and that you know the IP address or the public DNS name of your instance.

To configure OAT:

  1. Start the OAT by opening a browser and navigating to:
    http://public_name:your_port/openadmin
    where public_name is the IP address or the public DNS name of your HCL Informix Virtual Appliance instance.
  2. Use the following server details to log-in to OAT:
    • Informix Server: demo_on
    • Host Name: public_name
    • Port: 9088
    • Username: informix
    • Password: Your informix password

Installing the missing plugin (cloud images only)

The first time that you access an OATpage that requires the Adobe Flash Player plugin, you might receive a message that additional plugins are required to display all the media on the page. If you receive the message, install the Adobe Flash Player plugin. See the instructions provided by the software manufacturer for installation on specific platforms.

High-availability cluster demonstration for cloud environments

If you are using a version of the Informix Virtual Appliance that supports high-availability clusters, you can use OAT to view the cluster configuration. In the following example, public_name is the IP address or the public DNS name of your HCL Informix Virtual Appliance instance.

  1. If a high-availability cluster does not exist, run the createC1Cluster script.
  2. Click Admin on the main OAT screen.
  3. Click Connection Admin under Manage Connections
  4. Create a group by providing a Group Name and Password, then click Save.
  5. Click the Add Connection link to define a connection for each server in the cluster. For example, in the Add A Connection screen, enter the following for the primary server:
    • OAT Group: C1Cluster
    • Informix Server: c1primary
    • Host Name: public_name
    • Port: 1526
    • Username: informix
    • Password: Your informix password
    • ProtocolP: onsoctcp
    • Leave the Latitude, Longitude, and IDSD fields blank.
    When finished, the group should be configured as follows:
    Table 2. OAT configuration
    Informix server name Host name Port
    c1primary public_name 1526
    c1hdr1 public_name 1532
    c1rss1 public_name 1534
    c1rss2 public_name 1536
    c1sds1 public_name 1528
    c1sds2 public_name 1530
Parent topic: Informix Virtual Appliance
Copyright© 2018 HCL Technologies Limited