How to change the Vertica database password

book

Article ID: 37684

calendar_today

Updated On:

Products

CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration CA Performance Management - Data Polling

Issue/Introduction

Introduction:

dradmin is the default user created during the installation of Vertica (Data Repository).

This user can run the Data Repository processes and the Administration Tools (adminTools) utility.
This user owns Data Repository catalog files, data files, and so on.

dradmin is also the OS level user created on the system. This solution is specifically for changing the Vertica database password.

For more information on dradmin at the OS level, please refer to TEC1418368 for details on the steps and impacts of changing the dradmin OS user in a Vertica DB installation. 


Some of our customers have strict  password security policies that must be adhered to.

If you are required to change the actual dradmin password for the Vertica database, that would require the 'alter user' call, as well as updating the dbconnection.cfg on the Data Aggregator system.

You should shut down the Data Aggregator prior to making this change. 

Question:

How do I change the Vertica database password

Can I change the database password using admintools?

 

Answer:

No, you cannot change the the database password with admintools.

This must be done using vsql, while logged in as dradmin on the Data Respository system:

In the example below, we will change the database passwd 'dbpass2' to the new passwd 'dbpass' :

1. [[email protected] ~]#  su - dradmin

2. [[email protected] ~]$  /opt/vertica/bin/vsql

Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type: \h or \? for help with vsql commands
 \g or terminate with semicolon to execute query
 \q to quit

dradmin=> alter user dradmin IDENTIFIED BY 'dbpass' REPLACE 'dbpass2';
ALTER USER
dradmin=> \q

3. Verify the change by connecting to the database using the adminTools utility:

/opt/vertica/bin/adminTools

Select 2. Connect to Database

4. Now get the encrypted value of the new password 
cd /opt/IMDataAggregator/scripts/common.tools.encryption/
./doEncryption.sh dradmin <New Password> 

4. Now login to the Data Aggregator and modify the dbpassword in /opt/IMDataAggregator/apache-karaf-2.4.3/etc/dbconnection.cfg with the returned encrypted password from above. 

dbUser=dauser
dbEncryptedPassword=QUVTOkMZrUfMytW85NBX+bj7T4w=
dbAdminUser=dradmin
dbEncryptedAdminPassword=QUVTOmwDpCHP5zlGhX7b2ce9I9M=   <<--- This one 
 

Save the file.

You will also need to check your Vertica backup .ini (Default:backup_restore_full_local.ini) file for the location of the passwordFile file (Default password.txt) location and change the password in the that file to the new dbamin password. 

 



Environment

Release: IMDAGG99000-2.5-Infrastructure Management-Data Aggregator
Component:

Resolution

Please Update This Required Field