cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
996
Views
0
Helpful
2
Replies
Highlighted
Beginner

CMS Database Cluster Certificate Renewals

It doesn't look like this has been answered so I'm going to post too in hopes someone knows..  Our dbcluster client certs are up for renewal. I've gone through the process to get newer certs (used the same private key etc) but am wondering what the steps are to use the new cert files. Do I need to break the cluster? Can I just disable the cluster service, add the new cert and re-enable on each server? If so, do I start with the master? There is absolutely no documentation that I can find on this site (or out in the ether) so it would be helpful for someone from Cisco to document this

thanks in advance

Steve 

Everyone's tags (4)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Beginner

Re: CMS Database Cluster Certificate Renewals

just i did it today ,  i will share my experience about renewing the database certificates , hope u pick some points:

 

I used the same old CSR  for both server and client certificate, it is a internal CA ,    the  new and updated  certificate file example:  CSR for server ,  CER for  client ,,  PEM file for  bundle ,, uploaded to CMS thru winscp ..on the CLI ,  i had to remove the cluster , "database cluster remove "  on the master database first ,,

then run command :  database cluster certs   s11.key  s11.CRT   C12.key  C12.CER   B13.pem  ,,

then  another command : database cluster initialize   only in  master database cms cli ...

then on client side ,,,u will load the certificate , then remove the cluster  and  then  JOIN  the cluster ,,,

remember ,,the  word  "postgres"  should be client certificate : CN  and optional SAN  field ..

 

before doing this backup u r cluster .... and  check the deployment guide as well ...

 

hope this helps ...

 

View solution in original post

2 REPLIES 2
Highlighted
Beginner

Re: CMS Database Cluster Certificate Renewals

just i did it today ,  i will share my experience about renewing the database certificates , hope u pick some points:

 

I used the same old CSR  for both server and client certificate, it is a internal CA ,    the  new and updated  certificate file example:  CSR for server ,  CER for  client ,,  PEM file for  bundle ,, uploaded to CMS thru winscp ..on the CLI ,  i had to remove the cluster , "database cluster remove "  on the master database first ,,

then run command :  database cluster certs   s11.key  s11.CRT   C12.key  C12.CER   B13.pem  ,,

then  another command : database cluster initialize   only in  master database cms cli ...

then on client side ,,,u will load the certificate , then remove the cluster  and  then  JOIN  the cluster ,,,

remember ,,the  word  "postgres"  should be client certificate : CN  and optional SAN  field ..

 

before doing this backup u r cluster .... and  check the deployment guide as well ...

 

hope this helps ...

 

View solution in original post

Highlighted
Beginner

Re: CMS Database Cluster Certificate Renewals

thanks for the response. I did finally go through the steps as you did (since there didn't seem to be any other way). the only thing I did different was remove the cluster from the two slave dbs first so did the master last. The cert stuff itself was pretty straight forward as I had done that before but was hoping there was a way to just "recycle" the cluster service with a new cert or something like that without tearing the whole thing down. Anyway, it ended up not being as scary as I thought it would. thanks again

Steve

CreatePlease to create content
Content for Community-Ad
Future of Work Virtual Summit Day 5

Cisco COVID-19 Survey