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
BAYTAkNOMRAwDgYDVQQIDAdCZWlKaW5nMQwwCgYDVQQKDANBbnQxCzAJBgNVBAsM
Ak9CMRAwDgYDVQQDDAdyb290IGNhMCAXDTIzMTEyMjA3NDUzMFoYDzMwMjMwMzI1
MDc0NTMwWjBMMQswCQYDVQQGEwJDTjEQMA4GA1UECAwHQmVpSmluZzEMMAoGA1UE
CgwDQW50MQswCQYDVQQLDAJPQjEQMA4GA1UEAwwHcm9vdCBjYTCCASIwDQYJKoZI
hvcNAQEBBQADggEPADCCAQoCggEBANWsMw/GZqv7SgZDKUFt7DhyIbfVzVapoE+/
MLkgD5Pncu+vb87k9jj6ddG6ekTq9ccih3m01j9EmXqoKEXbqn/TT9w4IGxR1STJ
aL87Xe7NK8kpYPjtFfGMuXvzHQtsTy+KMHDW8+BLmitud4EEW75o/mA93AmtxmNZ
bHBVkIn5Q2MoU/TyMG6PPSbdMIDH2AlF4QAcM8Jsqn7lqs1J1M/ock0sYOi2YcM8
ceKUtcn7Xks22dSkOWYfMRlBXupXo/WqnKWJHpkZ0JWQn7b8De+qGwUwVoXU+DGH
sadmc4ESFwPlzar+yCfRo0rRyQ4MhYTZb5A3HKgAOh3HpMjNeykCAwEAAaNQME4w
HQYDVR0OBBYEFPG/BWN8y9A8Ti/ogcvAErbFXPxVMB8GA1UdIwQYMBaAFPG/BWN8
y9A8Ti/ogcvAErbFXPxVMAwGA1UdEwQFMAMBAf8wDQYJKoZIhvcNAQELBQADggEB
AKEDH+ytxMjgKVM/kPczI/iQRUj4Ql8I3/alyrH24X46KRDRP9010i12GB+uvMkC
HDjik5TAdzjcFzUWQNoDlO4FIL+lXkxZhqU4Ixd5/4MphMNubbcvMsVuui2WiyLE
oI5KBoRJrJntQYPBTrmVSgjb6BaIFhOXD6O8Et48Iel6jFcy38d4ZtUxXxzavWGN
n9iRXQeSBBA3XPYxlRoeeuePKmiqMSH1xltns0OyMRTzuUGOIfjIzQ8DKXx1STBw
LznB/zI0o8/aCMqt/jthRfC/OKSZaWWHD3wwx9BE5vHzenQ0o+lUtjZGklSnIze7
JXaALXmRyp5+2y6Z7pT1+6g=
-----END CERTIFICATE-----'
);
Query OK, 0 rows affected