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@lists.freeradius.org> on behalf of Alan DeKok <aland@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@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