converting username to lowercase

[JAHANZAIB SYED]

you mean, in dialup.conf uncomment following?

        # Use these for case sensitive usernames.
#        authorize_check_query = "SELECT id, username, attribute, value, op \
#         FROM ${authcheck_table} \
#         WHERE username = BINARY '%{SQL-User-Name}' \
#         ORDER BY id"
#        authorize_reply_query = "SELECT id, username, attribute, value, op \
#         FROM ${authreply_table} \
#         WHERE username = BINARY '%{SQL-User-Name}' \
#         ORDER BY id"



________________________________
From: Freeradius-Users <freeradius-users-bounces+aacable79=gmail.com at lists.freeradius.org> on behalf of Alan DeKok <aland at deployingradius.com>
Sent: Friday, September 21, 2018 7:14 PM
To: FreeRadius users mailing list
Subject: Re: converting username to lowercase

On Sep 21, 2018, at 10:11 AM, JAHANZAIB SYED <aacable at hotmail.com> wrote:
>
> I am running FreeRADIUS Version 2.2.8 (yes its old) along with Mikrotik Router as NAS (pppoe Server)
> in radacct table see some user entries with mixed uppercase ,example
>
> User1
> USER2
>
> in radcheck, the user is defined in lower case. why radacct is putting some user with random lower/uppercase ?

  Because it's storing what the user enters.

> How can I force it to use only lowercase for usernames?

  Check if the user is logging in with the wrong case, and reject them.

  This is all done by default in v3...

  Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html