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

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 value of the key am.dbserver.type=< > .
  1. If value is 'mysql' then follow the step for MySQL database,
  2. If it is 'pgsql' then follow steps for PostgreSql database otherwise, follow the steps for Microsoft SQL database.
Ensure that you have started the Applications Manager service before executing these commands.
Note: After executing these queries, the username and password will be reset to admin/admin.

For MySQL Database:

Open command prompt and navigate to <AppManagerHome>/working/mysql/bin/ directory.
Execute the following command:
For Windows:
mysql -P <mysqlport> -u root -pappmanager -h localhost -D AMDB -e "UPDATE AM_UserPasswordTable SET PASSWORD='$2a$10$va5tAqQobOh/K8sSDdhPZOF4S3rtq2MAxmnXqRVnmNBYg642A8212' WHERE USERNAME IN ('admin', 'systemadmin_enterprise')"
For Linux:
./mysql -P <mysqlport> -u root -pappmanager -h localhost --socket=./../mysql.sock -D AMDB -e "UPDATE AM_UserPasswordTable SET PASSWORD='$2a$10$va5tAqQobOh/K8sSDdhPZOF4S3rtq2MAxmnXqRVnmNBYg642A8212' WHERE USERNAME IN ('admin', 'systemadmin_enterprise')"

Note: In the above commands replace the <mysqlport> with the actual port number of your Applications Manager instance. You can cross check this value by looking up  the am.db.port  key entry in the <AppManagerHome>/conf/AMServer.properties file.

 
For Microsoft SQL Database:

Connect to the corresponding MSSQL database used by that Applications Manager instance and execute the below query:
UPDATE AM_UserPasswordTable SET PASSWORD='$2a$10$va5tAqQobOh/K8sSDdhPZOF4S3rtq2MAxmnXqRVnmNBYg642A8212' WHERE USERNAME IN ('admin', 'systemadmin_enterprise')
To know the Microsoft SQL database details, you can check the AppManagerHome\working\conf\database_params.conf file.

For PostgreSQL Database:

Open a command prompt and navigate to AppManagerHome/working/pgsql/bin/ directory.
Execute the following commands:

For Windows:
set PGPASSWORD=appmanager
psql -p <pgsqlport> -U postgres -h localhost  -d amdb -c "UPDATE AM_UserPasswordTable SET PASSWORD='$2a$10$va5tAqQobOh/K8sSDdhPZOF4S3rtq2MAxmnXqRVnmNBYg642A8212' WHERE USERNAME IN ('admin', 'systemadmin_enterprise')";

For Linux:
export PGPASSWORD=appmanager
./psql -p <pgsqlport> -U postgres -h localhost -d amdb -c "UPDATE AM_UserPasswordTable SET PASSWORD='$2a$10$va5tAqQobOh/K8sSDdhPZOF4S3rtq2MAxmnXqRVnmNBYg642A8212' WHERE USERNAME IN ('admin', 'systemadmin_enterprise')";

Note: In the above commands replace the <pgsqlport> with the actual port number of your Applications Manager instance. You can cross check this value by looking up  the am.db.port  key entry in the <AppManagerHome>/conf/AMServer.properties file.

                  New to ADSelfService Plus?

                    • Related Articles

                    • 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 ...
                    • 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 ...