DBShield
DBShield copied to clipboard
DBShield run into i/o timeout when receiving response from mysql 5.7 as backend server
When test against MySQL 5.7 as backend server, DBShield failed into i/o timeout when read packets fromserver. But the server did send back packets to DBShield. But this doesn't recurrent for Mysql 5.5 or 5.6. I am not quit sure about it. Please help.
debug log:
2017/10/19 17:18:13 [INFO] Config file: /path/to/dbshield.yml
2017/10/19 17:18:13 [INFO] Listening: 0.0.0.0:13307
2017/10/19 17:18:13 [INFO] Backend: mysql (10.10.10.57:3306)
2017/10/19 17:18:13 [INFO] Protect: false
2017/10/19 17:18:13 [INFO] Web interface on https://127.0.0.1:8070/
2017/10/19 17:18:20 [DEBUG] Connected from: 127.0.0.1:56552
2017/10/19 17:18:20 [DEBUG] Connected to: 10.10.10.57:3306
2017/10/19 17:18:20 [DEBUG] SSL connection
2017/10/19 17:18:20 [DEBUG] Client handshake done
2017/10/19 17:18:20 [DEBUG] Server handshake done
2017/10/19 17:18:20 [DEBUG] Username: root
2017/10/19 17:18:20 [DEBUG] Database: mysql_native_password
2017/10/19 17:18:20 [DEBUG] SSL bit: true
2017/10/19 17:18:20 [DEBUG] Query: show databases
2017/10/19 17:18:20 [DEBUG] action: learning
2017/10/19 17:18:20 [WARN] data recevied: Kdefinformation_schemSCHEMATSCHEMATDatabase
SCHEMA_NAME
!information_schemamysqlperformance_schemasys"
2017/10/19 17:18:30 [WARN] read tcp 10.2.1.5:56553->10.10.10.57:3306: i/o timeout
2017/10/19 17:18:54 [DEBUG] Connected from: 127.0.0.1:56593
2017/10/19 17:18:54 [DEBUG] Connected to: 10.10.10.57:3306
2017/10/19 17:18:54 [DEBUG] SSL connection
2017/10/19 17:18:54 [DEBUG] Client handshake done
2017/10/19 17:18:54 [DEBUG] Server handshake done
2017/10/19 17:18:54 [DEBUG] Username: root
2017/10/19 17:18:54 [DEBUG] Database: mysql_native_password
2017/10/19 17:18:54 [DEBUG] SSL bit: true
2017/10/19 17:18:54 [DEBUG] Query: select * from first where name<1719
2017/10/19 17:18:54 [DEBUG] action: learning
2017/10/19 17:18:54 [WARN] data recevied: #3D000No database selected
2017/10/19 17:19:04 [WARN] read tcp 10.2.1.5:56594->10.10.10.57:3306: i/o timeout
env
DBShield Version: 1.0.0-beta4
$ go version
go version go1.9.1 darwin/amd64
$ mysql --version
mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper
I'm having the same problem. any idea?