Hello, everyone!
The post will share with you the method of opening Windows clients to access DBservice database.
Method of Opening Windows Client to Access DBService Database
1. Log on to the main DBServer node, vi /srv/BigData/dbdata_service/data/pg_hba.conf, and open the configuration file
2. Add a line of configuration parameters at the end of the file: host all 0.0.0/0 sha256 (if SSL certificate is configured, add: host all 0.0.0/0 sha256)
3. Switch to OMM user and execute source /opt/huawei/Bigdata/dbservice/.dbservice_profile to import environment variables required by DBService.
4. Execute gs_ctl-D $GAUSSDATA restart and restart GaussDB.
The method of opening windows client to access OMS database:
1. Log on to the main OMS node, vi/srv/BigData/dbdata_om/data/pg_hba.conf, and open the configuration file.
2. Add a line of configuration parameters at the end of the file: host all 0.0.0/0 sha256 (if SSL certificate is configured, add: host all 0.0.0/0 sha256)
3. Switch to OMM user, execute gs_ctl-D $GAUSSDATA restart, restart gaussdb
Encryption Component Clear Password
In the OMS node, switch to the OMM user to execute
Scenario 1 uses the default key:
/opt/huawei/Bigdata/OMSV100R001 C00x8664/tools/encrypt/encrypt.sh--strSrc<plaintext password>--encType AES256
Scenario 2 uses the random key of the installation environment
/opt/huawei/Bigdata/OMSV100R001 C00x8664/tools/encrypt/encrypt.sh -- strSrc < plaintext password > -- encType AES256 -- keyFile ${AGENT_KEY_PATH}
That's all, thanks!
