Freeradius, mysql, please help!!!

[A.L.M.Buxey at lboro.ac.uk]

Hi,

> I've created some testusers in de mysql database as well (sorry for layout,
> pasting from the shell)
> mysql> select * from radcheck;
> +----+----------+---------------+----+------------------------------------+
> | id | UserName | Attribute     | op | Value                              |
> +----+----------+---------------+----+------------------------------------+
> |  1 | steve    | User-Password | := | $1$nyiGAEuR$5wcFr5bT7SfkVjIChnbZo0 |
> |  2 | maureen  | User-Password | := | $1$LTvKoOtc$X2fVg8uDqyP4.mU.iLNKm0 |
> |  3 | john     | User-Password | := | $1$bkW9WNor$tq5sRRiUcwOV4/fwk3CYM/ |
> +----+----------+---------------+----+------------------------------------+
> 
> Though when i try to authenticate john (or other from de db),
> i get a reject packet and i don't know why!
> 
> radius:/var/log/radius# radtest john test localhost 1812 testing123
> Sending Access-Request of id 240 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 240 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=240, length=20
> radius:/var/log/radius#

ummm. I'm not too certain here but wasnt the password you defined in the
mySQL database for john $1$bkW9WNor$tq5sRRiUcwOV4/fwk3CYM/
if this is a crypted password then surely the attribute is Crypt-Password
rather than User-Password?

alan