1
2
3
4
5
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
|
# File 'manifests/db/dpm.pp', line 1
class dmlite::db::dpm ($dbname, $dbuser, $dbpass, $dbhost) inherits dmlite::db::params {
include 'mysql::client'
# the packaged db script explicitly creates the db, we don't want that
file_line { 'dpm mysql commentcreate':
ensure => present,
match => 'CREATE DATABASE.*',
line => '-- CREATE DATABASE.*',
path => '/usr/share/dmlite/dbscripts/dpm_mysql_db.sql'
}
# the packaged db script hardcode the db name, we don't want that
file_line { 'dpm mysql commentuse':
ensure => present,
match => 'USE dpm_db.*',
line => '-- USE dpm_db',
path => '/usr/share/dmlite/dbscripts/dpm_mysql_db.sql'
}
mysql::db { $dbname:
user => $dbuser,
password => $dbpass,
host => $dbhost,
sql => '/usr/share/dmlite/dbscripts/dpm_mysql_db.sql',
require => File_line['dpm mysql commentcreate']
}
if $dbhost != 'localhost' and $dbhost != $::fqdn {
#create the DB user and the grants
mysql_user { "${dbuser}@${::fqdn}":
ensure => present,
password_hash => mysql_password($dbpass),
provider => 'mysql',
}
mysql_grant { "${dbuser}@${::fqdn}/${dbname}.*":
ensure => 'present',
options => ['GRANT'],
privileges => ['ALL'],
provider => 'mysql',
user => "${dbuser}@${::fqdn}",
table => "${dbname}.*",
require => [Mysql_database[$dbname], Mysql_user["${dbuser}@${::fqdn}"], ],
}
}
}
|