php and ingres ii

Hi folks,

I managed to compile php 4 with ingres ii extension. And I am talking usig I
ngres 2.6 on Red Hat Linux 9, and apache 1.3.31.
Here there are the steps I did.

1. In /etc/ld/so/conf, I added the line /home/ingres/ingsys/ingres, where /h
ome/ingres/ingsys is the II_SYSTEM
2. I configured apache, but did not build it yet
3. I confiured php with ingres option .
4. Edited Makfile of php to add -lpthread flag to EXTRA_LIBS
5. Ran make and make install for php
6. Re-configure apache with php support this time
7. Edited Makefile of apache to add -lpthread to EXTRA_LIBS
8. Ran make and make install for apache
9. Added II_SYSTEM, LD_LIBRARY_PATH and PATH updated with Ingres directories
 in the apachectl file
10. I made sure the root user has access to the database and it's tables.
11. Tailored the aapache conf file and fire up


The test page of apache runs fine.
I built a simple page to see the info of php, as it is detailed on php.net s
ite.

<?php phpinfo(); ?>

Apache environment

Apache EnvironmentVariableValueDOCUMENT_ROOT /usr/local/web/apache_1.3.31/ht
docs HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, applic
ation/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, appli
cation/x-shockwave-flash, *
/* HTTP_ACCEPT_ENCODING gzip, deflate HTTP_ACCEPT_LANGUAGE en-us HTTP_CONNEC
TION keep-alive HTTP_HOST 172.16.85.49 HTTP_USER_AGENT Mozilla/4.0 (compatib
le; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) HTTP_VIA 1.1 otcssis01002 (
NetCache NetApp/5.5R5), otc
ssis02001, 1.1 otcssis01002 (NetCache NetApp/5.5R5) HTTP_X_FORWARDED_FOR 172
.16.88.229, 172.16.88.229 HTTP_X_ICAP_VERSION 1.0 PATH /home/ingres/ingsys/i
ngres/bin:/home/ingres/ingsys/ingres/utility:/home/ingres/ingsys/ingres/bin:
/home/ingres/ingsys/ingres/
utility:/usr/local/j2sdk1.4.2_05/bin:/usr/local/j2sdk1.4.2_05/jre/bin:/bin:/
sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11
R6/bin:/root/bin REMOTE_ADDR 170.40.27.131 REMOTE_PORT 15307 SCRIPT_FILENAME
/usr/local/web/apache_1.3.31/htdocs/1.php SERVER_ADDR 172.16.85.49 SERVER_AD
MIN root@localhost.localdomain SERVER_NAME localhost.localdomain SERVER_PORT
 80 SERVER_SIGNATURE <ADDRESS>Apache/1.3.31 Server at localhost.localdomain 
Port 80</ADDRESS> SERVER_S
OFTWARE Apache/1.3.31 (Unix) PHP/4.3.8 GATEWAY_INTERFACE CGI/1.1 SERVER_PROT
OCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /1.php SC
RIPT_NAME /1.php

Running it and looking for Ingres here it is what I see.

ingres_iiIngres II SupportenabledActive Persistent Links 0 Active Links 0
DirectiveLocal ValueMaster Valueingres.allow_persistentOnOningres.default_da
tabaseno valueno valueingres.default_passwordno valueno valueingres.default_
userno valueno valueingres.max_linksUnlimitedUnlimitedingres.max_persistentU
nlimitedUnlimited


I built 2.php to test ingres connectivity


<?php
ingres_connect("crest", "root", "yadyyady")
or die("Could not connect");
echo "Connected successfully";
ingres_close($link);
?>


The result is

Warning: ingres_connect(): Ingres II: Server or API error : ERget: Directory
 error. in /usr/local/web/apache_1.3.31/htdocs/2.php on line 2

Warning: ingres_connect(): Ingres II: SQLSTATE : 08004 in /usr/local/web/apa
che_1.3.31/htdocs/2.php on line 2

Warning: ingres_connect(): Ingres II: Unable to connect to database (l::cres
t) in /usr/local/web/apache_1.3.31/htdocs/2.php on line 2
Could not connect



Any ideeas or hints ?


Thanks a lot.

Armand


---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!