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

+++++++++++++++++++++++++++++++++++++++