While this does extract all messages, we need to specify that " all" in signal-desktop has the meaning of " all messages actually loaded".
You have to install sqlcipher and jq for that: sudo apt install sqlcipher jq One can then use jq to access any key/value from the messages backup.
Where contains the PRAGMA key definition and the actual SQL statement ( SELECT json FROM messages ). This script uses sqlcipher and jq with signal-desktop's database key to open, decrypt and extract all messages in JSON format into clearTextMsgs.csv inside your signal-desktop folder ~/.config/Signal.īesides the key extraction by filtering JSON with jq (from ~/.config/Signal/config.json), the crucial bit happens here: sqlcipher -list -noheader Or render it executable with chmod 700 and call it directly. usr/bin/sqlcipher -list -noheader "$db" "PRAGMA key = \"x'"$key"'\" select json from messages " > "$clearTextMsgs" Īnd call it via bash. Just save this in a file : sigBase="$clearTextMsgs.csv"
0 kommentar(er)
