[SOLVED] freeradius2 and MySQL problems with German Umlaut

[john.wayne1]

We have a setup using freeradius2 package and MySQL as database for authentication.

The freeradius2 GUI on pfSense doesn't allow to save a password having German Umlaut but if setting it directly in the users file

/usr/local/etc/raddb/users
"guest" Cleartext-Password := "müller"

it is set and checked correctly in the Captive Portal.

When enabling SQL Support for freeradius2 and setting the password "müller" in the radcheck table it wont work.

Tried different collations (utf8_general_ci, utf8_bin, utf8_unicode_ci,  latin1_german2_ci) for the radcheck table but without success.

Does anyone have some experience with this?  ::)

[john.wayne1]

Issue created: https://redmine.pfsense.org/issues/7403