# Cannot find version 5.7.41 for mysql - OpenEMR Cloud Standard Edition - CloudFormation Issue **URL:** \ **Category:** Support\ **Tags:** aws, cloud\ **Created:** [April 5, 2024, 12:54pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362 "2024-04-05T12:54:03Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Goddard](https://community.open-emr.org/letter_avatar_proxy/v4/letter/g/43a26b/32.png) [@Goddard](https://community.open-emr.org/u/Goddard)\ **Post date:** [April 5, 2024, 12:54pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/1 "2024-04-05T12:54:03Z")
**OpenEMR Version** I’m (attempting) using OpenEMR version 7.0.2 (latest version at time of writing) **Situation** I am attempting to deploy OpenEMR Cloud Standard Edition in my AWS account from the marketplace listing: [Amazon Web Services Sign-In](https://aws.amazon.com/marketplace/server/fulfillment?deliveryMethod=c6f25a68a395e1d03b6a7e17ccff11e1&productId=0fd932d3-9167-45de-8ffa-05d0a32ec78f®ion=us-east-2&version=9ad69e2a-c3f4-401c-8853-2e8d1202c308&ref_=cfg_full_continue) When I launch the stack creation, I recieve the following error: ```auto Resource handler returned message: "Cannot find version 5.7.41 for mysql (Service: Rds, Status Code: 400, Request ID: 3f1c0225-a3df-4831-b3b2-ede4d44bbecc)" (RequestToken: ab87cd60-3426-a576-1306-1a39b420c1a0, HandlerErrorCode: InvalidRequest) ``` It seems that mySQL version 5.7 is only available through RDS Extended Edition since its official AWS RDS support has ended: [MySQL on Amazon RDS versions - Amazon Relational Database Service](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Concepts.VersionMgmt.html#MySQL.Concepts.VersionMgmt.ReleaseCalendar) Has OpenEMR been proven to work with MySQL 8.0? If so then I would assume this is an easy fix. Honestly, I would prefer to use MariaDB (assuming PostgreSQL is not yet supported), if someone has a CloudFormation Template using MariaDB that would be ideal for my purposes Or maybe I am missing something obvious? Huge Thank You! ---
**Author:** ![cpnsider](https://community.open-emr.org/letter_avatar_proxy/v4/letter/c/e8c25b/32.png) [@cpnsider](https://community.open-emr.org/u/cpnsider)\ **Post date:** [April 12, 2024, 11:24pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/2 "2024-04-12T23:24:16Z")
I ran into the same problem today. Looking at [the cloudformation template](https://s3.amazonaws.com/awsmp-fulfillment-cf-templates-prod/0fd932d3-9167-45de-8ffa-05d0a32ec78f/1cd66cd3ea41403ba7b8038260b1e6da.template), upgrading to MySQL 8.0 may require rebuilding AMIs. Can an expert please chime in? [OpenEMR wiki](https://www.open-emr.org/wiki/index.php/OpenEMR_Downloads) recommends MariaDB over MySQL. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [April 13, 2024, 2:25pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/3 "2024-04-13T14:25:26Z")
hi @Goddard and @cpnsider , thanks for reporting here. Started a [new issue](https://github.com/openemr/openemr-devops/issues/390). For the mariadb feature request, feel free to start another issue on devops 🙂 ---
**Author:** ![jesdynf](https://community.open-emr.org/user_avatar/community.open-emr.org/jesdynf/32/15698_2.png) [@jesdynf](https://community.open-emr.org/u/jesdynf)\ **Post date:** [April 13, 2024, 8:16pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/4 "2024-04-13T20:16:09Z")
I can’t fix that this minute but as soon as I’m not knocked over I’ll try to get a revised CF template into Amazon. In the meantime I bet you _could_ just edit the template you got from AWS Marketplace and launch _that_, which isn’t an ideal answer but it’d get you moving. Sorry for the trouble! ---
**Author:** ![Goddard](https://community.open-emr.org/letter_avatar_proxy/v4/letter/g/43a26b/32.png) [@Goddard](https://community.open-emr.org/u/Goddard)\ **Post date:** [April 14, 2024, 6:32pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/5 "2024-04-14T18:32:10Z")
Thank you so much, you are an absolute life-saver! 💟 💟 💟 ---
**Author:** ![Mika\_F](https://community.open-emr.org/user_avatar/community.open-emr.org/mika_f/32/19193_2.png) [@Mika\_F](https://community.open-emr.org/u/Mika_F)\ **Post date:** [May 9, 2024, 10:31am UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/6 "2024-05-09T10:31:57Z")
Hi, was this issue resolved? I’m getting a very similar error: `Resource handler returned message: "Cannot find version 5.7.41 for mysql (Service: Rds, Status Code: 400, Request ID: d8b500fb-b3c9-4e5e-8391-36460911efb4)" (RequestToken: 4fea68cc-14da-8832-6107-6cccb24a8aa6, HandlerErrorCode: InvalidRequest)` Thanks for your help! ---
**Author:** ![jesdynf](https://community.open-emr.org/user_avatar/community.open-emr.org/jesdynf/32/15698_2.png) [@jesdynf](https://community.open-emr.org/u/jesdynf)\ **Post date:** [May 18, 2024, 8:50pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/7 "2024-05-18T20:50:37Z")
Not yet, sorry. I’m starting work on a task list right and that’s on it but it won’t be done immediately. ---
**Author:** ![Goddard](https://community.open-emr.org/letter_avatar_proxy/v4/letter/g/43a26b/32.png) [@Goddard](https://community.open-emr.org/u/Goddard)\ **Post date:** [May 28, 2024, 1:43pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/8 "2024-05-28T13:43:38Z")
Very Much Appreciated! Thank you! 💟 @jesdynf ---
**Author:** ![nikoma](https://community.open-emr.org/user_avatar/community.open-emr.org/nikoma/32/20142_2.png) [@nikoma](https://community.open-emr.org/u/nikoma)\ **Post date:** [June 7, 2024, 4:42am UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/9 "2024-06-07T04:42:42Z")
How can this be resolved? I am receiving the same error. I am looking forward to roll out the standard install. ---
**Author:** ![Goddard](https://community.open-emr.org/letter_avatar_proxy/v4/letter/g/43a26b/32.png) [@Goddard](https://community.open-emr.org/u/Goddard)\ **Post date:** [June 7, 2024, 12:08pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/10 "2024-06-07T12:08:55Z")
I am also still experiencing this error when attempting to setup from the AWS Marketplace Console. I also attempted to setup directly from the cloudformation template which has lead me to a separate issue: [Cloud Standard Deployment - Received FAILURE signal with UniqueId](https://community.open-emr.org/t/cloud-standard-deployment-received-failure-signal-with-uniqueid/22715) _(Again, huge thanks for anyone taking the time to read this & extra special thanks to @jesdynf for the ongoing support)_ ---
**Author:** ![jesdynf](https://community.open-emr.org/user_avatar/community.open-emr.org/jesdynf/32/15698_2.png) [@jesdynf](https://community.open-emr.org/u/jesdynf)\ **Post date:** [June 7, 2024, 7:39pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/11 "2024-06-07T19:39:13Z")
If you’re still getting the 5.7.41 you don’t have the newest copy of the template, I don’t think. Is there a way to upgrade your version? Last week’s upgrade was supposed to have gone through already. ---
**Author:** ![jesdynf](https://community.open-emr.org/user_avatar/community.open-emr.org/jesdynf/32/15698_2.png) [@jesdynf](https://community.open-emr.org/u/jesdynf)\ **Post date:** [June 8, 2024, 1:37am UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/12 "2024-06-08T01:37:57Z")
Aw, c’mon. I spotted the problem, it was on Marketplace’s side. The procedure for products provisioned with CFTs is a little manual and they got something wrong when they did their edits, I think. I’ve sent them a note about it and hopefully it’ll be repaired soon. Sorry about that! ---
**Author:** ![Goddard](https://community.open-emr.org/letter_avatar_proxy/v4/letter/g/43a26b/32.png) [@Goddard](https://community.open-emr.org/u/Goddard)\ **Post date:** [June 8, 2024, 12:51pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/13 "2024-06-08T12:51:30Z")
Thanks so much! You’re continued support is greatly appreciated @jesdynf ! ---
**Author:** ![nikoma](https://community.open-emr.org/user_avatar/community.open-emr.org/nikoma/32/20142_2.png) [@nikoma](https://community.open-emr.org/u/nikoma)\ **Post date:** [June 8, 2024, 1:58pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/14 "2024-06-08T13:58:28Z")
It only works if you are using Tokyo when using the template from Github. All other locations use non-existing ami templates. I have OpenEMR in the AWS Tokyo datacenter now but the delay is too high. Thank you so much for your tremendous work and ongoing support! ---
**Author:** ![jesdynf](https://community.open-emr.org/user_avatar/community.open-emr.org/jesdynf/32/15698_2.png) [@jesdynf](https://community.open-emr.org/u/jesdynf)\ **Post date:** [June 8, 2024, 2:06pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/15 "2024-06-08T14:06:25Z")
It’s because they did a hand-edit on their copy of the mappings – but you can do the same. Download the CloudFormation template and open it up locally and you’ll see where the MySQL versions are set. Change your region to an 8.x and you can launch the revised template. ---
**Author:** ![nikoma](https://community.open-emr.org/user_avatar/community.open-emr.org/nikoma/32/20142_2.png) [@nikoma](https://community.open-emr.org/u/nikoma)\ **Post date:** [June 8, 2024, 2:16pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/16 "2024-06-08T14:16:24Z")
The MySQL versions are all correct now in the template on Github but none of the "OpenEMRMktPlaceAMI exist so the creation of the webserver fails. Do you happen to know the correct AMI ID for one of the USA locations? }, “us-east-1”: { “MySQLVersion”: “8.0.36”, “OpenEMRMktPlaceAMI”: “ami-07124126f9225d337” }, “us-east-2”: { “MySQLVersion”: “8.0.36”, “OpenEMRMktPlaceAMI”: “ami-f97f429c” }, “us-west-1”: { “MySQLVersion”: “8.0.36”, “OpenEMRMktPlaceAMI”: “ami-f5d6c995” }, “us-west-2”: { “MySQLVersion”: “8.0.36”, “OpenEMRMktPlaceAMI”: “ami-8b4d3af3” } ---
**Author:** ![jesdynf](https://community.open-emr.org/user_avatar/community.open-emr.org/jesdynf/32/15698_2.png) [@jesdynf](https://community.open-emr.org/u/jesdynf)\ **Post date:** [June 8, 2024, 2:23pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/17 "2024-06-08T14:23:27Z")
Yes. They’re in the CFT from Amazon. That’s why I said to get the CFT from Amazon. Get the CFT from Amazon, and edit _that_ to have the correct MySQL version, and you’re good to go. Amazon’s process changes the AMIs on the document I give them because they distribute the images, which is why what’s in GitHub doesn’t match their final product. ---
**Author:** ![nikoma](https://community.open-emr.org/user_avatar/community.open-emr.org/nikoma/32/20142_2.png) [@nikoma](https://community.open-emr.org/u/nikoma)\ **Post date:** [June 8, 2024, 2:34pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/18 "2024-06-08T14:34:57Z")
It worked!! Thank you so much! Installing OpenEMR Standard Edition on AWS Step 1: Select Standard edition template from Marketplace Step 2: Copy the S3 address of the template into a new browser window and download it Step 3: Replace all occurrences of 5.7.41 with 8.0.36 Step 4: Create stack from template and upload the template you have just edited Step 5: Enjoy the most awesome EMR ---
**Author:** ![jesdynf](https://community.open-emr.org/user_avatar/community.open-emr.org/jesdynf/32/15698_2.png) [@jesdynf](https://community.open-emr.org/u/jesdynf)\ **Post date:** [June 8, 2024, 3:50pm UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/19 "2024-06-08T15:50:33Z")
Great! For the record this shouldn’t be required for very much longer, I’m trying to straighten it out with them right now. ---
**Author:** ![nikoma](https://community.open-emr.org/user_avatar/community.open-emr.org/nikoma/32/20142_2.png) [@nikoma](https://community.open-emr.org/u/nikoma)\ **Post date:** [June 9, 2024, 6:30am UTC](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362/20 "2024-06-09T06:30:43Z")
Is there any documentation how to create a certbot SSL certificate? [Next page](https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362.md?page=2)