nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

where alfresco storing the user details like username, pwd

mialfresco

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 ldap, ntlm..etc

thanks in advance.

Find more posts tagged with

Comments

cheffilet

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;

‍‍‍‍

mikeh

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

Mike

mialfresco

Thanks Cheffilet and Mike.

wmay

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 ?

mwildam

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?

cheffilet

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.