You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@directory.apache.org by David R Robison <dr...@openroadsconsulting.com> on 2009/12/01 03:41:01 UTC
Re: PostgreSQL as backend
Thanks. Speaking of performance, we have records in our PostgreSQL
database that references contacts in our LDAP. We want to do LFAP
lookups as part of our database SQL calls. To do this we use a Perl
lookup function but for large queries it is quite slow. If the records
were already in a PostgreSQL database then we should be able to make
better benefit of internal indexes and keys. Thanks again. David
Emmanuel Lecharny wrote:
> Hi,
>
> On Mon, Nov 30, 2009 at 11:06 PM, David R Robison
> <dr...@openroadsconsulting.com> wrote:
>
>> Is it possible (or are there plans) to use PostgreSQL as a backend database
>> for Apache Directory Server? Thanks, David
>>
>
> Most certainly. We have an oracle backend being written by Andrea (see
> the dev. ML on archives), it should be possible with some little
> effort to port the code to Postgresql. We just need someone who has
> time to do that.
>
> Note that I'm afraid the performance will be quite low...
>
>
--
David R Robison
Open Roads Consulting, Inc.
103 Watson Road, Chesapeake, VA 23320
phone: (757) 546-3401
e-mail: drrobison@openroadsconsulting.com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526
This e-mail communication (including any attachments) may contain confidential and/or privileged material intended solely for the individual or entity to which it is addressed. If you are not the intended recipient, you should immediately stop reading this message and delete it from all computers that it resides on. Any unauthorized reading, distribution, copying or other use of this communication (or its attachments) is strictly prohibited. If you have received this communication in error, please notify us immediately.
Re: PostgreSQL as backend
Posted by Alex Karasulu <ak...@gmail.com>.
On Tue, Dec 1, 2009 at 8:30 AM, David R Robison <
drrobison@openroadsconsulting.com> wrote:
> Does Apache Directory Server support Virtual Directories?
Not yet but it can easily be altered in the code to do so.
> How would I expose my data through LDAP?
You can have a partition implemented to show your data in your db as a
branch in your DIT if you go with ApacheDS. Just write the partition to
expose some hierarchy for your data after querying it and caching the db
data.
I can go into details if you like but we'd have to offline this conversation
since it's a bit more specific to your situation rather than mainstream to
this list.
Alex
> Thanks for the info. David
>
>
> Alex Karasulu wrote:
>
>> On Mon, Nov 30, 2009 at 10:56 PM, David R Robison <
>> drrobison@openroadsconsulting.com> wrote:
>>
>>
>>
>>> No, what are virtual directories? David
>>>
>>>
>>>
>>>
>> http://en.wikipedia.org/wiki/Virtual_directory
>>
>> Sounds to me like you want to take data that you already have in a
>> database
>> and present it as LDAP to complete your directory. You may have put it
>> there for proximity/performance sake but still need to have it presented
>> via
>> LDAP. A VD can help you do that.
>>
>> HTH,
>>
>>
>>
>
> --
>
> David R Robison
> Open Roads Consulting, Inc.
> 103 Watson Road, Chesapeake, VA 23320
> phone: (757) 546-3401
> e-mail: drrobison@openroadsconsulting.com
> web: http://openroadsconsulting.com
> blog: http://therobe.blogspot.com
> book:
> http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526
>
> This e-mail communication (including any attachments) may contain
> confidential and/or privileged material intended solely for the individual
> or entity to which it is addressed. If you are not the intended recipient,
> you should immediately stop reading this message and delete it from all
> computers that it resides on. Any unauthorized reading, distribution,
> copying or other use of this communication (or its attachments) is strictly
> prohibited. If you have received this communication in error, please notify
> us immediately.
>
--
Alex Karasulu
My Blog :: http://www.jroller.com/akarasulu/
Apache Directory Server :: http://directory.apache.org
Apache MINA :: http://mina.apache.org
Re: PostgreSQL as backend
Posted by David R Robison <dr...@openroadsconsulting.com>.
Does Apache Directory Server support Virtual Directories? How would I
expose my data through LDAP? Thanks for the info. David
Alex Karasulu wrote:
> On Mon, Nov 30, 2009 at 10:56 PM, David R Robison <
> drrobison@openroadsconsulting.com> wrote:
>
>
>> No, what are virtual directories? David
>>
>>
>>
> http://en.wikipedia.org/wiki/Virtual_directory
>
> Sounds to me like you want to take data that you already have in a database
> and present it as LDAP to complete your directory. You may have put it
> there for proximity/performance sake but still need to have it presented via
> LDAP. A VD can help you do that.
>
> HTH,
>
>
--
David R Robison
Open Roads Consulting, Inc.
103 Watson Road, Chesapeake, VA 23320
phone: (757) 546-3401
e-mail: drrobison@openroadsconsulting.com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526
This e-mail communication (including any attachments) may contain confidential and/or privileged material intended solely for the individual or entity to which it is addressed. If you are not the intended recipient, you should immediately stop reading this message and delete it from all computers that it resides on. Any unauthorized reading, distribution, copying or other use of this communication (or its attachments) is strictly prohibited. If you have received this communication in error, please notify us immediately.
Re: PostgreSQL as backend
Posted by Alex Karasulu <ak...@gmail.com>.
On Mon, Nov 30, 2009 at 10:56 PM, David R Robison <
drrobison@openroadsconsulting.com> wrote:
> No, what are virtual directories? David
>
>
http://en.wikipedia.org/wiki/Virtual_directory
Sounds to me like you want to take data that you already have in a database
and present it as LDAP to complete your directory. You may have put it
there for proximity/performance sake but still need to have it presented via
LDAP. A VD can help you do that.
HTH,
--
Alex Karasulu
My Blog :: http://www.jroller.com/akarasulu/
Apache Directory Server :: http://directory.apache.org
Apache MINA :: http://mina.apache.org
Re: PostgreSQL as backend
Posted by David R Robison <dr...@openroadsconsulting.com>.
No, what are virtual directories? David
Alex Karasulu wrote:
> You ever look into virtual directories?
>
> Alex
>
> On Mon, Nov 30, 2009 at 9:41 PM, David R Robison <
> drrobison@openroadsconsulting.com> wrote:
>
>
>> Thanks. Speaking of performance, we have records in our PostgreSQL database
>> that references contacts in our LDAP. We want to do LFAP lookups as part of
>> our database SQL calls. To do this we use a Perl lookup function but for
>> large queries it is quite slow. If the records were already in a PostgreSQL
>> database then we should be able to make better benefit of internal indexes
>> and keys. Thanks again. David
>>
>> Emmanuel Lecharny wrote:
>>
>>
>>> Hi,
>>>
>>> On Mon, Nov 30, 2009 at 11:06 PM, David R Robison
>>> <dr...@openroadsconsulting.com> wrote:
>>>
>>>
>>>
>>>> Is it possible (or are there plans) to use PostgreSQL as a backend
>>>> database
>>>> for Apache Directory Server? Thanks, David
>>>>
>>>>
>>>>
>>> Most certainly. We have an oracle backend being written by Andrea (see
>>> the dev. ML on archives), it should be possible with some little
>>> effort to port the code to Postgresql. We just need someone who has
>>> time to do that.
>>>
>>> Note that I'm afraid the performance will be quite low...
>>>
>>>
>>>
>>>
>> --
>>
>> David R Robison
>> Open Roads Consulting, Inc.
>> 103 Watson Road, Chesapeake, VA 23320
>> phone: (757) 546-3401
>> e-mail: drrobison@openroadsconsulting.com
>> web: http://openroadsconsulting.com
>> blog: http://therobe.blogspot.com
>> book:
>> http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526
>>
>> This e-mail communication (including any attachments) may contain
>> confidential and/or privileged material intended solely for the individual
>> or entity to which it is addressed. If you are not the intended recipient,
>> you should immediately stop reading this message and delete it from all
>> computers that it resides on. Any unauthorized reading, distribution,
>> copying or other use of this communication (or its attachments) is strictly
>> prohibited. If you have received this communication in error, please notify
>> us immediately.
>>
>>
>
>
>
>
--
David R Robison
Open Roads Consulting, Inc.
103 Watson Road, Chesapeake, VA 23320
phone: (757) 546-3401
e-mail: drrobison@openroadsconsulting.com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526
This e-mail communication (including any attachments) may contain confidential and/or privileged material intended solely for the individual or entity to which it is addressed. If you are not the intended recipient, you should immediately stop reading this message and delete it from all computers that it resides on. Any unauthorized reading, distribution, copying or other use of this communication (or its attachments) is strictly prohibited. If you have received this communication in error, please notify us immediately.
Re: PostgreSQL as backend
Posted by Alex Karasulu <ak...@gmail.com>.
You ever look into virtual directories?
Alex
On Mon, Nov 30, 2009 at 9:41 PM, David R Robison <
drrobison@openroadsconsulting.com> wrote:
> Thanks. Speaking of performance, we have records in our PostgreSQL database
> that references contacts in our LDAP. We want to do LFAP lookups as part of
> our database SQL calls. To do this we use a Perl lookup function but for
> large queries it is quite slow. If the records were already in a PostgreSQL
> database then we should be able to make better benefit of internal indexes
> and keys. Thanks again. David
>
> Emmanuel Lecharny wrote:
>
>> Hi,
>>
>> On Mon, Nov 30, 2009 at 11:06 PM, David R Robison
>> <dr...@openroadsconsulting.com> wrote:
>>
>>
>>> Is it possible (or are there plans) to use PostgreSQL as a backend
>>> database
>>> for Apache Directory Server? Thanks, David
>>>
>>>
>>
>> Most certainly. We have an oracle backend being written by Andrea (see
>> the dev. ML on archives), it should be possible with some little
>> effort to port the code to Postgresql. We just need someone who has
>> time to do that.
>>
>> Note that I'm afraid the performance will be quite low...
>>
>>
>>
>
> --
>
> David R Robison
> Open Roads Consulting, Inc.
> 103 Watson Road, Chesapeake, VA 23320
> phone: (757) 546-3401
> e-mail: drrobison@openroadsconsulting.com
> web: http://openroadsconsulting.com
> blog: http://therobe.blogspot.com
> book:
> http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526
>
> This e-mail communication (including any attachments) may contain
> confidential and/or privileged material intended solely for the individual
> or entity to which it is addressed. If you are not the intended recipient,
> you should immediately stop reading this message and delete it from all
> computers that it resides on. Any unauthorized reading, distribution,
> copying or other use of this communication (or its attachments) is strictly
> prohibited. If you have received this communication in error, please notify
> us immediately.
>
--
Alex Karasulu
My Blog :: http://www.jroller.com/akarasulu/
Apache Directory Server :: http://directory.apache.org
Apache MINA :: http://mina.apache.org