How to access signal's db.sqlite,
I uploaded this to kingofras@lemmy.world "Look at the silent countries" post
I though it would be useful to know how to access what information signal stores.
So those privacy conscious individuals can check for themselves.
this is the basic difference between Molly and signal.
In Molly you can password protect db.sqlite, Signal removed this option a while ago.
On linux you can access your Signal messages in db.sqlite.
once you delete a message from signal, either through disappearing messages or manually, all those messages are deleted from the db.sqlite.
They are stored in an encrypted db.sqlite here:
/home/user/.config/Signal/sql/db.sqlite
you can also extract it from you phone:
only the messages that you can see when you open the Signal app are visible there.
to access the messages:
install:
signal-backup-tools-git
https://github.com/bepaald/signalbackup-tools
and
DB browser for sqlite
https://sqlitebrowser.org/
++++++++++++++++++++++++++++++
The most straight forward way is to create an output file to html.
copy the db.sqlite to a new directory
signalbackup-tools --exportdesktophtml signal.html
this will create folders of all your contacts and messages and media.
easily acessible. open the signal.html files in your browser
=+++++++++++++++++++++++++++++++++++++++
To open db.sqlite as a Sqlite database;
first you need to get the key:
copy the db.sqlite to a new directory
then run in terminal:
signalbackup-tools db.sqlite --showdesktopkey
OpenSSL 3.3.2 3 Sep 2024)
Signal Desktop key (hex):
58bfa167bb66b2b13b2ca6eadc33f4bf7275c254006d17ae5e3de5356c60f0b7
copy the key to a text editor
+++++++++++++++++++++++++++++++++++++++
you must now add 0x to the beginning of that line:
0x58bfa167bb66b2b13b2ca6eadc33f4bf7275c254006d17ae5e3de5356c60f0b7
then open db.sqlite with the sqlitebrowser
right click db.sqlite, select open with DB Browser for sqlite
select RAW from the dropdown menu
input the passphrase from above. make sure you added the 0x to the beginning.
The entire database opens.
you can view all the information that signal collects. phone numbers, messages, images, media etc
+++++++++++++++++++++++++++++++++++++++