Updated on 2023-05-15 GMT+08:00

Changing the Password for User compdbuser of the DBService Database

Scenario

It is recommended that the administrator periodically change the password of the OMS database administrator to improve the system O&M security.

Procedure

  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. Run the following command to 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';"

    • 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