(RADIATOR) AuthBy Group Question

Tom Daly tom at g4.net
Fri Dec 21 18:26:08 CST 2001


Hi Guys,
I am using radiator as a proxy server for Wholesale Dialup. Here's what I would like to do.

When a user makes a request, the request is proxied off to a remote radius server. At the same time, a call log entry is entered into a SQL server that I maintain. I am trying to accomplish this through the following:

<AuthBy GROUP>
        Identifier NetwayAuthDNIS
        RewriteUsername s/^NETWAY\/(.*)$/$1/
        AuthByPolicy ContinueAlways
        <AuthBy EMERALD>
                DBSource        dbi:FreeTDS:database=Radius;host=xxx.xxx.xxx.xxx;port=1433
                DBUsername      xxx
                DBAuth          xxx
                
                # You can add to or change these if you want.
                AccountingTable netwaycalls
                AcctColumnDef   UserName,User-Name
                AcctColumnDef   CallDate,Timestamp,integer-date
                AcctColumnDef   AcctStatusType,Acct-Status-Type,integer
                AcctColumnDef   AcctDelayTime,Acct-Delay-Time,integer
                AcctColumnDef   AcctInputOctets,Acct-Input-Octets,integer
                AcctColumnDef   AcctOutputOctets,Acct-Output-Octets,integer
                AcctColumnDef   AcctSessionId,Acct-Session-Id
                AcctColumnDef   AcctSessionTime,Acct-Session-Time,integer
                AcctColumnDef   AcctTerminateCause,Acct-Terminate-Cause,integer
                AcctColumnDef   NASIdentifier,NAS-IP-Address
                AcctColumnDef   NASPort,NAS-Port,integer
                AcctColumnDef   UserService,Service-Type,integer
                AcctColumnDef   FramedProtocol,Framed-Protocol,integer
                AcctColumnDef   FramedAddress,Framed-IP-Address
                AcctColumnDef   NASPortType,NAS-Port-Type,integer
                AcctColumnDef   NASPortDNIS,Called-Station-Id
                AcctColumnDef   CallerID,Calling-Station-Id
                
                AuthSelect
        </AuthBy>

        <AuthBy RADIUS>
                Host xxx.xxx.xxx.xxx
                Host yyy.yyy.yyy.yyy
                Secret zzz
                AuthPort 1645
                AcctPort 1646
                Retries 2
                RetryTimeout 30
                FailureBackoffTime 60
        </AuthBy>
</AuthBy>

However, this does not put entries into my SQL database.

Any ideas?

Thanks,

-- 
Tom Daly
Network Operations / Systems Administrator
G4 Communications Corp.
V: 603.296.4413 / F: 603.647.7576
E: tom at g4.net / W3: www.g4.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20011221/2ca0dcfa/attachment.html>


More information about the radiator mailing list