Cyrus Imap and crypt SQL Passwords?

[Diego M. Vadell]

I use ENCRYPT, and it works.
update usuarios set password=ENCRYPT("password","$1$encrypt$") ...

$1$encrypt$ may be any string, AFAIR

Good luck,
 -- Diego.

On Wednesday 13 April 2005 08:05, Berger, Stefan (IT- Management) wrote:
> Hi,
>
> thanks for the responses to all. But there is a problem still. I've
> patched the cyrus-sasl-2.1.19 Version compiled and installed. So if I set
> the parameter sasl_password_format: plaintext all is running. Is the
> sasl_password_format: crypt set, then i can't authenticate against my
> MySQL Database. The Database is a mysql version 4.0.21. I use phpMyAdmin
> too. If I create a user in the database which function i have to use for
> the password encryption. Is it MD5 or PASSWORD? Both won't work.
>
> Thanks a lot
>
> >> i want use this crypt password to login in cyrus imap with mozilla
> >> thunderbird or squirrelmail.... So in the mysql DB the password is
> >> crypt.
> >> So, what i have to do? Is this possible and where can i find the patch?
> >
> > Do you mean something like this ?
> > http://frost.ath.cx/software/cyrus-sasl-patches/
> >
> > Simon
> >
> >> Thanks a lot.
> >>
> >>> On Mon, 11 Apr 2005, Berger, Stefan (IT- Management) wrote:
> >>>> Hi,
> >>>>
> >>>> is there a possibility for use crypt mysql passwords with cyrus imap?
> >>>> Is
> >>>> there a patch available or any other solution? I've patched the cyrus
> >>>> sasl
> >>>> 2.1.19  and this works fine.
> >>>
> >>> Not for any scheme which is hash based, only schemes which take a
> >>> password
> >>> (e.g. login). Otherwise the one-way crypt is not reversible and you
> >>> have
> >>> no way to transform the password.
> >>>
> >>> The archives have a pointer to a patch, if this is what you want to do.
> >>>
> >>> ---
> >>> Cyrus Home Page: http://asg.web.cmu.edu/cyrus
> >>> Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
> >>> List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
> >>
> >> ---
> >> Cyrus Home Page: http://asg.web.cmu.edu/cyrus
> >> Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
> >> List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
>
> ---
> Cyrus Home Page: http://asg.web.cmu.edu/cyrus
> Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
> List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html

-- 
-----
:( >> $$
Hi! I'm a .signature virus! Copy me into your ~/.signature to help me
spread!
---
Cyrus Home Page: http://asg.web.cmu.edu/cyrus
Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html