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
signature.asc
Description: This is a digitally signed message part