Hi.
I cannot get to the bottom of this problem.
On occasions we are seeing multiple stop accounting records being added to
the records of a session. Looking at the logs I can confirm that multiple
stop records are actually send and received.
I have attached radius.cfg and a section of the logfile incase anyone can
help me sort this out. The user concerned in this case is "shi"
We are running Radiator 2.14.0 and the packets are coming to us from a
Ascend TNT via a proxy radiator server.
What should I look for to sort this problem out?
Radius.cfg
==========
# emerald.cfg
#
# Example Radiator configuration file that allows you to
# authenticate from and store accounting to the Emerald database
# from IEA (see http://www.emerald.iea.com)
#
# You should consider this file to be a starting point only
# $Id: emerald.cfg,v 1.1 1998/07/12 23:47:50 mikem Exp $
Foreground
LogStdout
LogDir /var/log/radius
DbDir /local/etc/radius
PidFile /var/run/radiusd.pid
SnmpgetProg /usr/bin/snmpget
AuthPort 1645
AcctPort 1646
Trace 4
# The reason for specifying each type of NAS seperately is to allow us to
# limit the number of simultaneous logins. (At some later date perhaps?)
# Our Ascend's
<Client 203.96.16.5>
# Max
Secret xxxxxxxxx
DupInterval 60
NasType AscendSNMP
SNMPCommunity public
# Add the Ascend MAX TNT's here:
# localhost is to allow us to perform testing...
IdenticalClients 203.96.16.66
</Client>
<Client 203.96.58.18>
Secret xxxxxxxxx
DupInterval 60
NasType Ascend
</Client>
<Client 203.96.58.146>
Secret xxxxxxxx
DupInterval 60
NasType Ascend
</Client>
# For testing
<Client 203.96.58.17>
Secret xxxxxxxx
DupInterval 60
NasType Ascend
</Client>
<Client 203.96.58.50>
Secret xxxxxxxx
DupInterval 60
NasType Ascend
</Client>
<Client 203.96.58.145>
DupInterval 60
Secret xxxxxxxxx
NasType Ascend
</Client>
<SessionDatabase SQL>
# Change DBSource, DBUsername, DBAuth for your database
# See the reference manual
DBSource dbi:Sybase:server=WOLFSTAR;database=plat
DBUsername xxxxxxxx
DBAuth xxxxxxxx
</SessionDatabase SQL>
<SNMPAgent>
Community public
</SNMPAgent>
<Realm DEFAULT>
# If Platypus rejects the login, forward it to the old Radius server
AuthByPolicy ContinueUntilAccept
ExcludeFromPasswordLog cisco
PasswordLogFileName %L/password.log
<AuthBy EMERALD>
# Change DBSource, DBUsername, DBAuth for your database
# See the reference manual
DBSource dbi:Sybase:server=WOLFSTAR;database=plat
DBUsername xxxxxxxx
DBAuth xxxxxxxx
# You can add to or change these if you want.
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,intege
r
AcctColumnDef NASIdentifier,NAS-Identifier
AcctColumnDef NASIdentifier,NAS-IP-Address
AcctColumnDef NASPort,NAS-Port,integer
# You can use this to force Radiator to limit
# maximum session times to how many minutes
# are left in subaccounts.timeleft
# TimeBanking
AddATDefaults
</AuthBy>
# <AuthBy RADIUS>
# Host mail.actrix.gen.nz
# Secret xxxxxxxx
# </AuthBy>
<AuthBy FILE>
Filename %D/users
</AuthBy>
# Log all accounting into daily log files
AcctLogFileName /local/etc/radius/log/%Y%m%d.act
</Realm>
Logfile
========
Thu Aug 26 07:27:39 1999: DEBUG: Packet dump:
*** Received from 203.96.58.18 port 32954 ....
Code: Accounting-Request
Identifier: 170
Authentic: W<243><8><252><22><205>vJ<230>L.<7>,Hk<149>
Attributes:
User-Name = "shi"
NAS-IP-Address = 203.96.58.17
NAS-Port = 2060
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "297957764"
Acct-Authentic = RADIUS
Acct-Session-Time = 8291
Acct-Input-Octets = 315073
Acct-Output-Octets = 1985828
Acct-Input-Packets = 5279
Acct-Output-Packets = 5752
Ascend-Disconnect-Cause = pppRcvTerminate
Ascend-Connect-Progress = prLanSessionUp
Ascend-Xmit-Rate = 52000
Ascend-Data-Rate = 28800
Ascend-PreSession-Time = 25
Ascend-Pre-Input-Octets = 268
Ascend-Pre-Output-Octets = 264
Ascend-Pre-Input-Packets = 10
Ascend-Pre-Output-Packets = 11
Ascend-First-Dest = 205.188.252.213
Ascend-Modem-PortNo = 9
Ascend-Modem-SlotNo = 9
Ascend-Modem-ShelfNo = 1
Called-Station-Id = "78686"
Framed-Protocol = PPP
Framed-IP-Address = 203.96.49.8
Timestamp = 935608851
Thu Aug 26 07:27:39 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Aug 26 07:27:39 1999: DEBUG: Deleting session for shi, 203.96.58.17, 2060
Thu Aug 26 07:27:39 1999: DEBUG: do query is: delete from RADONLINE where NASI
DENTIFIER='203.96.58.17' and NASPORT=2060
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Handling accounting with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputO
ctets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPor
t)
values
('shi', 'Aug 26, 1999 7:20', 2, 0, 315073, 1985828, '297957764
', 8291, '203.96.58.17', 2060)
Thu Aug 26 07:27:40 1999: DEBUG: Accounting accepted
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.18 port 32954 ....
Code: Accounting-Response
Identifier: 170
Authentic: W<243><8><252><22><205>vJ<230>L.<7>,Hk<149>
Attributes:
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Received from 203.96.58.146 port 32846 ....
Code: Access-Request
Identifier: 135
Authentic: PQ<223>i0<22><23>6<161><17><182><238>4<148><132><177>
Attributes:
User-Name = "ajiani"
CHAP-Password = "<1><255><226><228>W:}H<137><*<8><31>O<162><139>F"
NAS-IP-Address = 203.96.58.145
NAS-Port = 2054
Timestamp = 935608851
Thu Aug 26 07:27:39 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Aug 26 07:27:39 1999: DEBUG: Deleting session for shi, 203.96.58.17, 2060
Thu Aug 26 07:27:39 1999: DEBUG: do query is: delete from RADONLINE where NASI
DENTIFIER='203.96.58.17' and NASPORT=2060
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Handling accounting with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputO
ctets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPor
t)
values
('shi', 'Aug 26, 1999 7:20', 2, 0, 315073, 1985828, '297957764
', 8291, '203.96.58.17', 2060)
Thu Aug 26 07:27:40 1999: DEBUG: Accounting accepted
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.18 port 32954 ....
Code: Accounting-Response
Identifier: 170
Authentic: W<243><8><252><22><205>vJ<230>L.<7>,Hk<149>
Attributes:
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Received from 203.96.58.146 port 32846 ....
Code: Access-Request
Identifier: 135
Authentic: PQ<223>i0<22><23>6<161><17><182><238>4<148><132><177>
Attributes:
User-Name = "ajiani"
CHAP-Password = "<1><255><226><228>W:}H<137><*<8><31>O<162><139>F"
NAS-IP-Address = 203.96.58.145
NAS-Port = 2054
DENTIFIER='203.96.58.145' and NASPORT=2054
Thu Aug 26 07:27:40 1999: DEBUG: do query is: insert into RADONLINE (USERNAME,
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTY
PE, SERVICETYPE) values ('ajiani', '203.96.58.145', 2054, '301102652', 9356088
52, '203.96.51.115', 'Async', '')
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Handling accounting with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctSessio
nId, NASIdentifier, NASPort)
values
('ajiani', 'Aug 26, 1999 7:20', 1, 0, '301102652', '203.96.58.
145', 2054)
Thu Aug 26 07:27:40 1999: DEBUG: Accounting accepted
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.18 port 32954 ....
Code: Accounting-Response
Identifier: 208
Authentic: <224><177>Fd}<230><4>*!<167><15>K<4>r<130><163>
Attributes:
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Received from 203.96.58.146 port 32846 ....
Code: Access-Request
Identifier: 136
Authentic: <198><181>C<166><242><252><140><2>jN<222><139>[<218>Ke
Attributes:
User-Name = "rizwan"
CHAP-Password = "<1><192>1<155><30><139><237><12><14><173><224>PI ";<1
39>"
NAS-IP-Address = 203.96.58.145
NAS-Port = 2108
NAS-Port-Type = Async
State = ""
Called-Station-Id = "90303"
Acct-Session-Id = "301102653"
Ascend-Data-Rate = 14400
Ascend-Xmit-Rate = 14400
Thu Aug 26 07:27:40 1999: INFO: Duplicate request id 136 received from 203.96.
58.145: ignored
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Received from 203.96.58.18 port 32954 ....
Code: Accounting-Request
Identifier: 171
Authentic: <213>Oj<1><253><173><199><210><189><225><201><176><253><147><195><
187>
Attributes:
User-Name = "shi"
NAS-IP-Address = 203.96.58.17
NAS-Port = 2060
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 5
Acct-Session-Id = "297957764"
Acct-Authentic = RADIUS
Acct-Session-Time = 8291
Acct-Input-Octets = 315073
Acct-Output-Octets = 1985828
Acct-Input-Packets = 5279
Acct-Output-Packets = 5752
Ascend-Disconnect-Cause = pppRcvTerminate
Ascend-Connect-Progress = prLanSessionUp
Ascend-Xmit-Rate = 52000
Ascend-Data-Rate = 28800
Ascend-PreSession-Time = 25
Ascend-Pre-Input-Octets = 268
Ascend-Pre-Output-Octets = 264
Ascend-Pre-Input-Packets = 10
Ascend-Pre-Output-Packets = 11
Ascend-First-Dest = 205.188.252.213
Ascend-Modem-PortNo = 9
Ascend-Modem-SlotNo = 9
Ascend-Modem-ShelfNo = 1
Called-Station-Id = "78686"
Framed-Protocol = PPP
Framed-IP-Address = 203.96.49.8
Timestamp = 935608851
Thu Aug 26 07:27:40 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Aug 26 07:27:40 1999: DEBUG: Deleting session for shi, 203.96.58.17, 2060
Thu Aug 26 07:27:40 1999: DEBUG: do query is: delete from RADONLINE where NASI
DENTIFIER='203.96.58.17' and NASPORT=2060
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Handling accounting with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputO
ctets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPor
t)
values
('shi', 'Aug 26, 1999 7:20', 2, 5, 315073, 1985828, '297957764
', 8291, '203.96.58.17', 2060)
Thu Aug 26 07:27:40 1999: DEBUG: Accounting accepted
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.18 port 32954 ....
Code: Accounting-Response
Identifier: 171
Authentic: <213>Oj<1><253><173><199><210><189><225><201><176><253><147><195><
187>
Attributes:
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Received from 203.96.58.146 port 32846 ....
Code: Access-Request
Identifier: 92
Authentic: Na<217><195><207><1><225>Z<210><148>(<230>^<223>'f
Attributes:
User-Name = "clayoak"
CHAP-Password = "<1><169>a<9<8><233><165>><177>+<232>5<165><154><141>4
"
NAS-IP-Address = 203.96.58.242
NAS-Port = 2054
NAS-Port-Type = Async
State = ""
Called-Station-Id = "02626"
Acct-Session-Id = "298504715"
Ascend-Data-Rate = 31200
Ascend-Xmit-Rate = 33600
Thu Aug 26 07:27:40 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Aug 26 07:27:40 1999: DEBUG: Deleting session for clayoak, 203.96.58.242,
2054
Thu Aug 26 07:27:40 1999: DEBUG: do query is: delete from RADONLINE where NASI
DENTIFIER='203.96.58.242' and NASPORT=2054
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Query is: select DateAdd(Day, ma.extension, m
aExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
sa.password, sa.login, sa.shell, sa.TimeLeft
from masteraccounts ma, subaccounts sa
where (sa.login = 'clayoak' or sa.shell = 'clayoak')
and ma.customerid = sa.customerid
and sa.active <> 0 and ma.active <> 0
Thu Aug 26 07:27:40 1999: DEBUG: Select results: Dec 31 1999 12:00AM, Dec 31 1
999 12:00AM, 7131, PPP, 1claybox, clayoak, , ,
Thu Aug 26 07:27:40 1999: DEBUG: Query is: select ra.RadAttributeID, Data, Val
ue, Type
from RadConfigs rc, RadAttributes ra
where ra.RadAttributeID = rc.RadAttributeID and rc.AccountID=7131
Thu Aug 26 07:27:40 1999: DEBUG: Query is: select ra.RadAttributeID, Data, Val
ue, Type
from RadATConfigs rc, RadAttributes ra
where ra.RadAttributeID = rc.RadAttributeID
and rc.AccountType='PPP'
Thu Aug 26 07:27:40 1999: DEBUG: Radius::AuthEMERALD looks for match with clay
oak
Thu Aug 26 07:27:40 1999: DEBUG: Expiration date converted to: 946551600
Thu Aug 26 07:27:40 1999: DEBUG: Expiration date converted to: 946551600
Thu Aug 26 07:27:40 1999: DEBUG: Radius::AuthEMERALD ACCEPT:
Thu Aug 26 07:27:40 1999: DEBUG: Access accepted for clayoak
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.146 port 32846 ....
Code: Access-Accept
Identifier: 92
Authentic: Na<217><195><207><1><225>Z<210><148>(<230>^<223>'f
Attributes:
Framed-IP-Netmask = 255.255.255.255
Service-Type = 2
Framed-Protocol = 1
Idle-Timeout = 1200
Framed-Compression = 1
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Received from 203.96.58.18 port 32954 ....
Code: Accounting-Request
Identifier: 210
Authentic: <252>^<202><250>..~<9>h]H<235><2>^<146><251>
Attributes:
User-Name = "ajiani"
NAS-IP-Address = 203.96.58.145
NAS-Port = 2054
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Delay-Time = 5
Acct-Session-Id = "301102652"
Acct-Authentic = RADIUS
Ascend-Modem-PortNo = 31
Ascend-Modem-SlotNo = 14
Ascend-Modem-ShelfNo = 1
Called-Station-Id = "90303"
Framed-Protocol = PPP
Framed-IP-Address = 203.96.51.115
Timestamp = 935608852
Thu Aug 26 07:27:40 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Aug 26 07:27:40 1999: DEBUG: Adding session for ajiani, 203.96.58.145, 20
54
Thu Aug 26 07:27:40 1999: DEBUG: do query is: delete from RADONLINE where NASI
DENTIFIER='203.96.58.145' and NASPORT=2054
Thu Aug 26 07:27:40 1999: DEBUG: do query is: insert into RADONLINE (USERNAME,
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTY
PE, SERVICETYPE) values ('ajiani', '203.96.58.145', 2054, '301102652', 9356088
52, '203.96.51.115', 'Async', '')
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Handling accounting with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctSessio
nId, NASIdentifier, NASPort)
values
('ajiani', 'Aug 26, 1999 7:20', 1, 5, '301102652', '203.96.58.
145', 2054)
Thu Aug 26 07:27:40 1999: DEBUG: Accounting accepted
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.18 port 32954 ....
Code: Accounting-Response
Identifier: 210
Authentic: <252>^<202><250>..~<9>h]H<235><2>^<146><251>
Attributes:
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Received from 203.96.58.146 port 32846 ....
Code: Access-Request
Identifier: 135
Authentic: PQ<223>i0<22><23>6<161><17><182><238>4<148><132><177>
Attributes:
User-Name = "ajiani"
CHAP-Password = "<1><255><226><228>W:}H<137><*<8><31>O<162><139>F"
NAS-IP-Address = 203.96.58.145
NAS-Port = 2054
NAS-Port-Type = Async
State = ""
Called-Station-Id = "90303"
Acct-Session-Id = "301102652"
Ascend-Data-Rate = 31200
Ascend-Xmit-Rate = 33600
Thu Aug 26 07:27:40 1999: INFO: Duplicate request id 135 received from 203.96.
58.145: ignored
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Received from 203.96.58.146 port 32846 ....
Code: Accounting-Request
Identifier: 228
Authentic: <155><193><180>.<222>Nq<2>#<238><30><209><169><156>~:
Attributes:
User-Name = "shi"
NAS-IP-Address = 203.96.58.17
NAS-Port = 2060
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "297957764"
Acct-Authentic = RADIUS
Acct-Session-Time = 8291
Acct-Input-Octets = 315073
Acct-Output-Octets = 1985828
Acct-Input-Packets = 5279
Acct-Output-Packets = 5752
Ascend-Disconnect-Cause = pppRcvTerminate
Ascend-Connect-Progress = prLanSessionUp
Ascend-Xmit-Rate = 52000
Ascend-Data-Rate = 28800
Ascend-PreSession-Time = 25
Ascend-Pre-Input-Octets = 268
Ascend-Pre-Output-Octets = 264
Ascend-Pre-Input-Packets = 10
Ascend-Pre-Output-Packets = 11
Ascend-First-Dest = 205.188.252.213
Ascend-Modem-PortNo = 9
Ascend-Modem-SlotNo = 9
Ascend-Modem-ShelfNo = 1
Called-Station-Id = "78686"
Framed-Protocol = PPP
Framed-IP-Address = 203.96.49.8
Timestamp = 935605300
Thu Aug 26 07:27:40 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Aug 26 07:27:40 1999: DEBUG: Deleting session for shi, 203.96.58.17, 2060
Thu Aug 26 07:27:40 1999: DEBUG: do query is: delete from RADONLINE where NASI
DENTIFIER='203.96.58.17' and NASPORT=2060
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Handling accounting with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputO
ctets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPor
t)
values
('shi', 'Aug 26, 1999 6:21', 2, 0, 315073, 1985828, '297957764
', 8291, '203.96.58.17', 2060)
Thu Aug 26 07:27:40 1999: DEBUG: Accounting accepted
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.146 port 32846 ....
Code: Accounting-Response
Identifier: 228
Authentic: <155><193><180>.<222>Nq<2>#<238><30><209><169><156>~:
Attributes:
Thu Aug 26 07:27:40 1999: DEBUG: Packet dump:
*** Received from 203.96.58.18 port 32954 ....
Code: Access-Request
Identifier: 209
Authentic: <198><181>C<166><242><252><140><2>jN<222><139>[<218>Ke
Attributes:
User-Name = "rizwan"
CHAP-Password = "<1><192>1<155><30><139><237><12><14><173><224>PI ";<1
39>"
NAS-IP-Address = 203.96.58.145
NAS-Port = 2108
NAS-Port-Type = Async
State = ""
Called-Station-Id = "90303"
Acct-Session-Id = "301102653"
Ascend-Data-Rate = 14400
Ascend-Xmit-Rate = 14400
Thu Aug 26 07:27:40 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Aug 26 07:27:40 1999: DEBUG: Deleting session for rizwan, 203.96.58.145,
2108
Thu Aug 26 07:27:40 1999: DEBUG: do query is: delete from RADONLINE where NASI
DENTIFIER='203.96.58.145' and NASPORT=2108
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:40 1999: DEBUG: Query is: select DateAdd(Day, ma.extension, m
aExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
sa.password, sa.login, sa.shell, sa.TimeLeft
from masteraccounts ma, subaccounts sa
where (sa.login = 'rizwan' or sa.shell = 'rizwan')
and ma.customerid = sa.customerid
and sa.active <> 0 and ma.active <> 0
Thu Aug 26 07:27:41 1999: DEBUG: Select results: Dec 31 1999 12:00AM, Dec 31 1
999 12:00AM, 6544, PPP, roomi7, rizwan, , ,
Thu Aug 26 07:27:41 1999: DEBUG: Query is: select ra.RadAttributeID, Data, Val
ue, Type
from RadConfigs rc, RadAttributes ra
where ra.RadAttributeID = rc.RadAttributeID and rc.AccountID=6544
Thu Aug 26 07:27:41 1999: DEBUG: Query is: select ra.RadAttributeID, Data, Val
ue, Type
from RadATConfigs rc, RadAttributes ra
where ra.RadAttributeID = rc.RadAttributeID
and rc.AccountType='PPP'
Thu Aug 26 07:27:41 1999: DEBUG: Radius::AuthEMERALD looks for match with rizw
an
Thu Aug 26 07:27:41 1999: DEBUG: Expiration date converted to: 946551600
Thu Aug 26 07:27:41 1999: DEBUG: Expiration date converted to: 946551600
Thu Aug 26 07:27:41 1999: DEBUG: Radius::AuthEMERALD ACCEPT:
Thu Aug 26 07:27:41 1999: DEBUG: Access accepted for rizwan
Thu Aug 26 07:27:41 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.18 port 32954 ....
Code: Access-Accept
Identifier: 209
Authentic: <198><181>C<166><242><252><140><2>jN<222><139>[<218>Ke
Attributes:
Framed-IP-Netmask = 255.255.255.255
Service-Type = 2
Framed-Protocol = 1
Idle-Timeout = 1200
Framed-Compression = 1
Thu Aug 26 07:27:41 1999: DEBUG: Packet dump:
*** Received from 203.96.58.18 port 32954 ....
Code: Accounting-Request
Identifier: 172
Authentic: N<188>V<164>%<194>eC<5><152>zr<10>j<141>
Attributes:
User-Name = "shi"
NAS-IP-Address = 203.96.58.17
NAS-Port = 2060
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 10
Acct-Session-Id = "297957764"
Acct-Authentic = RADIUS
Acct-Session-Time = 8291
Acct-Input-Octets = 315073
Acct-Output-Octets = 1985828
Acct-Input-Packets = 5279
Acct-Output-Packets = 5752
Ascend-Disconnect-Cause = pppRcvTerminate
Ascend-Connect-Progress = prLanSessionUp
Ascend-Xmit-Rate = 52000
Ascend-Data-Rate = 28800
Ascend-PreSession-Time = 25
Ascend-Pre-Input-Octets = 268
Ascend-Pre-Output-Octets = 264
Ascend-Pre-Input-Packets = 10
Ascend-Pre-Output-Packets = 11
Ascend-First-Dest = 205.188.252.213
Ascend-Modem-PortNo = 9
Ascend-Modem-SlotNo = 9
Ascend-Modem-ShelfNo = 1
Called-Station-Id = "78686"
Framed-Protocol = PPP
Framed-IP-Address = 203.96.49.8
Timestamp = 935608851
Thu Aug 26 07:27:41 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Aug 26 07:27:41 1999: DEBUG: Deleting session for shi, 203.96.58.17, 2060
Thu Aug 26 07:27:41 1999: DEBUG: do query is: delete from RADONLINE where NASI
DENTIFIER='203.96.58.17' and NASPORT=2060
Thu Aug 26 07:27:41 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:41 1999: DEBUG: Handling accounting with Radius::AuthEMERALD
Thu Aug 26 07:27:41 1999: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputO
ctets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPor
t)
values
('shi', 'Aug 26, 1999 7:20', 2, 10, 315073, 1985828, '29795776
4', 8291, '203.96.58.17', 2060)
Thu Aug 26 07:27:41 1999: DEBUG: Accounting accepted
Thu Aug 26 07:27:41 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.18 port 32954 ....
Code: Accounting-Response
Identifier: 172
Authentic: N<188>V<164>%<194>eC<5><152>zr<10>j<141>
Attributes:
Thu Aug 26 07:27:41 1999: DEBUG: Packet dump:
*** Received from 203.96.58.146 port 32846 ....
Code: Access-Request
Identifier: 136
Authentic: <198><181>C<166><242><252><140><2>jN<222><139>[<218>Ke
Attributes:
User-Name = "rizwan"
CHAP-Password = "<1><192>1<155><30><139><237><12><14><173><224>PI ";<1
39>"
NAS-IP-Address = 203.96.58.145
NAS-Port = 2108
NAS-Port-Type = Async
State = ""
Called-Station-Id = "90303"
Acct-Session-Id = "301102653"
Ascend-Data-Rate = 14400
Ascend-Xmit-Rate = 14400
Thu Aug 26 07:27:41 1999: INFO: Duplicate request id 136 received from 203.96.
58.145: ignored
Thu Aug 26 07:27:41 1999: DEBUG: Packet dump:
*** Received from 203.96.58.146 port 32846 ....
Code: Accounting-Request
Identifier: 137
Authentic: $8<186><233><227><153><159>b<176>?<194><239><138><18>v
Attributes:
User-Name = "ajiani"
NAS-IP-Address = 203.96.58.145
NAS-Port = 2054
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "301102652"
Acct-Authentic = RADIUS
Ascend-Modem-PortNo = 31
Ascend-Modem-SlotNo = 14
Ascend-Modem-ShelfNo = 1
Called-Station-Id = "90303"
Framed-Protocol = PPP
Framed-IP-Address = 203.96.51.115
Timestamp = 935605301
Thu Aug 26 07:27:41 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Aug 26 07:27:41 1999: DEBUG: Adding session for ajiani, 203.96.58.145, 20
54
Thu Aug 26 07:27:41 1999: DEBUG: do query is: delete from RADONLINE where NASI
DENTIFIER='203.96.58.145' and NASPORT=2054
Thu Aug 26 07:27:41 1999: DEBUG: do query is: insert into RADONLINE (USERNAME,
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTY
PE, SERVICETYPE) values ('ajiani', '203.96.58.145', 2054, '301102652', 9356053
01, '203.96.51.115', 'Async', '')
Thu Aug 26 07:27:41 1999: DEBUG: Handling with Radius::AuthEMERALD
Thu Aug 26 07:27:41 1999: DEBUG: Handling accounting with Radius::AuthEMERALD
Thu Aug 26 07:27:41 1999: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctSessio
nId, NASIdentifier, NASPort)
values
('ajiani', 'Aug 26, 1999 6:21', 1, 0, '301102652', '203.96.58.
145', 2054)
Thu Aug 26 07:27:41 1999: DEBUG: Accounting accepted
*** Sending to 203.96.58.146 port 32846 ....
Code: Accounting-Response
Identifier: 137
Authentic: $8<186><233><227><153><159>b<176>?<194><239><138><18>v
Attributes:
Cheers
John
--
John Vorstermans || As the mind, so the man;
Actrix Networks Limited || bondage or liberation are in
Level 1, 282 Wakefield St, Wellington NZ || your own mind.
Phone (021) 432-987 || Sanskrit saying.
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
