Changing the Password for User compdbuser of the DBService Database

You need to regularly change the password of the OMS database to enhance system security and maintenance.

This topic is available for MRS 3.x and later versions only.

1. Log in to FusionInsight Manager, choose Cluster > Services > DBService, click Instance, and view the IP address of the active DBService node.
2. Log in to the active DBService node as user root.
   

   The password of user compuserdb cannot be changed on the standby DBService node. Change the password on the active management node only.

3. Switch to the $DBSERVER_HOME directory and configure environment variables.

   su - omm

   cd $DBSERVER_HOME

   source .dbservice_profile

4. Change the password of user compdbuser as user omm of the DBService database.

   gsql -U omm -W ommPassword of user omm of the DBService database -d postgres -p 20051 -c "alter user compdbuser identified by 'New password' valid until 'Expiration time';"

   

   • For the initial password of user omm in the DBService database, see MRS Cluster User Accounts.
   • The new password must meet the following complexity requirements:
     • Contains 16 to 32 characters.
     • Contains at least three types of the following: uppercase letters, lowercase letters, numbers, and special characters (~`!@#$%^&*()-+_=\|[{}];:",<.>/?).
     • Cannot be the same as the username or the username spelled backwards.
     • Cannot be the same as the last 20 historical passwords.
   • The expiration time format is xxxx-xx-xx, for example, 2020-10-31.

   If the following information is displayed, the modification is successful:

   ALTER ROLE