CHAP authentication + FreeRadius + SQL

2009-02-18 Thread Marcelo Freitas 
Hello,

I'm trying to authenticate users using CHAP and store the passwords in the SQL, 
but I'm having a hard time.

I checked past messages, but I still couldn't get it to work ... Below is my 
Access-Request packet

Wed Feb 18 12:31:04 2009
Packet-Type = Access-Request
NAS-Port-Type = Wireless-802.11
Calling-Station-Id = 000E2EEB1D91
Called-Station-Id = hotspot1
NAS-Port-Id = wHotSpotB
User-Name = admin2
NAS-Port = 2153775219
Acct-Session-Id = 80600073
Framed-IP-Address = 10.5.50.253
Mikrotik-Host-IP = 10.5.50.253
CHAP-Challenge = 0x4f0299d5a5107ded915739e236f71e3c
CHAP-Password = 0x606707e3411f443140573554283c987ca5
Service-Type = Login-User
WISPr-Logoff-URL = http://10.5.50.1/logout;
NAS-Identifier = AP_HQ
NAS-IP-Address = 10.0.1.130

In MySQL I just have Cleartext-Password == admin2 for check items ... But I 
always get Access-Reject.

Before checking the past messages, I had already check items like Auth-Type := 
CHAP, Cleartext-Password == admin2; and also just CHAP-Password, but none of it 
worked ...

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

Re: CHAP authentication + FreeRadius + SQL

2009-02-18 Thread Nicolas Goutte 


Am 18.02.2009 um 16:39 schrieb Marcelo Freitas:


Hello,

I'm trying to authenticate users using CHAP and store the passwords  
in the SQL, but I'm having a hard time.


I checked past messages, but I still couldn't get it to work ...  
Below is my Access-Request packet


Wed Feb 18 12:31:04 2009
Packet-Type = Access-Request
NAS-Port-Type = Wireless-802.11
Calling-Station-Id = 000E2EEB1D91
Called-Station-Id = hotspot1
NAS-Port-Id = wHotSpotB
User-Name = admin2
NAS-Port = 2153775219
Acct-Session-Id = 80600073
Framed-IP-Address = 10.5.50.253
Mikrotik-Ho! st-IP = 10.5.50.253
CHAP-Challenge = 0x4f0299d5a5107ded915739e236f71e3c
CHAP-Password = 0x606707e3411f443140573554283c987ca5
Service-Type = Login-User
WISPr-Logoff-URL = http://10.5.50.1/logout;
NAS-Identifier = AP_HQ
NAS-IP-Address = 10.0.1.130

In MySQL I just have Cleartext-Password == admin2 for check  
items ... But I always get Access-Reject.


Before checking the past messages, I had already check items like  
Auth-Type := CHAP, Cleartext-Password == admin2; and also just CHAP- 
Password, but none of it worked ...


Try to use := for Cleartext-Password instead of  == (Thing about  
assigning the password, instead of comparing it.)





Thanks in advance,

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



Have a nice day!

Nicolas Goutte


extragroup GmbH - Karlsruhe
Waldstr. 49
76133 Karlsruhe
Germany

Geschäftsführer: Stephan Mönninghoff, Hans Martin Kern, Tilman Haerdle
Registergericht: Amtsgericht Münster / HRB: 5624
Steuer Nr.: 337/5903/0421 / UstID: DE 204607841



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