topic How can I delete a user duplicated? in Alfresco Archive

How can I delete a user duplicated?

ejml — Mon, 15 Jan 2007 10:12:03 GMT

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

Re: How can I delete a user duplicated?

andy — Wed, 17 Jan 2007 12:31:55 GMT

Hi

Which version of alfresco are you using?

Regards

Andy

Re: How can I delete a user duplicated?

ejml — Wed, 17 Jan 2007 14:18:32 GMT

My alfresco's version is 1.4

Re: How can I delete a user duplicated?

andy — Fri, 26 Jan 2007 11:07:21 GMT

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

Re: How can I delete a user duplicated?

ejml — Fri, 26 Jan 2007 11:32:07 GMT

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

Where is it?

Thanks.

Re: How can I delete a user duplicated?

andy — Mon, 29 Jan 2007 15:38:06 GMT

Hi

See
http://wiki.alfresco.com/wiki/Security_and_Authentication#Handling_duplicate_person_entries_for_the_same_uid_-_from_2.0_onwards

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

Re: How can I delete a user duplicated?

ejml — Mon, 29 Jan 2007 16:03:42 GMT

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

Re: How can I delete a user duplicated?

ejml — Tue, 30 Jan 2007 08:25:41 GMT

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

Re: How can I delete a user duplicated?

andy — Tue, 30 Jan 2007 09:46:08 GMT

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

Re: How can I delete a user duplicated?

ejml — Tue, 30 Jan 2007 10:06:54 GMT

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

Re: How can I delete a user duplicated?

andy — Tue, 30 Jan 2007 10:23:10 GMT

Hi

The 2.0 preview is now out.

Regards

Andy

Re: How can I delete a user duplicated?

ejml — Tue, 30 Jan 2007 14:50:45 GMT

Ok, now I have deleted the username but I Still have the entry with username null and with name, there is some way to delete this entries.

Regards.

Thanks

Re: How can I delete a user duplicated?

andy — Wed, 31 Jan 2007 15:58:36 GMT

Hi

If you had given the fixed duplicate a real uid and rebuilt the index you could delete via the UI.

Regards

Andy

Re: How can I delete a user duplicated?

ejml — Wed, 31 Jan 2007 16:23:33 GMT

ufff!!, I deleted all entries of duplicate's user in the table.

Regards