Undefined Oracle functions during make

npfallen

Hi all, I am trying to build PHP --with-oracle and --with-oci8 but the make is failing saying that all of the Oracle functions are undefined. This happens even if I include only ONE of the oracle extenstions. I think the environment variables are setup correctly, and the User has been added to the Oracle group.

Here is my configure statement:
./configure --without-mysql --with-oci8 --with-oracle --with-apache=/usr/local/apache_1.3.27 --enable-track-vars

The configure seems OK, but it did detect my Oracle version as 8.1 when it is really 9.2. Dont know if this is somehow the problem.

GNU make gives me these error messages:
ld: 0711-317 ERROR: Undefined symbol: .OCIEnvInit
ld: 0711-317 ERROR: Undefined symbol: .OCIHandleAlloc
..[similar entries removed]..
ld: 0711-317 ERROR: Undefined symbol: .OCITypeByRef
ld: 0711-317 ERROR: Undefined symbol: .OCIObjectNew
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
make: *** [sapi/cli/php] Error 1

Here is my environment;
Unix AIX 5.1
Apache 1.3.27
Oracle 9.2
PHP 4.3.2 (Also tried 4.3.0 with the same results)

Please help! Thanks in advance. Don (allen-at-norpac-dot-com)

tsinka

Hi,

which environment variables did you export prior to executing configure ? Is /usr/local/apache_1.3.27 the apache source or an installed apache ?

You can compile php with both --with-oracle and --with-oci8. In our case it detected Oracle 8 when checking --with-oracle and Oracle 9i when checking --with-oci8. That should be ok. It should detect Oracle 9.2 at least once.

The undefined symbol error message tells us that the linker couldn't find the oracle shared libraries. There might be an environment variable missing. Additionally you might need to add some paths to the LD_LIBRARY_PATH environment variable.

Please post the config.log file (renamed to config.txt because phpbuilder wouldn't attach it to the post otherwise).

Thomas

npfallen

Below are environment variables. I didn't make any changes to what our DBA has already setup. If I know what paths to add, I can certainly try that as well.

The usr/local/apache_1.3.27 is the Apache source.

Also attached is the config.log as config.txt.

Based on a usenet message I found, I downloaded PHP version 4.2.3 as an experiment and noted that:
1. It got past this point--the make completed OK
2. configure still detected oracle as 8.1

I would prefer to get 4.3.2 working though..

Variables:
PATH=/oracle/v92/bin:/usr/ccs/bin:/usr/bin:/bin:/etc:/usr/sbin:/usr/ucb:/usr/local/bin:/tools/bin:.:/usr/lpp/X11/bin:/oracle/v92:/bin:/oracle/v92:/oracle/v92/bin
ORACLE_BASE=/oracle
CLASSPATH=/oracle/v92/JRE:/oracle/v92/jlib:/oracle/v92/product/jlib
ORACLE_SID=tbird
LOCPATH=/usr/lib/nls/loc
ORACLE_DOC=/oracle/v92/doc
ORA_NLS33=/oracle/v92/ocommon/nls/admin/data
LD_LIBRARY_PATH=:/oracle/v92/lib:/oracle/v92/network/lib
ORACLE_HOME=/oracle/v92
PWD=/usr/local/php-4.3.2

Thanks, Don

tsinka

Hi,

please also post the config.status.

npfallen

Attached: config.status

tsinka

And the complete output of configure 🙂

npfallen

No problem.. 🆒

tsinka

Seems like configure is using config.cache. Can you run make distclean to clean up things (or remove the php source directory and ungz/untar the sources again) and rerun configure and post the output again ? From what I can see so far the configure script has problems with the oci support. There should be an OCI output with an Oracle version of 9.2.

Thomas

tsinka

Sorry,

I was wrong, it should tell you the Oracle version 9.2 where it actually says Oracle 8.1.

I saw in one of the attached files that configure missed bison and something seems to be wrong with flex.

I'd suggest to get at least the most recent versions of gnu libtool, sed, flex and bison. Install them and make sure that the path to these newly installed packages comes first in the PATH environment variable.

Additionally you might try to remove libtool from the php source directory and to create a symlink to the most recent version of libtool.

This helps on Solaris and might help on AIX also. I recently compiled php 4.3.0 on AIX with Oracle support but it was a slightly older Oracle (I think something like 9.0).

I attached a configure.txt of a configure executed on a Solaris system. The output should be similar on your AIX system.

If you have a nm on your AIX machine you could try to execute nm /path/to/clientshlib and check the output to see if the symbols exist the linker complains about.

One difference I see is that the configure prints
checking for OCILobIsTemporary in -locijdbc8... (cached) no

in your case but it should be
checking for OCILobIsTemporary in -lclntsh... yes

So far I'm not sure why it checks the jdbc lib and not the clntsh lib. I read some posts about problems compiling php 4.3.2 with Oracle 9.2 maybe the symbols have changed in the client libraries.

Thomas

npfallen

Did a make distclean..

At some point yesterday I tried running configure --with-oracle but not the oci8 extension and this still had the error--just listed the standard ora functions as undefined.

I also tried yesterday to modify configure script to force Oracle_version as 9.0, in two places, but it didn't make a difference.

I looked myself for the same files configure is looking for and found that the
$OCI8_DIR/lib/libclntsh.a was present
and $OCI8_DIR/lib/libcore4.a is not
so that's how the script ends up with
OCI8_VERSION=8.1

There is a libcore9.a

tsinka

Might be a sed problem, try to install the gnu packages I mentioned above and retry the whole stuff.

Thomas

npfallen

Will see what I can do...

Thanks, Don

npfallen

Hi Thomas,

I installed all of those tools but there has been no change--I still am getting those same errors, "Undefined symbol"..... 😕

PATH was set so the /usr/local/bin was first..

I also replaced the PHP libtool with symlink to gnu libtool

Installed;
libtool 1.5
sed 4.0.7
flex 2.5.31
bison 1.875
m4 (required by bison) 1.4

I have attached files..

Any other suggestions? Anyone? Thanks again Thomas for all your time with this.... Don

npfallen

see attached:

npfallen

attached:

tsinka

Hi,

it might help if you post the contentd of the /oracle/v92 folder and the /oracle folder.

Thomas

npfallen

Hi, attached is contents of those folders, plus /oracle/v92/lib.

tsinka

Hi,

there's possibly one problem I can see. The libclntsh.so shared library is missing. Only the static one is in the lib directory.

I don't think that it is a problem that there is a Oracle 8i client installed in /oracle/v817 since the ORACLE_HOME environment variable points to /oracle/v92.

But I think the main problem is that the shared library is missing. Please post the file /oracle/v92/bin/genclntsh. This is the script that generates the shared library. It might be something wrong with it.

The linux version of Oracle 9 for example had a problem with genclntsh that led to a missing libclntsh. It might be the same problem on AIX.

But I have to see the script genclntsh to see if it has that bug.

Besides that ... would it be a problem to move away /oracle/v817 temporarily to test if it has something to do with the php compilation problem ?

Thanks,
Thomas

tsinka

The best way if the script is able to compile the shared library is to log in as oracle9i user and to execute genclntsh. It will possibly show an error message, at least it might be possible that it creates the shared library without any problems 🙂

Worth a try ...

Make sure that the oracle environment variables of user oracle9i are set to the right directories ...

npfallen

I've attached the genclntsh script.. if you don't find anything wrong with it, I will try to run it like you suggested. Thanks, Don.