Event JSON
{
"id": "7702c41c2c871eaad1cc9f750b86f2f5f4718c123c260a872f4eb276b5e38b96",
"pubkey": "044a07dfebb0efb8f1a7e23fbe9ca0af0294bd85588f8223fe8734cc02224c17",
"created_at": 1719563594,
"kind": 1,
"tags": [
[
"proxy",
"https://mastodon.social/@jpmens/112693319706920989",
"web"
],
[
"proxy",
"https://mastodon.social/users/jpmens/statuses/112693319706920989",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://mastodon.social/users/jpmens/statuses/112693319706920989",
"pink.momostr"
],
[
"expiration",
"1722156515"
]
],
"content": "TIL that Signal (desktop) uses https://www.zetetic.net/sqlcipher/ to encrypt messages. The key is on the file system in config.json (obviously; it obviously must be somewhere), and it's actually quite easy to decrypt the SQLite3 file when one knows how to :)\n\nhttps://kowalcj0.github.io/2020/05/03/decrypt-signal-message-db/",
"sig": "86d1a56e180e83a5f21d0d9590d8e487ef87923f5cd0d8cf5e2152d2d64a95b9a68577046cc01f8e106b7ad8f3a94eb565df4061ca93e14cf7f26d88e9476aff"
}
