I have added MySQL as a target in Warpgate and was able to successfully connect using the following command:
mysql -u "admin#tagetname" --host "warpgate" --port 33306 -p
However, once I log in and attempt to run any query, I encounter the following error:
ERROR 2013 (HY000): Lost connection to MySQL server during query No connection. Trying to reconnect... Connection id: 1 Current database: *** NONE ***
Additional error details from the Warpgate logs:
02:51:05 INFO MySQL: User handshake capabilities=LONG_FLAG | PROTOCOL_41 | INTERACTIVE | SSL | TRANSACTIONS | SECURE_CONNECTION | PLUGIN_AUTH | PLUGIN_AUTH_LENENC_DATA | SESSION_TRACK | DEPRECATE_EOF username=admin#mysql session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 INFO MySQL: Authenticated username=admin credentials=password session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 INFO MySQL: Target handshake capabilities=LONG_FLAG | PROTOCOL_41 | INTERACTIVE | TRANSACTIONS | SECURE_CONNECTION | PLUGIN_AUTH | PLUGIN_AUTH_LENENC_DATA | SESSION_TRACK | DEPRECATE_EOF session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 ERROR MySQL: Target connection failed error=protocol error: handshake failed: ErrPacket { error_code: 1251, sql_state: Some("08004"), error_message: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" } session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 ERROR Session failed error=protocol error: handshake failed: ErrPacket { error_code: 1251, sql_state: Some("08004"), error_message: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" }
Environment:
Warpgate version: 0.11.0
MySQL version: 8.0.39
MySQL User configuration: Root user with all privileges on all databases and tables.
I have added MySQL as a target in Warpgate and was able to successfully connect using the following command:
mysql -u "admin#tagetname" --host "warpgate" --port 33306 -pHowever, once I log in and attempt to run any query, I encounter the following error:
ERROR 2013 (HY000): Lost connection to MySQL server during query No connection. Trying to reconnect... Connection id: 1 Current database: *** NONE ***Additional error details from the Warpgate logs:
02:51:05 INFO MySQL: User handshake capabilities=LONG_FLAG | PROTOCOL_41 | INTERACTIVE | SSL | TRANSACTIONS | SECURE_CONNECTION | PLUGIN_AUTH | PLUGIN_AUTH_LENENC_DATA | SESSION_TRACK | DEPRECATE_EOF username=admin#mysql session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 INFO MySQL: Authenticated username=admin credentials=password session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 INFO MySQL: Target handshake capabilities=LONG_FLAG | PROTOCOL_41 | INTERACTIVE | TRANSACTIONS | SECURE_CONNECTION | PLUGIN_AUTH | PLUGIN_AUTH_LENENC_DATA | SESSION_TRACK | DEPRECATE_EOF session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 ERROR MySQL: Target connection failed error=protocol error: handshake failed: ErrPacket { error_code: 1251, sql_state: Some("08004"), error_message: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" } session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 ERROR Session failed error=protocol error: handshake failed: ErrPacket { error_code: 1251, sql_state: Some("08004"), error_message: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" }Environment:
Warpgate version: 0.11.0 MySQL version: 8.0.39 MySQL User configuration: Root user with all privileges on all databases and tables.