Re: Bug #14045 [Com]: Problem with installing of ibm_db2 (db2 v9.5, linux FC9)

Hi Wilfredo, <<Should I install DB on my App-Server just to let PHP connect to a db2 Database ??? >> The answer to this is, No, you need not install the DB on your App-Server. But however you would require a DB2 client (at your app-server), to connect to the Database. There are different types of client namely 'Dataserver Client', 'Dataserver Run-time client' and 'Data Server Driver for ODBC, CLI, and .NET' . You can choose any depending on your requirement. More info on this can be found at http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.qb.client.doc/doc/c0023452.html Coming to the next part, i.e. getting the PHP DB2 driver binary. This differs based on the platform your app-server is on : - What platform is your App-Server on? -- a) If your App-server is a Linux box, then it will require that you should build the PHP driver. For building the PHP driver the minimum thing that will be required is the DB2 client with the necessary include files. You may also build the PHP driver on your DB server, which will surely have all the minimum requirements, and use the binaries built there on your client side (provided the client and the server platforms are the same). b) If your App-server is a windows box then you need not build the PHP driver, the binaries for windows are available from the Pecl-for-windows site http://pecl4win.php.net/list.php . Thanks, Praveen Devarao IBM OpenSource Application Development Team India Software Labs, Bangalore (India) "bricenow at hotmail dot com" <pecl-dev@lists.php.net> 25/06/2008 19:42 To Open Source Application Development/Lenexa/IBM@IBMUS cc Subject [PECL-BUG] Bug #14045 [Com]: Problem with installing of ibm_db2 (db2 v9.5, linux FC9) Edit report at http://pecl.php.net/bugs/bug.php?id=14045&edit=1 ID: 14045 Comment by: bricenow at hotmail dot com Reported By: robert dot prokopczuk at wp dot pl Status: Open Id: 14045 Type: Bug Package: ibm_db2 Operating System: Linux FC9 PHP Version: 5.2.5 New Comment: Hi, I find myself in the same position, but in my case, I dont have DB2 installed in my App-Server, wich is the one i will using to connect to the DB-Server. So What I'm Asking is... Should I install DB on my App-Server just to let PHP connect to a db2 Database ??? Any help you can give me will be nice... Best Regards, Wilfredo Briceño Previous Comments: ------------------------------------------------------------------------ [2008-06-03 13:57:32] opendev at us dot ibm dot com Hi Robert, Seems like your DB2 is not installed properly, could you please re-install it and then check if you are able to build ibm_db2. The directory include should contain many more files like sqlcli1.h, sqlcli.h, sql.h etc. while installing ibm_db2 it finds for DB2 CLI include files in the include directory (to name a few, the files specified above), which it is not able to find. Thank You Praveen ------------------------------------------------------------------------ [2008-06-03 08:20:05] robert dot prokopczuk at wp dot pl I have installed DB2 v9.5 Express-C, instance owner is user db2 (not db2inst1). The directory /opt/ibm/db2/V9.5/include contains file: asn.h ------------------------------------------------------------------------ [2008-06-02 11:11:27] opendev at us dot ibm dot com Hi Robert, Can you let us know which DB2 product you are using. While installing ibm_db2 it searches for the include files in the directory /opt/ibm/db2/V9.5/include, in your case seems like the include directory is not found.Please let us know which product of DB2 are you using, so that we can guide in having ibm_db2 installed. If in case you are using the product DB2 connect then try the steps which Patrick has suggested, if not successful do let us know we will help you Thank and Regards Praveen ------------------------------------------------------------------------ [2008-06-02 09:14:00] robert dot prokopczuk at wp dot pl Description: ------------ I have a problem with installing of ibm_db2 extension. Reproduce code: --------------- pecl install ibm_db2 Actual result: -------------- [root@localhost ibm_db2-1.6.5]# ./configure --with-IBM_DB2=/opt/ibm/db2/V9.5 checking for grep that handles long lines and -e... /bin/grep checking for egrep... /bin/grep -E checking for a sed that does not truncate output... /bin/sed checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking whether gcc and cc understand -c and -o together... yes checking for system library directory... lib checking if compiler supports -R... no checking if compiler supports -Wl,-rpath,... yes checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking for PHP prefix... /usr checking for PHP includes... -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib checking for PHP extension directory... /usr/lib/php/modules checking for PHP installed headers prefix... /usr/include/php checking for re2c... re2c checking for re2c version... 0.12.3 (ok) checking for gawk... gawk checking for IBM_DB2 support... yes, shared checking Looking for DB2 CLI libraries... checking in /opt/ibm/db2/V9.5... checking in /opt/ibm/db2/V9.5/lib64... checking in /opt/ibm/db2/V9.5/lib32... found checking for DB2 CLI include files in default path... checking in /opt/ibm/db2/V9.5... not found configure: error: Please reinstall the DB2 CLI distribution ------------------------------------------------------------------------ -- Edit this bug report at http://pecl.php.net/bugs/bug.php?id=14045&edit=1