tag:blogger.com,1999:blog-1555497785494345295.post1973658225582172761..comments2023-11-05T03:06:55.414-08:00Comments on Barry McGillin: SQLCl - LDAP anyone?Barry McGillinhttp://www.blogger.com/profile/12215907295974180145noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1555497785494345295.post-12033306138703030302018-06-10T13:38:04.240-07:002018-06-10T13:38:04.240-07:00Hi Barry,
As of version 18.1.1, SQLCL still doesn...Hi Barry,<br /><br />As of version 18.1.1, SQLCL still doesn't seem to work with the "standard" configuration for LDAP support per my post above. Will it ever?<br /><br />Thanks,<br />Jack<br /><br />p.s. On my Windows 7 desktop, using the "set LDAPCON jdbc..." syntax described in your post above does not work. However, if I instead use "set LDAPCON<b>=</b>jdbc..." it works fine. Not sure if your post above has a syntax error or if my PC is somehow not respecting that syntax without the "=" sign.Jackhttps://www.blogger.com/profile/07856439504599211494noreply@blogger.comtag:blogger.com,1999:blog-1555497785494345295.post-64364390731739647532016-06-20T14:38:06.928-07:002016-06-20T14:38:06.928-07:00We can and will certainly look at that. We can al...We can and will certainly look at that. We can also do a show ldap which will walk the order tree and tell you what we can see. We also do this with show tns to show the tns locations.Barry McGillinhttps://www.blogger.com/profile/12215907295974180145noreply@blogger.comtag:blogger.com,1999:blog-1555497785494345295.post-9456414676822798842016-05-28T10:40:23.510-07:002016-05-28T10:40:23.510-07:00Hi Barry,
I'm a long time Oracle user and am ...Hi Barry,<br /><br />I'm a long time Oracle user and am just now converting from SQL*Plus to SQLcl. Looks like a great tool to replace sqlplus (saying that with a tear in my eye).<br /><br />I know you describe a way to use LDAP in this article, but we've standardized on Oracle's LDAP (OID) server in our shop. It is a standard setup as described in Oracle documentation, where we have setup the SQLNET.ORA and LDAP.ORA files with the LDAP_ADMIN and TNS_ADMIN environment variable pointing to their location.<br /><br />Is there a chance you could provide support for this setup?<br /><br />Proper support for it would follow these steps:<br />1) Look for the LDAP_ADMIN env variable first, and if that didn't exist, look for the TNS_ADMIN variable.<br />2) Look for the SQLNET.ORA file in the path specified in env variable<br />3) Interrogate the NAMES.DIRECTORY_PATH line in the SQLNET.ORA file to verify whether preference for name resolution is LDAP or TNSNAMES.<br />4) If LDAP, look in LDAP.ORA file for LDAP server details. Then try to lookup the database connection details. If not found, try the next connection method specified in NAMES.DIRECTORY_PATH directive above.<br /><br /><br />Thanks!<br />JackJackhttps://www.blogger.com/profile/07856439504599211494noreply@blogger.com