Oracle accounting

[Ayman Alashquar]

ï We are using the Oracle database for storing the FreeRadius accounting data. Can the SQL queries/updates in the oraclesql.conf be customized ? Another thing, in the RADACCT table, how to differentiate between the "START" and "STOP" records ? the record status field is not stored!     Many thanks Ayman Alashquar -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Truong Manh Cuong Sent: 17/02/2004 12:32 Ù To: [EMAIL PROTECTED] Subject: Realm -> no response configured 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 ---