topic Re: Problem with users in Alfresco Archive

Problem with users

lc — Mon, 30 Oct 2006 08:35:13 GMT

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 Di

Re: Problem with users

lc — Tue, 31 Oct 2006 08:47:06 GMT

Please .

Re: Problem with users

derek — Tue, 31 Oct 2006 13:42:25 GMT

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

Re: Problem with users

lc — Tue, 31 Oct 2006 14:55:21 GMT

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)"

Re: Problem with users

lc — Tue, 07 Nov 2006 16:01:38 GMT

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

Is it possible to delete them manually ?

Thanks .

Re: Problem with users

ajshaw — Thu, 09 Nov 2006 09:19:34 GMT

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();
‍‍‍‍‍‍‍‍‍‍‍‍