backup fail:Cannot find the password file

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.

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":



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

Siddarth

Hello Zhoumo, can you give the absolute path for the password file location and then try?

passwordFile = /home/vertica/pwd

zhoumo

Thank for your answer。 

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

zhoumo

Thank for your answer。 

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

anthony_1

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

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

Also copy the Password file to the remote backup host if your using one.