From: daniel dot henchoz at unil dot ch Operating system: Solaris 9 PHP version: 5.1.2 PHP Bug Type: Informix related Bug description: How to get PHP working in thread mode with informix libraries ?
Description: ------------ I've installed a SUN server under Solaris 9 with Apache 2.0.55, PHP 5.1.2, Informix 9.40.UC6, Informix Client SDK 2.90.UC3, Informix Webdatablade 4.13.UC3. Now I try to get information from the Informix database via a PHP ifx_connect function and on the same apache server using the Informix webdatablade tool (old pages not yet migrated ...). The php and informix modules are loaded in the apache httpd.conf : #IBM Informix Web DataBlade DSO Module Added LoadModule informix_module /d3/apache2/wwwdbdev/ifmx-bin/drvapch2.so # Load the necessary PHP modules LoadModule php5_module modules/libphp5.so I'm not able to have php and webdatablade connections to informix work together ... Case 1: ------- If I load the informix module first in the httpd.conf file the php ifx functions doesn't work and I get the following incomplete error message : *Warning*: ifx_connect() [function.ifx-connect <https://furio.unil.ch/php-dhz/function.ifx-connect>]: E [SQLSTATE= in */d3/apache2/wwwdbdev/php-dhz/testifmx.php* on line *3* *Warning*: ifx_query(): supplied argument is not a valid Informix link resource in */d3/apache2/wwwdbdev/php-dhz/testifmx.php* on line *4* *Warning*: printf() [function.printf <https://furio.unil.ch/php-dhz/function.printf>]: Too few arguments in */d3/apache2/wwwdbdev/php-dhz/testifmx.php* on line *7* The php script is below : <?php $ConnId = ifx_connect ("[EMAIL PROTECTED]","xxxxxx","xxxxxx"); $ResId = ifx_query ("SELECT * FROM dhtable", $ConnId); if (! $ResId) { printf("Can't select names : %s\n<br />%s<br />\n", ifx_error()); ifx_errormsg(); die; } ifx_htmltbl_result($ResId, "border=\"1\""); ifx_free_result($ResId); ifx_close($ConnId); ?> On the other hand the webdatablade connection works normally ... Case 2: ------- If I load the php module before the informix module in the httpd.conf file, the php ifx_connect function works correctly, but now the wedatablade connection fails (never answer) .... I need the two ways to connect to the database, since we actually still use both .... I've asked IBM for a solution, but they propose me to submit this problem to PHP people since IBM didn't develop the ifx functions to connect to the informix database via PHP. The IBM engineer already did some test, and suspect that we have problems because the php informix module doesn't use the informix thread libs, since the webdatablade module of informix use them ... (I could formward the complete tests and example if necessary). He propose me to submit a question to the PHP community. So my final question is : How to get PHP working in thread mode with the informix libraries ?? Best Regards Daniel -- Edit bug report at http://bugs.php.net/?id=36135&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=36135&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=36135&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=36135&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=36135&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=36135&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=36135&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=36135&r=needscript Try newer version: http://bugs.php.net/fix.php?id=36135&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=36135&r=support Expected behavior: http://bugs.php.net/fix.php?id=36135&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=36135&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=36135&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=36135&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=36135&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=36135&r=dst IIS Stability: http://bugs.php.net/fix.php?id=36135&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=36135&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=36135&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=36135&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=36135&r=mysqlcfg
