search

openemr / openemr-devops

OpenEMR administration and deployment tooling
GNU General Public License v3.0
87 stars 135 forks source link

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

Closed stephenwaite closed 1 week ago

stephenwaite commented 1 month ago

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

Jmevorach commented 1 month ago

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 commented 1 month ago

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 commented 2 weeks ago

I'll get this soon, but not today.

jesdynf commented 1 week ago

Prepping the revised CFT for AWS Marketplace now.