Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
6.2.1
-
None
-
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
|