RE: [PHP-DB] PHP and Informix installation

Halo,

        How could I set up Informix driver in my Linux Server?

SF At 13:26 27/7/2001 -0500, Muciño Zúñiga Marco Antonio wrote:

OK, I set my LIBS environment variable to my esql -libs result and the confire shell is OK now, but now I get the next error when running the make command: # make ===> src make[1]: Entering directory `/tmp/apache_1.3.20' make[2]: Entering directory `/tmp/apache_1.3.20/src' ===> src/os/unix gcc -c -I../../os/unix -I../../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0 .6/main -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp /php-4.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../../lib/e xpat-lite -DNO_DL_NEEDED ../../apaci os.c gcc -c -I../../os/unix -I../../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0 .6/main -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp /php-4.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../../lib/e xpat-lite -DNO_DL_NEEDED ../../apaci os-inline.c rm -f libos.a ar cr libos.a os.o os-inline.o true libos.a <=== src/os/unix ===> src/ap gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_cpystrn.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_execve.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_fnmatch.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_getpass.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_md5c.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_signal.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_slack.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_snprintf.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_sha1.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_checkpass.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_base64.c gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci ap_ebcdic.c rm -f libap.a ar cr libap.a ap_cpystrn.o ap_execve.o ap_fnmatch.o ap_getpass.o ap_md5c.o ap_si gnal.o ap_slack.o ap_snprintf.o ap_sha1.o ap_checkpass.o ap_base64.o ap_ebcdic.o true libap.a <=== src/ap ===> src/main gcc -c -I../os/unix -I../include -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/mai n -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4 .0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci gen_test_char.c gcc -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/main -I/tmp/ php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I../lib/expat-lite -DNO_DL_NEEDED ../apaci -o gen_test_char gen_test_char.o -lifsql -lifasf -lifgen -lifos -lifgls -lnsl_s -l crypt_i /usr/lib/libgen.a -lsocket -lnsl -lm -lsuds -ltinfo -lprot -lx -ltinfo - lm -lc /usr/informix/lib/esql/checkapi.o -lifglx -L/usr/informix/lib -L/usr/info rmix/lib/esql -L/tmp/php-4.0.6/ext/informix -L/usr/informix/lib -L/usr/informix /lib/esql -L/tmp/php-4.0.6/ext/informix -Lmodules/php4 -L../modules/php4 -L../.. /modules/php4 -lmodphp4 -lifsql -lifasf -lifgen -lifos -lifgls -lnsl_s -lcrypt _i -lgen -lsocket -lnsl -lsuds -ltinfo -lprot -lx -ltinfo -lc -lphpifx -lifglx - lcrypt -lm -lsocket -lsocket -lsocket -lmalloc -lprot -ltinfo -lx -lm ./gen_test_char >test_char.h dynamic linker : ./gen_test_char : error opening libifsql.so /bin/sh: 169 Killed make[3]: *** [test_char.h] Error 137 make[2]: *** [subdirs] Error 1 make[2]: Leaving directory `/tmp/apache_1.3.20/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/tmp/apache_1.3.20' make: *** [build] Error 2 The file libifsql.so exists in the directory /usr/informix/lib/esql do you have any idea what's happening now? Thanks a lot. -----Original Message----- From: Paul Gardiner [mailto:paul.gardiner@barleychalu.co.uk] Sent: Friday, July 27, 2001 7:57 AM To: Muciño Zúñiga Marco Antonio; php-db@lists.php.net Subject: Re: [PHP-DB] PHP and Informix installation Hi, To be honest I don't know if PHP will work with version 5.x of Informix. I think it must be 7.x. At least that's for the SE version. In case I'm wrong for On-Line you can have a go but you'll have to specify the libs manually when compiling Apache. If you run esql -libs this will list the libs you need. I have shown the ones for my machine but just check your own and put them in IFX_LIBS as like something below: # get these by running esql -libs at the prompt IFX_LIBS="-lifsql -lifasf -lifgen -lifos -lifgls -lnsl_s -lcrypt_i \ /usr/lib/libgen.a -lsocket -lnsl -lm -lsuds -ltinfo -lprot -lx \ -ltinfo -lm -lc /usr/informix/lib/esql/checkapi.o -lifglx" # Add any extra libs in here if required LIBS="$IFX_LIBS" export LIBS ./configure --prefix=$APACHE_DIR \

            --activate-module=src/modules/php4/libphp4.a

Regards, - Paul - ----- Original Message ----- From: "Muciño Zúñiga Marco Antonio" <MMZUNIGA@telmex.com> To: <php-db@lists.php.net> Sent: Thursday, July 26, 2001 6:35 PM Subject: [PHP-DB] PHP and Informix installation Hi, I installed php y my UNIX SCO Openserver and it works fine. Now, in the same server is installed the Informix Online 5.10. I want to access the Informix databases then I run the next commands successfully: cd php-4.0.6 ./configure --with-apache=../apache_1.3.20 --enable-track-vars --with-informix=/usr/informix make make install cd ../apache_1.3.20 ./configure --prefix=/usr/internet/apache --activate-module=src/modules/php4/libphp4.a All is OK until the last command (./configure ...) I get the error messages: # ./configure --prefix=/usr/internet/apache --activate-module=src/modules/php4/libphp4.a Configuring for Apache, Version 1.3.20 + using installation path layout: Apache (config.layout) + activated php4 module (modules/php4/libphp4.a) Creating Makefile Creating Configuration.apaci in src Creating Makefile in src + configured for SCO 5 platform + setting C compiler to gcc + setting C pre-processor to gcc -E + checking for system header files + adding selected modules

    o php4_module uses ConfigStart/End

+ checking sizeof various data types + doing sanity check on compiler and options ** A test compilation with your Makefile configuration ** failed. The below error output from the compilation ** test will give you an idea what is failing. Note that ** Apache requires an ANSI C Compiler, such as gcc. cd ..; gcc -DSCO5 -I/tmp/php-4.0.6 -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/Zend -I/tmp/php-4.0.6/TSRM -I/tmp/php-4.0 .6/TSRM -I/tmp/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED ./apaci

     -o helpers/dummy helpers/dummy.c   -L/usr/informix/lib

-L/usr/informix/lib/ esql -L/tmp/php-4.0.6/ext/informix -L/usr/informix/lib -L/usr/informix/lib/esql -L/tmp/php-4.0.6/ext/informix -Lmodules/php4 -L../modules/php4 -L../../modules/ php4 -lmodphp4 -lifsql -lifasf -lifgen -lifos -lifgls -lnsl_s -lcrypt_i -lgen -lsocket -lnsl -lsuds -ltinfo -lprot -lx -ltinfo -lc -lphpifx -lifglx -lcrypt -l m -lsocket -lsocket -lsocket -lmalloc -lprot -ltinfo -lx -lm

Undefined                       first referenced

 symbol                             in file

getspnam                            /usr/informix/lib/esql/libifos.so

helpers/dummy: fatal error: Symbol referencing errors. No output written to help ers/dummy make: *** [dummy] Error 1 ======== Error Output for sanity check ======== ============= End of Error Report ============= Aborting! Looks like the library libifos.so is wrong, does anyone have an idea what's going on? Thanks in advance. Marco Muciño -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net