Hi,
We have another problem which can be solved this way. But I'm not sure.
We have some POP's on different cities which are connected to our main location with point to point leased lines. Sometimes because of telco problems we loose connection to this POP's. At this moment if some user disconnects of course we don't have the stop record. Is it possible to use this setting (in such situation) to insert stop records to the accounting table.
Regards
Lutfi Yunusoglu
Siemens Business Services
System Administrator
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Aaron Holtz
Sent: Friday, February 11, 2000 2:54 PM
To: Tuncay MARGILIC
Cc: [EMAIL PROTECTED]
Subject: Re: (RADIATOR) Framed-IP-Address on Radonline
You need to add the following statement to your Cisco (and you may want to
have it send stop records only as this statement can basically replace
your Start record.):
aaa accounting update newinfo
This will include the Framed-IP after the PPP stream is started. Since
you end up with 2 records with this statement, you can have the Cisco only
send Stop records and use this Alive record (as it will be called in the
logs) to get the info you want. Radiator is built to handle these packets
and will update your radonline table with the information.
--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------
On Feb 11, Tuncay MARGILIC molded the electrons to say....
>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
>----------------------------------------------------------------------------
>-------------------------------------------------------------
>
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
