Roaming With GlobalRoam
Farhan Ahmed Siddiqui
farhan at aol.com.pk
Wed Mar 5 16:50:32 CST 2003
Hello all,
I have configure radiator with standard configuration and it is working fine
and now we want to to configure roaming with globalroam radius server , I
have configure our raditor with the help of documentaion and mailng list .
but it is not working .
My configuration is following
****************************************
Foreground
LogDir /billing/radius/log
DbDir /usr/local/src/rad/Radiator-2.16.3
LogFile /billing/radius/log/%Y%m%d.log
PidFile /billing/radius/log/radiusd.pid
Trace 4
DictionaryFile /billing/Radiator-2.17.1/dictionary
# This for our local users
<Client 192.168.1.12>
Secret xxxx
DupInterval 4
IgnoreAcctSignature
NasType Ascend
AuthPort 1645
AcctPort 1646
</Client>
#this for roaming (This IP is Roming server IP)
<Client 202.95.99.203>
Secret abcd
DupInterval 4
IgnoreAcctSignature
AuthPort 1812
AcctPort 1813
</Client>
<AddressAllocator SQL>
#
Identifier myallocator
DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=192.168.1.30)(PORT=1
313))(CONNECT_DATA=(SID=yahoo)))
DBUsername bill
DBAuth xxxx
<AddressPool dealers>
Subnetmask 255.255.255.240
Range 192.168.50.240 192.168.50.254
</AddressPool>
</AddressAllocator>
# This will authenticate users from table SUBSCRIBERS
<Realm DEFAULT>
RewriteUsername s/^([^@]+).*/$1/
AuthByPolicy ContinueWhileAccept
RejectHasReason
<AuthBy SQL>
#NODefault
NoDefaultIfFound
DefaultSimultaneousUse 1
# Adjust DBSource, DBUsername, DBAuth to suit your DB
DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=192.168.1.30
)(PORT=1313))(CONNECT_DATA=(SID=yahoo)))
DBUsername bill
DBAuth xxx
# For Authenication from Solaris encrypted password
AuthSelect select
Password,CallingStationId,ServiceType,get_sessiontimeout
('%n'),FramedProtocol, NASPortType, TimeDuration, SimultaneousUse,
FramedIPAddress, PoolHi
nt, OtherCheckItems, OtherReplyItems from TblUserLogin where Active=1 and
LoginName='%n'
AuthColumnDef 0, Encrypted-Password, check
AuthColumnDef 1, GENERIC, check
AuthColumnDef 2, Service-Type,reply
AuthColumnDef 3, Session-Timeout,reply
AuthColumnDef 4, Framed-Protocol, reply
AuthColumnDef 5, NAS-Port-Type, check
AuthColumnDef 6, GENERIC, check
AuthColumnDef 7, Simultaneous-Use, check
AuthColumnDef 8, Framed-IP-Address, reply
AuthColumnDef 9, PoolHint, reply
AuthColumnDef 10, GENERIC, check
AuthColumnDef 11, GENERIC, reply
# You may want to tailor these for your ACCOUNTING table
AccountingTable TblTransaction
AccountingStopsOnly
AcctColumnDef LoginName,User-Name
AcctColumnDef TimeClose,Timestamp,formatted-date,to_date('%d %m
% Y %H:%M:%S'
,'DD MM YYYY HH24:MI:SS')
AcctColumnDef RecordType,Acct-Status-Type
AcctColumnDef BytesIn,Acct-Input-Octets,integer
AcctColumnDef BytesOut,Acct-Output-Octets,integer
AcctColumnDef SessionId,Acct-Session-Id
AcctColumnDef Duration,Acct-Session-Time,integer
AcctColumnDef TerminationCause,Ascend-Disconnect-Cause
AcctColumnDef NASIdentifier,NAS-Identifier
AcctColumnDef NASIPAddress,NAS-IP-Address
AcctColumnDef PortNo,NAS-Port,integer
AcctColumnDef FramedIPAddress,Framed-IP-Address
AcctColumnDef CLI,Calling-Station-Id
</AuthBy>
<AuthBy DYNADDRESS>
Allocator myallocator
PoolHint %{Reply:PoolHint}
MapAttribute yiaddr, Framed-IP-Address
MapAttribute subnetmask, Framed-IP-Netmask
StripFromReply PoolHint
</AuthBy>
</Realm>
<Realm globalroam.com>
RewriteUsername s/^([^@]+).*/$1/
AuthByPolicy ContinueWhileAccept
RejectHasReason
<AuthBy RADIUS>
Secret abcd
Host 202.95.99.203
AuthPort 1812
AcctPort 1813
</AuthBy>
</Realm>
<SessionDatabase SQL>
# Specify the SQL database to connect to is similar to AuthSQL
# You can specify multiple databases as fallbacks etc. See
# the reference manual for more details
DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=192.168.1.30)(PORT=1
313))(CONNECT_DATA=(SID=yahoo)))
DBUsername bill
DBAuth xxxx
AddQuery insert into TblActiveSessions (LoginName,
SessionId,TimeStart,NASIPAddres
s,FramedIPAddress,PortNo,NASPortType,CLI,NASIdentifier) values \
('%n','%{Acct-Session-Id}',to_date('%d %m %Y %H:%M:%S','DD MM YYYY
HH24:MI:SS'),'%
N','%{Framed-IP-Address}',%{NAS-Port},'%{NAS-Port-Type}','%{Calling-Station-
Id}','%N')
DeleteQuery delete from TblActiveSessions where PortNo=%{NAS-Port}
and NASIdentifi
er='%N'
ClearNasQuery delete from TblActiveSessions where NASIdentifier='%N'
CountQuery select NASIdentifier, PortNo, SessionID from
TblActiveSessions where
LoginName='%n'
</SessionDatabase>
*******************************************************
Plz help us for this problem , I am waiting form positive and prompt reply.
Thanks & Regard
Farhan .
-------------------------------------------------
This mail sent through http://mail.aol.com.pk
-------------------------------------------------------
--
Mike McCauley mikem at open.com.au
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
TTLS, PEAP etc on Unix, Windows, MacOS etc.
===
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