ID: 24343
User updated by: thomas at fivemile dot net
Reported By: thomas at fivemile dot net
-Status: Bogus
+Status: Open
Bug Type: OCI8 related
Operating System: Redhat Linux 8.0
PHP Version: 4.3.3-dev
New Comment:
Okay, once again, slowly.
- installed a fresh oracle 9.2.0
- installed a fresh apache with PHP and linked against oracle
- does NOT work
- copied over the entire /opt/oracle/product/9.0.1 tree from another
machine where the libs work
- installed a fresh apache with PHP linked against those other libs
- CHANGED the environment vars so the 9.0.1 libs are used instead of
the 9.2.0 libs
- now it works - NO thanks to wild guesses from the bugs team.
i have installed a couple of working oci/php combos so far, the 9.2.0
is the first one where i ran into these kind of problems. And you can't
earnestly expect new users to fiddle with libs for 2 weeks till their
oci bindings start to work...
If you like, you can have an account on the box in question and have a
look around yourself. However i am NOT satisfied with the answer 'okay,
you made a crude hack, and by chance it worked, now use it and stop
bugging us'
Previous Comments:
------------------------------------------------------------------------
[2003-07-08 11:40:16] [EMAIL PROTECTED]
Then use those. Wild guess: The SAME environment vars don't work with
DIFFERENT oracle version..
------------------------------------------------------------------------
[2003-07-08 10:52:15] thomas at fivemile dot net
the SAME script on the SAME machine works with the 9.0.1 client libs I
copied over from the other machine. Only the 9.2.0 client libs (using
the SAME script, the SAME php, the SAME apache and the SAME configure
line) do not work.
------------------------------------------------------------------------
[2003-07-07 19:29:08] [EMAIL PROTECTED]
Try a script which has ONLY that one line.
And you're sure your username/password doesn't contain any illegal
chars? And your db name is tns.domain ??
------------------------------------------------------------------------
[2003-06-26 18:36:52] thomas at fivemile dot net
Warning: ociplogon(): OCISessionBegin: ORA-00604: error occurred at
recursive SQL level 1 ORA-00911: invalid character in
/home/httpd/index.php3 on line 3
or
Warning: ocilogon(): OCISessionBegin: ORA-00604: error occurred at
recursive SQL level 1 ORA-00922: missing or invalid option in
/home/httpd/index.php3 on line 3
'Line 3' is simply the OCILogon or OCIPLogon as follows:
$ohnd = OCILogon("dvd","hidden","tns.domain");
------------------------------------------------------------------------
[2003-06-26 18:30:36] [EMAIL PROTECTED]
With what script and what errors do you get..?
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/24343
--
Edit this bug report at http://bugs.php.net/?id=24343&edit=1
