Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DBShield run into i/o timeout when receiving response from mysql 5.7 as backend server #7

Open
qiwihui opened this issue Oct 19, 2017 · 1 comment
Assignees

Comments

@qiwihui
Copy link

qiwihui commented Oct 19, 2017

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: ���K��def�information_schemSCHEMATSCHEMATDatabase
                                                                                            SCHEMA_NAME
                                                                                !���information_schema��mysql��performance_schema���sys"
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
@nim4 nim4 self-assigned this Oct 19, 2017
@tfxrdz
Copy link

tfxrdz commented Nov 12, 2017

I'm having the same problem.
any idea?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants