Community and Support

            NFA and NCM 12 Default Admin password Reset_postgres Database


            1. Open a command prompt

            2. Go to the <Opmanager_HOME>\pgsql\bin directory

            3. Type
            For Windows    :   psql -U postgres -p 13306 -h 127.0.0.1 -d OpManagerDB
            For Linux        :   ./psql -U postgres -p 13306 -h 127.0.0.1 -d OpManagerDB

            Please exectue the below query :

            select name,apikey from ApiKeyToUserMap inner join AAALogin on AAALogin.USER_ID=ApiKeyToUserMap.APIKEYID inner join ApiKey on ApiKey.APIKEYID=ApiKeyToUserMap.APIKEYID where name='admin';

            4 . Copy the API Key from the output of the query.

            5. Install the Google chrome Postman add-on.

            https://chrome.google.com/webstore/detail/postman-rest-client-short/mkhojklkhkdaghjjfdnphfphiaiohkef?hl=en

            6. Open a Google chrome browser and open Postman add-on and execute the below API command in POST method to reset the password.

            For Example:

            http://localhost:8080/api/json/nfaadmin/changePassword?apiKey=34b77304c502174eaf8b70b034254071&newPwd=admin&userName=admin

            Localhost - Opmanager server IP:webserverport
            API key - Copied from the command output
            New Password- new password for admin user

            Attachments (1)
            Updated: 07 Mar 2018 04:47 AM
            Helpful?  
            Help us to make this article better
            0 0