annotate modules/mysql/examples/mysql_db.pp @ 443:c6c9a2cfcfbd

Update MySQL module Fixes a problem with MariaDB and blank certificate paths
author IBBoard <dev@ibboard.co.uk>
date Mon, 08 May 2023 11:48:41 +0100
parents 668df4711671
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
26
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
1 class { 'mysql::server':
389
668df4711671 Update MySQL modules
IBBoard <dev@ibboard.co.uk>
parents: 26
diff changeset
2 root_password => 'password',
26
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
3 }
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
4 mysql::db { 'mydb':
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
5 user => 'myuser',
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
6 password => 'mypass',
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
7 host => 'localhost',
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
8 grant => ['SELECT', 'UPDATE'],
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
9 }
443
c6c9a2cfcfbd Update MySQL module
IBBoard <dev@ibboard.co.uk>
parents: 389
diff changeset
10 mysql::db { "mydb_${facts['networking']['fqdn']}":
26
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
11 user => 'myuser',
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
12 password => 'mypass',
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
13 dbname => 'mydb',
443
c6c9a2cfcfbd Update MySQL module
IBBoard <dev@ibboard.co.uk>
parents: 389
diff changeset
14 host => $facts['networking']['fqdn'],
26
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
15 grant => ['SELECT', 'UPDATE'],
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
16 tag => $domain,
58d1818c2ded Update MySQL module (which adds "staging" module)
IBBoard <dev@ibboard.co.uk>
parents:
diff changeset
17 }