[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
