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
Are U sure that port 80 from the agent server to the PMM server is is open?
telnet serverIP 80
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.
CREATE USER IF NOT EXISTS ‘pmm_admin’@‘%’ IDENTIFIED BY ‘PASSWORD’ PASSWORD EXPIRE NEVER ;
GRANT ALL PRIVILEGES ON . TO ‘pmm_admin’@‘%’ WITH GRANT OPTION;