Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-8950

puppet-mysql : includedir not applying correctly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: mysql
    • Labels:
    • Template:
      MODULES Bug Template
    • Epic Link:
    • Team:
      Modules
    • Method Found:
      Needs Assessment
    • QA Risk Assessment:
      Needs Assessment

      Description

      Basic Info
      Module Version: 8.0.0
      Puppet Version: 5.5.6
      OS Name/Version: CentOS 7

      my.cnf does not have the includedir when it should, or if it shouldn't, isn't working as intended

       

      Desired Behavior:

      my.cnf to correctly add includedir or variables to work correctly from /etc/my.cnf.d/server.cnf

       

      Actual Behavior:

      Using MySQL community edition with this module, only certain variables are being picked up. In we have the below, things like "require_secure_transport = on" appear to be applying however other variables such as the ssl keys and the bind-address do not, the only way to do this is manually adding "!includedir /etc/my.cnf.d/" to /etc/my.cnf which doesn't appear to be getting managed by puppet, adding this works fine.

      [mysqld]
      basedir = /usr
      bind-address = 127.0.0.1
      datadir = /var/lib/mysql
      expire_logs_days = 10
      key_buffer_size = 16M
      log-error = /var/log/mysqld.log
      max_allowed_packet = 1073741824
      max_binlog_size = 100M
      max_connections = 151
      pid-file = /var/run/mariadb/mariadb.pid
      port = 3306
      require_secure_transport = on
      skip-external-locking
      socket = /var/lib/mysql/mysql.sock
      ssl = true
      ssl-ca = /etc/mysql/cacert.pem
      ssl-cert = /etc/mysql/server-cert.pem
      ssl-key = /etc/mysql/server-key.pem
      thread_cache_size = 8
      thread_stack = 256K
      tmpdir = /tmp
      user = mysql

      classes:

      • mysql::server
      • accounts
      • sudo
        yumrepo:
        'repo.mysql.com':
        baseurl: "http://repo.mysql.com/yum/mysql-5.7-community/el/%{::operatingsystemmajrelease}/$basearch/"
        descr: 'repo.mysql.com'
        enabled: 1
        gpgcheck: true
        gpgkey: 'http://repo.mysql.com/RPM-GPG-KEY-mysql'

      mysql::client::package_name: "mysql-community-client" # required for proper MySQL installation
      mysql::server::package_name: "mysql-community-server"
      mysql::server::manage_config_file: true
      mysql::server::service_name: 'mysqld'
      mysql::server::root_password: "%{hiera('looker_sql_root')}"
      mysql::server::remove_default_accounts: 'true'
      mysql::server::override_options:
      'mysqld':
      'bind-address': '127.0.0.1'
      'log-error': '/var/log/mysqld.log'
      'max_allowed_packet': '1073741824'
      'require_secure_transport': 'on'
      'ssl': 'true'
      'mysqld_safe':
      'log-error': '/var/log/mysqld.log'

      resource_tree::apply:

      • looker-sql
      • dbusers
      • dbsudo
      • lookerusers
      • lookersudo

      resource_tree::collections:
      'looker-sql':
      yumrepo:
      'repo.mysql.com':
      baseurl: "http://repo.mysql.com/yum/mysql-5.7-community/el/%{::operatingsystemmajrelease}/$basearch/"
      descr: 'repo.mysql.com'
      enabled: 1
      gpgcheck: true
      gpgkey: 'http://repo.mysql.com/RPM-GPG-KEY-mysql'
      mysql::db:
      'looker':
      user: 'looker'
      password: "%{hiera('looker_sql_user')}"
      grant: ['ALL']
      host: "%{hiera('looker')}"
      'looker_tmp':
      user: 'looker_temp'
      password: "%{hiera('looker_tmp_sql_user')}"
      grant: ['ALL']
      host: "%{hiera('looker')}"

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            dan2223 Dan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Zendesk Support