Add ssl certificate config parameters for AWS RDS MySQL connection for metricbeat

Hi

I am trying to configure the AWS RDS metric using metricbeat mysql module.

I have enabled the require_secure_transport ON for aws rds parametergroup

Below is the mysql.yml (/etc/metricbeat/modules.d/mysql.yml)

  • module: mysql
    metricsets:
    • status
      period: 10s
      hosts: ["tcp(my_rds_endpoint:3306)/"]
      username: my_username
      password: my_password

ERROR: {"log.level":"error","@timestamp":"2023-12-28T10:58:23.514Z",
"log.origin":{"file.name":"module/wrapper.go","file.line":256},"message":"Error fetching data for metricset mysql.status:
Error 3159: Connections using insecure transport are prohibited while --require_secure_transport=ON.","service.name":"metricbeat","ecs.version":"1.6.0"}

I tried adding below parameters but still same issue.

  • module: mysql
    metricsets:
    • status
      period: 10s
      hosts: ["tcp(my_rds_endpoint:3306)/"]
      username: my_username
      password: my_password
      ssl.enabled: true
      ssl.verification_mode: full
      ssl.certificate_authorities: ["/opt/ssl/global-bundle.pem"]
      logging.level: debug

Note: When i turned of require_secure_transport OFF metricbeat mysql module is working fine
only issue with ssl,

Can anyone please help on this.

Thanks.

Follow up : How to add ssl certificate config parameters for AWS RDS MySQL connection for metricbeat

lates update: used both global and region specific certificates, we are still getting the same issue. our aws rds aurora certificate authority is rds-ca-rsa4096-g1.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.