search

aws-samples / keycloak-on-aws

This is a solution for deploying Keycloak to AWS with high availability.
https://www.amazonaws.cn/solutions/keycloak-on-aws/
Apache License 2.0
185 stars 35 forks source link

Error Launching CloudFormation Stack for Keycloak on Aurora MySQL - Incompatible Version #421

Open bogdan-romaniv opened 12 months ago

bogdan-romaniv commented 12 months ago

Description When attempting to deploy Keycloak using the "Deploy Keycloak based on Aurora MySQL-Compatible from a new VPC" option in the CloudFormation stack, I encounter an error related to an incompatible version of Aurora MySQL.

Error Details The error message displayed is as follows:

Resource handler returned message: "Cannot find version 5.7.mysql_aurora.2.09.1 for aurora-mysql (Service: Rds, Status Code: 400, Request ID: 0670f6cd-4e6e-400f-bb14-5f3b9babaf9b)" (RequestToken: 2480a588-7a66-d6c3-5f35-40cee750a705, HandlerErrorCode: InvalidRequest)

Proposed Solution and Testing After encountering this issue, I updated the stack version to "5.7.mysql_aurora.2.12.0", and upon testing, I found that everything works correctly with this version. Therefore, I suggest updating the CloudFormation template to use this version.

Here are the versions available according to the AWS CLI command: aws rds describe-db-engine-versions --engine aurora-mysql --query "DBEngineVersions[].EngineVersion" [ "5.7.mysql_aurora.2.07.9", "5.7.mysql_aurora.2.07.10", "5.7.mysql_aurora.2.11.1", "5.7.mysql_aurora.2.11.2", "5.7.mysql_aurora.2.11.3", "5.7.mysql_aurora.2.11.3", "5.7.mysql_aurora.2.11.4", "5.7.mysql_aurora.2.12.0", "8.0.mysql_aurora.3.01.0", "8.0.mysql_aurora.3.01.1", "8.0.mysql_aurora.3.02.0", "8.0.mysql_aurora.3.02.1", "8.0.mysql_aurora.3.02.2", "8.0.mysql_aurora.3.02.3", "8.0.mysql_aurora.3.03.0", "8.0.mysql_aurora.3.03.1", "8.0.mysql_aurora.3.03.2", "8.0.mysql_aurora.3.04.0", "8.0.mysql_aurora.3.04.1", "8.0.mysql_aurora.3.05.0" ]

Additional Information Reviewing the revision file reveals the following:

Release 2.1.6 Upgrade Keycloak to version 22.0.4 Upgrade aws-cdk to version 2.100.0 Upgrade cdk-keycloak to version 2.9.0

However, the deployed version of Keycloak seems to be "jboss/keycloak:16.1.1", not the official keycloak image and also not the version 22.0.4 of keycloak

Request I would appreciate guidance on resolving this version compatibility issue or an update to the CloudFormation template to support the latest compatible versions of Aurora MySQL and Keycloak.

wchaws commented 11 months ago

@bogdan-romaniv Hi, can you test out the following template URLs? I think the problem should have been resolved in the v2.2.0 release, which was posted a month ago, but I didn't update the official website's latest template URL to v2.2.0 at that time. Now, It's updated. Please try it again. 

https://aws-gcr-solutions.s3.amazonaws.com/keycloakonaws/v2.2.0/keycloak-aurora-serverless-from-existing-vpc.template
https://aws-gcr-solutions.s3.amazonaws.com/keycloakonaws/v2.2.0/keycloak-aurora-serverless-from-new-vpc.template
https://aws-gcr-solutions.s3.amazonaws.com/keycloakonaws/v2.2.0/keycloak-from-existing-vpc.template
https://aws-gcr-solutions.s3.amazonaws.com/keycloakonaws/v2.2.0/keycloak-from-new-vpc.template