MySQL Router not yet bootstrapped + Access denied for user 'mysqlrouteruser@ip'

juju
1

Sorry for bothering you so much. But I have a lot of issues and can’t solve.
I am deploying openstack with openstack base charm.
I met a lot of error on units. Almost It caused by Mysql Router not yet bootstrapped. When I ssh into lxd , it showed me error

2020-06-09 20:17:15 ERROR juju-log Failed to bootstrap mysqlrouter: Error: Unable to connect to the metadata server: Error connecting to MySQL server at 192.168.28.25:0: Access denied for user ‘mysqlrouteruser’@‘192.168.28.11’ (using password: YES) (1045)

This is my juju status: Ubuntu Pastebin

I searched and it looks like a old bug : Bug #1861234 “The documented miniumum grants for bootstrap are i...” : Bugs : charm-mysql-router . It have a workaround like add a GRANT to mysql_innodb_cluster_metadata
But I have no password + username to login into Innodb Cluster .

Please have a look and help me how to troubleshoot this case.
Thanks,
Kien

2

It looks like the juju detected wrong the ip address, mis between 230.x vs 28.x
I found password and can login into mysql. It showed permission on 230.x

‘mysqlrouteruser’@‘192.168.230.3’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.1’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.10’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.11’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.12’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.13’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.14’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.15’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.16’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.17’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.18’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.2’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.20’ | def | CREATE USER | YES |
| ‘mysqlrouteruser’@‘192.168.230.21’ | def | CREATE USER | YES |

I will try to modify bundle.yaml to public space (230.x) and internal space(28.x) to the same subnet.