bug: version 5.7.41 for mysql - OpenEMR Cloud Standard Edition - CloudFormation Issue

[stephenwaite]

Describe the bug

To Reproduce

Steps to reproduce the behavior:

1. Add a '....'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior

bug: https://community.open-emr.org/t/cannot-find-version-5-7-41-for-mysql-openemr-cloud-standard-edition-cloudformation-issue/22362

Client configuration

• OpenEMR version:
• Operating system:

[Jmevorach]

Good afternoon @stephenwaite ! Hope this message finds you well.

I have proof that OpenEMR works for MySQL v8.0> 😊.

See the line of code here.

In the version of the CDK used (v2.133.0) the Aurora MySQL version referenced there is 8.03.6 which according to documentation here

[8.]3.x Aurora MySQL engine versions are wire-compatible with MySQL 8.0.23 onwards

This means that OpenEMR v7.0.2 is compatible with at least MySQL v8.0.23. Hope this is helpful.

[Jmevorach]

Oh also @stephenwaite fun fact; that version of the Aurora MySQL engine (v3.06), according to documentation here:

Today, AWS announces that Amazon Aurora ML now provides access to foundation models available in Amazon Bedrock directly through SQL in the Aurora MySQL 3.06 version.

Amazon Aurora ML exposes models as SQL functions, allowing you to use standard SQL to pass data to models and return model output as query results. It provides simple, optimized, and secure integration between Aurora and AWS machine learning services without having to build custom integrations or move data around. As an example, Aurora ML and Bedrock together can enable real-time summarization of customer support notes in Aurora to accelerate case resolution. Aurora ML can also pass current and relevant database information to Bedrock to improve chatbot responses.

This means we should in theory be able to write some modules in PHP that would allow OpenEMR installations running that version of the Aurora MySQL engine (which OpenEMR v7.0.2 supports) to summarize data in a way that was specific to the data in a certain OpenEMR installation using something like Claude 3 via Bedrock.

[jesdynf]

I'll get this soon, but not today.

[jesdynf]

Prepping the revised CFT for AWS Marketplace now.