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