Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-3307

PMM client fails with "authentication plugin is not supported" error for MySQL 5.1

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Priority: Low
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.17.0
    • Fix Version/s: None
    • Component/s: PMM Client
    • Labels:
      None

      Description

      Cannot add MySQL 5.1 instance with pmm-admin due to driver error:

      # pmm-admin add mysql --password msandbox --user msandbox --socket /tmp/mysql_sandbox5173.sock
      [linux:metrics] OK, now monitoring this system.
      [mysql] 2018/11/26 11:46:04 auth.go:293: unknown auth plugin:
      [mysql] 2018/11/26 11:46:04 driver.go:120: could not use requested auth plugin '': this authentication plugin is not supported
      [mysql] 2018/11/26 11:46:04 auth.go:293: unknown auth plugin:
      [mysql] 2018/11/26 11:46:04 driver.go:120: could not use requested auth plugin '': this authentication plugin is not supported
      [mysql] 2018/11/26 11:46:04 auth.go:293: unknown auth plugin:
      [mysql] 2018/11/26 11:46:04 driver.go:120: could not use requested auth plugin '': this authentication plugin is not supported
      [mysql:metrics] OK, now monitoring MySQL metrics using DSN msandbox:***@unix(/tmp/mysql_sandbox5173.sock)
      [mysql] 2018/11/26 11:46:04 auth.go:293: unknown auth plugin:
      [mysql] 2018/11/26 11:46:04 driver.go:120: could not use requested auth plugin '': this authentication plugin is not supported
      [mysql] 2018/11/26 11:46:04 auth.go:293: unknown auth plugin:
      [mysql] 2018/11/26 11:46:04 driver.go:120: could not use requested auth plugin '': this authentication plugin is not supported
      [mysql:queries] OK, now monitoring MySQL queries from slowlog using DSN msandbox:***@unix(/tmp/mysql_sandbox5173.sock)

      Looks like being related to Go MySQL driver changes and this should fix the issue as found in https://github.com/go-sql-driver/mysql/pull/835

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                przemyslaw.malkowski@percona.com Przemyslaw Malkowski
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 hour
                  1h