php and ingres ii
| From: | Armand Pirvu | Date: | Mon, 30 Aug 2004 12:50:51 +0000 |
| Subject: | php and ingres ii | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35941@lists.php.net to get a copy of this message | ||
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), otcssis02001, 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_SOFTWARE
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!