Apostrophe in username
    Dom Latter 
    freeradius-users at latter.org
       
    Tue Oct 30 16:31:21 CET 2018
    
    
  
We are using a mysql-backed v3 server and eap / peap / mschapv2.
A new user has come along whose email address contains an apostrophe,
('single quote' if you prefer) which is unusual but legitimate.
By default we allow users to use their email address as a username.
I have found the safe_characters list here:
/etc/freeradius/mods-config/sql/main/mysql/queries.conf
Without the apostrophe in the safe_characters list, it gets encoded to
=27 and so the db query [1] fails to find a user with that username.
With the apostrophe in the list, the query fails with "an error in your
SQL syntax"...
Is there any way out of this conundrum except putting mime-encoded
data in the database?
[1] authorize_check_query from sql/mysql/dialup.conf
    
    
More information about the Freeradius-Users
mailing list