Thursday, 2024-01-11

opendevreviewOpenStack Proposal Bot proposed openstack/puppet-openstack-integration master: Updated from Puppet OpenStack modules constraints  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90516903:02
amoraleji'm hitting a problem with p-o-i jobs related to mariadb that i suspect may affect you here10:11
amoralejapparently, we are configuring some certificates in mysqld config which does not exist, in the past that was a warning but now it's an error10:16
amoralejmmm but ssl is false10:17
amoralejyep, latest mariadb update changed behavior10:20
amoralejbefore, if it could not configure ssl when certificates were configured in config file, it simply gave a warning and continued without ssl, now it fails to start10:21
amoralejand ssl = false parameter is ignored10:21
amoralejwe need to remove the ssl parameters from config file10:21
amoralejreported in upstream release notes https://mariadb.com/kb/en/mariadb-10-5-18-release-notes/#ssl10:23
amoralejtkajinam ^ probably all CS9 jobs will fail, i'm looking where to patch in p-o-i i guess10:24
opendevreviewAlfredo Moralejo proposed openstack/puppet-openstack-integration master: Add ssl certificates to mariadb config only when SSL is enabled  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90529810:49
opendevreviewAlfredo Moralejo proposed openstack/puppet-openstack-integration master: Add ssl certificates to mariadb config only when SSL is enabled  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90529811:14
amoralejah, jobs are passing when ssl is enabled, i'm checking why in rdo jobs ssl is off11:49
opendevreviewTakashi Kajinami proposed openstack/puppet-openstack-integration master: Add ssl certificates to mariadb config only when SSL is enabled  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90529813:19
tkajinamamoralej, ah, that's a good catch. the change might be something we have to backport to old stable branches. I remember a similar problem seen in ubuntu jobs in old stable branches13:20
tkajinamamoralej, just refactored it a bit but will vote on it once zuul votes the result13:20
amoralejtkajinam, ^ iiuc your patch, that will leave default values from puppet-mysql for cert params right? i think defaults are bad for no-ssl config14:22
amoralejhttps://github.com/puppetlabs/puppetlabs-mysql/blob/main/manifests/params.pp#L94-L9614:23
amoralejdon't we need to explicitely undefine ?14:23
amoralejactually, in old releases, as xena, wich didn't support ssl in mysql it's failing with default values https://github.com/openstack/puppet-openstack-integration/blob/stable/xena/manifests/mysql.pp14:26
tkajinamamoralej, ugh, you are correct, I think14:31
amoraleji'm sending a patch to zed with appropiate patch for non-ssl case14:31
opendevreviewAlfredo Moralejo proposed openstack/puppet-openstack-integration stable/zed: Undefine ssl certificate parameters for mariadb  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90531114:32
amoralejthat ^14:32
opendevreviewTakashi Kajinami proposed openstack/puppet-openstack-integration master: Add ssl certificates to mariadb config only when SSL is enabled  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90529814:33
opendevreviewTakashi Kajinami proposed openstack/puppet-openstack-integration master: Add ssl certificates to mariadb config only when SSL is enabled  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90529814:35
tkajinam^^^ should restore overrides of key/cert files14:36
tkajinamwondering if this needs to be fixed in puppet-mysql as well14:37
amoraleji was wondering the same14:38
tkajinamanyway we can merge that fix now even if the problem is fixed in puppetlabs-mysql14:39
tkajinamthe workaround is required in stable branches where we can't bump puppetlabs-mysql now14:39
amoralejyep14:39
tkajinamwill later check how we can workaround the issue by any change in puppetlabs-mysql. we have to make sure we don't break compatibility with existing usage with only ssl => true overridden14:40
opendevreviewMerged openstack/puppet-openstack-integration stable/2023.2: nova: Capture cell details  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90509315:05
opendevreviewTakashi Kajinami proposed openstack/puppet-openstack-integration stable/zed: Undefine ssl certificate parameters for mariadb  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90531116:19
opendevreviewTakashi Kajinami proposed openstack/puppet-openstack-integration stable/2023.1: nova: Capture cell details  https://review.opendev.org/c/openstack/puppet-openstack-integration/+/90532816:26

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!