Dear freeradius-users list members,
I am testing on freeradius server with X-Supplicant and PostgreSQL. The
client_encoding in DB is set to UTF-8 by default.
When configuring login name and password in english text, authentication is
successfully completed. However, when i use UTF-8 characters as login name,
freeradius server is dropping the packets and the error message i found in
server is login name is incorrect. But the loginname configured in xsupplicant
and freeradius are same (UTF-8 format). I guess the FreeRadius does not support
UTF-8 chars and hence, passes some junk (letters converted into DECIMAL with
"=" prefix).
Below is the log of Freeradius when run in DEBUG mode.
**********************************************************************************************
Mon Dec 22 19:46:38 2008 : Debug: modsingle[authorize]: calling sql (rlm_sql)
for request 19
Mon Dec 22 19:46:38 2008 : Debug: expand: %{User-Name} ->
ã??ã?¹ã??ã??èµ·ã??ã?£ã?¦ã??ã??
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql (sql): sql_set_user escaped user -->
'ã??ã?¹ã??ã??èµ·ã??ã?£ã?¦ã??ã??'
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql (sql): Reserving sql socket id: 0
Mon Dec 22 19:46:38 2008 : Debug: expand: SELECT id, UserName, Attribute,
Value, Op FROM radcheck WHERE Username = '%{SQL-User-Name}'
ORDER BY id -> SELECT id, UserName, Attribute, Value, Op FROM radcheck
WHERE Username =
'=EF=BB=BF=E3=83=86=E3=82=B9=E3=83=88=E3=81=8C=E8=B5=B7=E3=81=93=E3=81=A3=E3=81=A6=E3=81=84=E3=82=8B'
ORDER BY id
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql_postgresql: query: SELECT id,
UserName, Attribute, Value, Op FROM radcheck WHERE Username =
'=EF=BB=BF=E3=83=86=E3=82=B9=E3=83=88=E3=81=8C=E8=B5=B7=E3=81=93=E3=81=A3=E3=81=A6=E3=81=84=E3=82=8B'
ORDER BY id
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql_postgresql: Status: PGRES_TUPLES_OK
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql_postgresql: query affected rows = 0 ,
fields = 5
Mon Dec 22 19:46:38 2008 : Debug: expand: SELECT GroupName FROM usergroup
WHERE UserName='%{SQL-User-Name}' -> SELECT GroupName FROM usergroup WHERE
UserName='=EF=BB=BF=E3=83=86=E3=82=B9=E3=83=88=E3=81=8C=E8=B5=B7=E3=81=93=E3=81=A3=E3=81=A6=E3=81=84=E3=82=8B'
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql_postgresql: query: SELECT GroupName
FROM usergroup WHERE
UserName='=EF=BB=BF=E3=83=86=E3=82=B9=E3=83=88=E3=81=8C=E8=B5=B7=E3=81=93=E3=81=A3=E3=81=A6=E3=81=84=E3=82=8B'
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql_postgresql: Status: PGRES_TUPLES_OK
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql_postgresql: query affected rows = 0 ,
fields = 1
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql (sql): Released sql socket id: 0
Mon Dec 22 19:46:38 2008 : Debug: rlm_sql (sql): User
ã??ã?¹ã??ã??èµ·ã??ã?£ã?¦ã??ã?? not found
Mon Dec 22 19:46:38 2008 : Debug: modsingle[authorize]: returned from sql
(rlm_sql) for request 19
Mon Dec 22 19:46:38 2008 : Debug: ++[sql] returns notfound
**********************************************************************************************
Is there any way to achieve UTF-8 support only with postgresql queries (some
kind of conversion to binary and then can be compared with radcheck and
radreply) or is there any tweak with Freeradius?
Regards
Elayaraja P
________________________________
"DISCLAIMER: This message is proprietary to Aricent and is intended solely for
the use of the individual to whom it is addressed. It may contain privileged or
confidential information and should not be circulated or used for any purpose
other than for what it is intended. If you have received this message in
error,please notify the originator immediately. If you are not the intended
recipient, you are notified that you are strictly prohibited from using,
copying, altering, or disclosing the contents of this message. Aricent accepts
no responsibility for loss or damage arising from the use of the information
transmitted by this email including damage from virus."
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
