bash-3.2# more /opt2/radiator/radius.cfg
LogStdout
LogDir /opt2/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  1818
AcctPort   1819



BindAddress 212.71.33.239

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.28>
        Secret nesma99
</Client>




# Handler for Accounting Stops

<Handler Acct-Status-Type = Stop>

<AuthBy SQL>
          DBSource        dbi:Sybase:xxxxx
          DBUsername      xxxser
          DBAuth          xxxserpass


HandleAcctStatusTypes Stop

AcctSQLStatement exec ISPBilling.dbo.[CM_WriteCDRnew] \

'%{Acct-Session-Id}','%{User-Name}','%G',%{Acct-Session-Time},'%{Called-Station-
Id}',%{Acct-Input-Octets},%{Acct-Output-Octets},'%{NAS-IP-Address}','%{Framed-IP
-Address}','%{Calling-Station-Id}','%{Acct-Terminate-Cause}','%{Tunnel-Client-En
dpoint}','%{Tunnel-Client-Auth-ID}','%{Acct-Status-Type}'


</AuthBy>

</Handler>

# Default Handler (For New-billing Server Nemsa)

<Handler>
PreProcessingHook file:"/etc/radiator/changeUserName"
<AuthBy SQL>
          DBSource        dbi:Sybase:xxxx
          DBUsername      xxxxx
          DBAuth          xxxse

          DefaultSimultaneousUse 1
          CaseInsensitivePasswords
          IgnoreAcctSignature


         AuthSelect select password, replyattr, checkattr  from NB_Authenticatio
n_Nesma \
         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:Sybase:xxxxx
          DBUsername      xxxser
          DBAuth          xxxserpass

# 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}'
,\
                         Cast ('%G' as datetime),'%{Framed-IP-Address}','%{NAS-P
ort-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, ACCTSESSIONI
D from \
                      #   RADONLINE where USERNAME=%0
        </SessionDatabase>