Puppet Community

See the `edestecd-mariadb` module at <https://forge.puppet.com/edestecd/mariadb?src=slack&amp;channel=puppet>

```mod 'edestecd/mariadb', '2.1.1'
mod 'puppetlabs/mysql', '10.3.0'```

ah, so that doesn't have override_options

but my reading of the code suggests it doesn't actually use it

<https://github.com/edestecd/puppet-mariadb/blob/master/manifests/server/mysql.pp#L31>

it should take the same content via `mariadb::server::options`

it passes that content to mysql's override_options

I think I tried too many things. Cleaning up.l

I think you need to define your repos manually, that made me go with the other one.

the readme has some examples for mariadb :slightly_smiling_face:

Easy for Ubuntu, but I want to install the upstream of MariaDB on RHEL

repo is defined at <https://mariadb.com/kb/en/yum/>, use the yumrepo resoure to define it

It was too simple with the mariadb module :disappointed:

And the mariadb module supports RHEL7 max.  It works on RHEL8, but its development is probably halted.  I have been able to make the my.cnf configs work but I think I'll have to switch to puppetlabs/mysql module.

See the `puppetlabs-mysql` module at <https://forge.puppet.com/puppetlabs/mysql?src=slack&amp;channel=puppet>

if you have any open PRs for thst module let me know and I can review them

Which one? puppetlabs-mysql?  Oh! Puppetlabs now uses Giltab's issues and PRs now?  It was Jira, before, right?

You want me to tag you in a PR if I make one?

yes, if you open a PR you can ping me and I will have a look

Ok, are tests required for a PR? If they are (which is good for code quality) I don't know how to write them :disappointed:.

always depends on the code change. but they should be easy to write, the modules all have good examples that can be copied

that's pretty much the story of learning puppet :smile:

I think there is something wrong in my file

I think I'm lacking a mariadb::server::db somewhere

My manifests contains this:
```  # Create all the named databases
  create_resources('mysql::db', $databases, {})

  # Create all the users and grants
  $users.each |$name, $attrs| {
    mysql_user { $name: * =&gt; $attrs }
  }
  $grants.each |$name, $attrs| {
    mysql_grant { $name: * =&gt; $attrs }
  }```


`/etc/puppetlabs/code/environments/production/site-modules/profile/manifests/mariadb.pp`

Here's the full contents:
```# @summary MariaDB profile
#
# A profile which installs MariaDB
#
# @example
#   classes:
#     - profile::mariadb
#
class profile::mariadb(
  Hash $databases  = {},
  Hash $grants  = {},
  Hash $users  = {},
) {
  # Disabling the modules must come prior to loading mariadb module
  case $facts['os']['release']['major'] {
    '7': {
      # put any LD_LIBRARY_PATH overrides here
    }
    '8': {
      # select the server flavor of the app stream for the given version
      package { ['mysql','mariadb']:
        ensure   =&gt; 'disabled',
        provider =&gt; 'dnfmodule',
        before   =&gt; Class['Mariadb::Server'],
      }
    }
    default: {
      fail('The mariadb profile only supports RedHat 7 &amp; 8')
    }
  }

  # Now load modules
  include atq
  include mariadb::server
  include mariadb::backup::mariabackup

  # Create all the named databases
  create_resources('mysql::db', $databases, {})

  # Create all the users and grants
  $users.each |$name, $attrs| {
    mysql_user { $name: * =&gt; $attrs }
  }
  $grants.each |$name, $attrs| {
    mysql_grant { $name: * =&gt; $attrs }
  }```

Do you have Hiera data for `profile::mariadb::databases`?

Yes, there is in a hiera file named after the node

With this at the top: `mysql::server::manage_config_file: false`

The fun with hiera is that you can have stuff everywhere.  The not fun part of hiera is that you can have stuff everywhere :wink:!

hah, exactly. But that’s what `lookup --explain` can help with

Well well, look at that:
```Notice: /Stage[main]/Mysql::Server::Config/File[mysql-config-file]/content: current_value '{md5}9f46f5d4c45701de990157ef787a21e0', should be '{md5}89457c9e2434f118302bbead301d15db' (noop)```

It looks like the key contains other informations (grants)

If I see this in the logs, what hiera key is it looking for?
```Notice: /Stage[main]/Profile::Mariadb/Mysql::Db```


Thanks a lot everyone.  I'm up to a good start now.

I defined the MariaDB upstream repo so that when the puppetlabs-mysql installs the package it uses the upstream version.  How do I make sure the repo is defined before the module installs the package? Repo is defined in hiera:
```yum::managed_repos:
    - 'mariadb'
yum::repos:
    mariadb:
        ensure: 'present'
        enabled: true
        descr: 'MariaDB Repo'
        baseurl: '<http://yum.mariadb.org/10.6/centos7-amd64>'
        gpgcheck: true
        gpgkey: '<https://yum.mariadb.org/RPM-GPG-KEY-MariaDB>'
        target: '/etc/yum.repos.d/mariadb-org.repo'```

What do you guys use to develop Puppet code? I use vim and VMWare snapshots to revert when needed

I use PDK, VS Code (with a heap of extensions) &amp; Git.

Inhabe tonuse vscode in one environment and I really hate it because its not really possiblento embed additional linter plugins into the puppet language server. Usually I use vim + plugins

Ok and how do you revert your changes when you break the os beyond repair?

if its while I am at work, yes I use vmware and snapshots. If its outside of work which I do some for also, then I have terraform and Azure