1:21 p.m.
Does OpenLdap support an oracle backend database? I have an existing
database with users that I'd like to put an LDAP interface in front of
to service other clients. Is this possible?
Thanks,
Leon
1:18 a.m.
King, Leon C wrote:
Does OpenLdap support an oracle backend database? I have an
existing
database with users that I'd like to put an LDAP interface in front of
to service other clients. Is this possible?
It should, using ODBC. However, you need to cast your data into a
structure that makes sense, according to guidelines and examples
provided here <http://www.openldap.org/faq/data/cache/978.html>;. Oracle
is not listed as "supported" simply because nobody who's using Oracle
cared to update the FAQ entry. The listed ones are those I could check
with, and lots of information might be out of date as that work is now
years old (given the evolution of MySQL, for example, I guess most of
the encountered limitations can now be easily overcome).
p.
Ing. Pierangelo Masarati
OpenLDAP Core Team
SysNet s.r.l.
via Dossi, 8 - 27100 Pavia - ITALIA
http://www.sys-net.it
-----------------------------------
Office: +39 02 23998309
Mobile: +39 333 4963172
Fax: +39 0382 476497
Email: ando(a)sys-net.it
-----------------------------------
10:07 a.m.
P,
Thanks for the info. I've built the package. Are there any
examples of the odbc.ini and odbcinst.ini files for oracle. I've also
installed the UNIXODBC package.
Thanks,
Leon King
Development Team Lead OASIS/ICIS WEB
Service Assurance
Outside: 919-378-6626
v-net: 965-6626
-----Original Message-----
From: Pierangelo Masarati [mailto:ando@sys-net.it]
Sent: Saturday, January 24, 2009 4:19 AM
To: King, Leon C
Cc: openldap-software(a)openldap.org
Subject: Re: Oracle back_sql support question openldap-2.4.11
King, Leon C wrote:
Does OpenLdap support an oracle backend database? I have an
existing
database with users that I'd like to put an LDAP interface in front of
to service other clients. Is this possible?
It should, using ODBC. However, you need to cast your data into a
structure that makes sense, according to guidelines and examples
provided here <http://www.openldap.org/faq/data/cache/978.html>;. Oracle
is not listed as "supported" simply because nobody who's using Oracle
cared to update the FAQ entry. The listed ones are those I could check
with, and lots of information might be out of date as that work is now
years old (given the evolution of MySQL, for example, I guess most of
the encountered limitations can now be easily overcome).
p.
Ing. Pierangelo Masarati
OpenLDAP Core Team
SysNet s.r.l.
via Dossi, 8 - 27100 Pavia - ITALIA
http://www.sys-net.it
-----------------------------------
Office: +39 02 23998309
Mobile: +39 333 4963172
Fax: +39 0382 476497
Email: ando(a)sys-net.it
-----------------------------------
3:59 p.m.
I have a server with the full Oracle 10 instance. I installed the
UNIXODBC package from the http://www.unixodbc.org/ website to compile.
What else do I need? Do I need to specify a file in the
'oracle/10.1.0/lib' directory. Unfortunately I can't find much
documentation.
Leon King
Development Team Lead OASIS/ICIS WEB
Service Assurance
Outside: 919-378-6626
v-net: 965-6626
-----Original Message-----
From:
openldap-software-bounces+leon.king=verizonbusiness.com(a)OpenLDAP.org
[mailto:openldap-software-bounces+leon.king=verizonbusiness.com@OpenLDAP
.org] On Behalf Of alessio
Sent: Wednesday, January 28, 2009 5:38 PM
To: openldap-software(a)openldap.org
Subject: Re: Oracle back_sql support question openldap-2.4.11
King, Leon C wrote:
P,
Thanks for the info. I've built the package. Are there any
examples of the odbc.ini and odbcinst.ini files for oracle. I've also
installed the UNIXODBC package.
And which oracle driver are you using?
Bye
A
1:07 a.m.
King, Leon C wrote:
I have a server with the full Oracle 10 instance. I installed the
UNIXODBC package from the http://www.unixodbc.org/ website to compile.
What else do I need? Do I need to specify a file in the
'oracle/10.1.0/lib' directory. Unfortunately I can't find much
documentation.
This is my /etc/odbc.ini
[ORACOLO]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = ORACOLODRIVER
DSN = ORACOLO
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName = ORACOLODB01
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
UserID =
And this is my /etc/odbcinst.ini
[ORACOLODRIVER]
Description = Oracle ODBC driver for Oracle 10g
Driver = /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1
Setup =
FileUsage =
CPTimeout =
CPReuse = 0
Btw... I don't know what some of these attributes means...
Surely "Driver =" in odbc.ini must be the same in odbcinst.ini
And "ServerName = ORACOLODB01" must be the name defined in tnsnames.ora
Another useful thing is to add these lines to odbcinst.ini for debugging
purposes
[ODBC]
# Serve solo per avere un log
Trace = Yes
TraceFile = /tmp/ODBCsql.log
ForceTrace = Yes
Pooling = No
At last I can suggest to use isql command
isql -v ORACOLO dbuser dbpassword
Greetings,
A
5:26 p.m.
Hi,
I have an encrypted password in the database. I'm using
back_sql to transact with an oracle database. How do I configure the
ldap_attr_mappings table to encrypt the plain text password that is
passed for authentication. I have an oracle PL_SQL function that is
used to encrypt a password before it is stored, I was planning to uses
this same function in the where clause. Is this possible? Am I heading
in the right direction?
Thanks,
Leon
5396
days inactive
5430
days old
openldap-software@openldap.org
6 comments
3 participants
participants (3)
-
alessio -
King, Leon C -
Pierangelo Masarati