Updated on 2024-11-29 GMT+08:00

Viewing the Default User

When MOTService runs the gs_preinstall command to prepare the installation user and environment, the user specified by the -U parameter is the default user and the system administrator. The following describes how to view the default user.

Procedure

  1. Log in to FusionInsight Manager, choose Cluster > Services > MOTService, click Instance, and view and record the service IP address of the MOTServer(Active) instance.
  2. Log in to any MOTService node queried in 1 as user omm.
  3. Run the following command to switch to the MOTService installation directory:

    cd $MOTSERVER_HOME

  4. Run the following command to configure environment variables:

    source .motservice_profile

  5. Run the following command to log in to MOTService and enter the password of the MOTService database user omm:

    gsql -d postgres -p 20105

    Contact the system administrator to obtain the password of user omm for the MOTService database.

  6. Run the following command to view the default user:

    SELECT rolname FROM pg_authid where oid=10;

    The following command output shows that the default user is omm.

    openGauss=# SELECT rolname FROM pg_authid where oid=10;
     rolname
    ---------
     omm
    (1 row)