[RADIATOR] Account log to MySQL

[Hugh Irvine]

Hello Chad -

From what you show below, you have two “<Handler>” lines - if this is not a typo it will certainly confuse the configuration file parser.

The best way to debug is to set the Trace level to 4 (DEBUG) so you can see exactly what is happening.

You set the Trace level in the configuration file:


…..

Trace 4

…..


regards

Hugh


> On 4 Feb 2015, at 08:39, Chad Roseburg <croseburg at ncrl.org> wrote:
> 
> Goal:
> Capture successful logins as well as failures for stats purposes.
> 
> I am setting up logging to a local MySQL instance. Here's what I've done:
> 
> * Following instructions in the 'mysqlcreate.sql' file, I created the radius table and user(s). 
> * Created the Mysql tables using the provided 'mysqlCreate.sql' in goodies.
> * Added the following stanza to my Handler just below the SIP Authby stanza:
> 
> ---------- conf -------------
> <Handler>
> <Handler>
>        <AuthBy SIP2>
>                 Port   6001
>                 Host  siphost.com
>  
>                 Delimiter |
>  
>                 LoginUserID sipuser
>                 LoginPassword supersecret
>                 LocationCode Radiator
>  
>                  SendChecksum no
>                  VerifyChecksum no
>  
>                 NoDefault
>                 EAPType GTC
>         </AuthBy>
>         <AuthLog SQL>
>                 DBSource        dbi:mysql:radius:localhost
>                 DBUsername      radius
>                 DBAuth          secrets
>                 LogSuccess
>                 SuccessQuery    insert into RADAUTHLOG (TIME_STAMP, USERNAME, TYPE, REASON) values (%t, '%n', 1)
>                 LogFailure
>                 FailureQuery    insert into RADAUTHLOG (TIME_STAMP, USERNAME, TYPE, REASON) values (%t, '%n', 0, %1)
>         </AuthLog>
> </Handler>
> ------------------------------ /conf -------------------------------
> 
> I'm not seeing anything with:
> SELECT * FROM RADAUTHLOG;
> 
> Is it just a quiet day or am I missing something?
> 
> Last question is: does USERNAME refer to the client?
> 
> Thank you!
> 
> -- 
> Chad Roseburg
> Automation Dept.
> North Central Regional Library
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator


--

Hugh Irvine
hugh at open.com.au

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER, SIM, etc. 
Full source on Unix, Linux, Windows, MacOSX, Solaris, VMS, NetWare etc.