Freeradius, mysql, please help!!!

YvesDM ydmlog at gmail.com
Wed Apr 12 20:37:41 CEST 2006


On 4/12/06, Alan DeKok <aland at nitros9.org> wrote:
>
> YvesDM <ydmlog at gmail.com> wrote:
> > mysql> select * from radcheck;
> >
> +----+----------+---------------+----+------------------------------------+
> > | id | UserName | Attribute     | op |
> Value                              |
> >
> +----+----------+---------------+----+------------------------------------+
> > |  1 | steve    | User-Password | :=3D |
> $1$nyiGAEuR$5wcFr5bT7SfkVjIChnbZo0=
> >  |
>
>   These are *not* clear-text passwords.  They're encrypted
> passwords. Change the attribute name to Crypt-Password, and it should
> work.
>
>   Alan DeKok.



Tnx for the reply, but it didn't solve my problem.

 mysql> select * from radcheck;
+----+----------+----------------+----+------------------------------------+
| id | UserName | Attribute      | op | Value                              |
+----+----------+----------------+----+------------------------------------+
|  1 | steve    | User-Password  | := | $1$nyiGAEuR$5wcFr5bT7SfkVjIChnbZo0 |
|  2 | maureen  | Crypt-Password | := | $1$LTvKoOtc$X2fVg8uDqyP4.mU.iLNKm0 |
|  3 | john     | Crypt-Password | := | $1$bkW9WNor$tq5sRRiUcwOV4/fwk3CYM/ |
+----+----------+----------------+----+------------------------------------+
3 rows in set (0.00 sec)

mysql> quit
Bye
radius:/usr/local/etc/raddb# radtest john test localhost 1812 testing123
Sending Access-Request of id 213 to 127.0.0.1 port 1812
        User-Name = "john"
        User-Password = "test"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1812
Re-sending Access-Request of id 213 to 127.0.0.1 port 1812
        User-Name = "john"
        User-Password = "test"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1812
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=213, length=20
radius:/usr/local/etc/raddb# radtest maureen test localhost 1812 testing123
Sending Access-Request of id 219 to 127.0.0.1 port 1812
        User-Name = "maureen"
        User-Password = "test"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1812
Re-sending Access-Request of id 219 to 127.0.0.1 port 1812
        User-Name = "maureen"
        User-Password = "test"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1812
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=219, length=20
radius:/usr/local/etc/raddb#

Any other suggestions?

Yves
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060412/f8cc12c3/attachment.html>


More information about the Freeradius-Users mailing list