(RADIATOR) Failed Attempts, Time::HiRes

[Hugh Irvine]

Hello Dan -

On Wed, 1 May 2002 06:16, Dan Melomedman wrote:
> Hi.
>
> A few questions:
>
> How to log failed attempts to an SQL database?
> The table will look something like this:
>
> Column_name            Type      Length       Nullable
>  ---------------------- --------- -----------  -----------
> LoggedAt               datetime  8            yes
> User_Name              varchar   255          yes
> NAS_IP_Address         varchar   255          yes
> Authen_Failure_Reason  varchar   255          yes
> Author_Failure_Reason  varchar   255          yes
> Caller_ID              varchar   255          yes
> NAS_Port               varchar   255          yes
> Source_NAS             varchar   255          yes
> Description            varchar   255          yes
>

You would use the AuthLog SQL clause and define your own FailureQuery.

See section 6.50 in the Radiator 3.0 reference manual.
("doc/ref.html").

>
> I also installed the Time::HiRes module, but Radiator refuses to log with
> microseconds without any warning messages. Yes, I restarted the server
> completely, instead of SIGHUP.
>

On each of the lines that show the Timestamps you will see a six digit number 
after the year (see below) which is the number of microseconds.

Wed May  1 10:31:15 2002 795300: DEBUG: Handling with Radius::AuthGROUP

In this example '795300' is the number of microseconds.

> Also, some attributes are not found in the dictionary, I am using 'ascend2'
> in addition to 'dictionary'. I suspect these are proprietary Cisco
> attributes which are in the packet trace. Should I worry about this, or
> what's a quick and dirty method of disabling these error messages so they
> do not fill up the log? Thanks.

Please send me a trace 5 hex dump showing these attributes and I will take a 
look to see what they are.

regards

Hugh


-- 
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.