| Armand Pirvu 2004-08-30, 3:56 pm |
| Hi folks,
I managed to compile php 4 with ingres ii extension. And I am talking usig Ingres 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 /home/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 site.
<?php phpinfo(); ?>
Apache environment
Apache EnvironmentVariableValueDOCUMENT_ROOT /usr/local/web/apache_1.3.31/htdocs HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/x-shockwave-flash, *
/* HTTP_ACCEPT_ENCODING gzip, deflate HTTP_ACCEPT_LANGUAGE en-us HTTP_CONNECTION keep-alive HTTP_HOST 172.16.85.49 HTTP_USER_AGENT Mozilla/4.0 (compatible; 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/ingres/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/X11R6/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_ADMIN 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_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /1.php SCRIPT_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_databaseno valueno valueingres.default_passwordno valueno valueingres.default_userno valueno valueingres.max_linksUnlimitedUnlimitedingres.max_persistentUnlimitedUnlimited
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/apache_1.3.31/htdocs/2.php on line 2
Warning: ingres_connect(): Ingres II: Unable to connect to database (l::crest) 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!
|