Proxysql_exporter error in scraping runtime mysql servers

Percona Monitoring and Management (PMM)
1

I have deployed pmm-client as a sidecar to the proxysql container. As per the documentation ProxySQL - Percona Monitoring and Management we should use admin-stats_credentials to configure read only user for monitoring process.

I am seeing the below error in the pmm-client container
ERRO[2024-11-23T04:08:41.737+00:00] ts=2024-11-23T04:08:41.737Z caller=exporter.go:202 level=error msg="Error scraping for collect.runtime_mysql_servers" agentID=/agent_id/81ed89ee-fa5e-4179-8ebc-f5b0ead063c4 component=agent-process type=proxysql_exporter

Upon going through the code of proxysql_exporter proxysql_exporter/exporter.go at main · percona/proxysql_exporter · GitHub it is querying the runtime_mysql_servers to which it doesn’t have access as per the documentation Admin Variables - ProxySQL

Do we need to use admin user with RW permissions? or should we provide additional privileges to the user defined in admin-stats_credentials

2

Hello @Animesh_Agarwal,
That’s a flat out bug. Please report it https://jira.percona.com/ I confirm that our docs say to use the admin-stats_credential but ProxySQL says that account cannot read any configuration tables. This is probably an oversight in our documentation.