Pivotal Knowledge Base

Follow

GPCC Install fails with ' FATAL: no pg_hba.conf entry for host "::1", user "gpmon", database "gpperfmon", SSL off '

Environment

Product Version
Pivotal Greenplum (GPDB) 4.3.x
Pivotal Greenplum Command Center (GPCC)  
Others  

Symptom

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]$

Resolution

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.

Comments

Powered by Zendesk