Re: PATCH for 9i support (was Re: [PHP-DB] Re: Oracle 9i Support)

Hi,

        I have oracle 8i in Linux server.  How could I connect it with PHP (on other server)?

SF At 16:57 26/7/2001 -0500, Lee Whatley (System Admin) wrote:

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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net