Open mangoes-git opened 2 years ago
Hi @mangoes-git you can try below steps to get actual value from DB
SELECT encode(column_name, 'base64') FROM TABLE_NAME limit 1;
from django.conf import settings from django_cryptography.utils.crypto import FernetBytes import pickle import base64 fernet = FernetBytes(settings.CRYPTOGRAPHY_KEY) base64_encoded_data = "...." pickle.loads(fernet.decrypt(base64.b64decode(base64_encoded_data))) `
Hi, I would like to know how to decrypt fields manually from querying the database directly. I am using MySQL and the MySQL CLI.
For example, this is the content of the encrypted field:
� ap�s��vdV8\� �P5�-X�9�m��cB,j�"������> ����j�~0����zah |�_�������H��
I am using https://asecuritysite.com/encryption/ferdecode to decode it (using my secret key) but I get no output.
Thanks