We have installed openldap-2.4.19 backsql and oracle as RDMS. Everthing works fine when I search for a specific entry.

But If I open a LDAP beowser and expand the tree. It tries to run the following query to load all the entries for ObjectClass NetAcadPerson . Unfortunately this query (this Objectclass has) returns almost one million records.

SELECT DISTINCT ldap_entries.id,NetacadPersons.NetAcadUserID,'NetAcadPerson' objectClass,ldap_entries.dn dn FROM ldap_entries,NetacadPersons WHERE NetacadPersons.NetAcadUserID=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND ldap_entries.parent=? AND 3=3

It was able to load 1000+ records with the following info in the logs ....

backsql_oc_get_candidates(): added entry id=471024, keyval=470924 dn="uid=xxxxx,ou=people,dc=netacad,dc=net"

...

...

dnPrettyNormal: <uid=xxxxx,ou=people,dc=netacad,dc=net>

<<< dnPrettyNormal: <uid=xxxxx,ou=people,dc=netacad,dc=net>, <uid=xxxxxx,ou=people,dc=netacad,dc=net> backsql_oc_get_candidates(): added entry id=471024, keyval=470924 dn="uid=xxxxx,ou=people,dc=netacad,dc=net"

...

...

dnPrettyNormal: <uid=xxxxx,ou=people,dc=netacad,dc=net>

<<< dnPrettyNormal: <uid=xxxxx,ou=people,dc=netacad,dc=net>, <uid=xxxxxx,ou=people,dc=netacad,dc=net>

But after loaading some of them I get the following error ...telling me that the memory allocation falied....

slap_sl_malloc of 16 bytes failed, using ch_malloc slap_sl_malloc of 32 bytes failed, using ch_malloc slap_sl_malloc of 56 bytes failed, using ch_malloc

My questions is - is it possible to restrict number of rows by using "rownum" special ORACLE feature.

By appending some thing like below to the query above.

"AND rownum < 100 "

If it is possible to configure above query, please let me know what slapd configuration I should use. I read all the options in the following man page - http://linux.die.net/man/5/slapd-sql

Let me know if I have any other options to prevent this from happening.

Thanks a lot in advance.

-Nikethan