Hi Buchan,
-----Original Message----- From: Buchan Milne [mailto:bgmilne@staff.telkomsa.net] Sent: Wednesday, July 01, 2009 12:27 PM To: openldap-technical@openldap.org; andreas@krummrich.org Cc: 'Jonathan Clarke' Subject: Re: db_archive: DB_ENV->log_archive: DB_NOTFOUND: No matching key/data pair found
On Wednesday 01 July 2009 12:05:12 Andreas Krummrich wrote:
Hi Jonathan,
-----Original Message----- From: openldap-technical-bounces+andreas=krummrich.org@OpenLDAP.org [mailto:openldap-technical-
bounces+andreas=krummrich.org@OpenLDAP.org]
On Behalf Of Jonathan Clarke Sent: Wednesday, July 01, 2009 11:10 AM To: andreas@krummrich.org Cc: openldap-technical@openldap.org Subject: Re: db_archive: DB_ENV->log_archive: DB_NOTFOUND: No
matching
key/data pair found
Hi Andreas,
On 30/06/2009 16:42, Andreas Krummrich wrote:
I'm running OpenLDAP 2.4.11 on a debian lenny box and it seems
that
I'm
having trouble with the log files. I had a corrupt database some
days
ago
and needed to restore the database from the backup. The log said:
Jun 28 01:16:59 old slapd[17374]: bdb_db_open: database "dc=intern,dc=domain,dc=de" cannot be recovered, err -30978.
Restore
from
backup!
So I installed a new OpenLDAP server with the same versions and
the
same
configuration. The first thing what I found out was that
db_archive
has some
trouble:
On the new box I get the following results from db_archive:
root@new:/var/lib/ldap# db4.2_archive -sa /var/lib/ldap/cn.bdb /var/lib/ldap/dn2id.bdb /var/lib/ldap/gidNumber.bdb /var/lib/ldap/givenName.bdb /var/lib/ldap/id2entry.bdb /var/lib/ldap/loginShell.bdb /var/lib/ldap/objectClass.bdb /var/lib/ldap/sn.bdb /var/lib/ldap/uid.bdb /var/lib/ldap/uidNumber.bdb root@new:/var/lib/ldap# db4.2_archive -la /var/lib/ldap/log.0000000001 root@new:/var/lib/ldap#
Looks good so far. On the old box I get the following results
(there
are the
same databases)
root@new:/var/lib/ldap# db4.2_archive -sa root@new:/var/lib/ldap# db4.2_archive -la db_archive: DB_ENV->log_archive: DB_NOTFOUND: No matching
key/data
pair
found root@new:/var/lib/ldap#
If I understand correctly, your new box works fine, and your old
box
gives you the error "No matching key/data pair found"? (should be root@old above, then?)
Right.
Have you restored the database from backup on your old box aswell?
This
would involve something like rm /var/lib/ldap/* (but save
DB_CONFIG),
then a slapadd.
Yes, I had to restore the db last weekend. I removed everything under /var/lib/ldap and restored the db with slapadd. But the error still
exists.
This is what I can see in /var/log/syslog, for example:
Jul 1 11:54:28 old slapd[2169]: <= bdb_dn2id: get failed:
DB_NOTFOUND: No
matching key/data pair found (-30990)
Now one interesting point. I restored the backup from the old box to
the
new box this morning and it works fine there. No errors. Db42_archive
works
well and I can archive and remove the logs.
I am not satisfied that we know how you restored. You should have:
1)(Re)moved all the contents from /var/lib/ldap, except for the DB_CONFIG file, including the database environment (__db*), database files (*.bdb), and transaction logs (log.*)
2)Run slapadd with the ldif export you had from backup
3)Ensure permissions/ownership are correct on the directory and all the files (the user running slapd must have write access to all).
Please tell us what the exact process was that you used to restore.
Okay ;-)
0) sudo -s 1) /etc/init.d/slapd stop 2) cd /var/lib/ldap 3) rm * 4) slapadd -l /root/bin/old/dc=intern,dc=domain,dc=de.ldif 5) chown openldap: * 6) /etc/init.d/slapd start
This is how I restored the backup to my test box and how I did it this weekend on the productive box where the error still exists. I also removed the DB_CONFIG, but after the restore the DB_CONFIG has the same entries.
Regards, Buchan
Thanks and Regards, Andreas