(RADIATOR) AuthLog SQL Problem

[Hugh Irvine]

Hello Keith -

I think I need to see a bit more of the configuration file and a more  
complete trace 4 debug showing what is happening.

regards

Hugh


On 29 Apr 2004, at 22:58, Keith Dornbusch wrote:

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

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.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

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