This can be recreated doing the following. I'd recommend doing this on a Jammy machine.
1) snap install lxd
2) snap install juju
3) Follow these steps up through the 'juju bootstrap localhost overlord') command: https://juju.is/docs/olm/lxd#heading--set-up-the-localhost-cloud
4) juju deploy ./jammy-yoga.yaml (see file contents below)
5) watch juju status (as soon as you see Agent column say "executing" you can ssh into the corresponding unit and add the security ppa)
6) (optional to add security ppa) add PPA to units - ssh to units as follows and run 'sudo add-apt-repository ppa:ubuntu-security-proposed/ppa --yes'
juju ssh keystone/0
juju ssh mysql-innodb-cluster/0
juju ssh mysql-innodb-cluster/1
juju ssh mysql-innodb-cluster/2
(you'll need to do this fairly quickly as the unit will start installing software soon)
7) The keystone unit is where mysql-router will get installed. /etc/keystone/keystone.conf will have the mysql credentials. /var/log/juju/unit-keystone-0.log will eventually show a Python traceback with a failing command that ends with:
subprocess.CalledProcessError: Command '['sudo', '-u', 'keystone', 'keystone-manage', 'db_sync']' returned non-zero exit status 1."
This can be recreated doing the following. I'd recommend doing this on a Jammy machine.
1) snap install lxd /juju.is/ docs/olm/ lxd#heading- -set-up- the-localhost- cloud security- proposed/ ppa --yes' cluster/ 0 cluster/ 1 cluster/ 2 keystone. conf will have the mysql credentials. /var/log/ juju/unit- keystone- 0.log will eventually show a Python traceback with a failing command that ends with: CalledProcessEr ror: Command '['sudo', '-u', 'keystone', 'keystone-manage', 'db_sync']' returned non-zero exit status 1."
2) snap install juju
3) Follow these steps up through the 'juju bootstrap localhost overlord') command: https:/
4) juju deploy ./jammy-yoga.yaml (see file contents below)
5) watch juju status (as soon as you see Agent column say "executing" you can ssh into the corresponding unit and add the security ppa)
6) (optional to add security ppa) add PPA to units - ssh to units as follows and run 'sudo add-apt-repository ppa:ubuntu-
juju ssh keystone/0
juju ssh mysql-innodb-
juju ssh mysql-innodb-
juju ssh mysql-innodb-
(you'll need to do this fairly quickly as the unit will start installing software soon)
7) The keystone unit is where mysql-router will get installed. /etc/keystone/
subprocess.
$ cat jammy-yoga.yaml
variables:
source: &source proposed
openstack-origin: &openstack-origin distro-proposed
series: &series jammy password: openstack -origin: *openstack-origin mysql-router: innodb- cluster: innodb- cluster mysql-router: db-router cluster: db-router mysql-router: shared- db
applications:
keystone:
charm: ch:keystone
num_units: 1
options:
admin-
openstack
constraints: mem=1024
channel: yoga/edge
keystone-
charm: ch:mysql-router
channel: 8.0/edge
mysql-
charm: ch:mysql-
num_units: 3
constraints: mem=4096
channel: 8.0/edge
relations:
- - keystone-
- mysql-innodb-
- - keystone:shared-db
- keystone-