AWS MySQL ODBC Driver Installation Failure

[elisehellwig]

Describe the bug

I tried to install the AWS MySQL ODBC Connector and am on a Mac (Sequoia, ARM) via the
aws-mysql-odbc-1.1.0-macos.pkg installer. First I installed iODBC and and then tried to install AWS MySQL ODBC but it failed at the last step but didn't tell me what went wrong.

Expected Behavior

I expected driver to be installed and appear in my iODBC Application.

Were cluster failover and/or enhanced failure detection enabled? Were any AWS authentication methods used? What other connection properties were set?

No nothing

Current Behavior

The driver told me it wasn't installed. It seems like some of the files were created but it doesn't appear as a driver in iODBC.

The following directories exist:
/usr/local/aws-mysql-odbc-1.1.0-macos/lib/
usr/local/aws-mysql-odbc-1.1.0-macos/bin/

These file exists:
/usr/local/aws-mysql-odbc-1.1.0-macos/lib/awsmysqlodbcw.dylib
/usr/local/bin/myodbc-installer

Reproduction Steps

I downloaded the installer and then ran it (aws-mysql-odbc-1.1.0-macos.pkg).

Possible Solution

No response

Additional Information/Context

No response

The AWS ODBC Driver for MySQL version used

v1.1.0

Operating System and version

Mac ARM Sequoia 15.3.1 (24D70)

[karenc-bq]

Hi @elisehellwig, unfortunately the driver only supports Intel Mac at the moment. We will update the documentation to clarify this, thank you for raising this issue.

[elisehellwig]

@karenc-bq, Is it possible to connect to an AWS Aurora (MySQL) database using the regular MySQL ODBC driver?

[karenc-bq]

Hi @elisehellwig, yes you can. You can just supply the Aurora endpoints as the hostname and use the community driver. However you won't be able to take advantage of the AWS authentication and Failover support. Would you be able to provide a bit more about your use case?

[elisehellwig]

Sure @karenc-bq! I am working on setting up a database on AWS Aurora for a group with relatively low levels of comfort with databases. They have samples that they have taken at particular sites that are indicated with the field site_id. I would like to have the site information piped into the excel file where they do their data entry so that they can make sure that they are using site_id values that actually exist. Basically that field would be used to populate a drop-down that they could use to select site_id for each sample they wanted to enter. As a note, that data will be exported as csvs where it will then be uploaded to an S3 bucket and then ingested into the database, but I think I have a pretty good handle on that for right now.