Spring boot connectivity to AWS RDS PostgreSQL using IAM | AWS Advanced JDBC Wrapper

Поделиться
HTML-код
  • Опубликовано: 22 окт 2024

Комментарии • 15

  • @vjp00777
    @vjp00777 Год назад +1

    Nice explanation.. thank you. It worked for me for IAM but i get an error for SSL. Unable to find valid certification path to requested target. Did u get this issue?

    • @visa2learn
      @visa2learn  Год назад

      Did you provide the certificate in the jdbc url? Also make sure the certificate actually exists for the driver to pick up

    • @tattushenoi
      @tattushenoi 6 месяцев назад

      Were you able to solve this? If yes can you pls say how?

  • @tattushenoi
    @tattushenoi 6 месяцев назад

    This is not working as of today. Error says certificate not found on path.
    What I tried. Downloaded the GitHub code as is, just changed the end point of db url in app properties. Built code, built docker, deployed on eks. Created role and policies correctly. Us east 2 region and us east 2 bundle pem certificate file.

  • @csamarnathreddy
    @csamarnathreddy 3 месяца назад +1

    Is SSL mandatory to connect to RDS through IAM role?

    • @visa2learn
      @visa2learn  3 месяца назад

      No but its highly recommended for security reasons

  • @preethibabu9085
    @preethibabu9085 Год назад +1

    Hi, Have you tried failover plugin in this wrapper?

    • @visa2learn
      @visa2learn  11 месяцев назад

      Yes and it works :)

    • @preethibabu9085
      @preethibabu9085 11 месяцев назад

      @@visa2learn it doesn't work for a global aurora cluster

    • @preethibabu9085
      @preethibabu9085 11 месяцев назад

      I posted the question in the GitHub discussions of aws jdbc wrapper.. they said this feature currently doesn't work for global aurora cluster..

    • @visa2learn
      @visa2learn  11 месяцев назад

      Thanks for the update. I had tried it with writer fail and one of the reader taking over and the application worked seamlessly. But as you said it might still be not supported for a global aurora cluster

  • @narasimhadevarapalli1741
    @narasimhadevarapalli1741 Год назад +1

    nice but I got ENDPOINT_PROVIDER field not configured issue.

    • @visa2learn
      @visa2learn  Год назад

      Never faced this error. Make sure you provide all the datasource related properties in your properties file

    • @narasimhadevarapalli1741
      @narasimhadevarapalli1741 Год назад

      @@visa2learn found AWS core dependency is missing..after adding it I didn't get endpoint provider issue. But now I'm getting PAM user authentication failed issue. Through IntelliJ I'm able to connect with IAM token though

    • @visa2learn
      @visa2learn  Год назад

      If it's working using IAM token using intellij, that means your user is setup correctly and connectivity is also fine. I would suggest you go through this troubleshooting link to see if you are missing any step for IAM role for service account. aws.amazon.com/premiumsupport/knowledge-center/eks-troubleshoot-oidc-and-irsa/