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.
