IBM DB2

From DreamFactory
Jump to: navigation, search
Line 27: Line 27:
 
#* <source lang="bash">$ sudo make install</source>
 
#* <source lang="bash">$ sudo make install</source>
 
# Enable the driver in PHP
 
# Enable the driver in PHP
#* <source lang="bash">$ sudo nano /etc/php/7.1/mods-available/pdo_ibm.ini</source>
+
#* <source lang="bash">$ sudo sh -c 'echo "extension=ibm_pdo.so" > /etc/php/7.1/mods-available/ibm_pdo.ini'</source>
#* Edit this file so it reads <code>extension=pdo_ibm.so</code>
+
#* Save the file and exit
+
 
#* <source lang="bash">$ sudo phpenmod pdo_ibm</source>
 
#* <source lang="bash">$ sudo phpenmod pdo_ibm</source>
 
# Confirm proper php installation with  
 
# Confirm proper php installation with  

Revision as of 14:08, 22 September 2017

IBM's PDO_IBM driver is required for connecting to DB2 databases and must be compiled from source. Please follow these instructions.

  1. Get prerequisites from Apt
    • $ sudo apt-get install ksh build-essential php7.1-dev
  2. Get the dsdriver package from IBM.
    • You can download the package from here. Grab the Linux 64 bit package.
    • This download requires you to register for a free account with IBM.
  3. Copy the downloaded tar.gz file to your home directory on the server.
  4. Uncompress the package and move it to /opt/
    • $ cd ~
    • $ tar -zxf ibm_data_server_driver_package_linuxx64_v11.1.tar.gz
    • $ sudo mv dsdriver /opt/
  5. Run the dsdriver installer
    • $ cd /opt/dsdriver
    • $ sudo chmod +x installDSDriver
    • $ sudo ksh installDSDriver
  6. Symlink the include directory
    • $ sudo ln -s /opt/dsdriver/include /include
  7. Get the DF Patched version of the PDO_IBM Source
    • $ cd ~
    • $ git clone https://github.com/dreamfactorysoftware/PDO_IBM-1.3.4-patched.git
  8. Compile and install the driver
    • $ cd PDO_IBM-1.3.4-patched
    • $ phpize
    • $ ./configure --with-pdo-ibm=/opt/dsdriver/lib
    • $ make
    • $ sudo make install
  9. Enable the driver in PHP
    • $ sudo sh -c 'echo "extension=ibm_pdo.so" > /etc/php/7.1/mods-available/ibm_pdo.ini'
    • $ sudo phpenmod pdo_ibm
  10. Confirm proper php installation with
    • $ php -m | grep pdo_ibm
  11. Restart Apache
    • $ sudo service apache2 restart