Problem with users

[lc]

Hello,

I have a problem with Alfresco 1.4.

Before I was in 1.2.1 version.

I have updated to the 1.3.1 scheme and I'm using the 1.4 version.

Everything seems to work fine, but I have a bug with users.

I have three times the same user and I can't delete them.

I'm using NTLM (only one user "psi" in Active Directory).

How can I delete them ?

[img]http://img95.imageshack.us/img95/8453/alf01yj9.jpg[/img]

[img]http://img88.imageshack.us/img88/5262/alf02jk9.jpg[/img]

Thanks .

[lc]

Please .

[derek]

Hi,

You didn't notice the 1.4 schema upgrade scripts running on first startup?  I take it they worked, then 😉

Query:

select * from alf_node_properties where qname = '{http://www.alfresco.org/model/user/1.0}username' order by string_value;‍‍

If the user doesn't occur multiple times in the database, then the indexes can be rebuilt.  Otherwise you can rename the users in the database and rebuild the indexes to reflect the changes.

To rebuilt indexes, move the Lucene index folder away and in repository.properties, change the following:

index.recovery.mode=FULL‍‍

At any rate, let us know what the query returned.

Regards

[lc]

Hello,

The result  :

mysql> select * from alf_node_properties where qname = '{http://www.alfresco.org/model/user/1.0}username' order by string_value;
+———+————-+————–+—————-+—————+————+————-+————–+————–+——————–+————–
————————————+
| node_id | actual_type | multi_valued | persisted_type | boolean_value | long_value | float_value | double_value | string_value | serializable_value | qname
                                    |
+———+————-+————–+—————-+—————+————+————-+————–+————–+——————–+————–
————————————+
|       7 | STRING      |            0 | STRING         |             0 |          0 |           0 |            0 | admin        | NULL               | {http://www.a
lfresco.org/model/user/1.0}username |
+———+————-+————–+—————-+—————+————+————-+————–+————–+——————–+————–
————————————+
1 row in set (0.09 sec)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

With "index.recovery.mode=FULL" it was ok.

I have deleted the 3 users, but the problem is that with other users I had the same problem (2 admin for example).

And I can't connect or disconnect :

"org.alfresco.error.AlfrescoRuntimeException: Found more than one user for admin (case insensitive)"

[lc]

After a restoration, I still have the problem of the 3 users.

Is it possible to delete them manually ?

Thanks .

[ajshaw]

i have had this issue before (but duplicate persons not users). I found all the duplicate person objects for a particylar user using the nodebrowser

@cm\:userName:"joe smith"‍

and then ran all those uuids through a script to remove them

function doIt() {

str =  ""+document.id+"<—-gone";
document.remove();

return str;
}


doIt();
‍‍‍‍‍‍‍‍‍‍‍‍