Project

General

Profile

Bug #7403

Captive Portal + freeradius2 + MySQL problems with German Umlaut

Added by John Wayne 4 months ago. Updated 4 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
FreeRADIUS
Target version:
-
Start date:
03/17/2017
Due date:
% Done:

0%

Affected version:
2.3.3_1
Affected Architecture:
amd64

Description

We have a setup using a Captive Portal and freeradius2 package + 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 adding content-type and accept-charset in portal index.php file
header('Content-Type: text/html; charset=UTF-8');
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
<form ... accept-charset="UTF-8">

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

Captive Portal + freeradius2 works.
Captive Portal + freeradius2 + MySQL doesn't work.

Does anyone have some experience with this?

pfSense-2.3.3_1
freeradius2-1.7.7
MySQL-5.6.25

History

#1 Updated by John Wayne 4 months ago

In the log files it seems all correct:

Mar 17 13:41:05 radiusd 74676 Login incorrect: [guest/müller] (from client 127.0.0.1 port 3006 cli a5:2a:52:f2:21:85)

Also available in: Atom PDF