Extract Telegram messages from db_sqlite PostBox – made for Telegram for macOS, but should work with Telegram for iOS

extract_telegram_macos.ipynb

@lindsaymorgan I’ve updated the gist code, hope I didn’t mess it up

@lindsaymorgan I think @ekzotech wrote about it, try this@lindsaymorgan我认为@ekzotech写过它，试试这个

Also there's an error with calling murmur because of mmh3 update 5.0.0 - it fails with negative seed. As workaround you can install mmh3==4.1.0 worked for me.此外，由于 mmh3 更新 5.0.0 而调用 murmur 时出错 - 它失败并出现负种子。作为解决方法，您可以安装 mmh3==4.1.0 对我有用。

It works! Thank you so much!

This has been working great for me for awhile. But recently, I've been getting an exception on this line in the TelegramMediaFile decoder:

self.fileId = (bio.read_int32(), bio.read_int64())

The call to read_int32() is failing because when it reads the buffer, it's getting b''. This isn't happening for all Media Files, but it is happening for a lot of them. I'm assuming it's some new feature in Telegram that's causing this, but I thought I would ask here if anyone knows what the change is, before spending time trying to dig into what's causing it.

I assume this needs to be ran on the host machine? I've tried exporting the account postbox directory to another machine and running the jup notebook but doesn't seem to be working. Does the notebook file need to be in the same directory with the db_sqlite? Once I run the jup notebook server and open this ipynb I just get a 0 byte DB and an error saying no such table T7

Just looking for initial setup guidance.

How to get the Sqlite DB file from an Android phone or Windows desktop computer? I searched a lot, but can't find them.

I'm stuck in the fist step of the problem 🤷

@pauloneves this is for iOS/macOS apps only, other apps are completely different

Hey, thanks so much for this. I'm trying to extract the key to decrypt db - I don't have a local passcode, only the cloud one, and I'm getting raise Exception(f'hash mismatch: {dbHash} != {calcHash}'). Any ideas on what else I could try?

Hey, thanks so much for this. I'm trying to extract the key to decrypt db - I don't have a local passcode, only the cloud one, and I'm getting raise Exception(f'hash mismatch: {dbHash} != {calcHash}'). Any ideas on what else I could try?

The same issue for me. No password, but still hash mismatch.

@ianwongkj @aromanyuk works fine for me on 11.13.273693 Stable. Maybe you're trying to pass cloud password instead of default no-matter-key?