puppetlabs / puppetlabs-mysql

MySQL Puppet Module / Manifests + Types & Providers
Apache License 2.0
380 stars 790 forks source link

Debian 12 Bookworm Support #1599

Open bk-lg opened 10 months ago

bk-lg commented 10 months ago

Use Case

I want to manage mysql instances on debian bookworm based machines.

Describe the Solution You Would Like

Testing if current state of module is compatible with debian 12 and if not identifying these and document them in separate issues to work in resolving them.

Describe Alternatives You've Considered

Staying on debian 11 but our organisation plans to move to debian 12 in the next months.

bk-lg commented 10 months ago

I created this issues as first step to document the process of upgrading the module and to ask if allready someone works on this topic and could need a helping hand.

kajinamit commented 9 months ago

jfyi:

I retently attempted basic installation in Debian 12 using v15.0.0. It worked mostly smooth but I had to add a resource to create the log directory

    file { '/var/log/mysql':
      ensure  => directory,
      owner   => 'mysql',
      mode    => '0755',
      require => Package['mysql-server']
    }

I've not yet looked into this in detail but I guess the log directory should be changed. Leaving this note just in case this could help people who may actually tackle this...

lbetz commented 6 months ago

The current MariaDB logs to syslog by default so set:

mysql::server::override_options:
  mysqld:
    log-error: ~

This disables the logging to file and the requirement and management of an existing directory /var/log/mysql.