Bug #2045: I can't use PHP3 with informix IDS7.3UC5

From: musica98@chollian.net Operating system: Redhat5.2(2.0.36) PHP version: 3.0.12 PHP Bug Type: Other Bug description: I can't use PHP3 with informix IDS7.3UC5 I'm user of Redhat5.2(2.0.36) + IDS7.3-UC5 + MYSQL + PHP3.0.12 I want use PHP3 with IDS7.3. but, I have error using PHP3 with IDS7.3. first, my install method is following --------------------------------------------- My informixuser & root's .bash_profile --------------------------------------------- export USERNAME ENV PATH export PATH=/usr/local/jdk1.2/bin:$PATH export PATH=/home/informix/bin:$PATH:$HOME/bin export INFORMIXDIR=/home/informix export INFORMIXSERVER=linux export LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH export TERMCAP=$INFORMIXDIR/etc/termcap export DBLANG=ko_Kr.ksc ----------------------------------------------- My install command (and I'm use IMAP function) ----------------------------------------------- php & apache's source extract into /usr/local 1. cd apache1.3.6 2. ./configue --prefix=/www 3. cd ../php-3.0.12 4. ./configure --with-mysql=/usr/local/mysql --with-informix=yes --with-apache=../apache1.3.6 --with-imap=yes --enable-track-vars 5. make 6. make install 7. cd ../apache_1.3.6 8. ./configure --prefix=/www --activate-module=src/modules/php3/libphp3.a 9. make 10. make install 11. Configuration httpd.conf php3.ini 12. Starting IDS7.3 (oninit) 13. Starting Apache I have no error. ----------------------------------------------- I checked following source ----------------------------------------------- <? echo(phpinfo()); ?> 1. I checked INFORMIX section. -----------------------------------------------------| | | | | |Allow persistent links: Yes | | |Persistent links: 0/Unlimited | | informix |Total links: 0/Unlimited | | |Client API version: 7.20 | | |Compilation definitions: IFX_INCLUDE= | | | IFX_LFLAGS= | | | IFX_LIBS= | ------------------------------------------------------ 2. I checked stores7 Database following source. (My informix servername = linux) <? $connect=ifx_connect( "stores7@linux", "informix", "*******"); $res_id = ifx_query(" select o.order_num, i.total_price from orders o, items i where o.order_num = i.order_num ", $connect); if (!$res_id) { printf("Can't select orders : %s\n<br>%s<br>\n", ifx_error(), ifx_errormsg()) ; die; } ifx_htmltbl_result($res_id, "border=1"); ifx_free_result($res_id); ifx_close($connect); ?> but I get follow result. -------------------------------------------- Warning: ifx_pconnect : E [SQLSTATE=IX 000 SQLCODE=-922] in /home/musica/www/index.html on line 3 Warning: ifx_query : 0 (type -1) is not a Informix link index in /home/musica/www/index.html on line 9 Can't select orders : E [SQLSTATE=IX 000 SQLCODE=-922] Cannot get name of current working directory. -------------------------------------------- I don't know my mistake. I used informix+php3 at home(Redhat 6.0(2.2.5)+IDS7.3-UC7 + MYSQL + PHP3.0.11) It's good. But at school Redhat5.2(2.0.36) + IDS7.3-UC5 + MYSQL + PHP3.0.12 It's don't run. Please help me. Thanks your try.