Error starting apache with mod_dbd and dbd_odbc

[xoft]

Hi,

I have the following problem:
I have compiled the apr_dbd_odbc with '#define APR_DSO_BUILD 1'
added on apr.h.
It compiled ok but when i start the apache web server i get the
following error:

[Fri Jul 11 14:03:33 2008] [dbd_odbc] SQLConnect returned SQL_ERROR
(-1) at apr_dbd_odbc.c:596 [unixODBC][Driver Manager]Can't open lib '/
tmp/lib/libsqora.so.10.1' : libclntsh.so.10.1: cannot open shared
object file: No such file or directory 01000

The files are there, cause i use them to run my CGI which uses the
ODBC driver to connect to an oracle server.
I'm running OpenSuse 10.3 with Apache 2.2.4
I checked the permissions, i even moved the libraries to /tmp folders
and i still get the same result. I have even added the APU_DSO_BUILD
and tried this way...
Do you have any idea?

Thanks,

[xoft]

I managed to figure out what was the root of the problem. I had to
export in LD_LIBRARY_PATH the oracle lib's prior starting apache2. i
had in httpd.conf set env var with the oracle path but it seems it
wasn't ok.
Anyway, now i have another problem:
"[Fri Jul 11 16:32:13 2008] [dbd_odbc] SQLConnect returned SQL_ERROR
(-1) at apr_dbd_odbc.c:596 [unixODBC][Oracle][ODBC][Ora]ORA-01005:
null password given; logon denied
28000
"
even if i set the password like this:
DBDParams "DATASOURCE=test,USER=sa,PASSWORD='testare' "

If you have any ideea let me know.
Thanks,

[TomD]

Two possibilities I can think of:

1. You need an updated Oracle ODBC driver from
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html

2. You need to set the NLS_LANG environment variable, e.g.:
export NLS_LANG=English_America.WE8ISO8859P1

Hope this helps,
-tom-