Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

How to add a pem file in SSL Root Certificate

Hi, how to add or upload a pem file for my SSL root certificate in Database Query Component. I tried to refer on a link but it wont work, it says Could not open SSL root certificate. The pemfile is provided by our AWS

Thanks

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Ryan,

There are two steps to this:

  1. Download the AWS certificates onto your Matillion instance
  2. Reference the SSL parameters in the Database Query

For step 1, SSH into your instance and issue the following commands:

sudo -i
mkdir /etc/pki/aws
chmod 755 /etc/pki/aws
cd /etc/pki/aws
wget https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem
chmod 644 rds-combined-ca-bundle.pem

For step 2, configure the following Connection Options in your Database Query:

  • sslmode = verify-full
  • sslrootcert = /etc/pki/aws/rds-combined-ca-bundle.pem

Best regards,
Ian

Post Your Community Answer

To add an answer please login