Here is the profile
bash-3.2# cat radius.cfg LogStdout LogDir /opt1/log LogFile %L/logfile-%Y-%m-%d DictionaryFile /etc/radiator/dictionary #DbDir . DbDir /etc/radiator #WINCHHook file:"%D/dump" # User a lower trace level in production systems: Trace 4 AuthPort 1816 AcctPort 1817 BindAddress 212.119.64.103 RewriteUsername tr/A-Z/a-z/ # You will probably want to add other Clients to suit your site, # one for each NAS you want to work with <Client 212.119.67.25> Secret JuiI76Tgy </Client> # Handler for Accounting Stops <Handler Acct-Status-Type = Stop> <AuthBy SQL> DBSource dbi:Sybase:Myejaz78k DBUsername nbauthuser DBAuth nbauthuserpass HandleAcctStatusTypes Stop AcctSQLStatement exec ISPBilling.dbo.[CM_WriteCDRnew] \ '%{Acct-Session-Id}','%{User-Name}','%G',%{Acct-Session-Time},'%{Called-Stat ion-Id}',%{Acct-Input-Octets},%{Acct-Output-Octets},'%{NAS-IP-Address}','%{F ramed-IP-Address}','%{Calling-Station-Id}','%{Acct-Terminate-Cause}','%{Tunn el-Client-Endpoint}','%{Tunnel-Client-Auth-ID}','%{Acct-Status-Type}' </AuthBy> </Handler> # Default Handler (For New-billing Server) <Handler> PreProcessingHook file:"/etc/radiator/changeUserName" <AuthBy SQL> DBSource dbi:Sybase:Myejaz78k DBUsername nbauthuser DBAuth nbauthuserpass DefaultSimultaneousUse 1 CaseInsensitivePasswords AuthSelect select password, replyattr, checkattr from NB_Authentication \ where username=%0 AuthColumnDef 0, User-Password, check AuthColumnDef 1, GENERIC, reply AuthColumnDef 2, GENERIC, check # Modification End </AuthBy> </Handler> #SessionDatabases <SessionDatabase SQL> DBSource dbi:Oracle:ejrsun DBUsername radonline DBAuth radonline # An entry for each user _currently_ on line AddQuery insert into RADONLINE (USERNAME,NASIDENTIFIER,NASPORT,\ ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NASPORTTYPE,\ SERVICETYPE,CALLERID) values \ (%0,'%{NAS-IP-Address}',%{NAS-Port},'%{Acct-Session-Id}',\ to_date('%G','Mon dd, yyyy hh24:mi:ss'),'%{Framed-IP-Address}','%{NAS-Port-Type}',\ '%{Framed-Protocol}','%{Calling-Station-Id}') DeleteQuery delete from RADONLINE where USERNAME=lower(%0) and \ NASIDENTIFIER='%N' and NASPORT=%{NAS-Port} # ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N' # CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from \ # RADONLINE where USERNAME=%0 </SessionDatabase>
_______________________________________________ Please visit https://lists.isc.org/mailman/listinfo/bind-users to unsubscribe from this list bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users