Unable to connect to MySQL DB with SSL and clear text password

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

Steps to reproduce

1. MySQL DB 8 set up with SSL and native password
2. use Nextcloud config.php and override DATABASE_URL to enable ssl-mode=Required and set the ssl-ca
3. launch the notify daemon

Expected behaviour

The notify daemon should connect to the database

Actual behaviour

Error: × Failed to connect to database: encountered unexpected or invalid data: mysql_cleartext_plugin disabled (sqlx_mysql::protocol::connect::auth_switch:30)
╰─▶ encountered unexpected or invalid data: mysql_cleartext_plugin disabled (sqlx_mysql::protocol::connect::auth_switch:30)

Server configuration

Web server: Apache

Database: MySQL 8

PHP version: 8.2

Nextcloud version: 30.0.2

DATABASE_URL=mysql://nextcloud:XXX@mysql.local/nextclouddb?ssl-ca=/etc/pki/ca-trust/source/anchors/rootca.pem /opt/nextcloud/notify_push /var/www/html/nextcloud/config/config.php

Start with the notify daemon's database connection path and reproduce the failure using the MySQL 8 setup, SSL options, and DATABASE_URL shown in the issue. Check how config.php passes the connection settings and inspect the reported sqlx_mysql::protocol::connect::auth_switch path. Done means the notify daemon connects successfully with SSL and the cleartext-password configuration.