Hello Noel!
On 04.10.2017 23:42, Noel Butler wrote:
As a test, this is testing123 in sha512
$6$Z6I5oyWUed.tmNUs$0ScF2w3ejPWFAX/3F6DgMyWpbXLq0DD6blL8rwBpSHGWaZ9RiXlpo5PPZFoJPZWIuQMETELsXG2YtbsAc8K3q/
Again, after inserting this String as is into the pgsql database, I can
authenticate with dovecot.
Now the next step for me would be to be able to generate such SHA512
hashes with pgsql myself.
I made two attempts:
1) select digest('testing123','sha512');
result:
\x4120117b3190ba5e24044732b0b09aa9ed50eb1567705abcbfa78431a4e0a96b1152ed7f4925966b1c82325e186a8100e692e6d2fcb6702572765820d25c7e9e
login fails
2) select encode(digest('testing123','sha512'),'hex');
result:
4120117b3190ba5e24044732b0b09aa9ed50eb1567705abcbfa78431a4e0a96b1152ed7f4925966b1c82325e186a8100e692e6d2fcb6702572765820d25c7e9e
login fails
How did you generate your hash and how can I do the same with pgsql?
Thanks
Magnus
