It is likely that we will encounter an error similar to Error connecting to database history at 172.21.0.130 when viewing a module graph in Metaconsole.
This is due to the fact that the machine of our meta console does not have privileges over the history DB of a node (or several).
To give privileges to the Metaconsole we have to apply the necessary grants, that I will indicate with a practical example:
- Metaconsole: 172.21.0.10
- Historical DB: 172.21.0.130
- DB name: history
In the history machine:
[root@historic ~]# mysql -u root -p history <mysql> grant all privileges on 'history`.* to 'pandora_history'@'172.21.0.10' identified by 'password';
It is important to know that the Metaconsole to connect to the historical DB uses the user, host, password and the DB name configured in the menu Setup -> Historical database of the NODE, so in the grant you have to indicate the same parameters.