the gencfg_jdbc role does not support pem file with multiple certificates

[cuddlyporcupine]

the jdbccfg template file will only create 1 entry in the certificates array and will stuff all the certificates in the provided pem file into this array entry.

the jdbccfg template should loop over the contents in the pem file and create an array entry for each certificate found in the pem file

[maulik-modi22]

To replicate the issue, use https://truststore.pki.rds.amazonaws.com/ca-central-1/ca-central-1-bundle.pem as an example

[maulik-modi22]

@andrercm , appreciate your inputs on this, it is required for AWS RDS SQL support.

can you please add Scott Wallace as the watcher?

[andrercm]

Alright, we'll assign this to be fixed in the upcoming ansible-devops releases

[andrercm]

@maulik-modi22 @cuddlyporcupine I have worked on a fix for this issue within the PR: #1097

[maulik-modi22]

thank you @andrercm for prioritising it, eager to get it merged and released