Expanding current Performance Management Database Repository Cluster to add new Data Repository Cluster members.
The configuration is failing when trying to set up Passwordless SSH.
SSH Key Generation or Distribution Failed
New install of vertica on multi-node cluster using sudo to run dr_install.sh fails with error:
>> Establishing DB Admin SSH connectivity...
Installing/Repairing SSH keys for svcadmin
Failed to import SSH key.
Failed on hosts: x.x.x.10, x.x.x.20, x.x.x.30, x.x.x.40, x.x.x.50
Error: SSH key generation or distribution failed.
Installation FAILED with errors.
Dx NetOps: All supported releases
The Vertica install utility is unable to validate the passwordless ssh configuration properly.
This is likely due to security settings on the host.
ONLY IF YOU ARE SURE PASSWORDLESS SSH COMMUNICATION AS THE DATABASE ADMINISTRATOR IS WORKING ACROSS ALL NODES TO INCLUDE THE NEW NODE(S)...
edit the dr_install.sh script
By adding the following parameter to the update_vertica command, you can skip the check:
--no-ssh-key-install
.........................
printTitle "Invoking install_vertica..."
/opt/vertica/sbin/install_vertica -s $DB_HOST_NAMES -u $DB_ADMIN_LINUX_USER -l $DB_ADMIN_LINUX_USER_HOME -d $DB_DATA_DIR -L ./resources/$VLICENSE -Y -r ./resources/$VERTICA_RPM_FILE $POINT_TO_POIN
T_SPREAD_OPTION $failure_threshold 2>&1 | tee -a $LOG_FILE
test ${PIPESTATUS[0]} -eq 0
check_retval_exit_on_fail "install_vertica script failed with exit code ${PIPESTATUS[0]}"
becomes
printTitle "Invoking install_vertica..."
/opt/vertica/sbin/install_vertica -s $DB_HOST_NAMES -u $DB_ADMIN_LINUX_USER -l $DB_ADMIN_LINUX_USER_HOME -d $DB_DATA_DIR -L ./resources/$VLICENSE -Y --no-ssh-key-install -r ./resources/$VERTICA_RPM_FILE $POINT_TO_POIN
T_SPREAD_OPTION $failure_threshold 2>&1 | tee -a $LOG_FILE
test ${PIPESTATUS[0]} -eq 0
check_retval_exit_on_fail "install_vertica script failed with exit code ${PIPESTATUS[0]}"
.