For developement reasons (oracle realted) I hadto abandone mod_php.tgz (php
4.0.5) package delivered with slackware 8.0 and use php 4.0.6 so I.m
currently working with:
php 4.0.6 and apache 1.3.20 ona a slackware 8.0 (with kernel 2.2.19).
At first I recompiled php 4.0.6 with exact same options of original package
( got oprions from phpinfo() ) and all went fine.
I then decided to try adding oracle database support.
I recompiled apache to be linked against libpthread (as told to do so from
erlier bug report related to oracle & sybase) with not little effort since
apache's configure does not ponder such action!:
root@extensa:~# ldd /usr/sbin/httpd
libm.so.6 => /lib/libm.so.6 (0x40020000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x40042000)
libdb.so.3 => /lib/libdb.so.3 (0x40070000)
libdl.so.2 => /lib/libdl.so.2 (0x400c3000)
libpthread.so.0 => /lib/libpthread.so.0 (0x400c7000)
libc.so.6 => /lib/libc.so.6 (0x400dd000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
Had some trouble with "--with-mm=/usr" option which is enabled per default
on mpd_php.tgz package for slackware
while trying to start apache got this error: "/usr/libexec/libphp4.so:
undefined symbol: mm_create"
So I temporarely removed it to get oracle working.
This ti what I did:
export LD_LIBRARY_PATH=/ora/app/oracle/product/8.0.5/lib:/usr/lib:/lib
export LD_RUN_LIBRARY_PATH=/ora/app/oracle/product/8.0.5/lib:/usr/lib:/lib
make clean
rm config.cache
./configure --prefix=/usr --with-apxs=/usr/sbin/apxs --with-mod_charset
--enable-force-cgi-redirect --enable-discard-path --with-con
fig-file-path=/etc/apache --enable-safe-mode --with-openssl --enable-bcmath
--with-bz2
--enable-calendar --enable-ctype --with-gdbm
--enable-ftp --enable-gd-imgstrttf --with-gd=/usr/src/gd-1.8.2
--with-jpeg-dir=/usr/src/gd-1.8.2 --with-png-dir --with-gmp --with-my
sql=/usr --with-xml=shared --with-readline=/usr --enable-trans-sid
--enable-shmop
--enable-sockets --with-regex=php --enable-sysvsem
--enable-sysvshm --enable-yp --enable-memory-limit --with-tsrm-pthreads
--enable-shared
--disable-debug --with-zlib=/usr --with-ora
cle=/opt/ora_syb/ora/app/oracle/product/8.0.5
this stage went successfully with no ATTENTION message & no errors produced
in
debug.log so I went ahead and compiled & installed:
make
/usr/sbin/apachectl stop
make install
root@extensa:~# ldd /usr/libexec/libphp4.so
libdl.so.2 => /lib/libdl.so.2
libreadline.so.4 => /usr/lib/libreadline.so.4
libhistory.so.4 => /usr/lib/libhistory.so.4
libncurses.so.5 => /lib/libncurses.so.5
libclntsh.so.1.0 =>
/opt/ora_syb/ora/app/oracle/product/8.0.5/lib/libclntsh.so.1.0
libm.so.6 => /lib/libm.so.6
libnsl.so.1 => /lib/libnsl.so.1
libmysqlclient.so.10 => /usr/lib/libmysqlclient.so.10
libz.so.1 => /usr/lib/libz.so.1
libgmp.so.3 => /usr/lib/libgmp.so.3
libpng.so.2 => /usr/lib/libpng.so.2
libjpeg.so.62 => /usr/lib/libjpeg.so.62
libgdbm.so.2 => /usr/lib/libgdbm.so.2
libbz2.so.1.0 => /lib/libbz2.so.1.0
libcrypt.so.1 => /lib/libcrypt.so.1
libssl.so.0 => /usr/lib/libssl.so.0
libcrypto.so.0 => /usr/lib/libcrypto.so.0
libresolv.so.2 => /lib/libresolv.so.2
libc.so.6 => /lib/libc.so.6
/lib/ld-linux.so.2 => /lib/ld-linux.so.2
Apache restarted ok and php seamed to work ok but as I made a very simple
function to start testing if I could query an oracle instance I ran into
trouble:
function oraconnect_test($a,$b) {
$conn = Ora_Logon("system@orcl","manager");
$string = Ora_Error ($conn);
print "$string";
ora_logoff ($conn);
}
Every time I run this function I get one more defunct httpd process a some
warning messages from php:
Warning: Oracle: Connection Failed: Error while trying to retrieve text for
error
ORA-12154 in /home/httpd/html/cpr/functions.php on line 223
Warning: Supplied argument is not a valid Oracle-Connection/Cursor resource
in
/home/httpd/html/cpr/functions.php on line 225
Warning: Supplied argument is not a valid Oracle-Connection resource in
/home/httpd/html/cpr/functions.php on line 228
According to oracle ORA-12154 means:
12154, 00000, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the following checks and correct the error:
// - Verify that a TNSNAMES.ORA file exists and is in the proper
// place and accessible. See the operating system specific
manual
// for details on the required name and location.
// - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
// - Make sure there are no syntax errors anywhere in the file.
// Particularly look for unmatched parentheses or stray
characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.
but my tnsnames is ok:
oracle@extensa:~# tnsping orcl
TNS Ping Utility for Linux: Version 8.0.5.0.0 - Production on 26-OCT-01
09:29:51
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(Host=linux)(Port=1521))
OK (60 msec)
Has anybody got any suggestions ?
Davide RAO
Database Administrator Group
SchlumbergerSema
E-mail: [EMAIL PROTECTED]
Tel: +39125 508765
--
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]
