Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7934

Oracle-compatible PAM plugin auth_pam_compat not working for MySQL 8.0.27

Details

    • Bug
    • Status: In Progress
    • Low
    • Resolution: Unresolved
    • None
    • None
    • Documentation

    Description

      https://www.percona.com/doc/percona-server/8.0/security/pam_plugin.html#pam-plugin

      Oracle-compatible PAM called auth_pam_compat. This plugin uses mysql_clear_password which is a part of Oracle MySQL client.

      Percona PAM Plugin works for MySQL 8.0.26 version , but in MySQL 8.0.27 version it's failing with following error,

      ERROR 1126 (HY000): Can't open shared library 'auth_pam_compat.so' (errno: 0 API version for AUTHENTICATION plugin is too different)

      Test:

      Server version: 8.0.26 MySQL Community Server - GPL

       

      mysql [localhost] {msandbox} ((none)) > INSTALL PLUGIN auth_pam_compat SONAME 'auth_pam_compat.so';
      Query OK, 0 rows affected (0.01 sec)
      mysql [localhost] {msandbox} ((none)) > Select * from information_schema.plugins where plugin_name like 'auth_pam_compat'\G
      *************************** 1. row ***************************
       PLUGIN_NAME: auth_pam_compat
       PLUGIN_VERSION: 0.1
       PLUGIN_STATUS: ACTIVE
       PLUGIN_TYPE: AUTHENTICATION
       PLUGIN_TYPE_VERSION: 2.0
       PLUGIN_LIBRARY: auth_pam_compat.so
      PLUGIN_LIBRARY_VERSION: 1.10
       PLUGIN_AUTHOR: Percona, Inc.
       PLUGIN_DESCRIPTION: PAM authentication plugin
       PLUGIN_LICENSE: GPL
       LOAD_OPTION: ON
      1 row in set (0.00 sec)
      

       

       

      Server version: 8.0.27 MySQL Community Server - GPL

       

      mysql [localhost] {msandbox} ((none)) > INSTALL PLUGIN auth_pam_compat SONAME 'auth_pam_compat.so';
      ERROR 1126 (HY000): Can't open shared library 'auth_pam_compat.so' (errno: 0 API version for AUTHENTICATION plugin is too different)
      
      mysql [localhost] {msandbox} ((none)) > INSTALL PLUGIN auth_pam SONAME 'auth_pam.so';
      ERROR 1126 (HY000): Can't open shared library 'auth_pam.so' (errno: 0 API version for AUTHENTICATION plugin is too different)
      

      Related Upstream Bug report#https://bugs.mysql.com/bug.php?id=105264

       

      Attachments

        Issue Links

          Activity

            People

              patrick.birch Patrick Birch
              lalit.choudhary Lalit Choudhary
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 hours
                  2h

                  Smart Checklist