Uploaded image for project: 'ProxySQL and Admin Scripts'
  1. ProxySQL and Admin Scripts
  2. PSQLADM-231

proxysql-admin --syncuser not work with ProxySQL cluster enabled

    Details

    • Type: Bug
    • Status: Done
    • Priority: Critical
    • Resolution: Invalid
    • Affects Version/s: 2.0.7
    • Fix Version/s: None
    • Component/s: None
    • Environment:

      Description

      Hello,
      I have PXC cluster with three nodes and two ProxySQL nodes in front in cluster. Before configuring the ProxySQL cluster proxysql-admin --syncuser  worked fine and synced successfull the mysql users from the backend until I configured ProxySQL cluster today. After that the command sync user is executed successfull but nothing happens and the new users created in the PXC cluster are not present in the ProxySQL mysql_users table.
      I found that this is official bug that is fixed in version 1.4 here:
       
       https://jira.percona.com/browse/PSQLADM-117
       
      but I am with the following version and examine exactly the same behaviour:
      ProxySQL2-2.0.7-1.2.el7.x86_64
       
      I didn't found information if this bug is fixed only in 1.4 and what other can I do. Can you please tell me what can I do, how can I avoid this and where can I report it as GitHub issue page is only for paid support?
       
      Thank you in advance!

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                kenn.takara Kenn Takara
                Reporter:
                intelbg Georgi
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: