Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

None ROOT password-Less SSH


one of our show-stopper in production is to have password-less SSH for ROOT between vertica servers.

We found a by-pass and to use DBADMIN for install_vertica using additional two parameters:



using dbadmin user rather than root.

This phase actually worked !!!


However, the second phase executed by dbadmin username : supposed to create the DB instance ,  using admintools CLI

It keep prompting : “Enter password for [email protected] (3 attempts left):”

Pressing enter, and the program will continue and the DB will be created.


Here the actual command that I’m using:

/opt/vertica/bin/admintools -t create_db -s apps-vertica-node-1,apps-vertica-node-2,apps-vertica-node-3 -d  verticaDB -l /opt/vertica/config/licensing/Vertica_IPP.dat -P always


Even if I am adding –p ‘<dba-password>’ , it keep prompting the above request.


BTW, SSH from machine 3 to 1,2 as dbadmin worked fine without password.


Any ideas how to overcome/by-pass this prompt issue?

Thank You.



  • Hello, Gil_Peretz,


    Watch out! Some of those options you are using are undocumented and are unsafe to use without the guidance of Technical Support.


    If you can reproduce the problem without using unsupported options, perhaps we can help you here in the Vertica Forum.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.