Hello Chris, Friday, April 19, 2002, 6:14:12 PM, you wrote:
CP> At 12:17 PM 4/19/2002 +0400, rust wrote: >>Hello freeradius-users, >> >> >>I build pppd with radius.so plugin and it work with freeradius and PAP >>auth with >>encrypted passwords in mysql base. >>Now I need authorize and accounting pptp with freeradius+mysql+ms-chap2 >> >>I add user "rust" with pass "qwerty" in table radcheck in database radius >> >>-------------------------------------------------------------------------------- >> >> id UserName Attribute Value >> 1 rust LM-Password 598DDCE2660D3193AAD3B435B51404EE CP> You should add an Auth-Type := MS-CHAP ( don't forget about the operator CP> column ). What must be in op. column?? I change from authorize { preprocess suffix mschap sql } to authorize { preprocess suffix sql mschap } Table radcheck in database radius -------------------------------------------------------------------------------- id UserName Attribute Value op 1 rust Password 598DDCE2660D3193AAD3B435B51404EE and i have now: Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on 1814/udp. Ready to process requests. rad_recv: Access-Request packet from host 192.168.200.1:4539, id=57, length=132 Service-Type = Framed-User Framed-Protocol = PPP User-Name = "rust" MS-CHAP-Challenge = 0x57f059a9234695cc18e4d76872562e67 MS-CHAP2-Response = 0x01001a4875d0fee41ae7e7d3f73ac484e78f0000000000000000292ed1a9b338633ff19c2f260e8a83e20bfa83de3f8624bb NAS-IP-Address = 127.0.0.1 NAS-Port = 1 modcall: entering group authorize modcall[authorize]: module "preprocess" returns ok modcall[authorize]: module "suffix" returns ok radius_xlat: 'rust' sql_escape in: 'rust' sql_escape out: 'rust' sql_set_user: escaped user --> 'rust' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'rust' ORDER BY id' rlm_sql: Reserving sql socket id: 4 SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'rust' ORDER BY id radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'rust' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'rust' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'rust' ORDER BY id' SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'rust' ORDER BY id radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'rust' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'rust' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id radius_xlat: 'SELECT Value,Attribute FROM radcheck WHERE UserName = 'rust' AND ( Attribute = 'User-Password' OR Attribute = 'Password' OR Attribute = 'Crypt-Password' ) ORDER BY Attribute DESC' SELECT Value,Attribute FROM radcheck WHERE UserName = 'rust' AND ( Attribute = 'User-Password' OR Attribute = 'Password' OR Attribute = 'Crypt-Password' ) ORDER BY Attribute DESC rlm_sql: Released sql socket id: 4 modcall[authorize]: module "sql" returns ok modcall[authorize]: module "mschap" returns ok modcall: group authorize returns ok rad_check_password: Found Auth-Type MS-CHAP auth: type "MS-CHAP" modcall: entering group authenticate modcall[authenticate]: module "mschap" returns reject modcall: group authenticate returns reject auth: Failed to validate the user. Delaying request 0 for 1 seconds Finished request 0 Going to the next request What wrong?? -- Best regards, rust mailto:[EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html