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:
select digest('testing123','sha512'); result: \x4120117b3190ba5e24044732b0b09aa9ed50eb1567705abcbfa78431a4e0a96b1152ed7f4925966b1c82325e186a8100e692e6d2fcb6702572765820d25c7e9e login fails
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