概述
关于三节点mssql-cluster证书失败
1.
select * from master.sys.certificates
DROP CERTIFICATE 证书名称
2.
select * from master.sys.database_mirroring_endpoints
DROP ENDPOINT 镜像端点名称
3
--已经创建可主key以不用再次创建
--CREATE MASTER KEY ENCRYPTION BY PASSWORD = '****';
4
--这次记得设置过期时间,没有默认一年
CREATE CERTIFICATE dbm_certificate WITH SUBJECT = 'dbm',EXPIRY_DATE
= '05/28/2099';
--备份证书文件前,手动删除这两个文件
BACKUP CERTIFICATE dbm_certificate
TO FILE =
'/var/opt/mssql/data/dbm_certificate.cer'
WITH PRIVATE KEY (
FILE = '/var/opt/mssql/data/dbm_certificate.pvk',
ENCRYPTION BY PASSWORD = '****'
);
CREATE ENDPOINT [Hadr_endpoint]
STATE=STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP =
(0.0.0.0))
FOR DATA_MIRRORING (
ROLE = ALL,
AUTHENTICATION = CERTIFICATE
[dbm_certificate],
ENCRYPTION = REQUIRED ALGORITHM AES)
GO
5.
--拷贝两个文件到 其他伙伴服务器相应的目录
6
--已经创建可主key以不用再次创建
--CREATE MASTER KEY ENCRYPTION BY PASSWORD = '****';
7
CREATE CERTIFICATE dbm_certificate
FROM FILE =
'/var/opt/mssql/data/dbm_certificate.cer'
WITH PRIVATE
KEY (
FILE =
'/var/opt/mssql/data/dbm_certificate.pvk',
DECRYPTION
BY PASSWORD = '****'
);
CREATE ENDPOINT [Hadr_endpoint]
STATE=STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP =
(0.0.0.0))
FOR DATA_MIRRORING (
ROLE = ALL,
AUTHENTICATION = CERTIFICATE
[dbm_certificate],
ENCRYPTION = REQUIRED ALGORITHM AES)
GO
挨个重启服务器
最后
以上就是忐忑鞋垫为你收集整理的mysql许可证书过期_sqlserver2017证书过期问题的全部内容,希望文章能够帮你解决mysql许可证书过期_sqlserver2017证书过期问题所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复