Mysql problem

[KNO]

On 3/16/06, Alan DeKok <aland at ox.org> wrote:
> "Fabiano Rodrigo Boscatto" <fabiano.boscatto at pucpr.br> wrote:
> > Hi there, i have freeradius working fine with mysql authentication. The
> > problem is that the User-Password is stored in mysql table as clear text. Is
> > there a way to crypt that?
>
>   Change User-Password to Crypt-Password, and encrypt the password
> with the Unix crypt() tool.
>
>   Then CHAP & MS-CHAP stop working.
>
>   If you want to encrypt the password with some kind of key, and then
> make the key available to FreeRADIUS too, that might be useful.  Maybe.
>
>   But it's not as useful as it might first look.  You're better off
> controlling access to the entire MySQL DB, which contains a lot more
> security information than the clear-text password.
>
>   Alan DeKok.

And what I must to do if I want to use MD5 to store the passwords?
Greets, Aitor

--
             a8888b.
             d888888b.
             8P"YP"Y88
             8|o||o|88
             8'    .88
             8`._.' Y8.
            d/      `8b.
           dP   .    Y8b.
          d8:'  "  `::88b
         d8"         'Y88b
        :8P    '      :888
         8a.   :     _a88P
       ._/"Yaa_:   .| 88P|
       \    YP"    `| 8P  `.
       /     \.___.d|    .'
       `--..__)8888P`._.'