Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
I have a system that has an oracle database of employees in my building. What I am trying to do is use LDAP with that database since it already contains all the entries that I would need. Is there any way for me to use the oracle database as the backend for my LDAP software? Thanks in advance for any feedback.
Thank you for the input. I had thought about doing that actually. My boss just wanted me to find a way to use oracle with LDAP, and you always have to listen to the boss man right? :-)
Maybe I can get him to come around.
Yes, you listen, then you gently explain why they're wrong and how to do it properly, because that's your function.
To answer the original question...
Oracle is a Relational Database. It does well with multiple tables of related data. LDAP is based on a tree structured database... it is basically a binary tree indexed flat-file. Using Oracle as a backend to LDAP would be hugely inefficient, as Oracle simply isn't optimised for the sort of access LDAP requires.
That, and the fact that Oracle licenses are expensive, and pretty much all LDAP servers come with Sleepycat or something bundled.
Sorry for the late reply on this. I was wondering if anyone had an idea as to how to get the extracted data into ldif format. I can extract the data to an ldif file using spool but of course this isn't in correct ldif format. Any suggestions?
I just talked with my boss and he'd like me to write this script in Perl. I've done some basic perl modules in my time but haven't gone too in depth. I'm reading up on it right now. I welcome any suggestions to point me in the right direction though :-)
If it was me, and it was a one-off Oracle -> LDAP transfer, I'd run a simple select SQL script to a text file, and then parse this with awk to create the LDIF.
If you need to use Perl, though, you want to look at the DBD::Oracle CPAN module and DBI in general.
I'd still be interested in knowing the overarching reasoning behind what you are trying to achieve here. I get the actual things you are trying to do, but I just don't get why... not that it's any of my business, but I might be able to give some overall guidance rather than a step-by-step how-to.
Well we have an oracle database of the employees in my building. When a new employee comes in they are added to our systems and to the database as well. My boss wants LDAP to be used so that users can have a good way to look up information about other users in the building (office, email, etc.). What I need to do is make it so that the LDAP database updates when the oracle database updates so that this is all done automatically. I don't know if that makes it more clear or not.