radius server 2.1.6 not storing data in radacct table..help
shivashankar
c.shivashankar at gmail.com
Fri Aug 21 11:14:27 CEST 2009
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..help-tp25075955p25075955.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
More information about the Freeradius-Users
mailing list