[Bug 295845] mail/sqlgrey: Failed to connect databases/mysql84-server

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=295845

--- Comment #1 from Jochen Neumeister <joneum@FreeBSD.org> ---
The issue may indeed have become visible after the default MySQL version
changed from 8.0 to 8.4, since MySQL 8.4 uses caching_sha2_password by default
and mysql_native_password is no longer enabled by default on the server side.

That said, I am not convinced that the proposed fix is appropriate as-is. The
patch unconditionally adds:

mysql_ssl=1

to every MySQL DSN, effectively forcing SSL for all sqlgrey MySQL connections.

While this may resolve the problem in the reported environment, it also changes
the behavior for all existing sqlgrey installations using MySQL. I would be
hesitant to commit or ship such a change without further discussion, as it
introduces a global behavior change and may cause regressions in deployments
where SSL is not currently configured or expected.

It may be worth investigating whether SSL support should instead be
configurable, allowing administrators to enable it when required by their MySQL
authentication and transport settings.

-- 
You are receiving this mail because:
You are the assignee for the bug.