[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 <users@sogo.nu> 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";
> 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 ^[^#] :-)
--
users@sogo.nu
https://inverse.ca/sogo/lists
