The database is MySQL.

------------
You have a good day now, en mag jou môre ook so wees,

Carl A Jeptha

On 2016-04-30 01:14, Gedalya wrote:
That's not SHA512-CRYPT. That's just a simple sha512 of the password, without 
salt.

A SHA512-CRYPT password will be generated with:

printf "1234\n1234" | doveadm pw -s SHA512-CRYPT

or:

doveadm pw -s SHA512-CRYPT -p 1234

or:

mkpasswd -m sha-512 1234

(without the "{SHA512-CRYPT}" prefix)

What exactly is the difficulty you are having with converting the passwords?
What database engine are you using?


On 04/29/2016 03:20 PM, Bill Shirley wrote:
Looks like an SQL update would do this:
UPDATE `users`
SET `passwd_SHA512` = SHA2(`passwd_clear`, 512);

Bill

On 4/29/2016 9:07 AM, Carl A Jeptha wrote:
converting the passwords in the database from clear/plain text to SHA512-CRYPT

Reply via email to