I used this:

Some of his info is wrong, or I had problems with, but hey, this worked:
*************************************************************************************************************************************************************
Now we know DB2 works now to test it with PHP and Apache, first login as user db2inst1 
then su to the user root, dont use su - , cause this will make the shell use the 
settings of root instead of db2inst1 and we need those settings so Apache can find the 
DB2 Instances. Now first stop apache (if started ofcourse) 
/usr/local/apache/bin/apachectl stop and start apache /usr/local/apache/bin/apachectl 
start . Now create a file in de apache docroot ( on my machine thats 
/usr/local/apache/htdocs/ ) called test.php for example and fill it with the following 
example:
*************************************************************************************************************************************************************

http://people.a2000.nl/nlvanrey/docs/install-db2-php-apache-linux.html


-----Original Message-----
From: Doug Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 08, 2002 1:28 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] can i use --with-unixODBC instead of --with-ibm-db2?


> I just checked my config, and I *actually* have that line in apachectl.
Try
> that, and if it fixes it, I'll correct the doc.

although my apache is built via rpm, i put the line (.
/home/db2inst1/sqllib/db2profile) in apachectl and started httpd w/
apachectl, buuuut...

unfortunately i'm still getting the

Warning: SQL error: , SQL state tO@6#A@ in SQLConnect in
/var/www/html/db2php/db2lib.php on line 8

error...

i also tried to add "export DB2INSTANCE=db2inst1" in the same script and
that didn't help either.

could the problem be that i'm starting httpd (or apachectl) as root? i know
the ". /home/db2inst1/sqllib/db2profile" is supposed to make apachectl
inherit the db2 environment variables, but...... somehow it's not working :/

matt, thank you again :)

        -doug


p.s. for the record__________________________
./configure
i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbind
ir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/includ
e --libdir=/usr/lib --sysconfdir=/etc --with-apxs=/usr/sbin/apxs --with-ibm-
db2








-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to