(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