- Pivotal Greenplum Database (GPDB) 4.3.x
- Pivotal Greenplum Command Center (GPCC)
During the new installation of Greenplum Command Center (GPCC), an error was encountered:
[gpadmin@mdw gpseg-1]$ gpcmdr --setup An instance name is used by the Greenplum Command Center as a way to uniquely identify a Greenplum Database that has the monitoring components installed and configured. This name is also used to control specific instances of the Greenplum Command Center web UI. Instance names can contain letters, digits and underscores and are not case sensitive. Please enter a new instance name: > gpcc The web component of the Greenplum Command Center can connect to a monitor database on a remote Greenplum Database. Is the master host for the Greenplum Database remote? Yy|Nn (default=N): > n The display name is shown in the web interface and does not need to be a hostname. What would you like to use for the display name for this instance: > gpcc What port does the Greenplum Database use? (default=5432): > Creating instance schema in GPDB. Please wait ... Failed to setup Command Center instance gpcc: Exception encountered while fetching GPDB version info Connection error for query select version();: FATAL: no pg_hba.conf entry for host "::1", user "gpmon", database "gpperfmon", SSL off [gpadmin@mdw gpseg-1]$
Add the below line to the pg_hba.conf file:
host gpperfmon gpmon ::1/128 trust
Once the line is added, issue a gpstop -u for the changes to take effect immediately without DB restart.
Now retry the command center setup and it should now succeed.