(RADIATOR) Logging incorrect passwords with <Authlog SQL>

[Hugh Irvine]

Hello Nicolai -

Yes, you can use the %P special character to give you the decoded 
password in the SuccessQuery and/or FailureQuery (you may need to 
upgrade however - Radiator 3.1 is the latest release - and there are 
also some patches).

regards

Hugh


On Wednesday, August 14, 2002, at 10:39 PM, Nicolai van der Smagt wrote:

> Hello,
>
> Recently I moved our authentication logging to Authlog SQL. In the old
> setup we had a PasswordLogFileName %L/xxxx clause. When a user tried
> logging in with a bad password, the password that the user used was
> logged to the password logfile. This was nice because our users cannot
> change the passwords in their routers. We changed the password in the
> radius configuration, the router would come online, we changed the
> password in the router and the radius server back to the correct value
> -> problem solved.
> Is there a way to log the used password with Authlog SQL the way it
> worked with PasswordLogFileName?
>
> Radiator 2.19
>
> <AuthLog SQL>
>         Identifier Radmin_authlog
>         DBSource dbi:mysql:radmin
>         DBUsername radmin
>         DBAuth xxxxxxxx
>         Table RADAUTHLOG
>         SuccessQuery insert into RADAUTHLOG values ('%1','%t','%0','%n')
>         FailureQuery insert into RADAUTHLOG values ('%1','%t','%0','%n')
>         LogSuccess 1
> </AuthLog>
>
> Regards,
> --
> Nicolai van der Smagt   UNIX Support Engineer
> BBned NV.               PO Box 692
> 2130 AR Hoofddorp       phone +31 23 565 9999
>
> http://www.vandersmagt.nl/pgp-public-key.txt
>
> Silence! Or I shall replace you with a very small shell script!
>                                    - The Wizard of OS
>
>
--
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.