Pivotal Knowledge Base

Follow

GPSEGINSTALL fails with mismatched keys

Environment 

Pivotal Greenplum (GPDB) 4.3.x

OS RHEL 6.x

Symptom

While running gpseginstall -f hostfile during a database upgrade, the command displays the following error.

Warning: the RSA host key for 'sdw5' differs from the key for the IP address '10.10.10.12'
Offending key for IP in /root/.ssh/known_hosts:50
Matching host key in /root/.ssh/known_hosts:53
Are you sure you want to continue connecting (yes/no)? no
20170610:14:04:46:051495 gpseginstall:mdw:root-[ERROR]:-command failed: 'scp /usr/local/greenplum-db-4.3.13.0.tar.gz sdw5:/usr/local': Host key verification failed.
lost connection
20170610:14:04:46:051495 gpseginstall:mdw:root-[CRITICAL]:-early exit from gpseginstall

Resolution

After confirming the IP address of sdw5 is matching the one reported in the warning message, checking the .ssh/known_hosts file showed a differing key values for the two. For example:

Master:

10.10.10.12 ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDfl4FRARJS5FSz6B+z8Ag1WbT+jqa4GrW9YjezsrNmQ5UvSclExhbMVDZLDYWvQCHXTLT9tD6fXGdOyouGAxPGTVNt56CqEd10qhQWFbFxBnZwZQG/nRSNyp+

sdw5 ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCwfmy5O4VHUQPbrAC3bpKCn7pPCDKvABZpBqYx/hcD1E57b6wUDJwjVDpSvcIUYkca4Nxhn0MQymismzOIctVlYNUuZpdxrrtgZhCpNC0QoOwKUDjLDf3YsU+jSMUV99+

Confirm the keys in the segment host's .ssh/known_host file:

10.10.10.12 ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCwfmy5O4VHUQPbrAC3bpKCn7pPCDKvABZpBqYx/hcD1E57b6wUDJwjVDpSvcIUYkca4Nxhn0MQymismzOIctVlYNUuZpdxrrtgZhCpNC0QoOwKUDjLDf3YsU+jSMUV99+

sdw5 ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCwfmy5O4VHUQPbrAC3bpKCn7pPCDKvABZpBqYx/hcD1E57b6wUDJwjVDpSvcIUYkca4Nxhn0MQymismzOIctVlYNUuZpdxrrtgZhCpNC0QoOwKUDjLDf3YsU+jSMUV99+

After correcting the master's known host key for IP Address 10.10.10.12 and re-exchanging the ssh keys, the message will disappear and the DB can then be started. 

Comments

Powered by Zendesk