Previous password in Change Password

[ton dev, módosítva 11 év-val korábban]

Where does Liferay store the previous passwords of the user when the history is enabled in the Password Policy of that user??

Example:

If the History Checking is enabled in the password policy and the history count is 6,
is there a file or table where Liferay store these passwords??

Thanks for the help..

[Alireza Zare, módosítva 11 év-val korábban]

In the PasswordTracker.

[ton dev, módosítva 11 év-val korábban]

Many Thanks!!!!

[Alireza Zare, módosítva 11 év-val korábban]

YW :-)

[Mazhar Alam, módosítva 11 év-val korábban]

Hi Ton,
I looked into paswordTracker table and unable to find any entries in it..

[Alireza Zare, módosítva 11 év-val korábban]

Is the password history enabled?

[Mazhar Alam, módosítva 11 év-val korábban]

Yes the password history is enabled in password policy..Is there anything else need to configure??

[Harish Kumar, módosítva 11 év-val korábban]

Hi Mazhar,

1. First enable the "password history" by editing the default password policy.

2. Change the password for any user and then check the password tracker table.

[Mazhar Alam, módosítva 11 év-val korábban]

Got it...seems the password is encrypted...

[Prasanna Raj, módosítva 11 év-val korábban]

can we view the previous passwords from the UI or the control panel?

[Wilson Man, módosítva 11 év-val korábban]

don't think so, generally, you don't want to decrypt passwords and display it. not a good idea.

[Gabriel Leon Leyva, módosítva 11 év-val korábban]

Hi Wilson, Good Morning.

Gabriel León from México, We have a system based on c# and sql server 2005 I want is possible know what tables affect on sql server (liferay tables) so users I create on my system can be created on liferay, changes I made can be change in liferay (like password, name, etc). We want this system to interact with the portal.

Thanks in advance for your help.

[Wilson Man, módosítva 11 év-val korábban]

well, the short answer is User_ table, but you shouldn't update that directly using a different application or manually. Liferay Portal keeps a cache of things, and also has dependencies between tables, so updating its database directly is highly discouraged.

[Hitoshi Ozawa, módosítva 11 év-val korábban]

can we view the previous passwords from the UI or the control panel?

No. If you set in portal-ext.properties to save password in clear text, password will be viewable in the database table. If you database support column encryption, it may be possible to set liferay to save password in clear text and have the database encrypt the password column.