topic Re: where alfresco storing the user details like username, pwd in Alfresco Archive

where alfresco storing the user details like username, pwd

mialfresco — Fri, 31 Jul 2009 12:41:46 GMT

Hi team,I'm using mysql with alfresco labs 3.0.I have created a couple of users through explorer. but i didn't found these users in mysql db.Can anyone tell me where it is storing the user details (user name, password..) and security mechanism.NOTE: i'm not using any other security mechanisms like l

Re: where alfresco storing the user details like username, pwd

cheffilet — Fri, 31 Jul 2009 13:18:34 GMT

Alfresco 3 Labs Final


SELECT * FROM (select * from alf_node where type_qname_id = 5) users, alf_node_properties properties WHERE users.id = properties.node_id;

‍‍‍‍

Re: where alfresco storing the user details like username, pwd

mikeh — Fri, 31 Jul 2009 13:43:58 GMT

Note, however that's it's a really, really bad idea to access the database directly (except perhaps read-only operations).

Mike

Re: where alfresco storing the user details like username, pwd

mialfresco — Mon, 03 Aug 2009 05:24:22 GMT

Thanks Cheffilet and Mike.

Re: where alfresco storing the user details like username, pwd

wmay — Tue, 04 Aug 2009 18:28:10 GMT

Note, however that's it's a really, really bad idea to access the database directly (except perhaps read-only operations).

Yes but this information where to find the user in the database can be useful - we had the situation (not only one time) during our tests of the CE 3.2 that Alfresco added multiple "dummy" admin users with the same ID "admin" but with multiple and different names and we had no other chance to reset the database. There is no way from the UI to remove or delete such "automatic" added users. Maybe it is possible by direct delete such entries from the database. The real problem is that it is not clear from where such "dummy admins" are added if this happens only one time or each time a certain action is performed and also for each of these users a home folder is created …..

Maybe it can be a way to look to the database and to delete such "ghost users" till the bug is found and fixed.

Does anybody also had such "automatic" added "admin" users - which can not removed via the normal application ?

Re: where alfresco storing the user details like username, pwd

mwildam — Wed, 05 Aug 2009 08:11:01 GMT

And the other important question: If deleting users using SQL with a statement deriving from the one above, are there other links that should be deleted then also?

Re: where alfresco storing the user details like username, pwd

cheffilet — Wed, 05 Aug 2009 09:03:03 GMT

My intention on posting a SQL-Statement was far from using Create, Update or even Delete-Operations. Thats a realy bad idea and i totally aggree with Mike.