remmina

To connect to another Ubuntu machine using remmina, enable desktop sharing on the server machine, by starting the associated application:
"Desktop sharing"
and allow other users to view your desktop.
NOTE: copy/paste  doesn't work between server and client...

what is my IP ?

dig +short myip.opendns.com @resolver1.opendns.com
.
.

AES encryption

I cannot run queries using encryption from MySQL workbench. I need to run them from the mysql console.

SELECT id,AES_DECRYPT(firstname,UNHEX(SHA2('key',512))),AES_DECRYPT(lastname,UNHEX(SHA2('key',512))),AES_DECRYPT(email,UNHEX(SHA2('key',512))),AES_DECRYPT(password,UNHEX(SHA2('key',512))) FROM user WHERE     AES_DECRYPT(lastname,UNHEX(SHA2('key',512))) LIKE '%lee%';

mysql -h 127.0.0.1 -u root -pXXXX -e "SET block_encryption_mode = 'aes-128-cbc';SET @enc_key='mywhateverkey';SET @bytes='0000000000000000';SELECT g.id,g.flag,AES_DECRYPT(FROM_BASE64(gc.firstname), @ENC_KEY, @BYTES) FROM guest AS g, guest_capa AS gc;" app_v2_e > i9011.db

pytest

pytest tests/test_api_extract.py::TestApi::test_db_source

.