Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-3209

Special symbols in username or password prevents addition of Remote Instances

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 1.16.0
    • Fix Version/s: 1.17.0
    • Component/s: PMM ManageD
    • Labels:
      None

      Description

      Effect on a user:
      If a user tries to add a Remote MySQL or PostgreSQL instance with % or @ in the password/username - PMM will fail or become broken

      STR:

      1. Install PMM 1.16.0
      2. Add Remote MySQL instance with % in the password.
        #UI reports Instance was added, no error

      Given Result:

      1. Check logs (PMM_SERVER/managed/logs.zip)
        #Error messages :
      StartTool: failed to send command after 10 attempts. And after that any other remote instances cannot be added.
      Executing 'supervisorctl update' returns an error: "Error: Format string “DATA_SOURCE_NAME=‘root:qwertyUIOP)(*&^%$#@1@tcp(10.10.11.54:3306)/?timeout=5s’” for ‘environment’ is badly formatted"

      or

      "supervisorctl update
      error: <class 'xmlrpclib.Fault'>, <Fault 92: 'CANT_REREAD: Format string "DATA_SOURCE_NAME=\'postgres://pmmpg%40pmm-pg-azure:1q2w3e$R@pmm-pg.postgres.database.azure.com:5432/postgres?connect_timeout=5&sslmode=disable\'" for \'environment\' is badly formatted'>: file: /usr/lib64/python2.7/xmlrpclib.py line: 794

      Expected Results:
      Dashboards with data, system working correctly

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              nailya.kutlubaeva Nailya Kutlubaeva
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 6 hours, 20 minutes
                6h 20m