Closed xchotard-talentsoft closed 1 year ago
class { 'apache': mpm_module => 'prefork', } class { 'apache::mod::php': } class { 'mysql::server': } class { 'zabbix': zabbix_url => 'zabbix.example.com', database_type => 'mysql', }
At each Puppet agent execution, the following changes are reported:
Notice: /Stage[main]/Zabbix::Database/Mysql::Db[zabbix_server]/Mysql_database[zabbix_server]/charset: charset changed 'utf8mb3' to 'utf8' (corrective) Notice: /Stage[main]/Zabbix::Database/Mysql::Db[zabbix_server]/Mysql_database[zabbix_server]/collate: collate changed 'utf8mb3_bin' to 'utf8_bin' (corrective)
The charset/collate changes should not be corrected at each run.
This issue is very similar to: https://tickets.puppetlabs.com/browse/IAC-1612
As a workaround, it is possible to replace utf8 by utf8mb4 and utf8_bin by utf8mb4_unicode_ci in manifests/params.pp:
utf8
utf8mb4
utf8_bin
utf8mb4_unicode_ci
manifests/params.pp
- $server_database_charset = 'utf8' - $server_database_collate = 'utf8_bin' + $server_database_charset = 'utf8mb4' + $server_database_collate = 'utf8mb4_unicode_ci'
Being able to pass charset and collate parameters to the zabbix::server and zabbix::proxy classes would also be a nice addition.
charset
collate
zabbix::server
zabbix::proxy
This behavior depends on MySQL-Server version.
Can we get a 9.2.1 release for this fix 🙏
Affected Puppet, Ruby, OS and module versions/distributions
How to reproduce (e.g Puppet code you use)
What are you seeing
At each Puppet agent execution, the following changes are reported:
What behaviour did you expect instead
The charset/collate changes should not be corrected at each run.
Output log
Any additional information you'd like to impart
This issue is very similar to: https://tickets.puppetlabs.com/browse/IAC-1612
As a workaround, it is possible to replace
utf8
byutf8mb4
andutf8_bin
byutf8mb4_unicode_ci
inmanifests/params.pp
:Being able to pass
charset
andcollate
parameters to thezabbix::server
andzabbix::proxy
classes would also be a nice addition.This behavior depends on MySQL-Server version.