Re: ldap info
my last gig was senior DBA at an internet travel shop, and we used LDAP to authenticate users. Since it is really just a glorified list sitting in memory, it is perfectly suited to small, straightforward uses such as this. We did not use oracle LDAP, but another vendor that I can't remember. The LDAP was accessed by the Java processes and gathered the password and username from it to login to the database. hth, jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: One of the users here came to me to talk about setting up user authentication and wanted to know what I knew about LDAP and Oracle. since the sum total of my knowledge on the subject consists of Oracle Internet Directory is a pain to set up I thought I might ask for advice from some who are more familiar with the subject. We will have something on the order of a million hits a day, this is definitely ONLY user authentication. We are not wedded to the idea that it has to be part of Oracle, if there is another, better (easier/stable) way to handle this, we are open to using that. Any suggestions on places to look? A search on LDAP in the 9.2 docs got me over 1300 matches... a bit overwhelming! I'm going to be reading through the OID admin manual, but that's somewhat prejudiced towards Oracle :) Rachel __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ldap info
thanks! that's pretty much the way we want to use it as well, for a universal login across any of our websites. Sun has an LDAP that we are looking at as well. The plus is, it's free. and we don't need another oracle license etc etc etc and even better, it wouldn't be MY responsibility to maintain :) Rachel --- Jack Silvey [EMAIL PROTECTED] wrote: my last gig was senior DBA at an internet travel shop, and we used LDAP to authenticate users. Since it is really just a glorified list sitting in memory, it is perfectly suited to small, straightforward uses such as this. We did not use oracle LDAP, but another vendor that I can't remember. The LDAP was accessed by the Java processes and gathered the password and username from it to login to the database. hth, jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: One of the users here came to me to talk about setting up user authentication and wanted to know what I knew about LDAP and Oracle. since the sum total of my knowledge on the subject consists of Oracle Internet Directory is a pain to set up I thought I might ask for advice from some who are more familiar with the subject. We will have something on the order of a million hits a day, this is definitely ONLY user authentication. We are not wedded to the idea that it has to be part of Oracle, if there is another, better (easier/stable) way to handle this, we are open to using that. Any suggestions on places to look? A search on LDAP in the 9.2 docs got me over 1300 matches... a bit overwhelming! I'm going to be reading through the OID admin manual, but that's somewhat prejudiced towards Oracle :) Rachel __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ldap info
free is good, especially when it comes to ldap and beer. ;) jack --- Rachel Carmichael [EMAIL PROTECTED] wrote: thanks! that's pretty much the way we want to use it as well, for a universal login across any of our websites. Sun has an LDAP that we are looking at as well. The plus is, it's free. and we don't need another oracle license etc etc etc and even better, it wouldn't be MY responsibility to maintain :) Rachel --- Jack Silvey [EMAIL PROTECTED] wrote: my last gig was senior DBA at an internet travel shop, and we used LDAP to authenticate users. Since it is really just a glorified list sitting in memory, it is perfectly suited to small, straightforward uses such as this. We did not use oracle LDAP, but another vendor that I can't remember. The LDAP was accessed by the Java processes and gathered the password and username from it to login to the database. hth, jack silvey --- Rachel Carmichael [EMAIL PROTECTED] wrote: One of the users here came to me to talk about setting up user authentication and wanted to know what I knew about LDAP and Oracle. since the sum total of my knowledge on the subject consists of Oracle Internet Directory is a pain to set up I thought I might ask for advice from some who are more familiar with the subject. We will have something on the order of a million hits a day, this is definitely ONLY user authentication. We are not wedded to the idea that it has to be part of Oracle, if there is another, better (easier/stable) way to handle this, we are open to using that. Any suggestions on places to look? A search on LDAP in the 9.2 docs got me over 1300 matches... a bit overwhelming! I'm going to be reading through the OID admin manual, but that's somewhat prejudiced towards Oracle :) Rachel __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from
RE: ldap info
Jack, What was the internet travel company? Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 my last gig was senior DBA at an internet travel shop, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ldap info
Oracle LDAP is free if you have purchased the full-blown version of iAS. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 11, 2002 1:35 PM To: Multiple recipients of list ORACLE-L One of the users here came to me to talk about setting up user authentication and wanted to know what I knew about LDAP and Oracle. since the sum total of my knowledge on the subject consists of Oracle Internet Directory is a pain to set up I thought I might ask for advice from some who are more familiar with the subject. We will have something on the order of a million hits a day, this is definitely ONLY user authentication. We are not wedded to the idea that it has to be part of Oracle, if there is another, better (easier/stable) way to handle this, we are open to using that. Any suggestions on places to look? A search on LDAP in the 9.2 docs got me over 1300 matches... a bit overwhelming! I'm going to be reading through the OID admin manual, but that's somewhat prejudiced towards Oracle :) Rachel __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ldap info
we aren't using iAS. --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: Oracle LDAP is free if you have purchased the full-blown version of iAS. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 11, 2002 1:35 PM To: Multiple recipients of list ORACLE-L One of the users here came to me to talk about setting up user authentication and wanted to know what I knew about LDAP and Oracle. since the sum total of my knowledge on the subject consists of Oracle Internet Directory is a pain to set up I thought I might ask for advice from some who are more familiar with the subject. We will have something on the order of a million hits a day, this is definitely ONLY user authentication. We are not wedded to the idea that it has to be part of Oracle, if there is another, better (easier/stable) way to handle this, we are open to using that. Any suggestions on places to look? A search on LDAP in the 9.2 docs got me over 1300 matches... a bit overwhelming! I'm going to be reading through the OID admin manual, but that's somewhat prejudiced towards Oracle :) Rachel __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ldap info
XXtra online, owner of powertrip and MyTrip. Yet another failed dotcom in the vast wasteland of free money and no management to speak of. --- Larry Elkins [EMAIL PROTECTED] wrote: Jack, What was the internet travel company? Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 my last gig was senior DBA at an internet travel shop, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LDAP deployment
Very briefly, we found: a) it works fine b) its a pain to setup since the doco (at 8i) was scant to say the least c) the error handling was poor, namely, every kind of error gave a generic An error has occurred type of message So there is some short term pain, but once its done, it works well hth connor --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Hi all, Where can I find some articles on LDAP deployment apart from OTN and Oracle sites? I am looking for real life experiences from users. We use Oracle 8i and 9i. If you have deployed it, what is your experience? Is it worth the effort? Thanks in advance Happy Holidays Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LDAP and Oracle
No, but I'd also be mighty interested to hear about the details. My problem here is that I've got a couple of applications (heck, most of the applications - including all the Oracle ones) that are not LDAP compliant. Most have their own internal security setup. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@fuels cc: pot.com Subject: LDAP and Oracle Sent by: [EMAIL PROTECTED] om 08/15/2001 10:01 AM Please respond to ORACLE-L Anyone use LDAP to work with Oracle to handle single login between various applications. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LDAP
iPlanet are what's left of Netscape Corporation's server products group, after they were eaten by the unholy alliance of Sun and AOL. They had an application server (Netscape App Server, nee Kiva plus LiveWire) which used a mysterious combination of C++ and JavaScript to create AppLogic(tm). It was an OK product, if a little quirky but it rapidly fell out of favor (at least at the consulting shop I was working at at the time) when WebLogic matured, since that was a lot more reliable and standards-compliant (J2EE). And they liked Cold Fusion too, because it was cheap and let people with minimal experience develop database-backed web sites, but I've never thought of Cold Fusion as anything more than a toy. Having said that, I've used Oracle Application Server versions 2 to 4. Version 2 was pretty good relative to what else was available in the market, but 3 and 4 really slipped behind unless you were 100% Oracle, for example deploying Forms and Reports on the web. If you wanted a general-purpose app server for, say, a JSP based web site, you would be better off with WebLogic or Sapphire or something. OAS 4 on NT was dreadful, it really was the nail in the coffin as far as I was concerned, which is odd because Oracle RDBMS on NT is very good, so it's not as if Oracle don't know what they're doing on that platform. My current favorite, for the last year or so, is ATG Dynamo. This app server is fast, powerful, easy to use and very reliable. But it should be, for what you pay for it! Cheers, g -Original Message- Sent: Wednesday, June 20, 2001 9:12 PM To: Multiple recipients of list ORACLE-L Related to this, I seem to recall reading something the other day that led me to believe that iPlanet is somewhat in competition with Oracle's app server product. Does anyone know if this is true? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LDAP
Stephane, This was very interesting...I am still perking on this...i have looked at the dbmsldap package, and admit to some ignoranceit seems that this PL/SQL package is good for making calls to OID (Oracle's LDAP) but I do not see how these package calls could be used to access the Netscape/iPlanet tool. Is this via the OpenLDAP libraries you cited? Have you the time to illuminate further? With thanks, and apologies for thick-headedness, - Ross -Original Message- Sent: Wednesday, June 13, 2001 4:42 PM To: Multiple recipients of list ORACLE-L Mohan, Ross wrote: Anyone have any idea when/if the Net8 clients will support/interface with Netscape/iPlanet LDAP offerings? Any thoughts welcome...! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Ross, I don't know if this has anything to do with your problem but I was looking for a way to make Oracle applications access the contents of a Netscape LDAP server. The idea was to map pseudo-tables upon PL/SQL tables (using the object option) so as to enable applications to issue SELECT * FROM LDAP$... types of queries. The problem is of course first to map the essentially hierarchical structure of a LDAP directory into relational tables (Back to the Future IV), and to create 'derived' views to hold multivalued attributes, and, as I am lazy, to do it automatically. I have a program (currently very ugly) written using OpenLDAP libraries which connects to the Netscape server and 'shows' (text mode, yek) the contents. You select the information you want to map with Oracle and it generates code to do it. Charlie Mengler has pointed me to the DBMS or UTL LDAP package, which can be used to fill the PL/SQL tables with the proper info. In my case, there was a snag, which is that it cannot work with MTS - and I have MTS. So I also generate C code for a daemon. I have a prototype in which the daemon writes a file used as cache which is then read with UTL_FILE by the PL/SQL function which fills the tables. Not very smart but it works. I am putting the last touch to another daemon which gets requests and sends info through an Oracle pipe, thus acting as a kind of proxy for the LDAP server. Would like to turn this into a true product, but still very far from it. -- HTH, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LDAP
I wouldn't look for it anytime soon. I recently spoke to the OID product manager about this issue, and he not only held out no hope for this, he asserted that the correct approach was to use meta-directory technology to sync OID with iPlanet. He also told me that the LDAP standards are a bit loose, and that each LDAP directory vendor tends to go their own way a bit, and that consequently, interoperability is not easy to achieve. Related to this, I seem to recall reading something the other day that led me to believe that iPlanet is somewhat in competition with Oracle's app server product. Does anyone know if this is true? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Wednesday, June 13, 2001, 1:21:14 PM, you wrote: MR Anyone have any idea when/if the Net8 clients will MR support/interface with Netscape/iPlanet LDAP offerings? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LDAP
I work for a consulting firm that specializes in iPlanet offerings. iPlanet offers a web server, application server, and LDAPand more. See http://www.iplanet.com/ Somewhat in competition? At my firm, they are in direct competition. I am presenting Oracle 9iAS this Friday to the group, to see if they will even consider an in-house 9iAS trial. -Joe Related to this, I seem to recall reading something the other day that led me to believe that iPlanet is somewhat in competition with Oracle's app server product. Does anyone know if this is true? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LDAP
Mohan, Ross wrote: Anyone have any idea when/if the Net8 clients will support/interface with Netscape/iPlanet LDAP offerings? Any thoughts welcome...! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Ross, I don't know if this has anything to do with your problem but I was looking for a way to make Oracle applications access the contents of a Netscape LDAP server. The idea was to map pseudo-tables upon PL/SQL tables (using the object option) so as to enable applications to issue SELECT * FROM LDAP$... types of queries. The problem is of course first to map the essentially hierarchical structure of a LDAP directory into relational tables (Back to the Future IV), and to create 'derived' views to hold multivalued attributes, and, as I am lazy, to do it automatically. I have a program (currently very ugly) written using OpenLDAP libraries which connects to the Netscape server and 'shows' (text mode, yek) the contents. You select the information you want to map with Oracle and it generates code to do it. Charlie Mengler has pointed me to the DBMS or UTL LDAP package, which can be used to fill the PL/SQL tables with the proper info. In my case, there was a snag, which is that it cannot work with MTS - and I have MTS. So I also generate C code for a daemon. I have a prototype in which the daemon writes a file used as cache which is then read with UTL_FILE by the PL/SQL function which fills the tables. Not very smart but it works. I am putting the last touch to another daemon which gets requests and sends info through an Oracle pipe, thus acting as a kind of proxy for the LDAP server. Would like to turn this into a true product, but still very far from it. -- HTH, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LDAP/OID
Dave Morgan wrote: Hi all, OID is not worth the hassle of installing, but, has anyone used a regular LDAP server to hold Oracle database information? Details would be appreciatted. TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 What do you mean, holding Oracle database information ? Storing TNS aliases? They would still need to be mapped to port/host/sid. Or for authentification ? I have been working on this very recently, but it still need to be polished a little. Basically, the idea is to map pseudo-views over information collected from a (Netscape) LDAP server. Applications can then access information from the LDAP server through SQL. I am not madly happy with my current implementation (which uses a flat file, regularly refreshed, as cache. Uh.) but it's promising. e-mail me privately if you want some details. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LDAP/OID
Four years ago, I worked on a project to publish employee/people data sourced in Oracle to Netscape LDAP. We first mapped our relational data to V3 objectclasses attributes, and defined our own objectclasses attributes as needed. Then we created a table that held: primary_key table_name transaction_type transaction_date ldap_update_status. Change events were logged to this table using triggers, and a PERL script generated LDIF changes based on events in this table. PERL used DBD/DBI to Oracle, and CL utilities ldapsearch/ldapmodify to LDAP. Not exactly elegant, but for a low-volume transaction database (approx 6000 changes per day) it worked well. We did this back when LDAP was relatively new, and we had experience with X500 so it was considered a huge improvement. Oracle remained the data source for employee/people published to LDAP, and LDAP was the data source for other data like passwords, certificates and preferences. LDAP served the needs of 70,000+ employees who used it for directory lookups, password certificate authentication, e-mail and calendar prefs, group lists, etc. We also integrated LDAP authentication and access control for hundreds of web-based applications. LDAP is definately worthwhile, good planning on schema design is must. Haven't done anything yet with OID except install and look at it. Suzy Dave Morgan wrote: Hi all, OID is not worth the hassle of installing, but, has anyone used a regular LDAP server to hold Oracle database information? Details would be appreciatted. TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
