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

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

            Bug ID: 295845
           Summary: mail/sqlgrey: Failed to connect
                    databases/mysql84-server
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs@FreeBSD.org
          Reporter: epopen@gmail.com
                CC: joneum@FreeBSD.org
                CC: joneum@FreeBSD.org

Created attachment 271472
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=271472&action=edit
mail/sqlgrey caching_sha2_password support

Hi All

In my server, I using databases/mysql84-server without "mysql_native_password"
plugin.

And mail/sqlgrey got failed as follows.
    Jun  4 15:16:47 mail sqlgrey: 2026/06/04-15:16:47 sqlgrey (type
Net::Server::Multiplex) starting! pid(20728) 
    Jun  4 15:16:47 mail sqlgrey: Resolved [*]:2501 to [::]:2501, IPv6 
    Jun  4 15:16:47 mail sqlgrey: Binding to TCP port 2501 on host :: with IPv6 
    Jun  4 15:16:47 mail sqlgrey: Setting gid to "11212 11212" 
    Jun  4 15:16:47 mail sqlgrey: Setting uid to "11212" 
    Jun  4 15:16:47 mail sqlgrey: dbaccess: can't connect to DB: Authentication
plugin 'caching_sha2_password' reported error: Authentication requires secure
connection. 
    Jun  4 15:16:47 mail sqlgrey: dbaccess: error: couldn't get now() from DB:
Authentication plugin 'caching_sha2_password' reported error: Authentication
requires secure connection. 
    Jun  4 15:16:47 mail sqlgrey: dbaccess: can't connect to DB: Authentication
plugin 'caching_sha2_password' reported error: Authentication requires secure
connection. 
    Jun  4 15:16:47 mail sqlgrey: dbaccess: error: couldn't access config
table: Authentication plugin 'caching_sha2_password' reported error:
Authentication requires secure connection. 

I tried to fix it and generated patch in attachment for workaround.
Could verify it and update ports? 

Thanks a lot.

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