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
