Emergency

Error adding mysql:queries service

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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:password@serverIP/qa...879de1355966d: 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

    Comment

    Working...
    X