Changing Password Schemes

[Carl A Jeptha]

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