ii libsope-appserver4.9 4.9.r1664.20180320
ii libsope-core4.9 4.9.r1664.20180320
ii libsope-gdl1-4.9 4.9.r1664.20180320
ii libsope-ldap4.9 4.9.r1664.20180320
ii libsope-mime4.9 4.9.r1664.20180320
ii libsope-xml4.9 4.9.r1664.20180320
ii sope4.9-gdl1-mysql 4.9.r1664.20180320
ii sope4.9-libxmlsaxdriver 4.9.r1664.20180320
ii sogo:amd64 4.0.0.20180406-1
ii sogo-activesync 4.0.0.20180406-1
ii libmariadbclient18 10.1.32+maria-1~xenial
ii libmysqlclient18 10.1.32+maria-1~xenial
ii mariadb-client-10.1 10.1.32+maria-1~xenial
ii mariadb-client-core-10.1 10.1.32+maria-1~xenial
ii mariadb-common 10.1.32+maria-1~xenial
ii mariadb-server 10.1.32+maria-1~xenial
ii mariadb-server-10.1 10.1.32+maria-1~xenial
ii mariadb-server-core-10.1 10.1.32+maria-1~xenial
ii mysql-common 10.1.32+maria-1~xenial

Database is Clusted with Galera.
Nightly-Builds

{
/* ***** Main SOGo configuration file **

• *
• Since the content of this file is a dictionary in OpenStep plist format, *
• the curly braces enclosing the body of the configuration are mandatory. *
• See the Installation Guide for details on the format. *
• *
• C and C++ style comments are supported. *
• *
• This example configuration contains only a subset of all available *
• configuration parameters. Please see the installation guide more details. *
• *
• ~sogo/GNUstep/Defaults/.GNUstepDefaults has precedence over this file, *
• make sure to move it away to avoid unwanted parameter overrides. *
• *

• **/

  / Database configuration (mysql:// or postgresql://) /
  SOGoProfileURL = "mysql://sogo:@localhost:3306/sogo/sogo_user_profile";
  OCSFolderInfoURL = "mysql://sogo:@localhost:3306/sogo/sogo_folder_info";
  OCSStoreURL = "mysql://sogo:@localhost:3306/sogo/sogo_store";
  OCSAclURL = "mysql://sogo:@localhost:3306/sogo/sogo_acl";
  OCSCacheFolderURL = "mysql://sogo:@localhost:3306/sogo/sogo_cache_folder";
  OCSSessionsFolderURL = "mysql://sogo:@localhost:3306/sogo/sogo_sessions_folder";

  / Mail /
  SOGoDraftsFolderName = Drafts;
  SOGoSentFolderName = Sent;
  SOGoTrashFolderName = Trash;
  SOGoIMAPServer = localhost;
  SOGoSieveServer = sieve://127.0.0.1:4190;
  SOGoSMTPServer = 127.0.0.1;
  //SOGoMailDomain = acme.com;
  SOGoMailingMechanism = smtp;
  //SOGoForceExternalLoginWithEmail = NO;
  //SOGoMailSpoolPath = /var/spool/sogo;
  //NGImap4ConnectionStringSeparator = "/";

  / Notifications /
  //SOGoAppointmentSendEMailNotifications = NO;
  //SOGoACLsSendEMailNotifications = NO;
  //SOGoFoldersSendEMailNotifications = NO;

  / Authentication /
  SOGoPasswordChangeEnabled = YES;

  / LDAP authentication example /
  //SOGoUserSources = (
  // {
  // type = ldap;
  // CNFieldName = cn;
  // UIDFieldName = uid;
  // IDFieldName = uid; // first field of the DN for direct binds
  // bindFields = (uid, mail); // array of fields to use for indirect binds
  // baseDN = "ou=users,dc=acme,dc=com";
  // bindDN = "uid=sogo,ou=users,dc=acme,dc=com";
  // bindPassword = qwerty;
  // canAuthenticate = YES;
  // displayName = "Shared Addresses";
  // hostname = ldap://127.0.0.1:389;
  // id = public;
  // isAddressBook = YES;
  // }
  //);

  / LDAP AD/Samba4 example /
  //SOGoUserSources = (
  // {
  // type = ldap;
  // CNFieldName = cn;
  // UIDFieldName = sAMAccountName;
  // baseDN = "CN=users,dc=domain,dc=tld";
  // bindDN = "CN=sogo,CN=users,DC=domain,DC=tld";
  // bindFields = (sAMAccountName, mail);
  // bindPassword = password;
  // canAuthenticate = YES;
  // displayName = "Public";
  // hostname = ldap://127.0.0.1:389;
  // filter = "mail = '*'";
  // id = directory;
  // isAddressBook = YES;
  // }
  //);

  / SQL authentication example /
  /* These database columns MUST be present in the view/table:

• c_uid - will be used for authentication - it's the username or username@domain.tld)
• c_name - which can be identical to c_uid - will be used to uniquely identify entries
• c_password - password of the user, plain-text, md5 or sha encoded for now
• c_cn - the user's common name - such as "John Doe"
• mail - the user's mail address

• See the installation guide for more details
  */
  SOGoUserSources = (
  {
  type = sql;
  id = vmail_mailbox;
  viewURL = "mysql://sogo:****@127.0.0.1:3306/sogo/users";
  canAuthenticate = YES;

      // Default algorithm used when changing passwords.
      userPasswordAlgorithm = ssha;
      prependPasswordScheme = YES;
  
      // Use vmail.mailbox as global address book.
      // WARNING: This will search all user accounts, not just accounts
      // under same domain as login user.
      //isAddressBook = YES;
      //displayName = "Global Address Book";
  }

  );

  / Web Interface /
  SOGoPageTitle = SOGo;
  SOGoVacationEnabled = YES;
  SOGoForwardEnabled = YES;
  SOGoSieveScriptsEnabled = YES;
  SOGoMailAuxiliaryUserAccountsEnabled = YES;
  SOGoTrustProxyAuthentication = NO;
  SOGoXSRFValidationEnabled = YES;

  / General - SOGoTimeZone MUST be defined /
  SOGoLanguage = German;
  SOGoTimeZone = Europa/Berlin;
  SOGoCalendarDefaultRoles = (
  PublicDAndTViewer,
  ConfidentialDAndTViewer
  );
  //SOGoSuperUsernames = (sogo1, sogo2); // This is an array - keep the parens!
  SxVMemLimit = 8096 ;
  WOPidFile = "/var/run/sogo/sogo.pid";
  SOGoMemcachedHost = "/var/run/memcached.sock";

  / Debug /
  //SOGoDebugRequests = YES;
  //SoDebugBaseURL = YES;
  //ImapDebugEnabled = YES;
  //LDAPDebugEnabled = YES;
  //PGDebugEnabled = YES;
  //MySQL4DebugEnabled = YES;
  //SOGoUIxDebugEnabled = YES;
  //WODontZipResponse = YES;
  WOLogFile = /var/log/sogo/sogo.log;
  }