Fix sFTP for Postgres - Githubissues

NBISweden / swefreq

Swedish Frequency resource for genomics website

https://swefreq.nbis.se/

GNU General Public License v3.0

8 stars 1 forks source link

Fix sFTP for Postgres #554

Closed talavis closed 5 years ago

talavis commented 5 years ago

Describe the pull request:

[X] Bug fix
[X] Functional change
[ ] New feature
[ ] Code cleanup
[ ] Build system change
[ ] Documentation change
[ ] Language translation

Pull request long description:

Updated the generate sFTP credentials functions to use digest() instead of SHA2, including a workaround to remove the prefix '\x' from the generated hash.

Also removes the non-functional sFTP tab from the dataset admin page.

norling commented 5 years ago

You can cast the hash to a hex value (removing the prefix) with passwd_hash = fn.encode(fn.digest(password, 'sha256'), 'hex'). Looks good otherwise!