(RADIATOR) logging IPASS accounting records to Database

[Ayotunde Itayemi]

Hi Hugh, Hi All,

I would like to log only IPASS accounting start and stop request to a database
table so as to get some sort of record locally - how can I implement this?
I want something a little bit "simpler" than the long detail file generated by 
the AcctLogFileName clause (see below pls). One can more easily peruse
entries in an Oracle table.

Regards,
Tunde Itayemi.


Relevant parts of my config :

<Client localhost>
    # ipass client for VNAS (incoming metrong roamers)
        Secret
        Identifier ipassclient
        IdenticalClients 63.10.10.212
        RewriteUsername s/^IPASS\/([^@]+)\@([^@]+)$/IPASS\/$1#$2\@myipass/
</Client>

<AuthBy RADIUS>
        Identifier      ipassNetserver
        Host            63.10.10.211
        Secret          
        AuthPort        11812
        AcctPort        11813
        AddToRequest Called-Station-Id=%{Called-Station-Id}, NAS-IP-Address=%N
        DefaultSimultaneousUse 1
</AuthBy>

<Handler Realm=myipass>
        AcctLogFileName  %L/ipass/detail
        RewriteUsername  s/^IPASS\/([^#]+)\#([^@]+)\@myipass$/IPASS\/$1\@$2/
        AuthBy ipassNetserver
</Handler>

<Handler Client-Identifier=ipassclient>
        AuthByPolicy ContinueWhileAccept
        RewriteUsername s/^([^@]+).*/$1/
        RewriteUsername tr/A-Z/a-z/
        UsernameCharset a-zA-Z0-9\._ at -
        AcctLogFileName         %L/account.log
        PasswordLogFileName     %L/password.log
        SessionDatabase SDB1
        AuthBy SQLClientauth
        StripFromReply Framed-IP-Address
</Handler>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20030115/7c9dad0d/attachment.html>