(RADIATOR) Proxying Accounting Packets
hugh at open.com.au
Sat Feb 28 01:12:33 CST 2004
Hello Erich -
You should use the following:
AcctColumnDef USERNAME, %u, formatted
See sections 6.2 and 6.28 in the Radiator 3.8 reference manual
On 28 Feb 2004, at 10:25, Erich Zigler wrote:
> Here's what I'm trying to do. I want to proxy the accounting packets
> to my
> customer's radius server, but I want to log them in my SQL database
> This is what I have so far...
> <Realm customersrealm.net>
> AuthByPolicy ContinueWhileReject
> <AuthBy SQL>
> DBSource dbi:mysql:radiator
> DBUsername radiator
> DBAuth xxxxxxx
> AccountingTable ACCOUNTING
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
> AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
> AcctColumnDef NASIDENTIFIER,NAS-Identifier
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> RewriteUsername s/^([^@]+).*/$1/
> <AuthBy RADIUS>
> Identifier Radius
> Host xxx.xxx.xxx.xxx
> Secret xxxxxx
> AuthPort 1645
> AcctPort 1646
> Retries 3
> It logs it correctly, however it only logs the username which I guess
> because of the RewriteUsername command. I moved the Rewriteusername
> to the bottom thinking it would on my accounting keep
> username at realm.com and
> just send the remote radius server username.
> This doesn't seem to be the case. How can I keep username at realm.com in
> accounting database and send username to the proxied radius server?
> 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.
NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
CATool: Private Certificate Authority for Unix and Unix-like systems.
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