You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jobs@airflow.apache.org by GitBox <gi...@apache.org> on 2026/04/20 23:33:20 UTC

[GH] (airflow/fix/db-shell-mysql-ssl-params): Workflow run "Check newsfragment PR number" failed!

The GitHub Actions job "Check newsfragment PR number" on airflow.git/fix/db-shell-mysql-ssl-params has failed.
Run started by GitHub user 1fanwang (triggered by 1fanwang).

Head commit for run:
850d60194a1e32415196e787000cb728c78d7e72 / Stefan Wang <21...@users.noreply.github.com>
Forward MySQL SSL params from sql_alchemy_conn to airflow db shell

With MySQL cert-based authentication (``CREATE USER ... REQUIRE X509``,
ProxySQL with cert passthrough, or auth plugins that map cert SANs to
MySQL users), ``sql_alchemy_conn`` carries ``ssl_ca``/``ssl_cert``/
``ssl_key``/``ssl_mode`` in the query string and no password. Airflow's
scheduler, webserver, and workers all connect successfully — SQLAlchemy's
mysqldb dialect consumes the ``ssl_*`` query params and forwards them
to the C client.

``airflow db shell``, however, writes a ``my.cnf`` containing only
host/user/password/port/database and invokes ``mysql`` via
``--defaults-extra-file``, silently dropping the ``ssl_*`` params. The
resulting empty-password attempt is rejected with a misleading
"Access denied (using password: YES)" even though the user is
cert-provisioned and never sends a password.

Extract my.cnf construction into a pure, typed helper and forward the
well-known MySQL SSL / connection query params (``ssl_ca``, ``ssl_cert``,
``ssl_key``, ``ssl_cipher``, ``ssl_mode``, ``charset``) into the
``[client]`` section, translating SQLAlchemy's underscored keys to the
hyphenated option-file keys that the mysql client expects.

Closes #65573

Signed-off-by: Stefan Wang <21...@users.noreply.github.com>

Report URL: https://github.com/apache/airflow/actions/runs/24695805433

With regards,
GitHub Actions via GitBox


---------------------------------------------------------------------
To unsubscribe, e-mail: jobs-unsubscribe@airflow.apache.org
For additional commands, e-mail: jobs-help@airflow.apache.org