[SOGo] BTS activities for Monday, July 18 2022

2022-07-18 Thread SOGo reporter 
Title: BTS activities for Monday, July 18 2022





  
BTS Activities

  Home page: https://sogo.nu/bugs
  Project: SOGo
  For the period covering: Monday, July 18 2022

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
1205
	2022-07-18 10:42:27
	updated (open)
	Backend Address Book
	update the vcard handling to VCARD 4 spec
	
	  
	
5530
	2022-07-18 10:42:53
	updated (open)
	Backend Address Book
	Unable to create mailing list in Thunderbird 91 + Connector 78
	
	  
	
5562
	2022-07-18 09:39:59
	updated (open)
	Web Calendar
	calendar search filter 'Selected Day' does not work at all (it shows always 'Today')
	
	  
	
5559
	2022-07-18 08:07:53
	updated (open)
	Web Mail
	Advanced search in subfolder does not open email
	
	  
	
5560
	2022-07-18 05:42:10
	updated (open)
	Web Mail
	Error when forwarding a larger email than set by SOGoMaximumMessageSizeLimit
	
	  
	
5561
	2022-07-18 05:58:09
	updated (open)
	Web Preferences
	regex sieve script comparisons should be case sensitive
	
	  
	
4980
	2022-07-18 04:54:11
	assigned (reopened)
	Web Mail
	Mails in subfolders of "Sent" are displayed with sender instead of recipient
	
	  
	
  
  


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

Re: [SOGo] Wrong time in WEB SOGo (5.5.1)

2022-07-18 Thread Emmanuel Dreyfus 
On Mon, Jul 18, 2022 at 07:34:57PM +, "? ???" wrote:
> Here is the command output
> [root@SRV-MAIL ~]# file /usr/share/zoneinfo/Europe/Moscow 
> /usr/share/zoneinfo/Europe/Moscow: timezone data [root@SRV-MAIL ~]#
> How to understand what version it is?     v2  ?

Your file(1) is not smart enough. Try 
hexdump -C /usr/share/zoneinfo/Europe/Moscow | head
v1 format start by TZif or just a bunch of nul bytes
v2 format start by TZif2


-- 
Emmanuel Dreyfus
m...@netbsd.org
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

RE: [SOGo] Wrong time in WEB SOGo (5.5.1)

2022-07-18 Thread Тарас Гуденко 
Hello.
Thanks for the answer
Here is the command output
[root@SRV-MAIL ~]# file /usr/share/zoneinfo/Europe/Moscow 
/usr/share/zoneinfo/Europe/Moscow: timezone data [root@SRV-MAIL ~]#
How to understand what version it is?     v2  ?
Best regards, Taras.
18.07.2022, 16:30, < mailto:users@sogo.nu users@sogo.nu >
On Thu, Jun 30, 2022 at 11:23:46AM +0300, /compose/ gtg2...@rambler.ru wrote: > 
The list of sent and received emails in the web interface shows the wrong > 
time (UTC), should be (UTC+3) What version is your timezone file? file(1) can 
tell: $ file /usr/share/zoneinfo/Europe/Moscow 
/usr/share/zoneinfo/Europe/Moscow: timezone data, version 2, no gmt time flags, 
no std time flags, no leap seconds, no transition times, 1 abbreviation char 
gnustep-base did not support v2+. I contributed the code for that and it was 
accepted, but there has not been any release wth it yet. If you are hit by the 
problm, a workaround can be to remplace your timezone file by a v1 copy from an 
earlier OS release. That will not fix events that have been inserted from the 
web interface with the v2 file: the wrong data is in database now. -- Emmanuel 
Dreyfus /compose/ m...@netbsd.org -- /compose/ users@sogo.nu 
https://inverse.ca/sogo/lists https://inverse.ca/sogo/lists
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

RE: [SOGo] Wrong time in WEB SOGo (5.5.1)

2022-07-18 Thread Тарас Гуденко 
Hello,
Attached a screenshot of the user settings
Best regards, Taras.
18.07.2022, 16:12, < mailto:users@sogo.nu users@sogo.nu >
Hello Am 17.07.22 um 10:04 schrieb /compose/ gtg2...@rambler.ru: > Hello, > 
Where you need to check Settings --> General --> Timezone, system or SOGo ? 
That one is in the webinterface of SOGo, while logged in as the User with that 
problem. > > Settings SOGo: > SOGoTimeZone = Europe/Moscow; > That is the 
standard set Timezone in sogo.conf. > System : > # date > Вс 17 июл 2022 
10:53:14 MSK > > #timedatectl > Local time: Вс 2022-07-17 
10:53:56 MSK > Universal time: Вс 2022-07-17 07:53:56 UTC > 
    RTC time: Вс 2022-07-17 07:53:56 > Time zone: 
Europe/Moscow (MSK, +0300) > System clock synchronized: yes >
NTP service: active >RTC in local TZ: yes > > I also noticed that 
in sogo.log also shows the wrong time. > > Best regards, Taras. > What does 
locale show you for sogo user? Kind regards, Christian Mack > -Original 
Message- > From: /compose/ users-requ...@sogo.nu < /compose/ 
users-requ...@sogo.nu > On Behalf Of Christian Mack > Sent: Thursday, July 14, 
2022 2:09 PM > To: /compose/ users@sogo.nu > Subject: Re: [SOGo] Wrong time in 
WEB SOGo (5.5.1) > > Hello > > Which timezone has the user set in Preferences 
--> General --> Time Zone ? > > > Kind regards, > Christian Mack > > Am 
30.06.22 um 10:23 schrieb /compose/ gtg2...@rambler.ru: >> Hello >> >> The list 
of sent and received emails in the web interface shows the wrong >> time (UTC), 
should be (UTC+3) >> >> The calendar SOGo shows correct time (UTC+3), in 
Thunderbird, the time of >> letters and calendar shows correctly too >> >> >> 
>> installation >> >> ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql 
>> >> >> >> Settings: >> >> SOGo.conf : SOGoTimeZone = 
Europe/Moscow; >> >> ls -l /etc/localtime /etc/localtime -> >> 
/usr/share/zoneinfo/Europe/Moscow >> >> >> >> Please write where I could miss 
the settings or why SOGo shows the wrong >> time (UTC) >> >> >> >> Best 
regards, Taras >> > > -- Christian Mack Universität Konstanz Kommunikations-, 
Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung und Lehre 
78457 Konstanz +49 7531 88-4416
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] CardDAV Sync List/Group Thunderbird Cardbook

2022-07-18 Thread Christian Mack 

Hello

That is correct.
There is a open enhancement request bug for that in the bugtracker for 
quite some time.


In short:
vCard version 4.0 has to be implemented in SOGo for that.
Address lists weren't a thing before that, therefore SOGo invented it's 
own implementation.

That obviously isn't compatible to anything else.


Kind regards,
Christian Mack

Am 16.07.22 um 12:22 schrieb g...@sico.at:

I have the following problem.

We use Lists in the adressbook. The sync with thunderbird cardbook works 
fine for the contacts.


But the lists are not correct synced:

If I create a list in SOGo webmailer, the code looks like:

BEGIN:VLIST
UID:60-62D29000-3-7FC63F00.vcf
VERSION:1.0
CARD;EMAIL=mai...@sogotest.com;FN=SG1:cab15b64-78d9-d347-a2e4-16864c041070.
  vcf
CARD;EMAIL=mai...@sogotest.com;FN=SG2:88a2ab28-d11d-024b-b487-611ced7dde0b.
  vcf
CARD;EMAIL=mai...@sogotest.com;FN=SG3:36b60e97-14a2-6041-adb3-b7bf1e6faba9.
  vcf
FN:TestListSOGo
END:VLIST

If I create a list in CardBook, the code looks like:

BEGIN:VCARD
VERSION:3.0
PRODID:-//Thunderbird.net/NONSGML Thunderbird CardBook V76.3//DE
UID:f652509f-80cb-8644-b2d4-b45d7e768952
FN:TestListCardbook
REV:2022-07-16T10:13:27Z
X-ADDRESSBOOKSERVER-KIND:group
X-ADDRESSBOOKSERVER-MEMBER:mailto:ma...@cardbook.com
X-ADDRESSBOOKSERVER-MEMBER:mailto:ma...@cardbook.com
X-ADDRESSBOOKSERVER-MEMBER:mailto:ma...@cardbook.com
END:VCARD

Conclusion:

The created lists in Thunderbird Cardbook are shown in the SOGo 
Webmailer as "contact" not as list and don´t work there.


The created lists in SOGo Webmailer are not shown in Thunderbird 
Cardbook at all.



Thx for your help.



--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416


smime.p7s
Description: S/MIME Cryptographic Signature

AW: [SOGo] - Error memcached

2022-07-18 Thread "Peter Nagel" 
Hi,

this is only one half of the necessary steps: have you changed the bind-address 
in your mysqld.cnf from

  bind-address=127.0.0.1

to

  bind-address=0.0.0.0

to allow external connections? You can try to connect locally via the ip of the 
server instead of localhost to test this.

Ah, and if you are using iptables on the database server (which you really 
should) check this too.

Bye, Peter

 

Von: users-requ...@sogo.nu  Im Auftrag von HYVERNAT 
Philippe
Gesendet: Montag, 18. Juli 2022 13:23
An: users@sogo.nu
Betreff: Re: [SOGo] - Error memcached

 

Hi,

The user sogo have access from his serveur 

 

root@localhost [(none)]> select User, host from mysql.user;

+--+--+

| User | host |

+--+--+

| sogo | 172.17.2.223 |

 

 

 

Le 15/07/2022 à 13:51, "Peter Nagel" (pe...@nagel-coe.de 
 ) a écrit :

Hi,
 

  OCSCacheFolderURL =
  
"mysql://sogo:@172.17.2.224:3306/sogo/sogo_cache_folder";

 
you are not using localhost for your SQL Connection: is the database really on 
a different machine? If not: is it set to accept connections from any other IP 
than localhost?
 
Bye, Peter
 

-Ursprüngliche Nachricht-
Von: users-requ...@sogo.nu    
  Im Auftrag von
HYVERNAT Philippe
Gesendet: Freitag, 15. Juli 2022 09:18
An: users@sogo.nu  
Betreff: Re: [SOGo] - Error memcached
 
Hello,
 
It is exactly what i have done :
 
SOGoMemcachedHost = "/var/run/memcached/memcached.pid";
 
 
Always the error on caching values...
 
 
 
Le 14/07/2022 à 13:14, Christian Mack (christian.m...@uni-konstanz.de 
 ) a
écrit :

Hello
 
Am 06.07.22 um 10:30 schrieb HYVERNAT Philippe

(p.hyver...@outlook.fr  ):

Hello,
 
we have many errors concerning caching value :
 
 
sogod [60246]: <0x0x8046cbc18[SOGoCache]> an error occurred when
caching value for key
'/Users/kagerv...@ehpad-avs.fr/Calendar/personal': "SERVER HAS FAILED
AND IS DISABLED UNTIL TIMED RETRY"
 
What is it ?
 
Here's the configuration :
 
 
  OCSCacheFolderURL =
  
"mysql://sogo:@172.17.2.224:3306/sogo/sogo_cache_folder";
 
  SOGoMemcachedHost = "/var/run/memcached/memcahed.pid"; (i tried to
put Ip Address but white page)
 

[cut]
There is a typo in SOGoMemcachedHost
Should be
SOGoMemcachedHost = "/var/run/memcached/memcached.pid";
 
 
Kind regards,
Christian Mack
 

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

 

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

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

Re: [SOGo] Wrong time in WEB SOGo (5.5.1)

2022-07-18 Thread Emmanuel Dreyfus 
On Thu, Jun 30, 2022 at 11:23:46AM +0300, gtg2...@rambler.ru wrote:
> The list of sent and received emails in the web interface shows the wrong
> time (UTC), should be (UTC+3)

What version is your timezone file? file(1) can tell:
$ file /usr/share/zoneinfo/Europe/Moscow   
/usr/share/zoneinfo/Europe/Moscow: timezone data, version 2, no gmt time flags, 
no std time flags, no leap seconds, no transition times, 1 abbreviation char

gnustep-base did not support v2+. I contributed the code for that and it was
accepted, but there has not been any release wth it yet. If you are hit
by the problm, a workaround can be to remplace your timezone file by
a v1 copy from an earlier OS release. That will not fix events that
have been inserted from the web interface with the v2 file: the wrong
data is in database now.


-- 
Emmanuel Dreyfus
m...@netbsd.org
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Wrong time in WEB SOGo (5.5.1)

2022-07-18 Thread Christian Mack 

Hello

Am 17.07.22 um 10:04 schrieb gtg2...@rambler.ru:

Hello,
Where you need to check Settings --> General --> Timezone,   system or SOGo ?


That one is in the webinterface of SOGo, while logged in as the User 
with that problem.




Settings SOGo:
SOGoTimeZone = Europe/Moscow;



That is the standard set Timezone in sogo.conf.


System :
# date
Вс 17 июл 2022 10:53:14 MSK

#timedatectl
Local time: Вс 2022-07-17 10:53:56 MSK
Universal time: Вс 2022-07-17 07:53:56 UTC
  RTC time: Вс 2022-07-17 07:53:56
 Time zone: Europe/Moscow (MSK, +0300)
System clock synchronized: yes
   NTP service: active
   RTC in local TZ: yes

I also noticed that in sogo.log also shows the wrong time.

Best regards, Taras.



What does locale show you for sogo user?


Kind regards,
Christian Mack


-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Christian Mack
Sent: Thursday, July 14, 2022 2:09 PM
To: users@sogo.nu
Subject: Re: [SOGo] Wrong time in WEB SOGo (5.5.1)

Hello

Which timezone has the user set in Preferences --> General --> Time Zone ?


Kind regards,
Christian Mack

Am 30.06.22 um 10:23 schrieb gtg2...@rambler.ru:

Hello

The list of sent and received emails in the web interface shows the wrong
time (UTC), should be (UTC+3)

The calendar SOGo shows correct time (UTC+3), in Thunderbird, the time of
letters and calendar shows correctly too

   


installation

ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql

   


Settings:

SOGo.conf :  SOGoTimeZone = Europe/Moscow;

ls -l /etc/localtime  /etc/localtime ->
/usr/share/zoneinfo/Europe/Moscow

   


Please write where I could miss the settings or why SOGo shows the wrong
time (UTC)

   


Best regards, Taras







--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416


smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] - Error memcached

2022-07-18 Thread HYVERNAT Philippe 

Hi,

The user sogo have access from his serveur


root@localhost [(none)]> select User, host from mysql.user;

+--+--+

| User| host|

+--+--+

| sogo| 172.17.2.223 |




Le 15/07/2022 à 13:51, "Peter Nagel" (pe...@nagel-coe.de) a écrit :

Hi,


   OCSCacheFolderURL =
"mysql://sogo:@172.17.2.224:3306/sogo/sogo_cache_folder";

you are not using localhost for your SQL Connection: is the database really on 
a different machine? If not: is it set to accept connections from any other IP 
than localhost?

Bye, Peter


-Ursprüngliche Nachricht-
Von:users-requ...@sogo.nuIm Auftrag von
HYVERNAT Philippe
Gesendet: Freitag, 15. Juli 2022 09:18
An:users@sogo.nu
Betreff: Re: [SOGo] - Error memcached

Hello,

It is exactly what i have done :

SOGoMemcachedHost = "/var/run/memcached/memcached.pid";


Always the error on caching values...



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

Hello

Am 06.07.22 um 10:30 schrieb HYVERNAT Philippe

(p.hyver...@outlook.fr):

Hello,

we have many errors concerning caching value :


sogod [60246]: <0x0x8046cbc18[SOGoCache]> an error occurred when
caching value for key
'/Users/kagerv...@ehpad-avs.fr/Calendar/personal': "SERVER HAS FAILED
AND IS DISABLED UNTIL TIMED RETRY"

What is it ?

Here's the configuration :


   OCSCacheFolderURL =
"mysql://sogo:@172.17.2.224:3306/sogo/sogo_cache_folder";

   SOGoMemcachedHost = "/var/run/memcached/memcahed.pid"; (i tried to
put Ip Address but white page)


[cut]
There is a typo in SOGoMemcachedHost
Should be
SOGoMemcachedHost = "/var/run/memcached/memcached.pid";


Kind regards,
Christian Mack


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

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

RE: [SOGo] Wrong time in WEB SOGo (5.5.1)

2022-07-18 Thread gtg2...@rambler.ru 
Hello,
Where you need to check Settings --> General --> Timezone,   system or SOGo ?

Settings SOGo:
SOGoTimeZone = Europe/Moscow;

System :
# date
Вс 17 июл 2022 10:53:14 MSK

#timedatectl
   Local time: Вс 2022-07-17 10:53:56 MSK
   Universal time: Вс 2022-07-17 07:53:56 UTC
 RTC time: Вс 2022-07-17 07:53:56
Time zone: Europe/Moscow (MSK, +0300)
System clock synchronized: yes
  NTP service: active
  RTC in local TZ: yes

I also noticed that in sogo.log also shows the wrong time.

Best regards, Taras.


-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Christian Mack
Sent: Thursday, July 14, 2022 2:09 PM
To: users@sogo.nu
Subject: Re: [SOGo] Wrong time in WEB SOGo (5.5.1)

Hello

Which timezone has the user set in Preferences --> General --> Time Zone ?


Kind regards,
Christian Mack

Am 30.06.22 um 10:23 schrieb gtg2...@rambler.ru:
> Hello
> 
> The list of sent and received emails in the web interface shows the wrong
> time (UTC), should be (UTC+3)
> 
> The calendar SOGo shows correct time (UTC+3), in Thunderbird, the time of
> letters and calendar shows correctly too
> 
>   
> 
> installation
> 
> ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql
> 
>   
> 
> Settings:
> 
> SOGo.conf :  SOGoTimeZone = Europe/Moscow;
> 
> ls -l /etc/localtime  /etc/localtime ->
> /usr/share/zoneinfo/Europe/Moscow
> 
>   
> 
> Please write where I could miss the settings or why SOGo shows the wrong
> time (UTC)
> 
>   
> 
> Best regards, Taras
> 


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] CardDAV Sync List/Group Thunderbird Cardbook

2022-07-18 Thread g...@sico.at 

I have the following problem.

We use Lists in the adressbook. The sync with thunderbird cardbook works 
fine for the contacts.


But the lists are not correct synced:

If I create a list in SOGo webmailer, the code looks like:

BEGIN:VLIST
UID:60-62D29000-3-7FC63F00.vcf
VERSION:1.0
CARD;EMAIL=mai...@sogotest.com;FN=SG1:cab15b64-78d9-d347-a2e4-16864c041070.
 vcf
CARD;EMAIL=mai...@sogotest.com;FN=SG2:88a2ab28-d11d-024b-b487-611ced7dde0b.
 vcf
CARD;EMAIL=mai...@sogotest.com;FN=SG3:36b60e97-14a2-6041-adb3-b7bf1e6faba9.
 vcf
FN:TestListSOGo
END:VLIST

If I create a list in CardBook, the code looks like:

BEGIN:VCARD
VERSION:3.0
PRODID:-//Thunderbird.net/NONSGML Thunderbird CardBook V76.3//DE
UID:f652509f-80cb-8644-b2d4-b45d7e768952
FN:TestListCardbook
REV:2022-07-16T10:13:27Z
X-ADDRESSBOOKSERVER-KIND:group
X-ADDRESSBOOKSERVER-MEMBER:mailto:ma...@cardbook.com
X-ADDRESSBOOKSERVER-MEMBER:mailto:ma...@cardbook.com
X-ADDRESSBOOKSERVER-MEMBER:mailto:ma...@cardbook.com
END:VCARD

Conclusion:

The created lists in Thunderbird Cardbook are shown in the SOGo 
Webmailer as "contact" not as list and don´t work there.


The created lists in SOGo Webmailer are not shown in Thunderbird 
Cardbook at all.



Thx for your help.
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] MailList as group ?

2022-07-18 Thread Christian Mack 

Hello

Am 14.07.22 um 13:26 schrieb Zhang Huangbin (z...@iredmail.org):




On Jul 14, 2022, at 7:23 PM, Christian Mack (christian.m...@uni-konstanz.de) 
 wrote:

Mailinglists are not part of SOGo.
Therefore you have to ask on iRedMail Forums where those Groups (or address 
lists) where coming from.
Perhaps they included another SOGoUserSources entry with those?


Hi Christian,

I think the problem in this case is why it worked before, but not after 
upgraded SOGo to the latest release.
No LDAP schema / data changes applied to mailing list accounts during iRedMail 
upgrade, hence SOGo should work too.



Have you set the following option?
SOGoLDAPGroupExpansionEnabled = YES;


Kind regards,
Christian Mack

--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416


smime.p7s
Description: S/MIME Cryptographic Signature