The ADD_TRUSTED_CERTIFICATE procedure adds a CA root certificate so that components such as an OBServer cluster or OMS can securely authenticate and connect to the cluster through RPC using the digital certificate issued by the certificate.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
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, used to distinguish between different certificates. |
| description | The description of the certificate's purpose or the associated cluster information. |
| content | The detailed information of 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