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

2001-07-27 Thread Brian Dunworth


 On Thursday, July 26, 2001 at 9:48 PM, Sommai Fongnamthip said:

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

  Install the Oracle Client software (on the other server).



 --- 
  Brian S. Dunworth
  Sr. Software Development Engineer
  Oracle Database Administrator
  The Printing House, Ltd.
  (850) 875-1500 x225
 --- 


-- 
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]




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

2001-07-26 Thread Sommai Fongnamthip

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, 0, 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]


-- 
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]