taurus-forever
commented
1 year ago Dear @Basdbruijne , tnx for trying our operator! The README was a way outdated, new PR created to address it. Meanwhile, check README in PR.
The charm documentation is something we are working this sprint, please pay your attention to the tutorial in docs folder (also it is being actively updated on discourse).
TL;DR please try the following on your side (note db-router relational there):
juju deploy mysql --channel edge
juju deploy mysql-router --series focal
juju deploy keystone --series focal
juju relate mysql-router keystone
juju relate mysql:db-router mysql-router:db-routerit does the job for me:
Model Controller Cloud/Region Version SLA Timestamp
default localhost-localhost localhost/localhost 2.9.38 unsupported 15:32:09+01:00
App Version Status Scale Charm Channel Rev Exposed Message
keystone 17.0.1 active 1 keystone stable 539 no Application Ready
mysql 8.0.32-0ubun... active 1 mysql edge 111 no Unit is ready: Mode: RW
mysql-router 8.0.32 active 1 mysql-router 8.0/stable 35 no Unit is ready
Unit Workload Agent Machine Public address Ports Message
keystone/0* active idle 1 10.158.123.127 5000/tcp Unit is ready
mysql-router/0* active idle 10.158.123.127 Unit is ready
mysql/0* active idle 0 10.158.123.115 Unit is ready: Mode: RW
Machine State Address Inst id Series AZ Message
0 started 10.158.123.115 juju-5ae2d0-0 jammy Running
1 started 10.158.123.127 juju-5ae2d0-1 focal RunningYour example also worked on my side:
Model Controller Cloud/Region Version SLA Timestamp
default localhost-localhost localhost/localhost 2.9.38 unsupported 17:57:07+01:00
App Version Status Scale Charm Channel Rev Exposed Message
keystone 21.0.0 active 1 keystone yoga/stable 595 no Application Ready
keystone-mysql-router 8.0.32 active 1 mysql-router 8.0/stable 35 no Unit is ready
mysql 8.0.32-0ubun... active 1 mysql edge 111 no Unit is ready: Mode: RW
Unit Workload Agent Machine Public address Ports Message
keystone/0* active idle 0 10.158.123.90 5000/tcp Unit is ready
keystone-mysql-router/0* active idle 10.158.123.90 Unit is ready
mysql/0* active idle 1 10.158.123.243 Unit is ready: Mode: RW
Machine State Address Inst id Series AZ Message
0 started 10.158.123.90 juju-412c71-0 jammy Running
1 started 10.158.123.243 juju-412c71-1 jammy Running
Relation provider Requirer Interface Type Message
keystone-mysql-router:shared-db keystone:shared-db mysql-shared subordinate
keystone:cluster keystone:cluster keystone-ha peer
mysql:database-peers mysql:database-peers mysql-peers peer
mysql:db-router keystone-mysql-router:db-router mysql-router regular
mysql:restart mysql:restart rolling_op peer
Is it still reproducible on your side? I see slightly different versions for charms. Tnx!
Sponge-Bas
paulomach
I'm trying to use the mysql charm instead of the mysql-innodb-cluster charm for an OpenStack deployment, but I'm running into a couple of issues:
Steps to reproduce
Following the examples from https://charmhub.io/mysql:
The docs suggest:
I ran:
I assume that this is because there is still some work to do to make keystone compatible with the mysql charm.
Then I tried one of the
legacy relations. I ran:Expected behavior
I would expect mysql to set up the database and allow keystone to connect to it.
Actual behavior
The deployment went into the following status:
Versions
see above
Log output
juju debug-log --replay
```shell Traceback (most recent call last): File "/var/lib/juju/agents/unit-mysql-0/charm/src/mysql_vm_helpers.py", line 187, in _run_mysqlsh_script return subprocess.check_output( File "/usr/lib/python3.10/subprocess.py", line 420, in check_output return run(*popenargs, stdout=PIPE, timeout=timeout, check=True, File "/usr/lib/python3.10/subprocess.py", line 524, in run raise CalledProcessError(retcode, process.args, subprocess.CalledProcessError: Command '['/snap/bin/mysqlsh', '--no-wizard', '--python', '-f', '/root/snap/mysql-shell/common/tmp_r6gwjds']' returned non-zero exit status 1. During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/var/lib/juju/agents/unit-mysql-0/charm/lib/charms/mysql/v0/mysql.py", line 966, in get_cluster_primary_address output = self._run_mysqlsh_script("\n".join(get_cluster_primary_commands)) File "/var/lib/juju/agents/unit-mysql-0/charm/src/mysql_vm_helpers.py", line 191, in _run_mysqlsh_script raise MySQLClientError(e.stderr) charms.mysql.v0.mysql.MySQLClientError: b'Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nTraceback (most recent call last):\n File "