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 = '[email protected]'; -> success b) get user data SQL: SELECT * FROM sogo_test_de WHERE (c_domain = 'test.de') AND ((c_uid = '[email protected]') OR (mail = '[email protected]')); -> 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 = '[email protected]@test.de') OR (mail = '[email protected]@test.de')); -> failure my sogo.conf (excerpts) SOGoForceExternalLoginWithEmail = YES; SOGoEnableDomainBasedUID = YES; test.de = { SOGoMailDomain = test.de; SOGoSuperUsernames = ("[email protected]"); // 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 -- [email protected] https://inverse.ca/sogo/lists
