Skip to content

解析基于tcp协议的 http、oracle、mysql,redis请求packet,以及消耗时长,可以用于sql审计、packet内容防火墙

Notifications You must be signed in to change notification settings

xieyuhua/http-sql-packet

Repository files navigation

##goproxy-packet

通过tcp连接,然后解析packet内容。解析协议 http、oracle、mysql,redis请求packet,可以用于sql审计、packet内容防火墙

##Examples

bind: 0.0.0.0:5678
wait_queue_len: 100
max_conn: 50
timeout: 60 #连接时长
failover: 3 #负载均衡尝试连接次数
type: "mysql" #mysql redis http oracle
stats: 0.0.0.0:8090
backend:
    - 127.0.1.1:3306
    - 127.0.1.1:3306
    - 127.0.1.1:3306

log:
    level: "info"
    path: "./logs/proxy.log"

[root@Web6 goup]# ./goup -c ./conf.yaml 
Start Proxy...
Start Successful...
2023/07/29 11:29:53 
2023/07/29 11:29:53 From client:192.168.5.254:36942 To Server:192.168.2.6:3307; Query: SET NAMES utf8
2023/07/29 11:29:59 From client:192.168.5.254:36942 To Server:192.168.2.6:3307; Quit: user quit

Server connecting num:3 
Server:127.0.1.1:3306 FailTimes:0 isUp:true

swoole and proxy swoole

[root@iZ2vc4fcja0fjd7ljf2a9cZ httpstatus]# ./httpstatus http://47.xx.xx.35

Connected to 47.xx.xx.35:80

Connected via plaintext

HTTP/1.1 200 OK
Server: nginx
Content-Type: text/html; charset=utf-8
Date: Thu, 07 Jul 2022 11:25:24 GMT
Vary: Accept-Encoding
Connection: keep-alive

Body discarded

   DNS Lookup   TCP Connection   Server Processing   Content Transfer
[       0ms  |           0ms  |              8ms  |             0ms  ]
             |                |                   |                  |
    namelookup:0ms            |                   |                  |
                        connect:0ms               |                  |
                                      starttransfer:9ms              |
                                                                 total:9ms      
[root@iZ2vc4fcja0fjd7ljf2a9cZ httpstatus]# 
[root@iZ2vc4fcja0fjd7ljf2a9cZ httpstatus]# ./httpstatus http://47.xx.xx.35:9810

Connected to 47.xxx.xx.35:9810

Connected via plaintext

HTTP/1.1 200 OK
Server: nginx
Content-Type: text/html; charset=utf-8
Date: Thu, 07 Jul 2022 11:25:25 GMT
Vary: Accept-Encoding
Connection: keep-alive

Body discarded

   DNS Lookup   TCP Connection   Server Processing   Content Transfer
[       0ms  |           0ms  |              9ms  |             0ms  ]
             |                |                   |                  |
    namelookup:0ms            |                   |                  |
                        connect:0ms               |                  |
                                      starttransfer:10ms             |
                                                                 total:10ms     

About

解析基于tcp协议的 http、oracle、mysql,redis请求packet,以及消耗时长,可以用于sql审计、packet内容防火墙

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages