I am trying to get PMM (running in Docker container) working with RDS instances.
But QAN is not running there:
Query Analytics API DOWN
When trying to add an instance:
[linux:metrics] OK, already monitoring this system.
[mysql:metrics] OK, already monitoring MySQL metrics.
[mysql:queries] Error adding MySQL queries: problem with agent registration on QAN API: exit status 1
From the log /var/log/qan-api.log:
2018/05/17 14:33:40 config.go:79: Loading /etc/percona-qan-api.conf
2018/05/17 14:33:40 config.go:119: API root dir /usr/share/percona-qan-api/src/github.com/percona/qan-api
2018/05/17 14:33:40 base.go:20: Error 1045: Access denied for user ‘qan-api’@‘localhost’ (using password: YES)
Can anyone please help me with this? I don’t have perf_schema enabled on RDS. Can it be the issue?