[RADIATOR] Account log to MySQL

Hugh Irvine hugh at open.com.au
Tue Feb 3 19:30:21 CST 2015


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.



More information about the radiator mailing list