Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    [SOLVED] freeradius2 and MySQL problems with German Umlaut

    Scheduled Pinned Locked Moved pfSense Packages
    2 Posts 1 Posters 542 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • J
      john.wayne1
      last edited by

      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?  ::)

      1 Reply Last reply Reply Quote 0
      • J
        john.wayne1
        last edited by

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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post
        Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.