(RADIATOR) mikrotik & radiator

Roy Soala roy at infoasia.net
Fri Nov 17 03:49:48 CST 2006


dear friend,

i have radiator installed and running to serve dial-up port. we are
planning to use the same radiator to handle hotspot (mikrotik RouterOS)
authentication and accounting system. i found that mikrotik VSA inserted
to radiator dictionary already.

my question is :

what should i insert in the radiator configuration to be able to serve
mikrotik as a captive portal if i want the dial-up users has ability to
use the same account for the hotspot access ?


here is my current config :
---
Foreground
LogStdout
LogDir          .
DbDir           .
Trace           4
<Client DEFAULT>
        Secret mysecret
        DupInterval 0
</Client>
<ClientListSQL>
        DBSource        dbi:mysql:radius
        DBUsername      root
        DBAuth          secret
</ClientListSQL>
<AddressAllocator SQL>
        Identifier myallocator
        DBSource        dbi:mysql:radius
        DBUsername      root
        DBAuth          secret

<AddressPool pool1>
Subnetmask      255.255.255.0
DNSServer       xxx.xxx.xxx.xxx
Range   192.192.193.2 192.192.193.65
</AddressPool>

</AddressAllocator>

<Realm DEFAULT>
AuthByPolicy ContinueWhileAccept
RewriteUsername s/^([^@]+).*/$1/
<AuthBy SQL>
DBSource        dbi:mysql:radius
DBUsername      root
DBAuth          secret
DefaultSimultaneousUse 1
AuthSelect select PASSWORD, TIMELEFT from SUBSCRIBERS where USERNAME=%0
and TIMELEFT > 0
AuthColumnDef   0,User-Password,check
AuthColumnDef   1,Session-Timeout,reply
# Adjust the time left when they log out

AccountingStopsOnly
    AcctSQLStatement update SUBSCRIBERS set
TIMELEFT=TIMELEFT-0%{Acct-Session-Time} where USERNAME='%n'
AccountingTable ACCOUNTING
AcctColumnDef   USERNAME,User-Name
AcctColumnDef   TIME_STAMP,Timestamp,integer
AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
AcctColumnDef   CALLINGID,Calling-Station-Id
AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef   ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef   NASIDENTIFIER,NAS-Identifier
AcctColumnDef   NASPORT,NAS-Port,integer
AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
SQLRecoveryFile %D/missedaccounting
</AuthBy>
<AuthBy DYNADDRESS>
AddressAllocator myallocator
PoolHint        pool1
MapAttribute    yiaddr, Framed-IP-Address
MapAttribute    subnetmask, Framed-IP-Netmask
MapAttribute    dnsserver, Unisphere-Primary-Dns
</AuthBy>
</Realm>
---



sample config would be greatly appreciated. thanks.

regards, --roy


--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list