hi, I have installed freeradius2.1.6 recently. Radius server was started successfully. But when i sent a packet using NTRadping its stored in file but not writing in oracle. when i run radiusd-X --few lines here ---------- [sql] expand: %{User-Name} -> free [sql] sql_set_user escaped user --> 'free' [sql] expand: INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay, XAscendSessionSvrKey) VALUES('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port-Id}', '%{NAS-Port-Type}', TO_DATE('%S','yyyy-mm-dd hh24:mi:ss'), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0', '%{X-Ascend-Session-Svr-Key}') -> INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAu rlm_sql (sql): Reserving sql socket id: 3 rlm_sql_oracle: execute query failed in sql_query: ORA-01400: cannot insert NULL into ("RADIUSUSER"."RADACCT"."GROUPNAME") rlm_sql_oracle: OCI_SERVER_NORMAL [sql] Couldn't insert SQL accounting START record - ORA-01400: cannot insert NULL into ("RADIUSUSER"."RADACCT"."GROUPNAME") [sql] WARNING: Deprecated conditional expansion ":-". See "man unlang" for details in radacct table we have GROUPNAME is not null.. i entered data in all tables except radgroupcheck table. i need to enter ....data in this table also. plz help me. -- View this message in context: http://www.nabble.com/radius-server-2.1.6-not-storing-data-in-radacct-table.... Sent from the FreeRadius - User mailing list archive at Nabble.com.