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
