The ADD_TRUSTED_CERTIFICATE procedure adds a trusted root CA certificate for a cluster. Components such as OceanBase clusters and OceanBase Migration Service (OMS) that use digital certificates issued by using this root certificate can pass remote procedure call (RPC) authentication and connect to the target cluster.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
PROCEDURE ADD_TRUSTED_CERTIFICATE(
common_name VARCHAR(256),
description VARCHAR(256),
content LONGTEXT);
Parameters
| Parameter | Description |
|---|---|
| common_name | The unique identifier of the certificate. |
| description | The purpose and associated cluster of the certificate. |
| content | The details about the certificate. |
Examples
obclient>CALL DBMS_TRUSTED_CERTIFICATE_MANAGER.ADD_TRUSTED_CERTIFICATE
('MySQL_Server_5.7.2_Auto_Geanrateed_C_Certificate',
'cluster B CA',
'-----BEGIN CERTIFICATE-----
MIIDbTCCAlWgAwIBAgIJANYnM/dk7iDWMA0GCSqGSIb3DQEBCwUAMEwxCzAJBgNV
******
******
******
JXaALXmRyp5+2y6Z7pT1+6g=
-----END CERTIFICATE-----'
);
Query OK, 0 rows affected