Hello Naveed -
Could you please send me the company name and/or user name of your purchased,
registered Radiator license.
thanks
Hugh
>
> 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
>
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, 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.