Freeradius-Users Digest, Vol 165, Issue 68

[Soklang Sum]

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 at lists.freeradius.org> On Behalf Of freeradius-users-request at lists.freeradius.org
Sent: Sunday, January 27, 2019 6:00 PM
To: freeradius-users at lists.freeradius.org
Subject: Freeradius-Users Digest, Vol 165, Issue 68

Send Freeradius-Users mailing list submissions to
	freeradius-users at 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 at lists.freeradius.org

You can reach the person managing the list at
	freeradius-users-owner at 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 at gmail.com>
To: "'FreeRadius users mailing list'"
	<freeradius-users at 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 at deployingradius.com>
To: FreeRadius users mailing list
	<freeradius-users at lists.freeradius.org>
Subject: Re: Session start times issues
Message-ID: <717983BF-2594-4316-807F-0726F706BD53 at deployingradius.com>
Content-Type: text/plain;	charset=us-ascii

On Jan 26, 2019, at 8:43 AM, Philemon Jaomalaza <philemon.jaomalaza at 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
*************************************************