Mercurial > repos > other > Puppet
view modules/mysql/examples/monitor.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 |
line wrap: on
line source
# @summary # Add a monitoring user to the database $mysql_monitor_password = 'password' $mysql_monitor_username = 'monitoring' $mysql_monitor_hostname = $facts['networking']['hostname'] mysql_user { "${mysql_monitor_username}@${mysql_monitor_hostname}": ensure => present, password_hash => mysql::password($mysql_monitor_password), require => Class['mysql::server::service'], } mysql_grant { "${mysql_monitor_username}@${mysql_monitor_hostname}/*.*": ensure => present, user => "${mysql_monitor_username}@${mysql_monitor_hostname}", table => '*.*', privileges => ['PROCESS', 'SUPER'], require => Mysql_user["${mysql_monitor_username}@${mysql_monitor_hostname}"], }