[SOGo] BTS activities for Thursday, January 20 2022

2022-01-20 Thread SOGo reporter 
Title: BTS activities for Thursday, January 20 2022





  
BTS Activities

  Home page: https://sogo.nu/bugs
  Project: SOGo
  For the period covering: Thursday, January 20 2022

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5463
	2022-01-20 07:41:10
	updated (open)
	Backend Calendar
	Carddav Server Response is not UTF8 complient
	
	  
	
5466
	2022-01-20 16:22:50
	updated (open)
	Web Mail
	Issue moving to Junk multiply emails
	
	  
	
5462
	2022-01-20 17:10:46
	resolved (fixed)
	Backend Address Book
	Entity tag missing in CardDAV global address book REPORT
	
	  
	
  
  


-- users@sogo.nuhttps://inverse.ca/sogo/lists

[SOGo] sogod won't start: sogod[7803:7803] unable to get status of descriptor 2 - Bad file descriptor

2022-01-20 Thread FF 
I've verified that /var/run/sogo/sogo.pid is writable by user sogo.
I've verified /var/log/sogo/sogo.log is permissioned for syslog.

I get no entries in sogo.log and systemctl says sogod starts and exits
clearly.

Don't know what file its looking for so I can't figure out how to fix it.
I've tried upgrading the package which worked, but didn't fix the
underlying issue. It must be super easy and obvious, but i don't know what
to look at.

It was working until about 24 hours ago and no system level changes were
made since then. the last entries in the log were watchdog errors about
processes:

Jan 18 03:04:51 sogod [1884]: [WARN] <0x0x557d83e4c8b0[WOWatchDogChild]>
pid 2326435 has been hanging in the same request for 2 minutes
Jan 18 03:04:53 sogod [2326435]:
<0x0x557d8445ba70[SOGoActiveSyncDispatcher]> Sleeping 30 seconds while
detecting changes for user dee...@fifty50official.com in Ping...
Jan 18 03:05:23 sogod [2326435]:
<0x0x557d8445ba70[SOGoActiveSyncDispatcher]> Sleeping 30 seconds while
detecting changes for user dee...@fifty50official.com in Ping...
Jan 18 03:05:51 sogod [1884]: [WARN] <0x0x557d83e4c8b0[WOWatchDogChild]>
pid 2326435 has been hanging iroot@truncheon:/var/log/sogo

which I don't think are particularly serious, but I don't know.

Thanks in advance!

-- 
FF
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Email reminders

2022-01-20 Thread "Christian M. Jensen" 

Hi,

Good to hear it's working. I think, not sure, that reminders are put 
directly to IMAP for that user from SOGo no SMTP.


But vacation I believe relies on sieve scripts.

Regards
Christian Jensen

Den 19-01-2022 kl. 19:09 skrev HYVERNAT Philippe (p.hyver...@outlook.fr):


Hi,

so,

i edited the file in FreeBSD /etc/crontab and put sogod user to 
execute the commands not use crontab -e


I restart sogo and no error on the log file : it is ok  but there is a 
thing i see is sogo don't send anything to my smtp server.



i see all my mail received but no reply for vacation ...


Any hints ?



Le 16/01/2022 à 10:53, "Christian M. Jensen" (c...@cjpg.dk) a écrit :


Hi,

I think what you need is a Dovecot master user, I never had to set 
credentials for reminders, but for vacation. It's a simple change to 
Dovecot configuration (also simple to revert).


It may be as simple, as setting permission for the 'creds' file so 
that sogo can read it.


Any way, they both have the /'//-p//' /configure flag, hence my 
suggestion.


https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_cronjob_email_reminders

    - / specify a credential file using -p /path/to/credFile. 
 separated by a colon (username:plain-text-password)/


And to configure master user(s) follow the official documentation I 
think its straight forward.


https://doc.dovecot.org/configuration_manual/authentication/master_users/#master-users, 


https://doc.dovecot.org/configuration_manual/authentication/master_users/#acls

_Do not forget to lock the file with proper permissions._

    - -r 1 sogo sogo 65 Aug  1 13:02 /etc/sogo/mailAlarms.cred

That is my suggestion.

Regards
Christian Jensen.


Den 14-01-2022 kl. 22:25 skrev HYVERNAT Philippe (p.hyver...@outlook.fr):

Hello,

Thanks for your answer, I understand.


That is a way to specify this account ?

Is it eventually an issue of permission on the file ?

I try several account ...


Le 14/01/2022 à 11:44, Christian Mack 
(christian.m...@uni-konstanz.de) a écrit :

Hello

Perhaps I wasn't clear enough.

In /etc/sogo/mailAlarms.creds you need credentials for an account
capable to send emails in the name of every other user on your SOGo 
server.

Not sure your account can do that.

It is some time back since I set this up, but not having
/etc/sogo/mailAlarms.creds altogether, did trigger a "not configured"
error back then.


Kind regards,
Christian Mack

Am 13.01.22 um 14:57 schrieb hyvernat philippe 
(p.hyver...@outlook.fr):

Hello,
Yes postfix is couples with dovecot and an ldap server i put 
credentials and pas of my account


The error doesn’t say bas credential but not configured…
Thanks for your answer

HYVERNAT Philippe


Le 13 janv. 2022 à 13:31, Christian Mack  a écrit :

Hello

Are the crendials in /etc/sogo/mailAlarms.creds valid for sending 
via

SMTP server?


Kind regards,
Christian Mack


On 11.01.22 18:00, HYVERNAT Philippe (p.hyver...@outlook.fr) wrote:
lol

of course even the server



Le 11/01/2022 à 17:11, Christian Mack 
(christian.m...@uni-konstanz.de) a

écrit :
Hello

Did you restart SOGo after changing sogo.conf?


Kind regards,
Christian Mack

Am 11.01.22 um 09:31 schrieb HYVERNAT Philippe 
(p.hyver...@outlook.fr):

Hello,

i setup the cronjob email reminders and i configure sogo.conf to
enable it

|
|

|
|

OCSEMailAlarmsFolderURL =
"mysql://user:@172.30.20.151:3306/sogo/sogo_alarms_folder";


*|SOGoEnableEMailAlarms = YES;|*

|
|

|every minute, the log file 
(/var/log/sogo/cron-ealarms-notify.log)

|

|I have this error :
|

|
|

|2022-01-11 08:29:00.234 sogo-ealarms-notify[84802:100568] 
*EMail alarms

are disabled in the SOGo configuration.*|

|
|

|Do you have any hints ? i am really stuck on this.|

|Thanks a lot|

|HYVERNAT Philippe
|

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] PostgreSQL Idle connections from

2022-01-20 Thread sogo-us...@list-post.ddt-consult.de 

Hi,

this will probably not come as a surprise: I'm still seeing the problem 
with the exhaustion of DB connections on SOGo 5.5.0.


In the meantime I've migrated the DB to the combined 9-table-layout. 
Makes no difference either.


Do you need additional logs?
As Cédric already asked: Should we file a bug?
Could you please comment on this issue?

Regards
  mks


19.12.21, 15:21 +0100 Markus Schönhaber:


26.11.21, 17:48 +0100: Francis Lachapelle (flachape...@inverse.ca):

The same happens to me with SOGo 5.3.0 and 5.4.0. Going back to 5.2.0
makes the problem disappear.
I see this on a very small SOGo setup with 4 users and 2-3 devices each
syncing via CalDAV/CardDAV. It takes roughly a day till all DB
connections are in use (max_connections of PostgreSQL is set to 100).

If you still need debug logs, I can provide some.

Regards
mks


Cédric

I need the debugging entries during a busy period, until you reach the maximum 
number of connections of your PostgreSQL server. I'm looking at entries such as:

   - DBPOOL: create new DB channel
   - DBPOOL: keeping channel
   - DBPOOL: garbage collecting

Thanks,

Francis


On Nov 26, 2021, at 10:43, Cédric Archambeau  wrote:

Without postgre debug, tell me if you want it :

Nov 26 16:26:54 sogod [68388]: 185.215.13.175 "REPORT 
/SOGo/dav/user.n...@domain.tld/Contacts/pg_addressbook_name/ HTTP/1.1" 207 1517/4915 
0.064 27386 94% 0 - 16
Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: 
reused cached DB channel! (0x55bde58f5ad0)
Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: keeping 
channel (age 125s, #2, 0x55bde598c160) : <0x0x55bde58f5ad0[PostgreSQL72Channel]: 
connection=<0x0x55bde59b8090[PGConnection]:  connection=0x0x55bde59b8250>>
Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: 
reused cached DB channel! (0x55bde60e3d80)
Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: keeping 
channel (age 41s, #2, 0x55bde5aa1eb0) : <0x0x55bde60e3d80[PostgreSQL72Channel]: 
connection=<0x0x55bde5f93910[PGConnection]:  connection=0x0x55bde5b7e560>>
Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: cannot use 
handle (postgresql://dbuser:dbpass@localhost:5432/dbname/table_pg_addressbook 
 
vspostgresql://dbuser:dbpass@localhost:5432/sogo/sogocontacts0012926777a 
)
Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: cannot use 
handle (postgresql://dbuser:dbpass@localhost:5432/dbname/table_pg_addressbook 
 
vspostgresql://dbuser:dbpass@localhost:5432/sogo/sogo_sessions_folder 
)
Nov 26 16:26:54 sogod [68388]: <0x0x55bde5374dc0[GCSChannelManager]> DBPOOL: create 
new DB channel for postgresql://localhost/dbname/table_pg_addressbook 


HTH

Cédric Archambeau
Le 26/11/2021 à 15:45, Francis Lachapelle (flachape...@inverse.ca 
) a écrit :

Hi Cédric


On Nov 26, 2021, at 06:29, Cédric Archambeau  
 wrote:

We have a problem with Postgresql connections from SOGo 5.3.0 since few days 
(last update monday 22 - community version).
Or we had it before but didn't see it ;-)

Connections stay idle, mainly with an adressbook (PostgreSQL view with right 
columns) query from Thunderbird dav (with sogo-connector).

We're using ubuntu server 20.04 (PostgreSQL 12.9 - no pooler), everything up to 
date. We configured idle_in_transaction_session_timeout='5min' as workaround, 
the job is done for most of connections, but not on dav queries (maybe because 
of the client response?). These dav connections stay, and new ones are created 
every 30 min. With few clients we reached tuesday the default max amount of 
connections for Postgresql (100). Never happened in five years of happy use ;-)

With [PGDebugEnabled = YES;], no special observation, queries seem to be fine.

Restarting SOGo is the only way to clean up everything.

Can you enable GCSChannelManagerPoolDebugEnabled and share the log entries?

Thanks,

Francis



--
users@sogo.nu
https://inverse.ca/sogo/lists






--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Email reminders

2022-01-20 Thread Christian Mack 
Hello

Alarms and Vacation are different.
Alarms are send from the SOGo server, when the event is due.
But Vacations are send from the dovecot server, specifically from the
sieve module in it when an email arrives.
SOGo only sets the sieve rule per managesieve on activation of the
vacation, and removes it after deactivation.
Therefore you have to look at your dovecot logs, in order to find
vacation replys.


Kind regards,
Christian Mack

Am 19.01.22 um 19:09 schrieb HYVERNAT Philippe (p.hyver...@outlook.fr):
> Hi,
> 
> so,
> 
> i edited the file in FreeBSD /etc/crontab and put sogod user to execute
> the commands not use crontab -e
> 
> I restart sogo and no error on the log file : it is ok  but there is a
> thing i see is sogo don't send anything to my smtp server.
> 
> 
> i see all my mail received but no reply for vacation ...
> 
> 
> Any hints ?
> 
> 
> 
> Le 16/01/2022 à 10:53, "Christian M. Jensen" (c...@cjpg.dk) a écrit :
>>
>> Hi,
>>
>> I think what you need is a Dovecot master user, I never had to set
>> credentials for reminders, but for vacation. It's a simple change to
>> Dovecot configuration (also simple to revert).
>>
>> It may be as simple, as setting permission for the 'creds' file so
>> that sogo can read it.
>>
>> Any way, they both have the /'//-p//' /configure flag, hence my
>> suggestion.
>>
>> https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_cronjob_email_reminders
>>
>>
>>     - / specify a credential file using -p /path/to/credFile. 
>> separated by a colon (username:plain-text-password)/
>>
>> And to configure master user(s) follow the official documentation I
>> think its straight forward.
>>
>> https://doc.dovecot.org/configuration_manual/authentication/master_users/#master-users,
>>
>> https://doc.dovecot.org/configuration_manual/authentication/master_users/#acls
>>
>>
>> _Do not forget to lock the file with proper permissions._
>>
>>     - -r 1 sogo sogo 65 Aug  1 13:02 /etc/sogo/mailAlarms.cred
>>
>> That is my suggestion.
>>
>> Regards
>> Christian Jensen.
>>
>>
>> Den 14-01-2022 kl. 22:25 skrev HYVERNAT Philippe (p.hyver...@outlook.fr):
>>> Hello,
>>>
>>> Thanks for your answer, I understand.
>>>
>>>
>>> That is a way to specify this account ?
>>>
>>> Is it eventually an issue of permission on the file ?
>>>
>>> I try several account ...
>>>
>>>
>>> Le 14/01/2022 à 11:44, Christian Mack
>>> (christian.m...@uni-konstanz.de) a écrit :
 Hello

 Perhaps I wasn't clear enough.

 In /etc/sogo/mailAlarms.creds you need credentials for an account
 capable to send emails in the name of every other user on your SOGo
 server.
 Not sure your account can do that.

 It is some time back since I set this up, but not having
 /etc/sogo/mailAlarms.creds altogether, did trigger a "not configured"
 error back then.


 Kind regards,
 Christian Mack

 Am 13.01.22 um 14:57 schrieb hyvernat philippe (p.hyver...@outlook.fr):
> Hello,
> Yes postfix is couples with dovecot and an ldap server i put
> credentials and pas of my account
>
> The error doesn’t say bas credential but not configured…
> Thanks for your answer
>
> HYVERNAT Philippe
>
>> Le 13 janv. 2022 à 13:31, Christian Mack  a écrit :
>>
>> Hello
>>
>> Are the crendials in /etc/sogo/mailAlarms.creds valid for sending via
>> SMTP server?
>>
>>
>> Kind regards,
>> Christian Mack
>>
>>> On 11.01.22 18:00, HYVERNAT Philippe (p.hyver...@outlook.fr) wrote:
>>> lol
>>>
>>> of course even the server
>>>
>>>
>>>
 Le 11/01/2022 à 17:11, Christian Mack
 (christian.m...@uni-konstanz.de) a
 écrit :
 Hello

 Did you restart SOGo after changing sogo.conf?


 Kind regards,
 Christian Mack

 Am 11.01.22 um 09:31 schrieb HYVERNAT Philippe
 (p.hyver...@outlook.fr):
> Hello,
>
> i setup the cronjob email reminders and i configure sogo.conf to
> enable it
>
> |
> |
>
> |
> |
>
> OCSEMailAlarmsFolderURL =
> "mysql://user:@172.30.20.151:3306/sogo/sogo_alarms_folder";
> 
>
> *|SOGoEnableEMailAlarms = YES;|*
>
> |
> |
>
> |every minute, the log file
> (/var/log/sogo/cron-ealarms-notify.log)
> |
>
> |I have this error :
> |
>
> |
> |
>
> |2022-01-11 08:29:00.234 sogo-ealarms-notify[84802:100568]
> *EMail alarms
> are disabled in the SOGo configuration.*|
>
> |
> |
>
> |Do you have any hints ? i am really stuck on this.|
>
> |Thanks a lot|
>
> |HYVERNAT Philippe
> |
>> -- 
>> Hilsen / Regards
>> Christian M. Jensen