DR backup script fails

book

Article ID: 5396

calendar_today

Updated On:

Products

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

Issue/Introduction

We are trying to set up a Vertica backup 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 yes

Environment

CAPM 3.x

NetOps 20.x

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

Additional Information

Vertica docset

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