Informix Connection - Scriptcase 8.1 - Linux

Informix Connection - Scriptcase 8.1 - Linux

To enable the connection to Informix on Linux, we must perform the following steps:

Prerequisites

Step 1 -  Add the i386 architecture and install the packages below
 :

UBUNTU\DEBIANCENTOS\RHEL
- sudo dpkg —add-architecture i386

- sudo apt-get update

- sudo apt-get install libaio1:i386
- sudo apt-get install libncurses5:i386
- sudo apt-get install alien

- sudo apt-get install gcc-multilib g++-multilib

- sudo apt-get install libpam0g:i386

- sudo apt-get install ksh:i386
- sudo apt-get install unixodbc-dev:i386 unixodbc:i386
- sudo yum update
- sudo yum install libaio-devel.i686
- sudo yum install libaio.i686
- sudo yum install glibc.i686
- sudo yum install compat-libstdc++-33.i686
- sudo yum install glibc-devel.i686
- sudo yum install libstdc++.i686
- sudo yum install libstdc++.i686
- sudo yum install pam.i686
- sudo yum install ncurses-devel.i686
- sudo yum install unixODBC.i686
- sudo wget ftp://195.220.108.108/linux/centos/6.7/os/i386/Packages/ksh-20120801-28.el6.i686.rpm
- sudo yum install ksh-20120801-28.el6.i686.rpm
- sudo yum install nano


Step 2 - Download Informix Client SDK :

- Client SDK 3.70.UC8.DE 


Step 3
 - Download PHP extension : 

PHP 56
PHP 54


Step 4 - Copy the extension to the folder ext from scriptcase :

- sudo cp pdo_informix.so /opt/NetMake/v81/components/apache/ext/

Step 5 - Edit and add on the end of php.ini file the informix extension :
- sudo nano /opt/NetMake/v81/components/apache/conf/php.ini
- extension=pdo_informix.so

Step 6 - Install the Client SDK :
- sudo tar -xf clientsdk.3.70.UC8DE.LINUX.tar
- sudo ./installclientsdk

Required: The Informix client installation directory should be: /opt/IBM/ifx

Step 7 - Edit the php.fcgi file
- sudo nano /opt/NetMake/v81/components/apache/cgi-bin/php.fcgi

Step 8 - Add content down over the line exec $PHPCGI :

INFORMIXDIR="/opt/IBM/ifx/"
INFORMIXSQLHOSTS="/opt/IBM/ifx/etc/sqlhosts"
INFORMIXSERVER="demo_on"
ODBCINI="/opt/IBM/ifx/etc/odbc.ini"
LD_LIBRARY_PATH="/opt/IBM/ifx/lib:/opt/IBM/ifx/lib/esql:/opt/IBM/ifx/lib/cli:/opt/IBM/ifx/lib/c++:/opt/IBM/ifx/lib/client:/opt/IBM/ifx/lib/dmi"
CLIENT_LOCALE="en_US.utf8"
DB_LOCALE="en_US.819"

export INFORMIXDIR
export INFORMIXSQLHOSTS
export INFORMIXSERVER
export ODBCINI
export LD_LIBRARY_PATH
export CLIENT_LOCALE
export DB_LOCALE

Step 9 - Restart apache :
- sudo /etc/init.d/apachesc81 restart

    • Related Articles

    • Manual Update - Linux

      Before performing any procedure we recommend performing a backup of your projects. To back up Scriptcase: Go to Options > Settings, in the side menu go to Services > Backup. A file (.ZIP) will be generated with all your projects, save this file to a ...
    • Install ScriptCase PHP 7.0 on a XAMPP on Linux

      Xampp Installation Using PHP 7.0 XAMPP It allows you to easily install Apache on your own computer, regardless of your operating system (Linux, Windows, MAC or Solaris). First you have to proceed to download XAMPP PHP ...
    • Install ScriptCase PHP 7.3 on a XAMPP in Linux

      Xampp Installation Using PHP 7.3 XAMPP It allows you to easily install Apache on your own computer, regardless of your operating system (Linux, Windows, MAC or Solaris). First you have to proceed to download XAMPP PHP ...
    • DB2 Connection - Scriptcase 8.1 - Linux

      To enable the connection to DB2 on Linux, we must perform the following steps: Prerequisites Step 1  -  Add the i386 architecture and install the packages below : UBUNTU\DEBIAN CENTOS\RHEL - sudo dpkg —add-architecture i386 
- sudo apt-get update
 - ...
    • Oracle Connection - Scriptcase 8.1 - Linux

      To enable the connection to Oracle on Linux, we must perform the following steps: Prerequisites Step 1  -  Add the i386 architecture and install the packages below : UBUNTU\DEBIAN CENTOS\RHEL - sudo dpkg —add-architecture i386 
- sudo apt-get update
 ...