How to reset the password of Admin user without using webclient.
I have installed Agile 935. While logging in for the first time, it didn’t take the password I had mentioned during installation. Is there any way that I can reset the password.
Thanks!
Not so hard, and yet rather hard.
All login passwords are stored in AGILEUSER.LOGIN_PWD where LOGINID is the username of the user. But they are always encrypted. And starting with 9.3.2, you could use a number of “better” encryption methods (AES, RSA, etc.) as desired.
But for today, let’s make this simple. Use the following query to set the password to be “agile987” for the “admin” user account :
update agileuser set login_pwd=’LD0RK6THOLTE9IIBD6RVO40L8L5OA1EK’ where loginid = ‘admin’;
If you want to use something else as the password, look for the “encryptPwdUtil.cmd” file in AGILE_HOME/AgileDomain/bin directory. You can find specific directions on how to use it in the Admin Guide manual. Also note that running the above utility multiple times in a row with the same plain-text password may NOT return the same result every time.
Then stop/start the application server so that the new password is read in. The above is not a good method for changing normal user passwords, as it REQUIRES you to stop/start the application server after having made the change in the database.
you can go to users and reset password, is an option to reset, I am using 9.3.1, not sure about 9.3.5
