The UPDATE_TRUSTED_CERTIFICATE procedure updates the trusted root CA certificate for a cluster.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
PROCEDURE UPDATE_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.UPDATE_TRUSTED_CERTIFICATE
('MySQL_Server_5.7.2_Auto_Geanrateed_C_Certificate',
'cluster B CA OMS',
'-----BEGIN CERTIFICATE-----
MIIDbTCCAlWgAwIBAgIJANYnM/dk7iDWMA0GCSqGSIb3DQEBCwUAMEwxCzAJBgNV
******
******
******
JXaALXmRyp5+2y6Z7pT1+6g=
-----END CERTIFICATE-----'
);
Query OK, 0 rows affected