View Issue Details

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

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

exemple test mailbox edvil@ëdvil.fr

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

which returns nothing because domain is punycoded.

The right request should be:
SELECT c_password FROM sogov WHERE c_uid = 'edvil@'xn--dvil-kpa.fr';

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.

Relationships

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

Activities

There are no notes attached to this issue.

Issue History

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