[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
ldap SQL backend and syncrepl
- To: openldap-technical@openldap.org
- Subject: ldap SQL backend and syncrepl
- From: Frederic Bouy <frederic.bouy@gmail.com>
- Date: Tue, 21 Apr 2009 15:57:11 +0200
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=7NWNnw0cSp404gboZPYeGLUZHNtSVjV3BiCJ6UbQyAw=; b=pY75MzqPta6SYUS/74jDH0tP+sJ8MazpCowaBeTeYwogG0V0o2ipYXq4HCMqOglPMT edKh9UtPITa1HFblvIR6sMf/E8VWkFho4kEMZt79VTzD4R+JIcI4IeXM5Mr3djWrWPKU d1ZV+NN1qtFrnsHdtkMpUq06nyZlg0pYFL7gs=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=ZoDAUYQ99UYqA3wTiwFJ/q189xFyzwUHfM+3v9hc439BwbATSmuUSTMourpyNn21NK V18yTt9m34xHRKyhUagp051J3LLkJ1R86JzZ/RexT+tX0XcLzbUFz5gXcOkPOQfPTvzK aLRJ3Bf1WSyWSmAzWztnmL51Q0ZXegDEbfCh0=
Hello,
For performance issues (millions or records) I have two ldap servers:
- one master with an sql backend (postgres) to allow easy data manipulation
- one slave to anwer ldap queries and provide good response time
When lauching the slave ("./slapd -f /usr/local/openldap/etc/openldap/slapd-front.conf -h "ldap://localhost:3890" -d 1") I got a first non blocking error I don't really understand:
" => bdb_dn2id("dc=lnp")
<= bdb_dn2id: get failed: DB_NOTFOUND: No matching key/data pair found (-30988)"
According to the fact that the following command is successfull:
"ldapwhoami -H "ldap://localhost:389" -D "cn=manager,dc=lnp" -w secret"
and then the synchronization fails with this error:
"read1msg: ld 0x9ca73e8 msgid 2 message type search-entry
ber_scanf fmt ({xx) ber:
ber_scanf fmt ({a) ber:
ber_scanf fmt (o) ber:
ber_scanf fmt ({em) ber:
do_syncrep2: rid=001 got empty syncUUID with LDAP_SYNC_ADD
ldap_msgfree
connection_get(11): got connid=0
ldap_free_request (origid 2, msgid 2)
ldap_free_connection 1 1
ldap_send_unbind
ber_flush2: 7 bytes to sd 11
ldap_free_connection: actually freed
do_syncrepl: rid=001 quitting"
Do you know whether suncrepl is support for ldap with sql backend?
Do you know where can I find some documentation on this?
Do you have any clue on how I could solve my issues?
Thanks in advance.
Please find below the .conf of those two ldap servers:
# === MASTER =====
include /usr/local/openldap/etc/openldap/schema/core.schema
include /usr/local/openldap/etc/openldap/schema/cosine.schema
include /usr/local/openldap/etc/openldap/schema/nis.schema
include /usr/local/openldap/etc/openldap/schema/inetorgperson.schema
include /usr/local/openldap/etc/openldap/schema/lnp.schema
pidfile /usr/local/openldap/var/slapd-lnp.pid
argsfile /usr/local/openldap/var/slapd-lnp.args
backend sql
#######################################################################
# sql database definitions
#######################################################################
database sql
suffix "dc=lnp"
rootdn "cn=Manager,dc=lnp"
rootpw secret
dbname lnp
dbuser lnp
dbpasswd lnp
strcast_func "text"
#subtree_cond "ldap.entries.dn like '%'||?"
concat_pattern "?||?"
has_ldapinfo_dn_ru no
overlay syncprov
syncprov-checkpoint 100 10
syncprov-sessionlog 100
lastmod on
# === MASTER =====
include /usr/local/openldap/etc/openldap/schema/core.schema
include /usr/local/openldap/etc/openldap/schema/cosine.schema
include /usr/local/openldap/etc/openldap/schema/nis.schema
include /usr/local/openldap/etc/openldap/schema/inetorgperson.schema
include /usr/local/openldap/etc/openldap/schema/lnp.schema
pidfile /usr/local/openldap/var/run/slapd-front.pid
argsfile /usr/local/openldap/var/run/slapd-front.args
#######################################################################
# BDB database definitions
#######################################################################
database bdb
suffix "dc=lnp"
rootdn "cn=Manager,dc=lnp"
rootpw secret
directory /usr/local/openldap/var/openldap-data
# index entryCSN,entryUUID eq
index entryUUID eq
# filter="(objectClass=*)"
syncrepl rid=001
provider=ldap://localhost:389
bindmethod=simple
type=refreshAndPersist
searchbase="ou=31,dc=lnp"
schemachecking=off
binddn="cn=manager,dc=lnp"
credentials=secret
filter="(objectClass=*)"
mirrormode on
serverID 1