Hi All,
I'm using sql module to authorize and authenticate users from Oracle
database. I'm trying to use PAP module to change the encryption type
used for password but it does not work. I tried to define the
authentication type in users file and included the files module in
authorization. I used PAP in authentication and changed the
"encryption_scheme = md5" in the radiusd.conf. In all cases I get an
Access-Accept and unix crypt encryption-scheme.
The debug mode run gives the following:
Sat Oct 26 05:40:09 2002 : Debug: radius_xlat: 'SELECT
id,user_id,Attribute,pwd_Value, op FROM user_profile_new WHERE user_id =
'eim101' AND Status = 'W' ORDER BY id'
Sat Oct 26 05:40:09 2002 : Debug: rlm_sql: Reserving sql socket id: 3
Sat Oct 26 05:40:09 2002 : Debug: radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
pcheck.Value,radgroupcheck.op FROM radgroupcheck WHERE
radgroupcheck.GroupName = '4014444' ORDER BY radgroupcheck.id'
Sat Oct 26 05:40:09 2002 : Debug: radius_xlat: 'SELECT 0
id,User_id,Attribute_name,Attribute_Value, '' op FROM
user_attributes_new WHERE User_id = 'eim101''
Sat Oct 26 05:40:09 2002 : Debug: radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
preply.Value,radgroupreply.op FROM radgroupreply WHERE
radgroupreply.GroupName = '4014444' ORDER BY radgroupreply.id'
Sat Oct 26 05:40:09 2002 : Debug: rlm_sql: check items
Sat Oct 26 05:40:09 2002 : Debug: Crypt-Password = "cUTAc33b3ghLs"
Sat Oct 26 05:40:09 2002 : Debug: rlm_sql: reply items
Sat Oct 26 05:40:09 2002 : Debug: Tunnel-Client-Endpoint:0 =
"195.170.195.15"
Sat Oct 26 05:40:09 2002 : Debug: Tunnel-Medium-Type:0 = IP
Sat Oct 26 05:40:09 2002 : Debug: Tunnel-Password:0 = "test"
Sat Oct 26 05:40:09 2002 : Debug: Tunnel-Server-Endpoint:0 =
"194.170.127.254"
Sat Oct 26 05:40:09 2002 : Debug: Tunnel-Type:0 = L2TP
Sat Oct 26 05:40:09 2002 : Debug: rlm_sql: Released sql socket id: 3
Sat Oct 26 05:40:09 2002 : Debug: modcall[authorize]: module "sql"
returns ok
Sat Oct 26 05:40:09 2002 : Debug: modcall: group authorize returns ok
Sat Oct 26 05:40:09 2002 : Debug: rad_check_password: Found Auth-Type
PAP
Sat Oct 26 05:40:09 2002 : Debug: auth: type Crypt
Sat Oct 26 05:40:09 2002 : Debug: modcall: entering group session
Sat Oct 26 05:40:09 2002 : Debug: modcall[session]: module "radutmp"
returns ok
Sat Oct 26 05:40:09 2002 : Debug: modcall: group session returns ok
Sending Access-Accept of id 32 to 194.170.195.10:38226
I want to know how to control the authentication once using sql module.
Regards,
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
