MySQL table for Username and Password

[wahyono]

Dear Engineer,


I try to make interfacing for own Application that is authenticate with same username and Password in Alfresco database, i use Alfresco 2.9B and Database MySQL.
but i don't know which table that is contain username and password for Alfresco authentication.

Does anyone know which table contain both username and password? so i can make authentication for my application ?

what kind of encryption does alfresco use for password, is it Password, MD5 or else ?

thank you for helping me.


best regards,


Wahyono

[pmonks]

A better option would be to call a Web Script that has <authentication>user</authentication> in its descriptor (note that you might need to write a simple "no-op" Web Script if an appropriate one doesn't already exist).  This approach insulates your app from any changes that might be made to the underlying data model in future versions of Alfresco, and also ensures that your app will continue to work if you choose to configure Alfresco to use an alternative authentication mechanism (such as LDAP or ActiveDirectory) later on.

Cheers,
Peter