Hello Your SOGo isn't using your sogo.conf! As sogo-tool dump-defaults gives you some output, you still have a GNUstep configuration laying around in your sogo user.
Move that away, and restart sogo :-) Kind regards, Christian Mack Am 12.02.19 um 15:17 schrieb Carsten Pieper ([email protected]): > Thanks a lot, Odhiambo, > > but that is exactly my problem. > > I have specified User A in my sogo.conf, but in the logs, I see, that > the default user 'sogo' is used. I have set the password of the user > 'sogo' to the password prompted out in the dump-defaults. I can > authenticate via mysql console with User A and user sogo. Now, I change > the password of user 'sogo' to 'sogo'. I can authenticate with the new > password via mysql console, the errors in the log disappear and the > calendar entries are back again. > > Thus, where in the system do I find the defaults dumped out? > > Regards, > > Carsten > > > Am 12.02.19 um 08:29 schrieb Odhiambo Washington ([email protected]): >> [My responses inline] >> >> Since it's been 8hrs since you posted and no one has responded, I will >> try my guess here: >> >> On Tue, 12 Feb 2019 at 01:13, Carsten Pieper <[email protected] >> <mailto:[email protected]>> wrote: >> >> Hi all, >> >> actually, I have some strange problems with SOGO. >> >> A user told me that his calendar is empty. In the logs I find: >> >> Feb 11 01:04:20 sogod [22810]: [ERROR] >> <0x0x56308306d918[GCSChannelManager]> could not open channel >> <MySQL4Channel[0x0x56308826ba68] connection=0x(null)> for >> mysql://localhost/sogo/sogo[...] >> Feb 11 01:04:20 sogod [22810]: [WARN] >> <0x0x56308306d918[GCSChannelManager]> will prevent opening of this >> channel 5 seconds after 2019-02-11 01:04:20 +0100 >> Feb 11 01:04:20 sogod [22810]: [ERROR] <0x0x56308826a138[GCSFolder]> >> could not open storage channel! >> >> >> >> The " could not open channel <MySQL4Channel[0x0x56308826ba68] >> connection" line could be something to do with >> sogod not being able to connect to the MySQL database. >> Could you please try to manually connect to see if the connection is >> successful: >> >> mysql -h localhost -usogo -p sogo <ENTER> >> Then enter the relevant password. >> >> Another way to find out is to edit your /etc/sogo/sogo.conf and enable >> debugging then restart sogod. >> The below are possible debug options that you can enable: >> >> /* Debug */ >> //SOGoDebugRequests = YES; >> //SoDebugBaseURL = YES; >> //ImapDebugEnabled = YES; >> //LDAPDebugEnabled = YES; >> //PGDebugEnabled = YES; >> //MySQL4DebugEnabled = YES; >> //SOGoUIxDebugEnabled = YES; >> //WODontZipResponse = YES; >> >> >> >> >> I tried the dump-default sogo-tool command and got: >> >> root@www:/var/log/sogo# sogo-tool dump-defaults >> { >> OCSFolderInfoURL = >> "mysql://sogo:[...]@localhost:3306/sogo/sogo_folder_info"; >> SOGoACLsSendEMailNotifications = YES; >> SOGoAppointmentSendEMailNotifications = YES; >> SOGoFoldersSendEMailNotifications = YES; >> SOGoLanguage = German; >> SOGoMailDomain = "carstenpieper.com <http://carstenpieper.com>"; >> SOGoProfileURL = >> "mysql://sogo:[...]@localhost:3306/sogo/sogo_user_profile"; >> SOGoTimeZone = "Europe/Berlin"; >> >> SOGoUserSources = ( >> { >> CNFieldName = cn; >> IDFieldName = uid; >> IMAPHostFieldName = mailHost; >> UIDFieldName = uid; >> baseDN = "ou=accounts,dc=[...],dc=com"; >> bindDN = "uid=sogadmin,ou=accounts,dc=[...],dc=com"; >> bindPassword = okoo9Fi; >> canAuthenticate = YES; >> displayName = "Shared Addresses"; >> hostname = localhost; >> id = public; >> isAddressBook = YES; >> port = 389; >> } >> ); >> } >> >> >> Now I have to ask you: Are your SOGoUserSources stored in LDAP of >> MySQL?? >> >> >> >> Now, some questions come into my mind: >> >> 1. Why is there no default for OCSSessionsFolderURL? >> >> >> From https://sogo.nu/files/docs/SOGoInstallationGuide.html, I can see >> that OCSSessionsFolderURL needs to be specified. >> There is a default for it. >> >> >> >> 2. Where do the defaults come from? I had a look in the >> GNUstepDefaults >> but found nothing: >> >> >> SOGo creates them :-) >> >> >> >> -- >> Best regards, >> Odhiambo WASHINGTON, >> Nairobi,KE >> +254 7 3200 0004/+254 7 2274 3223 >> "Oh, the cruft.", grep ^[^#] :-) >> -- >> [email protected] >> https://inverse.ca/sogo/lists -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
