Uploaded image for project: 'Percona Kubernetes Operator for Percona XtraDB Cluster'
  1. Percona Kubernetes Operator for Percona XtraDB Cluster
  2. K8SPXC-641

Update of secret for proxyadmin user does not work properly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 1.5.0, 1.6.0, 1.7.0
    • Fix Version/s: 1.8.0
    • Component/s: None
    • Labels:
      None
    • Needs Review:
      Yes

      Description

      Hi,

      When I am trying  to update/change the password for 'proxyadmin' user I see the following behaviour, for cluster1-proxysql-2 pod the password was successfully updated but for cluster1-proxysql-0 and cluster1-proxysql-1 the  value for env variable and configuration files was changed but not in proxysql DB.  

      From operator log we can see the following:

      {"level":"error","ts":1612980237.9058497,"logger":"controller_perconaxtradbcluster","msg":"sync users","error":"exec syncusers: command terminated with exit code 1 /  / ERROR 1045 (28000): ProxySQL Error: Access denied for user 'proxyadmin'@'127.0.0.1' (using password: YES)\nERROR (line:553) : ProxySQL connection check failed. \n-- Could not connect to ProxySQL at localhost:6032 \n-- Please check the ProxySQL connection parameters and status.\n","errorVerbose":"exec syncusers: command terminated with exit code 1 /  / ERROR 1045 (28000): ProxySQL Error: Access denied for user 'proxyadmin'@'127.0.0.1' (using password: YES)\nERROR (line:553) : ProxySQL connection check failed. \n-- Could not connect to ProxySQL at localhost:6032 \n-- Please check the ProxySQL connection parameters and status.\n\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).syncPXCUsersWithProxySQL\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/users.go:380\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:1084\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1373","stacktrace":"github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:1086"}
      

      From proxysql-2 pod log:

      2021-02-10 17:53:21 ProxySQL_Cluster.cpp:217:ProxySQL_Cluster_Monitor_thread(): [WARNING] Cluster: unable to connect to peer cluster1-proxysql-2.cluster1-proxysql-unready.pxc.svc.cluster.local:6032 . Error: ProxySQL Error: Access denied for user 'proxyadmin'@'10.12.0.6' (using password: YES)
      

      We need to fix it and we need to improve our 'users' test to check whether we can connect to proxysql DB (on all proxysql nodes) using a new password or not.

        Attachments

          Activity

            People

            Assignee:
            max.dudin Maksim Dudin
            Reporter:
            slava.sarzhan Slava Sarzhan
            Votes:
            0 Vote for this issue
            Watchers:
            1 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 - 2 days, 7 hours
                2d 7h

                  Smart Checklist