Query log not printing to stdout
Closed this issue · 4 comments
jjhatobjective commented
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 commented
hi @jjhatobjective , you should start portproxy
with --verbose
option.
-verbose
print verbose sql query
jjhatobjective commented
@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 commented
mysql 5.7
or above version enable ssl
by default, you should set --skip-ssl
if use high version mysql
command.
jjhatobjective commented
Thanks Resolved.