Re: openLDAP + Oracle

["Pierangelo Masarati" <ando@sys-net.it>]

It appears to be related to iODBC configuration (see below),
unless you can trace down any error in the use of ODBC code
in back-sql (which I do not consider probable, because
back-sql is known to work with iODBC and Oracle, although
I never tried personally).

I suggest you review your iODBC configuration files,
and check if all the required drives are available.

p.

> Hi,
>
> Trying to get openLDAP work with Oracle 9i via back-sql
>
> Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_get_db_conn()
> Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_open_db_conn()
> Mar 26 05:25:56 localhost slapd[4444]: backsql_open_db_conn:
> SQLConnect() to database 'loe' as user 'loe' failed:
> Mar 26 05:25:56 localhost slapd[4444]: Return code: -1
> Mar 26 05:25:56 localhost slapd[4444]: Native error code: 0
> Mar 26 05:25:56 localhost slapd[4444]: SQL engine state: IM002
> Mar 26 05:25:56 localhost slapd[4444]: Message: [iODBC][Driver
> Manager]Data source name not found and no default driver specified.
> Driver could not be loaded

^^^

> Mar 26 05:25:56 localhost slapd[4444]: backsql_get_db_conn(): could not
> get connection handle -- returning NULL
> Mar 26 05:25:56 localhost slapd[4444]: backsql_db_open(): connection
> failed, exiting
> Mar 26 05:25:56 localhost slapd[4444]: backend_startup: bi_db_open(0)
> failed! (1)
> Mar 26 05:25:56 localhost slapd[4444]: slapd shutdown: initiated
> Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_db_close()
> Mar 26 05:25:56 localhost slapd[4444]: <==backsql_db_close()
> Mar 26 05:25:56 localhost slapd[4444]: slapd shutdown: freeing system
> resources.
> Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_db_destroy()
> Mar 26 05:25:56 localhost slapd[4444]: ==>backsql_free_db_env()
> Mar 26 05:25:56 localhost slapd[4444]: <==backsql_free_db_env()
> Mar 26 05:25:56 localhost slapd[4444]: ==>destroy_schema_map()
> Mar 26 05:25:56 localhost slapd[4444]: <==destroy_schema_map()
> Mar 26 05:25:56 localhost slapd[4444]: <==backsql_db_destroy()
> Mar 26 05:25:56 localhost slapd[4444]: slapd stopped.
> Mar 26 05:25:56 localhost slapd[4444]: connections_destroy: nothing to
> destroy.
> ~
>
> Other details :
>
> It connects via SQLPLUS and also JDBC..i have checked my tnsnames.ora
> file many times...i still have no idea why this error occurs when I try
> to connect :
>
> [root@localhost bin]# ./isql ORACLE -v
>
> [08001][unixODBC][Easysoft][Oracle]ORA-12154: TNS:could not resolve
> service name
>
> [ISQL]ERROR: Could not SQLConnect
>
> Here is my odbc.ini and odbcinst.ini files and also my tnsnames.ora
>
> odbc.ini
>
> ========
>
> [ODBC Data Sources]
>
> [ORACLE]
>
> Driver = ORACLE
>
> Database = loe
>
> Host = 15.70.187.13
>
> ServerType = Oracle 9
>
> SID = newsid
>
> Port = 1521
>
> User = loe
>
> Password = loe
>
> METADATA_ID = 0
>
> ENABLE_USER_CATALOG = 1
>
> ENABLE_SYNONYMS = 1
>
> ====================
>
> Odbcinst.ini
>
> ============
>
> [ORACLE]
>
> Description = Easysoft ODBC Oracle Driver
>
> Driver = /opt/easysoft/oracle/libesoracle.so
>
> Setup = /opt/easysoft/oracle/libesoraclesetup.so
>
> FileUsage = 1
>
> Tnsnames.ora
>
> ===========
>
> w2k3 =
>
> (DESCRIPTION =
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = 15.70.187.13)(PORT = 1521))
>
> )
>
> (CONNECT_DATA =
>
> (SERVER = DEDICATED)
>
> (SID = newsid)
>
> )
>
> )
>
> Sqlnet.ra
>
> ==========
>
> #NAMES.DEFAULT_DOMAIN = localdomain
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
> ============================
>
> This is what I get when I connect thro SQLPLUS...
>
> [root@localhost bin]# cat /home/ravi/OraHome1/network/admin/sqlnet.ora
>
> # SQLNET.ORA Network Configuration File:
> /home/ravi/OraHome1/network/admin/sqlnet.ora
>
> # Generated by Oracle configuration tools.
>
> #NAMES.DEFAULT_DOMAIN = localdomain
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
> [root@localhost bin]# /home/ravi/OraHome1/bin/sqlplus loe/loe@w2k3
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Fri Mar 26 01:55:51 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
>
> Connected to:
>
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
>
> With the Partitioning, OLAP and Oracle Data Mining options
>
> JServer Release 9.2.0.1.0 - Production
>
> SQL>
>
> Any pointers would be appreciated,
>
>
> Any ideas??
>
> Thanks,
> Ravi


-- 
Pierangelo Masarati
mailto:pierangelo.masarati@sys-net.it