julienfastre
commented
7 years ago @marwey Could you dump your sogo.conf file ? (please take care of removing sensitive data, like passwords and URL of your ldap server).
Closed marwey closed 7 years ago
julienfastre
commented
7 years ago @marwey Could you dump your sogo.conf file ? (please take care of removing sensitive data, like passwords and URL of your ldap server).
marwey
commented
7 years ago @julienfastre Thank you for looking into this! Please find below the sogo.conf file I am using. I haven't set up the SMTP server yet - just the LDAP server so far. Postgres configuration is also untouched and currently set as in the example conf file.
{
/* Database configuration (mysql:// or postgresql://) */
SOGoProfileURL = "postgresql://postgres:postgres@db:5432/postgres/sogo_user_profile";
OCMDolderInfoURL = "postgresql://postgres:postgres@db:5432/postgres/sogo_folder_info";
OCSSessionMDolderURL = "postgresql://postgres:postgres@db:5432/postgres/sogo_sessions_folder";
/* Mail */
//SOGoDraftMDolderName = Drafts;
//SOGoSentFolderName = Sent;
//SOGoTrashFolderName = Trash;
SOGoIMAPServer = "imaps://imap.example.tld:143/?tls=yes";
SOGoSieveServer = sieve://sieve.example.tld:4190;
SOGoSMTPServer = smtp.example.tld;
SOGoMailDomain = example.tld;
SOGoMailingMechanism = smtp;
SOGoForceExternalLoginWithEmail = YES;
SOGoSMTPAuthenticationType = PLAIN;
SOGoForceExternalLoginWithEmail = YES;
//SOGoMailSpoolPath = /var/spool/sogo;
//NGImap4ConnectionStringSeparator = "/";
/* Notifications */
//SOGoAppointmentSendEMailNotifications = NO;
//SOGoACLsSendEMailNotifications = NO;
//SOGoFoldersSendEMailNotifications = NO;
/* Authentication */
SOGoPasswordChangeEnabled = NO;
/* LDAP authentication example */
/* LDAP authentication example */
SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
UIDFieldName = cn; // uid;
IDFieldName = cn; // uid; // first field of the DN for direct binds
bindFields = cn; // (uid, mail); // array of fields to use for indirect binds
baseDN = "dc=mydomain,dc=com";
bindDN = "cn=admin,dc=mydomain,dc=com";
bindPassword = topsecret;
canAuthenticate = YES;
displayName = "Shared Addresses";
hostname = 192.168.188.5;
// encryption = SSL;
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 = directory;
// viewURL = "postgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_view";
// canAuthenticate = YES;
// isAddressBook = YES;
// userPasswordAlgorithm = md5;
// }
// );
/* Web Interface */
SOGoPageTitle = mydomain;
SOGoVacationEnabled = YES;
//SOGoForwardEnabled = YES;
//SOGoSieveScriptsEnabled = YES;
//SOGoMailAuxiliaryUserAccountsEnabled = YES;
//SOGoTrustProxyAuthentication = NO;
//SOGoXSRFValidationEnabled = YES;
/* General */
SOGoLanguage = English;
SOGoTimeZone = Europe/Berlin;
//SOGoCalendarDefaultRoles = (
// PublicDAndTViewer,
// ConfidentialDAndTViewer
//);
//SOGoSuperUsernames = (sogo1, sogo2); // This is an array - keep the parens!
//SxVMemLimit = 384;
//WOPidFile = "/var/run/sogo/sogo.pid";
// reach memcached through docker
SOGoMemcachedHost = "memcached";
// this has a great impact on performance: you should adjust the number
// of workers according to the number of users and the performance of your
// machine
WorkersCount = 4;
/* Debug */
//SOGoDebugRequests = YES;
//SoDebugBaseURL = YES;
//ImapDebugEnabled = YES;
LDAPDebugEnabled = YES;
//PGDebugEnabled = YES;
//MySQL4DebugEnabled = YES;
//SOGoUIxDebugEnabled = YES;
//WODontZipResponse = YES;
//WOLogFile = /var/log/sogo/sogo.log;
}No time to look at this today, by tomorrow or thursday I may do some tests.
Could your run your instance with PGDebugEnabled = YES; uncommented ? Maybe we will have more debug messages.
marwey
commented
7 years ago @julienfastre yes sure, no problem!
I've uncommented PGDebugEnabled = YES; and restarted the server. See the output below:
sogo_1 | ^
sogo_1 |
sogo_1 | Mar 07 11:45:23 sogod [7]: |SOGo| request took 0.014426 seconds to execute
nginx_1 | 192.168.188.201 - - [07/Mar/2017:10:45:23 +0000] "GET /SOGo/so/rouser/jsonDefaults HTTP/1.1" 200 965 "http://192.168.188.5:8080/SOGo/so/rouser/Mail/view" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36" "-"
sogo_1 | Mar 07 11:45:23 sogod [7]: 192.168.188.5 "GET /SOGo/so/rouser/jsonDefaults HTTP/1.1" 200 965/0 0.015 - - 608K
sogo_1 | Mar 07 11:45:23 sogod [1]: [ERROR] <0x0x557b6ead1f50[WOWatchDog]> No child available to handle incoming request!
sogo_1 | Mar 07 11:45:23 sogod [7]: |SOGo| starting method 'GET' on uri '/SOGo/so/rouser/jsonSettings'
sogo_1 | 2017-03-07 11:45:23.154 sogod[7] PG0x0x557b6f21f420 SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'
db_1 | ERROR: relation "sogo_user_profile" does not exist at character 24
db_1 | STATEMENT: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f1c0330[SOGoSQLUserProfile]> could not run SQL 'SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'': <PostgreSQL72Exception: 0x557b6f35c430> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x557b6f21f420[PostgreSQL72Channel]: connection=<0x0x557b6f2047c0[PGConnection]: connection=0x0x557b6f204970>>): ERROR: relation "sogo_user_profile" does not exist
sogo_1 | LINE 1: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rous...
sogo_1 | ^
sogo_1 |
sogo_1 | Mar 07 11:45:23 sogod [7]: |SOGo| request took 0.002828 seconds to execute
sogo_1 | Mar 07 11:45:23 sogod [7]: 192.168.188.5 "GET /SOGo/so/rouser/jsonSettings HTTP/1.1" 200 43/0 0.004 - - 0
nginx_1 | 192.168.188.201 - - [07/Mar/2017:10:45:23 +0000] "GET /SOGo/so/rouser/jsonSettings HTTP/1.1" 200 43 "http://192.168.188.5:8080/SOGo/so/rouser/Mail/view" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36" "-"
sogo_1 | Mar 07 11:45:23 sogod [7]: |SOGo| starting method 'GET' on uri '/SOGo/so/rouser/Mail/0/view'
sogo_1 | 2017-03-07 11:45:23.158 sogod[7] PG0x0x557b6ef9a770 SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rouser'
db_1 | ERROR: relation "sogo_user_profile" does not exist at character 24
db_1 | STATEMENT: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rouser'
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0c8290[SOGoSQLUserProfile]> could not run SQL 'SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rouser'': <PostgreSQL72Exception: 0x557b6f315b70> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x557b6ef9a770[PostgreSQL72Channel]: connection=<0x0x557b6ef9ae40[PGConnection]: connection=0x0x557b6ef9aff0>>): ERROR: relation "sogo_user_profile" does not exist
sogo_1 | LINE 1: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rous...
sogo_1 | ^
sogo_1 |
db_1 | ERROR: relation "sogo_user_profile" does not exist at character 24
db_1 | STATEMENT: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'
sogo_1 | 2017-03-07 11:45:23.159 sogod[7] PG0x0x557b6f21f420 SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0e6440[SOGoSQLUserProfile]> could not run SQL 'SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'': <PostgreSQL72Exception: 0x557b6f1eb840> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x557b6f21f420[PostgreSQL72Channel]: connection=<0x0x557b6f2047c0[PGConnection]: connection=0x0x557b6f204970>>): ERROR: relation "sogo_user_profile" does not exist
sogo_1 | LINE 1: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rous...
sogo_1 | ^
sogo_1 |
sogo_1 | 2017-03-07 11:45:23.206 sogod[7] Host 'imap.example.tld' not found using 'gethostbyname()' - perhaps the hostname is wrong or networking is not set up on your machine
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0c2a40[NGImap4ConnectionManager]> IMAP4 login failed:
sogo_1 | host=imap.example.tld, user=rouser@example.tld, pwd=yes
sogo_1 | url=imaps://rouser%40example.tld@imap.example.tld/?tls=YES
sogo_1 | base=(null)
sogo_1 | base-class=(null))
sogo_1 | = <0x0x557b6f30b370[NGImap4Client]: login=rouser@example.tld(pwd) address=<0x0x557b6f36e030[NGInternetSocketAddress]: host=imap.example.tld not-filled>>
sogo_1 | Mar 07 11:45:23 sogod [7]: <0x557b6f0c6850[SOGoMailAccount]:0> renewing imap4 password
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0c2a40[NGImap4ConnectionManager]> IMAP4 login failed:
sogo_1 | host=imap.example.tld, user=rouser@example.tld, pwd=yes
sogo_1 | url=imaps://rouser%40example.tld@imap.example.tld/?tls=YES
sogo_1 | base=(null)
sogo_1 | base-class=(null))
sogo_1 | = <0x0x557b6f302fd0[NGImap4Client]: login=rouser@example.tld(pwd) address=<0x0x557b6f1c6800[NGInternetSocketAddress]: host=imap.example.tld not-filled>>
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x557b6f0c6850[SOGoMailAccount]:0> Could not connect IMAP4
sogo_1 | Mar 07 11:45:23 sogod [7]: |SOGo| request took 0.055327 seconds to execute
nginx_1 | 192.168.188.201 - - [07/Mar/2017:10:45:23 +0000] "GET /SOGo/so/rouser/Mail/0/view HTTP/1.1" 200 17 "http://192.168.188.5:8080/SOGo/so/rouser/Mail/view" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36" "-"
sogo_1 | Mar 07 11:45:23 sogod [7]: 192.168.188.5 "GET /SOGo/so/rouser/Mail/0/view HTTP/1.1" 200 17/0 0.056 - - 600K
sogo_1 | Mar 07 11:45:23 sogod [7]: |SOGo| starting method 'GET' on uri '/SOGo/so/rouser/Mail/0/view'
sogo_1 | 2017-03-07 11:45:23.365 sogod[7] PG0x0x557b6ef9a770 SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rouser'
db_1 | ERROR: relation "sogo_user_profile" does not exist at character 24
db_1 | STATEMENT: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rouser'
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6efe4ff0[SOGoSQLUserProfile]> could not run SQL 'SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rouser'': <PostgreSQL72Exception: 0x557b6efd9210> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x557b6ef9a770[PostgreSQL72Channel]: connection=<0x0x557b6ef9ae40[PGConnection]: connection=0x0x557b6ef9aff0>>): ERROR: relation "sogo_user_profile" does not exist
sogo_1 | LINE 1: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rous...
sogo_1 | ^
sogo_1 |
db_1 | ERROR: relation "sogo_user_profile" does not exist at character 24
db_1 | STATEMENT: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'
sogo_1 | 2017-03-07 11:45:23.365 sogod[7] PG0x0x557b6f21f420 SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0c8290[SOGoSQLUserProfile]> could not run SQL 'SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'': <PostgreSQL72Exception: 0x557b6f0dbfd0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x557b6f21f420[PostgreSQL72Channel]: connection=<0x0x557b6f2047c0[PGConnection]: connection=0x0x557b6f204970>>): ERROR: relation "sogo_user_profile" does not exist
sogo_1 | LINE 1: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rous...
sogo_1 | ^
sogo_1 |
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0c2a40[NGImap4ConnectionManager]> IMAP4 login failed:
sogo_1 | host=imap.example.tld, user=rouser@example.tld, pwd=yes
sogo_1 | url=imaps://rouser%40example.tld@imap.example.tld/?tls=YES
sogo_1 | base=(null)
sogo_1 | base-class=(null))
sogo_1 | = <0x0x557b6f309610[NGImap4Client]: login=rouser@example.tld(pwd) address=<0x0x557b6f0e13b0[NGInternetSocketAddress]: host=imap.example.tld not-filled>>
sogo_1 | Mar 07 11:45:23 sogod [7]: <0x557b6f12c170[SOGoMailAccount]:0> renewing imap4 password
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0c2a40[NGImap4ConnectionManager]> IMAP4 login failed:
sogo_1 | host=imap.example.tld, user=rouser@example.tld, pwd=yes
sogo_1 | url=imaps://rouser%40example.tld@imap.example.tld/?tls=YES
sogo_1 | base=(null)
sogo_1 | base-class=(null))
sogo_1 | = <0x0x557b6f2f4d30[NGImap4Client]: login=rouser@example.tld(pwd) address=<0x0x557b6f0e1f00[NGInternetSocketAddress]: host=imap.example.tld not-filled>>
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x557b6f12c170[SOGoMailAccount]:0> Could not connect IMAP4
sogo_1 | Mar 07 11:45:23 sogod [7]: |SOGo| request took 0.007854 seconds to execute
sogo_1 | Mar 07 11:45:23 sogod [7]: 192.168.188.5 "GET /SOGo/so/rouser/Mail/0/view HTTP/1.1" 200 17/0 0.009 - - 0
nginx_1 | 192.168.188.201 - - [07/Mar/2017:10:45:23 +0000] "GET /SOGo/so/rouser/Mail/0/view HTTP/1.1" 200 17 "http://192.168.188.5:8080/SOGo/so/rouser/Mail/view" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36" "-"
nginx_1 | 192.168.188.201 - - [07/Mar/2017:10:45:23 +0000] "GET /SOGo.woa/WebServerResources/fonts/FiraSans-Regular.woff HTTP/1.1" 304 0 "http://192.168.188.5:8080/SOGo.woa/WebServerResources/css/styles.css" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36" "-"
nginx_1 | 192.168.188.201 - - [07/Mar/2017:10:45:23 +0000] "GET /SOGo.woa/WebServerResources/fonts/FiraSans-Medium.woff HTTP/1.1" 304 0 "http://192.168.188.5:8080/SOGo.woa/WebServerResources/css/styles.css" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36" "-"
sogo_1 | Mar 07 11:45:23 sogod [7]: |SOGo| starting method 'POST' on uri '/SOGo/so/rouser/Mail/unseenCount'
sogo_1 | 2017-03-07 11:45:23.501 sogod[7] PG0x0x557b6ef9a770 SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rouser'
db_1 | ERROR: relation "sogo_user_profile" does not exist at character 24
db_1 | STATEMENT: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rouser'
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f02ab40[SOGoSQLUserProfile]> could not run SQL 'SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rouser'': <PostgreSQL72Exception: 0x557b6eff2c60> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x557b6ef9a770[PostgreSQL72Channel]: connection=<0x0x557b6ef9ae40[PGConnection]: connection=0x0x557b6ef9aff0>>): ERROR: relation "sogo_user_profile" does not exist
sogo_1 | LINE 1: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rous...
sogo_1 | ^
sogo_1 |
sogo_1 | 2017-03-07 11:45:23.502 sogod[7] PG0x0x557b6f21f420 SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'
db_1 | ERROR: relation "sogo_user_profile" does not exist at character 24
db_1 | STATEMENT: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0cca20[SOGoSQLUserProfile]> could not run SQL 'SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rouser'': <PostgreSQL72Exception: 0x557b6f129000> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x557b6f21f420[PostgreSQL72Channel]: connection=<0x0x557b6f2047c0[PGConnection]: connection=0x0x557b6f204970>>): ERROR: relation "sogo_user_profile" does not exist
sogo_1 | LINE 1: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rous...
sogo_1 | ^
sogo_1 |
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0c2a40[NGImap4ConnectionManager]> IMAP4 login failed:
sogo_1 | host=imap.example.tld, user=rouser@example.tld, pwd=yes
sogo_1 | url=imaps://rouser%40example.tld@imap.example.tld/?tls=YES
sogo_1 | base=(null)
sogo_1 | base-class=(null))
sogo_1 | = <0x0x557b6f0f8ea0[NGImap4Client]: login=rouser@example.tld(pwd) address=<0x0x557b6f3434c0[NGInternetSocketAddress]: host=imap.example.tld not-filled>>
sogo_1 | Mar 07 11:45:23 sogod [7]: <0x557b6f1ba910[SOGoMailAccount]:0> renewing imap4 password
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x0x557b6f0c2a40[NGImap4ConnectionManager]> IMAP4 login failed:
sogo_1 | host=imap.example.tld, user=rouser@example.tld, pwd=yes
sogo_1 | url=imaps://rouser%40example.tld@imap.example.tld/?tls=YES
sogo_1 | base=(null)
sogo_1 | base-class=(null))
sogo_1 | = <0x0x557b6f0d27c0[NGImap4Client]: login=rouser@example.tld(pwd) address=<0x0x557b6f338fa0[NGInternetSocketAddress]: host=imap.example.tld not-filled>>
sogo_1 | Mar 07 11:45:23 sogod [7]: [ERROR] <0x557b6f1ba910[SOGoMailAccount]:0> Could not connect IMAP4
sogo_1 | Mar 07 11:45:23 sogod [7]: |SOGo| request took 0.008890 seconds to execute
nginx_1 | 192.168.188.201 - - [07/Mar/2017:10:45:23 +0000] "POST /SOGo/so/rouser/Mail/unseenCount HTTP/1.1" 200 21 "http://192.168.188.5:8080/SOGo/so/rouser/Mail/view" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36" "-"
sogo_1 | Mar 07 11:45:23 sogod [7]: 192.168.188.5 "POST /SOGo/so/rouser/Mail/unseenCount HTTP/1.1" 200 21/31 0.010 - - 0
nginx_1 | 192.168.188.201 - - [07/Mar/2017:10:45:23 +0000] "GET /SOGo.woa/WebServerResources/fonts/FiraSans-Thin.woff HTTP/1.1" 304 0 "http://192.168.188.5:8080/SOGo.woa/WebServerResources/css/styles.css" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36" "-"@julienfastre did you have time to look at the issue?
julienfastre
commented
7 years ago Hi,
I have problem reproducing this bug...
It seems that the database schema is not created when you launch sogo. But I do not know why. Have you any hint ?
julienfastre
commented
7 years ago Sorry for the delay.
I could reproduce the bug.
On your part, could you have some hint ?
julienfastre
commented
7 years ago I could solve the problem by running docker-compose up --force-recreate
Sogo create schema lazingly at startup. It seems that the bug you mention appears when sogo initialize a first time the database, then the database is destroyed, and sogo restarted again.
When you re-create the container, it seems that sogo check the database schema again; this steps seems to be omitted after initial start. But when you recreate the container, the verification is done and the schema created, if required.
@marwey could you tell me if your bug is solved, or if, due to the long delay, this is no more relevant for you ?
marwey
commented
7 years ago @julienfastre - great the you were able to recreate the bug and that you could fix it! ;-)
It still is relevant for me. Just didn't have an idea how to work around the issue.
Will test your proposed solution ASAP and let you if it worked for me.
Thanks again!
julienfastre
commented
7 years ago I am closing this issue. Please re-open it if your problem is not fixed.
Hi, I was setting up a SOGo docker installation based on this docker-compose file:
I configured access to an LDAP server in sogo.conf and can login just fine!
However, I receive the errors attached below when accessing the database.
Any idea what went wrong here?
Thanks!