We are using SQL database and Radonline table to record customers online information.
Also we set up our radius servers as a proxy for another Realm as well(for example abc.co.nz).
All works fine except our Radonline table records not only our customers online info
but also the proxied Realm customers online info.
Can I set up our Radonline only record our customers online info?
Here is part of my radius.cfg: ... <Handler Realm=abc.co.nz> RewriteUsername s/^([EMAIL PROTECTED]).*/$1/ <AuthBy RADIUS> Host xxx.xxx.xxx.xxx Secret xxxxxxx RetryTimeout 15 </AuthBy> </Handler>
<Handler Request-Type = Accounting-Request> RewriteUsername s/^([EMAIL PROTECTED]).*/$1/
<AuthBy EMERALD> # You can use this to force Radiator to limit # maximum session times to how many minutes # are left in subaccounts.timeleft DefaultSimultaneousUse 1 TimeBanking # Change DBSource, DBUsername, DBAuth for your database # See the reference manual DBSource dbi:xxx:server=xxx;database=xxx DBUsername xxxxxx DBAuth xxxxxxx
# You can add to or change these if you want.
AccountingTable Calls
AcctColumnDef UserName,User-Name
AcctColumnDef CallDate,Timestamp,integer-date
#AcctColumnDef CallDate,Timestamp,formatted-date,convert(datetime,'%b %e %Y %H:%M:%S',109)
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,Ascend-Disconnect-Cause,integer
# AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer
# AcctColumnDef NASIdentifier,NAS-Identifier
AcctColumnDef NASIdentifier,NAS-IP-Address
AcctColumnDef NASPort,NAS-Port,integer
AddATDefaults AuthSelect ,sa.LoginLimit AuthColumnDef 0,Simultaneous-Use,check </AuthBy>
# Log all accounting into daily log files AcctLogFileName /var/log/radius/log/%Y%m%d.act
</Handler>
<Handler> RewriteUsername s/^([EMAIL PROTECTED]).*/$1/ # If Platypus rejects the login, forward it to the old Radius server # AuthByPolicy ContinueUntilAccept ExcludeFromPasswordLog cisco root hal sritchie cbegg john jjcv PasswordLogFileName %L/password.log
<AuthBy EMERALD> # You can use this to force Radiator to limit # maximum session times to how many minutes # are left in subaccounts.timeleft DefaultSimultaneousUse 1 TimeBanking # Change DBSource, DBUsername, DBAuth for your database # See the reference manual DBSource dbi:xxx:server=xxx;database=xxx DBUsername xxx DBAuth xxx AddATDefaults AuthSelect ,sa.LoginLimit AuthColumnDef 0,Simultaneous-Use,check </AuthBy>
<AuthBy DBFILE> Filename %D/users </AuthBy>
<AuthBy FILE> Filename %D/users </AuthBy>
</Handler>
Lin
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 6/1/2003