Deployment issues to nodes about galera-manager-support

[dribblecastle]

Thanks for the quick reply @denisgcm. I followed your instructions but it didn't work until I created a mySQL user with 127.0.0.1 instead of localhost. Also, set the permissions according to the previously existing mysqld_exporter:localhost user. See below. The good news is things appear to be working as expected. Looking forward to using this tool as its improves, I just wish I had setup my Galera cluster with it initially so I could use more of the features.

CREATE USER 'mysqld_exporter'@'127.0.0.1'  IDENTIFIED BY 'monitoringpwd';
GRANT SELECT, PROCESS, REPLICATION CLIENT ON *.* TO 'mysqld_exporter'@'127.0.0.1';

[denisgcm]

There is an issue that we should fix. As a temporary workaround I can suggest that you log in to the Galera Manager server via ssh and run gmc cluster list (you will have to enter your Galera Manager admin user and password). You will get a similar output:

user@ip:~$ gmc cluster list
Enter auth name: admin
Enter auth password:
+----+---------+------+--------------+--------------+-------------+---------------+---------------------+------------------+
| ID |  NAME   | UUID |    SYSTEM    |  DB ENGINE   | HOSTS/NODES | ROOT PASSWORD | MONITORING PASSWORD | BACKUP PASSWORD  |
+----+---------+------+--------------+--------------+-------------+---------------+---------------------+------------------+
|  2 | sample  |      | ubuntu:20.04 | mariadb:10.5 | 3/3         | rootpwd       | monitoringpwd       | backupgpwd       |
+----+---------+------+--------------+--------------+-------------+---------------+---------------------+------------------+

Pick your value for monitoringpwd and update the password for the mysqld_exporter user accordingly. After you do that, the stats should start working.

Please let me know if it helped.