DR backup or copycluster script fails

book

Article ID: 5396

calendar_today

Updated On:

Products

CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

We are trying to set up a Vertica backup using vbr.py.

We are trying to set up a Vertica copycluster using vbr.py.

We have validated that the dradmin user has passwordless ssh enabled and working.

 The backups fail with this message:

[[email protected] backup]$ /opt/vertica/bin/vbr.py --task backup --config-file /home/dradmin/backup/backup_snapshot.ini

 

Error: Errors connecting to remote hosts: <IP>.  Check SSH settings, and that the same Vertica version is installed on all nodes.

Backup FAILED.

 

Cause

Since Vertica (7.2.x), it is required that you set AllowTcpForwarding to yes in the /etc/ssh/sshd_config.

Environment

All supported releases

Resolution

  • In the file /etc/ssh/sshd_config
  • Locate the line

#AllowTcpForwarding yes

 Notice that by default it is commented out, that is because the default value is yes, if it has been edited of changed, change it back.

  • To further restrict to tcp forwarding to just one user you can add the following lines:

AllowTcpForwarding no

Match User dradmin

AllowTcpForwarding yes

 

Note, if you edit this file, recycle sshd

systemctl restart sshd

Additional Information

Vertica docset

https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/ConfiguringBackupHosts.htm