puppet-module-puppetlabs-mysql outdated and incompatible with 16.04

[Hadmut Danisch]

Hi,

puppet-module-puppetlabs-mysql does not work under 16.04.

Reason: it's outdated and incompatible with the mysql version that comes with ubuntu 16.04.

puppet-module-puppetlabs-mysql creates /etc/mysql/my.cnf (and overwrites if manually edited to correct) and fills in the options

key_buffer_size = 16M (twice!)

myisam_recover = BACKUP

but mysqld refuses to start since these options are unknown. Removing both with an editor makes mysqld start, but next puppet run puppet restores the wrong values.

Please fix.

ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: puppet-module-puppetlabs-mysql 3.6.1-1
ProcVersionSignature: Ubuntu 4.4.0-22.39-generic 4.4.8
Uname: Linux 4.4.0-22-generic x86_64
ApportVersion: 2.20.1-0ubuntu2
Architecture: amd64
CurrentDesktop: XFCE
Date: Sat May 14 15:41:29 2016
InstallationDate: Installed on 2015-10-08 (218 days ago)
InstallationMedia: Xubuntu 15.10 "Wily Werewolf" - Alpha amd64 (20150924)
PackageArchitecture: all
SourcePackage: puppet-module-puppetlabs-mysql
UpgradeStatus: Upgraded to xenial on 2016-05-06 (7 days ago)

[Hadmut Danisch (hadmut)]

btw, another bug in

/usr/share/puppet/modules.available/puppetlabs-mysql/manifests/params.pp

is

  case $::operatingsystem {
    'Ubuntu': {
      $server_service_provider = upstart
    }
    default: {
      $server_service_provider = undef
    }
  }

should be systemd right now.

[Hadmut Danisch (hadmut)]

Workaround for first problem:

class{

    '::mysql::server':

      override_options => {

        mysqld => {
          'myisam_recover' => undef,
          'key_buffer_size' => undef,
        },

      isamchk => {
        'key_buffer_size' => undef,
      },

    } ;

But workarounds should not be required.

[Hadmut Danisch (hadmut)]

Workaround for second problem:

class{

    '::mysql::server':
               service_provider => 'systemd',

...

[Hadmut Danisch (hadmut)]

Next problem:

Error: Could not prefetch mysql_user provider 'mysql': Execution of '/usr/bin/mysql -NBe SELECT MAX_USER_CONNECTIONS, MAX_CONNECTIONS, MAX_QUESTIONS, MAX_UPDATES, PASSWORD /*!50508 , PLUGIN */ FROM mysql.user WHERE CONCAT(user, '@', host) = 'debian-sys-maint@localhost'' returned 1: ERROR 1054 (42S22) at line 1: Unknown column 'PASSWORD' in 'field list'
Error: Execution of '/usr/bin/mysql -e CREATE USER 'root'@'localhost' IDENTIFIED BY PASSWORD '*443B61BE7C79F04F8B6451B74EEF0042736EA707'' returned 1: ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'root'@'localhost'
Error: /Stage[verwaltung]/Mysql::Server::Root_password/Mysql_user[root@localhost]/ensure: change from absent to present failed: Execution of '/usr/bin/mysql -e CREATE USER 'root'@'localhost' IDENTIFIED BY PASSWORD '*443B61BE7C79F04F8B6451B74EEF0042736EA707'' returned 1: ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'root'@'localhost'

There is no PASSWORD column anymore in this mysql version that comes with 16.04.

Upgrade that damned package.

[Sebastien Badia (sbadia)]

Updated in Debian https://tracker.debian.org/news/953120/accepted-puppet-module-puppetlabs-mysql-530-1-source-into-unstable/