How can I delete a user duplicated?

[ejml]

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!!

[andy]

Hi

Which version of alfresco are you using?

Regards

Andy

[ejml]

My alfresco's version is 1.4

[andy]

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]

Sorry but I don't see this options on file.

Where is it?

Thanks.

[andy]

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]

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]

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]

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]

I don't have idea that Alfresco 2.0 had been released.