[root@vqc006a ~]# date; mysql -A -h karma075 -u user1 -P 4008 -p Wed Jul 20 18:15:57 UTC 2022 Enter password: ERROR 1045 (28000): Access denied for user 'user1'@'10.2.14.177' (using password: YES) [root@vqc006a ~]# [root@karma075 ~]# maxctrl list servers ┌───────────────────┬─────────────┬──────┬─────────────┬─────────────────┬──────┐ │ Server │ Address │ Port │ Connections │ State │ GTID │ ├───────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤ │ Bootstrap1 │ 10.2.15.126 │ 3306 │ 0 │ Master, Running │ │ ├───────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤ │ Bootstrap2 │ 10.2.15.143 │ 3306 │ 0 │ Master, Running │ │ ├───────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤ │ Bootstrap3 │ 10.2.12.232 │ 3306 │ 0 │ Master, Running │ │ ├───────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤ │ @@Clustrix:node-1 │ 10.2.15.126 │ 3306 │ 0 │ Master, Running │ │ ├───────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤ │ @@Clustrix:node-2 │ 10.2.12.232 │ 3306 │ 0 │ Master, Running │ │ ├───────────────────┼─────────────┼──────┼─────────────┼─────────────────┼──────┤ │ @@Clustrix:node-3 │ 10.2.15.143 │ 3306 │ 0 │ Master, Running │ │ └───────────────────┴─────────────┴──────┴─────────────┴─────────────────┴──────┘ [root@karma075 ~]# tail -f /data/clustrix/log/maxscale.log 2022-07-20 18:16:11 error : Failed to query server '@@Clustrix:node-1' for user account info. Connection to [10.2.15.126]:3306 failed. Error 2013: Lost connection to server at 'handshake: reading initial communication packet', system error: 110 2022-07-20 18:16:21 error : Failed to query server '@@Clustrix:node-2' for user account info. Connection to [10.2.12.232]:3306 failed. Error 2013: Lost connection to server at 'handshake: reading initial communication packet', system error: 110 2022-07-20 18:16:31 error : Failed to query server '@@Clustrix:node-3' for user account info. Connection to [10.2.15.143]:3306 failed. Error 2013: Lost connection to server at 'handshake: reading initial communication packet', system error: 110 2022-07-20 18:16:31 warning: (3) [MariaDBProtocol] Authentication failed for user 'user1'@[10.2.14.177] to service 'RCR'. Originating listener: 'RCR-Listener'. MariaDB error: 'Access denied for user 'user1'@'10.2.14.177' (using password: YES)'. 2022-07-20 18:16:31 info : Stopped RCR client session [3] [root@karma075 ~]# tcpdump -i enp5s0f0 port 4008 -A tcpdump: verbose output suppressed, use -v or -vv for full protocol decode listening on enp5s0f0, link-type EN10MB (Ethernet), capture size 262144 bytes 18:16:01.471800 IP vqc006a.colo.sproutsys.com.59118 > karma075.colo.sproutsys.com.netcheque: Flags [S], seq 1932987418, win 29200, options [mss 1460,sackOK,TS val 807649080 ecr 0,nop,wscale 7], length 0 E..<."@.@.X. ... .......s7........r.A#......... 0#.8........ 18:16:01.471825 IP karma075.colo.sproutsys.com.netcheque > vqc006a.colo.sproutsys.com.59118: Flags [S.], seq 1886365143, ack 1932987419, win 28960, options [mss 1460,sackOK,TS val 423993203 ecr 807649080,nop,wscale 7], length 0 E..<..@.@..4 ... .......po..s7....q /.......... .E.s0#.8.... 18:16:01.471968 IP vqc006a.colo.sproutsys.com.59118 > karma075.colo.sproutsys.com.netcheque: Flags [.], ack 1, win 229, options [nop,nop,TS val 807649080 ecr 423993203], length 0 E..4.#@.@.X. ... .......s7..po....... ..... 0#.8.E.s 18:16:01.472421 IP karma075.colo.sproutsys.com.netcheque > vqc006a.colo.sproutsys.com.59118: Flags [P.], seq 1:101, ack 1, win 227, options [nop,nop,TS val 423993203 ecr 807649080], length 100 E...:.@.@.., ... .......po..s7......0...... .E.s0#.8`... 5.5.5-10.2.12 6.4.1-maxscale.....#B,Ya|dn......?............2G|"'ir:@JG>.mysql_native_password. 18:16:01.472598 IP vqc006a.colo.sproutsys.com.59118 > karma075.colo.sproutsys.com.netcheque: Flags [.], ack 101, win 229, options [nop,nop,TS val 807649081 ecr 423993203], length 0 E..4.$@.@.X. ... .......s7..po.<........... 0#.9.E.s 18:16:01.472662 IP vqc006a.colo.sproutsys.com.59118 > karma075.colo.sproutsys.com.netcheque: Flags [P.], seq 1:212, ack 101, win 229, options [nop,nop,TS val 807649081 ecr 423993203], length 211 E....%@.@.W; ... .......s7..po.<........... 0#.9.E.s....... ....!.......................user1...U...+a. ...El..?.3Qmysql_native_password.}._os.Linux._client_name libmariadb._pid.4257._client_version.3.1.15 _platform.x86_64.program_name.mysql._server_host.karma075 18:16:01.472670 IP karma075.colo.sproutsys.com.netcheque > vqc006a.colo.sproutsys.com.59118: Flags [.], ack 212, win 235, options [nop,nop,TS val 423993203 ecr 807649081], length 0 E..4:.@.@... ... .......po. vqc006a.colo.sproutsys.com.59118: Flags [P.], seq 101:180, ack 212, win 235, options [nop,nop,TS val 424023236 ecr 807649081], length 79 E...:.@.@..? ... .......po. vqc006a.colo.sproutsys.com.59118: Flags [F.], seq 180, ack 212, win 235, options [nop,nop,TS val 424023236 ecr 807649081], length 0 E..4:.@.@... ... .......po..s7....../...... .F..0#.9 18:16:31.505204 IP vqc006a.colo.sproutsys.com.59118 > karma075.colo.sproutsys.com.netcheque: Flags [F.], seq 212, ack 180, win 229, options [nop,nop,TS val 807679113 ecr 424023236], length 0 E..4.&@.@.X ... .......s7..po......%...... 0$4..F.. 18:16:31.505218 IP karma075.colo.sproutsys.com.netcheque > vqc006a.colo.sproutsys.com.59118: Flags [.], ack 213, win 235, options [nop,nop,TS val 424023236 ecr 807679113], length 0 E..4:.@.@... ... .......po..s7....../...... .F..0$4. 18:16:31.505337 IP vqc006a.colo.sproutsys.com.59118 > karma075.colo.sproutsys.com.netcheque: Flags [.], ack 181, win 229, options [nop,nop,TS val 807679114 ecr 424023236], length 0 E..4.'@.@.X. ... .......s7..po......%...... 0$4..F.. ^C 12 packets captured 12 packets received by filter 0 packets dropped by kernel [root@karma075 ~]# [root@karma075 ~]# cat /etc/maxscale.cnf [maxscale] log_info=1 threads=auto logdir=/data/clustrix/log [Bootstrap1] type=server address=10.2.15.126 port=3306 protocol=mariadbbackend proxy_protocol=on [Bootstrap2] type=server address=10.2.15.143 port=3306 protocol=mariadbbackend proxy_protocol=on [Bootstrap3] type=server address=10.2.12.232 port=3306 protocol=mariadbbackend proxy_protocol=on [Clustrix] type=monitor module=xpandmon servers=Bootstrap1,Bootstrap2,Bootstrap3 user=maxscale password=maxscale_pw cluster_monitor_interval=10000ms #dynamic_node_detection=false [RCR] type=service router=readconnroute user=maxscale password=maxscale_pw cluster=Clustrix #servers=Bootstrap1,Bootstrap2,Bootstrap3 [RCR-Listener] type=listener service=RCR protocol=MariaDBClient address=0.0.0.0 port=4008 # authenticator_options=skip_authentication=true # [RCR-Listener] # type=listener # service=RCR # protocol=MariaDBClient # address=127.0.0.1 # port=4008 # skip_authentication=true [root@karma075 ~]#