cancel
Showing results for 
Search instead for 
Did you mean: 

How can I delete a user duplicated?

ejml
Champ in-the-making
Champ in-the-making
Hello folks:

My problem is that I have a user duplicated in the system and I cannot delete by the convencional way. there is other way to delete one of them.

Thanks in Advance!!
13 REPLIES 13

andy
Champ on-the-rise
Champ on-the-rise
Hi

Which version of alfresco are you using?

Regards

Andy

ejml
Champ in-the-making
Champ in-the-making
My alfresco's version is 1.4

andy
Champ on-the-rise
Champ on-the-rise
Hi

See authentication-services-context.xml. This defines the person service impl bean. It is possible to configure this to deal with duplicate users. There are a few simple options to decide which of a set of duplicate users is best. Given the best - the rest can be left, the username changed to uid+guid to aviod conflict, or deleted.

Regards

Andy

ejml
Champ in-the-making
Champ in-the-making
Sorry but I don't see this options on file.

Where is it?

Thanks.

andy
Champ on-the-rise
Champ on-the-rise
Hi

See
http://wiki.alfresco.com/wiki/Security_and_Authentication#Handling_duplicate_person_entries_for_the_...

If you have support then you can also do this in 1.4, if not you will have to split users in the DB.

How did you get the duplicates?

Regards

Andy

ejml
Champ in-the-making
Champ in-the-making
I don't think really, I created the user, then when the user tried to do loggin on the system, the system said that the user not exist, than I tried create the user again, after I rebooted the system and there was the duplicate's users.

How do I split the user in the DB?, What is the user's table?

Thanks

ejml
Champ in-the-making
Champ in-the-making
I Have tried this in the authentication-services-context.xml:


<!– The person service.                                                –>

    <bean id="personService" class="org.alfresco.repo.security.person.PersonServiceImpl">
      <property name="nodeService">
          <ref bean="nodeService" />
      </property>
      <property name="searchService">
          <ref bean="searchService" />
      </property>
      <property name="permissionServiceSPI">
         <ref bean="permissionServiceImpl" />
      </property>
        <property name="authorityService">
           <ref bean="authorityService" />
        </property>
      <property name="namespacePrefixResolver">
         <ref bean="namespaceService" />
      </property>
        <!– Configurable properties.                                 –>
        <!–                                                          –>
        <!– TODO:                                                    –>
        <!– Add support for creating real home spaces adn setting    –>
        <!– permissions on the hame space and people created.        –>
        <!–                                                          –>
        <!– The store in which people are persisted.                 –>
        <property name="storeUrl">
           <value>${spaces.store}</value>
        </property>
        <!– Some authentication mechanisms may need to create people –>
        <!– in the repository on demand. This enables that feature.  –>
        <!– If dsiabled an error will be generated for missing       –>
        <!– people. If enabled then a person will be created and     –>
        <!– persisted.                                               –>
        <!–                                                          –>
        <!– This value should be false or only true if the           –>
        <!– repository is mutable; set from the property             –>
        <!– ${server.transaction.allow-writes}                       –>
        <property name="createMissingPeople">
           <value>${server.transaction.allow-writes}</value>
        </property>
      <property name="userNamesAreCaseSensitive">
          <value>${user.name.caseSensitive}</value>
        </property>
   <property name="processDuplicates">
      <value>true</value>
   </property>
   <property name="duplicateMode">
      <value>DELETE</value>
   </property>

    </bean>

But it thrown a error:

Invalid property processDuplicates

andy
Champ on-the-rise
Champ on-the-rise
Hi

The error is because support for this missed 1.4 community; it is in 2.0.

You best approach is to update to 2.0.

If you must ….you can try this - at your own risk!

As always, if you make changes to the DB you can make your system unusable, if you have no back up, you may not be able to recover and you could be stuffed.

The table details are:

alf_node_properties .. column qname ..     {http://www.alfresco.org/model/content/1.0}userName

You can find all the user name properties with duplicates …

What you do to them is up to you - I suggest you back up your DB first, and change any duplicate user ids to split them. You will need to do a full index rebuild after.


Regards

Andy

ejml
Champ in-the-making
Champ in-the-making
I don't have idea that Alfresco 2.0 had been released.