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.

Table Containing username and password

khinendra

Hi,

I want to know that in which table alfresco maintains username and password.
If any one knows please reply? I checked many tables but nowhere found it.

Find more posts tagged with

Comments

mrogers

There isn't one.

There is a person node (which corresponds to your username) and an authentication node (which contains the encrypted password hash (or whatever the internal implementation is).

However the authentication mechanism is configurable so you could use an external authentication system which is based on a user, password table. Most application servers tend to come with one, which you use for development until you bolt into a real authentication system.

khinendra

Hi,
Thanks for reply.

Where can I find these person and authentication node?

renjithnalinam

Hi,

Any of you found where the Alfresco storing the user name and passwords/ where I can find the person and authentication node?

Thanks

joe_l3

The md4 hashed passwords and the user's name are stored in the alf_node_properties table. Try this:

SELECT anp1.node_id,
       anp1.qname_id,
       anp1.string_value as hash_pass,
       anp2.string_value as user_string
FROM alf_node_properties anp1
        INNER JOIN alf_qname aq1            ON aq1.id       = anp1.qname_id
        INNER JOIN alf_node_properties anp2 ON anp2.node_id = anp1.node_id
        INNER JOIN alf_qname aq2            ON aq2.id       = anp2.qname_id
 WHERE aq1.local_name    = 'password'
 AND aq2.local_name    = 'username';‍‍‍‍‍‍‍‍‍‍

renjithnalinam

Thanks Joe

joe_l3

Thanks Joe

😎