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
--
CARSTEN PIEPER
Dyckburgheide 1
48157 Münster
Deutschland
Fon: +49 251 3997257
Fax: +49 251 3997256
Mobil: +49 151 46673961
E-Mail: [email protected]
Internet: www.carstenpieper.com
--
[email protected]
https://inverse.ca/sogo/lists
