Recover notes full IDs

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!

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: