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. All is (actually) well now.
> On Apr 23, 2017, at 21:31, Ron Scott-Adams <[email protected]> wrote: > > I tried spinning up a completely fresh instance on Ubuntu 16.04.2 using the > official nightly repo and notice that there, the problem is similar: only one > table is created, sogo_acl. > > Any ideas? > >> On Apr 23, 2017, at 05:16, Ron Scott-Adams <[email protected] >> <mailto:[email protected]>> wrote: >> >> After a very confusing session of troubleshooting settings not being >> available, I’ve realized it isn’t solved after all: there’s still no tables. >> Can someone take a look at this and assist? Thank you! >> >> >>> On Apr 23, 2017, at 03:28, Ron Scott0Adams <[email protected] >>> <mailto:[email protected]>> wrote: >>> >>> Thanks to a little digging through the archives, I found the issue is that >>> memcached and rpl weren’t installed. Seems there’s some missing >>> dependencies in the Ubuntu repo version of this package. All is well now. >>> >>> >>>> On Apr 23, 2017, at 03:16, Ron Scott0Adams <[email protected] >>>> <mailto:[email protected]>> wrote: >>>> >>>> I see the following in sogo.log after logging in to the web interface >>>> (which succeeds): >>>>> sogod [11471]: [WARN] <0x0x7fbac999c4c0[WOxElemBuilder]> could not locate >>>>> builders: WOxExtElemBuilder,WOxExtElemBuilder >>>>> sogod [11471]: <0x0x5614b1d9b1b0[SOGoCache]> an error occurred when >>>>> caching value for key ‘myuser+dn': "SERVER HAS FAILED AND IS DISABLED >>>>> UNTIL TIMED RETRY” >>>> >>>> As near as I can tell, connection to the database is successful. It >>>> certainly fails if I throw a bogus password. Additionally, I verified the >>>> mysql user ‘sogo’ has all privileges on the database ‘sogo’. >>>> >>>> My sogo.conf: >>>> { >>>> SOGoLanguage = English; >>>> SOGoTimeZone = America/Chicago; >>>> SOGoAppointmentSendEMailNotifications = YES; >>>> SOGoFirstDayOfWeek = 0; >>>> SOGoMailMessageCheck = every_minute; >>>> SOGoMailAuxiliaryUserAccountsEnabled = YES; >>>> SOGoMemcachedHost = 127.0.0.1; >>>> SOGoMailDomain = tohuw.net <http://tohuw.net/>; >>>> SOGoPasswordChangeEnabled = YES; >>>> SOGoMaximumFailedLoginCount = 5; >>>> SOGoMaximumFailedLoginInterval = 60; >>>> SOGoFailedLoginBlockInterval = 300; >>>> >>>> SOGoPageTitle = "TohuwNet"; >>>> SOGoLoginModule = Mail; >>>> >>>> >>>> MySQL4Encoding = "utf8mb4"; >>>> SOGoProfileURL = >>>> "mysql://sogo:my_password@localhost/sogo/sogo_user_profile >>>> <mysql://sogo:my_password@localhost/sogo/sogo_user_profile>"; >>>> OCSFolderInfoURL = >>>> "mysql://sogo:my_password@localhost/sogo/sogo_folder_info >>>> <mysql://sogo:my_password@localhost/sogo/sogo_folder_info>"; >>>> OCSSessionsFolderURL = >>>> "mysql://sogo:my_password@localhost/sogo/sogo_sessions_folder >>>> <mysql://sogo:my_password@localhost/sogo/sogo_sessions_folder>"; >>>> OCSEMailAlarmsFolderURL = >>>> "mysql://sogo:my_password@localhost/sogo/sogo_alarms_folder >>>> <mysql://sogo:my_password@localhost/sogo/sogo_alarms_folder>"; >>>> OCSStoreURL = "mysql://sogo:my_password@localhost/sogo/sogo_store >>>> <mysql://sogo:my_password@localhost/sogo/sogo_store>"; >>>> OCSAclURL = "mysql://sogo:my_password@localhost/sogo/sogo_acl >>>> <mysql://sogo:my_password@localhost/sogo/sogo_acl>"; >>>> OCSCacheFolderURL = >>>> "mysql://sogo:my_password@localhost/sogo/sogo_cache_folder >>>> <mysql://sogo:my_password@localhost/sogo/sogo_cache_folder>"; >>>> >>>> SOGoMailingMechanism = smtp; >>>> SOGoSMTPServer = 127.0.0.1; >>>> >>>> SOGoIMAPServer = "imaps://localhost:143/?tls=YES >>>> <imaps://localhost:143/?tls=YES>"; >>>> SOGoSieveServer = "sieve://localhost:4190/?tls=YES >>>> <sieve://localhost:4190/?tls=YES>"; >>>> SOGoIMAPAclConformsToIMAPExt = YES; >>>> SOGoSentFolderName = Sent; >>>> SOGoTrashFolderName = Trash; >>>> SOGoDraftsFolderName = Drafts; >>>> SOGoVacationEnabled = YES; >>>> SOGoForwardEnabled = YES; >>>> SOGoSieveScriptsEnabled = YES; >>>> >>>> SOGoLDAPContactInfoAttribute = displayName; >>>> >>>> SOGoUserSources = ( >>>> { >>>> type = ldap; >>>> CNFieldName = cn; >>>> IDFieldName = cn; >>>> UIDFieldName = uid; >>>> baseDN = "ou=users,dc=tohuw,dc=net"; >>>> bindDN = "uid=sogo,ou=services,dc=tohuw,dc=net"; >>>> bindFields = (uid); >>>> bindPassword = my_ldap_password; >>>> canAuthenticate = YES; >>>> displayName = "TohuwNet"; >>>> hostname = ldap://localhost <ldap://localhost>; >>>> id = directory; >>>> isAddressBook = YES; >>>> } >>>> ); >>>> } >>> >> >
smime.p7s
Description: S/MIME cryptographic signature
