SSHA512 Salting in SQL Query

dovecot at ptld.com dovecot at ptld.com
Thu Jul 1 20:49:46 EEST 2021


I don't understand what im doing wrong.

Password = test
Salt = salt


MariaDB> select to_base64(concat(sha2('testsalt', 512), 'salt'));

NmM4MzhlOTM0ZTNmZWVmYWU2Y2ZhNTNhZjExMzc1ZDQ5NTRmODVjNmY1ZWQ4ODhjMDJjZDc4MDZhNzE2OTZkMWNiNDQ5ZjJiZTc4ZTllNmVhMzAxYTk1YzgxZjI4YWQ4NzY2ZjNhZTU4MmY5YmVhYWMzM2M3ZGMyYjdiYTkxODdzYWx0


[root at host /]# doveadm pw -p test -t 
{SSHA512.b64}NmM4MzhlOTM0ZTNmZWVmYWU2Y2ZhNTNhZjExMzc1ZDQ5NTRmODVjNmY1ZWQ4ODhjMDJjZDc4MDZhNzE2OTZkMWNiNDQ5ZjJiZTc4ZTllNmVhMzAxYTk1YzgxZjI4YWQ4NzY2ZjNhZTU4MmY5YmVhYWMzM2M3ZGMyYjdiYTkxODdzYWx0

Fatal: reverse password verification check failed: Password mismatch


Can someone point me in the right direction? Thanks.


More information about the dovecot mailing list