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