Relationship Graph

View IssueDependency GraphShow Summary
Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004896SOGoWeb Address Bookpublic2019-11-28 17:412022-01-13 15:51
Reporterdragoangel Assigned Tofrancis  
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Platform[Client] MicrosoftOSWindowsOS Version7
Product Version4.1.1 
Fixed in Version5.5.0 
Summary0004896: SOGoDomainsVisibility and GAL Address Book broken
Description

I have successfully configured:
SOGoDomainsVisibility = (
(mail.cow.com, myaw.com)
);

When look in GAL at another domain users from SOGo they displayed in Address book and in Send dialog as hints without issues. But:

  1. if try copy them to Personal Address Book you will get 400 for https://mail.cow.com/SOGo/so/email@moo.com/Contacts/moo.com/copy with payload {"uids":["email@myaw.com"],"folder":"personal"}
  2. if in address book click on user from another domain you will get 404 for https://mail.cow.com/SOGo/so/email@moo.com/Contacts/moo.com/email%40myaw.com/view
  3. mostly bad part of it:
    If use native SOGo Connector or TBSync with CalDAV & CardDAV provider, or any other EAS or CalDAV solution: GAL will display only users from users authenticated domain. So for CardDAV & EAS SOGoDomainsVisibility is not working.
Steps To Reproduce
  1. Configure SOGoDomainsVisibility for multiply domains like:
    SOGoDomainsVisibility = (
    (mail.cow.com, myaw.com)
    );
  2. Create 2 domains (mail.cow.com, myaw.com) and users for them.
  3. Login to SOGo from mail.cow.com user and check that GAL display myaw.com users
  4. Install Thunderbird & TBSync plugin with CalDAV & CardDAV provider
  5. Login as mail.cow.com user in Thunderbird and configure TBSync connection to SOGo
  6. Sync GAL and you will see only mail.cow.com users
TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
related to 0005424 resolvedfrancis CalDav missing contacts in GAL that available on SOGo Web and server 
related to 0005420 resolvedfrancis CardDAV sync failed - failed status for getetag 

Activities

dragoangel

dragoangel

2019-11-30 10:36

reporter   ~0013942

Note: I'm using SOGo in mailcow dockerized https://github.com/mailcow/mailcow-dockerized/
francis

francis

2020-04-06 18:38

administrator   ~0014267

Please share your complete configuration file (sogo.conf).
dragoangel

dragoangel

2020-04-06 22:11

reporter   ~0014270

Last edited: 2020-05-22 19:45

Here the sogo.conf content with anonymized domains only in SOGoDomainsVisibility:

{
    SOGoCalendarDefaultRoles = (
        PublicViewer,
        ConfidentialDAndTViewer,
        PrivateDAndTViewer
    );

    WOWorkersCount = "20";
    SOGoACLsSendEMailNotifications = YES;
    SOGoAppointmentSendEMailNotifications = YES;
    SOGoDraftsFolderName = "Drafts";
    SOGoJunkFolderName= "Junk";
    SOGoMailDomain = "sogo.local";
    SOGoEnableEMailAlarms = YES;
    SOGoFoldersSendEMailNotifications = YES;
    SOGoForwardEnabled = YES;
    SOGoUIAdditionalJSFiles = (js/custom-sogo.js);
    SOGoEnablePublicAccess = YES;

    // Multi-domain setup
    // Domains are isolated, you can define visibility options here.
    SOGoDomainsVisibility = (
     (company.com, company.com.ua, company.org.ua, company.in.ua)
    );

    SOGoSieveServer = "sieve://dovecot:4190/?tls=YES";
    SOGoSMTPServer = "postfix:588";
    WOPort = "0.0.0.0:20000";
    SOGoMemcachedHost = "memcached";

    SOGoLanguage = English;
    SOGoMailAuxiliaryUserAccountsEnabled = YES;
    SOGoMailCustomFromEnabled = YES;
    SOGoMailingMechanism = smtp;
    SOGoSMTPAuthenticationType = plain;

    SxVMemLimit = 384;

    SOGoMaximumPingInterval = 3540;

    SOGoInternalSyncInterval = 45;
    SOGoMaximumSyncInterval = 3540;

    // 100 seems to break some Android clients
    //SOGoMaximumSyncWindowSize = 99;
    // This should do the trick for Outlook 2016
    SOGoMaximumSyncResponseSize = 512;

    WOWatchDogRequestTimeout = 30;
    WOListenQueueSize = 16;
    WONoDetach = YES;

    SOGoIMAPAclConformsToIMAPExt = Yes;
    SOGoPageTitle = "SOGo Groupware";
    SOGoFirstDayOfWeek = "1";

    SOGoSieveFolderEncoding = "UTF-8";
    SOGoPasswordChangeEnabled = NO;
    SOGoSentFolderName = "Sent";
    SOGoMailShowSubscribedFoldersOnly = NO;
    NGImap4ConnectionStringSeparator = "/";
    SOGoSieveScriptsEnabled = YES;
    SOGoTrashFolderName = "Trash";
    SOGoVacationEnabled = YES;

    SOGoCacheCleanupInterval = 900;
    SOGoMaximumFailedLoginCount = 10;
    SOGoMaximumFailedLoginInterval = 900;
    SOGoFailedLoginBlockInterval = 900;

    MySQL4Encoding = "utf8mb4";
  //SOGoDebugRequests = YES;
  //SoDebugBaseURL = YES;
  //ImapDebugEnabled = YES;
  //SOGoEASDebugEnabled = YES;
  //LDAPDebugEnabled = YES;
  //PGDebugEnabled = YES;
  //MySQL4DebugEnabled = YES;
  //SOGoUIxDebugEnabled = YES;
  //WODontZipResponse = YES;
    WOLogFile = "/dev/sogo_log";
}
dragoangel

dragoangel

2020-04-06 22:14

reporter   ~0014271

To be sure add file to display spaces|formating etc.:

sogo.conf (2,368 bytes)    
{
    SOGoCalendarDefaultRoles = (
        PublicViewer,
        ConfidentialDAndTViewer,
        PrivateDAndTViewer
    );

    WOWorkersCount = "20";
    SOGoACLsSendEMailNotifications = YES;
    SOGoAppointmentSendEMailNotifications = YES;
    SOGoDraftsFolderName = "Drafts";
    SOGoJunkFolderName= "Junk";
    SOGoMailDomain = "sogo.local";
    SOGoEnableEMailAlarms = YES;
    SOGoFoldersSendEMailNotifications = YES;
    SOGoForwardEnabled = YES;
    SOGoUIAdditionalJSFiles = (js/custom-sogo.js);
    SOGoEnablePublicAccess = YES;

    // Multi-domain setup
    // Domains are isolated, you can define visibility options here.
    SOGoDomainsVisibility = (
     (company.com, company.com.ua, company.org.ua, company.in.ua)
    );

    SOGoSieveServer = "sieve://dovecot:4190/?tls=YES";
    SOGoSMTPServer = "postfix:588";
    WOPort = "0.0.0.0:20000";
    SOGoMemcachedHost = "memcached";

    SOGoLanguage = English;
    SOGoMailAuxiliaryUserAccountsEnabled = YES;
    SOGoMailCustomFromEnabled = YES;
    SOGoMailingMechanism = smtp;
    SOGoSMTPAuthenticationType = plain;

    SxVMemLimit = 384;

    SOGoMaximumPingInterval = 3540;

    SOGoInternalSyncInterval = 45;
    SOGoMaximumSyncInterval = 3540;

    // 100 seems to break some Android clients
    //SOGoMaximumSyncWindowSize = 99;
    // This should do the trick for Outlook 2016
    SOGoMaximumSyncResponseSize = 512;

    WOWatchDogRequestTimeout = 30;
    WOListenQueueSize = 16;
    WONoDetach = YES;

    SOGoIMAPAclConformsToIMAPExt = Yes;
    SOGoPageTitle = "SOGo Groupware";
    SOGoFirstDayOfWeek = "1";

    SOGoSieveFolderEncoding = "UTF-8";
    SOGoPasswordChangeEnabled = NO;
    SOGoSentFolderName = "Sent";
    SOGoMailShowSubscribedFoldersOnly = NO;
    NGImap4ConnectionStringSeparator = "/";
    SOGoSieveScriptsEnabled = YES;
    SOGoTrashFolderName = "Trash";
    SOGoVacationEnabled = YES;

    SOGoCacheCleanupInterval = 900;
    SOGoMaximumFailedLoginCount = 10;
    SOGoMaximumFailedLoginInterval = 900;
    SOGoFailedLoginBlockInterval = 900;

    MySQL4Encoding = "utf8mb4";
  //SOGoDebugRequests = YES;
  //SoDebugBaseURL = YES;
  //ImapDebugEnabled = YES;
  //SOGoEASDebugEnabled = YES;
  //LDAPDebugEnabled = YES;
  //PGDebugEnabled = YES;
  //MySQL4DebugEnabled = YES;
  //SOGoUIxDebugEnabled = YES;
  //WODontZipResponse = YES;
    WOLogFile = "/dev/sogo_log";
}
sogo.conf (2,368 bytes)   
dragoangel

dragoangel

2020-05-21 23:02

reporter   ~0014368

Hi @francis, do you have time to check if it? Thank you in advance.
Christian Mack

Christian Mack

2020-05-22 08:46

developer   ~0014371

In your sogo.conf you do not have any domains defined at all.
Nor any SOGoUserSources.
Don't think this can work.
dragoangel

dragoangel

2020-05-22 10:15

reporter   ~0014372

Hello @Cristian Mack,
I using mailcow-dockerinzed which provide preconfigured SOGo out of box. Sorry, I doesn't know that there not only sogo.conf. After dig in it I find that bootstrap-sogo.sh generate sogod.plist on each start of SOGo Docker which is used as well and provide setting you mentioned is missing.

I anonymized my config (changed real domain to "company", changed sql credentials to "user:password" and encryption key) and attach it here. Could you please check it? Big thank you in advance.

sogod.plist (10,652 bytes)    
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//GNUstep//DTD plist 0.9//EN" "http://www.gnustep.org/plist-0_9.xml">
<plist version="0.9">
	<dict>
		<key>OCSAclURL</key>
		<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/sogo_acl</string>
		<key>SOGoIMAPServer</key>
		<string>imaps://172.22.1.250:993</string>
		<key>SOGoTrustProxyAuthentication</key>
		<string>YES</string>
		<key>SOGoEncryptionKey</key>
		<string>secret</string>
		<key>OCSCacheFolderURL</key>
		<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/sogo_cache_folder</string>
		<key>OCSEMailAlarmsFolderURL</key>
		<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/sogo_alarms_folder</string>
		<key>OCSFolderInfoURL</key>
		<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/sogo_folder_info</string>
		<key>OCSSessionsFolderURL</key>
		<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/sogo_sessions_folder</string>
		<key>OCSStoreURL</key>
		<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/sogo_store</string>
		<key>SOGoProfileURL</key>
		<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/sogo_user_profile</string>
		<key>SOGoTimeZone</key>
		<string>Europe/Kiev</string>
		<key>domains</key>
		<dict>
			<key>company.com.ua</key>
			<dict>
				<key>SOGoMailDomain</key>
				<string>company.com.ua</string>
				<key>SOGoUserSources</key>
				<array>
					<dict>
						<key>MailFieldNames</key>
						<array>
							<string>aliases</string>
							<string>ad_aliases</string>
							<string>ext_acl</string>
						</array>
						<key>KindFieldName</key>
						<string>kind</string>
						<key>DomainFieldName</key>
						<string>domain</string>
						<key>MultipleBookingsFieldName</key>
						<string>multiple_bookings</string>
						<key>listRequiresDot</key>
						<string>NO</string>
						<key>canAuthenticate</key>
						<string>YES</string>
						<key>displayName</key>
						<string>GAL company.com.ua</string>
						<key>id</key>
						<string>company.com.ua</string>
						<key>isAddressBook</key>
						<string>YES</string>
						<key>type</key>
						<string>sql</string>
						<key>userPasswordAlgorithm</key>
						<string>ssha256</string>
						<key>prependPasswordScheme</key>
						<string>YES</string>
						<key>viewURL</key>
						<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/_sogo_static_view</string>
					</dict>
					<!--
                <example>
                    <key>canAuthenticate</key>
                    <string>YES</string>
                    <key>id</key>
                    <string>company.com.ua_ldap</string>
                    <key>isAddressBook</key>
                    <string>NO</string>
                    <key>IDFieldName</key>
                    <string>mail</string>
                    <key>UIDFieldName</key>
                    <string>uid</string>
                    <key>bindFields</key>
                    <array>
                        <string>mail</string>
                    </array>
                    <key>type</key>
                    <string>ldap</string>
                    <key>bindDN</key>
                    <string>cn=admin,dc=example,dc=local</string>
                    <key>bindPassword</key>
                    <string>password</string>
                    <key>baseDN</key>
                    <string>ou=People,dc=example,dc=local</string>
                    <key>hostname</key>
                    <string>ldap://1.2.3.4:389</string>
                </example>
                -->
				</array>
			</dict>
			<key>company.in.ua</key>
			<dict>
				<key>SOGoMailDomain</key>
				<string>company.in.ua</string>
				<key>SOGoUserSources</key>
				<array>
					<dict>
						<key>MailFieldNames</key>
						<array>
							<string>aliases</string>
							<string>ad_aliases</string>
							<string>ext_acl</string>
						</array>
						<key>KindFieldName</key>
						<string>kind</string>
						<key>DomainFieldName</key>
						<string>domain</string>
						<key>MultipleBookingsFieldName</key>
						<string>multiple_bookings</string>
						<key>listRequiresDot</key>
						<string>NO</string>
						<key>canAuthenticate</key>
						<string>YES</string>
						<key>displayName</key>
						<string>GAL company.in.ua</string>
						<key>id</key>
						<string>company.in.ua</string>
						<key>isAddressBook</key>
						<string>YES</string>
						<key>type</key>
						<string>sql</string>
						<key>userPasswordAlgorithm</key>
						<string>ssha256</string>
						<key>prependPasswordScheme</key>
						<string>YES</string>
						<key>viewURL</key>
						<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/_sogo_static_view</string>
					</dict>
					<!--
                <example>
                    <key>canAuthenticate</key>
                    <string>YES</string>
                    <key>id</key>
                    <string>company.in.ua_ldap</string>
                    <key>isAddressBook</key>
                    <string>NO</string>
                    <key>IDFieldName</key>
                    <string>mail</string>
                    <key>UIDFieldName</key>
                    <string>uid</string>
                    <key>bindFields</key>
                    <array>
                        <string>mail</string>
                    </array>
                    <key>type</key>
                    <string>ldap</string>
                    <key>bindDN</key>
                    <string>cn=admin,dc=example,dc=local</string>
                    <key>bindPassword</key>
                    <string>password</string>
                    <key>baseDN</key>
                    <string>ou=People,dc=example,dc=local</string>
                    <key>hostname</key>
                    <string>ldap://1.2.3.4:389</string>
                </example>
                -->
				</array>
			</dict>
			<key>company.org.ua</key>
			<dict>
				<key>SOGoMailDomain</key>
				<string>company.org.ua</string>
				<key>SOGoUserSources</key>
				<array>
					<dict>
						<key>MailFieldNames</key>
						<array>
							<string>aliases</string>
							<string>ad_aliases</string>
							<string>ext_acl</string>
						</array>
						<key>KindFieldName</key>
						<string>kind</string>
						<key>DomainFieldName</key>
						<string>domain</string>
						<key>MultipleBookingsFieldName</key>
						<string>multiple_bookings</string>
						<key>listRequiresDot</key>
						<string>NO</string>
						<key>canAuthenticate</key>
						<string>YES</string>
						<key>displayName</key>
						<string>GAL company.org.ua</string>
						<key>id</key>
						<string>company.org.ua</string>
						<key>isAddressBook</key>
						<string>YES</string>
						<key>type</key>
						<string>sql</string>
						<key>userPasswordAlgorithm</key>
						<string>ssha256</string>
						<key>prependPasswordScheme</key>
						<string>YES</string>
						<key>viewURL</key>
						<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/_sogo_static_view</string>
					</dict>
					<!--
                <example>
                    <key>canAuthenticate</key>
                    <string>YES</string>
                    <key>id</key>
                    <string>company.org.ua_ldap</string>
                    <key>isAddressBook</key>
                    <string>NO</string>
                    <key>IDFieldName</key>
                    <string>mail</string>
                    <key>UIDFieldName</key>
                    <string>uid</string>
                    <key>bindFields</key>
                    <array>
                        <string>mail</string>
                    </array>
                    <key>type</key>
                    <string>ldap</string>
                    <key>bindDN</key>
                    <string>cn=admin,dc=example,dc=local</string>
                    <key>bindPassword</key>
                    <string>password</string>
                    <key>baseDN</key>
                    <string>ou=People,dc=example,dc=local</string>
                    <key>hostname</key>
                    <string>ldap://1.2.3.4:389</string>
                </example>
                -->
				</array>
			</dict>
			<key>company.com</key>
			<dict>
				<key>SOGoMailDomain</key>
				<string>company.com</string>
				<key>SOGoUserSources</key>
				<array>
					<dict>
						<key>MailFieldNames</key>
						<array>
							<string>aliases</string>
							<string>ad_aliases</string>
							<string>ext_acl</string>
						</array>
						<key>KindFieldName</key>
						<string>kind</string>
						<key>DomainFieldName</key>
						<string>domain</string>
						<key>MultipleBookingsFieldName</key>
						<string>multiple_bookings</string>
						<key>listRequiresDot</key>
						<string>NO</string>
						<key>canAuthenticate</key>
						<string>YES</string>
						<key>displayName</key>
						<string>GAL company.com</string>
						<key>id</key>
						<string>company.com</string>
						<key>isAddressBook</key>
						<string>YES</string>
						<key>type</key>
						<string>sql</string>
						<key>userPasswordAlgorithm</key>
						<string>ssha256</string>
						<key>prependPasswordScheme</key>
						<string>YES</string>
						<key>viewURL</key>
						<string>mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/_sogo_static_view</string>
					</dict>
					<!--
                <example>
                    <key>canAuthenticate</key>
                    <string>YES</string>
                    <key>id</key>
                    <string>company.com_ldap</string>
                    <key>isAddressBook</key>
                    <string>NO</string>
                    <key>IDFieldName</key>
                    <string>mail</string>
                    <key>UIDFieldName</key>
                    <string>uid</string>
                    <key>bindFields</key>
                    <array>
                        <string>mail</string>
                    </array>
                    <key>type</key>
                    <string>ldap</string>
                    <key>bindDN</key>
                    <string>cn=admin,dc=example,dc=local</string>
                    <key>bindPassword</key>
                    <string>password</string>
                    <key>baseDN</key>
                    <string>ou=People,dc=example,dc=local</string>
                    <key>hostname</key>
                    <string>ldap://1.2.3.4:389</string>
                </example>
                -->
				</array>
			</dict>
		</dict>
	</dict>
</plist>
sogod.plist (10,652 bytes)   
dragoangel

dragoangel

2020-06-23 19:48

reporter   ~0014423

Hi Christian, please help. The issue is still reproduce and I still need help.
dragoangel

dragoangel

2020-07-16 07:23

reporter   ~0014544

The issue still persists on latest SOGo 4.3.2 nightly.
dragoangel

dragoangel

2020-07-18 20:17

reporter   ~0014548

@francis please could you help to check config I send in https://sogo.nu/bugs/view.php?id=4896#c14372 ?
Christian Mack

Christian Mack

2020-08-04 14:40

developer   ~0014625

Do you really have the same users in all of your domains?
viewURL = mysql://user:password@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/mailcow/_sogo_static_view
dragoangel

dragoangel

2020-08-04 14:53

reporter   ~0014626

Hi Christian, this static view are contains all users from all domains on my mail server.
The structure of view:
c_uid - user@example.com
domain - example.com
c_name - user@example.com
c_password - {SSHA256}HASH
c_cn - User Name
mail - user@example.com
aliases - list of space delimited aliases for this user if any
ad_aliases - list of space delimited domain aliases if any
ext_acl & kind - all empty in my case
multiple_bookings - all has -1, doesn't use this available\busy.
dragoangel

dragoangel

2020-08-07 01:08

reporter   ~0014645

So this bug or incorrect configuration?
Christian Mack

Christian Mack

2020-08-10 12:47

developer   ~0014650

I am not absolutely sure, but when I tested multi domain, you had to provide a different list of users for each domain.
One user could not be member of more than one login domain.
dragoangel

dragoangel

2020-10-03 11:18

reporter   ~0014878

Hi Christian Mack
No this will not fix issue.
Mailcow way, one static view with all domains:
1) each GAL display users for all shared domains and at same time user see multiply GALs.
2) If I try: select in SOGo|copy in SOGo|use carddav I doesn't see any emails except my own domain and getting 404 (An error occurred during object publishing\n the requested object could not be found!)

Your way, I created per domain static views in mysql which display users only from domain it designed to be and configured sogod.plist to use this views:
1) each GAL display useers only from this domain and users see all shared GALs.
2) And here we have exactly same result as in Mailcow was: non MY domain is 404 in any case.

Please check this.
dragoangel

dragoangel

2020-10-03 11:56

reporter   ~0014879

https://sogo.moo.com/SOGo/so/user@mailcow.com/Contacts/moo.com/view show an array correctly or users moo.com
but https://sogo.moo.com/SOGo/so/user@mailcow.com/Contacts/moo.com/admin%40moo.com/view display 404 to be more correct and /dav/ also 0
dragoangel

dragoangel

2020-10-20 19:35

reporter   ~0014898

Guys can you check it on your side please?
francis

francis

2022-01-11 16:28

administrator   ~0015742

Any errors in the log file of sogod?

For 2, set MySQL4DebugEnabled = YES; in your sogo.conf and check the SQL query just before the 404.
dragoangel

dragoangel

2022-01-11 16:50

reporter   ~0015743

Hi Francis,

2022-01-11 18:33:44.121 sogod[154:154] &lt;MySQL4Channel[0x0x55bfe09d0220] connection=0x0x55bfe0979f70> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@example.com' AND c_folder_type = 'Contact';
2022-01-11 18:33:44.122 sogod[154:154] &lt;MySQL4Channel[0x0x55bfe09d0220] connection=0x0x55bfe0979f70>   query has results, entering fetch-mode.
2022-01-11 18:33:44.122 sogod[154:154] &lt;MySQL4Channel[0x0x55bfe09d0220] connection=0x0x55bfe0979f70> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'user@example.com' AND c_folder_type = 'Contact';
2022-01-11 18:33:44.124 sogod[154:154] &lt;MySQL4Channel[0x0x55bfe09d0220] connection=0x0x55bfe0979f70>   query has results, entering fetch-mode.
2022-01-11 18:33:44.124 sogod[154:154] &lt;MySQL4Channel[0x0x55bfe09d0220] connection=0x0x55bfe0979f70> SQL: SELECT * FROM _sogo_static_view WHERE (domain = 'example.com') AND (c_uid = 'contact@example2.org');
2022-01-11 18:33:44.125 sogod[154:154] &lt;MySQL4Channel[0x0x55bfe09d0220] connection=0x0x55bfe0979f70>   query has results, entering fetch-mode.
sogod [154]: 192.0.2.5 &quot;GET /SOGo/so/user@example.com/Contacts/example.com/contact%40example2.org/view HTTP/1.0&quot; 404 208/0 0.014 - - 0 - 13

If I do select to DB it will not return contact@example2.org, because domain for this user is: example2.org, when asked example.com because my user is part of example.com.
I have in sogo.conf:

    SOGoDomainsVisibility = (
     (example.com, example2.org)
    );

Why domain here is asked when c_name already have domain? This what lead to 404.
The cases when c_name do not have domain exist?

Also want to note that there is more critical issue with CardDAV that lead to denial of service and broken GAL for CardDAV when sogo work with mysql backend, please see:
https://www.sogo.nu/bugs/view.php?id=5420
https://www.sogo.nu/bugs/view.php?id=5424
dragoangel

dragoangel

2022-01-11 16:59

reporter   ~0015744

Just to clarify, request:
SELECT * FROM _sogo_static_view WHERE (c_uid = 'contact@example2.org');
will return correct contact.
francis

francis

2022-01-11 22:03

administrator   ~0015750

Please try the next nightly build (>= 20220112) and let me know if it solves your issues.
dragoangel

dragoangel

2022-01-11 22:19

reporter   ~0015751

Okay �, thank you a lot, will try tomorrow
dragoangel

dragoangel

2022-01-12 09:10

reporter   ~0015756

Hi francis, thank you, now this issue solved.

Related Changesets

sogo: master 368360bb

2022-01-11 16:40

francis


Details Diff		 fix(addressbook): respect visible domains when fetching contact

Fixes 0004896		 Affected Issues
0004896
mod - SoObjects/SOGo/SQLSource.h Diff File
mod - SoObjects/SOGo/SQLSource.m Diff File

Issue History

Date Modified Username Field Change
2019-11-28 17:41 dragoangel New Issue
2019-11-30 10:36 dragoangel Note Added: 0013942
2020-04-06 18:38 francis Note Added: 0014267
2020-04-06 22:11 dragoangel Note Added: 0014270
2020-04-06 22:14 dragoangel File Added: sogo.conf
2020-04-06 22:14 dragoangel Note Added: 0014271
2020-05-21 23:02 dragoangel Note Added: 0014368
2020-05-22 08:46 Christian Mack Note Added: 0014371
2020-05-22 10:15 dragoangel File Added: sogod.plist
2020-05-22 10:15 dragoangel Note Added: 0014372
2020-05-22 19:45 francis Note Edited: 0014270
2020-05-22 19:45 francis Note Edited: 0014270
2020-06-23 19:48 dragoangel Note Added: 0014423
2020-07-16 07:23 dragoangel Note Added: 0014544
2020-07-18 20:17 dragoangel Note Added: 0014548
2020-08-04 14:40 Christian Mack Note Added: 0014625
2020-08-04 14:53 dragoangel Note Added: 0014626
2020-08-07 01:08 dragoangel Note Added: 0014645
2020-08-10 12:47 Christian Mack Note Added: 0014650
2020-10-03 11:18 dragoangel Note Added: 0014878
2020-10-03 11:56 dragoangel Note Added: 0014879
2020-10-20 19:35 dragoangel Note Added: 0014898
2022-01-11 16:28 francis Note Added: 0015742
2022-01-11 16:50 dragoangel Note Added: 0015743
2022-01-11 16:59 dragoangel Note Added: 0015744
2022-01-11 22:02 francis Changeset attached => sogo master 368360bb
2022-01-11 22:02 francis Assigned To => francis
2022-01-11 22:02 francis Resolution open => fixed
2022-01-11 22:03 francis Note Added: 0015750
2022-01-11 22:03 francis Status new => feedback
2022-01-11 22:09 francis Relationship added related to 0005424
2022-01-11 22:19 dragoangel Note Added: 0015751
2022-01-11 22:19 dragoangel Status feedback => assigned
2022-01-12 09:10 dragoangel Note Added: 0015756
2022-01-12 13:37 francis Status assigned => resolved
2022-01-12 13:37 francis Fixed in Version => 5.5.0
2022-01-13 15:51 francis Relationship added related to 0005420