Problem getting FR/MySQL to work with CHAP

[Kevin Bonner]

On Thursday 09 June 2005 08:26, Rens Houben wrote:
> radius_xlat:  'SELECT id,UserName,Attribute,Value,op
> 	FROM radcheck WHERE Username = 'testflex at systemec.nl' ORDER BY id'
>
> * This returns the following data when run in a mysql shell:
> +-----+----------------------+----------------+-------+------+
>
> | id  | UserName             | Attribute      | Value | op   |
>
> +-----+----------------------+----------------+-------+------+
> | 186 | testflex at systemec.nl | Password       | ----- | ==   |
> | 271 | testflex at systemec.nl | CHAP-Challenge | ----- | ==   |
> | 272 | testflex at systemec.nl | Auth-Type      | Local | :=   |
> +-----+----------------------+----------------+-------+------+
> (password and challenge secret changed for security purposes)

First suggestion, upgrade to 1.0.4 (when it's released).

Auth-Type isn't necessary.  Also, I don't think CHAP-Challenge should be 
listed there.  The only attribute you should need in the db for CHAP auth is 
User-Password.

Kevin Bonner
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20050609/83e20eea/attachment.pgp>