Ticket ID #204 ‐ Apply Puppet Module for MariaDB on DB Server - GriffinKat/group-a GitHub Wiki

Apply Puppet Module for MariaDB on DB Server

  • To apply the module to a node, include the mariadb class in the node definition for your database server.
  node ’db-x.oe2.org.nz’ {
  include mariadb
  }

Edit the site.pp file in /etc/puppetlabs/code/environments/production/manifests$

image

  • Run the following command on the database server to apply the configuration from the Puppet Master.

    sudo /opt/puppetlabs/puppet/bin/puppet agent --server=mgmt-a --no-daemonize --verbose --onetime

    image

Verification

  1. Check the status of the service by running the command.

    sudo systemctl status mysql

    image

  2. Log into the Mariadb server with the default root user and review the logs. Use the following command to login. Enter the group password when prompted for password.

    sudo mysql -u root -p

    image

    Review the logs to check for errors during configuration and installation

    sudo cat /var/log/mysql/error.log

    image