Thanks Michael, I will try that and see if it goes. Cheers, Jennings
-----Original Message----- From: Michael [mailto:ri...@vianet.ca] Sent: Thursday, 19 April 2012 2:57 PM To: Jennings Tuala Cc: Mike Puchol; radiator@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:puc...@me.com <mailto:puc...@me.com>] > *Sent:* Saturday, 14 April 2012 2:42 AM > *To:* Jennings Tuala > *Cc:* radiator@open.com.au <mailto:radiator@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 <jtu...@blueskysamoa.com <mailto:jtu...@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@open.com.au <mailto:radiator@open.com.au> > http://www.open.com.au/mailman/listinfo/radiator > > > > _______________________________________________ > radiator mailing list > radiator@open.com.au > http://www.open.com.au/mailman/listinfo/radiator _______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator