Hi.
I have been experimenting with the TimeLeft option. I seem to have it
working correctly where Rediator picks up the Time the User has left on
their account and I can see it coming through the logfile below as sa.TimeLeft.
I set this to -5 which I would thought would have been no time left but the
user is still able to login. That is Radiator authorises the connection. I
would have thought it would NOT authorise the connection if this was a
negative number? Am I seeing this from a different perspective than I should?
Also, if the user runs out of time while on-line how can we ensure that the
connection is dropped? Do I need to install the snmp module for this?
We are running radiator 1.14 along with Platypus/Emerald.cfg
Any pointers would be appreciated.
Relevant logfile below.
Cheers
John
Tue Oct 26 16:43:58 1999: DEBUG: Packet dump:
*** Received from 203.96.58.18 port 32812 ....
Code: Access-Request
Identifier: 94
Authentic: <203><155>w<173><239>I<182><13><150><204><130>c<18><27>&<249>
Attributes:
User-Name = "jjcv2"
CHAP-Password = "<1>=<251>?<201><162>9<<201><155>D<171>zMZr<20>"
NAS-IP-Address = 203.96.58.17
NAS-Port = 2195
NAS-Port-Type = Async
State = ""
Called-Station-Id = "78686"
Acct-Session-Id = "298109374"
Ascend-Data-Rate = 26400
Ascend-Xmit-Rate = 26400
Tue Oct 26 16:43:58 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Tue Oct 26 16:43:58 1999: DEBUG: Deleting session for jjcv2, 203.96.58.17,
2195
Tue Oct 26 16:43:58 1999: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='203.96.58.17' and NASPORT=2195
Tue Oct 26 16:43:58 1999: DEBUG: Handling with Radius::AuthEMERALD
Tue Oct 26 16:43:58 1999: DEBUG: Handling with Radius::AuthEMERALD
Tue Oct 26 16:43:58 1999: DEBUG: Query is: select DateAdd(Day,
ma.extension, maExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
sa.password, sa.login, sa.shell, sa.TimeLeft ,sa.LoginLimit
from masteraccounts ma, subaccounts sa
where (sa.login = 'jjcv2' or sa.shell = 'jjcv2')
and ma.customerid = sa.customerid
and sa.active <> 0 and ma.active <> 0
Tue Oct 26 16:43:58 1999: DEBUG: Select results: Dec 31 1999 12:00AM, Dec
31 1999 12:00AM, 7714, PPP, xxxxxx, jjcv2, , -5, 1
Tue Oct 26 16:43:58 1999: DEBUG: Query is: select ra.RadAttributeID, Data,
Value, Type
from RadConfigs rc, RadAttributes ra
where ra.RadAttributeID = rc.RadAttributeID and rc.AccountID=7714
Tue Oct 26 16:43:58 1999: DEBUG: Query is: select ra.RadAttributeID, Data,
Value, Type
from RadATConfigs rc, RadAttributes ra
where ra.RadAttributeID = rc.RadAttributeID
and rc.AccountType='PPP'
Tue Oct 26 16:43:58 1999: DEBUG: Radius::AuthEMERALD looks for match with jjcv2
Tue Oct 26 16:43:58 1999: DEBUG: Expiration date converted to: 946551600
Tue Oct 26 16:43:58 1999: DEBUG: Expiration date converted to: 946551600
Tue Oct 26 16:43:58 1999: DEBUG: Query is: select NASIDENTIFIER, NASPORT,
ACCTSESSIONID from RADONLINE where USERNAME='jjcv2'
Tue Oct 26 16:43:58 1999: DEBUG: Radius::AuthEMERALD ACCEPT:
Tue Oct 26 16:43:58 1999: DEBUG: Access accepted for jjcv2
Tue Oct 26 16:43:58 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.18 port 32812 ....
Code: Access-Accept
Identifier: 94
Authentic: <203><155>w<173><239>I<182><13><150><204><130>c<18><27>&<249>
Attributes:
Framed-IP-Netmask = 255.255.255.255
Service-Type = 2
Framed-Protocol = 1
Idle-Timeout = 1200
Framed-Compression = 1
Tue Oct 26 16:43:58 1999: DEBUG: Packet dump:
*** Received from 203.96.58.146 port 32918 ....
Code: Accounting-Request
Identifier: 39
Authentic: <140><192>e<21>\<159>B<170><192><214>p<164>SkU<8>
Attributes:
User-Name = "jjcv2"
NAS-IP-Address = 203.96.58.17
NAS-Port = 2195
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "298109374"
Acct-Authentic = RADIUS
Ascend-Modem-PortNo = 32
Ascend-Modem-SlotNo = 12
Ascend-Modem-ShelfNo = 1
Called-Station-Id = "78686"
Framed-Protocol = PPP
Framed-IP-Address = 203.96.49.22
Timestamp = 940904558
Tue Oct 26 16:43:58 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Tue Oct 26 16:43:58 1999: DEBUG: Adding session for jjcv2, 203.96.58.17, 2195
Tue Oct 26 16:43:58 1999: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='203.96.58.17' and NASPORT=2195
Tue Oct 26 16:43:58 1999: DEBUG: do query is: insert into RADONLINE
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('jjcv2', '203.96.58.17',
2195, '298109374', 940904558, '203.96.49.22', 'Async', '')
Tue Oct 26 16:43:58 1999: DEBUG: Handling with Radius::AuthEMERALD
Tue Oct 26 16:43:58 1999: DEBUG: Handling accounting with Radius::AuthEMERALD
Tue Oct 26 16:43:58 1999: DEBUG: do query is: insert into Calls
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctSessionId,
NASIdentifier, NASPort)
values
('jjcv2', 'Oct 26, 1999 15:22', 1, 0, '298109374', '203.96.58.17',
2195)
Tue Oct 26 16:43:58 1999: DEBUG: Accounting accepted
Tue Oct 26 16:43:58 1999: DEBUG: Packet dump:
*** Sending to 203.96.58.146 port 32918 ....
Code: Accounting-Response
Identifier: 39
Authentic: <140><192>e<21>\<159>B<170><192><214>p<164>SkU<8>
Attributes:
--
John Vorstermans || We are what we repeatedly do.
Technical Manager || - Aristotle
Actrix Networks
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
