https://www.puppet.com/community logo
Join Slack
Powered by
# puppet
  • u

    Ugo Bellavance

    05/13/2022, 8:09 PM
    Oh!
  • l

    Lumiere

    05/13/2022, 8:09 PM
    yaml is extremely whitespace sensitive
  • u

    Ugo Bellavance

    05/13/2022, 8:10 PM
    But
    mariadb::server::purge_conf_dir
    should be OK, right?
  • l

    Lumiere

    05/13/2022, 8:10 PM
    yea, that looks sane
  • u

    Ugo Bellavance

    05/13/2022, 8:10 PM
    The
    mariadb::server::override_options :
    looks bad as well, right?
  • u

    Ugo Bellavance

    05/13/2022, 8:11 PM
    Is there a binary in Linux to lint yaml files on the CLI?
  • y

    Yorokobi

    05/13/2022, 8:11 PM
    yamllint
    👍 1
  • u

    Ugo Bellavance

    05/13/2022, 8:15 PM
    message has been deleted
  • n

    natemccurdy

    05/13/2022, 8:16 PM
    @Ugo Bellavance There are some empty values there for
    bind-address
    and
    log_output
    . Not sure what you want those to be, so I just set them as
    ~
    (which is the null character in YAML). But here’s how that YAML should look.
    Untitled.txt
  • u

    Ugo Bellavance

    05/13/2022, 8:17 PM
    Yes, this was a paste error
  • u

    Ugo Bellavance

    05/13/2022, 8:17 PM
    Copy code
    Path "/etc/puppetlabs/code/environments/production/data/role/mariadb.yaml"
            Original path: "role/%{facts.atq.role}.yaml"
            Found key: "mariadb::server::override_options" value: {
              "purge_conf_dir" => true,
              "mysqld" => {
                "binlog_format" => "MIXED",
                "innodb_buffer_pool_size" => "1G",
                "innodb_buffer_pool_instances" => 1,
                "join_buffer_size" => "512K",
                "key_buffer_size" => "256M"
              }
            }
    👍 1
  • u

    Ugo Bellavance

    05/13/2022, 8:19 PM
    Puppet runs without applying the changes, though.
  • u

    Ugo Bellavance

    05/13/2022, 8:20 PM
    But I'm making progress.
  • n

    natemccurdy

    05/13/2022, 8:21 PM
    Next thing I’d check is node classification then. What tells Puppet to apply
    mariadb
    to your node? Is there a
    node
    definition? Maybe that’s not matching?
  • u

    Ugo Bellavance

    05/13/2022, 8:21 PM
    It's a role based on the name.
  • u

    Ugo Bellavance

    05/13/2022, 8:22 PM
    MariaDB is installed and running.
  • l

    Lumiere

    05/13/2022, 8:22 PM
    so, purge_conf_dir shouldn't be a key on override_options
  • l

    Lumiere

    05/13/2022, 8:22 PM
    that parameter is stuff to pass to my.cnf basically
  • u

    Ugo Bellavance

    05/13/2022, 8:23 PM
    Exactly, let me clean it up
  • u

    Ugo Bellavance

    05/13/2022, 8:23 PM
    Copy code
    mariadb::server::manage_repo: true
    mariadb::server::manage_config_file: true
    mariadb::server::purge_conf_dir: true
    mariadb::server::repo_version: '10.6'
    mariadb::backup::mariabackup::backupuser: 'potato'
    
    # MySQL module config options passthru
    mariadb::server::override_options:
      'mysqld':
        binlog_format: MIXED
        innodb_buffer_pool_size: 1G
        innodb_buffer_pool_instances: 1
        #    innodb_log_file_size: 1375M
        join_buffer_size: 512K
        key_buffer_size: 256M
    🥔 1
  • u

    Ugo Bellavance

    05/13/2022, 8:23 PM
    I know that
    mariadb::server::repo_version
    does work.
  • l

    Lumiere

    05/13/2022, 8:25 PM
    https://github.com/puppetlabs/puppetlabs-mysql/blob/main/manifests/server/config.pp this is where the configs get laid down
  • l

    Lumiere

    05/13/2022, 8:25 PM
    https://github.com/puppetlabs/puppetlabs-mysql/blob/main/manifests/server/config.pp this is where the configs get laid down
  • l

    Lumiere

    05/13/2022, 8:26 PM
    and it's called with this https://github.com/puppetlabs/puppetlabs-mysql/blob/main/manifests/server.pp#L135-L144 (which sets the _options key that config uses)
  • l

    Lumiere

    05/13/2022, 8:26 PM
    and it's called with this https://github.com/puppetlabs/puppetlabs-mysql/blob/main/manifests/server.pp#L135-L144 (which sets the _options key that config uses)
  • u

    Ugo Bellavance

    05/13/2022, 8:28 PM
    I use the mariadb module. It says that it uses the mysql module in the background but I can't figure out how and how I should interact with it.
  • l

    Lumiere

    05/13/2022, 8:29 PM
    I was assuming it just passed things through
  • u

    Ugo Bellavance

    05/13/2022, 8:29 PM
    mariadb::server::repo_version
    does work.
  • l

    Lumiere

    05/13/2022, 8:30 PM
    which upstream module are you using?
  • u

    Ugo Bellavance

    05/13/2022, 8:31 PM
    Copy code
    mod 'edestecd/mariadb', '2.1.1'
    mod 'puppetlabs/mysql', '10.3.0'
1...383940...428Latest