[Fedora-directory-users] Deleting database

[Ville Silventoinen]

On Fri, 23 Mar 2007, Noriko Hosoi wrote:

> Richard Megginson wrote:
>> Ville Silventoinen wrote:
>>> On Fri, 23 Mar 2007, Richard Megginson wrote:
>>> 
>>>> Ville Silventoinen wrote:
>>>>> On Fri, 23 Mar 2007, Richard Megginson wrote:
>>>>> 
>>>>>> Ville Silventoinen wrote:
>>>>>>> On Thu, 22 Mar 2007, Richard Megginson wrote:
>>>>>>> 
>>>>>>>> Ville Silventoinen wrote:
>>>>>>>>> I'm using Fedora DS 1.0.4. I've written an application that uses 
>>>>>>>>> Fedora DS and next I'm planning to write unit tests. I'm wondering 
>>>>>>>>> if there is a way to delete the whole userRoot database and create 
>>>>>>>>> it again? I searched the documentation and there seems to be a way 
>>>>>>>>> to create the database from command line, but no way to delete it, 
>>>>>>>>> except from the GUI?
>>>>>>>> Just delete the entry (e.g. delete cn=userRoot,cn=ldbm 
>>>>>>>> database,cn=plugins,cn=config).  You will have to do some sort of 
>>>>>>>> recursive deletion to remove all of the child entries.  I think this 
>>>>>>>> is what the GUI does - just check the access logs for the server 
>>>>>>>> after deleting the database in the console.
>>>>>>> 
>>>>>>> Thank you Richard, that worked very well. I also delete the mapping 
>>>>>>> tree entry, which maps the suffix to the backend database:
>>>>>>>
>>>>>>>   dn: cn="dc=ebi,dc=ac,dc=uk",cn=mapping tree,cn=config
>>>>>>>   objectclass: top
>>>>>>>   objectclass: extensibleObject
>>>>>>>   objectclass: nsMappingTree
>>>>>>>   nsslapd-state: backend
>>>>>>>   nsslapd-backend: userRoot
>>>>>>>   cn: dc=ebi,dc=ac,dc=uk
>>>>>>> 
>>>>>>> The GUI works slightly differently, it sets nsslapd-state to 
>>>>>>> "disabled" and removes the nsslapd-backend attribute.
>>>>>>> 
>>>>>>> If anyone has a need for a script that can delete and create a 
>>>>>>> database, I can send it to the list. I use Python with python-ldap 
>>>>>>> package.
>>>>>>> 
>>>>>>> Thank you very much for a fast response!
>>>>>> If you just want to restore the database to it's initial state, you can 
>>>>>> just do an import - ldif2db or ldif2db.pl - this will remove the 
>>>>>> previous contents and create a new database.  This might be sufficient 
>>>>>> for your purposes, without having to delete the database and mapping 
>>>>>> tree entries. See ldif2db.pl for how to invoke an import operation via 
>>>>>> ldap
>>>>> 
>>>>> This may be a stupid question but how do I get ldif2db.pl to remove the 
>>>>> previous contents so it can create the entries?
>>>>> 
>>>>> I tried like this:
>>>>>
>>>>>   ./ldif2db.pl -v -D "cn=Directory Manager" -w mypassword -n userRoot -i 
>>>>> /path/to/userRoot.ldif
>>>>> 
>>>>> but in the errors log it shows for every entry "WARNING: Skipping 
>>>>> duplicate entry".
>>>> That usually means there are duplicate entries in your userRoot.ldif file 
>>>> - can you post it somewhere and post the link to it here?  I'd rather not 
>>>> spam the list with a large ldif file.
>>> 
>>> Thanks Richard! You were right, all the entries were defined twice in the 
>>> file. I don't understand how that happened, I used the "Export Databases"
>>> task in the Console to create the file. If the file already exists, does 
>>> it append new entries to it? I must have done something wrong...
>> It might append to it.  I'm not sure.
> I could not reproduce it.  If I choose the same file name to export database, 
> I get "File '<filename>' already exists. Its contents will be overwritten. 
> Do you want to continue?" dialog box, and my existing file is really 
> overwritten...

I tried it as well, I couldn't reproduce the problem either. Unfortunately 
I deleted the file so I cannot check in which order the entries were.

Thanks for the help.

Ville