Client Access Authentication

Configuring Client Access Authentication

Background

If a host needs to connect to a database remotely, you need to add information about the host in configuration file of the database system and perform client access authentication. The configuration file (pg_hba.conf by default) is stored in the data directory of the database. HBA is short for host-based authentication.

• The system supports the following three authentication methods, which all require the pg_hba.conf file.

  • Host-based authentication: A server checks the configuration file based on the IP address, username, and target database of the client to determine whether the user can be authenticated.
  • Password authentication: A password can be an encrypted password for remote connection or a non-encrypted password for local connection.
  • SSL encryption: The OpenSSL is used to provide a secure connection between the server and the client.

• In the pg_hba.conf file, each record occupies one row and specifies an authentication rule. An empty row or a row started with a number sign (#) is neglected.

• Each authentication rule consists of multiple columns separated by spaces and forward slashes (/), or spaces and tab characters. If a field is enclosed with quotation marks ("), it can contain spaces. One record cannot span different rows.

Procedure

1. Log in as the OS user omm to the primary node of the database.

2. Configure the client authentication mode and enable the client to connect to the host as user jack. User omm cannot be used for remote connection.

   Assume you are to allow the client whose IP address is 10.10.0.30 to access the current host.

   gs_guc reload -N all -I all -h "host all jack 10.10.0.30/32 sha256"

   NOTE:

   • Before using user jack, connect to the database locally and run the following command in the database to create user jack:

     mogdb=# CREATE USER jack PASSWORD 'Test@123';

   • -N all indicates all hosts in MogDB.

   • -I all indicates all instances on the host.

   • -h specifies statements that need to be added in the pg_hba.conf file.

   • all indicates that a client can connect to any database.

   • jack indicates the user that accesses the database.

   • 10.10.0.30/32 indicates that only the client whose IP address is 10.10.0.30 can connect to the host. The specified IP address must be different from those used in MogDB. 32 indicates that there are 32 bits whose value is 1 in the subnet mask. That is, the subnet mask is 255.255.255.255.

   • sha256 indicates that the password of user jack is encrypted using the SHA-256 algorithm.

This command adds a rule to the pg_hba.conf file corresponds to the primary node of the database. The rule is used to authenticate clients that access primary node.

Each record in the pg_hba.conf file can be in one of the following four formats. For parameter description of the four formats, see Configuration File Reference.

local     DATABASE USER METHOD [OPTIONS]
host      DATABASE USER ADDRESS METHOD [OPTIONS]
hostssl   DATABASE USER ADDRESS METHOD [OPTIONS]
hostnossl DATABASE USER ADDRESS METHOD [OPTIONS]

During authentication, the system checks records in the pg_hba.conf file in sequence for connection requests, so the record sequence is vital.

NOTE: Configure records in the pg_hba.conf file from top to bottom based on communication and format requirements in the descending order of priorities. The IP addresses of the MogDB cluster and added hosts are of the highest priority and should be configured prior to those manually configured by users. If the IP addresses manually configured by users and those of added hosts are in the same network segment, delete the manually configured IP addresses before the scale-out and configure them after the scale-out.

The suggestions on configuring authentication rules are as follows:

• Records placed at the front have strict connection parameters but weak authentication methods.
• Records placed at the end have weak connection parameters but strict authentication methods.

NOTE:

• If a user wants to connect to a specified database, the user must be authenticated by the rules in the pg_hba.conf file and have the CONNECT permission for the database. If you want to restrict a user from connecting to certain databases, you can grant or revoke the user's CONNECT permission, which is easier than setting rules in the pg_hba.conf file.
• The trust authentication mode is insecure for a connection between the MogDB and a client outside the cluster. In this case, set the authentication mode to sha256.

Exception Handling

There are many reasons for a user authentication failure. You can view an error message returned from a server to a client to determine the exact cause. Table 1 lists common error messages and solutions to these errors.

Table 1 Error messages

Example

TYPE  DATABASE        USER            ADDRESS                 METHOD

#Allow only the user specified by the -U parameter (omm as default) during installation to establish a connection from the local server.
local   all             omm                                     trust
IPv4 local connections:
#User  jack  is allowed to connect to any database from the 10.10.0.50 host. The SHA-256 algorithm is used to encrypt the password.
host    all           jack             10.10.0.50/32            sha256
#Any user is allowed to connect to any database from a host on the 10.10.0.0/24 network segment. The SHA-256 algorithm is used to encrypt the password and SSL transmission is used.
hostssl    all             all             10.10.0.0/24            sha256
#Any user is allowed to connect to any database from a host on the 10.10.0.0/24 network segment. The Kerberos authentication is used. In the current version, Kerberos authentication cannot be used to connect to external clients.
host    all             all             10.10.0.0/24            gss         include_realm=1        krb_realm=HADOOP.COM

Configuration File Reference

Table 2 Parameter description

Table 3 Authentication modes

Establishing Secure TCP/IP Connections in SSL Mode

Background

MogDB supports the standard SSL (TLS 1.2). As a highly secure protocol, SSL authenticates bidirectional identification between the server and client using digital signatures and digital certificates to ensure secure data transmission.

Prerequisites

Obtain formal certificates and keys for servers and clients from the Certificate Authority (CA). Assume the private key and certificate for the server are server.key and server.crt, the private key and certificate for the client are client.key and client.crt, and the CA root certificate is cacert.pem.

Precautions

• When a user remotely accesses the primary node of the database, the SHA-256 authentication method is used.
• If internal servers are connected with each other, the trust authentication mode must be used. IP address whitelist authentication is supported.

Procedure

After a cluster is deployed, MogDB enables the SSL authentication mode by default. The server certificate, key, and root certificates have been configured. You need to set client parameters.

Set digital certificate parameters related to SSL authentication. For details, see Table 4.

• Configure client parameters.

  The default client certificate, key, root certificate, and key encrypted file have been obtained from the CA authentication center. Assume that the certificate, key, and root certificate are stored in the /home/omm directory.

  For bidirectional authentication, set the following parameters:

  export PGSSLCERT="/home/omm/client.crt"
  export PGSSLKEY="/home/omm/client.key"
  export PGSSLMODE="verify-ca"
  export PGSSLROOTCERT="/home/omm/cacert.pem"

  For unidirectional authentication, set the following parameters:

  export PGSSLMODE="verify-ca"
  export PGSSLROOTCERT="/home/omm/cacert.pem"

• Change the client key permission.

  The permission of the client root certificate, key, certificate, and encrypted key file should be 600. Otherwise, the client cannot connect to MogDB through SSL.

  chmod 600 client.key
  chmod 600 client.crt
  chmod 600 client.key.cipher
  chmod 600 client.key.rand
  chmod 600 cacert.pem

NOTICE: You are advised to use bidirectional authentication for security purposes. The environment variables configured for a client must contain the absolute file paths.

Table 4 Authentication modes

Reference

In the postgresql.conf file on the server, set the related parameters. For details, see Table 5.

Table 5 Server parameters

Configure environment variables related to SSL authentication on the client. For details, see Table 6.

NOTE: The path of environment variables is set to /home/omm as an example. Replace it with the actual path.

Table 6 Client parameters

The following tables describe the connection results based on the settings of the server parameters ssl and require_ssl and the client parameter sslmode.

• Server ssl = on

  sslmode (Client)	require_ssl (Client)	Result
  disable	on	The connection fails, because the server requires SSL but the client has disabled it.
  allow	on	The connection is encrypted.
  prefer	on	The connection is encrypted.
  require	on	The connection is encrypted.
  verify-ca	on	The connection is encrypted and the server certificate is verified.
  verify-full	on	The connection is encrypted and the server certificate and host name are verified.
  verify-full	off	The connection is encrypted and the server certificate and host name are verified.

• Server ssl = off

  sslmode (Client)	require_ssl (Client)	Result
  disable	on	The connection is not encrypted.
  allow	on	The connection is not encrypted.
  prefer	on	The connection is not encrypted.
  require	on	The connection fails, because the client requires SSL but the server has disabled it.
  verify-ca	on	The connection fails, because the client requires SSL but the server has disabled it.
  verify-full	on	The connection fails, because the client requires SSL but the server has disabled it.
  verify-full	off	The connection fails, because the client requires SSL but the server has disabled it.

A series of encryption and authentication algorithms with different strength are supported for SSL transmission. You can modify ssl_ciphers in postgresql.conf to specify the encryption algorithm used by the database server. Table 7 lists the encryption algorithms supported by the SSL.

Table 7 Encryption algorithms

NOTE:

• Currently, SSL transmission supports encryption algorithms with the encryption strength higher than strong.
• The default value of ssl_ciphers is ALL, indicating that all encryption algorithms listed in the table are supported. You are advised to retain the default value, unless there are other special requirements on the encryption algorithm.
• If multiple encryption algorithms are specified, use semicolons (;) to separate them. For example, set ssl_ciphers='DHE-RSA-AES256-GCM-SHA384;DHE-RSA-AES256-SHA256;DHE-RSA-AES256-CCM' in postgresql.conf.
• If a DSS-related algorithm is to be used (such as DHE-DSS-AES256-GCM-SHA384, DHE-DSS-AES256-SHA256, and DHE-DSS-AES256-SHA), a certificate file with the DSA algorithm signature must be loaded. For details about how to use OpenSSL to generate a certificate file with the DSA algorithm signature, see the official OpenSSL documents.
• SSL authentication increases the time spent for login (creating the SSL environment) and logout processes (clearing the SSL environment), and requires extra time for encrypting the data to be transferred. It affects performance especially in frequent login, logout, and short-time query scenarios.
• If the certificate will expire in seven days, an alarm is generated in logs during connection.

Establishing Secure TCP/IP Connections in SSH Tunnel Mode

Background

To ensure secure communication between the database server and its clients, secure SSH tunnels can be established between the database server and clients. SSH is a reliable security protocol dedicated to remote login session and other network services.

Regarding the SSH client, the SSH provides the following two security authentication levels:

• Password-based security authentication: Use an account and a password to log in to a remote host. All transmitted data is encrypted. However, the connected server may not be the target server. Another server may pretend to be the real server and perform the man-in-the-middle attack.
• Key-based security authentication: A user must create a pair of keys and put the public key on the target server. This mode prevents man-in-the-middle attacks while encrypting all transmitted data. However, the entire login process may last 10s.

Prerequisites

The SSH service and the database must run on the same server.

Procedure

OpenSSH is used as an example to describe how to configure SSH tunnels. The process of configuring key-based security authentication is not described here. OpenSSH provides multiple configurations to adapt to different networks. For more details, see documents related to OpenSSH.

Establish the SSH tunnel from a local host to the database server.

ssh -L 63333:localhost:8000 username@hostIP

NOTE:

• The first digit string (63333) of the -L parameter indicates the local port ID of the tunnel and can be randomly selected.
• The second digit string (8000) indicates the remote port ID of the tunnel, which is the port ID on the server.
• localhost is the IP address of the local host, username is the username on the database server to be connected, and hostIP is the IP address of the database server to be connected.

Checking the Number of Database Connections

Background

If the number of connections reaches its upper limit, new connections cannot be created. Therefore, if a user fails to connect a database, the administrator must check whether the number of connections has reached the upper limit. The following are details about database connections:

• The maximum number of global connections is specified by the max_connections parameter. Its default value is 5000.
• The number of a user's connections is specified by CONNECTION LIMIT connlimit in the CREATE ROLE statement and can be changed using CONNECTION LIMIT connlimit in the ALTER ROLE statement.
• The number of a database's connections is specified by the CONNECTION LIMIT connlimit parameter in the CREATE DATABASE statement.

Procedure

1. Log in as the OS user omm to the primary node of the database.

2. Run the following command to connect to the database:

   gsql -d mogdb -p 8000

   mogdb is the name of the database to be connected, and 8000 is the port number of the database primary node.

3. View the upper limit of the number of global connections.

   mogdb=# SHOW max_connections;
       max_connections
   -----------------
       800
   (1 row)

   800 is the maximum number of session connections.

4. View the number of connections that have been used.

   NOTICE:

   Except for database and usernames that are enclosed in double quotation marks (") during creation, uppercase letters are not allowed in the database and usernames in the commands in the following table.

   • View the maximum number of sessions connected to a specific user.

     Run the following commands to view the upper limit of the number of omm's session connections. -1 indicates that no upper limit is set for the number of omm's session connections.

     mogdb=# SELECT ROLNAME,ROLCONNLIMIT FROM PG_ROLES WHERE ROLNAME='omm';
      rolname | rolconnlimit
     ---------+--------------
      omm     |           -1
     (1 row)

   • View the number of session connections that have been used by a user.

     Run the following commands to view the number of session connections that have been used by omm. 1 indicates the number of session connections that have been used by omm.

     mogdb=# CREATE OR REPLACE VIEW DV_SESSIONS AS
     SELECT
     sa.sessionid AS SID,
     0::integer AS SERIAL#,
     sa.usesysid AS USER#,
     ad.rolname AS USERNAME
     FROM pg_stat_get_activity(NULL) AS sa
     LEFT JOIN pg_authid ad ON(sa.usesysid = ad.oid)
     WHERE sa.application_name <> 'JobScheduler';
     mogdb=# SELECT COUNT() FROM DV_SESSIONS WHERE USERNAME='omm';
      count
     -------
         1
     (1 row)

   • View the maximum number of sessions connected to a specific database

     Run the following commands to view the upper limit of the number of mogdb's session connections. -1 indicates that no upper limit is set for the number of mogdb's session connections.

     mogdb=# SELECT DATNAME,DATCONNLIMIT FROM PG_DATABASE WHERE DATNAME='mogdb';
      datname | datconnlimit
     ---------+--------------
      mogdb   |           -1
     (1 row)

   • View the number of session connections that have been used by a specific database.

     Run the following commands to view the number of session connections that have been used by mogdb. 1 indicates the number of session connections that have been used by mogdb.

     mogdb=# SELECT COUNT(*) FROM PG_STAT_ACTIVITY WHERE DATNAME='mogdb';
      count
     -------
         1
     (1 row)

   • View the number of session connections that have been used by all users.

     Run the following commands to view the number of session connections that have been used by all users:

     mogdb=# CREATE OR REPLACE VIEW DV_SESSIONS AS
     SELECT
     sa.sessionid AS SID,
     0::integer AS SERIAL#,
     sa.usesysid AS USER#,
     ad.rolname AS USERNAME
     FROM pg_stat_get_activity(NULL) AS sa
     LEFT JOIN pg_authid ad ON(sa.usesysid = ad.oid)
     WHERE sa.application_name <>'JobScheduler';
     mogdb=# SELECT COUNT(*) FROM DV_SESSIONS;
      count
     -------
         23
     (1 row)

Managing SSL Certificates

Security certificates and keys generated using OpenSSL are configured in MogDB by default. In addition, MogDB provides certificate replacement interfaces to allow users to replace their certificates.

Generating Certificates

Scenarios

In the test environment, users can use either of the following methods to test digital certificates. In a customer's operating environment, only a digital certificate obtained from a CA can be used.

Prerequisites

The OpenSSL component has been installed in the Linux environment.

Generating an Automatic Authentication Certificate

1. Establish a CA environment.

   #  Suppose that user omm exists, and the CA path is test.
   #  Log in to the Linux environment as user root and switch to user omm:
   mkdir test
   cd /etc/pki/tls
   #  Copy the configuration file openssl.cnf to test.
   cp openssl.cnf ~/test
   cd ~/test
   # Establish the CA environment under the test folder.
   # Create folder demoCA./demoCA/newcerts./demoCA/private.
   mkdir ./demoCA ./demoCA/newcerts ./demoCA/private
   chmod 700 ./demoCA/private
   # Create the serial file and write it to 01.
   echo '01'>./demoCA/serial
   #  Create the index.txt file.
   touch ./demoCA/index.txt
   #  Modify parameters in the openssl.cnf configuration file.
   dir  = ./demoCA
   default_md      = sha256
   # The CA environment has been established.

2. Generate a root private key.

   # Generate a CA private key.
   openssl genrsa -aes256 -out demoCA/private/cakey.pem 2048
   Generating RSA private key, 2048 bit long modulus
   .................+++
   ..................+++
   e is 65537 (0x10001)
   # Set the protection password of the root private key, for example, Test@123.
   Enter pass phrase for demoCA/private/cakey.pem:
   # Enter the private key password Test@123 again.
   Verifying - Enter pass phrase for demoCA/private/cakey.pem:

3. Generate a root certificate request file.

   # Generate a CA root certificate application file named careq.pem.
   openssl req -config openssl.cnf -new -key demoCA/private/cakey.pem -out demoCA/careq.pem
   Enter pass phrase for demoCA/private/cakey.pem:
   # Enter the root private key password Test@123.
   You are about to be asked to enter information that will be incorporated
   into your certificate request.
   What you are about to enter is what is called a Distinguished Name or a DN.
   There are quite a few fields but you can leave some blank
   For some fields there will be a default value,
   If you enter '.', the field will be left blank.
   -----
   
   # Note down the following names and use them when entering information in the generated server certificate and client certificate.
   Country Name (2 letter code) [AU]:CN
   State or Province Name (full name) [Some-State]:shanxi
   Locality Name (eg, city) []:xian
   Organization Name (eg, company) [Internet Widgits Pty Ltd]:Abc
   Organizational Unit Name (eg, section) []:hello
   # Common Name can be randomly set.
   Common Name (eg, YOUR name) []:world
   # The email address is optional.
   Email Address []:
   
   Please enter the following 'extra' attributes
   to be sent with your certificate request
   A challenge password []:
   An optional company name []:

4. Generate a self-signed root certificate.

   # When generating the root certificate, modify the openssl.cnf file and set basicConstraints to CA:TRUE.
   vi openssl.cnf
   #  Generate a CA self-signed root certificate.
   openssl ca -config openssl.cnf -out demoCA/cacert.pem -keyfile demoCA/private/cakey.pem -selfsign -infiles demoCA/careq.pem
   Using configuration from openssl.cnf
   Enter pass phrase for demoCA/private/cakey.pem:
   # Enter the root private key password Test@123.
   Check that the request matches the signature
   Signature ok
   Certificate Details:
           Serial Number: 1 (0x1)
           Validity
               Not Before: Feb 28 02:17:11 2017 GMT
               Not After : Feb 28 02:17:11 2018 GMT
           Subject:
               countryName               = CN
               stateOrProvinceName       = shanxi
               organizationName          = Abc
               organizationalUnitName    = hello
               commonName                = world
           X509v3 extensions:
               X509v3 Basic Constraints:
                   CA:FALSE
               Netscape Comment:
                   OpenSSL Generated Certificate
               X509v3 Subject Key Identifier:
                   F9:91:50:B2:42:8C:A8:D3:41:B0:E4:42:CB:C2:BE:8D:B7:8C:17:1F
               X509v3 Authority Key Identifier:
                   keyid:F9:91:50:B2:42:8C:A8:D3:41:B0:E4:42:CB:C2:BE:8D:B7:8C:17:1F
   
   Certificate is to be certified until Feb 28 02:17:11 2018 GMT (365 days)
   Sign the certificate? [y/n]:y
   
   1 out of 1 certificate requests certified, commit? [y/n]y
   Write out database with 1 new entries
   Data Base Updated
   # A CA root certificate named demoCA/cacert.pem has been issued.

5. Generate a private key for the server certificate.

   # Generate a private key file named server.key.
   openssl genrsa -aes256 -out server.key 2048
   Generating a 2048 bit RSA private key
   .......++++++
   ..++++++
   e is 65537 (0x10001)
   Enter pass phrase for server.key:
   # Password of the server private key, for example, Test@123.
   Verifying - Enter pass phrase for server.key:
   # Confirm the protection password for the server private key Test@123 again.

6. Generate a server certificate request file.

   # Generate a server certificate request file server.req.
   openssl req -config openssl.cnf -new -key server.key -out server.req
   Enter pass phrase for server.key:
   You are about to be asked to enter information that will be incorporated
   into your certificate request.
   What you are about to enter is what is called a Distinguished Name or a DN.
   There are quite a few fields but you can leave some blank
   For some fields there will be a default value,
   If you enter '.', the field will be left blank.
   -----
   
   # Set the following information and make sure that it is same as that when CA is created.
   Country Name (2 letter code) [AU]:CN
   State or Province Name (full name) [Some-State]:shanxi
   Locality Name (eg, city) []:xian
   Organization Name (eg, company) [Internet Widgits Pty Ltd]:Abc
   Organizational Unit Name (eg, section) []:hello
   # Common Name can be randomly set.
   Common Name (eg, YOUR name) []:world
   Email Address []:
   # The following information is optional.
   Please enter the following 'extra' attributes
   to be sent with your certificate request
   A challenge password []:
   An optional company name []:

7. Generate a server certificate.

   # When generating the server certificate or client certificate, modify the openssl.cnf file and set basicConstraints to CA:FALSE.
   vi openssl.cnf
   # Change the demoCA/index.txt.attr attribute to no.
   vi demoCA/index.txt.attr
   
   # Issue the generated server certificate request file. After it is issued, an official server certificate server.crt is generated.
   openssl ca  -config openssl.cnf -in server.req -out server.crt -days 3650 -md sha256
   Using configuration from /etc/ssl/openssl.cnf
   Enter pass phrase for ./demoCA/private/cakey.pem:
   Check that the request matches the signature
   Signature ok
   Certificate Details:
           Serial Number: 2 (0x2)
           Validity
               Not Before: Feb 27 10:11:12 2017 GMT
               Not After : Feb 25 10:11:12 2027 GMT
           Subject:
               countryName               = CN
               stateOrProvinceName       = shanxi
               organizationName          = Abc
               organizationalUnitName    = hello
               commonName                = world
           X509v3 extensions:
               X509v3 Basic Constraints:
                   CA:FALSE
               Netscape Comment:
                   OpenSSL Generated Certificate
               X509v3 Subject Key Identifier:
                   EB:D9:EE:C0:D2:14:48:AD:EB:BB:AD:B6:29:2C:6C:72:96:5C:38:35
               X509v3 Authority Key Identifier:
                   keyid:84:F6:A1:65:16:1F:28:8A:B7:0D:CB:7E:19:76:2A:8B:F5:2B:5C:6A
   
   Certificate is to be certified until Feb 25 10:11:12 2027 GMT (3650 days)
   # Enter y to sign and issue the certificate.
   Sign the certificate? [y/n]:y
   
   # Enter y. The certificate singing and issuing is complete.
   1 out of 1 certificate requests certified, commit? [y/n]y
   Write out database with 1 new entries
   Data Base Updated

   Disable password protection for the private key.

   # Disable the password protection for the server private key.
   openssl rsa -in server.key -out server.key
   # If the password protection for the server private key is not disabled, you need to use the gs_guc tool to encrypt the password.
   gs_guc encrypt -M server -D ./
   # Enter the passowrd of the the server private key as prompted. After the password is encrypted, two private key password protection files server.key.cipher and server.key.rand are generated.

8. Generate the client certificate and private key.

   Methods and requirements for generating client certificates and private keys are the same as that for server certificates and private keys.

   # Generate a client private key.
   openssl genrsa -aes256 -out client.key 2048
   # Generate a certificate request file for a client.
   openssl req -config openssl.cnf -new -key client.key -out client.req
   # After the generated certificate request file for client is signed and issued, a formal client certificate client.crt is generated.
   openssl ca -config openssl.cnf -in client.req -out client.crt -days 3650 -md sha256

   Disable password protection for the private key:

   # Disable the protection for a client private key password.
   openssl rsa -in client.key -out client.key
   # If password protection for a client private key is not removed, you need to use the gs_guc tool to encrypt the password.
   gs_guc encrypt -M client -D ./
   Enter the passowrd of the the client private key as prompted. After the password is encrypted, two private key password protection files client.key.cipher and client.key.rand are generated.

   Convert the client key to the DER format.

   openssl pkcs8 -topk8 -outform DER -in client.key -out client.key.pk8 -nocrypt

9. Generate a CRL.

   If the CRL is required, you can generate it by following the following procedure:

   # Create a crlnumber file.
   echo '00'>./demoCA/crlnumber
   # Revoke a server certificate.
   openssl ca -config openssl.cnf -revoke server.crt
   # Generate the CRL sslcrl-file.crl.
   openssl ca -config openssl.cnf -gencrl -out sslcrl-file.crl

Replacing Certificates

Scenarios

Default security certificates and private keys required for SSL connection are configured in MogDB. You can change them as needed.

Prerequisites

The formal certificates and keys for the server and client have been obtained from the CA.

Precautions

Currently, MogDB supports only the X509v3 certificate in PEM format.

Procedure

1. Prepare for a certificate and a key.

   Conventions for configuration file names on the server:

   • Certificate name: server.crt
   • Key name: server.key
   • Key password and encrypted file: server.key.cipher and server.key.rand

   Conventions for configuration file names on the client:

   • Certificate name: client.crt
   • Key name: client.key
   • Key password and encrypted file: client.key.cipher and client.key.rand
   • Certificate name: cacert.pem
   • CRL file name: sslcrl-file.crl

2. Create a compressed package.

   Package name: db-cert-replacement.zip

   Package format: ZIP

   Package file list: server.crt, server.key, server.key.cipher, server.key.rand, client.crt, client.key, client.key.cipher, client.key.rand, cacert.pem If you need to configure the CRL, the list must contain sslcrl-file.crl.

3. Invoke the certificate replacement interface to replace a certificate.

   a. Upload the prepared package db-cert-replacement.zip to any path of an MogDB user.

   For example: /home/xxxx/db-cert-replacement.zip

   b. Run the following command to perform the replacement:

   gs_om -t cert --cert-file=/home/xxxx/db-cert-replacement.zip

4. Restart the MogDB.

   gs_om -t stop
   gs_om -t start

   NOTE: Certificates can be rolled back to the version before the replacement. You can run the gs_om -t cert -rollback command to remotely invoke the interface or gs_om -t cert -rollback -L to locally invoke the interface. The certificate will be rolled back to the latest version that was successfully replaced.