View Issue Details

IDProjectCategoryView StatusLast Update
0004261SOGoWeb Mailpublic2020-08-04 16:00
Reporteredvil Assigned To 
Status newResolutionopen 
Platform[Server] LinuxOSDebianOS Version8 (Jessie)
Product Version3.2.10 
Summary0004261: SQL authentication with punycode encoded domain is not working

It is impossible to authenticate with a idn domain when using SQL authentication if domain are stored in punycode:

exemple test mailbox edvil@ë

SOGO request the following to authenticate :
SQL: SELECT c_password FROM sogov WHERE c_uid = 'edvil@ë';

which returns nothing because domain is punycoded.

The right request should be:
SELECT c_password FROM sogov WHERE c_uid = 'edvil@'';

Using punycoded domain to log in works.

Imho, there should be an option in sogo to encode/decode idn domains to/from punycode in sogo.conf.

Steps To Reproduce

Have a punycode encoded domain in a SQL database.
Configure sogo to use SQL auth.

TagsNo tags attached.


related to 0005094 new Display of punnycode domains (xn--) 


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-08-24 15:51 edvil New Issue
2020-08-04 16:00 Christian Mack Relationship added related to 0005094