--- Forwarded mail from [EMAIL PROTECTED]
Date: Mon, 2 Oct 2000 17:40:20 +1000 (EST)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from ["Naveed
Ilyas" <[EMAIL PROTECTED]>]
>From mikem Mon Oct 2 17:40:13 2000
Received: by oscar.open.com.au (8.9.0/8.9.0) id RAA21714
for [EMAIL PROTECTED]; Mon, 2 Oct 2000 17:40:12 +1000 (EST)
>Received: from hotmail.com (f188.law8.hotmail.com [216.33.241.188]) by
perki.connect.com.au with ESMTP id SAA16287
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Mon, 2 Oct 2000 18:13:39 +1100
(EST)
Received: from hotmail.com (f188.law8.hotmail.com [216.33.241.188]) by
perki.connect.com.au with ESMTP id SAA16287
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Mon, 2 Oct 2000 18:13:39 +1100
(EST)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
Mon, 2 Oct 2000 00:13:37 -0700
Received: from 216.252.185.51 by lw8fd.law8.hotmail.msn.com with HTTP; Mon, 02
Oct 2000 07:13:37 GMT
X-Originating-IP: [216.252.185.51]
From: "Naveed Ilyas" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Wrong Multiple Sessions
Date: Mon, 02 Oct 2000 07:13:37 GMT
Mime-Version: 1.0
Message-ID: <[EMAIL PROTECTED]>
X-OriginalArrivalTime: 02 Oct 2000 07:13:37.0316 (UTC)
FILETIME=[488DDE40:01C02C40]
Content-Type: text/plain; format=flowed
hi,
i am administrating an ISP, i am using Radiator RADIUS. In our scenario
user's authentication and accounting are done in database. There is a
problem in user accounting. Some time Radiator is inserting multiple
sessions in database of those users which are not allowed for multiple
sessions.
The part of Configuration file for authentication and accounting is
following
The RAS Authentication Part is
<Client 233.235.235.235>
Secret myscret
DupInterval 0
IgnoreAcctSignature
NasType Cisco
SNMPCommunity public
FramedGroupBaseAddress 222.222.222.1
FramedGroupMaxPortsPerClassC 192
</Client>
<AuthBy SQL>
# Adjust DBSource, DBUsername, DBAuth to suit your DB
DBSource DBI:mysql:databasename:222.222.222.222:3306
DBUsername dbuser
DBAuth dbpasswd
AuthSelect select PASSWORD, CallingStationId, ServiceType,
FramedProtocol, FramedIPNetmask, NASPortType, SimultaneousUse,
FramedIPAddress, SessionTimeout, TimeDuration from SUBSCRIBERS
where Active=1 and USERNAME='%n'
AuthColumnDef 0, Encrypted-Password, check
AuthColumnDef 1, GENERIC, check
AuthColumnDef 2, Service-Type, check
AuthColumnDef 3, Framed-Protocol, reply
AuthColumnDef 4, Framed-IP-Netmask, reply
AuthColumnDef 5, NAS-Port-Type, check
AuthColumnDef 6, Simultaneous-Use, check
# For Single Session this field Simultaneous-Use has value 1
AuthColumnDef 7, GENERIC, reply
AuthColumnDef 8, GENERIC, reply
AuthColumnDef 9, GENERIC, check
# For Accounting
AccountingTable TblTransaction
AccountingStopsOnly
AcctColumnDef LoginName,User-Name
AcctColumnDef TimeClose,Timestamp,formatted-date,'%Y-%m-%d
%H:%M:%S'
AcctColumnDef RecordType,Acct-Status-Type
#AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
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,Acct-Terminate-Cause
AcctColumnDef NASIdentifier,NAS-Identifier
AcctColumnDef NASIPAddress,NAS-IP-Address
AcctColumnDef NASPort,NAS-Port,integer
AcctColumnDef FramedIPAddress,Framed-IP-Address
AcctColumnDef CLI,Calling-Station-Id
</AuthBy>
When Radiator insert multiple sessions all the above field have same values
for example Acct-Session-Id, Acct-Session-Time, Calling-Station-Id,
Timestamp, User-Name. Some time value of Timestamp is different with a
difference of some seconds.
In database i have another field name RecordNo, it is an autoincrement
number, so its value is unique in this case.
Some one please help
Bye
Naveed
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
---End of forwarded mail from [EMAIL PROTECTED]
--
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 etc etc
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
