View Issue Details

IDProjectCategoryView StatusLast Update
0004152SOGoBackend Generalpublic2017-05-08 13:55
Reportertohuw Assigned Toludovic  
PriorityimmediateSeverityblockReproducibilityalways
Status closedResolutionno change required 
PlatformServerOSUbuntuOS Version16.04 LTS
Product Versionnightly master 
Summary0004152: MariaDB Database Never Populates (SOGo 3.2.8.20170423-1)
Description

After a fresh install, the MariaDB (v 10.0.24-7) SOGo database is never populated with any data, except an empty table 'sogo_acl'. LDAP is used as the authentication source. No overrides are present in the GNUStep hierarchy.

Steps To Reproduce
  1. Create new installation of SOGo v3 nightly at version 3.2.8.20170423-1 on Ubuntu 16.04
  2. Create MariaDB Database as described in docs
  3. Populate LDAP with a test user
  4. Provide below configuration as sogo.conf
  5. Login (this succeeds)
  6. Observe settings cannot successfully be changed, and database has only one table, 'sogo_acl'
Additional Information

sogo.conf, with the minimum necessary changes:

{
SOGoProfileURL = "mysql://sogo:sogopass@127.0.0.1:3306/sogo/sogo_user_profile";
OCSFolderInfoURL = "mysql://sogo:sogopass@127.0.0.1:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL = "mysql://sogo:sogopass@127.0.0.1:3306/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL = "mysql://sogo:sogopass@127.0.0.1:3306/sogo/sogo_alarms_folder";
OCSStoreURL = "mysql://sogo:sogopass@127.0.0.1:3306/sogo/sogo_store";
OCSAclURL = "mysql://sogo:sogopass@127.0.0.1:3306/sogo/sogo_acl";
OCSCacheFolderURL = "mysql://sogo:sogopass@127.0.0.1:3306/sogo/sogo_cache_folder";

SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
IDFieldName = cn;
UIDFieldName = uid;
baseDN = "ou=users,dc=example,dc=net";
bindDN = "uid=sogo,ou=services,dc=example,dc=net";
bindFields = (uid);
bindPassword = sogopass;
canAuthenticate = YES;
displayName = "LDAP";
hostname = ldap://localhost;
id = directory;
isAddressBook = YES;
}
);
}

TagsNo tags attached.

Activities

tohuw

tohuw

2017-04-24 05:32

reporter   ~0011752

I found the issue... MariaDB sets the character sets to utf8mb4, thus it is necessary to complete this by doing as is suggested in the SOGo docs for complete unicode compliance for MySQL. This is covered in section 5.9.1 "Complete Unicode Compliance". Until the sogo.conf and mariadb configurations are properly changed, the database tables will not be created.

This bug can be closed, as it is not a bug.

Issue History

Date Modified Username Field Change
2017-04-24 04:53 tohuw New Issue
2017-04-24 05:32 tohuw Note Added: 0011752
2017-05-08 13:55 ludovic Status new => closed
2017-05-08 13:55 ludovic Assigned To => ludovic
2017-05-08 13:55 ludovic Resolution open => no change required