(RADIATOR) CallerID logging in AuthLog SQL

[Hugh Irvine]

Hello Gordon -

You will need to modify your RADAUTHLOG table first to include the 
column, then do something like this:

  FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, REASON, 
CALLINGSTATIONID)
values (%t, '%n', 0, %1, %{Calling-Station-Id})

You will find the list of attributes in the dictionary file included in 
the distribution (the file called "dictionary").

Here are the definitions for both Calling-Station-Id and 
Called-Station-Id from the dictionary:

ATTRIBUTE       Called-Station-Id               30      string
ATTRIBUTE       Calling-Station-Id              31      string

regards

Hugh


On Thursday, Jan 16, 2003, at 09:54 Australia/Melbourne, 
<gordons at morenet.net.nz> wrote:

> Hi all,
>
> I have a problem - I want to include Calling-Station-ID in my AuthLog
> table.
> Unfortunately, I can't find the correct attribute to include in the SQL
> statement to do so.
>
> I have the standard:
>
>  FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, REASON)
> values (%t, '%n', 0, %1)
>
> Does anyone know the value to insert for callerid? It's not in the
> attributes table in the manual...
>
> Cheers,
>
> Gordon Smith  CCNA
> Network Operations Manager
>
> MoreNet Ltd
>
> PGP Fingerprint: 8303 3372 E226 08C2 8A42 4188 D9E1 D2F5 832E 67C5
>
>
>
>
> ===
> 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.