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
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@sys-net.it -----------------------------------
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@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@sys-net.it -----------------------------------
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@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@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
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
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
openldap-software@openldap.org
-
alessio -
King, Leon C -
Pierangelo Masarati