odbc.ini for MySQL/MariaDB on AWS w/ SSL

odbc.ini

# Ref: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html
#
# A certificate bundle that contains both the old and new root certificates can be 
# downloaded at https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem . 

[aws]
Description     = MySQL/MariaDB on AWS
Driver          = MySQL
Database        = DATABASE
#
# Use the AWS FQDN - CNAME's will NOT work
Server          = FQDN.rds.amazonaws.com
User            = user
Password        = password
Port            = 3306
charset         = utf8
#
# The All regions AWS root certificate did NOT work.
# Use the certificate bundle that contains both the old and new root certificates. brian
sslca           = /PATH/TO/rds-combined-ca-bundle.pem
# - END

# Test the connection with 'isql -v aws'