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

[ronnybremer]

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:[email protected]/nextclouddb?ssl-ca=/etc/pki/ca-trust/source/anchors/rootca.pem /opt/nextcloud/notify_push /var/www/html/nextcloud/config/config.php