View Issue Details

IDProjectCategoryView StatusLast Update
0003887SOGoBackend Address Bookpublic2016-12-13 15:18
Reporterat Assigned To 
PrioritynormalSeverityminorReproducibilitysometimes
Status newResolutionopen 
Platform[Server] LinuxOSUbuntuOS Version14.04 LTS
Product Version3.2.0 
Summary0003887: PROPFIND 404 Status for certain account
Description

[09/Nov/2016:16:39:02 +0300] "PROPFIND /SOGo/dav/w.calendar@example.com/Contacts/personal/ HTTP/1.1" 404 97 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 Lightning/4.7.4"

Cannot sync remote address book for this user. However other accounts synchrinize without issues.

Steps To Reproduce

Install Sogo connector on thunderbird. Add remote address book. Synchronize.

TagsNo tags attached.

Activities

Christian Mack

Christian Mack

2016-11-10 07:25

developer   ~0010826

I had that once, with SOGo V2 though.
I had to backup the user with sogo-tool, then delete her and restore again.
Does this help you too?

cedric.archambeau

cedric.archambeau

2016-11-10 10:48

reporter   ~0010829

Do you use ldap backend for authentication?

You should look at UIDFieldName in your sogo.conf. If multivalued key, the value should be the first (ex: mail[0], not mail[1]).

Adjust your user entry in ldap, and:

  • sogo-tool rename-user [old_value] w.calendar@example.com
  • Restart sogo and memcached
at

at

2016-11-10 15:30

reporter   ~0010831

Yep, we use LDAP backend.

UIDFieldName = mail;

LDAP value for mail attribute is w.calendar@example.com not multivalue or something. So I'll try backup-restore routine

at

at

2016-11-12 21:04

reporter   ~0010841

backup/remove/restore had no effect.

Nov 13 00:02:47 sogod [23449]: mail.example.com "PROPFIND /SOGo/dav/w.calendar@example.com/Contacts/personal/ HTTP/1.0" 401 0/175 0.003 - - 128K
Nov 13 00:02:47 sogod [23449]: mail.example.com "PROPFIND /SOGo/dav/w.calendar@example.com/Contacts/personal/ HTTP/1.0" 404 72/175 0.003 - - 0

ludovic

ludovic

2016-12-08 19:48

administrator   ~0010963

Show your full sogod.conf file and the LDIF entry of the w.calendar user.

at

at

2016-12-13 15:18

reporter   ~0010992

sogo.conf

{
WOPort = 127.0.0.1:20000;
WOMaxUploadSize = 100500;
WOWorkersCount = 100;
SOGoMaximumPingInterval = 3540;
SOGoMaximumSyncInterval = 3540;
SOGoInternalSyncInterval = 30;
WOWatchDogRequestTimeout = 5;
SOGoMaximumSyncWindowSize = 100;
SOGoMaximumSyncResponseSize = 4096;
SxVMemLimit = 512;
SOGoProfileURL = "mysql://sogo:s3cr3t@127.0.0.1:3306/sogo/sogo_user_profile";
OCSFolderInfoURL = "mysql://sogo:s3cr3t@127.0.0.1:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL = "mysql://sogo:s3cr3t@127.0.0.1:3306/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL = "mysql://sogo:s3cr3t@127.0.0.1:3306/sogo/sogo_alarms_folder";
SOGoLanguage = Russian;
SOGoLoginModule = Mail;
SOGoForceExternalLoginWithEmail = YES;
SOGoMailCustomFromEnabled = YES;
SOGoEnableEMailAlarms = YES;
SOGoIMAPServer = "imap://127.0.0.1:143/";
SOGoSMTPServer = 127.0.0.1;
SOGoMailingMechanism = smtp;
SOGoSieveServer = sieve://127.0.0.1:4190;
SOGoSieveScriptsEnabled = YES;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveFolderEncoding = UTF-8;
SOGoMemcachedHost = 127.0.0.1;
SOGoTimeZone = "Europe/Moscow";
SOGoFirstDayOfWeek = 1;
SOGoRefreshViewCheck = every_5_minutes;
SOGoMailReplyPlacement = below;
SOGoAppointmentSendEMailNotifications = YES;
SOGoFoldersSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES;
SOGoPasswordChangeEnabled = YES;
SOGothreadedview = YES;
SOGoUserSources = (
{
type = sql;
id = users;
viewURL = "mysql://sogo:s3cr3t@127.0.0.1:3306/sogo/users";
canAuthenticate = YES;
userPasswordAlgorithm = ssha;
prependPasswordScheme = YES;
isAddressBook = YES;
displayName = "Domain Address Book";
SOGoEnableDomainBasedUID = YES;
DomainFieldName = "domain";
}
);
SOGoUserSources = (
{
type = ldap;
hostname = "ldap://127.0.0.1:389";
baseDN = "o=domains,dc=mycomp,dc=ru";
bindDN = "cn=vmailadmin,dc=mycomp,dc=ru";
bindPassword = "s3cr3t";
filter = "objectClass=mailUser AND accountStatus=active AND enabledService=mail AND enabledService=sogo";
scope = SUB;
userPasswordAlgorithm = ssha;
IDFieldName = mail;
bindFields = (mail);
CNFieldName = cn;
UIDFieldName = mail;
IMAPLoginFieldName = mail;
SearchFieldNames = (cn, sn, displayName, telephoneNumber, mail, shadowAddress);
canAuthenticate = YES;
displayName = "Global Address Book";
id = ldap_auth;
isAddressBook = YES;
}
);
}

ldif

dn: mail=w.calendar@mycomp.ru,ou=Users,domainName=mycomp.ru,o=domains,dc=
mycomp,dc=ru
objectClass: inetOrgPerson
objectClass: mailUser
objectClass: shadowAccount
objectClass: amavisAccount
mail: w.calendar@mycomp.ru
userPassword:: s3cr3t=

uid: w.calendar
storageBaseDirectory: /var/vmail
mailMessageStore: vmail1/mycomp.ru/w/c/a/w.calendar-2016.10.27.18.05.07/
homeDirectory: /var/vmail/mycomp.ru/w/c/a/w.calendar-2016.10.27.18.
05.07/
enabledService: mail
enabledService: deliver
enabledService: lda
enabledService: lmtp
enabledService: smtp
enabledService: smtpsecured
enabledService: pop3
enabledService: pop3secured
enabledService: imap
enabledService: imapsecured
enabledService: managesieve
enabledService: managesievesecured
enabledService: sogo
enabledService: sieve
enabledService: sievesecured
enabledService: forward
enabledService: senderbcc
enabledService: recipientbcc
enabledService: internal
enabledService: lib-storage
enabledService: indexer-worker
enabledService: doveadm
enabledService: dsync
enabledService: shadowaddress
enabledService: displayedInGlobalAddressBook
shadowLastChange: 0
amavisLocal: TRUE
structuralObjectClass: inetOrgPerson
entryUUID: 7e3cbc48-3002-1036-838e-9ba8033019ea
creatorsName: cn=vmailadmin,dc=mycomp,dc=ru
createTimestamp: 20161027150507Z
cn: W Calendar
givenName: W
sn: Calendar
preferredLanguage: en_US
employeeNumber: w.calendar
mailQuota: 2147483648
accountStatus: active
entryCSN: 20161108200236.397159Z#000000#000#000000
modifiersName: cn=vmailadmin,dc=mycomp,dc=ru
modifyTimestamp: 20161108200236Z

BTW, strange line end at homeDirectory

Issue History

Date Modified Username Field Change
2016-11-09 15:02 at New Issue
2016-11-10 07:25 Christian Mack Note Added: 0010826
2016-11-10 10:48 cedric.archambeau Note Added: 0010829
2016-11-10 15:30 at Note Added: 0010831
2016-11-12 21:04 at Note Added: 0010841
2016-12-08 19:48 ludovic Note Added: 0010963
2016-12-13 15:18 at Note Added: 0010992