(RADIATOR) RADMIN and radius

[Hugh Irvine]

Hello Lloyd -

If you specify an AuthBy RADMIN together with a SessionDatabase SQL, the 
management of the RADONLINE table is done automatically using the accounting 
requests from the NAS.

Here is the relevant section from the manual:

  6.7.3 AddQuery

  This SQL statement is executed whenever a new user session starts (i.e. 
when an Accounting-Request Start message is received). It is expected to 
record the details of the new session in the SQL database. Special formatting 
characters may be used (the %{attribute} ones are probably the most useful). 
If AddQuery is defined as an empty string, then the query will not be 
executed.

  It defaults to:  insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, \
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, \
SERVICETYPE) values ('%u', '%N', 0%{NAS-Port}, '%{Acct-Session-Id}',\
 %{Timestamp}, '%{Framed-IP-Address}', '%{NAS-Port-Type}', \
'%{Service-Type}')

If you want to include the DNIS (Called-Station-Id), you will have to modify 
the RADONLINE table and change the default AddQuery (shown above).

regards

Hugh


On Friday 14 September 2001 17:08, lloyd dagoc wrote:
> hi to everybody,
>
> im a little bit confused as to where or who does the update of the
> RADONLINE table in the radmin database...we never included the update
> RADONLINE statement in our radius.cfg...any ideas? is the NAS responsible
> on this? if it is responsible, how come they never include the DNIS of the
> user in our RADONLINE database? any ideas?
>
> thanks
> lloyd dagoc
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.