Error adding mysql:queries service

Percona Monitoring and Management (PMM) PMM 1.x
1

I get an error every time I try to add the mysql:queries service, after executing with root access this:

pmm-admin add mysql:queries --user mysqluser --password mysqlpassword --query-source perfschema

I get this error:

Error adding MySQL queries: PUT http://username:password@serverIP/qan-api/instances/88f67174438f82f821b55b879de1355966d: API returned HTTP status code 409, expected 204

pmm-admin check-network shows everything ok

The linux:metrics and mysql:metrics services work fine. I’m running MySQL 5.7.20 on a Ubuntu 16.04 server. pmm-client and server version 1.6

Any help would be greatly appreciated

2

Are U sure that port 80 from the agent server to the PMM server is is open?

telnet serverIP 80

shows what?

Also I successfully have used since I have multiple servers being monitored.

pmm-admin add mysql:metrics SERVICENAME --user pmm_admin --password PASSWORD --host serverIP
pmm-admin add mysql:queries SERVICENAME --query-source perfschema --user pmm_admin --password PASSWORD --host serverIP

pmm_admin was created manually by me as I do not have root on the agent server and so just created a service account.

In MySQL:

CREATE USER IF NOT EXISTS ‘pmm_admin’@‘%’ IDENTIFIED BY ‘PASSWORD’ PASSWORD EXPIRE NEVER ;
GRANT ALL PRIVILEGES ON . TO ‘pmm_admin’@‘%’ WITH GRANT OPTION;
EXIT;

Good Luck