Radius-profile

[MEjaz]

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>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/bind-users/attachments/20190211/f3629e43/attachment.html>