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

Upgrade path broken on Debian-based systems

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Trivial
        • Resolution: Won't Fix
        • Affects Version/s: 5.5.33
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None
        • Environment:
          Ubuntu 12.04 LTS

          Description

          After the release of MariaDB 5.5.33, running an apt-get upgrade on the machine leaves mariadb packages in an incomplete status.

          The syslog reports the following error:

          Sep 18 12:05:32 db01 mysqld_safe[10670]: 130918 12:05:32 [ERROR] /usr/sbin/mysqld: unknown variable 'pam_use_cleartext_plugin=1'

          Removing the option from the config files and restarting the upgrade fixes the problem, and after that I can re-enable the option and restart MariaDB successfully.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                discussed the problem with the user on IRC. Here's what happening:

                • he has this option in the my.cnf and a pam plugin installed
                • during the upgrade process, debian postinst script temporarily restarts the server in the "safe mode" (with --skip-grant-tables) which skips loading of plugins
                • without plugins --pam-use-cleartext-plugin is not recognized and upgrade fails
                Show
                serg Sergei Golubchik added a comment - discussed the problem with the user on IRC. Here's what happening: he has this option in the my.cnf and a pam plugin installed during the upgrade process, debian postinst script temporarily restarts the server in the "safe mode" (with --skip-grant-tables) which skips loading of plugins without plugins --pam-use-cleartext-plugin is not recognized and upgrade fails
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                I'm not really sure how we can fix that. One can always have plugin options in my.cnf and they won't be recognized when server is started with --skip-grants.

                A safe workaround would be to prefix all plugin options in your my.cnf file with --loose

                Show
                serg Sergei Golubchik added a comment - I'm not really sure how we can fix that. One can always have plugin options in my.cnf and they won't be recognized when server is started with --skip-grants . A safe workaround would be to prefix all plugin options in your my.cnf file with --loose
                Hide
                Permalink
                giannello Giuseppe Iannello added a comment -

                Using the --loose prefix seems to be the best solution, due to the way plugins are loaded (or not, when using safe mode) and is confirmed working. Probably this should be documented a little mode.

                Show
                giannello Giuseppe Iannello added a comment - Using the --loose prefix seems to be the best solution, due to the way plugins are loaded (or not, when using safe mode) and is confirmed working. Probably this should be documented a little mode.
                Hide
                Permalink
                giannello Giuseppe Iannello added a comment -

                s/mode/more/

                Show
                giannello Giuseppe Iannello added a comment - s/mode/more/

                  People

                  • Assignee:
                    serg Sergei Golubchik
                    Reporter:
                    giannello Giuseppe Iannello
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: