Unable to log in as Partition Administrator (pa) or System Administrator (sa)

From DocWiki

Jump to: navigation, search


Contents

Scenario Setup

Log all administrators out

Database Server

  1. Set PA and SA passwords to some random encrypted text

Problem Statement

Unable to log in to the default partition as pa. The login will fail:

LoginFailed.png


The same is true for the system partition. Remember that the sa user is a system user and can only log in to partitionId=0. The login will fail the same as for pa.

Administrator user eG Database
PA eGActiveDB
SA eGMasterDB

No more administration?

SA and PA are just standalone users defined in eGMasterDB and eGActiveDB, respectively.

The passwords are encrypted once set. If a customer forgets their password, it can be blanked out and reset from within the UI on version 4.4.1 or less.

Starting with Version 9, blank passwords are not allowed so you have to copy the password and case insensitive password from another user that you do know the password for.

Reset SA password:

Run the following against the eGMasterDB:

select * from egpl_user

SaPassQuery.png

  For version 4.4.1 or less, verify that the SA user's ID is 1. Then run the following query, also against the eGMasterDB:

UPDATE egpl_user WITH (ROWLOCK) SET password = '', case_insensitive_password = '' WHERE user_id = 1;

For version 9, copy the password and case_insensitive_password from another user and run the following against the eGMasterDB:

UPDATE egpl_user WITH (ROWLOCK) SET password = 'KEY FROM OTHER USER', case_insensitive_password = 'KEY FROM OTHER USER' WHERE user_id = 1;

Reset PA password:

Run the following against the eGActiveDB:

select * from egpl_user

Pa.png

  Verify that the PA user's ID is 1. Then run the following query, also against the eGActiveDB:

UPDATE egpl_user WITH (ROWLOCK) SET password = '', case_insensitive_password = '' WHERE user_id = 1;

For version 9, copy the password and case_insensitive_password from another user and run the following against the eGActiveDB:

UPDATE egpl_user WITH (ROWLOCK) SET password = 'KEY FROM OTHER USER', case_insensitive_password = 'KEY FROM OTHER USER' WHERE user_id = 1;

Reset Passwords from UI

Log in as SA and PA with blank passwords or for version 9, the password you set it to. Navigate to the Administration console > Users and change the password.

SaPass.png

Resolution

Resetting forgotten PA and SA user (and other standalone user) passwords is simple with a few quick SQL queries and updates.

Rating: 0.0/5 (0 votes cast)

Personal tools