Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

PMM2 Setup

I've just installed a new installation of PMM2. The manual seems to have a lot of mistakes within it which don't even match the Percona blogs on the product. The create pmm user does not appear to be supported by pmm-admin, (pmm-admin --help-long has no reference to it and the command as listed fails). I've got the client registration working and the Linux stats are appearing in pmm. However when trying to add a pmm user for mysql the command fails with access denied despite my ability to log into mysql with the username and password. Hopefully someone will be able to point out the error of my ways?

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Hey there jemiss, thanks for reaching out on this. It's a little troubling if the documentation isn't working for you. I'll see if I can get someone to help with your immediate issues and then we'd be happy to hear of any errors or faults that you're finding too.

    For bugs and errors (including in documentation) you are invited to raise a Jira report, and this way you will be able to more easily track how things progress and when fixes are available. The URL for that is https://jira.percona.com and on that first page you'll find some useful tips on how to report issues.

    Meanwhile, I will draw the attention of the PMM team to this question. Thanks!

    Could you also update this post with a few more details e.g. are you new to PMM, is it an upgrade or are you trying a new install, what environment you're installing into and so on.
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    One other thing... something that you said above has the team wanting you to check that you are accessing the right manual. The online version can be read here https://www.percona.com/doc/percona-monitoring-and-management/2.x/index.html and you can download a pdf version from here. https://learn.percona.com/download-percona-monitoring-and-management-pmm-manual-2-0 ... I just checked and both links will get you to the correct content.

    Let me know? Thanks!
  • jemissjemiss Entrant Current User Role Novice
    Hi. We previously were using PMM 1.17. We have installed on Centos 7 core with the docker image. Getting the server up and running was easy, although the documentation for attaching to prometheus was incorrect in the manual, but using the online documentation worked when pointing at the URL. We have two proxysql 2 (percona provided) nodes and they setup correctly and are reporting happily. It is getting our two PXC 5.7 clusters reporting in correctly which is causing the problems. We had the existing pmm user and so I am trying to use that account for the new pmm. I can log in to mysql with the account no problem but continually get error 1045 when trying to set up the client;
    $ pmm-admin add mysql --username=pmm-mysql --password=password
    Connection check failed: Error 1045: Access denied for user 'pmm-mysql'@'127.0.0.1' (using password: YES).
    $ pmm-admin add mysql --username='pmm-mysql' --password='password'
    Connection check failed: Error 1045: Access denied for user 'pmm-mysql'@'127.0.0.1' (using password: YES).
    $ pmm-admin add mysql --username="pmm-mysql" --password="password"
    Connection check failed: Error 1045: Access denied for user 'pmm-mysql'@'127.0.0.1' (using password: YES).
    $ pmm-admin add mysql --username pmm-mysql --password password
    Connection check failed: Error 1045: Access denied for user 'pmm-mysql'@'127.0.0.1' (using password: YES).
    $ pmm-admin add mysql --username 'pmm-mysql' --password 'password'
    Connection check failed: Error 1045: Access denied for user 'pmm-mysql'@'127.0.0.1' (using password: YES).
    $ pmm-admin add mysql --username 'pmm-mysql' --password 'password' 127.0.0.1:3306
    Connection check failed: Error 1045: Access denied for user 'pmm-mysql'@'127.0.0.1' (using password: YES).
    $ pmm-admin add mysql --username='pmm-mysql' --password='password' 127.0.0.1:3306
    Connection check failed: Error 1045: Access denied for user 'pmm-mysql'@'127.0.0.1' (using password: YES).
  • jemissjemiss Entrant Current User Role Novice
    documentation which I downloaded last week is for release 2.0.0 and has the date of September 18, 2019 on the cover sheet.
  • jemissjemiss Entrant Current User Role Novice
    Some extra details:
    page 37 which does not work
    pmm-admin config --server-insecure-tls --server-address=<IP Address>:443
    from your website (and also I've just found is also on page 41) - which does work:
    pmm-admin config --server-insecure-tls --server-url=https://admin:[email protected]:443
  • jemissjemiss Entrant Current User Role Novice
    pmm-admin uninstall doesn't work either:
    ]$ sudo pmm-admin uninstall --help
    pmm-admin: error: expected command but got "uninstall", try --help
  • lalit.choudharylalit.choudhary Percona Percona Staff Role
    Hello Jemiss,

    Thank you for finding this.
    I have created bugs for both PMM2 issues.

    missing uninstall option : https://jira.percona.com/browse/PMM-4777
    missing --create-user option: https://jira.percona.com/browse/PMM-4776

    As a workaround for missing --create-user create pmm user manually as follows,
    Example:
    CREATE USER [email protected] IDENTIFIED BY 'pass' WITH MAX_USER_CONNECTIONS 10;
    GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD ON *.* TO 'pmm'@'localhost';
    GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO 'pmm'@'localhost';

    # pmm-admin add mysql --help
    usage: pmm-admin add mysql [<flags>] [<name>] [<address>]

    # pmm-admin add mysql ps5726 --query-source=slowlog --username=pmm --password=pass 127.0.0.1:5726
    MySQL Service added.
    Service ID : /service_id/02e7b7cb-2061-4e58-8953-0e83e75d14e9
    Service name: ps5726

    # pmm-admin list
    Service type Service name Address and port Service ID
    MySQL ps5726 127.0.0.1:5726 /service_id/02e7b7cb-2061-4e58-8953-0e83e75d14e9
  • jemissjemiss Entrant Current User Role Novice
    Hi Lalit
    Currently nothing is listening on 5726 - does this create a specific service on that port?
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.