-----Original Message----- From: freeradius-users-bounces@lists.freeradius.org [mailto:freeradius- users-bounces@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Wednesday, 5 October 2005 1:48 AM To: FreeRadius users mailing list Subject: Re: MSCHAPv2, MySQL, Freeradius

"Dan Russell" <dan@in-house.com.au> wrote:

...

Hey, I'm not having a go at you, I believe it does work, I'm just having issue getting it working..

Yes, but too many people post messages saying "Stuff went wrong... how do I fix it?". Without any context, the only possible answer is "No idea..."

...

Tue Oct 4 15:10:39 2005 : Info: rlm_sql (sql): No matching entry in the database for request from user [wolfer]

Well, that would appear to be useful.

...

Here is a snippet of the radcheck table :

ID UserName Attribute op Value 25 wolfer SMB-Account-CTRL == 16 27 wolfer NT-Password == 0x47C8F8E50C470E37AAD3B435B51404EE

See the docs for rlm_sql. '==' is a *comparison* operator. There is no NT-Password in the packet, so of course it never matches.

Change both '==' to ':='.

Alan DeKok.

That's fixed it.. All works well now.. Thanks for your help. Daniel Russell

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html