(RADIATOR) Authlog SQL question

R.H.Hoek r.h.hoek at utwente.nl
Thu Oct 5 09:51:00 CDT 2006


Dear All,

We want to log authentication successes and failures into an SQL dB.
For that purpose we use the next config:

<AuthLog SQL>
   Identifier authlogging-wlan-sql
   DBSource        dbi:Oracle:xxxx
   DBUsername      yyyyy
   DBAuth          zzzzz
   LogSuccess
   SuccessQuery insert into RADAUTHLOG (TIMESTAMP, SERVER, NAS,
USERNAME, USER_RAW, SERVICE, RESULT, REASON, TUNNELED,
CALLINGSTATION) values (%t, '%h', '%c', %2, %4, 'WLAN', 'success',
%1, '%{Handler:Identifier}', replace('%{Calling-Station-Id}', '.'))
   LogFailure
   FailureQuery insert into RADAUTHLOG (TIMESTAMP, SERVER, NAS,
USERNAME, USER_RAW, SERVICE, RESULT, REASON, TUNNELED,
CALLINGSTATION) values (%t, '%h', '%c', %2, %4, 'WLAN', 'failure',
%1, '%{Handler:Identifier}', replace('%{Calling-Station-Id}', '.'))
</AuthLog>

<Handler
Realm=utwente.nl,Client-Identifier=/^WLAN-ID$|^LOCALHOST-ID$/,
TunnelledByTTLS=0>
        <AuthBy FILE>
                EAPType TTLS
        .
        .
        </AuthBy>
        Identifier INNER
        AuthLog authlogging-wlan-sql
</Handler>

Question: Is there a way to log handler attributes into SQL, such as
Client-Identifier, Realm and TunnelledByTTLS ?
Or is it possible to define more 'Identifiers' (or LocalVar's) ?



-- 

Groeten,

Roel H.Hoek, Netwerkbeheer
Dienst Informatietechnologie, Bibliotheek en Educatie (ITBE)
Universiteit Twente,  Postbus 217,  7500 AE  Enschede
kmr SP 422, telefoon: 053 - 489 4598,  fax: 053 - 489 2383
e-mail: r.h.hoek at utwente.nl http://www.utwente.nl/itbe
IM-Jabber: rhhoek at gmail.com


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


More information about the radiator mailing list