Hello, I just tried to setup SOGo for the first time, and I'm recieving
these errors when I attempt to log in with OIDC:
Jul 21 10:07:17 quadraticserver sogod[530030]:
<0x0x55fac60f9ea8[GCSSessionsFolder]> -[GCSSessionsFolder
writeRecordForEntryWithID:value:creationDate:lastSeenDate:]: cannot
write record: <MySQL4Exception: 0x55fac624dfa8> NAME:ExecutionFailed
REASON:Table 'sogo.sogo_sessions_folder' doesn't exist
Jul 21 10:07:17 quadraticserver sogod[530030]:
<0x0x55fac60f9ea8[GCSSessionsFolder]> -[GCSSessionsFolder
recordForEntryWithID:]: cannot execute fetch: <MySQL4Exception:
0x55fac6365df8> NAME:ExecutionFailed REASON:Table
'sogo.sogo_sessions_folder' doesn't exist
Jul 21 10:07:17 quadraticserver sogod[530030]:
<0x0x55fac6157748[GCSOpenIdFolder]> -[GCSOpenIdFolder
deleteOpenIdSessionFor:]: cannot delete record: <MySQL4Exception:
0x55fac6204328> NAME:ExecutionFailed REASON:Table 'sogo.sogo_openid'
doesn't exist
Any help would be appreciated, thank you. Here is my config:
{
// Mandatory parameters
SOGoTimeZone = "America/Toronto";
SOGoLanguage = "English";
// Paths
WOSendMail = "/run/wrappers/bin/sendmail";
SOGoMailSpoolPath = "/var/lib/sogo/spool";
// Enable CSRF protection
SOGoXSRFValidationEnabled = YES;
// Remove dates from log (jornald does that)
NGLogDefaultLogEventFormatterClass = "NGLogEventFormatter";
// Extra config
SOGoMailDomain = "federated.nexus";
SOGoMemcachedHost = "/run/memcached/memcached.sock";
SOGoAuthenticationType = "openid";
SOGoOpenIdConfigUrl =
"<https://auth.federated.nexus/.well-known/openid-configuration>";
SOGoOpenIdClient = "Federated Nexus Auth";
SOGoOpenIdClientSecret = "";
SOGoOpenIdScope = "";
SOGoOpenIdTokenCheckInterval = 600;
SOGoSMTPServer = "smtp://localhost";
SOGoSMTPAuthenticationType = "xoauth2";
SOGoIMAPServer = "imap://localhost";
NGImap4AuthMechanism = "xoauth2";
SOGoPageTitle = "Federated Nexus Mail";
SOGoZipPath =
"/nix/store/ginvr5w1gxj00cphlwgxv035mkl5x0dq-zip-3.0/bin/zip";
OCSSessionsFolderURL =
"mysql://sogo@%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_sessions_folder";
OCSFolderInfoURL =
"mysql://sogo@%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_folder_info";
OCSOpenIdURL =
"mysql://sogo@%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_openid";
}
-- Henry Hiles
