How to update the Revenue Secure certificate in the eCOC linux Server

Created by Ray McDonnell, Modified on Thu, 27 Mar, 2025 at 4:21 PM by Ray McDonnell

Copy the new certificate to eCoC server, for example:
1. /tmp/catherine1.p12.bac
Backup the current certificate
1. cp /home/ecoc/app/appl/V1/Truststore/catherine1.p12 /home/ecoc/app/appl/V1/Truststore/catherine23.p12
Copy the latest certificate (from step 1) to the production location
1. cp /tmp/catherine1.p12.bac /home/ecoc/app/appl/V1/Truststore/catherine1.p12
Access mySQL database
1. mysql -u ecoc -p v1_coc (supply the ecoc user password)
List existing certificates by performing the query below
1. SELECT * FROM tbl_cert;
Update the password for certificate id 272
1. UPDATE tbl_cert SET certPass='new_password' WHERE certId=272;
Restart both applications
1. sudo service coc-camel restart
2. sudo service v1 restart