Hi,
I have tried to set up a single instance of slapd serving information from two DITs that
have been defined in separate mysql databases. I can comment out the database entries for
either DIT, and everything works for the other DIT. But it won't support the two DITs
simultaneously (it seems random which DIT will return results and which returns "no
such object" when I restart slapd with both DITs configured). All the odbc stuff for
both backends seems fine, isql runs and of course either database can be accessed through
ldapsearch if it is the only one slapd serves.
I can even run two instances of slapd, one with each DIT and successfully query them
separately with ldapsearch, but I'd prefer one instance with the two DITs if possible.
Could you please help me get this running, or is it just the law that only one sql backend
can be used per server ?
Many thanks
Alan
Slaptest says (when both DITs are defined in one slapd.conf)...
WARNING: No dynamic config support for database sql.
WARNING: No dynamic config support for database sql.
config file testing succeeded
slapd.conf (with both backends/DITs) is:
# $OpenLDAP$
#
# See slapd.conf(5) for details on configuration options.
# This file should NOT be world readable.
#
loglevel 64
moduleload /usr/lib64/openldap/back_sql.la
include /etc/openldap/schema/core.schema
include /etc/openldap/schema/cosine.schema
include /etc/openldap/schema/inetorgperson.schema
include /etc/openldap/schema/farm.schema
# Define global ACLs to disable default read access.
# Do not enable referrals until AFTER you have a working directory
# service AND an understanding of referrals.
#referral
ldap://root.openldap.org
#pidfile /usr/local/var/slapd.pid
#pidfile /var/run/openldap/slapd.pid
#argsfile /usr/local/var/slapd.args
#######################################################################
# sql database definitions
#######################################################################
database sql
suffix "dc=server,dc=farm"
rootdn "cn=root,dc=server,dc=farm"
rootpw ***********
dbname openldap
dbuser openldap
dbpasswd ***************
subtree_cond "ldap_entries.dn LIKE CONCAT('%',?)"
insentry_stmt "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES
(?,?,?,?)"
has_ldapinfo_dn_ru no
database sql
suffix "dc=lab,dc=farm"
rootdn "cn=root,dc=lab,dc=farm"
rootpw **********
dbname lab
dbuser ldap
dbpasswd ********
subtree_cond "ldap_entries.dn LIKE CONCAT('%',?)"
insentry_stmt "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES
(?,?,?,?)"
has_ldapinfo_dn_ru no