(RADIATOR) CallerID logging in AuthLog SQL

2003-01-15 Thread gordons
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)

Re: (RADIATOR) CallerID logging in AuthLog SQL

2003-01-15 Thread 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