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
46
47
48
|
# File 'manifests/db/ns.pp', line 1
class dmlite::db::ns ($flavor , $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 { "${flavor} mysql commentcreate":
ensure => present,
match => 'CREATE DATABASE.*',
line => '-- CREATE DATABASE.*',
path => '/usr/share/dmlite/dbscripts/cns_mysql_db.sql'
}
# the packaged db script hardcode the db name, we don't want that
file_line { 'cns mysql commentuse':
ensure => present,
match => 'USE cns_db.*',
line => '-- USE cns_db',
path => '/usr/share/dmlite/dbscripts/cns_mysql_db.sql'
}
#workaroundworkaround for missing / db creation
file_line { 'workaround for missing / db creation':
ensure => present,
line => "insert into Cns_file_metadata values(1, 1, 0, NULL, '/', 16877, 0, 0, 0, 0,UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 0, '-','','','','{}'); insert into Cns_unique_id values(1);",
path => '/usr/share/dmlite/dbscripts/cns_mysql_db.sql'
}
mysql::db { $dbname:
user => $dbuser,
password => $dbpass,
host => $dbhost,
sql => '/usr/share/dmlite/dbscripts/cns_mysql_db.sql',
require => [File_line["${flavor} mysql commentcreate"],File_line['workaround for missing / db creation']]
}
if $dbhost != 'localhost' and $dbhost != $::fqdn {
#create the database grants for the user
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}"], ],
}
}
}
|