Hi All,
I am using Radiator-3.0 and DB on SQL Server.
I am implementing CLI through DB from more than one number ... radiator
just read only the number from the first field not going to the second
one ... i m attaching my configuration file and detail showing error.
waiting for replies,
Mushtaque.
_______
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to which they
are addressed. This communication represents the originator's personal
views and opinions, which do not necessarily reflect those of eWorld
(Pvt) Ltd. If you are not the original / intended recipient or the
person responsible for delivering the email to the intended recipient,
be advised that you have received this email in error, and that any
use, dissemination, forwarding, printing, or copying of this email is
strictly prohibited. If you have received this email in error, we
regret the inconvenience and request you to please immediately notify
at [EMAIL PROTECTED]
RunAsDaemon: yes
# emerald.cfg
#
# Example Radiator configuration file that allows you to
# authenticate from and store accounting to the Emerald database
# from IEA (see http://www.iea-software.com), or from
# Platypus (see www.platypus.com) from Boradtown when running
# the RadiusNT compatibility mode.
# Caution: this config file and AuthBy EMERALD will not work with
# non-standard dictionary file.
#
# You should consider this file to be a starting point only
# $Id: emerald.cfg,v 1.5 2000/08/21 04:33:08 mikem Exp $
#DateFormat %b %e, %Y %H:%M:%S
Foreground
LogStdout
DbDir .
LogDir .
LogFile ./detail
Trace 4
# You will probably want to change this to suit your site.
<Client DEFAULT>
Secret ********
IgnoreAcctSignature
DupInterval 2
FramedGroupBaseAddress 10.0.0.1
</Client>
<AuthBy FILE>
DefaultSimultaneousUse 1
Filename %D/users
Nocache
Identifier ID_1
</AuthBy>
<AuthBy EMERALD>
# Change DBSource, DBUsername, DBAuth for your database
# See the reference manual
# Default username and password for Platypus
# Typical username and password for Emerald. Make
# sure that you have added the users, and made their
# default database the Emerald database
# DBUsername emeralduser
# DBAuth emeralduser
# You can add to or change these if you want.
DBSource dbi:ODBC:plat
DBUsername *********
DBAuth *******
AccountingTable Calls
AcctColumnDef UserName,User-Name
AcctColumnDef CallDate,Timestamp,integer-date
AcctColumnDef AcctStatusType,Acct-Status-Type,integer
AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
AcctColumnDef AcctSessionId,Acct-Session-Id
AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer
AcctColumnDef NASIdentifier,NAS-Identifier
AcctColumnDef NASIdentifier,NAS-IP-Address
AcctColumnDef CallerID,Calling-Station-Id
AcctColumnDef NASPort,NAS-Port,integer
# AcctColumnDef FramedIPAddress,Framed-IP-Address
AddToReply Service-Type=Framed-User
DefaultSimultaneousUse 1
Identifier ID_0
# You can use this to force Radiator to limit
# maximum session times to how many minutes
# are left in subaccounts.timeleft
TimeBanking
# You can optionally honour the LoginLimit
# column in the emerald database
# or any other column like this:
AuthSelect ,sa.LoginLimit,sa.cli1,sa.cli2
AuthColumnDef 0,Simultaneous-Use, check
#AuthSelect ,sa.cli1
AuthColumnDef 1,Calling-Station-Id, check
#AuthSelect ,sa.cli2
AuthColumnDef 2,Calling-Station-Id, check
#AuthSelect select cli1 from subaccounts \
# where login='%n' and clicheck='Y'
# Therefore you can add support for any number
# of additional columns, if you wish.
# Note that Platypus fixes LoginLimit at 1, so
# if you enable this with Platypus, all your
# users will be forced to a Sumultaneous-Use limit
# of 1
AcctSQLStatement update scratchcustomer set
timeleft=timeleft-('0%{Acct-Session-Time}'/60) where scratchcustomer.username ='%n'
AcctSQLStatement update scratchcustomer set
expire_date=dateadd(m,1,getdate()),expirevalue=1 where username='%n' and expirevalue=0
#AcctSQLStatement update customer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*monthlyprice from
PriceCalculationMonthly,customer where customer.username ='%n' and
customer.accttype='eTimeMonthly'
#AcctSQLStatement update customer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
e15TimeMonthly,customer where customer.username ='%n' and
customer.accttype='e15TimeMonthly'
#AcctSQLStatement update customer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
e30TimeMonthly,customer where customer.username ='%n' and
customer.accttype='e30TimeMonthly'
#AcctSQLStatement update customer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
e60TimeMonthly,customer where customer.username ='%n' and
customer.accttype='e60TimeMonthly'
#AcctSQLStatement update customer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
e90TimeMonthly,customer where customer.username ='%n' and
customer.accttype='e90TimeMonthly'
AcctSQLStatement update customer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
e30TimeYearly,customer where customer.username ='%n' and
customer.accttype='e30TimeYearly'
AcctSQLStatement update customer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
e60TimeYearly,customer where customer.username ='%n' and
customer.accttype='e60TimeYearly'
AcctSQLStatement update customer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
e90TimeYearly,customer where customer.username ='%n' and
customer.accttype='e90TimeYearly'
AcctSQLStatement update customer set
bw=bw-('0%{Acct-Input-Octets}')+('0%{Acct-Output-Octets}') where customer.username
='%n' and customer.accttype='eBandwidth'
AcctSQLStatement update scratchcustomer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
escratch5,scratchcustomer where scratchcustomer.username ='%n' and
scratchcustomer.accttype='eScratch5'
AcctSQLStatement update scratchcustomer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
escratch15,scratchcustomer where scratchcustomer.username ='%n' and
scratchcustomer.accttype='eScratch15'
AcctSQLStatement update scratchcustomer set
amount=amount-('0%{Acct-Session-Time}'/3600.00)*Monthlyprice from
escratch30,scratchcustomer where scratchcustomer.username ='%n' and
scratchcustomer.accttype='eScratch30'
</AuthBy>
<Log EMERALD>
# These should probably be the same as for your AuthBy EMERALD
DBSource dbi:ODBC:plat
DBUsername *********
DBAuth *********
DateFormat %b %e, %Y %H:%M:%S
</Log>
<ClientListSQL>
DBSource dbi:ODBC:plat
DBUsername ********
DBAuth ********
GetClientQuery select IPAddress,secret from Servers
</ClientListSQL>
# <AuthBy NT>
# You must set the domain name here to suit your site:
# Domain Domain
# ON NT, optionally specify the name of the
# Primary Domain Controller, including the leading
# \\ slashes, to override the default domain controller
# for the domain you specified above
# DomainController \\64.86.172.39
# On Unix, you MUST specify the Domain Controller
# name as the NT host name of the domain controller:
# its not optional. This needs to be set to the NT
# name of the Primary Domain Controller, and further
# the NT name must be in the Unix hosts or DNS
# DomainController romeo
# On NT, you can optionally check the
# "Grant dialin permission to user" flag in the
# user manager. Requires the
# Win32-RasAdmin Perl package to be installed first
# HonourDialinPermission
# This will set up some standard reply items for
# your NAS, you may need others for your NAS
# DefaultReply
Service-Type=Framed-User,Framed-Protocol=PPP,Framed-IP-Address = 64.86.45.250,
# Identifier ID_2
# </AuthBy>
<Realm DEFAULT>
AuthBy ID_0
AuthBy ID_1
# AuthBy ID_2
AuthByPolicy ContinueUntilAccept
RejectHasReason
SessionDatabase
</Realm>
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Courier New;}{\f1\fswiss\fcharset0 Arial;}} \viewkind4\uc1\pard\f0\fs20 Code: Access-Request\par Identifier: 233\par Authentic: <193><135><160>^(<128><19>R<158>h<141><221><218>|hj\par Attributes:\par \tab NAS-IP-Address = 202.63.217.241\par \tab NAS-Port = 5\par \tab Cisco-NAS-Port = "Async5"\par \tab NAS-Port-Type = Async\par \tab User-Name = "m_mushtaque"\par \tab Called-Station-Id = "7155"\par \tab Calling-Station-Id = "215219318"\par \tab User-Password = "n<13><180><199><144><134><157><248><12><161><236>H<249><164><142><198>"\par \tab Service-Type = Framed-User\par \tab Framed-Protocol = PPP\par \par Mon Oct 28 11:53:16 2002: DEBUG: Handling request with Handler 'Realm=DEFAULT'\par Mon Oct 28 11:53:16 2002: DEBUG: Deleting session for m_mushtaque, 202.63.217.241, 5\par Mon Oct 28 11:53:16 2002: DEBUG: Handling with Radius::AuthEMERALD\par Mon Oct 28 11:53:16 2002: DEBUG: Handling with Radius::AuthEMERALD: ID_0\par Mon Oct 28 11:53:16 2002: DEBUG: Query is: select DateAdd(Day, ma.extension+ma.overdue, maExpireDate),\par DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,\par sa.password, sa.login, sa.shell, sa.TimeLeft ,sa.LoginLimit,sa.cli1,sa.cli2\par from masteraccounts ma, subaccounts sa \par where (sa.login = 'm_mushtaque' or sa.shell = 'm_mushtaque') \par and ma.customerid = sa.customerid \par and sa.active <> 0 and ma.active <> 0\par \par Mon Oct 28 11:53:24 2002: DEBUG: Select results: 2003-10-28 11:56:00.983, 2003-10-28 11:56:00.983, 2265, PPP, eworld, m_mushtaque, , 1449, 4 216997300 215219318 \par Mon Oct 28 11:53:24 2002: DEBUG: Query is: select ra.RadAttributeID, ra.RadVendorID, \par ra.RadVendorType, \par Data, Value, Type, RadCheck \par from RadConfigs rc, RadAttributes ra\par where ra.RadAttributeID = rc.RadAttributeID \par and ra.RadVendorID = rc.RadVendorID\par and ra.RadVendorType = rc.RadVendorType\par and rc.AccountID=2265\par \par Mon Oct 28 11:53:24 2002: DEBUG: Query is: select ra.RadAttributeID, ra.RadVendorID, \par ra.RadVendorType, \par Data, Value, Type, RadCheck \par from RadATConfigs rc, RadAttributes ra\par where ra.RadAttributeID = rc.RadAttributeID \par and ra.RadVendorID = rc.RadVendorID\par and ra.RadVendorType = rc.RadVendorType\par and rc.AccountType='PPP'\par \par Mon Oct 28 11:53:24 2002: DEBUG: Radius::AuthEMERALD looks for match with m_mushtaque\par Mon Oct 28 11:53:24 2002: DEBUG: Expiration date converted to: 1067281200\par Mon Oct 28 11:53:24 2002: DEBUG: Expiration date converted to: 1067281200\par Mon Oct 28 11:53:24 2002: DEBUG: Radius::AuthEMERALD REJECT: Check item Calling-Station-Id expression '216997300 ' does not match '215219318' in request\par Mon Oct 28 11:53:24 2002: DEBUG: Query is: select DateAdd(Day, ma.extension+ma.overdue, maExpireDate),\par DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,\par sa.password, sa.login, sa.shell, sa.TimeLeft ,sa.LoginLimit,sa.cli1,sa.cli2\par from masteraccounts ma, subaccounts sa \par where (sa.login = 'DEFAULT' or sa.shell = 'DEFAULT') \par and ma.customerid = sa.customerid \par and sa.active <> 0 and ma.active <> 0\par \par Mon Oct 28 11:53:28 2002: DEBUG: Handling with Radius::AuthFILE: ID_1\par Mon Oct 28 11:53:28 2002: DEBUG: Reading users file ./users\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE looks for match with m_mushtaque\par Mon Oct 28 11:53:28 2002: DEBUG: Reading users file ./users\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE looks for match with DEFAULT\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE REJECT: Check item Service-Type expression 'Administrative-User' does not match 'Framed-User' in request\par Mon Oct 28 11:53:28 2002: DEBUG: Reading users file ./users\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE looks for match with DEFAULT1\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE REJECT: Check item Service-Type expression 'Login-User' does not match 'Framed-User' in request\par Mon Oct 28 11:53:28 2002: DEBUG: Reading users file ./users\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE looks for match with DEFAULT2\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE REJECT: Check item Service-Type expression 'Outbound-User' does not match 'Framed-User' in request\par Mon Oct 28 11:53:28 2002: DEBUG: Reading users file ./users\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE looks for match with DEFAULT3\par Mon Oct 28 11:53:28 2002: WARNING: Could not find Identifier for Auth-Type 'System'\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE REJECT: Could not find Identifier for Auth-Type 'System'\par Mon Oct 28 11:53:28 2002: DEBUG: Reading users file ./users\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE looks for match with DEFAULT4\par Mon Oct 28 11:53:28 2002: WARNING: Could not find Identifier for Auth-Type 'System'\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE REJECT: Could not find Identifier for Auth-Type 'System'\par Mon Oct 28 11:53:28 2002: DEBUG: Reading users file ./users\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE looks for match with DEFAULT5\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE REJECT: Username not prefixed with P\par Mon Oct 28 11:53:28 2002: DEBUG: Reading users file ./users\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE looks for match with DEFAULT6\par Mon Oct 28 11:53:28 2002: WARNING: This AuthBy does not know how to check Group membership\par Mon Oct 28 11:53:28 2002: DEBUG: Radius::AuthFILE REJECT: User m_mushtaque is not in Group group1\par Mon Oct 28 11:53:28 2002: DEBUG: Reading users file ./users\par Mon Oct 28 11:53:28 2002: INFO: Access rejected for m_mushtaque: User m_mushtaque is not in Group group1\par Mon Oct 28 11:53:28 2002: DEBUG: Packet dump:\par *** Sending to 202.63.217.241 port 1645 ....\par Code: Access-Reject\par Identifier: 233\par Authentic: <193><135><160>^(<128><19>R<158>h<141><221><218>|hj\par Attributes:\par \tab Reply-Message = "User m_mushtaque is not in Group group1"\par \f1\par }
