Not the answer you need?
Register and ask your own question!

Error adding mysql:queries service

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:[email protected]/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

Comments

  • baaspbaasp Contributor Current User Role Novice
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.