View Issue Details

IDProjectCategoryView StatusLast Update
0004655SOGoWeb Mailpublic2019-01-23 12:40
Reporterultreia Assigned To 
Status newResolutionopen 
Platform[Server] LinuxOSDebianOS Version8 (Jessie)
Product Version4.0.5 
Summary0004655: Password change fails

In our infrastructure, we can login to webmail using a login(c_uid) or an email(mail). We use c_uid and mail as login fields. SQL Update fails if a user log into the webmail with his mail instead of his c_uid.

Additional Information


SQL: SELECT c_password FROM sogo WHERE (c_uid = '') OR (mail = '');
2019-01-22 18:14:10.892 sogod[4311:4311] <MySQL4Channel[0x0x559f4d43b730] connection=0x0x559f4d6d1628> query has results, entering fetch-mode.
2019-01-22 18:14:10.892 sogod[4311:4311] <MySQL4Channel[0x0x559f4d43b730] connection=0x0x559f4d6d1628> SQL: UPDATE sogo SET c_password = '12345' WHERE c_uid = '';

Update query fails because our c_uid is a login (example). If users log in via his login (example) instead of his mail ( query has success, but if they log in via mail, query fails.

| c_uid | c_name | c_password | c_cn | mail |
| example || 12345 |||

The fix could be something like: UPDATE sogo SET c_password = '12345' WHERE (c_uid = '') OR (mail = '');

TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-01-23 12:40 ultreia New Issue