Mercurial > repos > other > Puppet
view modules/mysql/spec/classes/mysql_server_backup_spec.rb @ 220:ccc13f56f8ec puppet-3.6
Blacklist lots more users from SSH probes
Includes the german for "web page"
author | IBBoard <dev@ibboard.co.uk> |
---|---|
date | Sat, 14 Sep 2019 10:34:43 +0100 |
parents | 58d1818c2ded |
children | 48d3a1948e4d |
line wrap: on
line source
require 'spec_helper' describe 'mysql::server::backup' do on_pe_supported_platforms(PLATFORMS).each do |pe_version,pe_platforms| pe_platforms.each do |pe_platform,facts| describe "on #{pe_version} #{pe_platform}" do let(:facts) { facts } let(:default_params) { { 'backupuser' => 'testuser', 'backuppassword' => 'testpass', 'backupdir' => '/tmp', 'backuprotate' => '25', 'delete_before_dump' => true, 'execpath' => '/usr/bin:/usr/sbin:/bin:/sbin:/opt/zimbra/bin', } } context 'standard conditions' do let(:params) { default_params } # Cannot use that_requires here, doesn't work on classes. it { is_expected.to contain_mysql_user('testuser@localhost').with( :require => 'Class[Mysql::Server::Root_password]') } it { is_expected.to contain_mysql_grant('testuser@localhost/*.*').with( :privileges => ['SELECT', 'RELOAD', 'LOCK TABLES', 'SHOW VIEW', 'PROCESS'] ).that_requires('Mysql_user[testuser@localhost]') } it { is_expected.to contain_cron('mysql-backup').with( :command => '/usr/local/sbin/mysqlbackup.sh', :ensure => 'present' )} it { is_expected.to contain_file('mysqlbackup.sh').with( :path => '/usr/local/sbin/mysqlbackup.sh', :ensure => 'present' ) } it { is_expected.to contain_file('mysqlbackupdir').with( :path => '/tmp', :ensure => 'directory' )} it 'should have compression by default' do is_expected.to contain_file('mysqlbackup.sh').with( :content => /bzcat -zc/ ) end it 'should skip backing up events table by default' do is_expected.to contain_file('mysqlbackup.sh').with( :content => /EVENTS="--ignore-table=mysql.event"/ ) end it 'should have 25 days of rotation' do # MySQL counts from 0 is_expected.to contain_file('mysqlbackup.sh').with_content(/.*ROTATE=24.*/) end it 'should have a standard PATH' do is_expected.to contain_file('mysqlbackup.sh').with_content(%r{PATH=/usr/bin:/usr/sbin:/bin:/sbin:/opt/zimbra/bin}) end end context 'custom ownership and mode for backupdir' do let(:params) do { :backupdirmode => '0750', :backupdirowner => 'testuser', :backupdirgroup => 'testgrp', }.merge(default_params) end it { is_expected.to contain_file('mysqlbackupdir').with( :path => '/tmp', :ensure => 'directory', :mode => '0750', :owner => 'testuser', :group => 'testgrp' ) } end context 'with compression disabled' do let(:params) do { :backupcompress => false }.merge(default_params) end it { is_expected.to contain_file('mysqlbackup.sh').with( :path => '/usr/local/sbin/mysqlbackup.sh', :ensure => 'present' ) } it 'should be able to disable compression' do is_expected.to contain_file('mysqlbackup.sh').without_content( /.*bzcat -zc.*/ ) end end context 'with mysql.events backedup' do let(:params) do { :ignore_events => false }.merge(default_params) end it { is_expected.to contain_file('mysqlbackup.sh').with( :path => '/usr/local/sbin/mysqlbackup.sh', :ensure => 'present' ) } it 'should be able to backup events table' do is_expected.to contain_file('mysqlbackup.sh').with_content( /EVENTS="--events"/ ) end end context 'with database list specified' do let(:params) do { :backupdatabases => ['mysql'] }.merge(default_params) end it { is_expected.to contain_file('mysqlbackup.sh').with( :path => '/usr/local/sbin/mysqlbackup.sh', :ensure => 'present' ) } it 'should have a backup file for each database' do is_expected.to contain_file('mysqlbackup.sh').with_content( /mysql | bzcat -zc \${DIR}\\\${PREFIX}mysql_`date'/ ) end end context 'with file per database' do let(:params) do default_params.merge({ :file_per_database => true }) end it 'should loop through backup all databases' do is_expected.to contain_file('mysqlbackup.sh').with_content(/.*SHOW DATABASES.*/) end context 'with compression disabled' do let(:params) do default_params.merge({ :file_per_database => true, :backupcompress => false }) end it 'should loop through backup all databases without compression' do is_expected.to contain_file('mysqlbackup.sh').with_content( /.*SHOW DATABASES.*/ ) is_expected.to contain_file('mysqlbackup.sh').without_content( /.*bzcat -zc.*/ ) end end end context 'with postscript' do let(:params) do default_params.merge({ :postscript => 'rsync -a /tmp backup01.local-lan:' }) end it 'should be add postscript' do is_expected.to contain_file('mysqlbackup.sh').with_content( /rsync -a \/tmp backup01.local-lan:/ ) end end context 'with postscripts' do let(:params) do default_params.merge({ :postscript => [ 'rsync -a /tmp backup01.local-lan:', 'rsync -a /tmp backup02.local-lan:', ]}) end it 'should be add postscript' do is_expected.to contain_file('mysqlbackup.sh').with_content( /.*rsync -a \/tmp backup01.local-lan:\n\nrsync -a \/tmp backup02.local-lan:.*/ ) end end end end end end