Mercurial > repos > other > Puppet

comparison modules/website/manifests/mysql.pp @ 0:956e484adc12

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Initial public release of Puppet configs
author IBBoard <dev@ibboard.co.uk>
date Sat, 16 Aug 2014 19:47:38 +0000
parents
children b0a6f4b93e10
comparison
equal deleted inserted replaced
-1:000000000000 0:956e484adc12
1 class website::mysql (
2 $mysqluser,
3 $mysqlpassword,
4 $mysqlsuffix = '',
5 $phpsuffix = '',
6 $phpmysqlsuffix = '')
7 {
8 class { 'mysql::client':
9 package_name => "mysql${mysqlsuffix}",
10 bindings_enable => false, #Deal with bindings manually
11 }
12 class { 'mysql::bindings':
13 php_enable => true,
14 php_package_name => "php${phpsuffix}-mysql${phpmysqlsuffix}",
15 }
16 class { 'mysql::server':
17 package_name => "mysql${mysqlsuffix}-server",
18 }
19 $username = strip($mysqluser)
20 $password = strip($mysqlpassword)
21 $configured_marker = '/etc/mysql/.is-configured'
22 exec { 'Rename root MySQL user for security':
23 command => "mysql -uroot -e 'UPDATE mysql.user SET User = \"$username\", Password = PASSWORD(\"$password\") WHERE User = \"root\"; DELETE FROM mysql.user WHERE User = ''; FLUSH PRIVILEGES;' && touch $configured_marker",
24 provider => shell,
25 creates => $configured_marker
26 }
27 }