diff -r a2342f26c9de -r b0b56e0f8c7f dev/provisioning/modules/sysconfig/manifests/mariadb.pp --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dev/provisioning/modules/sysconfig/manifests/mariadb.pp Fri Jan 15 15:35:00 2016 +0100 @@ -0,0 +1,93 @@ +class sysconfig::mariadb ( + $db_name = hiera('sysconfig::params::db_name', sysconfig::params::db_name), + $db_drpl_name = hiera('sysconfig::params::db_drpl_name', $sysconfig::params::db_drpl_name), + $db_user = hiera('sysconfig::params::db_user', $sysconfig::params::db_user), + $db_pw = hiera('sysconfig::params::db_pw', $sysconfig::params::db_pw), + $db_host = hiera('sysconfig::params::db_host', $sysconfig::params::db_host), + $db_port = hiera('sysconfig::params::db_port', $sysconfig::params::db_port), +) inherits sysconfig::params { + + $mariadb_packages = [ + 'mariadb-server' + ] + + package { $mariadb_packages: + ensure => present, + notify => Service["mariadb"] + } + + service { "mariadb": + ensure => running, + enable => true + } + + augeas { "mariadb_server_cnf/max_allowed_packet": + lens => "MySQL.lns", + incl => "/etc/my.cnf.d/server.cnf", + changes => "set target[.='mysqld']/max_allowed_packet 16M", + notify => Service["mariadb"], + require => Package["mariadb-server"] + } + + augeas { "mariadb_server_cnf/collation-server": + lens => "MySQL.lns", + incl => "/etc/my.cnf.d/server.cnf", + changes => "set target[.='mysqld']/collation-server utf8mb4_general_ci", + notify => Service["mariadb"], + require => Package["mariadb-server"] + } + + augeas { "mariadb_server_cnf/character-set-server": + lens => "MySQL.lns", + incl => "/etc/my.cnf.d/server.cnf", + changes => "set target[.='mysqld']/character-set-server utf8mb4", + notify => Service["mariadb"], + require => Package["mariadb-server"] + } + + augeas { "mariadb_client_cnf/default-character-set": + lens => "MySQL.lns", + incl => "/etc/my.cnf.d/client.cnf", + changes => "set target[.='client']/default-character-set utf8mb4", + notify => Service["mariadb"], + require => Package["mariadb-server"] + } + + augeas { "mariadb_mysql-client_cnf/default-character-set": + lens => "MySQL.lns", + incl => "/etc/my.cnf.d/mysql-clients.cnf", + changes => "set target[.='mysql']/default-character-set utf8mb4", + notify => Service["mariadb"], + require => Package["mariadb-server"] + } + + mysql::db { "drupal_db": + dbname => $db_drpl_name, + user => $db_user, + password => $db_pw, + host => $db_host, + charset => 'utf8mb4', + collate => 'utf8mb4_general_ci', + require => Service["mariadb"], + } + mysql::db { "corpus_db": + dbname => $db_name, + user => $db_user, + password => $db_pw, + host => $db_host, + charset => 'utf8mb4', + collate => 'utf8mb4_general_ci', + require => Service["mariadb"], + } + + #TODO: create user + + #TODO: create databases + + # max_allowed_packetĀ : > 16M -> + # [mysqld] + # collation-server = utf8mb4_general_ci + # character-set-server = utf8mb4 + + +}