config

<SessionDatabase SQL>

Identifier      tamesql
DBSource        dbi:ODBC:IRONMAN
DBUsername      xxxx
DBAuth          xxxx


AddQuery insert into RADONLINE2 (USERNAME, NASIDENTIFIER, CALLSESSID, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, , SERVICETYPE) values ('%n', '%N', '%{Calling-Station-Id}', '%{Acct-Session-Id}', %{Timestamp}, '%{Framed-IP-Address}', '%{NAS-Port-Type}', '%{Service-Type}')

DeleteQuery delete from RADONLINE2 where USERNAME='%n' and NASIDENTIFIER='%N' and CALLSESSID='%{Calling-Station-Id}'

ClearNasQuery   delete from RADONLINE2 where NASIDENTIFIER='%N'

CountQuery      select NASIDENTIFIER, CALLSESSID, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE2 where USERNAME='%n'

</SessionDatabase>


<Handler Request-Type = "Access-Request">

Identifier Access
MaxSessions 1
AuthByPolicy ContinueUntilAccept
PreAuthHook sub { &main::log($main::LOG_DEBUG, "Hay... start authentication"); }

        <AuthBy SQL>
                # Change DBSource, DBUsername, DBAuth for your database
                # See the reference manual
                Identifier      mahmoud
                DBSource        dbi:ODBC:IRONMAN
                DBUsername      xxx
                DBAuth         xxx
               AuthSelect select password, termend, profile0, concurrentlogins from wmd_customers where username='%n'

               AuthColumnDef  0,Password,check
               AuthColumnDef  1,Expiration,check
               AuthColumnDef  2,Mikrotik-Rate-Limit,reply
               AuthColumnDef  3,Simultaneous-Use,check
                AddToReply      Session-Timeout=2332800,Acct-Interim-Interval=300,Service-Type=Framed,Framed-
                                Protocol=PPP,cisco-avpair="ip:ip-unnumbered=loopback1"
         </AuthBy>

PostAuthHook file:"/etc/radiator/access.pl"

</Handler>