Recover notes full IDs

Support
1

My version of HedgeDoc is: 1.9.5

What I expected to happen:

Our instance used to use LDAP to log users in, but it was removed unexpectedly, so now we use the Github login. Obviously, this means that the users can no longer see their list of notes.

I launched psql to look at the tables contents, but could not find the full IDs for the documents, the ones that are used in the URL (like this: https://my.hedgedoc.instance/KcELsw5LSXK1AcrIRDuagA)

What actually happened:

I only found IDs like this: 025c3b99-a1f3-4abf-8e15-bc0f3c6e868a

I already tried:

Looking through the different tables, using base64 one way and another to match both IDs, looking through this forum, looking through the documentation, reading the source code (but I’ll be honest, I got nowhere and gave up fast).

What I’d like to get is just the list of “full” URLs for our notes, we can figure the rest ourselves.

Thanks a lot in advance for any help!

2

Hey @Alfred456654 ,

welcome to the community forum.

The long ids in the url are an encoded version of a id column. You can find the encoding part here:

Greetings,
DerMolly

1 Like
3

Hello DerMolly,
Thank you very much for this perfect answer!
I’m still figuring out how this works since I’m not familiar with javascript but with a bit of patience I’ll be able to write a function that does the opposite.
I will then update my post with said script just in case.
Wish you the best!
Alfred

1 Like
4

Here is how I recovered my URLs:

  1. First, I extracted the IDs from the DB like this:

psql -U hackmd -W -c 'select "id" from "Notes";' > ids.txt

  1. I cleaned up the file a bit manually so that only the ids remain in it (basically remove the 2 first lines, the last line, and de-indent the whole file)

  2. I executed the following python code:

#!/usr/bin/env python
import codecs
if __name__ == '__main__':
    with open("ids.txt", mode='r', encoding="utf-8") as id_file:
        hex_ids = list(map(str.strip, id_file.readlines()))
        b64_ids = [codecs.encode(codecs.decode(hex_id.replace("-", ""), 'hex'), 'base64').decode().strip() for hex_id in hex_ids]
        print("\n".join([f"https://hedgedoc.example.com/{b64_id}" for b64_id in b64_ids]))
1 Like