---------- Forwarded Message ----------
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from [Farhan
Ahmed Siddiqui <[EMAIL PROTECTED]>]
Date: Wed, 5 Mar 2003 06:51:01 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
>From [EMAIL PROTECTED] Wed Mar 5 06:51:01 2003
Received: from safari.aol.com.pk ([202.69.44.3])
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id h25Coxb12723
for <[EMAIL PROTECTED]>; Wed, 5 Mar 2003 06:51:00 -0600
Received: from safari.aol.com.pk (localhost [127.0.0.1])
by safari.aol.com.pk (8.12.6/8.12.6) with ESMTP id h25MoWcs020338
for <[EMAIL PROTECTED]>; Wed, 5 Mar 2003 17:50:32 -0500 (GMT)
Received: (from [EMAIL PROTECTED])
by safari.aol.com.pk (8.12.6/8.12.6/Submit) id h25MoWOr020336
for [EMAIL PROTECTED]; Wed, 5 Mar 2003 17:50:32 -0500 (GMT)
X-Authentication-Warning: safari.aol.com.pk: nobody set sender to
[EMAIL PROTECTED] using -f Received: from 202.69.42.227 ( [202.69.42.227])
as user [EMAIL PROTECTED] by mail.aol.com.pk with HTTP;
Wed, 5 Mar 2003 17:50:32 -0500
Message-ID: <[EMAIL PROTECTED]>
Date: Wed, 5 Mar 2003 17:50:32 -0500
From: Farhan Ahmed Siddiqui <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Roaming With GlobalRoam
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 3.1
X-Originating-IP: 202.69.42.227
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/^([EMAIL PROTECTED]).*/$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/^([EMAIL PROTECTED]).*/$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 [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
