----+---------------------------------------+------------+-----------+------------+----------+-------------+-------------+---------------+
| id | oc_map_id | name | sel_expr | sel_expr_u | from_tbls | join_where | add_proc | delete_proc | param_order | expect_return |
+-----+-----------+---------------+---------------------------------------+------------+-----------+------------+----------+-------------+-------------+---------------+
| 1 | 1 | cn | concat(
persons.name,,persons.surname) | NULL | persons | NULL | NULL | NULL | 3 | 0 |
| 2 | 1 | sn |
persons.surname | NULL | persons |
NULL | NULL | NULL | 3 | 0 |
|
4 | 1 | displayname | persons.displayname |
NULL | persons | NULL | NULL | NULL
| 3 | 0 |
| 3 | 1 | uid |
persons.uid | NULL | persons |
NULL | NULL | NULL | 3 | 0 |
| 101 | 101 | uid |
persons.name | NULL | persons | NULL | NULL | NULL | 3 | 0 |
| 102 | 101 | uidNumber | 2000 | NULL | persons | NULL | NULL | NULL | 3 | 0 |
| 103 | 101 | gidNumber | 2000 | NULL | persons | NULL | NULL | NULL | 3 | 0 |
| 104 | 101 | homeDirectory |
persons.name | NULL | persons | NULL | NULL | NULL | 3 | 0 |
+-----+-----------+---------------+---------------------------------------+------------+-----------+------------+----------+-------------+-------------+---------------+
select * from ldap_entry_objclasses;
+----------+------------------+
| entry_id | oc_name |
+----------+------------------+
| 2 | posixAccount |
| 7 | extensibleObject |
| 1 | inetOrgPerson |
+----------+------------------+
select * from ldap_entries;
+----+-------------------+-----------+--------+--------+
| id | dn | oc_map_id | parent | keyval |
+----+-------------------+-----------+--------+--------+
| 1 | dc=example,dc=com | 1 | 0 | 1 |
| 2 | cn=sri ram | 1 | 1 | 2 |
+----+-------------------+-----------+--------+--------+
select * from ldap_oc_mappings;
+-----+---------------+---------+--------+-------------+-------------+---------------+
| id | name | keytbl | keycol | create_proc | delete_proc | expect_return |
+-----+---------------+---------+--------+-------------+-------------+---------------+
| 1 | inetOrgPerson | persons | id | NULL | NULL | 0 |
| 101 | posixAccount | persons | id | NULL | NULL | 0 |
+-----+---------------+---------+--------+-------------+-------------+---------------+
select * from persons;
+----+------+---------+------+-------------+
| id | name | surname | uid | displayname |
+----+------+---------+------+-------------+
| 1 | sri | ram | 12 | sriram |
+----+------+---------+------+-------------+
while doing ldapsearch after this we encountered the error,
ldapsearch error
# extended LDIF
#
# LDAPv3
# base <> with scope subtree
# filter: (objectclass=*)
# requesting: ALL
#
# search result
search: 2
result: 80 Internal (implementation specific) error
# numResponses: 1
what is the problem here??
whats that internal error??
our slapd.conf looks like...
# This is the main slapd configuration file. See slapd.conf(5) for more
# info on the configuration options.
#######################################################################
# Global Directives:
# Features to permit
#allow bind_v2
# Schema and objectClass definitions
include /etc/ldap/schema/core.schema
include /etc/ldap/schema/cosine.schema
include /etc/ldap/schema/nis.schema
include /etc/ldap/schema/inetorgperson.schema
# Where the pid file is put. The init.d script
# will not stop the server if you change this.
pidfile /var/run/slapd/slapd.pid
# List of arguments that were passed to the server
argsfile /var/run/slapd/slapd.args
# Read slapd.conf(5) for possible values
loglevel 0
# Where the dynamically loaded modules are stored
modulepath /usr/lib/ldap
moduleload back_sql
# The maximum number of entries that is returned for a search operation
sizelimit 500
# The tool-threads parameter sets the actual amount of cpu's that is used
# for indexing.
tool-threads 1
#######################################################################
# Specific Backend Directives for bdb:
# Backend specific directives apply to this backend until another
# 'backend' directive occurs
backend sql
checkpoint 512 30
#######################################################################
# Specific Backend Directives for 'other':
# Backend specific directives apply to this backend until another
# 'backend' directive occurs
#backend <other>
#######################################################################
# Specific Directives for database #1, of type bdb:
# Database specific directives apply to this databasse until another
# 'database' directive occurs
database sql
suffix "dc=example,dc=com"
rootdn "cn=admin,dc=example,dc=com"
rootpw ldap
dbname ldap
dbuser new
dbpasswd new
insentry_query "insert into ldap_entries (id,dn,oc_map_id,parent,keyval) values ((select max(id)+1 from ldap_entries),?,?,?,?)"
upper_func "upper"
strcast_func "text"
concat_pattern "?||?"
has_ldapinfo_dn_ru no
schemacheck on
lastmod off
# The base of your directory in database #1
suffix "dc=example,dc=com"
# rootdn directive for specifying a superuser on the database. This is needed
# for syncrepl.
rootdn "cn=admin,dc=example,dc=com"
rootpw XXX
# Where the database file are physically stored for database #1
directory "/var/lib/ldap"
# For the Debian package we use 2MB as default but be sure to update this
# value if you have plenty of RAM
dbconfig set_cachesize 0 2097152 0
# Sven Hartge reported that he had to set this value incredibly high
# to get slapd running at all. See
http://bugs.debian.org/303057
# for more information.
# Number of objects that can be locked at the same time.
dbconfig set_lk_max_objects 1500
# Number of locks (both requested and granted)
dbconfig set_lk_max_locks 1500
# Number of lockers
dbconfig set_lk_max_lockers 1500
# Indexing options for database #1
index objectClass eq
cn,sn,ou
# Save the time that the entry gets modified, for database #1
lastmod on
# Where to store the replica logs for database #1
# replogfile /var/lib/ldap/replog
# The userPassword by default can be changed
# by the entry owning it if they are authenticated.
# Others should not be able to see it, except the
# admin entry below
# These access lines apply to database #1 only
access to attrs=userPassword,shadowLastChange
by dn="cn=admin,dc=example,dc=com" write
by anonymous auth
by self write
by * none
# Ensure read access to the base for things like
# supportedSASLMechanisms. Without this you may
# have problems with SASL not knowing what
# mechanisms are available and the like.
# Note that this is covered by the 'access to *'
# ACL below too but if you change that as people
# are wont to do you'll still need this if you
# want SASL (and possible other things) to work
# happily.
access to dn.base="" by * read
# The admin dn has full write access, everyone else
# can read everything.
access to *
by dn="cn=admin,dc=example,dc=com" write
by * none
# For Netscape Roaming support, each user gets a roaming
# profile for which they have write access to
#access to dn=".*,ou=Roaming,o=morsnet"
# by dn="cn=admin,dc=example,dc=com" write
# by dnattr=owner write
#######################################################################
# Specific Directives for database #2, of type 'other' (can be bdb too):
# Database specific directives apply to this databasse until another
# 'database' directive occurs
#database <other>
# The base of your directory for database #2
#suffix "dc=debian,dc=org"