Re: [SOGo] Sogo Calendar events deleted

2023-03-05 Thread HYVERNAT Philippe 

Le 14/02/2023 à 09:01, Odhiambo Washington (odhia...@gmail.com) a écrit :



On Tue, Feb 14, 2023 at 9:50 AM HYVERNAT Philippe  wrote:

In complement, we have many error like this :

I follow recommendations from the list to solve this issue but
never works.


 sogod [89977]: <0x0x804808158[SOGoCache]> an error occurred when
caching value for key '/Users/u...@mydomein.com/Calendar/personal
': "SERVER HAS FAILED
AND IS DISABLED UNTIL TIMED RETRY"


For starters, may I please request you to try and adhere to the 
following guideline when communicating on mailing lists:

1. https://support.google.com/a/users/answer/9283192#better-conversations
I am mostly interested in replying inline and NOT top-posting. Thank 
you very much.


Now, looking at your captured error, it would appear that you have a 
problem with caching and that problem lies with memcached, because 
that is where caching is done.
On FreeBSD which I believe you are familiar with, you can do one of 
two things:
1. Log all queries to memcached. You do this by adding -vvv (the 
number of v's depend on the verbosity you want) to memcached_flags in 
rc.conf and restarting memcached.

    I'd also try and give Memcached a little more RAM to use with -m 128


In /etc/rc.conf :

memcached_enable="YES"
memcached_flags="-vvv -m 128"


2. Capture these queries in it's own file by adding a specific logging 
config to /etc/syslog.conf:


!memcached
*.* /var/log/memcached.log #please touch this file!
Then restart syslogd with: kill -HUP `cat /var/run/syslog.pid`

From there, for every entry about caching in sogo.log, check for a 
corresponding entry in memcached.log.

Hopefully, you will nail the problem by deducing a solution.


Here's the entry memcached :

Kicking LRU crawler off for LRU 244
Kicking LRU crawler off for LRU 245
Kicking LRU crawler off for LRU 246
Kicking LRU crawler off for LRU 247
Kicking LRU crawler off for LRU 248
Kicking LRU crawler off for LRU 249
Kicking LRU crawler off for LRU 250
Kicking LRU crawler off for LRU 251
Kicking LRU crawler off for LRU 252
Kicking LRU crawler off for LRU 253
Kicking LRU crawler off for LRU 254
Kicking LRU crawler off for LRU 255
Nothing left to crawl for 1
Nothing left to crawl for 2
Nothing left to crawl for 3
Nothing left to crawl for 4
Nothing left to crawl for 5

 to 255

With the sogocache error

 <0x0x804ae81a8[SOGoCache]> an error occurred when caching value for 
key '/Users/u...@mydomain.com/Calendar/personal': "SERVER HAS FAILED AND 
IS DISABLED UNTIL TIMED RETRY"






Sorry for the lecture. I just did not want to make assumptions that 
you know what I wanted you to do :)


--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

Re: [SOGo] Sogo Calendar events deleted

2023-02-14 Thread Odhiambo Washington 
Why would you let log file grow to several GB? What happened to configuring
log file rotations? :)

Please split the log file into several manageable sizes. Something like
this: split -b100m -a5 sogo.log
(Split splits the files based upon your size specification whether based
upon line or bytes. It then adds a suffix to these files to keep them in
order)

and do the usual grep on them - grep "string1|string2|string3" file_name.


On Tue, Feb 14, 2023 at 12:21 PM HYVERNAT Philippe  wrote:

> Ok i activate :
>
> MySQL4DebugEnabled = YES;
>
>  SOGoEASDebugEnabled = YES;
>
>
> Restart the service and log are written.
>
> like my precedent mail we have many errors like  :
>
> Feb 14 09:38:35 sogod [54518]: <0x0x804807118[SOGoCache]> an error
> occurred when caching value for key '/Users/*user*@
> ehpad-avs.fr/Calendar/personal': "SERVER HAS FAILED AND IS DISABLED UNTIL
> TIMED RETRY"
>
>
>
> Do you know how can i filter my log ?
>
> With grep "warning" and grep "error" ?  the log file wait several GB
>
>
> Le 14/02/2023 à 07:24, Odhiambo Washington (odhia...@gmail.com) a écrit :
>
>
>
> On Mon, Feb 13, 2023 at 7:40 PM HYVERNAT Philippe  wrote:
>
>> Thanks a lot for your answer :
>>
>> Here is my configuration. I add EAS options. Nothing was set
>>
>> The problem is that the issue is very difficult to make and users doesn't
>> know when it really appear.
>>
>> I check the debug log for EAS and see
>>
>
> The Debug log for EAS and MySQL !
> Those two must reveal something.
>
> --
> Best regards,
> Odhiambo WASHINGTON,
> Nairobi,KE
> +254 7 3200 0004/+254 7 2274 3223
> "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
>
>

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

Re: [SOGo] Sogo Calendar events deleted

2023-02-14 Thread HYVERNAT Philippe 

Ok i activate :

MySQL4DebugEnabled = YES;

 SOGoEASDebugEnabled = YES;


Restart the service and log are written.

like my precedent mail we have many errors like  :

Feb 14 09:38:35 sogod [54518]: <0x0x804807118[SOGoCache]> an error 
occurred when caching value for key 
'/Users/*user*@ehpad-avs.fr/Calendar/personal': "SERVER HAS FAILED AND 
IS DISABLED UNTIL TIMED RETRY"




Do you know how can i filter my log ?

With grep "warning" and grep "error" ?  the log file wait several GB


Le 14/02/2023 à 07:24, Odhiambo Washington (odhia...@gmail.com) a écrit :



On Mon, Feb 13, 2023 at 7:40 PM HYVERNAT Philippe  wrote:

Thanks a lot for your answer :

Here is my configuration. I add EAS options. Nothing was set

The problem is that the issue is very difficult to make and users
doesn't know when it really appear.

I check the debug log for EAS and see


The Debug log for EAS and MySQL !
Those two must reveal something.

--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

Re: [SOGo] Sogo Calendar events deleted

2023-02-14 Thread Odhiambo Washington 
On Tue, Feb 14, 2023 at 9:50 AM HYVERNAT Philippe  wrote:

> In complement, we have many error like this :
>
> I follow recommendations from the list to solve this issue but never works.
>
>
>
>  sogod [89977]: <0x0x804808158[SOGoCache]> an error occurred when caching
> value for key '/Users/u...@mydomein.com/Calendar/personal': "SERVER HAS
> FAILED AND IS DISABLED UNTIL TIMED RETRY"
>

For starters, may I please request you to try and adhere to the following
guideline when communicating on mailing lists:
1. https://support.google.com/a/users/answer/9283192#better-conversations
I am mostly interested in replying inline and NOT top-posting. Thank you
very much.

Now, looking at your captured error, it would appear that you have a
problem with caching and that problem lies with memcached, because that is
where caching is done.
On FreeBSD which I believe you are familiar with, you can do one of two
things:
1. Log all queries to memcached. You do this by adding -vvv (the number of
v's depend on the verbosity you want) to memcached_flags in rc.conf and
restarting memcached.
I'd also try and give Memcached a little more RAM to use with -m 128
2. Capture these queries in it's own file by adding a specific logging
config to /etc/syslog.conf:

!memcached
*.* /var/log/memcached.log #please touch this file!
Then restart syslogd with: kill -HUP `cat /var/run/syslog.pid`

>From there, for every entry about caching in sogo.log, check for a
corresponding entry in memcached.log.
Hopefully, you will nail the problem by deducing a solution.

Sorry for the lecture. I just did not want to make assumptions that you
know what I wanted you to do :)

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

Re: [SOGo] Sogo Calendar events deleted

2023-02-13 Thread Odhiambo Washington 
On Mon, Feb 13, 2023 at 7:40 PM HYVERNAT Philippe  wrote:

> Thanks a lot for your answer :
>
> Here is my configuration. I add EAS options. Nothing was set
>
> The problem is that the issue is very difficult to make and users doesn't
> know when it really appear.
>
> I check the debug log for EAS and see
>

The Debug log for EAS and MySQL !
Those two must reveal something.

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

Re: [SOGo] Sogo Calendar events deleted

2023-02-13 Thread HYVERNAT Philippe 

In complement, we have many error like this :

I follow recommendations from the list to solve this issue but never works.


 sogod [89977]: <0x0x804808158[SOGoCache]> an error occurred when 
caching value for key '/Users/u...@mydomein.com/Calendar/personal': 
"SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"




Le 13/02/2023 à 17:37, HYVERNAT Philippe (p.hyver...@outlook.fr) a écrit :


Thanks a lot for your answer :

Here is my configuration. I add EAS options. Nothing was set

The problem is that the issue is very difficult to make and users 
doesn't know when it really appear.


I check the debug log for EAS and see


 /* Web Interface */
  SOGoPageTitle = SOGo;
  SOGoVacationEnabled = YES;
  SOGoForwardEnabled = YES;
  SOGoSieveScriptsEnabled = YES;
  SOGoMailAuxiliaryUserAccountsEnabled = YES;
  SOGoTrustProxyAuthentication = NO;
  SOGoXSRFValidationEnabled = NO;

  /* General - SOGoTimeZone *MUST* be defined */
  SOGoLanguage = French;
  SOGoTimeZone = Europe/Paris;
  SOGoCalendarDefaultRoles = (
    PublicDAndTViewer,
    ConfidentialDAndTViewer
  );
  //SOGoSuperUsernames = (sogo1, sogo2); // This is an array - keep 
the parens!

  SxVMemLimit = 384;
  WOPidFile = "/var/run/sogo/sogo.pid";
  SOGoMemcachedHost = "/var/run/memcached/memcahed.pid";

  WOWorkersCount = 80;
  SOGoMaximumPingInterval = 3540;
  SOGoMaximumSyncInterval = 3540;
  SOGoInternalSyncInterval = 30;

  /* EAS */
  SOGoMaximumSyncResponseSize = 512;
  SOGoMaximumSyncWindowSize = 30;
  SOGoEASDebugEnabled = YES;

  /* Debug */
  SOGoDebugRequests = YES;
  SoDebugBaseURL = YES;
  ImapDebugEnabled = YES;
  LDAPDebugEnabled = YES;
  PGDebugEnabled = YES;
  MySQL4DebugEnabled = YES;
  SOGoUIxDebugEnabled = YES;
  WODontZipResponse = YES;
  WOLogFile = /var/log/sogo/sogo.log;
}

Le 13/02/2023 à 16:24, Odhiambo Washington (odhia...@gmail.com) a écrit :



On Mon, Feb 13, 2023 at 5:44 PM HYVERNAT Philippe  wrote:

Hello community;

I'm trouble with a customer where i installed SOGO for a while.

The installation were on FreeBSD 13.1 with mysql 80.

My customer have 80 mails boxes and shared calendars between with
them
with Outlook 2021 and EAS.

The trouble is that events is deleted sometimes (it isn't deleted
from
users).

this problem appeared since Sogo 5.4 we are in version 5.8 now.


And were MySQL-8.x and Outlook 2021 present? No.
Did the problem happen with any other version of MySQL or Outlook 
prior to 2021?


No log on servers...


Did you say that you have set:
 SOGoEASDebugEnabled = YES;
..and nothing was logged??

my customer is very disappointed because it wants to migrate do
Exchange
if the problem doesn't resolve.


Thanks by advance for an answer.

Philippe


The fact that you are using MySQL means if you logged MySQL events, 
you'd catch  every

access and every change, no?

I would turn ON all debug and look for clues on the dates the 
deletions happen. Just ensure you have sane values for your environment.


     /* EAS */
    SOGoMaximumSyncResponseSize = 512;
    SOGoMaximumSyncWindowSize = 30;
    SOGoEASDebugEnabled = YES;

    /* Debug */
    //SOGoDebugRequests = YES;
    //SoDebugBaseURL = YES;
    //ImapDebugEnabled = YES;
    //LDAPDebugEnabled = YES;
    //PGDebugEnabled = YES;
    //MySQL4DebugEnabled = YES;
    //SOGoUIxDebugEnabled = YES;
    //WODontZipResponse = YES;
    //WOLogFile = /var/log/sogo/sogo.log;
    //GCSFolderDebugEnabled = YES;
    //GCSFolderStoreDebugEnabled = YES;
    //NGImap4DisableIMAP4Pooling = YES;
    //OCSFolderManagerSQLDebugEnabled = YES;
    //PGDebugEnabled = YES;
    //SOGoMailKeepDraftsAfterSend = YES;
    //SoDebugObjectTraversal = YES;
    //SoSecurityManagerDebugEnabled = YES;
    //WODebugZipResponse  = YES;



--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

Re: [SOGo] Sogo Calendar events deleted

2023-02-13 Thread HYVERNAT Philippe 

Thanks a lot for your answer :

Here is my configuration. I add EAS options. Nothing was set

The problem is that the issue is very difficult to make and users 
doesn't know when it really appear.


I check the debug log for EAS and see


 /* Web Interface */
  SOGoPageTitle = SOGo;
  SOGoVacationEnabled = YES;
  SOGoForwardEnabled = YES;
  SOGoSieveScriptsEnabled = YES;
  SOGoMailAuxiliaryUserAccountsEnabled = YES;
  SOGoTrustProxyAuthentication = NO;
  SOGoXSRFValidationEnabled = NO;

  /* General - SOGoTimeZone *MUST* be defined */
  SOGoLanguage = French;
  SOGoTimeZone = Europe/Paris;
  SOGoCalendarDefaultRoles = (
    PublicDAndTViewer,
    ConfidentialDAndTViewer
  );
  //SOGoSuperUsernames = (sogo1, sogo2); // This is an array - keep the 
parens!

  SxVMemLimit = 384;
  WOPidFile = "/var/run/sogo/sogo.pid";
  SOGoMemcachedHost = "/var/run/memcached/memcahed.pid";

  WOWorkersCount = 80;
  SOGoMaximumPingInterval = 3540;
  SOGoMaximumSyncInterval = 3540;
  SOGoInternalSyncInterval = 30;

  /* EAS */
  SOGoMaximumSyncResponseSize = 512;
  SOGoMaximumSyncWindowSize = 30;
  SOGoEASDebugEnabled = YES;

  /* Debug */
  SOGoDebugRequests = YES;
  SoDebugBaseURL = YES;
  ImapDebugEnabled = YES;
  LDAPDebugEnabled = YES;
  PGDebugEnabled = YES;
  MySQL4DebugEnabled = YES;
  SOGoUIxDebugEnabled = YES;
  WODontZipResponse = YES;
  WOLogFile = /var/log/sogo/sogo.log;
}

Le 13/02/2023 à 16:24, Odhiambo Washington (odhia...@gmail.com) a écrit :



On Mon, Feb 13, 2023 at 5:44 PM HYVERNAT Philippe  wrote:

Hello community;

I'm trouble with a customer where i installed SOGO for a while.

The installation were on FreeBSD 13.1 with mysql 80.

My customer have 80 mails boxes and shared calendars between with
them
with Outlook 2021 and EAS.

The trouble is that events is deleted sometimes (it isn't deleted
from
users).

this problem appeared since Sogo 5.4 we are in version 5.8 now.


And were MySQL-8.x and Outlook 2021 present? No.
Did the problem happen with any other version of MySQL or Outlook 
prior to 2021?


No log on servers...


Did you say that you have set:
 SOGoEASDebugEnabled = YES;
..and nothing was logged??

my customer is very disappointed because it wants to migrate do
Exchange
if the problem doesn't resolve.


Thanks by advance for an answer.

Philippe


The fact that you are using MySQL means if you logged MySQL events, 
you'd catch  every

access and every change, no?

I would turn ON all debug and look for clues on the dates the 
deletions happen. Just ensure you have sane values for your environment.


     /* EAS */
    SOGoMaximumSyncResponseSize = 512;
    SOGoMaximumSyncWindowSize = 30;
    SOGoEASDebugEnabled = YES;

    /* Debug */
    //SOGoDebugRequests = YES;
    //SoDebugBaseURL = YES;
    //ImapDebugEnabled = YES;
    //LDAPDebugEnabled = YES;
    //PGDebugEnabled = YES;
    //MySQL4DebugEnabled = YES;
    //SOGoUIxDebugEnabled = YES;
    //WODontZipResponse = YES;
    //WOLogFile = /var/log/sogo/sogo.log;
    //GCSFolderDebugEnabled = YES;
    //GCSFolderStoreDebugEnabled = YES;
    //NGImap4DisableIMAP4Pooling = YES;
    //OCSFolderManagerSQLDebugEnabled = YES;
    //PGDebugEnabled = YES;
    //SOGoMailKeepDraftsAfterSend = YES;
    //SoDebugObjectTraversal = YES;
    //SoSecurityManagerDebugEnabled = YES;
    //WODebugZipResponse  = YES;



--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

Re: [SOGo] Sogo Calendar events deleted

2023-02-13 Thread Odhiambo Washington 
On Mon, Feb 13, 2023 at 5:44 PM HYVERNAT Philippe  wrote:

> Hello community;
>
> I'm trouble with a customer where i installed SOGO for a while.
>
> The installation were on FreeBSD 13.1 with mysql 80.
>
> My customer have 80 mails boxes and shared calendars between with them
> with Outlook 2021 and EAS.
>
The trouble is that events is deleted sometimes (it isn't deleted from
> users).
>
> this problem appeared since Sogo 5.4 we are in version 5.8 now.
>

And were MySQL-8.x and Outlook 2021 present? No.

Did the problem happen with any other version of MySQL or Outlook prior to
2021?

No log on servers...
>

Did you say that you have set:
 SOGoEASDebugEnabled = YES;
..and nothing was logged??


my customer is very disappointed because it wants to migrate do Exchange
> if the problem doesn't resolve.
>
>
> Thanks by advance for an answer.
>
> Philippe
>

The fact that you are using MySQL means if you logged MySQL events, you'd
catch  every
access and every change, no?

I would turn ON all debug and look for clues on the dates the deletions
happen. Just ensure you have sane values for your environment.

 /* EAS */
SOGoMaximumSyncResponseSize = 512;
SOGoMaximumSyncWindowSize = 30;
SOGoEASDebugEnabled = YES;

/* Debug */
//SOGoDebugRequests = YES;
//SoDebugBaseURL = YES;
//ImapDebugEnabled = YES;
//LDAPDebugEnabled = YES;
//PGDebugEnabled = YES;
//MySQL4DebugEnabled = YES;
//SOGoUIxDebugEnabled = YES;
//WODontZipResponse = YES;
//WOLogFile = /var/log/sogo/sogo.log;
//GCSFolderDebugEnabled = YES;
//GCSFolderStoreDebugEnabled = YES;
//NGImap4DisableIMAP4Pooling = YES;
//OCSFolderManagerSQLDebugEnabled = YES;
//PGDebugEnabled = YES;
//SOGoMailKeepDraftsAfterSend = YES;
//SoDebugObjectTraversal = YES;
//SoSecurityManagerDebugEnabled = YES;
//WODebugZipResponse  = YES;



-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)

[SOGo] Sogo Calendar events deleted

2023-02-13 Thread HYVERNAT Philippe 

Hello community;

I'm trouble with a customer where i installed SOGO for a while.

The installation were on FreeBSD 13.1 with mysql 80.

My customer have 80 mails boxes and shared calendars between with them 
with Outlook 2021 and EAS.



The trouble is that events is deleted sometimes (it isn't deleted from 
users).


this problem appeared since Sogo 5.4 we are in version 5.8 now.

No log on servers...

my customer is very disappointed because it wants to migrate do Exchange 
if the problem doesn't resolve.



Thanks by advance for an answer.

Philippe