topic Re: Table Containing username and password in Alfresco Archive

Table Containing username and password

khinendra — Tue, 01 Dec 2009 11:05:41 GMT

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.

Re: Table Containing username and password

mrogers — Tue, 01 Dec 2009 11:28:23 GMT

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.

Re: Table Containing username and password

khinendra — Tue, 01 Dec 2009 11:53:58 GMT

Hi,
Thanks for reply.

Where can I find these person and authentication node?

Re: Table Containing username and password

renjithnalinam — Thu, 08 Apr 2010 12:11:07 GMT

Hi,

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

Thanks

Re: Table Containing username and password

joe_l3 — Thu, 08 Apr 2010 16:26:35 GMT

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';‍‍‍‍‍‍‍‍‍‍

Re: Table Containing username and password

renjithnalinam — Fri, 09 Apr 2010 07:36:01 GMT

Thanks Joe

Re: Table Containing username and password

joe_l3 — Fri, 09 Apr 2010 08:01:20 GMT

Thanks Joe

😎