You can use the MySQL crypt command. It calls the unix crypt()
function, so it's compatiable with vpopmail (and /etc/shadow)
Ken Jones
On Thursday 10 October 2002 05:15 pm, Alfredo Perez wrote:
> Ari,
>
>
> The SQL md5 function won't work for these passwords... it seems that
> vpopmail uses another md5 like algorithm.
>
> So the encripted password will always be different between MySQL and
> vpopmail.
>
>
> Regards,
>
> El jue, 10-10-2002 a las 15:56, Ari Arantes Filho escribió:
> > Hi,
> >
> > I've installed vpopmail with --enable-mysql=y and the default
> > option --enable-md5-password=y, then I've tried: update vpopmail set
> > pw_passwd = md5('test'), pw_clear_passwd = 'test' where pw_name = 'user1'
> > and pw_domain = 'test.com'
> >
> > It didn't work. Then I've changed md5('test') to password('test'),
> > didn't work too.
> >
> > Then I've reinstalled vpopmail with --enable-md5-password=n, it
> > didn't work too.
> >
> > I only can change password with vpasswd command. How can I change the
> > password with SQL command?
> >
> > Best regards,
> >
> > Ari
