[RADIATOR] Idle timeout issue
Jennings Tuala
jtuala at blueskysamoa.com
Wed Apr 18 21:09:37 CDT 2012
Thanks Michael, I will try that and see if it goes.
Cheers,
Jennings
-----Original Message-----
From: Michael [mailto:ringo at vianet.ca]
Sent: Thursday, 19 April 2012 2:57 PM
To: Jennings Tuala
Cc: Mike Puchol; radiator at open.com.au
Subject: Re: [RADIATOR] Idle timeout issue
maybe need Idle-Timeout = 0 in your authentication accept reply packet?
eg. AddToReplyIfNotExist Idle-Timeout = 0
On 12-04-18 09:24 PM, Jennings Tuala wrote:
> Hi Mike,
>
> I have tried again this time with laptop on continuously, not going to
sleep and it still cuts out the connection. I have pasted my radius.cfg
for your perusal.
>
> LogDir /var/log/radius
>
> DbDir /etc/radiator
>
> # Use a low trace level in production systems. Increase
>
> # it to 4 or 5 for debugging, or use the -trace flag to radiusd
>
> Trace 4
>
> AuthPort 1812
>
> AcctPort 1813
>
> # You will probably want to add other Clients to suit your site,
>
> # one for each NAS you want to work with
>
> <Client DEFAULT>
>
> Secret xxxxxxx
>
> DupInterval 0
>
> </Client>
>
> <Client 1.1.1.1>
>
> Secret xxxxxxx
>
> AuthPort 1182
>
> AcctPort 1183
>
> DupInterval 0
>
> </Client>
>
> <SessionDatabase SQL>
>
> DBSource dbi:mysql:bluezone
>
> DBUsername root
>
> DBAuth xxxyyyzzz
>
> AddQuery insert into SUBSCRIBERS (USERNAME, \
>
> NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, \
>
> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE, DNIS)
>
> values ('%n', '%N', \
>
> %{NAS-Port}, �%{Acct-Session-Id}�, %{Timestamp},\
>
> �%{Framed-IP-Address}�, �%{NAS-Port-Type}�, \
>
> �%{Service-Type}�, �%{Called-Station-Id}�)
>
> </SessionDatabase>
>
> <Handler>
>
> <AuthBy SQL>
>
> DBSource dbi:mysql:bluezone
>
> DBUsername root
>
> DBAuth xxxyyyzzz
>
> # Only one Session per user at a time
>
> DefaultSimultaneousUse 1
>
> # Let the user IN if they have any time
left, set
>
> # the Session-Timeout to the time left
>
> AuthSelect select PASSWORD,
SESSIONTIMEOUT from SUBSCRIBERS where USERNAME=%0 and SESSIONTIMEOUT > 0
>
> AuthColumnDef 0, User-Password, check
>
> AuthColumnDef 1, Session-Timeout, reply
>
> # Adjust the time left when they log
out
>
> AccountingStopsOnly
>
> AcctSQLStatement update SUBSCRIBERS set
SESSIONTIMEOUT=SESSIONTIMEOUT-0%{Acct-Session-Time} where USERNAME='%n'
>
> AccountingTable SUBSCRIBERS
>
> </AuthBy>
>
> </Handler>
>
> Thanks and look forward to your response.
>
> Cheers,
>
> Jennings
>
> *From:*Mike Puchol [mailto:puchol at me.com <mailto:puchol at me.com>]
> *Sent:* Saturday, 14 April 2012 2:42 AM
> *To:* Jennings Tuala
> *Cc:* radiator at open.com.au <mailto:radiator at open.com.au>
> *Subject:* Re: [RADIATOR] Idle timeout issue
>
> Acct terminate cause is User-Request, meaning the hotspot received a
session end instruction from the device, eg. logoff URL, or a
disassociation which the hotspot translates as User-Request (eg. laptop
going to sleep). There is no Session-Timeout or Idle-Timeout in the logs
that would correspond to what you describe.
>
>
> On Apr 13, 2012, at 3:26 PM, Jennings Tuala <jtuala at blueskysamoa.com
<mailto:jtuala at blueskysamoa.com>> wrote:
>
> Hi there,
>
> I�m having some issues with idle timeouts in radiator. Users are
suddenly being disconnected after say 25 minutes of inactivity. This never
used to happen before so I attached a trace 4 debug for you to have a look
at. Would greatly appreciate your assistance please.
>
> Thanks,
>
> Jay
>
> Tue Apr 10 15:48:32 2012: DEBUG: Packet dump:
>
> *** Received from 110.5.112.85 port 32817 ....
>
> Code: Access-Request
>
> Identifier: 29
>
> Authentic:
<137><202><239><165><163>W<22><229>Xfg<168>&<144><174><216>
>
> Attributes:
>
> User-Name = "6100510"
>
> User-Password =
@[<4>=<161><221><154>u<141><0><143><5><1><165>_<250>
>
> NAS-IP-Address = 110.5.112.85
>
> Service-Type = Login-User
>
> Framed-IP-Address = 10.17.4.212
>
> Called-Station-Id = "00:90:0B:05:6B:14"
>
> Calling-Station-Id = "38:59:f9:80:c8:5d"
>
> NAS-Identifier = "110.5.112.85"
>
> Acct-Session-Id = "00:90:0B:05:6B:14:133411720333317"
>
> NAS-Port-Type = Wireless-IEEE-802-11
>
> Tue Apr 10 15:48:32 2012: DEBUG: Handling request with Handler '',
Identifier ''
>
> Tue Apr 10 15:48:32 2012: DEBUG: Deleting session for 6100510,
110.5.112.85,
>
> Tue Apr 10 15:48:32 2012: DEBUG: do query is: 'delete from RADONLINE
where NASIDENTIFIER='110.5.112.85' and NASPORT=0':
>
> Tue Apr 10 15:48:32 2012: DEBUG: Handling with Radius::AuthSQL:
>
> Tue Apr 10 15:48:32 2012: DEBUG: Handling with Radius::AuthSQL:
>
> Tue Apr 10 15:48:32 2012: DEBUG: Query is: 'select PASSWORD,
SESSIONTIMEOUT from SUBSCRIBERS where USERNAME='6100510' and
SESSIONTIMEOUT > 0':
>
> Tue Apr 10 15:48:32 2012: DEBUG: Radius::AuthSQL looks for match
with 6100510 [6100510]
>
> Tue Apr 10 15:48:32 2012: DEBUG: Radius::AuthSQL ACCEPT: : 6100510
[6100510]
>
> Tue Apr 10 15:48:32 2012: DEBUG: AuthBy SQL result: ACCEPT,
>
> Tue Apr 10 15:48:32 2012: DEBUG: Access accepted for 6100510
>
> Tue Apr 10 15:48:32 2012: DEBUG: Packet dump:
>
> *** Sending to 110.5.112.85 port 32817 ....
>
> Code: Access-Accept
>
> Identifier: 29
>
> Authentic:
<253>;<226>m<181>{}V<28><250><198><209><179><151><176><224>
>
> Attributes:
>
> Session-Timeout = 86400
>
> Tue Apr 10 15:48:32 2012: DEBUG: Packet dump:
>
> *** Received from 110.5.112.85 port 32817 ....
>
> Code: Accounting-Request
>
> Identifier: 30
>
> Authentic: {<211>=c;_<160><152>Z<132><22><10>RE<253><3>
>
> Attributes:
>
> User-Name = "6100510"
>
> Acct-Status-Type = Start
>
> Acct-Session-Id = "00:90:0B:05:6B:14:133411720333317"
>
> Acct-Authentic = Local
>
> NAS-Identifier = "110.5.112.85"
>
> NAS-IP-Address = 110.5.112.85
>
> Calling-Station-Id = "38:59:f9:80:c8:5d"
>
> Called-Station-Id = "00:90:0B:05:6B:14"
>
> Framed-IP-Address = 10.17.4.212
>
> NAS-Port-Type = Wireless-IEEE-802-11
>
> Tue Apr 10 15:48:32 2012: DEBUG: Handling request with Handler '',
Identifier ''
>
> Tue Apr 10 15:48:32 2012: DEBUG: Adding session for 6100510,
110.5.112.85,
>
> Tue Apr 10 15:48:32 2012: DEBUG: do query is: 'delete from RADONLINE
where NASIDENTIFIER='110.5.112.85' and NASPORT=00':
>
> Tue Apr 10 15:48:32 2012: DEBUG: do query is: 'insert into
SUBSCRIBERS (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS,
>
> NASPORTTYPE, SERVICETYPE, DNIS)':
>
> Tue Apr 10 15:48:32 2012: ERR: do failed for 'insert into
SUBSCRIBERS (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS,
>
> NASPORTTYPE, SERVICETYPE, DNIS)': You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for
the right
>
> syntax to use near '' at line 1
>
> Tue Apr 10 15:48:32 2012: ERR: do failed for 'insert into
SUBSCRIBERS (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS,
>
> NASPORTTYPE, SERVICETYPE, DNIS)': You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for
the right
>
> syntax to use near '' at line 1
>
> Tue Apr 10 15:48:32 2012: DEBUG: Handling with Radius::AuthSQL:
>
> Tue Apr 10 15:48:32 2012: DEBUG: Handling accounting with
Radius::AuthSQL
>
> Tue Apr 10 15:48:32 2012: DEBUG: AuthBy SQL result: ACCEPT,
>
> Tue Apr 10 15:48:32 2012: DEBUG: Accounting accepted
>
> Tue Apr 10 15:48:32 2012: DEBUG: Packet dump:
>
> *** Sending to 110.5.112.85 port 32817 ....
>
> Code: Accounting-Response
>
> Identifier: 30
>
> Authentic: <159><4>g<161><5>4,Pq<29><169>L<159><251><160><242>
>
> Attributes:
>
> Tue Apr 10 16:14:18 2012: DEBUG: Packet dump:
>
> *** Received from 110.5.112.85 port 32817 ....
>
> Code: Accounting-Request
>
> Identifier: 29
>
> Authentic: <153>3B}f<158><172>Pb<30><192><139><246><23>h<148>
>
> Attributes:
>
> User-Name = "6100510"
>
> Acct-Status-Type = Stop
>
> Acct-Session-Id = "00:90:0B:05:6B:14:133411720333317"
>
> Acct-Authentic = RADIUS
>
> Acct-Session-Time = 1547
>
> NAS-Identifier = "110.5.112.85"
>
> NAS-IP-Address = 110.5.112.85
>
> Acct-Input-Octets = 1069902
>
> Acct-Output-Octets = 93367
>
> Acct-Input-Packets = 1017
>
> Acct-Output-Packets = 1087
>
> Calling-Station-Id = "38:59:f9:80:c8:5d"
>
> Called-Station-Id = "00:90:0B:05:6B:14"
>
> Framed-IP-Address = 10.17.4.212
>
> NAS-Port-Type = Wireless-IEEE-802-11
>
> Class = " "
>
> Acct-Terminate-Cause = User-Request
>
> Tue Apr 10 16:14:18 2012: DEBUG: Handling request with Handler '',
Identifier ''
>
> Tue Apr 10 16:14:18 2012: DEBUG: Deleting session for 6100510,
110.5.112.85,
>
> Tue Apr 10 16:14:18 2012: DEBUG: do query is: 'delete from RADONLINE
where NASIDENTIFIER='110.5.112.85' and NASPORT=0':
>
> Tue Apr 10 16:14:18 2012: DEBUG: Handling with Radius::AuthSQL:
>
> Tue Apr 10 16:14:18 2012: DEBUG: Handling accounting with
Radius::AuthSQL
>
> Tue Apr 10 16:14:18 2012: DEBUG: do query is: 'update SUBSCRIBERS
set SESSIONTIMEOUT="until Time" where USERNAME='6100510'':
>
> Tue Apr 10 16:14:18 2012: DEBUG: AuthBy SQL result: ACCEPT,
>
> Tue Apr 10 16:14:18 2012: DEBUG: Accounting accepted
>
> Tue Apr 10 16:14:18 2012: DEBUG: Packet dump:
>
> *** Sending to 110.5.112.85 port 32817 ....
>
> Code: Accounting-Response
>
> Identifier: 29
>
> Authentic: <203>W~n<225><215>'<26><206><28><183>}<161><181><240><6>
>
> Attributes:
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au <mailto:radiator at open.com.au>
> http://www.open.com.au/mailman/listinfo/radiator
>
>
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator
More information about the radiator
mailing list