Logging into Command Center produces the error "User xxxx is not allowed to login Command Center"

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

Attempting to connect to command center returns the error message "User xxxx is not allowed to login Command Center,".

For example:

Environment

Cause

This issue is caused by a user being defined to be authenticated as "Trust" and not using md5 or Password.

Resolution

1. Open "pg_hba.conf"

2. Navigate to the appropriate tag that is used to authenticate the user.

For example, in the above case, the connection to command center is edited for the "gpmon" user using the method below:

host gpperfmon gpmon ::1/128 trust

Change the authentication type to md5 or password. Reload the configuration using "gpstop -u" and try to connect again to command center using the "gpmon" user.