Well, what you don't know in a brand new Alive/Start packet is information
about lost Stop records. Anything from the time of the lost record (which
may or may not be a big deal) to the radius accounting ID assigned to the
session (which again, may or may not be important.) Radiator tries to be
self healing in that if a new person comes on and gets a modem of someone
in the database, it removes them and then inserts the new user. Radiator
can also query the remote NAS unit to verify a user's connection and take
action from there. Maybe you might want to check that out. Although with
a little hacking, I'm sure a preclienthook or preauthhook could do a
little logic and magic on your radonline database and remove bad entries
to avoid contacting the NAS unit.
--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------
On Feb 11, Lutfi YUNUSOGLU molded the electrons to say....
>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.
>
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
