For security reasons, I would like to know where exactly monitoring user passwords are stored into PMM2 while adding a remote DB instance please.
I am talking about the user which connects to the DB instance to enable monitoring metrics collection.
For example I know that in case that I add a new DB instance via the PMM client, this password can be stored in a file with restraint access which will be called during the" pmm-admin add" command using “@/home/pmm/.access-mysql.conf”.
But what about remote monitoring?
Thanks in advance.
There is a PostgreSQL database inside the PMM server that houses the vast majority of configuration data including credential information. This is both for local (agent-based) monitoring AND remote (agent-less) monitoring.
So all these credentials are centralized in the Postgres database, is this correct ?
Are they in plaintext or encrypted in the database ?
Thanks in advance !