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,
[EMAIL PROTECTED] 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
