View Issue Details

IDProjectCategoryView StatusLast Update
0004413SOGoWeb Address Bookpublic2018-03-07 11:22
ReporterKyKyllloHoK Assigned Tofrancis  
PriorityhighSeverityminorReproducibilityalways
Status closedResolutionfixed 
Platform[Server] LinuxOSDebianOS Version8 (Jessie)
Summary0004413: Address Book in firefox
Description

Address book entries displayed only after selection

Additional Information

Test on firefox version 38 52 60

Tags3.2.10, Address book

Relationships

has duplicate 0004412 resolvedludovic Address Book in firefox 

Activities

KyKyllloHoK

KyKyllloHoK

2018-03-06 11:01

reporter  

2018-03-06_14-57-17.png (100,626 bytes)   
2018-03-06_14-57-17.png (100,626 bytes)   
francis

francis

2018-03-06 20:27

administrator   ~0012627

Have you executed the upgrade script sql-update-3.2.10_to_4.0.0-mysql.sh?

KyKyllloHoK

KyKyllloHoK

2018-03-07 02:16

reporter   ~0012629

No

francis

francis

2018-03-07 02:42

administrator   ~0012630

Run it to solve your issue.

KyKyllloHoK

KyKyllloHoK

2018-03-07 03:51

reporter   ~0012631

Last edited: 2018-03-07 03:53

It`s no help.
I use PostgreSQL and start sql-update-3.2.10_to_4.0.0.sh.
Need start sql-update-3.0.0-to-combined.sh ?

francis

francis

2018-03-07 03:51

administrator   ~0012632

Show your log and your config file.

KyKyllloHoK

KyKyllloHoK

2018-03-07 03:55

reporter   ~0012633

./sql-update-3.2.10_to_4.0.0.sh
Username (root): sogo
Hostname (localhost): 127.0.0.1
Database (sogo):
This script will ask for the database password twice
Converting c_mail from VARCHAR(255) to TEXT in Contacts quick tables
?????? ???????????? sogo:
ALTER TABLE sogo_quick_contact ALTER COLUMN c_mail TYPE TEXT;
ALTER TABLE sogo_quick_contact ADD c_hascertificate INT4 DEFAULT 0;

francis

francis

2018-03-07 04:15

administrator   ~0012634

I was referring to your sogo.log file and sogo.conf config file.

KyKyllloHoK

KyKyllloHoK

2018-03-07 04:39

reporter   ~0012635

Mar 07 08:17:52 sogod [6461]: [WARN] <0x0x562f2c358050[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table
Mar 07 08:17:52 sogod [6461]: [WARN] <0x0x562f2c358050[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table
Mar 07 08:17:52 sogod [6461]: [WARN] <0x0x562f2c358050[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
Mar 07 08:17:52 sogod [6461]: <0x0x562f2bde1f40[GCSFolderManager]> ERROR(-[GCSFolderManager folderForRecord:]): missing folder location in record: {"c_acl_location" = "<null>"; "c_folder_id" = 111; "c_folder_type" = Appointment; "c_location" = "<null>"; "c_path" = "/Users/pky50257/Calendar/personal"; "c_quick_location" = "<null>"; }
Mar 07 08:17:52 sogod [6461]: [ERROR] <0x562f2c237310[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchAlarmInfosFrom:to:]): missing folder for fetch!
Mar 07 08:17:52 sogod [6461]: <0x0x562f2bde1f40[GCSFolderManager]> ERROR(-[GCSFolderManager folderForRecord:]): missing folder location in record: {"c_acl_location" = "<null>"; "c_folder_id" = 118; "c_folder_type" = Appointment; "c_location" = "<null>"; "c_path" = "/Users/pky50257/Calendar/3418-5847DD80-1-9A7CB10"; "c_quick_location" = "<null>"; }
Mar 07 08:17:52 sogod [6461]: [ERROR] <0x562f2c22d7e0[SOGoWebAppointmentFolder]:3418-5847DD80-1-9A7CB10> (-[SOGoAppointmentFolder fetchAlarmInfosFrom:to:]): missing folder for fetch!
Mar 07 08:17:52 sogod [6461]: 79.133.90.49, 172.17.100.4 "GET /SOGo/so/pky50257/Calendar/alarmslist?browserTime=1520396272 HTTP/1.1" 200 63/0 0.012 - - 260K
Mar 07 08:17:52 sogod [6461]: <0x0x562f2bde1f40[GCSFolderManager]> ERROR(-[GCSFolderManager folderForRecord:]): missing folder location in record: {"c_acl_location" = "<null>"; "c_folder_id" = 112; "c_folder_type" = Contact; "c_location" = "<null>"; "c_path" = "/Users/pky50257/Contacts/personal"; "c_quick_location" = "<null>"; }
Mar 07 08:17:52 sogod [6461]: <0x0x562f2bde1f40[GCSFolderManager]> ERROR(-[GCSFolderManager folderForRecord:]): missing folder location in record: {"c_acl_location" = "<null>"; "c_folder_id" = 112; "c_folder_type" = Contact; "c_location" = "<null>"; "c_path" = "/Users/pky50257/Contacts/personal"; "c_quick_location" = "<null>"; }
Mar 07 08:17:52 sogod [6461]: 79.133.90.49, 172.17.100.4 "POST /SOGo/so/pky50257/Contacts/personal/view HTTP/1.1" 200 137/46 0.012 - - 128K

KyKyllloHoK

KyKyllloHoK

2018-03-07 04:40

reporter   ~0012636

WOPort = 127.0.0.1:20000;
WOPidFile = /var/run/sogo/sogo.pid;
WOLogFile = /var/log/sogo/sogo.log;
WOMaxUploadSize = 30000;
WOWorkersCount = 100;
SOGoMaximumPingInterval = 3600;
SOGoMaximumSyncInterval = 3600;
SOGoInternalSyncInterval = 60;
WOWatchDogRequestTimeout = 60;
SOGoMaximumSyncWindowSize = 0;
SOGoMaximumSyncResponseSize = 0;
SOGoProfileURL = "postgresql://user:pwd@127.0.0.1:5432/sogo/sogo_user_profile";
OCSFolderInfoURL = "postgresql://user:pwd@127.0.0.1:5432/sogo/sogo_folder_info";
OCSStoreURL = "postgresql://user:pwd@127.0.0.1:5432/sogo/sogo_store";
OCSAclURL = "postgresql://user:pwd@127.0.0.1:5432/sogo/sogo_acl";
OCSSessionsFolderURL = "postgresql://user:pwd@127.0.0.1:5432/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL = "postgresql://user:pwd@127.0.0.1:5432/sogo/sogo_alarms_folder";
SOGoLanguage = Russian;
SOGoSupportedLanguages = ("Russian","English");
SOGoLoginModule = Mail;
SOGoForceExternalLoginWithEmail = YES;
SOGoMailCustomFromEnabled = YES;
SOGoEnableEMailAlarms = YES;
SOGoIMAPServer = "imap://127.0.0.1:143/?tls=YES";
SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoSMTPServer = 127.0.0.1;
SOGoMailingMechanism = smtp;
SOGoSMTPAuthenticationType = PLAIN;
SOGoSieveServer = sieve://127.0.0.1:4190;
SOGoSieveScriptsEnabled = YES;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveFolderEncoding = UTF-8;
SOGoMaximumFailedLoginCount = 5;
SOGoMemcachedHost = 127.0.0.1;
SOGoCacheCleanupInterval = 30;
SOGoExternalAvatarsEnabled = NO;
SOGoGravatarEnabled = NO;
SOGoTimeZone = "Europe/Samara";
SOGoDayStartTime = 8;
SOGoDayEndTime = 17;
SOGoFirstDayOfWeek = 1;
SOGoMailComposeMessageType = "html";
SOGoRefreshViewCheck = every_5_minutes;
SOGoMailReplyPlacement = below;
SOGoAppointmentSendEMailNotifications = YES;
SOGoFoldersSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES;
SOGoCalendarDefaultReminder = -PT5M;
SOGoPasswordChangeEnabled = NO;
SOGoIMAPAclConformsToIMAPExt = YES;
SOGoUIxAdditionalPreferences = YES;
SOGoDomainsVisibility = ( (axion.ru, ldap.axion.ru), (axion.ru, boss.axion.ru) );
domains = {
boss.axion.ru = {
SOGoMailDomain = boss.axion.ru;
SOGoUserSources = ({
type = ldap;
id = ldap_auth_boss;
hostname = "ldap://ldap0:389";
baseDN = "ou=People,dc=axion,dc=ru";
bindAsCurrentUser = YES;
filter = "(businessCategory <> '0' AND mail = '')";
scope = SUB;
userPasswordAlgorithm = ssha;
IDFieldName = uid;
UIDFieldName = uid;
bindFields = (uid);
CNFieldName = displayName;
IMAPLoginFieldName = mail;
IMAPHostFieldName = mail.axion.ru;
passwordPolicy = YES;
canAuthenticate = YES;
isAddressBook = NO;
},
{
type = ldap;
id = ldap_adrb_boss;
hostname = "ldap://ldap0:389";
baseDN = "ou=People,dc=axion,dc=ru";
filter = "((businessCategory <> '0') AND (mail = '
'))";
bindAsCurrentUser = YES;
scope = SUB;
CNFieldName = displayName;
SearchFieldNames = (displayName, uid, mobile, mail, o, ou, title);
displayName = "boss.axion.ru";
canAuthenticate = NO;
isAddressBook = YES;
mapping = {
photo = ("jpegPhoto");
};
});
};
ldap.axion.ru = {
SOGoMailDomain = ldap.axion.ru;
SOGoUserSources = ({
type = ldap;
id = ldap_auth;
hostname = "ldap://ldap0:389";
baseDN = "ou=People,dc=axion,dc=ru";
bindAsCurrentUser = YES;
filter = "((businessCategory == '0') AND (mail <> ''))";
scope = SUB;
userPasswordAlgorithm = ssha;
IDFieldName = uid;
UIDFieldName = uid;
bindFields = (uid);
CNFieldName = displayName;
IMAPLoginFieldName = mail;
IMAPHostFieldName = mail.axion.ru;
SearchFieldNames = (displayName, uid, mobile, mail, o, ou, title);
passwordPolicy = YES;
canAuthenticate = YES;
displayName = "axion.ru";
isAddressBook = YES;
mapping = {
photo = ("jpegPhoto");
};
});
};
axion.ru = {
SOGoMailDomain = axion.ru;
SOGoUserSources = ({
type = sql;
id = users;
viewURL = "postgresql://user:pwd@127.0.0.1:5432/sogo/users";
canAuthenticate = YES;
userPasswordAlgorithm = ssha;
prependPasswordScheme = YES;
isAddressBook = NO;
SOGoEnableDomainBasedUID = YES;
DomainFieldName = "domain";
});
};
axionet.ru = {
SOGoMailDomain = axionet.ru;
SOGoUserSources = ({
type = sql;
id = users_2;
viewURL = "postgresql://user:pwd@127.0.0.1:5432/sogo/users";
canAuthenticate = YES;
userPasswordAlgorithm = ssha;
prependPasswordScheme = YES;
isAddressBook = NO;
SOGoEnableDomainBasedUID = YES;
DomainFieldName = "domain";
});
};
};
}

KyKyllloHoK

KyKyllloHoK

2018-03-07 05:16

reporter   ~0012637

Understood
1) sql-update-3.0.0-to-combined.sh
2) set param "OCSCacheFolderURL"

Everything works, I'm sorry for the trouble.

Issue History

Date Modified Username Field Change
2018-03-06 11:01 KyKyllloHoK New Issue
2018-03-06 11:01 KyKyllloHoK File Added: 2018-03-06_14-57-17.png
2018-03-06 11:02 KyKyllloHoK Tag Attached: 3.2.10
2018-03-06 11:02 KyKyllloHoK Tag Attached: Address book
2018-03-06 20:24 francis Relationship added has duplicate 0004412
2018-03-06 20:27 francis Note Added: 0012627
2018-03-07 02:16 KyKyllloHoK Note Added: 0012629
2018-03-07 02:42 francis Note Added: 0012630
2018-03-07 02:42 francis Status new => closed
2018-03-07 02:42 francis Assigned To => francis
2018-03-07 02:42 francis Resolution open => fixed
2018-03-07 03:51 KyKyllloHoK Note Added: 0012631
2018-03-07 03:51 KyKyllloHoK Status closed => feedback
2018-03-07 03:51 KyKyllloHoK Resolution fixed => reopened
2018-03-07 03:51 francis Note Added: 0012632
2018-03-07 03:53 KyKyllloHoK Note Edited: 0012631
2018-03-07 03:55 KyKyllloHoK Note Added: 0012633
2018-03-07 03:55 KyKyllloHoK Status feedback => assigned
2018-03-07 04:15 francis Note Added: 0012634
2018-03-07 04:39 KyKyllloHoK Note Added: 0012635
2018-03-07 04:40 KyKyllloHoK Note Added: 0012636
2018-03-07 05:16 KyKyllloHoK Note Added: 0012637
2018-03-07 11:22 francis Status assigned => closed
2018-03-07 11:22 francis Resolution reopened => fixed