Dear Team Freeradius, I would like to ask about FreeRADIUS work with google authenticator (2FA) or not? I have tried to install freeRADIUS with google authenticator but it doesn't work, when I try install following the guideline any website like https://networkjutsu.com/freeradius-google-authenticator/ it always rejected. So that why I want to make sure from team expertise freeRADIUS it work with google authenticator or not? But I saw in the guideline it works but for me never work. Please help feedback soon as possible. Thanks =================== -----Original Message----- From: Freeradius-Users <freeradius-users-bounces+soklang.sum=cambotech.com@lists.freeradius.org> On Behalf Of freeradius-users-request@lists.freeradius.org Sent: Sunday, January 27, 2019 6:00 PM To: freeradius-users@lists.freeradius.org Subject: Freeradius-Users Digest, Vol 165, Issue 68 Send Freeradius-Users mailing list submissions to freeradius-users@lists.freeradius.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.freeradius.org/mailman/listinfo/freeradius-users or, via email, send a message with subject or body 'help' to freeradius-users-request@lists.freeradius.org You can reach the person managing the list at freeradius-users-owner@lists.freeradius.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Freeradius-Users digest..." Today's Topics: 1. Session start times issues (Philemon Jaomalaza) 2. Re: Session start times issues (Alan DeKok) ---------------------------------------------------------------------- Message: 1 Date: Sat, 26 Jan 2019 16:43:23 +0300 From: "Philemon Jaomalaza" <philemon.jaomalaza@gmail.com> To: "'FreeRadius users mailing list'" <freeradius-users@lists.freeradius.org> Subject: Session start times issues Message-ID: <031301d4b57d$1e29c3a0$5a7d4ae0$@gmail.com> Content-Type: text/plain; charset="utf-8" Hello, If the nas has a wrong date and time, the sqlcounter does not work correctly. The attribute Event-Timestamp got the wrong data and time from nas. I found this features in preacct substitution: update request { &FreeRADIUS-Acct-Session-Start-Time = "%{expr: %l - %{%{Acct-Session-Time}:-0} - %{%{Acct-D$ } I uncomente it but nothing change. Where is the best way to have the good local time of radius server on "acctstarttime" column of "radacct" on sql database ? JMLZ --- L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. https://www.avast.com/antivirus ------------------------------ Message: 2 Date: Sat, 26 Jan 2019 14:35:02 -0500 From: Alan DeKok <aland@deployingradius.com> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: Session start times issues Message-ID: <717983BF-2594-4316-807F-0726F706BD53@deployingradius.com> Content-Type: text/plain; charset=us-ascii On Jan 26, 2019, at 8:43 AM, Philemon Jaomalaza <philemon.jaomalaza@gmail.com> wrote:

If the nas has a wrong date and time, the sqlcounter does not work correctly.

If I take the tires off of my car, it doesn't drive well. Solution: fix the REAL problem.

The attribute Event-Timestamp got the wrong data and time from nas.

Fix the NAS. Anything else is an ugly hack.

I found this features in preacct substitution:

update request { &FreeRADIUS-Acct-Session-Start-Time = "%{expr: %l - %{%{Acct-Session-Time}:-0} - %{%{Acct-D$ }

I uncomente it but nothing change.

Where is the best way to have the good local time of radius server on "acctstarttime" column of "radacct" on sql database ?

Fix the NAS. Alan DeKok. ------------------------------ Subject: Digest Footer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ------------------------------ End of Freeradius-Users Digest, Vol 165, Issue 68 *************************************************