2016-09-15 - Re: Power Off and User Re-Login
Header Data
From: Hotspotuser <jo***s@algardata.pt>
Message Hash: 76524d9b9ef991d691a4efc296b149e874d8d57074fadefd6ff295eb4617e08c
Message ID: <0ddb8d24-1b95-4d16-9cce-f4b7a7b574ed@grasehotspot.org>
Reply To: <c1f08161-14dd-4ef9-850b-15fba30a167d@grasehotspot.org>
UTC Datetime: 2016-09-15 06:45:58 UTC
Raw Date: Thu, 15 Sep 2016 06:45:58 -0700
Raw message
If you dont have that match itens in radacct table, why not go for:
$query = "SELECT CallingStationId, UserName, FramedIpAddress, AcctStopTime
FROM radius.radacct WHERE UserName != 'CoovaChilli' Group BY
CallingStationId ORDER by RadAcctId DESC";
Which gets all the unique MACs in the radacct table, which you problably
clean every 2 months right?
And try to reconnect everyone?
quinta-feira, 15 de Setembro de 2016 às 14:44:19 UTC+1, Hotspotuser
escreveu:
>
> As another simplier solution... how long is your Default Session Idle
> Timeout set to be in the Grase "Coova Chilli Settings" page? If you have
> like one year (in seconds), do they have to type the password once again,
> once the server reboots? What about the DHCP Lease time setting? have
> you tried that?
>
> quinta-feira, 15 de Setembro de 2016 às 14:39:04 UTC+1, Hotspotuser
> escreveu:
>>
>> This script only works for connections that did not end, i.e. dont have a
>> AcctStopTime (a server unwanted poweroff, not a normal shutdown/reboot).
>>
>> If you want to enable the autoreconnect, you will have to change the SQL
>> query to search for a different status as Tim rightly mentioned in his
>> post
>> <https://groups.google.com/a/grasehotspot.org/d/msg/grase-hotspot/DD2emcSZCvw/aqYKpvdPAQAJ>
>> .
>>
>> something in the lines of...
>>
>> $query = "SELECT CallingStationId, UserName, FramedIpAddress,
>> AcctStopTime FROM radius.radacct WHERE UserName != 'CoovaChilli' and
>> AcctStopTime is null or month(AcctStopTime) = month(now()) and
>> CallingStationId in ('".implode("','",$macs_connected)."') Group BY
>> CallingStationId ORDER by RadAcctId DESC";
>>
>> Notice the new filter : or month(AcctStopTime) = month(now())
>>
>> This will not only give you the ones that are already connected but also
>> the ones that have had a session in the current month.
>>
>>
>> quinta-feira, 15 de Setembro de 2016 às 13:18:15 UTC+1, Eliot Ness
>> escreveu:
>>>
>>> Yes, the last wget one works.
>>> But still devices do not reconnect.
>>> Even without a normal shutdown, login screen comes up.
>>> It must be something with AcctStopTime
>>>
>>>
>>> On Thursday, June 2, 2016 at 9:40:51 AM UTC+3, Eliot Ness wrote:
>>>>
>>>> At least one Pi2 comes yesterday in my hands, and ....grase run again.
>>>> Detailed tutorial steps install on next days.
>>>>
>>>> As simple question : On power off or reboot, user have login again,
>>>> except if admin store mac adr.
>>>>
>>>> Is there any way on grase to remember users after reboot ? So no need
>>>> user to login again....
>>>>
>>>> Anyone?
>>>>
>>>
Thread
- Return to June 2016
- Return to July 2016
- Return to August 2016
-
Return to September 2016
- Return to “Hotspotuser <jo***s@algardata.pt>”
- Return to “Eliot Ness <sc***7@googlemail.com>”
- Return to “Timothy White <ti***8@gmail.com>”
-
Return to “Edward Allen <yb***j@gmail.com>”
- 2016-06-01 (Wed, 01 Jun 2016 23:40:51 -0700) - Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-06-02 (Thu, 02 Jun 2016 19:20:48 +1000) - Re: [GRASE-Hotspot] Power Off and User Re-Login - Timothy White <ti***8@gmail.com>
- 2016-07-08 (Fri, 08 Jul 2016 08:08:15 -0700) - Re: [GRASE-Hotspot] Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-08-05 (Fri, 05 Aug 2016 16:08:15 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-08-08 (Mon, 08 Aug 2016 01:47:54 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-08-10 (Wed, 10 Aug 2016 11:16:43 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-08-11 (Thu, 11 Aug 2016 02:00:13 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-08-11 (Thu, 11 Aug 2016 16:56:42 +0000) - Re: [GRASE-Hotspot] Re: Power Off and User Re-Login - Edward Allen <yb***j@gmail.com>
- 2016-08-11 (Thu, 11 Aug 2016 02:00:13 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-08-16 (Tue, 16 Aug 2016 23:34:06 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-08-17 (Wed, 17 Aug 2016 03:01:35 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-08-25 (Thu, 25 Aug 2016 14:10:25 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-08-26 (Fri, 26 Aug 2016 02:28:20 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-08-28 (Sun, 28 Aug 2016 12:16:44 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-09-09 (Fri, 09 Sep 2016 06:11:38 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-09-10 (Sat, 10 Sep 2016 20:33:15 +1000) - Re: [GRASE-Hotspot] Re: Power Off and User Re-Login - Timothy White <ti***8@gmail.com>
- 2016-09-13 (Tue, 13 Sep 2016 01:42:44 -0700) - Re: [GRASE-Hotspot] Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-10 (Sat, 10 Sep 2016 20:33:15 +1000) - Re: [GRASE-Hotspot] Re: Power Off and User Re-Login - Timothy White <ti***8@gmail.com>
- 2016-09-13 (Tue, 13 Sep 2016 06:39:36 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-09-13 (Tue, 13 Sep 2016 06:45:00 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-13 (Tue, 13 Sep 2016 07:38:47 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-09-13 (Tue, 13 Sep 2016 07:44:28 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-13 (Tue, 13 Sep 2016 07:46:51 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-13 (Tue, 13 Sep 2016 07:44:28 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-15 (Thu, 15 Sep 2016 05:18:15 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-09-15 (Thu, 15 Sep 2016 06:39:04 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-15 (Thu, 15 Sep 2016 06:44:18 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-15 (Thu, 15 Sep 2016 06:45:58 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-15 (Thu, 15 Sep 2016 06:44:18 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-15 (Thu, 15 Sep 2016 06:47:00 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-15 (Thu, 15 Sep 2016 06:39:04 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-17 (Sat, 17 Sep 2016 07:30:01 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-09-20 (Tue, 20 Sep 2016 05:57:02 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-09-27 (Tue, 27 Sep 2016 09:55:32 -0700) - Re: Power Off and User Re-Login - Eliot Ness <sc***7@googlemail.com>
- 2016-09-20 (Tue, 20 Sep 2016 05:57:02 -0700) - Re: Power Off and User Re-Login - Hotspotuser <jo***s@algardata.pt>
- 2016-06-02 (Thu, 02 Jun 2016 19:20:48 +1000) - Re: [GRASE-Hotspot] Power Off and User Re-Login - Timothy White <ti***8@gmail.com>