Re: [Proftpd-user] Migration encrypted passwords from to SHA-512 based crypt() with mod_sql?

[Christian H. <ch...@la...>]

Am Fri, 29 Jun 2012 09:39:10 -0700 (PDT)
schrieb TJ Saunders <tj...@ca...>:

> 
> > That's not the problem: the SQLAuthType Crypt already understands
> > SHA-512 based passwords (starting with "$6$") as well as DES, MD5
> > and SHA-256 based ones.
> 
> Ah.  That sounds like your platform's crypt(3) support -- not
> everyone's SQLAuthType Crypt will support that.  (Just pointing this
> out for the benefits of others on the list.)
> 
> > My problem is that I want to *overwrite* them in my database with
> > e.g.: UPDATE ftpusers SET password = $sha512hash WHERE username =
> > $user;
> 
> Why would you want to do the above within proftpd itself?  It sounds
> like you can simply write a SQL script, and run it against your
> database, without needing to change anything with your proftpd
> configuration.

I only have password hashes in the database, to re-encrypt them
with a different algorithm I need the cleartext password.
Thus, either all users would have to re-enter it on a website or
I tap them when they log in.

bye,

-christian-