(RADIATOR) Need to log reject-reason.

[Hugh Irvine]

Hello Sergio -

As far as I can see in the code, %1 should be the reject reason, so 
your query looks correct.

Can you send me a copy of your configuration file (no secrets) and a 
trace 4 debug showing what is happening and what gets logged in the 
RADAUTHLOG table?

regards

Hugh


On Saturday, Oct 4, 2003, at 06:42 Australia/Melbourne, Sergio Gonzalez 
wrote:

> Hello.
>
>
> I'm trying to log the reject-reason when a user can't login. I use 
> AuthLog SQL and this is the failure query:
>
> FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, TYPE, 
> REASON) values (%t, '%U', 0, %1)
>
> Every time a user mistype his pasword, the entry is inserted into the 
> RADAUTHLOG table as "Bad Password" reason, but; ¿how do I log the 
> entry when the user exceeds his simultaneous use or when a portlimit 
> is reached? (I have DefaultSimultaneousUse 1 in the AuthBy, and ? want 
> to use the same AuthLog for another realms which use portlimits.
>
>
> Thanks a lot in advance.
>
>
> Regards
>
> Sergio Alejandro Gonzalez
> Director Operativo
> Network and Services Field Manager
> SkyNet de Colombia.
> Calle 100 No. 8A-55 Of. 711
> Bogota, Cundinamarca
> Colombia, South America.
> Tel: 57 (+1) 6 422 020
> Cel: 57 (+3)/(03315) 3551034
> Pager: 5405555, 3469999 Cod 2010
>
> ===
> 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.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, 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.