Hi there,
I have use the verison 2.14.1 with 5300 Networt Access Servers. Users are able to authanticate. Radiator also writes the stoponly accounting information to the accounting table (including the FRAMED-IP-ADDRESS). But I have a problem with radonline table, the FRAMED-IP-ADDRESS is not sent to the insert statement. And I cannot see the IP adresses of the online users. Do I have to do modifications on cisco side or is there a problem with my Radiator or should I do something on the .cfg file to get every connected users IP with snmpget???
PS: the version of the snmpget is UCD-snmp version:4.0.1
Tuncay Margilic
Siemens Business Services - Turkey
System Administrator
-----------------------------------------------------------------------------------------------------------------------------------------
<SessionDatabase SQL>
DBSource dbi:Oracle:radora
DBUsername radius
DBAuth ******
AddQuery insert into RADONLINE (USERNAME,NASIDENTIFIER,NASPORT,\
ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NASPORTTYPE,\
SERVICETYPE) values ('%U','%{NAS-IP-Address}',%{NAS-Port},'%{Acct-Session-Id}',\
%{Timestamp},'%{Framed-IP-Address}','%{NAS-Port-Type}','%{Framed-Protocol}')
</SessionDatabase>
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
AccountingStopsOnly
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time
AcctColumnDef ACCTTERMINATECAUSE,Ascend-Disconnect-Cause,integer
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDADDRESS,Framed-IP-Address
AcctColumnDef CALLERID,Calling-Station-Id
AcctColumnDef DATARATE,Ascend-Data-Rate,integer
AcctColumnDef XMITRATE,Ascend-Xmit-Rate,integer
AcctColumnDef CLIENTDNIS,Called-Station-Id
AcctColumnDef LOGDATE,Timestamp,integer-date
-----------------------------------------------------------------------------------------------------------------------------------------
