|
I add realm cuong {} to /raddb/proxy.conf. User account is stored in postgres database The log report: no response configured, reject. I login using [EMAIL PROTECTED], but in
postgresql, there is only user tmcuong. How can radius authenticate this user -> accept connect
and write Realm value to Realm field of radacct table ? Please give me some helps, Thanks a lot. Manh Cuong. --- Walking the entire request list --- Cleaning up request 1 ID 16 with timestamp 4031d058 Nothing to do. Sleeping until we see
a request. rad_recv:
Access-Request packet from host 172.16.67.93:1152, id=17, length=70
User-Name = "[EMAIL PROTECTED]" User-Password
= "tmcuong"
NAS-Port = 0
Acct-Session-Time = 225
Session-Timeout = 0 modcall: entering
group authorize for request 2 modcall[authorize]:
module "preprocess" returns ok for request 2 rlm_realm: Looking up realm "card" for User-Name
= "[EMAIL PROTECTED]" rlm_realm: Found realm "card" rlm_realm: Adding Stripped-User-Name = "tmcuong" rlm_realm: Proxying request from
user tmcuong to realm card rlm_realm: Adding Realm = "card" rlm_realm: Preparing to proxy authentication request to
realm "card" modcall[authorize]:
module "suffix" returns updated for request 2 radius_xlat: 'tmcuong' rlm_sql (sql): sql_set_user escaped user
--> 'tmcuong' radius_xlat: 'SELECT id, UserName,
Attribute, Value, Op ??FROM radcheck ??WHERE Username = 'tmcuong' ??ORDER BY id' rlm_sql (sql): Reserving sql socket id: 2 rlm_sql_postgresql: query:
SELECT id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE Username = 'tmcuong'
??ORDER BY id rlm_sql_postgresql: Status:
PGRES_TUPLES_OK rlm_sql_postgresql: affected
rows = radius_xlat: 'SELECT radgroupcheck.id,
radgroupcheck.GroupName, ??radgroupcheck.Attribute, radgroupcheck.Value,radgroupcheck.Op ??FROM radgroupcheck,
usergroup
??WHERE usergroup.Username = 'tmcuong' AND usergroup.GroupName
= radgroupcheck.GroupName ??ORDER BY radgroupcheck.id' rlm_sql_postgresql: query:
SELECT radgroupcheck.id, radgroupcheck.GroupName, ??radgroupcheck.Attribute, radgroupcheck.Value,radgroupcheck.Op
??FROM radgroupcheck, usergroup ??WHERE usergroup.Username = 'tmcuong'
AND usergroup.GroupName = radgroupcheck.GroupName ??ORDER
BY radgroupcheck.id rlm_sql_postgresql: Status:
PGRES_TUPLES_OK rlm_sql_postgresql: affected
rows = radius_xlat: 'SELECT id, UserName,
Attribute, Value, Op ??FROM radreply ??WHERE Username = 'tmcuong' ??ORDER BY id' rlm_sql_postgresql: query:
SELECT id, UserName, Attribute, Value, Op ??FROM radreply ??WHERE Username = 'tmcuong'
??ORDER BY id rlm_sql_postgresql: Status:
PGRES_TUPLES_OK rlm_sql_postgresql: affected
rows = radius_xlat: 'SELECT radgroupreply.id,
radgroupreply.GroupName, radgroupreply.Attribute, ??radgroupreply.Value, radgroupreply.Op
??FROM radgroupreply,usergroup
??WHERE usergroup.Username = 'tmcuong'
AND usergroup.GroupName = radgroupreply.GroupName ??ORDER
BY radgroupreply.id' rlm_sql_postgresql: query:
SELECT radgroupreply.id, radgroupreply.GroupName,
radgroupreply.Attribute, ??radgroupreply.Value, radgroupreply.Op ??FROM radgroupreply,usergroup
??WHERE usergroup.Username = 'tmcuong'
AND usergroup.GroupName = radgroupreply.GroupName ??ORDER
BY radgroupreply.id rlm_sql_postgresql: Status:
PGRES_TUPLES_OK rlm_sql_postgresql: affected
rows = rlm_sql (sql): Released sql socket id: 2 modcall[authorize]:
module "sql" returns ok for request 2 users: Matched DEFAULT at 152 modcall[authorize]:
module "files" returns ok for request 2 modcall: group
authorize returns updated for request 2 There was no response configured: rejecting request 2 Server rejecting request 2. Finished request 2 Going to the next request --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Sending Access-Reject of id 17 to 172.16.67.93:1152 Waking up in 4 seconds... --- Walking the entire request list --- |
- Oracle accounting Truong Manh Cuong
- Oracle accounting Ayman Alashquar
- Re: Oracle accounting Alan DeKok

