Query log not printing to stdout

[jjhatobjective]

On testing the app I have noticed that when connecting to a sql server only the client and proxy information is printing however the query log does not print.

example:

2020/04/24 03:34:10 client: 10.38.5.158:53236 ==> 10.38.20.178:33075
2020/04/24 03:34:10 proxy: 10.38.20.178:39012 ==> 10.38.31.245:3306
2020/04/24 03:34:23 client: 10.38.5.158:53238 ==> 10.38.20.178:33075
2020/04/24 03:34:23 proxy: 10.38.20.178:39014 ==> 10.38.31.245:3306
2020/04/24 03:34:23 r: 3394 w:0 ct:0.001 t:0.273 [#2]
2020/04/24 03:34:23 client: 10.38.5.158:53240 ==> 10.38.20.178:33075
2020/04/24 03:34:23 proxy: 10.38.20.178:39016 ==> 10.38.31.245:3306
2020/04/24 03:34:24 r: 3394 w:0 ct:0.001 t:0.692 [#2]
2020/04/24 03:34:24 client: 10.38.5.158:53242 ==> 10.38.20.178:33075
2020/04/24 03:34:24 proxy: 10.38.20.178:39018 ==> 10.38.31.245:3306
2020/04/24 03:34:24 r: 3394 w:0 ct:0.001 t:0.215 [#2]

Ran some select statements successfully when these sessions were enabled.

[arstercz]

hi @jjhatobjective , you should start portproxy with --verbose option.

  -verbose
        print verbose sql query

[jjhatobjective]

@arstercz thanks for the speedy response.

With the verbose flag I get some binary data and a bunch of empty lines, no query information.

2020/04/24 03:59:05 Can't get config info, skip insert log to mysql...                                                                                                               [48/1993]
2020/04/24 03:59:05 portproxy started.



2020/04/24 03:59:15 client: 10.38.5.158:53394 ==> 10.38.20.178:33075
2020/04/24 03:59:15 proxy: 10.38.20.178:39186 ==> 10.38.31.245:3306
2020/04/24 03:59:15 
2020/04/24 03:59:15 From 10.38.5.158 To 10.38.31.245; Refresh: 
                                                               p���)AHM�����'�=�E���^�t*tJްӤ"���3c5�>V�"y�߂�~�3�h�]��    �p-�U7)
K=��T0K�1h�MP:5xP5*��                                                                                                          �v��6s&
׼�7S%rl���}     S@�>8#z܈�����?��-�@�ʛ�_���#1
6E�{f1ʎ�OQB-�|��Fzs
2020/04/24 03:59:15 
2020/04/24 03:59:15 
2020/04/24 03:59:15 
2020/04/24 03:59:15 
2020/04/24 03:59:15 
2020/04/24 03:59:15 
2020/04/24 03:59:15 
2020/04/24 03:59:15 
2020/04/24 03:59:15 
2020/04/24 03:59:16 
2020/04/24 03:59:16 
2020/04/24 03:59:16 
2020/04/24 03:59:16 

[arstercz]

mysql 5.7 or above version enable ssl by default, you should set --skip-ssl if use high version mysql command.

[jjhatobjective]

Thanks Resolved.