Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20569

Plugin dialog could not be loaded (wrong path)

Details

    Description

      Since I upgraded from MariaDB 10.3.17 to 10.3.18, using apt upgrade (Debian Stretch) followed by a mysql_upgrade, I can't authenticate anymore using PAM:

      myuser:~# mysql
      		 
      ERROR 1045 (28000): Plugin dialog could not be loaded: /usr//usr/lib/mysql/plugin/dialog.so: cannot open shared object file: No such file or directory

      => As you can see, Plugin Path /usr//usr/lib/mysql/plugin/dialog.so is wrong (duplicate prefix /usr/)

      Here are my current settings:

      +---------------+------------------------+
      		 
      | Variable_name | Value                  |
      		 
      +---------------+------------------------+
      		 
      | basedir       | /usr                   |
      		 
      | plugin_dir    | /usr/lib/mysql/plugin/ |
      		 
      +---------------+------------------------+

      Specifying the right path for plugin-dir on the command line fixes the problem:

      myuser:~# mysql -e "exit" && echo "OK"
      		 
      ERROR 1045 (28000): Plugin dialog could not be loaded: /usr//usr/lib/mysql/plugin/dialog.so: cannot open shared object file: No such file or directory
      		 
       
      		 
      myuser:~# mysql --plugin-dir=/usr/lib/mysql/plugin -e "exit" && echo "OK"
      		 
      OK

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONC-376 missing prefix for searching mysql_clear_password.so

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CONC-383 Plugin auth_gssapi_client could not be loaded; missing "/usr/" prefix

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONC-431 Use bcrypt on Windows for authentication plugins

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19807 MariaDB client plugin path is wrong

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19942 Default installation of mariadb-server doesn't allow clients to use client plugins

          • Major - Major loss of function.
          • Closed

          Activity

            Descending order - Click to sort in ascending order
            sscherfke Stefan Scherfke added a comment -

            I have a similar problem with the python-mariadbclient: When I try to perform gssapi-auth with it, I get `/home/...env//hom/...env/lib/plugin/auth_gssapi_client.so: cannot open shared object file: No such file or directory')`.

            The changes 8e6812be71d0b44d302fda84d53a6ec106b48296 fixes the problem for me.

            sscherfke Stefan Scherfke added a comment - I have a similar problem with the python-mariadbclient: When I try to perform gssapi-auth with it, I get `/home/...env//hom/...env/lib/plugin/auth_gssapi_client.so: cannot open shared object file: No such file or directory')`. The changes 8e6812be71d0b44d302fda84d53a6ec106b48296 fixes the problem for me.
            georg Georg Richter added a comment -

            Sanja, could you please check if changeset 8e6812be71d0b44d302fda84d53a6ec106b48296 will fix the problem?

            georg Georg Richter added a comment - Sanja, could you please check if changeset 8e6812be71d0b44d302fda84d53a6ec106b48296 will fix the problem?
            hholzgra Hartmut Holzgraefe added a comment -

            On 10.2.27 the compiled in default plugin dir path is clearly wrong:

            $ strings /usr/bin/mysql | grep /plugin
            		 
            /usr//usr/lib64/mysql/plugin

            Same on 10.2.26 returns expected result:

            $ strings /usr/bin/mysql | grep /plugin
            		 
            /usr/lib64/mysql/plugin

            hholzgra Hartmut Holzgraefe added a comment - On 10.2.27 the compiled in default plugin dir path is clearly wrong: $ strings /usr/bin/mysql | grep /plugin /usr//usr/lib64/mysql/plugin Same on 10.2.26 returns expected result: $ strings /usr/bin/mysql | grep /plugin /usr/lib64/mysql/plugin
            johnhowe John Howe added a comment - - edited

            I am seeing the same issue with Debian 8.11, mariadb 10.2.27+maria~jessie

            Since I can't downgrade the packages, I have a temporary work-around by adding the following under /etc/mysql/mariadb.conf.d/99-20569-hotfix.cnf

            Fix for https://jira.mariadb.org/browse/MDEV-20569
            [client]
            plugin-dir=/usr/lib/mysql/plugin

            johnhowe John Howe added a comment - - edited I am seeing the same issue with Debian 8.11, mariadb 10.2.27+maria~jessie Since I can't downgrade the packages, I have a temporary work-around by adding the following under /etc/mysql/mariadb.conf.d/99-20569-hotfix.cnf Fix for https://jira.mariadb.org/browse/MDEV-20569 [client] plugin-dir=/usr/lib/mysql/plugin
            tturenko Timofey Turenko added a comment -

            run into the same problem with Maxscale kerberos tests:

            (test does "echo select User,Host from mysql.user | mysql --ssl -uusr1 -h maxscale.maxscale.test -P 4006"):

            244: 09:39:57.930 94.943335: Installing gssapi plugin to all nodes
            		 
            244: 09:39:58.297 95.309789: Creating usr1 user
            		 
            244: 09:39:58.302 95.315556: Trying use usr1 to execute query: RW Split
            		 
            244: ERROR 1045 (28000): Plugin auth_gssapi_client could not be loaded: /usr//usr/lib64/mysql/plugin/auth_gssapi_client.so: cannot open shared object file: No such file or directory
            		 
            244: 96.446531: TEST_FAILED! Error executing query against RW Split
            		 
            244: 09:39:59.433 96.446551: Trying use usr1 to execute query: Read Connection Master
            		 
            244: ERROR 1045 (28000): Plugin auth_gssapi_client could not be loaded: /usr//usr/lib64/mysql/plugin/auth_gssapi_client.so: cannot open shared object file: No such file or directory
            		 
            244: 96.758715: TEST_FAILED! Error executing query against Read Connection Master
            		 
            244: 09:39:59.746 96.758735: Trying use usr1 to execute query: Read Connection Slave
            		 
            244: ERROR 1045 (28000): Plugin auth_gssapi_client could not be loaded: /usr//usr/lib64/mysql/plugin/auth_gssapi_client.so: cannot open shared object file: No such file or directory

            tturenko Timofey Turenko added a comment - run into the same problem with Maxscale kerberos tests: (test does " echo select User,Host from mysql.user | mysql --ssl -uusr1 -h maxscale.maxscale.test -P 4006 "): 244: 09:39:57.930 94.943335: Installing gssapi plugin to all nodes 244: 09:39:58.297 95.309789: Creating usr1 user 244: 09:39:58.302 95.315556: Trying use usr1 to execute query: RW Split 244: ERROR 1045 (28000): Plugin auth_gssapi_client could not be loaded: /usr//usr/lib64/mysql/plugin/auth_gssapi_client.so: cannot open shared object file: No such file or directory 244: 96.446531: TEST_FAILED! Error executing query against RW Split 244: 09:39:59.433 96.446551: Trying use usr1 to execute query: Read Connection Master 244: ERROR 1045 (28000): Plugin auth_gssapi_client could not be loaded: /usr//usr/lib64/mysql/plugin/auth_gssapi_client.so: cannot open shared object file: No such file or directory 244: 96.758715: TEST_FAILED! Error executing query against Read Connection Master 244: 09:39:59.746 96.758735: Trying use usr1 to execute query: Read Connection Slave 244: ERROR 1045 (28000): Plugin auth_gssapi_client could not be loaded: /usr//usr/lib64/mysql/plugin/auth_gssapi_client.so: cannot open shared object file: No such file or directory
            GeoffMontee Geoff Montee (Inactive) added a comment -

            Maybe this was broken by this change that was part of the fix for CONC-431?:

            https://github.com/MariaDB/mariadb-connector-c/commit/11a2d035dde02b2a4379d5c5b978ada7447e9bfd#diff-6005b12e9a4ecd5532b0a3f629c5a4e6

            GeoffMontee Geoff Montee (Inactive) added a comment - Maybe this was broken by this change that was part of the fix for CONC-431 ?: https://github.com/MariaDB/mariadb-connector-c/commit/11a2d035dde02b2a4379d5c5b978ada7447e9bfd#diff-6005b12e9a4ecd5532b0a3f629c5a4e6
            GeoffMontee Geoff Montee (Inactive) added a comment -

            An almost identical bug was just fixed in the previous round of releases. See MDEV-19807.

            GeoffMontee Geoff Montee (Inactive) added a comment - An almost identical bug was just fixed in the previous round of releases. See MDEV-19807 .
            laca Laszlo Soos added a comment -

            Same on 10.4.8 with clear_password.

            bcf17c125bf3:~# mysql -u asd -p
            		 
            Enter password:
            		 
            ERROR 1045 (28000): Plugin mysql_clear_password could not be loaded: Error loading shared library /usr//usr/lib/mysql/plugin/mysql_clear_password.so: No such file or directory
            		 
            bcf17c125bf3:~# mysqld -V
            		 
            mysqld  Ver 10.4.8-MariaDB for Linux on x86_64 (MariaDB Server)

            laca Laszlo Soos added a comment - Same on 10.4.8 with clear_password. bcf17c125bf3:~# mysql -u asd -p Enter password: ERROR 1045 (28000): Plugin mysql_clear_password could not be loaded: Error loading shared library /usr//usr/lib/mysql/plugin/mysql_clear_password.so: No such file or directory bcf17c125bf3:~# mysqld -V mysqld Ver 10.4.8-MariaDB for Linux on x86_64 (MariaDB Server)

            People

              sanja Oleksandr Byelkin
              nico Nicolas Payart
              Votes:
              6 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.