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: [EMAIL PROTECTED] / W3: www.g4.net

Reply via email to