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 ...
    • 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
 ...
    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • DB2 connection - Scriptcase

      Enabling DB2connection on Scriptcase:   1. Download the instant client of DB2 form the url below or download the file in the final of this tutorial.   - Data Server Driver Package 10.5 - http://www-01.ibm.com/support/docview.wss?uid=swg27016878 ...
    • Popular Articles

    • Examples for diagrams

      This tutorial shows how you can import and use the new examples for diagrams released with Scriptpcase V9.2.16.  The applications were created using the components: Jsmind, JKanban e Orgchart.  - Sample 1: Mind Map diagram Click here to  execute the ...
    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • Correcting access error for the Scriptcase database

      Sometimes we encounter an error accessing the Scriptcase database itself, as shown in the image below:   This problem happens when we change the folder name of the scriptcase to another name, such as "sc". Then, the error happens because the complete ...
    • Necessary libraries to install the Scriptcase in Windows 7

      To install Windows 7 SP1, you need to verify that the system has the following items installed: * Visual C ++ Redistributable Packages for Visual Studio (2008) x86 and x64. * Visual C ++ Redistributable Packages for Visual Studio (2010) x86 and x64. ...
    • Manual Update - Windows

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