Hello,
Has anybody come across issues related to 'special' characters used in either the username or the password of a ClearPass Guest user? One of my customers is experiencing is the following two issues:
1. User successfully self registered with the username “xxxxxxxx.o'boyle@xxxxxxxx.xxx” (Note: the "x"s replace the actual name and domain for privacy reason), however when she came to authenticate using WPA2-Enterprise she was unable to access the wifi and the clearpass message read:
“[Guest User Repository] - localhost: 42601 [unixODBC]ERROR: syntax error at or near 'boyle'; Error while executing the query”. Usernames without the apostrophy (') do not show the issue.
2. User successfully registered with a password ending with a “£”, however the user was unable to login with that password. Alert on clearpass is:
“MSCHAP: Authentication failed”.
At first this looks like she has entered her password incorrectly, we tested logging in with her credentials and we were unable – we removed the “£” from the users password and we authenticated successfully.
I haven't found anything relevant in the documentation and have already suggested to enable the "Disallowed characters" flag for the password, but since users are allowed to register with those characters on either the username or the password and then their authentication fails, I think there could be an issue here.
Thoughts?
Best regards,
Giuseppe Damiano/