[MDEV-5032] Upgrade path broken on Debian-based systems Created: 2013-09-18  Updated: 2014-02-07  Resolved: 2014-02-06

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.33
Fix Version/s: None

Type: Bug Priority: Trivial
Reporter: Giuseppe Iannello Assignee: Sergei Golubchik
Resolution: Won't Fix Votes: 0
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.

 Comments   
Comment by Sergei Golubchik [ 2013-09-18 ]

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
Comment by Sergei Golubchik [ 2014-02-06 ]

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

Comment by Giuseppe Iannello [ 2014-02-07 ]

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.

Comment by Giuseppe Iannello [ 2014-02-07 ]

s/mode/more/

Generated at Thu Feb 08 07:01:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.