mysql_server_spec.rb

require 'spec_helper_acceptance'

describe 'mysql class' do
  describe 'advanced config' do
    let(:pp) do
      <<-MANIFEST
        class { 'mysql::server':
          manage_config_file      => 'true',
          override_options        => { 'mysqld' => { 'key_buffer_size' => '32M' }},
          package_ensure          => 'present',
          purge_conf_dir          => 'true',
          remove_default_accounts => 'true',
          restart                 => 'true',
          root_group              => 'root',
          root_password           => 'test',
          service_enabled         => 'true',
          service_manage          => 'true',
          users                   => {
            'someuser@localhost' => {
              ensure                   => 'present',
              max_connections_per_hour => '0',
              max_queries_per_hour     => '0',
              max_updates_per_hour     => '0',
              max_user_connections     => '0',
              password_hash            => '*F3A2A51A9B0F2BE2468926B4132313728C250DBF',
            }},
          grants                  => {
            'someuser@localhost/somedb.*' => {
              ensure     => 'present',
              options    => ['GRANT'],
              privileges => ['SELECT', 'INSERT', 'UPDATE', 'DELETE'],
              table      => 'somedb.*',
              user       => 'someuser@localhost',
            },
          },
          databases => {
            'somedb' => {
              ensure  => 'present',
              charset => 'utf8',
            },
          }
        }
      MANIFEST
    end

    it_behaves_like 'a idempotent resource'
  end

  describe 'minimal config' do
    before(:all) do
      @tmpdir = default.tmpdir('mysql')
    end
    # 'manage_config_file'/'service_enabled' being set to false can cause random failures in Debian 9
    let(:os_variant) do
      if fact('operatingsystem') =~ %r{Debian} && fact('operatingsystemrelease') =~ %r{^9\.}
        'true'
      else
        'false'
      end
    end
    let(:pp) do
      <<-MANIFEST
        class { 'mysql::server':
          manage_config_file      => '#{os_variant}',
          override_options        => { 'mysqld' => { 'key_buffer_size' => '32M' }},
          package_ensure          => 'present',
          purge_conf_dir          => 'false',
          remove_default_accounts => 'false',
          restart                 => 'false',
          root_group              => 'root',
          root_password           => 'test',
          service_enabled         => '#{os_variant}',
          service_manage          => 'false',
          users                   => {},
          grants                  => {},
          databases               => {},
        }
      MANIFEST
    end

    it_behaves_like 'a idempotent resource'
  end

  describe 'syslog configuration' do
    let(:pp) do
      <<-MANIFEST
        class { 'mysql::server':
          override_options => { 'mysqld' => { 'log-error' => undef }, 'mysqld_safe' => { 'log-error' => false, 'syslog' => true }},
        }
      MANIFEST
    end

    it_behaves_like 'a idempotent resource'
  end

  context 'when changing the password' do
    let(:password) { 'THE NEW SECRET' }
    let(:pp) { "class { 'mysql::server': root_password => '#{password}' }" }

    it 'does not display the password' do
      result = execute_manifest(pp, catch_failures: true)
      # this does not actually prove anything, as show_diff in the puppet config defaults to false.
      expect(result.stdout).not_to match %r{#{password}}
    end

    it_behaves_like 'a idempotent resource'
  end
end