Files
Takashi Kajinami 1ed8e5b866 Ubuntu: Use utf8mb3_general_ci collate in MySQL
Currently idempotency in Ubuntu is broken because of the below change
detected in collate in MySQL.

```
/Stage[main]/Keystone::Db::Mysql/Openstacklib::Db::Mysql[keystone]/
Mysql_database[keystone]/collate: collate changed 'utf8mb3_general_ci'
to 'utf8_general_ci'
```

Similarly to what we observed in the past about charset[1], it seems
MySQL in Ubuntu is automatically converting the collate value and that
is causing the "unexpected" change detected in the 2nd puppet run.

This fixes the idempotency by using utf8mb3_general_ci in Ubuntu to
avoid the mismatch caused by internal translation.

[1] 085d356902

Conflicts:
	manifests/ironic.pp

(yoga to xena)
Conflicts:
	manifests/octavia.pp

(xena to wallaby)
Backport note:
This change also covers Panko which was retired during Xena cycle.

Change-Id: I56f31397669d3d7b08aa2e9808947141e003ab0b
(cherry picked from commit 9c2d58221c)
(cherry picked from commit b8ad2df96a)
(cherry picked from commit 8bf381e97b)
2022-08-15 23:03:42 +09:00

68 lines
2.3 KiB
Puppet

class openstack_integration::panko {
include openstack_integration::config
include openstack_integration::params
if $::openstack_integration::config::ssl {
openstack_integration::ssl_key { 'panko':
notify => Service['httpd'],
require => Package['panko'],
}
Exec['update-ca-certificates'] ~> Service['httpd']
}
class { 'panko::logging':
debug => true,
}
include panko
class { 'panko::db':
database_connection => 'mysql+pymysql://panko:panko@127.0.0.1/panko?charset=utf8',
}
class { 'panko::db::mysql':
charset => $::openstack_integration::params::mysql_charset,
collate => $::openstack_integration::params::mysql_collate,
password => 'panko',
}
class { 'panko::keystone::auth':
public_url => "${::openstack_integration::config::base_url}:8977",
internal_url => "${::openstack_integration::config::base_url}:8977",
admin_url => "${::openstack_integration::config::base_url}:8977",
password => 'a_big_secret',
}
class { 'panko::keystone::authtoken':
password => 'a_big_secret',
user_domain_name => 'Default',
project_domain_name => 'Default',
auth_url => $::openstack_integration::config::keystone_admin_uri,
www_authenticate_uri => $::openstack_integration::config::keystone_auth_uri,
memcached_servers => $::openstack_integration::config::memcached_servers,
}
class { 'panko::api':
sync_db => true,
enabled => true,
service_name => 'httpd',
}
# NOTE(tobias-urdin): The panko-api package in Ubuntu installs the apache vhosts which we
# not need but we keep them as empty to not break package upgrades.
if ($::operatingsystem == 'Ubuntu') and (versioncmp($::operatingsystemmajrelease, '18') >= 0) {
ensure_resource('file', '/etc/apache2/sites-available/panko-api.conf', {
'ensure' => 'present',
'content' => '',
})
Package['panko-api'] -> File['/etc/apache2/sites-available/panko-api.conf'] ~> Anchor['panko::install::end']
}
include apache
class { 'panko::wsgi::apache':
bind_host => $::openstack_integration::config::ip_for_url,
ssl => $::openstack_integration::config::ssl,
ssl_key => "/etc/panko/ssl/private/${::fqdn}.pem",
ssl_cert => $::openstack_integration::params::cert_path,
workers => 2,
}
}