Dan,

    Thank you for the link.... unfortunately, even after initally logging in
as db2inst1 and then su to root (w/o the dash) and stopping/starting
apachectl -- i still had no luck :/

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

    Thank you very much though still, i appreciate the ideas :)

            -Doug



"Dan Vande More" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
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