Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-4058

Query Editor: Connection to [::]:9999 failed. Error 2002: Can't connect to server on '::' (113)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.2.1
    • Fix Version/s: 6.2.4, 22.08.0
    • Component/s: maxgui
    • Labels:
      None
    • Sprint:
      MXS-SPRINT-154

      Description

      In the Query editor, we are unable to connect the DB, if we select source as a Listener. But we are able to connect the DB, if we select source as a Server from the GUI.

      We are getting the below error while trying to connect the DB using source a Listener [Schema-Service-Listener].

      *Connection to [::]:9999 failed. Error 2002: Can't connect to server on '::' (113) *

      Below is configuration file:

      [maxscale]
      threads                                 =       4
      admin_host                              =       192.168.1.1
      admin_port                              =       8080
      auth_read_timeout                       =       10s
      admin_secure_gui                        =       false
      admin_pam_readonly_service              =       maxscale
       
      [server1]
      type                                    =       server
      address                                 =       192.168.1.2
      port                                    =       9999
      proxy_protocol                          =       on
       
      [server2]
      type                                    =       server
      address                                 =       192.168.1.3
      port                                    =       9999
      proxy_protocol                          =       on
       
      [server3]
      type                                    =       server
      address                                 =       192.168.1.4
      port                                    =       9999
      proxy_protocol                          =       on
       
       
      [Scehma-Router-Service]
      type                                    =       service
      router                                  =       schemarouter
      servers                                 =       server1,server2,server3
      user                                    =       max_user
      password                                =       XXXXXXXXXXXXX
      connection_timeout                      =       3000s
      auth_all_servers                        =       true
       
      [Schema-Service-Listener]
      type                                    =       listener
      service                                 =       Scehma-Router-Service
      protocol                                =       mariadbclient
      port                                    =       9999
      authenticator                           =       PAMAuth
       
      [Monitor]
      type                                    =       monitor
      module                                  =       mariadbmon
      servers                                 =       server1,server2,server3
      user                                    =       max_user
      password                                =       XXXXXXXXXXXXX
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            naresh.chandra@copart.com Naresh Chandra
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.