Vertica backup error- Error: Unable to connect to backup host via password-less SSH: 127.0.0.1

Hi Hari

Can you kindly let us know the database version on which you are running this backup? 

Also provide us the backup (vbr.py) log to look into it.

Thanks

Rahul

Hi Rahul,

We are using Vertica-7.2.3 database. Where is the backup log saved?

Hi Rahul,

I have attached the latest log file herewith.

Could this be a bug in the vbr.py script because by default it takes only 22 port for rsync and ssh. I have given the parameter port_ssh_backup = port_num in the config files for the database but it doen not take this port number at all.

I have exactly the same problem. I am using Vertica Analytic Database v8.1.0-2. I defined in backup.ini file following option:

[Transmission]
port_ssh_backup = 222

Do you know how to solve the issue? I was able to change that in vbr.py file but I don't want to do it anymore. I would like to use options.

When running sshd on a non-standard port, I'd recommend creating entries in your admin user's ssh client config. For instance, in ~/.ssh/config, add
Host 127.0.0.1
Port 222

I have the same problem :'(
Error: Unable to connect to backup host via password-less SSH: 127.0.0.1.
Init FAILED.

[user_testing@localhost ~]$ /opt/vertica/bin/vbr --setupconfig
Warning: This setup tool is deprecated, and will be removed in a future version. Please use config file samples we provide in /opt/vertica/share/vbr/example_configs instead of using this tool.
Snapshot name (backup_snapshot): fullbak
Number of restore points (1): 1
Specify objects (no default): 
Object restore mode (coexist, createOrReplace or create) (createOrReplace): createOrReplace
Vertica user name (user_testing): 
Save password to avoid runtime prompt? (n) [y/n]: 
Node v_db_testing_0_node0001
Backup host name (no default): 127.0.0.1
Backup directory (no default): /home/user_testing/backup
Change advanced settings? (n) [y/n]: n
Config file name (fullbak.ini): /opt/vertica/config/vbr.ini
Saved vbr config to /opt/vertica/config/vbr.ini.

I'm attaching vbr.ini file

cat /opt/vertica/config/vbr.ini
[Misc]
snapshotName = fullbak
restorePointLimit = 1
objectRestoreMode = createOrReplace

[Database]
dbName = db_testing_0
dbUser = user_testing
dbPromptForPassword = True

[Transmission]
port_ssh_backup = 5055
[Mapping]
v_db_testing_0_node0001 = 127.0.0.1:/home/user_testing/backup

Plz provide solution

this is my hosts file /etc/hosts
[user_testing@localhost ~]$ cat /etc/hosts
127.0.0.0 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

I'm using Vertica Analytic Database v8.1.1-0 version on a single node.what I have to do?

Did you give the suggestion above a try: setting up a host/port config in ~/.ssh/config?

Also, for node-local backups I'd suggestion using the empty host notation to specify the backup location, for example, v_db_testing_0_node0001 = []:/home/user_testing/backup

hello @jheffner this is my admintools.conf

[user_testing@localhost ~]$ cat /opt/vertica/config/admintools.conf
[Configuration]
last_port = 5433
tmp_dir = /tmp
default_base = /home/dbadmin
format = 3
install_opts = --failure-threshold FAIL --dba-user user_testing --hosts '103.18. ** . ** ' --rpm 'vertica-8.1.1-0.x86_64.RHEL6.rpm'
spreadlog = False
atdebug = False
controlsubnet = default
ipv6 = False
controlmode = broadcast
unreachable_host_caching = True
admintools_config_version = 103

[Cluster]
hosts = 103.18. ** . **

[Nodes]
node0001 = 103.18. ** . ** /home/user_testing,/home/user_testing
v_db_testing_0_node0001 = 103.18. ** . ** ,/home/user_testing/catalog,/home/user_testing/data

[SSHConfig]
ssh_user =
ssh_ident =
ssh_options = -oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes

[Database:db_testing_0]
restartpolicy = ksafe
port = 5433
path = /home/user_testing/catalog/db_testing_0
nodes = v_db_testing_0_node0001
is_eon_mode = False
depot_base_dir
depot_size
communal_storage_url
num_shards

So what I have to do at v_db_testing_0_node0001 = []:/home/user_testing/backup

hello @jheffner
yes I did, this is my .ssh/config
[user_testing@localhost ~]$ cat .ssh/config
Host 127.0.0.0
Port 5055
This is my admintools.config
[user_testing@localhost ~]$ cat /opt/vertica/config/admintools.conf
[Configuration]
last_port = 5433
tmp_dir = /tmp
default_base = /home/dbadmin
format = 3
install_opts = --failure-threshold FAIL --dba-user user_testing --hosts '103.18. ** . ** ' --rpm 'vertica-8.1.1-0.x86_64.RHEL6.rpm'
spreadlog = False
atdebug = False
controlsubnet = default
ipv6 = False
controlmode = broadcast
unreachable_host_caching = True
admintools_config_version = 103

[Cluster]
hosts = 103.18. ** . **

[Nodes]
node0001 = 103.18. ** . ** ,/home/user_testing,/home/user_testing
v_db_testing_0_node0001 = 103.18. ** . ** ,/home/user_testing/catalog,/home/user_testing/data

[SSHConfig]
ssh_user =
ssh_ident =
ssh_options = -oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -o StrictHostKeyChecking=no -o BatchMode=yes

[Database:db_testing_0]
restartpolicy = ksafe
port = 5433
path = /home/user_testing/catalog/db_testing_0
nodes = v_db_testing_0_node0001
is_eon_mode = False
depot_base_dir
depot_size
communal_storage_url
num_shards
Am i doing anything wrong ??

In your /etc/hosts file, why are you using the IP 127.0.0.0 for you local host as opposed to 127.0.0.1?

127.0.0.1 is a loopback address while 127.0.0.0 is a network address.

Anyway, shouldn't your .ssh/config file be this?

Host 127.0.0.1
Port 5055

You have this:

Host 127.0.0.0
Port 5055

You'll probably need to create an entry for your node's IP address because it's not running on localhost -- you've got it obscured as "103.18. ** . **".

This is current permission to vertica db, Is this ok or I need to change it ??
drwxrwxrwx 9 user_testing verticadba
Please provide a solution to backup my db,I'm stuck