Puppet Class: mysql::password

Defined in:
manifests/password.pp

Overview

Class: mysql::password

Set mysql password



6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
 
# File 'manifests/password.pp', line 6

class mysql::password {

  # Load the variables used in this module. Check the params.pp file
  include mysql
  include mysql::params

  if ! defined(File['/root/.my.cnf']) {
    file { '/root/.my.cnf':
      ensure  => 'present',
      path    => '/root/.my.cnf',
      mode    => '0400',
      owner   => $mysql::config_file_owner,
      group   => $mysql::config_file_group,
      content => template($mysql::root_cnf_template),
      # replace => false,
      # require => Exec['mysql_root_password'],
    }
  }

  file { '/root/.my.cnf.backup':
    ensure  => 'present',
    path    => '/root/.my.cnf.backup',
    mode    => '0400',
    owner   => $mysql::config_file_owner,
    group   => $mysql::config_file_group,
    content => template('mysql/root.my.cnf.backup.erb'),
    replace => false,
    before  => [Exec['mysql_root_password'],
                Exec['mysql_backup_root_my_cnf'] ],
  }

  exec { 'mysql_backup_root_my_cnf':
    require => Service['mysql'],
    path    => '/bin:/sbin:/usr/bin:/usr/sbin',
    unless  => 'diff /root/.my.cnf /root/.my.cnf.backup',
    command => 'cp /root/.my.cnf /root/.my.cnf.backup ; true',
    before  => File['/root/.my.cnf'],
  }


  exec { 'mysql_root_password':
    subscribe   => File['/root/.my.cnf'],
    require     => Service['mysql'],
    path        => '/bin:/sbin:/usr/bin:/usr/sbin',
    refreshonly => true,
    command     => "mysqladmin --defaults-file=/root/.my.cnf.backup -uroot password '${mysql::real_root_password}'",
  }

}