Vertica Tips: How to Reset a Lost Password in Vertica


Vertica Tips: How to Reset a Lost Password in Vertica

by Josh Varner

Have you locked yourself out of your Vertica cluster, but still have SSH or console access to the servers themselves? If you’re using the default authentication method (not LDAP/Kerberos/GSS), you can temporarily use the “trust” Vertica client authentication method and reset the password. The steps to do so are detailed below. We’ll assume that you’re trying to reset the “dbadmin” user password to “test123” on a single-node test cluster, and that the database has not yet been started.

Note: this method is only recommended for non-production systems on private networks. Use at your own risk.

  1. Log onto the server as the dbadmin system user. If you’ve lost the dbadmin system password, log in as root and reset it using the “passwd” command. If you do not have access to root, you’ll need to use a method such as this one to regain access to the system root account.
  2. As dbadmin, run “admintools”
  3. Select “View Database Cluster State” from the main menu and ensure that the database is not started. If it is, the easiest thing to do is to simply reboot the server.
  4. After verifying the database is down, select “Configuration Menu” from the main menu in admin tools
  5. Select “Edit Authentication” and select the database
  6. Add the following line to enable trust authentication for local connections:
    ClientAuthentication = local all trust
  7. Save the file and quit (“:wq” + ENTER in VI)
  8. Return to the main menu and select “Start Database”
  9. Run “vsql -U dbadmin”. It should not prompt for a password.
  10. Execute the following query:
    ALTER USER dbadmin IDENTIFIED BY 'test123';
  11. Quit vsql (“q”)
  12. In admin tools, return to “Configuration Menu”
  13. Select “Edit Authentication” and select the database
  14. Remove the line that you added in step #6, then save & quit (“:wq” + ENTER in VI)
  15. Return to the main menu, then select “Stop Database”
  16. After the database has stopped, select “Start Database”

To read more about the trust client authentication method and implementing security in a Vertica cluster, check out the Implementing Security section of the Vertica 6.0 Administrator’s Guide, available for download from MyVertica.

More About the Author

Josh Varner

Database Engineer
Proper Care and Feeding of Vertica (Part One) (This is a multi-part series about the proper care & feeding of a Vertica cluster. There’s simply too much content for one post, ...
Big Changes in Vertica 6.1 SP2 (6.1.2) About a month ago, HP Vertica released its latest service pack, HP Vertica 6.1 Service Pack 2 (version 6.1.2). It may sound like a ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072


Love our blog? You should see our emails. Sign up for our newsletter!