view modules/website/manifests/mysql.pp @ 1:f9876f71f1a3

Bump the number of server processes - the server seems to cope, and a South Korean forum's hotlinking was flooding us
author IBBoard <dev@ibboard.co.uk>
date Mon, 18 Aug 2014 18:57:52 +0000
parents 956e484adc12
children b0a6f4b93e10
line wrap: on
line source

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
  }
}