We rebuilt our QA instance using the production app file system and database.
After this, we decided to change the password for "Admin" user.
So, I used kEncrypt.sh fron ITG/bin and encrypted a password. Then I updated knta_users table for username = 'admin'
and set password = 'above encrypted value'. Committed the transaction.
After this I am getting invalid username/password error.
I tried this multiple time, but no luck.
Is there any way to retrieve admin account or is there a way to set a new password for admin?
Please note, none of the other users in the system have the 'Open Workbench' access or "User Administration" access.
you have to remove the #!# delimiter from the beginning and the end of the encrypted text :)
I just did an step by step guide, please check the attachment file and let us know the results.
you forgot to mention the call to the "set define off" statement - this is useful since the encrypted text might contain the & character.
The best way to do this.
In my opinion it is not a good practice to have the same password for PROD and non-PROD environments.
Sorry I missed to mention...
Once the password issue is resolved.. then change the password of Destination envrionment.