Here is a patch that will allow configure to properly detect oracle 9i
If your mail server filters out attachments you can download it from
http://www.cba.ua.edu/~spaff/php-4.0.6-oci8-oracle9i.patch

The patch should be applied from directly outside of the php source
tree.
I am not a coder by any means so I hope this doesn't break anything.

-Lee

"Thies C. Arntzen" wrote:
> 
> On Thu, Jul 26, 2001 at 02:21:02PM -0500, Lee Whatley (System Admin) wrote:
> >
> > If I try to use ocilogon("scott","tiger"); I get the following:
> > Warning: _oci_open_server: Error while trying to retrieve text for error
> > ORA-12546
> >
> > If its giving me an ORA-12546 error then I am assuming it is at least
> > trying to talk to the database.  I guess it must be a library
> > incompatibility issue.
> 
>     no -
> 
> 12546, 00000, "TNS:permission denied"
> // *Cause: User has insufficient privileges to perform the
> // requested operation.
> // *Action: Acquire necessary privileges and try again.
> 
>     please make sure that the user that runs apache can actually
>     access $ORACLE_HOME and all needed files withing!
> 
>     tc
> 
> >
> > "Thies C. Arntzen" wrote:
> > >     if phpinfo says oci8 is included than it _is_. the libraries
> > >     used thing might (and probably is) broken. just try calling
> > >     ocilogon($user,$pw); and see what it does!
> > >
> > >     tc
--- ./php-4.0.6/configure.orig  Thu Jul 26 16:22:42 2001
+++ ./php-4.0.6/configure       Thu Jul 26 16:30:31 2001
@@ -573,8 +573,8 @@
                           directory. If unspecified, the bundled MySQL library
                           will be used."
 ac_help="$ac_help
-  --with-oci8[=DIR]       Include Oracle-oci8 support. Default DIR is 
-                          ORACLE_HOME."
+  --with-oci8[=DIR]       Include Oracle-oci8 (oracle 8i and 9i) support.
+                          Default DIR is ORACLE_HOME."
 ac_help="$ac_help
   --with-adabas[=DIR]     Include Adabas D support.  DIR is the Adabas base
                           install directory, defaults to /usr/local."
@@ -31541,6 +31541,8 @@
        test -z "$OCI8_VERSION" && OCI8_VERSION=7.3
   elif test -f $OCI8_DIR/lib/libclntsh.s?.8.0; then
        OCI8_VERSION=8.1
+  elif test -f $OCI8_DIR/lib/libclntsh.s?.9.0; then
+       OCI8_VERSION=9.0
   elif test -f $OCI8_DIR/lib/libclntsh.s?.1.0; then
        OCI8_VERSION=8.0
   elif test -f $OCI8_DIR/lib/libclntsh.a; then 
@@ -31934,7 +31936,7 @@
 
          ;;
 
-       8.1)
+       9.0)
          
  case "clntsh" in
  c|c_r|pthread*) ;;
--- ./php-4.0.6/ext/oci8/config.m4.orig Thu Jul 26 16:22:51 2001
+++ ./php-4.0.6/ext/oci8/config.m4      Thu Jul 26 16:24:34 2001
@@ -7,6 +7,8 @@
        test -z "$OCI8_VERSION" && OCI8_VERSION=7.3
   elif test -f $OCI8_DIR/lib/libclntsh.s?.8.0; then
        OCI8_VERSION=8.1
+  elif test -f $OCI8_DIR/lib/libclntsh.s?.9.0; then
+       OCI8_VERSION=9.0
   elif test -f $OCI8_DIR/lib/libclntsh.s?.1.0; then
        OCI8_VERSION=8.0
   elif test -f $OCI8_DIR/lib/libclntsh.a; then 
@@ -72,6 +74,12 @@
          ;;
 
        8.1)
+         PHP_ADD_LIBRARY(clntsh, 1, OCI8_SHARED_LIBADD)
+         PHP_ADD_LIBPATH($OCI8_DIR/lib, OCI8_SHARED_LIBADD)
+         AC_DEFINE(HAVE_OCI8_TEMP_LOB,1,[ ])
+         ;;
+
+       9.0)
          PHP_ADD_LIBRARY(clntsh, 1, OCI8_SHARED_LIBADD)
          PHP_ADD_LIBPATH($OCI8_DIR/lib, OCI8_SHARED_LIBADD)
          AC_DEFINE(HAVE_OCI8_TEMP_LOB,1,[ ])

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to