topic Re: User password in database in Alfresco Archive

User password in database

sheva7 — Tue, 05 Aug 2008 10:19:32 GMT

Hi,Is it possible to find user password directly in the database ? With one tool like phpMyAdmin or else ?I know users are in the alf_authority table but i can't find passwords.Thank you.———————————————–Alfresco v2.9b on Windows Server 2003———————————————–

Re: User password in database

samudaya — Thu, 05 May 2011 17:33:21 GMT

Hi,

Do you which hashing is this used?

I want to add user account by manually (by using sql query) what are the relevant tables?

Thanks
Sam

Re: User password in database

mrogers — Thu, 05 May 2011 18:54:04 GMT

You should probably be using the API rather than trying to guess alfresco's private implementation details. We never recommend writing directly to the alfresco database.

Or another, probably better, way of doing it is to store your passwords in some authentication system and then have alfresco access them from there.

Re: User password in database

samudaya — Fri, 06 May 2011 17:25:31 GMT

Thanks Mrogers.

I'm new to Alfresco. I would like to use separate PHP module to add users to system and edit password by using this php module. If you have any idea could you please help me?

Thanks…..