Skip to main content

backup fail:Cannot find the password file

  • November 27, 2014
  • 6 replies
  • 27 views

zhoumo
Yesterday, I wanted to backup the full database  under vertica-7.1.1community version.

I did what the guid said, using vbr.py --setupconfig  command step by step.image

Both of the db.ini,pwd file  was under the "/home/vertica" directory.

The content of the db.ini was as below:

**************************************************************************
[Misc]snapshotName = db
restorePointLimit = 1
passwordFile = pwd

[Database]
dbName = db_vertica_test
dbUser = vertica

[Transmission]

[Mapping]
v_db_vertica_test_node0001 = vertica01:/home/vertica/backup
v_db_vertica_test_node0002 = vertica02:/home/vertica/backup

**************************************************************************




The content of the pwd file was as below:

**************************************************************************
dbPassword = vertica
**************************************************************************


Then , run the command "/opt/vertica/bin/vbr.py --task backup --config-file db.ini":

image

It's my pleasure to get your help to know why this error occurred and the solution.

6 replies

Siddarth
Forum|alt.badge.img+1
  • Participating Frequently
  • November 27, 2014
Hello Zhoumo, can you give the absolute path for the password file location and then try?

passwordFile = /home/vertica/pwd

zhoumo
  • Author
  • New Participant
  • November 27, 2014
Thank for your answer。 

The problem was solved when I copied the pwd file to another node.

zhoumo
  • Author
  • New Participant
  • November 27, 2014
Thank for your answer。 

The problem was solved when I copied the pwd file to another node.

anthony_1
  • New Participant
  • December 22, 2014
hi zhoumo, did you have to put the pwd file on all of your nodes? i would have assumed that just putting it on the primary master node would have been enough. I'm curious to know how you solved this issue.

Bhawana
Forum|alt.badge.img
  • Participating Frequently
  • December 30, 2014
Hi Anthony,

Check the .ini file , if full path is not there please add

passwordFile = <full path>

e.g
passwordFile=/home/vertica/pwd_quantros

Also copy the pwd file to other nodes.

Regards

Bhawana


Sunil_Bopanna
  • New Participant
  • February 5, 2015
Also copy the Password file to the remote backup host if your using one.