Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-2427

Upgrade java-mysql-connector to support new server authentication

    XMLWordPrintable

Details

    • New Feature
    • Resolution: Fixed
    • Minor
    • 2.5.45
    • 2.4.0
    • API
    • None

    Description

      MySQL servers 8.0+ have changed their default authentication, and clients < 5.7 won't be able to connect to them without extra effort. The version supplied with Grouper is 5.1.45.

      (So nobody has set up an 8.0 database with Grouper yet??)

      https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html

      In MySQL 5.7, the default authentication plugin is mysql_native_password. As of MySQL 8.0, the default authentication plugin is changed to caching_sha2_password. To enable MySQL 5.7 clients to connect to 8.0 and higher servers using accounts that authenticate with caching_sha2_password, the MySQL 5.7 client library and client programs support the caching_sha2_password client-side authentication plugin. This improves MySQL 5.7 client connect-capability compatibility with respect to MySQL 8.0 and higher servers, despite the differences in default authentication plugin.

      So we should test whether a 5.x will work fine in Grouper to connect with an 8.x database, or whether we would need to upgrade the mysql connector to 8.x.

      Attachments

        Activity

          People

            chad.redman@at.internet2.edu Chad Redman (unc.edu)
            chad.redman@at.internet2.edu Chad Redman (unc.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: