Reset Applications Manager login password for admin account (For v15680 and below) ?

Reset Applications Manager login password for admin account (For v15680 and below) ?

Note: If you are using Applications Manager version 15690 and above, refer to this link .

Solution:  Open the <AppManagerHome>\conf\AMServer.Properties file with any text editor and check for the key  am.dbserver.type= < >. If value is 'mssql' then follow the step for Microsoft SQL database, if it is 'pgsql' then follow steps for PostgreSql database otherwise, follow the steps for MySQL database. Make sure you have started Applications Manager before running these commands.

After executing these queries, the username and password will be reset to admin/admin.

For Microsoft SQL Database:

Connect to the corresponding MSSQL database used by that Applications Manager instance and execute the below query:
  1. update AM_UserPasswordTable set PASSWORD = hashbytes('MD5','admin') where USERNAME = 'admin'
You can refer the Microsoft SQL database details in the AppManagerHome\working\conf\database_params.conf file.


For PostgreSQL Database:

For resetting the admin user password, open a command prompt and go to AppManagerHome/working/pgsql/bin/ directory. Then execute the following commands:

For Windows:
  1. set PGPASSWORD=appmanager
  2. psql -p  <pgsqlport>  -U postgres -h localhost  -d amdb -c "UPDATE AM_UserPasswordTable SET PASSWORD='21232f297a57a5a743894a0e4a801fc3' WHERE USERNAME='admin'"

ex:



For Linux:

  1. export PGPASSWORD=appmanager
  2. ./psql -p  <pgsqlport>  -U postgres -h localhost -d amdb -c "UPDATE AM_UserPasswordTable SET PASSWORD='21232f297a57a5a743894a0e4a801fc3' WHERE USERNAME='admin'"

ex:


In the above command replace the  <pgsqlport>  with the actual port number of your Applications Manager instance's PostgreSQL by cross checking the  am.db.port   key   entry  in the <AppManagerHome>/conf/ AMServer.properties  file.


For MySQL Database:

For resetting the admin user password, open command prompt and go to <AppManagerHome>/working/mysql/bin/ directory. Then execute the following command:


For Windows: 
  1. mysql -P  <mysqlport>  -u root -pappmanager -h localhost -D AMDB -e "UPDATE AM_UserPasswordTable SET PASSWORD='21232f297a57a5a743894a0e4a801fc3' WHERE USERNAME='admin'"
For Linux:
  1. ./mysql -P  <mysqlport>  -u root -pappmanager -h localhost --socket=./../mysql.sock -D AMDB -e "UPDATE AM_UserPasswordTable SET PASSWORD='21232f297a57a5a743894a0e4a801fc3' WHERE USERNAME='admin'"

In the above command replace the  
<mysqlport>  with the actual port number of your Applications Manager instance by cross checking the  am.db.port key entry in the <AppManagerHome>/conf/AMServer.properties file.

                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • Reset Applications Manager login password for admin account (For v15690 to v15980)

                      Note: If you're using Applications Manager v15990 and above, check this KB. Follow the steps below to reset the admin account password in Applications Manager: Open the <AppManagerHome>\conf\AMServer.Properties file using a text editor and check the ...
                    • How to reset Super Admin Password in Applications Manager

                      Please follow the steps below to reset Super Admin Password: Note: This option is available from AppManager v15990 only. If you're using older versions, check this KB. These steps are applicable for Microsoft SQL and PostgreSQL database backends. For ...
                    • How to recover forgotten password in Applications Manager

                      In case you have forgotten your account password or if your password does not work, you can request a password reset from the login page of Applications Manager. To do so, follow the steps given below: Prerequisites for password recovery 1. You ...
                    • How to Integrate Site24x7 with Applications Manager

                      To integrate a Site24x7 account with Applications Manager, you need to configure and add OAuth Provider first Steps to configure and add OAuth Provider for Site24x7 Integration Visit https://api-console.zoho.com/ (If your account belongs to another ...
                    • Configuring SAML authentication for Okta in Applications Manager

                      Follow the steps given below to configure SAML authentication for Okta in Applications Manager: 1. Go to www.okta.com. Login to Okta. Click on the Admin tab and navigate to Applications. 2. Click on Create a new app integration and select SAML 2.0 ...