Re: [Help-gnu-radius] Password on a MySQL Server (fwd)

[Mario - Firewalls]

I don't believe that is just my radius not working with MySQL...
Are you all using it ? and working fine ?

----------------------------------
M?rio Frederico Le?o Balistieri
Diretor de Implementa??es
Firewalls
address@hidden


Key fingerprint = C2BA B98D EE25 BEAF E0EF  4AD6 4B75 DDD2 1D74 97C7

---------- Forwarded message ----------
Date: Wed, 26 Feb 2003 13:41:57 -0300 (BRT)
From: Mario - Firewalls <address@hidden>
To: address@hidden
Subject: Re: [Help-gnu-radius] Password on a MySQL Server

As I said, I tried with ENCRYPT function of mysql, and with crypt functin of 
PHP and a lot of other ones.
And all I get is:
Auth.notice: Login Incorrect [user/pass nvalid chars] ...
Like the password shown in the notice is not in cleartext...

Maybe the version I am using.... or a PATCH I did not aplied... or the 
auth_query needs to be modified..???

Thanks...


Firewalls Security Corporation
www.firewalls.com.br
address@hidden


Key fingerprint = C2BA B98D EE25 BEAF E0EF  4AD6 4B75 DDD2 1D74 97C7

On 26 Feb 2003, Edward Rudd wrote:

> The passwords are crypted..
> so basically do this..
> INSERT INTO user_name (username,password) VALUES
> ('myuser',CRYPT('mypass'))
> or you can use the php crypt function
>
> $crypted_pass = crypt('mypass');
> and then insert that contents of $crypted_pass into the Database.
> make sure your password field is long enough though.. Mine is 34
> characters.
>
> On Wed, 2003-02-26 at 09:58, Mario - Firewalls wrote:
> > Hi there,
> > I'm trying to use GNU-Radius with MySQL, so I realized that the passwords 
> > stored on a mysql server must be encrypted. Does it realy need to be 
> > encrypted? could it be in cleartext/plaintext ?
> > If not, how I encrypt the password before storing it ?
> > I tryied to encrypt with md5sum(from slackware) with MD5,ENCRYPT and DES 
> > functions of mysql, with functions of PHP(crypt,md5,base64_encode/decode) 
> > and I did not get it working !
> >
> > PS: Using md5(php) and after using the function base64_encode I get a 
> > supposed working string, but MySQL does not accept it on a varchar field, 
> > cuz they're invalid chars.
> >
> > Please need help.
> > Thanks a lot!
> >
> > Mario Leao.
> > Firewalls Security Corporation
> > www.firewalls.com.br
> >
> > Key fingerprint = C2BA B98D EE25 BEAF E0EF  4AD6 4B75 DDD2 1D74 97C7
> >
> >
> >
> > _______________________________________________
> > Help-gnu-radius mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/help-gnu-radius
> --
> Edward Rudd <address@hidden>
>



_______________________________________________
Help-gnu-radius mailing list
address@hidden
http://mail.gnu.org/mailman/listinfo/help-gnu-radius