AWS RDS SSL connection Error mysql2 in Redmine database yml

Question

I have hosted redmine on AWS it was working properly, Suddenly last two days its showing error We're sorry, but something went wrong. The issue has been logged for investigation. Please try again later.

I have checked apache2 server log, it shows Error ID: 53a00391 Error details saved to: /tmp/passenger-error-ISPn8Y.html Message from application: SSL connection error: error:00000001:lib(0):func(0):reason(1) (Mysql2::Error)

so i have updated AWS RDS Mysql SSL connection, RDS Mysql SSL connection working properly when i tried to connect through command

database.yml

production:
  <<: *default
  database: database
  u;sername: user
  password: ******
  host: *****.c8pm9vrrqq0w.us-west-2.rds.amazonaws.com
  port: 3306
  sslverify: true
  sslmode: 'REQUIRED'
  sslca: /path/to/**.pem

Still i am getting same SSL connection Error

Could any one please help me to resolve this error.

Thanks

Have you rotated your ssl certs as needed on 5th march 2020? — Marcin
– Marcin, Commented Mar 8, 2020 at 11:53
@Marcin yes i did, That is the reason i can able to connect through Command. i attached screenshot — thilakg
– thilakg, Commented Mar 8, 2020 at 13:30

Brian Winant · Accepted Answer · 2020-03-08 11:54:19Z

1

Have you rotated the CA certificate for your RDS instance? All RDS CA certificates expired on March 5

See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL-certificate-rotation.html

answered Mar 8, 2020 at 11:54

Brian Winant

3,03517 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marcin Over a year ago

lol. upvote from me, as I though exactly same at the same time.

Collectives™ on Stack Overflow

AWS RDS SSL connection Error mysql2 in Redmine database yml

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related