(RADIATOR) AuthLog SQL Problem

[Keith Dornbusch]

I am using <AuthLog SQL> and not getting Passwords recorded. I have tried
the %3 and %P variables to no avail.  Can someone explain what is wrong
here.  The PasswordLogFileName does trap passwords.  Here are my config
statements and sample output.

--- config statement ---- 
 PasswordLogFileName %L/%RPWLOG
--- end config statement ---
--- output -----
Thu Apr 29 00:25:46 2004:1083216346:quailch1:UNKNOWN-CHAP:business:PASS
Thu Apr 29 00:25:47 2004:1083216347:rtgoldsby:rustyspur:rustyspur:PASS
Thu Apr 29 00:28:28 2004:1083216508:mlsojka:UNKNOWN-CHAP:1217lkd:PASS
Thu Apr 29 00:28:32 2004:1083216512:rtgoldsby:rustyspur:rustyspur:PASS
Thu Apr 29 00:28:33 2004:1083216513:mlsojka:UNKNOWN-CHAP:1217lkd:PASS
Thu Apr 29 00:29:53 2004:1083216593:quailch1:UNKNOWN-CHAP:business:PASS
--- end of output


--- config section -----
 <AuthLog SQL>
      DBSource
dbi:mysql:%{GlobalVar:MySQLDb}:%{GlobalVar:MySQLServer}:%{GlobalVar:MySQLPor
t}
      DBUsername %{GlobalVar:MySQLUser}
      DBAuth %{GlobalVar:MySQLPassword}
      Table radauthlog
#     Identifier authlogger
      LogSuccess 1
      SuccessQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, TYPE,
REASON, REQUESTPASSWORD, PRIORITY) values (%t, '%n', 1, 'Access Accepted',
'%P', %0)
      LogFailure 1
      FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, TYPE,
REASON, REQUESTPASSWORD, PRIORITY) values (%t, '%n', 0, %1, '%P', %0)
 </AuthLog>
--- end of config section ----
--- output ----
TIME_STAMP USERNAME TYPE REASON                         REQUESTPASSWORD
PRIORITY
1083216347 quailch1                 0     Expiration date has passed  NULL
NULL
1083216347 rtgoldsby               1     Access-Request Accepted  NULL
NULL
1083216508 mlsojka                 1     Access Accepted
Empty                             0
1083216512 rtgoldsby               1     Access-Request Accepted  NULL
NULL
1083216513 mlsojka                 1     Access Accepted
Empty                             0
1083216593 quailch1                0     Expiration date has passed  NULL
NULL
-- end of output ---
-- Table structure radauthlog ---
CREATE TABLE `radauthlog` (
  `TIME_STAMP` int(11) default NULL,
  `USERNAME` varchar(50) default NULL,
  `TYPE` int(11) default NULL,
  `REASON` varchar(50) default NULL,
  `REQUESTPASSWORD` varchar(50) default NULL,
  `PRIORITY` int(11) default NULL,
  KEY `USERNAME_I` (`USERNAME`)
) TYPE=MyISAM
-- end of table structure radauthlog ---






Thank you in Advance;
Keith Dornbusch / CTO
U.S. Choice, Inc.

--
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.