How to change the Vertica database password
Article ID: 37684
Updated On:
Products
Issue/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.
How do I change the Vertica database password
Can I change the database password using admintools?
Cause
You cannot change the database password with admintools.
This must be done using vsql, while logged in as dradmin on the Data Respository system:
Resolution
In the example below, we will change the database passwd 'dbpass' to the new passwd 'dbpass2' :
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 'dbpass2' REPLACE 'dbpass';
ALTER USER
dradmin=> \q
>>>> where dbpass = your current password and dbpass2 is your intended new password
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>
5. 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 that file to the new dbamin password.
Feedback
