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

Initial public release of Puppet configs
author IBBoard <dev@ibboard.co.uk>
date Sat, 16 Aug 2014 19:47:38 +0000
parents
children b0a6f4b93e10
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/modules/website/manifests/mysql.pp	Sat Aug 16 19:47:38 2014 +0000
@@ -0,0 +1,27 @@
+class website::mysql (
+  $mysqluser,
+  $mysqlpassword,
+  $mysqlsuffix    = '',
+  $phpsuffix      = '',
+  $phpmysqlsuffix = '')
+  {
+  class { 'mysql::client':
+    package_name    => "mysql${mysqlsuffix}",
+    bindings_enable => false, #Deal with bindings manually
+  }
+  class { 'mysql::bindings':
+    php_enable       => true,
+    php_package_name => "php${phpsuffix}-mysql${phpmysqlsuffix}",
+  }
+  class { 'mysql::server':
+    package_name => "mysql${mysqlsuffix}-server",
+  }
+  $username = strip($mysqluser)
+  $password = strip($mysqlpassword)
+  $configured_marker = '/etc/mysql/.is-configured'
+  exec { 'Rename root MySQL user for security':
+    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",
+    provider => shell,
+    creates  => $configured_marker
+  }
+}