[SOGo] BTS activities for Friday, April 12 2019
Title: BTS activities for Friday, April 12 2019 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Friday, April 12 2019 idlast updatestatus (resolution)categorysummary 4719 2019-04-12 14:13:48 updated (open) Backend Calendar Certain Emoticons cause calendar events to not be accessbile 4734 2019-04-12 08:58:20 updated (open) Backend Calendar Repetitive events email 4731 2019-04-12 11:12:27 updated (open) Web Mail Cannot reply to any email -- users@sogo.nuhttps://inverse.ca/sogo/lists
[SOGo] SOGo multi-domains mysql with c_uid = mail -> address books / calendars use user@domain@domain
Hello! I've set up SOGo with sql authentification vs an existing mail server (MySQL). This works for SOGo login and Imap quite well. But when I want to grant access rights to address books / calendars to a different user the system queries for users like user@domain@domain. Which of course does not work and an error message "no users found" pops up. from the logs a) SOGo login SQL: SELECT c_password FROM sogo_test_de WHERE c_uid = 'us...@test.de'; -> success b) get user data SQL: SELECT * FROM sogo_test_de WHERE (c_domain = 'test.de') AND ((c_uid = 'us...@test.de') OR (mail = 'us...@test.de')); -> success c) find the other user for granting access SQL: SELECT * FROM sogo_test_de WHERE (LOWER(c_cn) LIKE '%user2%' OR LOWER(mail) LIKE '%user2%') AND (c_domain = 'test.de'); -> succcess d) a query when saving the access rights SQL: SELECT * FROM sogo_test_de WHERE (c_domain = 'test.de') AND ((c_uid = 'us...@test.de@test.de') OR (mail = 'us...@test.de@test.de')); -> failure my sogo.conf (excerpts) SOGoForceExternalLoginWithEmail = YES; SOGoEnableDomainBasedUID = YES; test.de = { SOGoMailDomain = test.de; SOGoSuperUsernames = ("us...@test.de"); // This is an array - keep the parens! SOGoUserSources = ( { type = sql; id = "sogo_test_de"; viewURL = "mysql://sogo:secret@localhost:3306/mail/sogo_test_de"; DomainFieldName = "c_domain"; canAuthenticate = YES; isAddressBook = NO; userPasswordAlgorithm = sha512; } ) } I've tried quite a number of further variants but have not found yet a way to enable login with the complete mail address (user@domain) without getting problems with the address books / calendars permissions (due user@domain@domain lookups). Regards, Michael -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Addressbook Sync Errors
I have installed CalDav Syncronizer for Outlook. SOGo is v4.0.7. When I try to sync the following error is logged on sogo.log: 2019-04-12 11:08:31.511 sogod[43707:100181] EXCEPTION: NAME:NSInvalidArgumentException REASON:'_name' must not be an empty string INFO:(null) while the CalDav tool generates so many messages. Sync fails of course. Any clue as to what could be the problem? My config block for Addressbook is: SOGoUserSources = ( { type = sql; id = directory; viewURL = "mysql://sogou:X@127.0.0.1:3306/exim4u/sogo_auth_view "; canAuthenticate = YES; isAddressBook = YES; listRequiresDot = NO; userPasswordAlgorithm = md5-crypt; displayName = "CSL Global Address Book"; } ); -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Passing the remote IP to dovecot
On 4/11/19 1:36 AM, André Rodier "(an...@rodier.me) wrote: How can I forward the source IP address of the connections to Dovecot, please? I don't think you can. That's not a feature of the standard IMAP protocol. Dovecot supports proprietary protocol extensions to forward client address information, but I'm not aware of any implementation of those extensions in SOGo. Dovecot also supports a "proxy protocol" developed by the haproxy project, but again, I don't believe that's implemented in SOGo. Both of these are non-standard, but mentioned on this page: https://wiki2.dovecot.org/HAProxy -- users@sogo.nu https://inverse.ca/sogo/lists