RE: [SOGo] download production version

[qhivert]

Hello,
Thank you for your interest in sogo.

To access the production builds, you need a premium contract support that
you can request here -> https://www.sogo.nu/commercial.html. After the
request, our sales team will contact you. Besides the production builds, you
will have access to a private website for support.

 

The nightly builds are free to download. Go at the end of page there and
chose your OS and “nightly” ->
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_software_download
s. If you are in rhel/centos, more steps are needed and explained here ->
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_software_download
s

The difference between the nightly and productions builds is that the
production ones are stable, where the nightly are built each day with our
on-going bug fixes/features and might be unstable, even if we try our best
to keep it stable.

Regards,
Quentin Hivert

 

 

From: users-requ...@sogo.nu  On Behalf Of "Alexandre
CAYLA"
Sent: vendredi 24 mai 2024 11:47
To: users@sogo.nu
Subject: [SOGo] download production version

 

Hello,

I’m registred on Sogo but i don’t know how i can download the debian package
distribution. What is my username ? i tried with my mail and my
password created but i don’t have access.

The free version is the development version only ? I’m looking for a free
open source solution for mail and collaboration, i would like to start using
Sogo for a test on my organization.

 

Thanks you 

 

Cordialement,




Alexandre CAYLA
Administration système
réseau et sécurité
Tél:   05.62.13.56.43
  alexandre.ca...@mnsp.fr

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce
mail que si nécessaire.

 

RE: [SOGo] AddressBook remains empty - Sogo v5.10.0

[qhivert]

Do you see the contacts of the others global addressbooks?
Can you try to search for a user in your ‘Users’ calendar group and tell me if 
it works or not?

 

I know there has been dev on the parameter listRequiresDot = NO;  which allows 
or not to directly show all the users, but in your configuration it should be 
working. I also test it with your same config and the last nightly and it works 
on my machine (ubuntu 22).

 

From: users-requ...@sogo.nu  On Behalf Of Eduardo Maia
Sent: mercredi 22 mai 2024 16:39
To: users@sogo.nu
Subject: Re: [SOGo] AddressBook remains empty - Sogo v5.10.0

 

Hi,

I'm not searching for a user. It's happen when I click on the Address Book. 
Here is a screenshot:



 

 

 

About the debug, I already have it enabled:

 

root@ipb8:~# tail -21 /etc/sogo/sogo.conf


GCSFolderDebugEnabled = YES;
GCSFolderStoreDebugEnabled = YES;
LDAPDebugEnabled = YES;
MySQL4DebugEnabled = YES;
NGImap4DisableIMAP4Pooling = YES;
ImapDebugEnabled = YES;
OCSFolderManagerSQLDebugEnabled = YES;
PGDebugEnabled = YES;
SOGoDebugRequests = YES;
SOGoMailKeepDraftsAfterSend = YES;
SOGoUIxDebugEnabled = YES;
SoDebugObjectTraversal = YES;
SoSecurityManagerDebugEnabled = YES;
WODontZipResponse = YES;
WODebugZipResponse = YES;


}

root@ipb8:~# 

 

 

I received LDAP debug messages when logging in with a user :



 

May 22 15:32:34 sogod [105042]: <0x0x555692c05060[NGLdapConnection]> Using 
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
May 22 15:32:34 sogod [105042]: <0x0x555692b89090[NGLdapConnection]> Using 
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
2024-05-22 15:32:34.436 sogod[105042:105042] -[NGLdapConnection 
_searchAtBaseDN:qualifier:attributes:scope:]: search at base 
'ou=users,dc=demo222,dc=pt' filter '(|(uid=emaia)(mail=emaia))' for attrs 'dn'
May 22 15:32:34 sogod [105042]: <0x0x555692b4e5e0[NGLdapConnection]> Using 
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
2024-05-22 15:32:34.439 sogod[105042:105042] -[NGLdapConnection 
_searchAtBaseDN:qualifier:attributes:scope:]: search at base 
'ou=users,dc=demo222,dc=pt' filter '(|(uid=emaia)(mail=emaia))' for attrs '*'
May 22 15:34:06 sogod [105042]: <0x0x555692ce8a60[NGLdapConnection]> Using 
ldap_initialize for LDAP URL: ldap://127.0.0.1:389

 

 

 

Testing LDAP with a query for the Address Book, I get:

 

root@ipb8:~# ldapsearch -x -H ldap://127.0.0.1:389 -D 
"cn=reader,dc=demo222,dc=pt" -b "ou=Users,dc=demo222,dc=pt" -w PASS "cn" "uid" 
"mail" 
# extended LDIF
#
# LDAPv3
# base  with scope subtree
# filter: (objectclass=*)
# requesting: cn uid mail 
#

# Users, demo222.pt
dn: ou=Users,dc=demo222,dc=pt

# emaia, Users, demo222.pt
dn: uid=emaia,ou=Users,dc=demo222,dc=pt
cn: Eduardo Maia
mail: em...@demo222.pt <mailto:em...@demo222.pt> 
uid: emaia

# dsantos, Users, demo222.pt
dn: uid=dsantos,ou=Users,dc=demo222,dc=pt
cn: Diana Santos
mail: dsan...@demo222.pt <mailto:dsan...@demo222.pt> 
uid: dsantos

# administrator, Users, demo222.pt
dn: uid=administrator,ou=Users,dc=demo222,dc=pt
cn: Administrator
mail: administra...@demo222.pt <mailto:administra...@demo222.pt> 
uid: administrator

# search result
search: 2
result: 0 Success

# numResponses: 5
# numEntries: 4
root@ipb8:~# 



 

 

 

Best regards,

Eduardo 

 

 

 

Às 14:57 de 22/05/24, qhivert (qhiv...@alinto.eu <mailto:qhiv...@alinto.eu> ) 
escreveu:

Hello,
Could you tell me if you’re searching for a user in this address book, is there 
any result?
Also, could you add LDAPDebugEnabled = YES; to your sogo.conf (and restart sogo)

Quentin

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>   
<mailto:users-requ...@sogo.nu>  On Behalf Of Eduardo Maia
Sent: mercredi 22 mai 2024 12:27
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] AddressBook remains empty - Sogo v5.10.0

 

Hi,

I configured an AddressBook based on my OpenLDAP users, but with the new Sogo 
version 5.10.0 on Debian BookWorm, it’s not working. The AddressBook remains 
empty.” 

I tried with some nightly versions and a compiled version. The result was the 
same.

Note: The same configuration on Sogo 5.9.0 and Debian Buster works fine!

 

Configuration on my /etc/sogo/sogo.conf :

 SOGoUserSources =
(
{
type = ldap;
CNFieldName = cn;
UIDFieldName = uid;
IDFieldName = uid; //first field of the DN for direct 
binds
bindFields = (uid, mail); //array of fields to use for 
indirect binds
baseDN = "ou=Users,dc=demo222,dc=pt";
bindDN = "cn=reader,dc=demo222,dc=pt";
bindPassword = "385831e5962a9d6516971c8f6a08d65d";
ca

RE: [SOGo] AddressBook remains empty - Sogo v5.10.0

[qhivert]

Hello,
Could you tell me if you’re searching for a user in this address book, is there 
any result?
Also, could you add LDAPDebugEnabled = YES; to your sogo.conf (and restart sogo)

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Eduardo Maia
Sent: mercredi 22 mai 2024 12:27
To: users@sogo.nu
Subject: [SOGo] AddressBook remains empty - Sogo v5.10.0

 

Hi,

I configured an AddressBook based on my OpenLDAP users, but with the new Sogo 
version 5.10.0 on Debian BookWorm, it’s not working. The AddressBook remains 
empty.” 

I tried with some nightly versions and a compiled version. The result was the 
same.

Note: The same configuration on Sogo 5.9.0 and Debian Buster works fine!

 

Configuration on my /etc/sogo/sogo.conf :

 SOGoUserSources =
(
{
type = ldap;
CNFieldName = cn;
UIDFieldName = uid;
IDFieldName = uid; //first field of the DN for direct 
binds
bindFields = (uid, mail); //array of fields to use for 
indirect binds
baseDN = "ou=Users,dc=demo222,dc=pt";
bindDN = "cn=reader,dc=demo222,dc=pt";
bindPassword = "385831e5962a9d6516971c8f6a08d65d";
canAuthenticate = YES;
displayName = "Users" ;
hostname =   
"ldap://127.0.0.1:389;;
id = "colaboradores";
isAddressBook = YES;
listRequiresDot = NO;
SOGoSearchMinimumWordLength = 3;
}

);

 

 

Extract from /var/log/sogo/sogo.log (with debug enabled):

 

May 22 11:10:15 sogod [105042]: |SOGo| starting method 'POST' on uri 
'/SOGo/so/emaia/Contacts/colaboradores/view'
May 22 11:10:15 sogod [105042]: |SOGo| traverse(acquire): emaia => Contacts => 
colaboradores => view
May 22 11:10:15 sogod [105042]: |SOGo|   do traverse name: 'emaia'
May 22 11:10:15 sogod [105042]: |SOGo|   do traverse name: 'Contacts'
May 22 11:10:15 sogod [105042]: |SOGo|   do traverse name: 'colaboradores'
2024-05-22 11:10:15.173 sogod[105042:105042] PG0x0x5556926d4390 SQL: SELECT 
c_path4 FROM sogo_folder_info WHERE c_path2 = 'emaia' AND c_folder_type = 
'Contact'
2024-05-22 11:10:15.176 sogod[105042:105042] PG0x0x5556926d4390 SQL: SELECT 
c_path4 FROM sogo_folder_info WHERE c_path2 = 'emaia' AND c_folder_type = 
'Contact'
May 22 11:10:15 sogod [105042]: |SOGo|   do traverse name: 'view'
May 22 11:10:15 sogod [105042]: |SOGo| set clientObject: 
<0x555692a31250[SOGoContactSourceFolder]: name=colaboradores 
container=0x555692a79d10/Contacts>
May 22 11:10:15 sogod [105042]: |SOGo| request took 0.010682 seconds to execute
May 22 11:10:15 sogod [105042]: <0x0x555692a57ff0[WOResponse]> Zipping of 
response disabled
May 22 11:10:15 sogod [105042]: 10.200.140.53 "POST 
/SOGo/so/emaia/Contacts/colaboradores/view HTTP/1.1" 200 74/46 0.013 - - 0 - 12

 

Anyone could help ?

 

Thanks in advance!

-- 


Eduardo Maia
IPBrick IDI 

  


Av. da França, 821 
4250-214 Porto
Portugal 

TEL: +351 220 126 921
TLM: +351 933 568 871
FAX: +351 225 189 722
UCoIP:   em...@ipbrick.com 


  www.ipbrick.com
  www.youtube.com/ipbricksa 

   
  
  
  
 

 

RE: [SOGo] Vcard 4.0

[qhivert]

Hello Loïc
I will be interested to know how you have converted your contact to vcard3 from 
vcard 4, I don't see the option in thunderbird? 

Regards,
Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Loïc Tron
Sent: mardi 21 mai 2024 11:28
To: users@sogo.nu
Subject: Re: [SOGo] Vcard 4.0

Thank's Quentin, I revert my Thunderbird cards to v 3.0.
Loïc


Le 21/05/24 à 11:16, qhivert (qhiv...@alinto.eu) a écrit :
> Hello Loic,
> SOGo doesn't support vcard 4.
>
> Quentin
>
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of Loïc Tron
> Sent: lundi 20 mai 2024 21:29
> To: users@sogo.nu
> Subject: [SOGo] Vcard 4.0
>
> Hi,
> I can't find how to enable Vcard 4.0. Can anyone give me instructions?
> Thank you
> Loïc
>

RE: [SOGo] Vcard 4.0

[qhivert]

Hello Loic,
SOGo doesn't support vcard 4.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Loïc Tron
Sent: lundi 20 mai 2024 21:29
To: users@sogo.nu
Subject: [SOGo] Vcard 4.0

Hi,
I can't find how to enable Vcard 4.0. Can anyone give me instructions?
Thank you
Loïc

RE: [SOGo] Two Versions

[qhivert]

Hello,

What version of sogo are you using?
If this is the last ones ~5.10 there shouldn't be any CalDavSynchronizer 
errors. I'm myself using Outlook with CalDavSynchronizer and everything's works 
fine with SOGO 5.9. 

Other versions that 5.X are not maintained anymore and I strongly suggest to 
not switch to them.

Regards,
Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Alexandru 
Sauciuc
Sent: jeudi 25 avril 2024 10:08
To: users@sogo.nu
Subject: [SOGo] Two Versions

Hello there,

we are a small firm and have been using SOGo for a few years now.
Due to Outlook compatibility problems (more exactly CalDavSynchronizer
errors) we are considering alternatives.

While looking for alternatives, we found out that SOGo is actually maintaining 
two versions, one of which (2.x) offers Outlook native support (over 
openchange).

Now the question is, how maintained is the 2.x really? We noticed the last 
release in April 2022, and 1 year before that but nothing since. 
Openchange is a little worse, as we see the last update was in 2015.
Is the version 2.x safe to use in production? What are the main differences 
between the version 2.x and 3.x+?


Kind regards,
Alex

RE: [SOGo] settings pane empty when switching to zh_cn or ar

[qhivert]

Hello,

So, it was some translated string that caused that. The strings are
converted in an array using the comma delimiter...
In those two languages the comma was not the usual ones but the 'FULLWIDTH
COMMA' (U+FF0C) or 'ARABIC COMMA' (U+060C) causing this "array" to have just
one item instead of the nine expected, causing this empty pane.

I've made a quick fix on transifex for those particular strings so with the
next nightly you should see the settings pane. But I agree there is better
things to do against that :/

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Marco Moock
Sent: jeudi 14 mars 2024 10:13
To: users@sogo.nu
Subject: [SOGo] settings pane empty when switching to zh_cn or ar

Hello!

When one of our clients changed the lang to zh_cn, the settings pane turned
empty.
This also happens when choosing Arabic (ar), but it does work properly for
German and Russian.

That can be reproduced on demo.sogo.nu.

--
kind regards
Marco Moock

RE: [SOGo] How to disable X-Forward header?

[qhivert]

Hello,

It doesn't look like you can do this in sogo. However, you probably can 
configure your smtp server to remove this header.
Example with postfix:

global:
main.cf: header_checks=regexp:/etc/postfix/header_cleanup
header_cleanup: /^X-Forward;/   IGNORE
could be restricted to submission if added this header_checks in corresponding 
service (master.cf)

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Frank Richter
Sent: jeudi 7 mars 2024 12:51
To: users@sogo.nu
Subject: [SOGo] How to disable X-Forward header?

Hi,

when sending e-mails SOGo writes the IP address of the user in the e-mail 
header:
X-Forward: IP

We have  to disable it for privacy reasons. Is there a possibility within SOGo?

Thanks,
Frank

-- 
Frank Richter, Chemnitz University of Technology, Germany

RE: [SOGo] Forwarding to internal domains only

[qhivert]

In what documentation you were looking at ?
In here, look for the parameter SOGoForwardConstraints and it is explained  
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html

Quentin
-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Kees van Vloten
Sent: mardi 5 mars 2024 15:33
To: users@sogo.nu
Subject: Re: [SOGo] Forwarding to internal domains only


On 04-03-2024 09:03, qhivert (qhiv...@alinto.eu) wrote:
> Hello,
> Yes, you can like this:
> SOGoForwardEnabled = YES
> SOGoForwardConstraints = 3;
> SOGoForwardConstraintsDomains = ("gmail.com", "googlemail.com");
>
> The value 3 will check for both internal domain known by sogo and domains in 
> the list SOGoForwardConstraintsDomains

Thanks Quentin, I have tested this setting, it works!

This option '3' and the extra config key 'SOGoForwardConstraintsDomains' 
are not in the documentation (I checked that before asking here).
Could you add that, please?

- Kees.

>
> Quentin
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of Kees van 
> Vloten
> Sent: vendredi 1 mars 2024 15:05
> To: users@sogo.nu
> Subject: [SOGo] Forwarding to internal domains only
>
> Hi,
>
> I want to allow users to set forwarding to internal mail accounts, so mail 
> sogo.conf contains:
>
>   SOGoForwardEnabled = YES;
>   SOGoForwardConstraints = 1;
>
> The fact is that there are multiple internal domains and not all users can 
> send mails in all domains.
>
> Now it looks like sogo looks at the user's mail identities to determine what 
> internal domains are for that user. Because what sogo deems an internal 
> domain differs per user.
>
> So if you have identities in example.com and example.org you can forward 
> within both, but if you just have an identity in example.com you can only 
> forward to example.com addresses. What I want is that all users can forward 
> to both because both are in internal domains.
>
> Is it possible to specify a list of internal domains in sogo.conf?
> Or perhaps configure a LDAP query to fetch internal domains there?
>
> - Kees.
>

RE: [SOGo] Forwarding to internal domains only

[qhivert]

Hello,
Yes, you can like this:
SOGoForwardEnabled = YES
SOGoForwardConstraints = 3;
SOGoForwardConstraintsDomains = ("gmail.com", "googlemail.com");

The value 3 will check for both internal domain known by sogo and domains in 
the list SOGoForwardConstraintsDomains

Quentin
-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Kees van Vloten
Sent: vendredi 1 mars 2024 15:05
To: users@sogo.nu
Subject: [SOGo] Forwarding to internal domains only

Hi,

I want to allow users to set forwarding to internal mail accounts, so mail 
sogo.conf contains:

 SOGoForwardEnabled = YES;
 SOGoForwardConstraints = 1;

The fact is that there are multiple internal domains and not all users can send 
mails in all domains.

Now it looks like sogo looks at the user's mail identities to determine what 
internal domains are for that user. Because what sogo deems an internal domain 
differs per user.

So if you have identities in example.com and example.org you can forward within 
both, but if you just have an identity in example.com you can only forward to 
example.com addresses. What I want is that all users can forward to both 
because both are in internal domains.

Is it possible to specify a list of internal domains in sogo.conf?
Or perhaps configure a LDAP query to fetch internal domains there?

- Kees.

RE: [SOGo] Webinterface's color changed after upgrade to SOGo v5.10.0

[qhivert]

Yes it was,
Somehow this faulty css pass trough our pipelines :/

SOGO 5.10 has been updated and the file is correct now.
If you're already have installed 5.10 to get the proper package do:
- apt remove sogo
- apt update
- apt install sogo
(or yum equivalent)

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Adi
Kriegisch
Sent: vendredi 23 février 2024 14:05
To: users@sogo.nu
Subject: Re: [SOGo] Webinterface's color changed after upgrade to SOGo
v5.10.0

Hi!

> after upgrading SOGo v5.9.1 -> v5.10.0 the web interface looks 
> different color-wise than before (see screenshot comparing now and
before).
> To me, it seems like some background is missing. Since I assume that 
> this is not an intentional change, how do I find what might be wrong 
> with my SOGo installation (I don't see errors in the SOGo- and
apache-logs)?
> I'm using self-built Debian packages for Sope and SOGo on Bookworm.
This is caused by bug #5929 (https://bugs.sogo.nu/view.php?id=5929) and you
can fix this by adding '*/' to close the comment in
/usr/lib/GNUstep/SOGo/WebServerResources/css/theme-default.css on line 12...

all the best,
Adi

RE: [SOGo] How many table

[qhivert]

Hello,

Sogo has two modes for database.

The current one, with only 11 tables

The legacy one with several tables per user
Both are ok and once a mode has been chosen, you can’t switch between them.

If you’re setting up a new sogo server, we encourage to use the new mode (by 
setting OCSStoreURL, OCSAclURL and OCSCacheFolderURL).

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Max Malycha
Sent: jeudi 22 février 2024 11:33
To: users@sogo.nu
Subject: Re: [SOGo] How many table

 

Hi,
my (MySQL-)Database holds only 11 tables:

mysql> use sogo

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

 

Database changed

mysql> show tables;

++

| Tables_in_sogo |

++

| sogo_acl |

| sogo_admin |

| sogo_alarms_folder |

| sogo_cache_folder |

| sogo_folder_info |

| sogo_quick_appointment |

| sogo_quick_contact |

| sogo_sessions_folder |

| sogo_store |

| sogo_user_profile |

| users |

++

11 rows in set (0,00 sec)


I'm not sure, but perhaps the count of rows you name is the whole db? The 
number of rows in my example means the count of rows in the answer to my 
statement! 


Best Regards

Max  

Am 22. Feb. 2024, 10:59 +0100 schrieb Albert Shih mailto:users@sogo.nu> >:



Hi,

How many tables do you have in your postgresql ?

Because I got

(26908 rows)

It seem I got 12 tables for each users.

Everything seem to work well, and maybe it's just because it's old
installation, but I just want to ask.

Regards
--
Albert SHIH 嶺 
France
Heure locale/Local time:
jeu. 22 févr. 2024 10:39:33 CET

RE: [SOGo] sogo_admin table in 5.10

[qhivert]

Hi,
Have you set the param OCSAdminURLin your sogo.conf? If not, it's normal the 
table is not created.
If yes, sogo will create it when starting/restrating

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Albert Shih
Sent: jeudi 22 février 2024 10:38
To: qhivert 
Subject: Re: [SOGo] sogo_admin table in 5.10

Le 21/02/2024 à 16:54:01+0100, qhivert a écrit Hi, 

> 
> You’re quick, I haven’t even made the full release yet 
> Yes the table will be created by sogo itself, no need to do it manually.
> If you use another collation than utf8mb4 (for example 
> utf8mb4_unicode_ci) you may have to change it manually, though.
> 

I just upgrade to 5.10 and no table sogo_admin tables. 

I check inside 

  /usr/share/doc/sogo/

and don't see any 

  sql-update-5.9.0_to_5.10.*

regards.

JAS
--
Albert SHIH 嶺 
France
Heure locale/Local time:
jeu. 22 févr. 2024 10:35:05 CET

RE: [SOGo] sogo_admin table in 5.10

[qhivert]

Hello

Careful you probably put in your OCSAdminUrl the same as value as SOGoProfileURL

Yours should look like this
OCSAdminURL = "mysql://sogo:PASSWORD@127.0.0.1:3306/sogo/sogo_admin";

 

For the collation, SOGo should create the correct value. For example, mines are 
utf8mb4_0900_ai_ci



For some users that use Unicode (for emoji) they would have to change that 
manually. As long as you don’t see any missing characters in your webmail, you 
have nothing to worry about.

 

Quentin

 

 

From: users-requ...@sogo.nu  On Behalf Of Max Malycha
Sent: mercredi 21 février 2024 18:11
To: users@sogo.nu
Subject: RE: [SOGo] sogo_admin table in 5.10

 

Hi,
I've tried to get rid of the message about missing OCSAdminURL today and set 
the value in this way:

// Hack um Fehlermeldung "OCSAdminUrl not set" zu unterdruecken

OCSAdminURL = "mysql://sogo:PASSWORD@127.0.0.1:3306/sogo/sogo_user_profile";


Reason is I've found no db-description for the table 'sogo_admin' :(

Quentin wrote:

If you use another collation than utf8mb4 (for example utf8mb4_unicode_ci) 

you may have to change it manually, though.


Now I took a look in my MySQL database. There is no possibility to set 'pure' 
utf8mb4 collation. I can only use utf8mb4_XXX encodings, like unicode_ci, 
german2 etc. 
And the table sogo_admin was not created by the first start after the update 
... (nightly built from today).

Best Regards
Max

Am 21. Feb. 2024, 16:55 +0100 schrieb qhivert mailto:users@sogo.nu> >:



Hello

You’re quick, I haven’t even made the full release yet 
Yes the table will be created by sogo itself, no need to do it manually.
If you use another collation than utf8mb4 (for example utf8mb4_unicode_ci) you 
may have to change it manually, though.

 

Quentin




From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Pavel 
Zheltobryukhov
Sent: mercredi 21 février 2024 15:34
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] sogo_admin table in 5.10

 

Hi to all, it's nice to hear what ver. 5.10 was released recently. Some new 
parameters was introduced - OCSAdminURL  and SOGoSuperUsernames .

In OCSAdminURL we need to set up a 'sogo_admin' table. Before start upgrade, I 
did a SQL query about tables in sogo db

$ psql -U vmailadmin -d sogo

psql (12.17 (Ubuntu 12.17-0ubuntu0.20.04.1))

Type "help" for help.

 

sogo=> \dt

List of relations

 Schema |  Name  | Type  | Owner

++---+---

 public | sogo_acl   | table | sogo

 public | sogo_alarms_folder | table | sogo

 public | sogo_cache_folder  | table | sogo

 public | sogo_folder_info   | table | sogo

 public | sogo_quick_appointment | table | sogo

 public | sogo_quick_contact | table | sogo

 public | sogo_sessions_folder   | table | sogo

 public | sogo_store | table | sogo

 public | sogo_user_profile  | table | sogo

(9 rows)

 

sogo=>

There is no 'sogo_admin' at this moment in 5.9.1 (nightly January build) . Does 
this table will be created during upgrade process, or I should create it 
before/after upgrade?

 

WBR, Pavel Zhe

RE: [SOGo] sogo_admin table in 5.10

[qhivert]

Hello

You’re quick, I haven’t even made the full release yet 
Yes the table will be created by sogo itself, no need to do it manually.
If you use another collation than utf8mb4 (for example utf8mb4_unicode_ci) you 
may have to change it manually, though.

 

Quentin



From: users-requ...@sogo.nu  On Behalf Of Pavel 
Zheltobryukhov
Sent: mercredi 21 février 2024 15:34
To: users@sogo.nu
Subject: [SOGo] sogo_admin table in 5.10

 

Hi to all, it's nice to hear what ver. 5.10 was released recently. Some new 
parameters was introduced - OCSAdminURL  and SOGoSuperUsernames .

In OCSAdminURL we need to set up a 'sogo_admin' table. Before start upgrade, I 
did a SQL query about tables in sogo db

$ psql -U vmailadmin -d sogo

psql (12.17 (Ubuntu 12.17-0ubuntu0.20.04.1))

Type "help" for help.

 

sogo=> \dt

List of relations

 Schema |  Name  | Type  | Owner

++---+---

 public | sogo_acl   | table | sogo

 public | sogo_alarms_folder | table | sogo

 public | sogo_cache_folder  | table | sogo

 public | sogo_folder_info   | table | sogo

 public | sogo_quick_appointment | table | sogo

 public | sogo_quick_contact | table | sogo

 public | sogo_sessions_folder   | table | sogo

 public | sogo_store | table | sogo

 public | sogo_user_profile  | table | sogo

(9 rows)

 

sogo=>

There is no 'sogo_admin' at this moment in 5.9.1 (nightly January build) . Does 
this table will be created during upgrade process, or I should create it 
before/after upgrade?

 

WBR, Pavel Zhe

RE: [SOGo] CKEditor 4.x insecure

[qhivert]

Hello,

You can find more infos here -> https://bugs.sogo.nu/view.php?id=5920

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Ganael 
Laplanche
Sent: vendredi 9 février 2024 10:26
To: users@sogo.nu
Subject: [SOGo] CKEditor 4.x insecure

Hello,

Latest Sogo release (5.9.1) embeds CKEditor 4.22.1, which is considered as 
insecure, see:

https://ckeditor.com/ckeditor-4/#is-ckeditor-4-secure?

"The final public security patches for CKEditor 4 were released on June 30, 
2023. Please be aware this means the public versions of CKEditor 4 are no 
longer secure."

Has Sogo team backported any patch to fix XSS flaws (it does not seem
so: the latest commit related to CKEditor I can find is the integration of 
version 4.22.1 itself) ?

Is there any plan to upgrade CKEditor to version 5 ?

Best regards,

--
Ganael Laplanche 
Unix Systems Engineer @CentraleSupelec Rennes - DISI

RE: [SOGo] SOGo 5.9.0 could not load product

[qhivert]

Hello,

Thank you for your investigation and your pull request.
I assume some OS does need that as for the others, everything’s ok . On my 
ubuntu 22, ytnef is correctly linked without your modification ->
root@8e09d7b54b57:/src/SOGo# ldd /usr/local/lib/GNUstep/SOGo/Mailer.SOGo/Mailer 
| grep ytnef 

   libytnef.so.0 => /lib/x86_64-linux-gnu/libytnef.so.0 
(0x7f70b321)

Do you confirm your sogo can now open winmail.dat file without problem ? 



From: users-requ...@sogo.nu  On Behalf Of 
"burkha...@konsultaner.de"
Sent: vendredi 2 février 2024 14:46
To: users@sogo.nu
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

 

I found the issue. It was already described here: https://bugs.gentoo.org/811351

 

The "SoObjects/SOGo/GNUmakefile" is missing the additional LDFLAG

 

This is what needs to be changed




-ADDITIONAL_LDFLAGS += -lmemcached -lzip
+ADDITIONAL_LDFLAGS += -lmemcached -lzip -lytnef
 
now ldd shows the link!
 
I would say this is a SOGo bug and should be changed in the source code.

 

Am Freitag, dem 02.02.2024 um 12:37 + schrieb burkha...@konsultaner.de 
<mailto:burkha...@konsultaner.de> :

I just realized one more thing

ldd /usr/local/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer | grep ytnef 

ldd /usr/local/lib64/GNUstep/SOGo/MailerUI.SOGo/MailerUI | grep ytnef 

 ldd /usr/local/lib64/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers | grep 
ytnef


returns nothing. it seems like ytnef didn't get linked eventhough it didn't end 
in a compiletime error. So compilation worked well, but execution doesn't work. 

 

Am Donnerstag, dem 01.02.2024 um 22:03 + schrieb burkha...@konsultaner.de 
<mailto:burkha...@konsultaner.de> :

To answer you other questions:

cat /usr/local/include/ytnef.h | grep TNEFParseMemory

int TNEFParseMemory(BYTE *memory, long size, TNEFStruct *TNEF);

 

gcc -lytnef

/usr/bin/ld: /usr/lib/gcc/x86_64-redhat-linux/11/../../../../lib64/crt1.o: in 
function `_start':

(.text+0x1b): undefined reference to `main'

collect2: error: ld returned 1 exit status

 

I finally got ld to find the libytnef.so and libytnef.a 

ldconfig -p | grep libyt

libytnef.so.0 (libc6,x86-64) => /usr/local/lib/libytnef.so.0

libytnef.so (libc6,x86-64) => /usr/local/lib/libytnef.so

 

I needed to add /usr/local/lib to the ld path. Seems like Alma puts everything 
into /usr/local/lib64 

 

I could compile the test.c without a problem. I also added the BUNDLE_LIBS += 
-lytnef but still

 

Nothing works. The linker can see ytnef and sogo should find it too, because it 
is available in /usr/local/lib64 via a symlink. 

 

Is there any other possible condition why the mail component doesn't find my 
libytnef.so? 

 

The version of ytnef also contains the symbol:

nm -D /usr/local/lib/libytnef.so | grep TNEFParseMemory 54e0 T 
TNEFParseMemory

 

Am Mittwoch, dem 31.01.2024 um 18:25 + schrieb burkha...@konsultaner.de 
<mailto:burkha...@konsultaner.de> :

Sorry, this is the output of the daemon. So when running it not building. 
Compiling works well.

 

Am 31.01.2024 17:29 schrieb qhivert mailto:users@sogo.nu> >:

It’s not clear to me if you get the errors when building or after when running 
sogo ?

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> >On Behalf 
Of"burkha...@konsultaner.de <mailto:burkha...@konsultaner.de> "
Sent: mercredi 31 janvier 2024 16:14
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

 

Thank you, compiling the test.c worked. my I added the ytnef.h to ld but still 
the same error. If it helps here is my part of the ansible script that compiles 
sogo on alma 9.3 minimal

 

- name: set data path
  set_fact:
sogo_gnustep_path: "/usr/local/lib64/GNUstep/SOGo"

- name: Enable additional repo
  dnf:
name:
  - epel-release
  - almalinux-release-devel

- name: Enable CRB repository
  command: dnf config-manager --set-enabled crb

- name: Enable devel repository
  command: dnf config-manager --set-enabled devel

- name: Install required packages
  dnf:
enablerepo: epel
name:
  - gnustep-base
  - gnustep-make
  - gnustep-base-devel
  - gcc-objc
  - libsodium
  - libsodium-devel
  - libmemcached-awesome
  - libmemcached-awesome-devel
  - libzip
  - libzip-devel

- name: Install required packages
  dnf:
name:
  - redhat-rpm-config
  - libxml2-devel
  - libxml2
  - openssl-devel
  - openssl
  - openldap-devel
  - openldap
  - postgresql-devel
  - postgresql
  - libcurl-devel
  - libcurl
  - python3-psycopg2
  - autoconf
  - automake
  - libtool
  - git
state: present

- name: Clone ytnef from GitHub
  git:
repo: 'https://github.com/Yeraze/ytnef.git'
dest: '/tmp/ytnef'
version: "{{ ytnef_git_tag }}"
 

RE: [SOGo] SOGo 5.9.0 could not load product

[qhivert]

It’s not clear to me if you get the errors when building or after when running 
sogo ?

 

From: users-requ...@sogo.nu  On Behalf Of 
"burkha...@konsultaner.de"
Sent: mercredi 31 janvier 2024 16:14
To: users@sogo.nu
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

 

Thank you, compiling the test.c worked. my I added the ytnef.h to ld but still 
the same error. If it helps here is my part of the ansible script that compiles 
sogo on alma 9.3 minimal

 

- name: set data path
  set_fact:
sogo_gnustep_path: "/usr/local/lib64/GNUstep/SOGo"

- name: Enable additional repo
  dnf:
name:
  - epel-release
  - almalinux-release-devel

- name: Enable CRB repository
  command: dnf config-manager --set-enabled crb

- name: Enable devel repository
  command: dnf config-manager --set-enabled devel

- name: Install required packages
  dnf:
enablerepo: epel
name:
  - gnustep-base
  - gnustep-make
  - gnustep-base-devel
  - gcc-objc
  - libsodium
  - libsodium-devel
  - libmemcached-awesome
  - libmemcached-awesome-devel
  - libzip
  - libzip-devel

- name: Install required packages
  dnf:
name:
  - redhat-rpm-config
  - libxml2-devel
  - libxml2
  - openssl-devel
  - openssl
  - openldap-devel
  - openldap
  - postgresql-devel
  - postgresql
  - libcurl-devel
  - libcurl
  - python3-psycopg2
  - autoconf
  - automake
  - libtool
  - git
state: present

- name: Clone ytnef from GitHub
  git:
repo: 'https://github.com/Yeraze/ytnef.git'
dest: '/tmp/ytnef'
version: "{{ ytnef_git_tag }}"
clone: yes
update: yes

- name: Compile and Install SOPE
  shell: |
cd /tmp/ytnef
autoreconf -i
./configure
make
make install
echo "/usr/local/include" | sudo tee -a /etc/ld.so.confD
ldconfig
  args:
executable: /bin/bash

- name: Clone SOPE from GitHub
  git:
repo: 'https://github.com/Alinto/sope.git'
dest: '/tmp/SOPE'
version: "{{ sope_git_tag }}"
clone: yes
update: yes

- name: Clone SOGo from GitHub
  git:
repo: 'https://github.com/Alinto/sogo.git'
dest: '/tmp/SOGo'
version: "{{ sogo_git_tag }}"
clone: yes
update: yes

- name: Compile and Install SOPE
  shell: |
cd /tmp/SOPE
./configure --with-gnustep --enable-debug --disable-strip
make
make install
  args:
executable: /bin/bash

- name: Compile and Install SOGo
  shell: |
cd /tmp/SOGo
./configure --enable-debug --disable-strip
make
make install
  args:
executable: /bin/bash

 

you just need to set the vars in you playbook, this is only my sogo role.

 

Am Mittwoch, dem 31.01.2024 um 15:16 +0100 schrieb qhivert:

Ok,

It seems related to  <https://bugs.sogo.nu/view.php?id=5907> 
https://bugs.sogo.nu/view.php?id=5907
but it it’s not the same symbol. Could you try the steps of my first comment 
there (qhivert)?

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of 
"burkha...@konsultaner.de <mailto:burkha...@konsultaner.de> "
Sent: mercredi 31 janvier 2024 15:06
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

 

Hey Queintin,

 

no I tried installing from yum, from the nightly repo and finally tried to 
install by compiling from source. Nothing worked. I always get the same error. 
Even going down on a 5.8 didn't work.

 

Richard

 

Am Mittwoch, dem 31.01.2024 um 14:32 +0100 schrieb qhivert:

Hello,

 

Are you saying that when installing ytnef via yum it don’t work but when you’re 
building ytnef yourself it works fine? 

 

Queintin





 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of 
"burkha...@konsultaner.de <mailto:burkha...@konsultaner.de> "
Sent: mercredi 31 janvier 2024 11:23
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

 

I compiled SOGo 5.9.1 from source on AlmaLinux9 which worked fine. I also 
compiled ytnef from source, because I keep getting the errors:

 

Error (objc-load):/usr/local/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined 
symbol: TNEFParseMemory

Error 
(objc-load):/usr/local/lib64/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: 
undefined symbol: __objc_class_name_SOGoMailBodyPart

Error 
(objc-load):/usr/local/lib64/GNUstep/SOGo/PreferencesUI.SOGo/PreferencesUI: 
undefined symbol: __objc_class_name_SOGoMailLabel

 

So somehow ytnef is not getting bundled. I tried to add it to BUNDLE_LIBS 
"-lytnef" in SoObjects/Mailer/GNUmakefile.preamble but it didn't work.

RE: [SOGo] SOGo 5.9.0 could not load product

[qhivert]

Ok,

It seems related to  <https://bugs.sogo.nu/view.php?id=5907> 
https://bugs.sogo.nu/view.php?id=5907
but it it’s not the same symbol. Could you try the steps of my first comment 
there (qhivert)?

 

From: users-requ...@sogo.nu  On Behalf Of 
"burkha...@konsultaner.de"
Sent: mercredi 31 janvier 2024 15:06
To: users@sogo.nu
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

 

Hey Queintin,

 

no I tried installing from yum, from the nightly repo and finally tried to 
install by compiling from source. Nothing worked. I always get the same error. 
Even going down on a 5.8 didn't work.

 

Richard

 

Am Mittwoch, dem 31.01.2024 um 14:32 +0100 schrieb qhivert:

Hello,

 

Are you saying that when installing ytnef via yum it don’t work but when you’re 
building ytnef yourself it works fine? 

 

Queintin




 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of 
"burkha...@konsultaner.de <mailto:burkha...@konsultaner.de> "
Sent: mercredi 31 janvier 2024 11:23
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

 

I compiled SOGo 5.9.1 from source on AlmaLinux9 which worked fine. I also 
compiled ytnef from source, because I keep getting the errors:

 

Error (objc-load):/usr/local/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined 
symbol: TNEFParseMemory

Error 
(objc-load):/usr/local/lib64/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: 
undefined symbol: __objc_class_name_SOGoMailBodyPart

Error 
(objc-load):/usr/local/lib64/GNUstep/SOGo/PreferencesUI.SOGo/PreferencesUI: 
undefined symbol: __objc_class_name_SOGoMailLabel

 

So somehow ytnef is not getting bundled. I tried to add it to BUNDLE_LIBS 
"-lytnef" in SoObjects/Mailer/GNUmakefile.preamble but it didn't work.

RE: [SOGo] SOGo 5.9.0 could not load product

[qhivert]

Hello,

 

Are you saying that when installing ytnef via yum it don’t work but when you’re 
building ytnef yourself it works fine? 

 

Queintin



 

From: users-requ...@sogo.nu  On Behalf Of 
"burkha...@konsultaner.de"
Sent: mercredi 31 janvier 2024 11:23
To: users@sogo.nu
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

 

I compiled SOGo 5.9.1 from source on AlmaLinux9 which worked fine. I also 
compiled ytnef from source, because I keep getting the errors:

 

Error (objc-load):/usr/local/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined 
symbol: TNEFParseMemory

Error 
(objc-load):/usr/local/lib64/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: 
undefined symbol: __objc_class_name_SOGoMailBodyPart

Error 
(objc-load):/usr/local/lib64/GNUstep/SOGo/PreferencesUI.SOGo/PreferencesUI: 
undefined symbol: __objc_class_name_SOGoMailLabel

 

So somehow ytnef is not getting bundled. I tried to add it to BUNDLE_LIBS 
"-lytnef" in SoObjects/Mailer/GNUmakefile.preamble but it didn't work.

RE: [SOGo] Fosdem?

[qhivert]

Hello,
(beware, yo usent this email to the mailing list and not my private email which 
is qhiv...@alinto.eu)
Alinto has not planned to go to Fosdem, do you need some infos or to be put in 
contact with our team?

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Kees van Vloten
Sent: dimanche 28 janvier 2024 13:11
To: qhivert (qhiv...@alinto.eu) 
Subject: [SOGo] Fosdem?

Hi Quentin,


I got your mail-address from the mailing list.

Now I was wondering if anyone from Alinto / Sogo will be attending Fosdem next 
week in Brussels?


- Kees.

RE: [SOGo] NAME:NSGenericException REASON:Parse failed

[qhivert]

Well in that case you will need the debugger gdb. I explained it in my previous 
message.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Raoul 
Holzlöhner
Sent: samedi 6 janvier 2024 06:14
To: qhivert (qhiv...@alinto.eu) 
Subject: Re: [SOGo] NAME:NSGenericException REASON:Parse failed

Hey,
I raised the debug-level (ty i didn'd recognized that options) but log is still 
like that:
"Jan 06 05:18:11 sogod [24288]: 10.10.10.2 "POST 
/SOGo/so/me/Mail/0/folderINBOX/changes HTTP/1.1" 200 29/126 0.286 - - 0 - 15
2024-01-06 05:18:11.991 sogod[24286:24286] EXCEPTION:  NAME:NSGenericException REASON:Parse failed - as
property list {Parse failed at line 1 (char 65536) - reached end of string 
while parsing quoted string}, and as strings file {Parse failed at line 1 (char 
1) - unexpected character (wanted '=' or ';')} INFO:(null) Jan 06 05:18:11 
sogod [24286]: |SOGo| request took 0.835148 seconds to execute"

WTF is wrong with this guys mailbox? Is it a malformed mail in his inbox? 
Should i recreate it with another username (would be a pain in the ass cause it 
contains thousands of mails..)?

Raoul

Am 05.01.2024 um 18:03 schrieb qhivert (qhiv...@alinto.eu):
> Hello,
> You can add this to your sogo.conf to add a lot of logs
>SoDebugRequestClassification = YES;
>SOGoDebugRequests = YES;
>ImapDebugEnabled = YES;
>LDAPDebugEnabled = YES;
>PGDebugEnabled = YES;
>SMTPDebugEnabled = YES;
>MySQL4DebugEnabled = YES;
>SOGoUIxDebugEnabled = YES;
> 
> The best would be to use th debugger gdb and follow the instructions 
> here to get the full trace of what's happening before the exception -> 
> https://www.sogo.nu/support/faq/how-do-i-debug-sogo.html
> 
> Quentin
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of Raoul 
> Holzlöhner
> Sent: vendredi 5 janvier 2024 17:54
> To: qhivert (qhiv...@alinto.eu) 
> Subject: Re: [SOGo] NAME:NSGenericException REASON:Parse failed
> 
> Hello Quentin,
> 
> thank you - I checked those DB-entries: they are valid json and look good. I 
> even deleted (and later reconstructed) the rows of those 2 users but nothing 
> changed.
> And the Error Message is: "Parse failed at line 1 (char 65536)". What is that 
> beeing parsed having 65536 chars? I even deleted all calendars of those 2 
> Users using the sogo-tool but that doesn't help too.
> 
> Thats quite frustrating because the other 120 Users on the same Server (with 
> similar clients) got no problems.
> 
> Should I dig deeper in the Database and can I raise the log-level of sogo?
> 
> Raoul
> 
> Am 03.01.2024 um 16:12 schrieb qhivert (qhiv...@alinto.eu):
>> Hello,
>> So, with only two users you get an error when logging? Maybe there's 
>> something wrong in the database for them. Check the table defined by 
>> SOGoProfileURL in your sogo.conf (typically sogo_user_profile). The value 
>> for c_defaults et c_settings should be json string. You could try to remove 
>> their rows, it will be made again clean at the next connection.
>>
>> Quentin
>>
>> -Original Message-
>> From: users-requ...@sogo.nu  On Behalf Of 
>> Raoul Holzlöhner
>> Sent: mercredi 3 janvier 2024 08:21
>> To: users@sogo.nu
>> Subject: [SOGo] NAME:NSGenericException REASON:Parse failed
>>
>> Hello,
>>
>> I've got a strange parse error exception that happens if I try to 
>> login to the SOGo-GUI or if the User is invited to an event. It only 
>> occurs on
>> 2 of 120 accounts.
>> My setup is SOGo/Cyrus/postfix and sogo.log when I try to login with those 2 
>> "damaged" accounts is like this:
>> ===
>> Jan 03 08:01:32 sogod [7815]: SOGoRootPage successful login from 
>> '10.10.10.2' for user 'me' - expire = -1  grace = -1 Jan 03 08:01:32 sogod 
>> [7815]: 10.10.10.2 "POST /SOGo/connect HTTP/1.1"
>> 200 45/74 0.178 - - 0 - 14
>> Jan 03 08:01:33 sogod [7815]: 10.10.10.2 "GET 
>> /SOGo/so/me/Calendar/view HTTP/1.1" 200 22816/0 0.060 84157 72% 0 - 
>> 14 Jan 03 08:01:36 sogod [7815]: 10.10.10.2 "GET
>> /SOGo/so/me/Calendar/alarmslist?browserTime=1704265293 HTTP/1.1" 200
>> 60/0 0.009 - - 0 - 14
>> Jan 03 08:01:36 sogod [7811]: 10.10.10.2 "POST 
>> /SOGo/so/me/Mail/0/folderINBOX/changes HTTP/1.1" 200 29/126 0.314 - -
>> 0
>> - 13
>> 2024-01-03 08:01:36.686 sogod[7826:7826] EXCEPTION: > 0x56181f5beef0> NAME:NSGenericException REASON:Parse failed - as
>> property list {Parse failed at line 1 (char 65536) - reached end of 
>> string while parsing quoted string}, and as strings file {Parse 
>> failed at line 1 (char 1) - unexpected character (wanted '=' or ';')}
>> INFO:(null)
>> Jan 03 08:01:36 sogod [7826]: 10.10.10.2 "GET 
>> /SOGo/so/me/Calendar/eventsblocks?ed=20240103=20240103=dayvie
>> w
>> HTTP/1.1" 501 0/0 0.528 - - 1M - 13
>> ===
>> Can anybody tell me what exactly is parsed there and where I can find and 
>> fix it?
>>
> 

RE: [SOGo] NAME:NSGenericException REASON:Parse failed

[qhivert]

Hello,
You can add this to your sogo.conf to add a lot of logs
  SoDebugRequestClassification = YES;
  SOGoDebugRequests = YES;
  ImapDebugEnabled = YES;
  LDAPDebugEnabled = YES;
  PGDebugEnabled = YES;
  SMTPDebugEnabled = YES;
  MySQL4DebugEnabled = YES;
  SOGoUIxDebugEnabled = YES;

The best would be to use th debugger gdb and follow the instructions here to 
get the full trace of what's happening before the exception -> 
https://www.sogo.nu/support/faq/how-do-i-debug-sogo.html

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Raoul 
Holzlöhner
Sent: vendredi 5 janvier 2024 17:54
To: qhivert (qhiv...@alinto.eu) 
Subject: Re: [SOGo] NAME:NSGenericException REASON:Parse failed

Hello Quentin,

thank you - I checked those DB-entries: they are valid json and look good. I 
even deleted (and later reconstructed) the rows of those 2 users but nothing 
changed.
And the Error Message is: "Parse failed at line 1 (char 65536)". What is that 
beeing parsed having 65536 chars? I even deleted all calendars of those 2 Users 
using the sogo-tool but that doesn't help too.

Thats quite frustrating because the other 120 Users on the same Server (with 
similar clients) got no problems.

Should I dig deeper in the Database and can I raise the log-level of sogo?

Raoul

Am 03.01.2024 um 16:12 schrieb qhivert (qhiv...@alinto.eu):
> Hello,
> So, with only two users you get an error when logging? Maybe there's 
> something wrong in the database for them. Check the table defined by 
> SOGoProfileURL in your sogo.conf (typically sogo_user_profile). The value for 
> c_defaults et c_settings should be json string. You could try to remove their 
> rows, it will be made again clean at the next connection.
> 
> Quentin
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of Raoul 
> Holzlöhner
> Sent: mercredi 3 janvier 2024 08:21
> To: users@sogo.nu
> Subject: [SOGo] NAME:NSGenericException REASON:Parse failed
> 
> Hello,
> 
> I've got a strange parse error exception that happens if I try to 
> login to the SOGo-GUI or if the User is invited to an event. It only 
> occurs on
> 2 of 120 accounts.
> My setup is SOGo/Cyrus/postfix and sogo.log when I try to login with those 2 
> "damaged" accounts is like this:
> ===
> Jan 03 08:01:32 sogod [7815]: SOGoRootPage successful login from '10.10.10.2' 
> for user 'me' - expire = -1  grace = -1 Jan 03 08:01:32 sogod [7815]: 
> 10.10.10.2 "POST /SOGo/connect HTTP/1.1"
> 200 45/74 0.178 - - 0 - 14
> Jan 03 08:01:33 sogod [7815]: 10.10.10.2 "GET 
> /SOGo/so/me/Calendar/view HTTP/1.1" 200 22816/0 0.060 84157 72% 0 - 14 
> Jan 03 08:01:36 sogod [7815]: 10.10.10.2 "GET
> /SOGo/so/me/Calendar/alarmslist?browserTime=1704265293 HTTP/1.1" 200
> 60/0 0.009 - - 0 - 14
> Jan 03 08:01:36 sogod [7811]: 10.10.10.2 "POST 
> /SOGo/so/me/Mail/0/folderINBOX/changes HTTP/1.1" 200 29/126 0.314 - - 
> 0
> - 13
> 2024-01-03 08:01:36.686 sogod[7826:7826] EXCEPTION:  0x56181f5beef0> NAME:NSGenericException REASON:Parse failed - as
> property list {Parse failed at line 1 (char 65536) - reached end of 
> string while parsing quoted string}, and as strings file {Parse failed 
> at line 1 (char 1) - unexpected character (wanted '=' or ';')}
> INFO:(null)
> Jan 03 08:01:36 sogod [7826]: 10.10.10.2 "GET 
> /SOGo/so/me/Calendar/eventsblocks?ed=20240103=20240103=dayview
> HTTP/1.1" 501 0/0 0.528 - - 1M - 13
> ===
> Can anybody tell me what exactly is parsed there and where I can find and fix 
> it?
> 

RE: [SOGo] COMPLETED field in task return only DATE and not DATETIME

[qhivert]

Hello,

Could you open a ticket here -> https://bugs.sogo.nu for that matter? Once 
you’ve created your account, I will need to manually enable it so let me know.

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Matthieu Aohzan
Sent: mercredi 3 janvier 2024 10:28
To: users@sogo.nu
Subject: [SOGo] COMPLETED field in task return only DATE and not DATETIME

 

Hello,

I have an issue with the CalDav integration on Home-Assistant with my
SOGo server because:
"
Looking at the COMPLETED field spec according to
https://datatracker.ietf.org/doc/html/rfc5545#section-3.8.2.1 this also
requires the date value to have a time, however it is only being
returned as a DATE which makes me think SOGo is not following the spec
here.
"
The issue :
https://github.com/home-assistant/core/issues/106671#issuecomment-1874279246

Is it possible to match the spec ?
Please tell me if you need something else

Thank you

Regards,

Aohzan

RE: [SOGo] NAME:NSGenericException REASON:Parse failed

[qhivert]

Hello,
So, with only two users you get an error when logging? Maybe there's something 
wrong in the database for them. Check the table defined by SOGoProfileURL in 
your sogo.conf (typically sogo_user_profile). The value for c_defaults et 
c_settings should be json string. You could try to remove their rows, it will 
be made again clean at the next connection.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Raoul 
Holzlöhner
Sent: mercredi 3 janvier 2024 08:21
To: users@sogo.nu
Subject: [SOGo] NAME:NSGenericException REASON:Parse failed

Hello,

I've got a strange parse error exception that happens if I try to login to the 
SOGo-GUI or if the User is invited to an event. It only occurs on
2 of 120 accounts.
My setup is SOGo/Cyrus/postfix and sogo.log when I try to login with those 2 
"damaged" accounts is like this:
===
Jan 03 08:01:32 sogod [7815]: SOGoRootPage successful login from '10.10.10.2' 
for user 'me' - expire = -1  grace = -1 Jan 03 08:01:32 sogod [7815]: 
10.10.10.2 "POST /SOGo/connect HTTP/1.1" 
200 45/74 0.178 - - 0 - 14
Jan 03 08:01:33 sogod [7815]: 10.10.10.2 "GET /SOGo/so/me/Calendar/view 
HTTP/1.1" 200 22816/0 0.060 84157 72% 0 - 14 Jan 03 08:01:36 sogod [7815]: 
10.10.10.2 "GET
/SOGo/so/me/Calendar/alarmslist?browserTime=1704265293 HTTP/1.1" 200
60/0 0.009 - - 0 - 14
Jan 03 08:01:36 sogod [7811]: 10.10.10.2 "POST 
/SOGo/so/me/Mail/0/folderINBOX/changes HTTP/1.1" 200 29/126 0.314 - - 0
- 13
2024-01-03 08:01:36.686 sogod[7826:7826] EXCEPTION:  NAME:NSGenericException REASON:Parse failed - as
property list {Parse failed at line 1 (char 65536) - reached end of string 
while parsing quoted string}, and as strings file {Parse failed at line 1 (char 
1) - unexpected character (wanted '=' or ';')}
INFO:(null)
Jan 03 08:01:36 sogod [7826]: 10.10.10.2 "GET 
/SOGo/so/me/Calendar/eventsblocks?ed=20240103=20240103=dayview
HTTP/1.1" 501 0/0 0.528 - - 1M - 13
===
Can anybody tell me what exactly is parsed there and where I can find and fix 
it?


--
Raoul Holzlöhner
IT Systems Engineer

-

Cyrano. #gutekommunikation

Ausgezeichnet u.a. mit dem Deutschen Preis für Onlinekommunikation, dem German 
Design Award, dem eLearning-Award und dem Comprix.

E-Mail: r...@cyrano.de
Tel.: +49 251 98776-61
Fax: +49 251 98776-99
Web: www.cyrano.de
Instagram: www.instagram.com/cyrano.kommunikation
LinkedIn: www.linkedin.com/company/cyranokommunikation
TikTok: https://www.tiktok.com/@cyrano.kommunikation
Facebook: www.facebook.com/cyrano.kommunikation

Hinweise zum Datenschutz: www.cyrano.de/dse

Cyrano Kommunikation GmbH
Hohenzollernring 49-51
48145 Münster
Deutschland / Germany

Parkplätze befinden sich hinter dem Hohenzollernhaus.

Geschäftsführung: Oliver Pauli, Markus Eicher
Seniorpartner: Alexander Springensguth

Registergericht Münster: HRB 5242
Steuernummer: DE 337/5941/0105

RE: [SOGo] Move email on mobile view

[qhivert]

Ah ok I understand now.
Indeed, it’s not practical at all. I will add this to our backlog. I don’t know 
when we will have time though as we’re pretty booked up until February.

 

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Sébastien 
Perilhou
Sent: mardi 2 janvier 2024 14:52
To: users@sogo.nu
Subject: Re: [SOGo] Move email on mobile view

 

Sure, it is when you are inside an e-mail, reading it (screenshot 1).

If I compare to Gmail you have a "Move to" button in the detail (see screenshot 
2).

 

 

In SoGo case, I have to return to the list to move it.

In GMail case, I can move it from the reading panel, and I return to the list 
after.

 

 





Le 2 janv. 2024 à 14:42, qhivert mailto:users@sogo.nu> > a 
écrit :



Do you have a screen of your user case?
With my mobile I don’t even see the folders/subfolders so I certainly couldn’t 
drag and drop :/
I compare with gmail and it’s the same behavior btw.

 



 

 

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Sébastien 
Périlhou
Sent: mardi 2 janvier 2024 14:26
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: Re: [SOGo] Move email on mobile view

 

Hi Quentin,

 

Thank you for your feedback.

I found that too but I can not understand why this option is not on the e-mail 
screen. You can not move it directly, you have to return to the list to do that.

I am currently preparing a new mail server with SoGo and I am 100% sure my 
users will ask me that in the first hours after the switch :D

 

Best regards,

Sébastien

 

 






Le 2 janv. 2024 à 14:22, qhivert (qhiv...@alinto.eu <mailto:qhiv...@alinto.eu> 
) mailto:users@sogo.nu> > a écrit :

 

Hello,

I’ve just tested on my android with chrome and when you multi-select your 
emails (or even just one) you can click on the three dots -> move To

Quentin

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Sébastien 
Périlhou
Sent: vendredi 29 décembre 2023 23:07
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] Move email on mobile view

 

Hello everyone,

 

I am using Sogo for a few days, but I can not figure out how I can move emails 
from Inbox to a subfolder.

>From desktop view I can drag and drop, but from mobile?

 

Thank you for your feedback!

 

Best regards,
Sébastien

 

RE: [SOGo] Move email on mobile view

[qhivert]

Hello,

I’ve just tested on my android with chrome and when you multi-select your 
emails (or even just one) you can click on the three dots -> move To

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Sébastien 
Périlhou
Sent: vendredi 29 décembre 2023 23:07
To: users@sogo.nu
Subject: [SOGo] Move email on mobile view

 

Hello everyone,

 

I am using Sogo for a few days, but I can not figure out how I can move emails 
from Inbox to a subfolder.

>From desktop view I can drag and drop, but from mobile?

 

Thank you for your feedback!

 

Best regards,
Sébastien

 

 

 

 

RE: [SOGo] Spam reporting

[qhivert]

Hello,

No, it doesn’t seem we can. Maybe you could set a sieve filter that redirect + 
keep for one of the mail address?

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of "Simon Wilson"
Sent: samedi 30 décembre 2023 14:28
To: Jérôme Melis 
Subject: [SOGo] Spam reporting

 

Can this block:

  SOGoMailJunkSettings = {
vendor = "generic";
junkEmailAddress = "s...@mydomaininhere.net 
 ";
notJunkEmailAddress = "h...@mydomaininhere.net 
 ";
limit = 10;
  };

Have multiple email addresses set for junkEmailAddress? I.e if I wanted to be 
training my own Bayes database but also sending to DNSWL?

Thanks

-- 
Simon Wilson
M: 0400 121 116

RE: [SOGo] Need information about SOGo workflow

[qhivert]

Ok,

So your problem is that all seems to be correctly configured sogo-side but you 
don’t succeed to make an outlook profile that sync with it?

 

From: users-requ...@sogo.nu  On Behalf Of Jérôme Melis
Sent: jeudi 28 décembre 2023 10:17
To: users@sogo.nu
Subject: Re: [SOGo] Need information about SOGo workflow

 

Thanks Kees.

I've read about this too, the idea was to have a 2nd instance on another port 
just for not blocking the threads with activesync connections.
Then nginx is redirecting request as a reverse proxy.

But to me that is not really a concern.

--
Jérôme

 

On 2023-12-28 16:00, van Vloten Kees wrote:

My experience with eas in a separate sogo instance is good. That separates the 
workloads, so users don't experience delays in webmail and dav. 

It is documented somewhere in the sogo website, since I am on holiday I can't 
look up the link easily.

Next week I will be able to supply details on my setup.

 

- Kees

 

Op do 28 dec. 2023 10:25 schreef qhivert mailto:users@sogo.nu> 
>:

Hello Jérôme,

 

Is it a company requirement for people to use outlook on Mac? If not, tell them 
to use the apple calendar where there is caldav/cardav especially if the sync 
is essential. Even if they don't want to, they will have to if they want their 
event/contacts.

However, sogo can use activesync but it's very tedious to dimension has this 
protocol will use a lot of ram and keep the connection open with a 
worker/process for some times. You'll will find the info here -> 
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_microsoft_enterprise_activesync

And here -> https://www.mail-archive.com/users@sogo.nu/msg20479.html

 

Regards,

Quentin

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Jérôme 
Melis
Sent: jeudi 28 décembre 2023 02:44
To: Bruno CAPELETO (bruno.capel...@abcreseau.com 
<mailto:bruno.capel...@abcreseau.com> ) mailto:users@sogo.nu> >
Subject: Re: [SOGo] Need information about SOGo workflow

 

Dear Bruno,

thank you very much for your insights.

I would rather like to avoid outlook as I know by experience how much of a 
nightmare it can be.

But if I don't find a solution quickly, I'm afraid the direction will order a 
migration to MS exchange with all the headaches that implies.

I've looked at openchange a bit and it seems it does all the work, so I'm not 
sure why there's a sogo package named activesync nor why I would need sogo in 
the first place if all it does is to delegate the feature I'm looking for to a 
3rd party groupware.

That new requirements I have sound hopeless and that truly scares me but 
well... I've got to do my job so I'll keep digging for a solution.

Have a great day.
-- 


 <http://www.pasteur.la/> 

 <http://www.pasteur.la/> Jérôme Melis

 <http://www.pasteur.la/> CTO

 <http://www.pasteur.la/> Samsenthai Rd, Vientiane, Lao PDR

 <http://www.pasteur.la/>  +856 21 285 321

 <http://www.pasteur.la/> On 27/12/2023 15:38, Bruno CAPELETO 
(bruno.capel...@abcreseau.com) wrote:

 <http://www.pasteur.la/> Dear Jérôme, 

I have been using SOGo for years, including ActiveSync. 

My experience with the ActiveSync protocol is not good ; it always brake down 
especially with iPhone devices. 
Whether it comes from SOGo, from iPhone, or whatever is never clear. 

To me - as a non-specialist - this protocol is bullshit. 

Regarding the users of Outlook : we have been spending more than 15 years 
trying to get this shit work. 
It simply does not. And the issue is not SOGo, or ActiveSync, or whatever. 
It even does not work with MS365 : there is always from time to time a big 
crash. 

I know users loves it - when it works. That is the issue. But there is no way 
to get something stable over time with Outlook. 


To get more in technical details, you have to set up ActiveSync according to 
the guide. 
It is not installed when you install SOGo. 


Kind regards, 

Bruno Capeleto 



Le 26/12/2023 à 06:13, Jérôme Melis (j.me...@pasteur.la) a écrit : 

 <http://www.pasteur.la/> Hi, 

I'm interested in the SOGo groupware solution but I need to understand it 
better before deciding if our institute will switch to this solution. 

So far we are using a postfix/dovecot mail server, roundcube is our webmail. 
We also have a calendar solution which is synchronizing via caldav. 

The problem with our current solution is it's not covering all our user needs. 
Some people are using outlook on a mac (or iphone) where there isn't support 
for plugins, which means the caldav is unsupported too. 

I see SOGo can use ActiveSync to solve this. 
But I'm not familiar with ActiveSync. 
And when checking the official documentation, I only see "Outlook Connector 
Configuration Guide" while v3 of SOGo was offering a "Native Microsoft Outlook 
Configuration Guide". 

I did made a temporary test with the nightly build and 

RE: [SOGo] Need information about SOGo workflow

[qhivert]

Hello Jérôme,

 

Is it a company requirement for people to use outlook on Mac? If not, tell them 
to use the apple calendar where there is caldav/cardav especially if the sync 
is essential. Even if they don’t want to, they will have to if they want their 
event/contacts.

However, sogo can use activesync but it’s very tedious to dimension has this 
protocol will use a lot of ram and keep the connection open with a 
worker/process for some times. You’ll will find the info here -> 
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_microsoft_enterprise_activesync

And here -> https://www.mail-archive.com/users@sogo.nu/msg20479.html

 

Regards,

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Jérôme Melis
Sent: jeudi 28 décembre 2023 02:44
To: Bruno CAPELETO (bruno.capel...@abcreseau.com) 
Subject: Re: [SOGo] Need information about SOGo workflow

 

Dear Bruno,

thank you very much for your insights.

I would rather like to avoid outlook as I know by experience how much of a 
nightmare it can be.

But if I don't find a solution quickly, I'm afraid the direction will order a 
migration to MS exchange with all the headaches that implies.

I've looked at openchange a bit and it seems it does all the work, so I'm not 
sure why there's a sogo package named activesync nor why I would need sogo in 
the first place if all it does is to delegate the feature I'm looking for to a 
3rd party groupware.

That new requirements I have sound hopeless and that truly scares me but 
well... I've got to do my job so I'll keep digging for a solution.

Have a great day.
-- 


  

Jérôme Melis

CTO

Samsenthai Rd, Vientiane, Lao PDR

 +856 21 285 321

On 27/12/2023 15:38, Bruno CAPELETO (  
bruno.capel...@abcreseau.com) wrote:

Dear Jérôme, 

I have been using SOGo for years, including ActiveSync. 

My experience with the ActiveSync protocol is not good ; it always brake down 
especially with iPhone devices. 
Whether it comes from SOGo, from iPhone, or whatever is never clear. 

To me - as a non-specialist - this protocol is bullshit. 

Regarding the users of Outlook : we have been spending more than 15 years 
trying to get this shit work. 
It simply does not. And the issue is not SOGo, or ActiveSync, or whatever. 
It even does not work with MS365 : there is always from time to time a big 
crash. 

I know users loves it - when it works. That is the issue. But there is no way 
to get something stable over time with Outlook. 


To get more in technical details, you have to set up ActiveSync according to 
the guide. 
It is not installed when you install SOGo. 


Kind regards, 

Bruno Capeleto 



Le 26/12/2023 à 06:13, Jérôme Melis (  
j.me...@pasteur.la) a écrit : 



Hi, 

I'm interested in the SOGo groupware solution but I need to understand it 
better before deciding if our institute will switch to this solution. 

So far we are using a postfix/dovecot mail server, roundcube is our webmail. 
We also have a calendar solution which is synchronizing via caldav. 

The problem with our current solution is it's not covering all our user needs. 
Some people are using outlook on a mac (or iphone) where there isn't support 
for plugins, which means the caldav is unsupported too. 

I see SOGo can use ActiveSync to solve this. 
But I'm not familiar with ActiveSync. 
And when checking the official documentation, I only see "Outlook Connector 
Configuration Guide" while v3 of SOGo was offering a "Native Microsoft Outlook 
Configuration Guide". 

I did made a temporary test with the nightly build and I could successfully 
connect to our self-hosted sogo server which is using postfix's database for 
auth. 
But from there I'm not sure what to do the next. 
When pointing outlook to that host, it gives me the error: "Log onto Exchange 
ActiveSync mail server (EAS): The server cannot be found." 
I suppose I'm missing some understanding of the overall architecture for this 
to work. 

I'm confused, is this activesync feature still available? 
Is it possible to plug outlook via activesync directly to the sogo server 
(which will retreive user data from postfix database) or do I have to install a 
fake ldap/openchange server and duplicate my user database? 

Thanks for your help. 
-- 
Jérôme 

 

RE: [SOGo] Question regarding SOGoDisableSharingAnyAuthUser

[qhivert]

Thanks for your feedback.
I will fix the nigthly asap.

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Frank Richter
Sent: mercredi 20 décembre 2023 14:16
To: users@sogo.nu
Subject: Re: [SOGo] Question regarding SOGoDisableSharingAnyAuthUser

 

Am 20.12.23 um 13:50 schrieb qhivert (qhiv...@alinto.eu 
<mailto:qhiv...@alinto.eu> ):

You do understand the documentation correctly.

Good!



I’ve just test it and with 5.9.1 all is ok, but with the nightly it seems to 
have a problem with the autocompletion unrelated to this parameter. What 
version are you using?

Ah, I checked it with our test server who runs the nightly version. With 
version 5.9.1. ist works. Great, that will save us from users sharing their 
mailbox to all …

Do you see any error in the console by the way?

With nightly: No errors, just repeating 
https://server.domain/SOGo/so/login/usersSearch?search=searchterm

Thanks,
Frank

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>   
<mailto:users-requ...@sogo.nu>  On Behalf Of Frank 
Richter
Sent: mercredi 20 décembre 2023 10:34
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] Question regarding SOGoDisableSharingAnyAuthUser

 

Hello,

we’d like to disable the possibility for users to share their mailfolders to 
all users. That means users should not see the option „Any Authenticated User“ 
under Sharing … .
I hoped that the config option 
SOGoDisableSharingAnyAuthUser = (Mail);

would do it. And yes, the option „Any Authenticated User“ isn't shown, but then 
sharing at all is disabled, the lookup for a user doesn’t work any longer. Is 
this a bug or do I misinterpret the explanation of this option:

List of modules where sharing with any authenticated user option should be 
disabled, for example (Mail, Calendar). Modules can be Mail, Contacts and 
Calendar. Default value empty list (sharing enabled for everybody).





-- 
Frank Richter, Chemnitz University of Technology, Germany

RE: [SOGo] Question regarding SOGoDisableSharingAnyAuthUser

[qhivert]

Hello,
You do understand the documentation correctly.
I’ve just test it and with 5.9.1 all is ok, but with the nightly it seems to 
have a problem with the autocompletion unrelated to this parameter. What 
version are you using?
Do you see any error in the console by the way?

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Frank Richter
Sent: mercredi 20 décembre 2023 10:34
To: users@sogo.nu
Subject: [SOGo] Question regarding SOGoDisableSharingAnyAuthUser

 

Hello,

we’d like to disable the possibility for users to share their mailfolders to 
all users. That means users should not see the option „Any Authenticated User“ 
under Sharing … .
I hoped that the config option 
SOGoDisableSharingAnyAuthUser = (Mail);

would do it. And yes, the option „Any Authenticated User“ isn't shown, but then 
sharing at all is disabled, the lookup for a user doesn’t work any longer. Is 
this a bug or do I misinterpret the explanation of this option:

List of modules where sharing with any authenticated user option should be 
disabled, for example (Mail, Calendar). Modules can be Mail, Contacts and 
Calendar. Default value empty list (sharing enabled for everybody).

Regards and thanks,
Frank

-- 
Frank Richter, Chemnitz University of Technology, Germany

RE: [SOGo] Authentication using ldap-md5 password fails

[qhivert]

Wait thre some ocnfusions, you don’t used ldap but a database for the user ?
What is your SOGoUserSources?
You should have something like this:
SOGoUserSources =
(
  {
type = sql;
id = directory;
viewURL = "postgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_view";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = md5;
  }
);

 

Quentin

From: users-requ...@sogo.nu  On Behalf Of  

Sent: mardi 12 décembre 2023 10:25
To: users@sogo.nu
Subject: Re: [SOGo] Authentication using ldap-md5 password fails

 

Sorry, but rollback is not possible.

 

I needed to move the mailer to another server. A backup was made on the old 
server, on the new server I launched mailcow, then deployed the backup using 
the backup_and_restore.sh script( (supplied with mailcow).

All containers started successfully, imap / smtp are working for all users.

Sogo also worked, but I tested it on a user with {BLF-CRYPT} password. 

A couple of days later, a person contacted me who could not enter sogo. I 
started looking into it and realized that only users with an md5 hash cannot 
log in. 

 

SOGO current version: 5.9.0

Old ver - i think Sogo 5.8.0, I can't look anymorе, old server is down. 

 

вт, 12 дек. 2023 г. в 13:30, qhivert mailto:users@sogo.nu> >:

Hello, you’ve updated from what sogo version to what? If you rollback your 
mailcow does it work again?

Quentin

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of  

Sent: mardi 12 décembre 2023 07:22
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] Authentication using ldap-md5 password fails

 

Good afternoon 

  I use a  mailcow: dockerized mail server with an integrated container SOGO. 
After the update, sogo stopped allowing users whose password hash was generated 
using the {MD5} algorithm. Users whose password is generated by {BLF-CRYPT} are 
authenticated normally. I turned on the logs, in the logs I can see access to 
the database and retrieval of the password hash, but the password is not 
accepted. 

 

Dec 12 10:26:01 260deb884b40 2023-12-12 10:26:01.627 sogod[69:69] 
 SQL: SELECT 
c_password FROM _sogo_static_view WHERE c_uid = 'pp_pet...@xx.xx';
Dec 12 10:26:01 260deb884b40 2023-12-12 10:26:01.627 sogod[69:69] 
   query has 
results, entering fetch-mode.

...

 SOGoRootPage Login from 'MY.IP.AD.DR' for user 'pp_pet...@xx.xx' might not 
have worked - password policy: 65535  grace: -1  expire: -1  bound: 0

 

"c_password" field on  _sogo_static_view contains hash like:

 {MD5}ZVN1hovmmV34NCxjRKIDVw==

Base64 encoded MD5 hash 

 

userPasswordAlg setting:

userPasswordAlgoritm

ldap-md5

i also try md5

 

What could be the problem? Plz  help me fix it 

RE: [SOGo] Questions Regarding SOGo / before Compliling

[qhivert]

The nightly part of our repo is open to anyone, only the release need an account
https://packages.sogo.nu/nightly/5

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of "Robert Himics"
Sent: mardi 12 décembre 2023 02:21
To: qhivert 
Subject: RE: [SOGo] Questions Regarding SOGo / before Compliling

 

Fedora 37 has gnuStep 1.28.0 and ytnef 2.1.2.

 

And your repository require a. ID and password to pull down rpms

 

Fyi Fedora 37 is newer than the base of RH 9. (Fedora 32 equivalent) 

Robert Himics
r...@himicsfamily.com <mailto:r...@himicsfamily.com> 

 

On Dec 11, 2023 3:43 AM, qhivert mailto:users@sogo.nu> > wrote:

Hello,

1 – When compiling SOGo / SOPE , Is this a 32bit or 64 Bit Application?
It’s for 64 bit


2 – Can both (SOGo / SOPE ) be compiled / Run on Fedora 37 ?
I can’t say yes for sure as I never dit it but I don’t see why it couldn’t be. 
Usually the only problems is to find and install the correct package for this 
OS.

 

3 -  When I first tried to Compile on Fedore 37,  It could NOT File the 
Libraries  for MariaDB/mySQL XML2 and possible Others 
I installed the GNUStep that’s part of the Fedora 37 Yum Repo 
What is the gnutsep version ? It should be 1.28 for sogo to work. For the 
others RHEL OS we support, we provide our own package for gnustep. You may try 
to download them, look at 
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_software_downloads

 

4 – and Since the dovecot I’ve setup Uses MariaDB as it’s backend (How do I 
disable the Need for PostgreSQL and LDAP

In that case sogo parameter SOGoUserSources should be link to the table use by 
dovecot for the users. 
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL
You may need to make hook/trigger to synchronize your different user table.

Quentin

 

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of "Robert 
Himics"
Sent: samedi 9 décembre 2023 04:18
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: RE: [SOGo] Questions Regarding SOGo / before Compliling

 

Hello – Have a Few Questions Regarding SOGo and SOPE

1 – When compiling SOGo / SOPE , Is this a 32bit or 64 Bit Application?
2 – Can both (SOGo / SOPE ) be compiled / Run on Fedora 37 ?

3 -  When I first tried to Compile on Fedore 37,  It could NOT File the 
Libraries  for MariaDB/mySQL XML2 and possible Others 
I installed the GNUStep that’s part of the Fedora 37 Yum Repo 

4 – and Since the dovecot I’ve setup Uses MariaDB as it’s backend (How do I 
disable the Need for PostgreSQL and LDAP

 

Rob Himics

r...@himicsfamily.com <mailto:r...@himicsfamily.com> 

 

RE: [SOGo] Authentication using ldap-md5 password fails

[qhivert]

Hello, you’ve updated from what sogo version to what? If you rollback your 
mailcow does it work again?

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of  

Sent: mardi 12 décembre 2023 07:22
To: users@sogo.nu
Subject: [SOGo] Authentication using ldap-md5 password fails

 

Good afternoon 

  I use a  mailcow: dockerized mail server with an integrated container SOGO. 
After the update, sogo stopped allowing users whose password hash was generated 
using the {MD5} algorithm. Users whose password is generated by {BLF-CRYPT} are 
authenticated normally. I turned on the logs, in the logs I can see access to 
the database and retrieval of the password hash, but the password is not 
accepted. 

 

Dec 12 10:26:01 260deb884b40 2023-12-12 10:26:01.627 sogod[69:69] 
 SQL: SELECT 
c_password FROM _sogo_static_view WHERE c_uid = 'pp_pet...@xx.xx';
Dec 12 10:26:01 260deb884b40 2023-12-12 10:26:01.627 sogod[69:69] 
   query has 
results, entering fetch-mode.

...

 SOGoRootPage Login from 'MY.IP.AD.DR' for user 'pp_pet...@xx.xx' might not 
have worked - password policy: 65535  grace: -1  expire: -1  bound: 0

 

"c_password" field on  _sogo_static_view contains hash like:

 {MD5}ZVN1hovmmV34NCxjRKIDVw==

Base64 encoded MD5 hash 

 

userPasswordAlg setting:

userPasswordAlgoritm

ldap-md5

i also try md5

 

What could be the problem? Plz  help me fix it 

RE: [SOGo] Questions Regarding SOGo / before Compliling

[qhivert]

Hello,

1 – When compiling SOGo / SOPE , Is this a 32bit or 64 Bit Application?
It’s for 64 bit


2 – Can both (SOGo / SOPE ) be compiled / Run on Fedora 37 ?
I can’t say yes for sure as I never dit it but I don’t see why it couldn’t
be. Usually the only problems is to find and install the correct package for
this OS.

 

3 -  When I first tried to Compile on Fedore 37,  It could NOT File the
Libraries  for MariaDB/mySQL XML2 and possible Others 
I installed the GNUStep that’s part of the Fedora 37 Yum Repo 
What is the gnutsep version ? It should be 1.28 for sogo to work. For the
others RHEL OS we support, we provide our own package for gnustep. You may
try to download them, look at
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_software_download
s

 

4 – and Since the dovecot I’ve setup Uses MariaDB as it’s backend (How do I
disable the Need for PostgreSQL and LDAP

In that case sogo parameter SOGoUserSources should be link to the table use
by dovecot for the users.
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-usi
ng-SQL
You may need to make hook/trigger to synchronize your different user table.

Quentin

 

 

From: users-requ...@sogo.nu  On Behalf Of "Robert
Himics"
Sent: samedi 9 décembre 2023 04:18
To: users@sogo.nu
Subject: RE: [SOGo] Questions Regarding SOGo / before Compliling

 

Hello – Have a Few Questions Regarding SOGo and SOPE

1 – When compiling SOGo / SOPE , Is this a 32bit or 64 Bit Application?
2 – Can both (SOGo / SOPE ) be compiled / Run on Fedora 37 ?

3 -  When I first tried to Compile on Fedore 37,  It could NOT File the
Libraries  for MariaDB/mySQL XML2 and possible Others 
I installed the GNUStep that’s part of the Fedora 37 Yum Repo 

4 – and Since the dovecot I’ve setup Uses MariaDB as it’s backend (How do I
disable the Need for PostgreSQL and LDAP

 

Rob Himics

r...@himicsfamily.com  

 

RE: [SOGo] Remove user profile completely

[qhivert]

Hello,

Probably the user is still in your sogo database, in the table SOGoProfileURL, 
usually   “sogo_user_profile”?

SELECT * from sogo_user_profile WHERE c_uid = “te...@example.com”;
If yes, remove the row. The c_uid may be only test2.

Quentin



 

From: users-requ...@sogo.nu  On Behalf Of Kees van Vloten
Sent: samedi 9 décembre 2023 13:27
To: users@sogo.nu
Subject: [SOGo] Remove user profile completely

 

Hi all,

 

I am seeing errors in the dovecot logging, like this:

Dec  3 19:50:02 strauss dovecot: auth: Master user logging in as  
 te...@example.com
Dec  3 19:50:02 strauss dovecot: auth: ldap( 
 
te...@example.com,127.0.0.1,): unknown user

 

The logging is repeated every 5 minutes and the master user is only used by 
sogo, i.e. that is where the source of the issue is expected.

Sogo has some cron scripts, one of which is:

# Vacation messages expiration 
# The credentials file should contain the sieve admin credentials 
(username:passwd) 
*/5 * * * *sogo/usr/bin/timeout 4m /usr/sbin/sogo-tool update-autoreply 
-p /etc/sogo/sieve.creds > /dev/null 2>&1

Aparently this runs every 5 minutes and uses the master user via 'sieve.creds'.

Further more the 'test2' user is no longer an existing user in the LDAP 
(Samba4) OU for users. This test-user simulates somebody who has left the 
company.

Since the test2 user is not explicitely removed from sogo, it still has a sogo 
profile in the database (postgresql). 

How can I prevent 'sogo-tool update-autoreply' from going over past users? 

My suggestion would be to remove its user profile completely, what is the 
command to do so?

Or is there a better solution to this issue?

I did find 'sogo-tool remove ' in the documentation, it states: "Remove 
all folders (Calendar and Address Book) and Preference settings of a user.". I 
guess this is not equal to: "remove user from database", or is it?

 

- Kees,

 

RE: [SOGo] BTS activities for Monday, November 27 2023

[qhivert]

I've reopened your ticket https://bugs.sogo.nu/view.php?id=5902

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Bits 'n Tricks
Sent: jeudi 30 novembre 2023 15:30
To: users@sogo.nu
Subject: Re: [SOGo] BTS activities for Monday, November 27 2023

Hi,

what should I do now? I cannot add to the bug report. utf8mb4_0900_ai_ci is not 
a supported collation in MariaDB server,

thanks,

---
Met Vriendelijke Groet,
Kind Regards,
Salutations,


Bart Coninckx
Bits 'n Tricks

On 28/11/2023 16:58, smizr...@alinto.eu wrote:
> Hi,
> 
> Can you p​lease use bug tracker's ticket instead of mailing list 
> and try nightly build ?
> 
> Sebastien
> 
> Le Mardi, Novembre 28, 2023 16:39 CET, "Bits 'n Tricks"
> (i...@bitsandtricks.com)  a écrit:
> 
>> The proposed alteration of the collation does not wirk with me:
>> 
>> ERROR 1273 (HY000): Unknown collation: 'utf8mb4_0900_ai_ci'
>> 
>> ---
>> Met Vriendelijke Groet,
>> Kind Regards,
>> Salutations,
>> 
>> Bart Coninckx
>> Bits 'n Tricks
>> 
>> On 28/11/2023 06:00, SOGo reporter wrote:
>>> BTS ACTIVITIES
>>> 
>>> Home page: https://bugs.sogo.nu
>>> Project: SOGo
>>> For the period covering: Monday, November 27 2023
>>> 
>>> ID
>>> LAST UPDATE
>>> STATUS (RESOLUTION)
>>> CATEGORY
>>> SUMMARY
>>> 
>>> 5846 [1]
>>> 2023-11-27 10:01:20
>>> updated (open)
>>> GUI
>>> passwordRecovery via Email with OpenLDAP server 2.5 fails because 
>>> sending old new to Ldap
>>> 
>>> 5902 [2]
>>> 2023-11-27 16:00:22
>>> resolved (fixed)
>>> Backend General
>>> 501 error after a short while
>>> 
>>> 
>>> 
>>> Links:
>>> --
>>> [1] https://bugs.sogo.nu/view.php?id=5846
>>> [2] https://bugs.sogo.nu/view.php?id=5902

RE: [SOGo] 501 error

[qhivert]

Hello,
I’ve enabled your account. You should be able to open an issue now.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Bits 'n Tricks
Sent: mercredi 22 novembre 2023 15:17
To: users@sogo.nu
Subject: Re: [SOGo] 501 error

Hi,

I created an account (username bcnx), cheers!

---
Met Vriendelijke Groet,
Kind Regards,
Salutations,


Bart Coninckx
Bits 'n Tricks

Hoge Mierdse Heide 182
2360 Oud-Turnhout
gsm +32 478 88 33 08
i...@bitsandtricks.com
Cybersecurity: https://www.bntsecurity.com
Infrastructure: https://www.bitsandtricks.com House rental: 
https://www.bntrent.com Creative Technology: https://www.bntdesign.eu Music 
Production: https://www.controversial.eu

BTW: BE0817.401.875
KBC IBAN: BE77 7360 1739 9642 BIC-CODE: KREDBEBB Voor onze Algemene 
Voorwaarden, zie: 
http://www.bitsandtricks.com/index.php/contact/algemene-voorwaarden

On 22/11/2023 09:14, qhivert wrote:
> Hello,
> 
> Nothing wrong when I put the same data as you in a user. Could you 
> open an issue in https://bugs.sogo.nu/ ?
> If you don't have an account yet, you'll need to create it and notify 
> me so I can enable it.
> 
> Quentin
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of Bits 
> 'n Tricks
> Sent: lundi 20 novembre 2023 18:42
> To: users@sogo.nu
> Subject: Re: [SOGo] 501 error
> 
> Hi,
> 
> see attachment,
> 
> ---
> Met Vriendelijke Groet,
> Kind Regards,
> Salutations,
> 
> 
> Bart Coninckx
> Bits 'n Tricks
> 
> 
> On 20/11/2023 17:06, qhivert wrote:
>> Hello,
>> Could you put the c_defaults value in a txt or json file? Because 
>> with Outlook hard to tell if the line return is in database or from 
>> outlook formatting.
>> 
>> Quentin
>> 
>> -Original Message-
>> From: users-requ...@sogo.nu  On Behalf Of Bits 
>> 'n Tricks
>> Sent: lundi 20 novembre 2023 15:33
>> To: users@sogo.nu
>> Subject: Re: [SOGo] 501 error
>> 
>> Sure:
>> 
>> c_uid: info
>> 
>> c_defaults:
>> {"SOGoMailLabelsColors":{"$mdnsent":["Ontvangstbewijs verzonden", 
>> "#006600"],"$label5":["Later", "#993399"],"$label2":["Werk", 
>> "#FF9900"],"$label4":["Te doen", 
>> "#FF"],"$forwarded":["Forwarded",
>> "#B01FE3"],"$label1":["Belangrijk",
>> "#FF"],"$label3":["Persoonlijk",
>> "#009900"]},"SOGoMailAutoSave":"5","SOGoTimeFormat":"%H:%M","SOGoMail
>> A ddOutgoingAddresses":0,"SOGoCalendarCategories":["Klant",
>> "Favorieten", "Kwesties", "Meeting", "Projecten", "Status", 
>> "Concurrentie", "Cliënten", "Zaken", "Vrije dagen", "Trouwdag", 
>> "Vervolggesprek", "Nationale feestdag", "Giften", "Reizen", 
>> "Diversen", "Persoonlijk", "Telefoongesprekken", "Verjaardag", 
>> "Ideeën", "Leveranciers", 
>> "Vakantie"],"SOGoCalendarDefaultReminder":"NONE","SOGoCalendarCategor
>> i 
>> esColors":{"Diversen":"#FA016D","Persoonlijk":"#0E197D","Favorieten":"
>> #0396FF","Zaken":"#623AA2","Vrije
>> dagen":"#F5","Vakantie":"#E80505","Ideeën":"#6018DC","Vervolggesp
>> r
>> ek":"#9708CC","Giften":"#E96D71","Cliënten":"#9F44D3","Kwesties":"#EA
>> 5
>> 455","Nationale
>> feestdag":"#736EFE","Telefoongesprekken":"#DE4313","Status":"#F6416C"
>> , 
>> "Klant":"#F8D800","Leveranciers":"#D939CD","Reizen":"#3677FF","Concur
>> r
>> entie":"#28C76F","Projecten":"#32CCBC","Trouwdag":"#8C1BAB","Meeting":
>> "#7367F0","Verjaardag":"#002661"},"SOGoPasswordRecoveryQuestion":"Sec
>> r 
>> etQuestion1","SOGoLoginModule":"Mail","SOGoDayStartTime":"08:00","SOG
>> o
>> CalendarWeekdays":["SU",
>> "MO", "TU", "WE", "TH", "FR",
&g

RE: [SOGo] 501 error

[qhivert]

Hello,

Nothing wrong when I put the same data as you in a user. Could you open an 
issue in https://bugs.sogo.nu/ ?
If you don't have an account yet, you'll need to create it and notify me so I 
can enable it.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Bits 'n Tricks
Sent: lundi 20 novembre 2023 18:42
To: users@sogo.nu
Subject: Re: [SOGo] 501 error

Hi,

see attachment,

---
Met Vriendelijke Groet,
Kind Regards,
Salutations,


Bart Coninckx
Bits 'n Tricks


On 20/11/2023 17:06, qhivert wrote:
> Hello,
> Could you put the c_defaults value in a txt or json file? Because with 
> Outlook hard to tell if the line return is in database or from outlook 
> formatting.
> 
> Quentin
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of Bits 
> 'n Tricks
> Sent: lundi 20 novembre 2023 15:33
> To: users@sogo.nu
> Subject: Re: [SOGo] 501 error
> 
> Sure:
> 
> c_uid: info
> 
> c_defaults:
> {"SOGoMailLabelsColors":{"$mdnsent":["Ontvangstbewijs verzonden", 
> "#006600"],"$label5":["Later", "#993399"],"$label2":["Werk", 
> "#FF9900"],"$label4":["Te doen", "#FF"],"$forwarded":["Forwarded",
> "#B01FE3"],"$label1":["Belangrijk",
> "#FF"],"$label3":["Persoonlijk",
> "#009900"]},"SOGoMailAutoSave":"5","SOGoTimeFormat":"%H:%M","SOGoMailA
> ddOutgoingAddresses":0,"SOGoCalendarCategories":["Klant",
> "Favorieten", "Kwesties", "Meeting", "Projecten", "Status", 
> "Concurrentie", "Cliënten", "Zaken", "Vrije dagen", "Trouwdag", 
> "Vervolggesprek", "Nationale feestdag", "Giften", "Reizen", 
> "Diversen", "Persoonlijk", "Telefoongesprekken", "Verjaardag", 
> "Ideeën", "Leveranciers", 
> "Vakantie"],"SOGoCalendarDefaultReminder":"NONE","SOGoCalendarCategori
> esColors":{"Diversen":"#FA016D","Persoonlijk":"#0E197D","Favorieten":"
> #0396FF","Zaken":"#623AA2","Vrije 
> dagen":"#F5","Vakantie":"#E80505","Ideeën":"#6018DC","Vervolggespr
> ek":"#9708CC","Giften":"#E96D71","Cliënten":"#9F44D3","Kwesties":"#EA5
> 455","Nationale 
> feestdag":"#736EFE","Telefoongesprekken":"#DE4313","Status":"#F6416C",
> "Klant":"#F8D800","Leveranciers":"#D939CD","Reizen":"#3677FF","Concurr
> entie":"#28C76F","Projecten":"#32CCBC","Trouwdag":"#8C1BAB","Meeting":
> "#7367F0","Verjaardag":"#002661"},"SOGoPasswordRecoveryQuestion":"Secr
> etQuestion1","SOGoLoginModule":"Mail","SOGoDayStartTime":"08:00","SOGo
> CalendarWeekdays":["SU",
> "MO", "TU", "WE", "TH", "FR",
> "SA"],"SOGoCalendarTasksDefaultClassification":"PUBLIC","SOGoTimeZone"
> :"GMT+1","SOGoPasswordRecoveryMode":"Disabled","SOGoRefreshViewCheck":
> "manually","SOGoLanguage":"Dutch","SOGoAnimationMode":"normal","SOGoMa
> ilSignaturePlacement":"below","SOGoSelectedAddressBook":"collected","S
> OGoContactsCategories":["Collega",
> "Concurrent", "Familie", "Klant", "Leverancier", "Pers", "VIP", 
> "Vriend", 
> "Zakenrelatie"],"SOGoShortDateFormat":"%d-%b-%y","SOGoFirstWeekOfYear"
> :"January1","SOGoDefaultCalendar":"selected","SOGoFirstDayOfWeek":0,"S
> OGoAlternateAvatar":"none","SOGoTOTPEnabled":0,"SOGoCalendarEventsDefa
> ultClassification":"PUBLIC","SOGoMailComposeMessageType":"html","SOGoG
> ravatarEnabled":0,"SOGoLongDateFormat":"%A,
> %B %d,
> %Y","SOGoMailDisplayRemoteInlineImages":"never","SOGoMailAutoMarkAsRea
> dD

RE: [SOGo] 501 error

[qhivert]

Hello,
Could you put the c_defaults value in a txt or json file? Because with Outlook 
hard to tell if the line return is in database or from outlook formatting.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Bits 'n Tricks
Sent: lundi 20 novembre 2023 15:33
To: users@sogo.nu
Subject: Re: [SOGo] 501 error

Sure:

c_uid: info

c_defaults:
{"SOGoMailLabelsColors":{"$mdnsent":["Ontvangstbewijs verzonden", 
"#006600"],"$label5":["Later", "#993399"],"$label2":["Werk", 
"#FF9900"],"$label4":["Te doen", "#FF"],"$forwarded":["Forwarded",
"#B01FE3"],"$label1":["Belangrijk", "#FF"],"$label3":["Persoonlijk",
"#009900"]},"SOGoMailAutoSave":"5","SOGoTimeFormat":"%H:%M","SOGoMailAddOutgoingAddresses":0,"SOGoCalendarCategories":["Klant",
"Favorieten", "Kwesties", "Meeting", "Projecten", "Status", "Concurrentie", 
"Cliënten", "Zaken", "Vrije dagen", "Trouwdag", "Vervolggesprek", "Nationale 
feestdag", "Giften", "Reizen", "Diversen", "Persoonlijk", "Telefoongesprekken", 
"Verjaardag", "Ideeën", "Leveranciers", 
"Vakantie"],"SOGoCalendarDefaultReminder":"NONE","SOGoCalendarCategoriesColors":{"Diversen":"#FA016D","Persoonlijk":"#0E197D","Favorieten":"#0396FF","Zaken":"#623AA2","Vrije
dagen":"#F5","Vakantie":"#E80505","Ideeën":"#6018DC","Vervolggesprek":"#9708CC","Giften":"#E96D71","Cliënten":"#9F44D3","Kwesties":"#EA5455","Nationale
feestdag":"#736EFE","Telefoongesprekken":"#DE4313","Status":"#F6416C","Klant":"#F8D800","Leveranciers":"#D939CD","Reizen":"#3677FF","Concurrentie":"#28C76F","Projecten":"#32CCBC","Trouwdag":"#8C1BAB","Meeting":"#7367F0","Verjaardag":"#002661"},"SOGoPasswordRecoveryQuestion":"SecretQuestion1","SOGoLoginModule":"Mail","SOGoDayStartTime":"08:00","SOGoCalendarWeekdays":["SU",
"MO", "TU", "WE", "TH", "FR",
"SA"],"SOGoCalendarTasksDefaultClassification":"PUBLIC","SOGoTimeZone":"GMT+1","SOGoPasswordRecoveryMode":"Disabled","SOGoRefreshViewCheck":"manually","SOGoLanguage":"Dutch","SOGoAnimationMode":"normal","SOGoMailSignaturePlacement":"below","SOGoSelectedAddressBook":"collected","SOGoContactsCategories":["Collega",
"Concurrent", "Familie", "Klant", "Leverancier", "Pers", "VIP", "Vriend", 
"Zakenrelatie"],"SOGoShortDateFormat":"%d-%b-%y","SOGoFirstWeekOfYear":"January1","SOGoDefaultCalendar":"selected","SOGoFirstDayOfWeek":0,"SOGoAlternateAvatar":"none","SOGoTOTPEnabled":0,"SOGoCalendarEventsDefaultClassification":"PUBLIC","SOGoMailComposeMessageType":"html","SOGoGravatarEnabled":0,"SOGoLongDateFormat":"%A,
%B %d,
%Y","SOGoMailDisplayRemoteInlineImages":"never","SOGoMailAutoMarkAsReadDelay":0,"SOGoMailComposeFontSize":0,"SOGoMailMessageForwarding":"inline","SOGoMailReplyPlacement":"below","SOGoDayEndTime":"18:00"}

c_settings:
{"Calendar":{"SelectedList":"eventsListView","FoldersOrder":["personal"],"EventsFilterState":"view_next7","EventsSortingState":["start",
"1"],"View":"weekview"},"Mail":{"folderForExpunge":"imap://info@localhost/INBOX/"}}


---
Met Vriendelijke Groet,
Kind Regards,
Salutations,


Bart Coninckx
Bits 'n Tricks


On 20/11/2023 08:47, smizr...@alinto.eu wrote:
> Can you provide the content of the sogo_user_profile table for the
> user when the problem occurs ?
> 
> Sebastien
> 
> Le Samedi, Novembre 18, 2023 17:44 CET, "Bits 'n Tricks"
> (i...@bitsandtricks.com)  a écrit:
> 
>> I should add my config:
>> 
>> {
>> SOGoProfileURL =
>> "mysql://sogo:hidden@localhost:3306/sogo/sogo_user_profile";
>> OCSFolderInfoURL =
>> "mysql://sogo:hidden@localhost:3306/sogo/sogo_folder_info";
>> OCSSessionsFolderURL =
>> "mysql://sogo:hiddenƒ@localhost:3306/sogo/sogo_sessions_folder";
>> //OCSEMailAlarmsFolderURL =
>> "postgresql://sogo:password@127.0.0.1:5432/sogo/sogo_alarms_folder";
>> SOGoLanguage = English;
>> SOGoAppointmentSendEMailNotifications = YES;
>> SOGoMailingMechanism = smtp;
>> SOGoSMTPServer = 127.0.0.1;
>> SOGoTimeZone = GMT+1;
>> SOGoSentFolderName = Sent;
>> SOGoTrashFolderName = Trash;
>> SOGoDraftsFolderName = Drafts;
>> SOGoIMAPServer = "imap://localhost:143/?tls=NO";
>> SOGoSieveServer = "sieve://localhost:4190/?tls=YES";
>> SOGoIMAPAclConformsToIMAPExt = YES;
>> SOGoVacationEnabled = NO;
>> SOGoForwardEnabled = NO;
>> SOGoSieveScriptsEnabled = NO;
>> SOGoFirstDayOfWeek = 0;
>> SOGoMailMessageCheck = manually;
>> SOGoMailAuxiliaryUserAccountsEnabled = NO;
>> SOGoMemcachedHost = 127.0.0.1;
>> //SOGoSuperUsernames = (admin);
>> SOGoUserSources =
>> (
>> {
>> type = sql;
>> id = users;
>> viewURL = "mysql://sogo:hidden@127.0.0.1:3306/sogo/sogo_users";
>> canAuthenticate = YES;
>> isAddressBook = NO;
>> userPasswordAlgorithm = md5;
>> }
>> );
>> }
>> 
>> ---
>> Met Vriendelijke Groet,
>> Kind Regards,
>> Salutations,
>> 
>> Bart Coninckx
>> Bits 'n Tricks
>> 
>> On 18/11/2023 14:49, Bits 'n Tricks wrote:
>>> Hi all,
>>> 
>>> I installed SOGo by means of the packages in Debian 12. I used
>> MariaDB
>>> (MySQL) as the backend. After a while I get an 501 error and this
>> in
>>> the log file:
>>> 
>>> 2023-11-18 14:34:47.939 

RE: [SOGo] Sogo-tool documentation is available

[qhivert]

I’ve added the protection, it will be in the next nightly. The doc online will 
be updated with the next release.

 

https://github.com/Alinto/sogo/commit/bb943e414d3fc8b71ebb169e31c261cd2dcd6d37

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Frank Richter
Sent: jeudi 16 novembre 2023 11:43
To: users@sogo.nu
Subject: Re: [SOGo] Sogo-tool documentation is available

 

Am 02.11.23 um 17:30 schrieb qhivert (qhiv...@alinto.eu 
<mailto:qhiv...@alinto.eu> ):

 

The documentation of sogo-tool is finally available in our website here -> 
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_using_sogo_tool
You will find more details of each command and how to use them. The command 
sogo-tool alone will also print a link to this documentation.

Thanks, Quentin! It’s very useful for me.

I’d also find it useful to eleminate the dangerous bevaviour in 
sogo-tool expire-sessions  not_a_number   # remove all current session

This should really print a usage information instead of removing all …

Shall I open a featere enhancement for this?

Regards,
Frank

 

-- 
Frank Richter, Chemnitz University of Technology, Germany

RE: [SOGo] NSCalendarDate - invalid day given

[qhivert]

Hello,
Better late than never, this has been fixed in the next nightly, you shouldn't 
see this log anymore.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of qhivert
Sent: jeudi 12 octobre 2023 14:35
To: users@sogo.nu
Subject: RE: [SOGo] NSCalendarDate - invalid day given

The log format is normal as it is a log from GNUStep library and not from Sogo 
You can find it here -> 
https://github.com/gnustep/libs-base/blob/f0f841c01f24ec6f118a97a4b0f3618d13d530fa/Source/NSCalendarDate.m#L1553

I'll let you know when I'll fix this. I have to investigate because I made that 
commit to fix a bug that wad indeed fixed, so I have to check if the bug is not 
back again when correcting this warning.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Dirk Schäfer
Sent: jeudi 12 octobre 2023 14:06
To: qhivert (qhiv...@alinto.eu) 
Subject: Re: [SOGo] NSCalendarDate - invalid day given

Hi,

thx for the replies so far.

- "sogo-tool checkup" does not identify misconstructed events
- fortunately no data loss found yet

There is something odd about the log format on that specific kinds of entries.

The "invalid day given" entries have a prefix like
2023-10-12 10:55:19.204 sogod[1335:1335] File NSCalendarDate.m: 1553. In ...

The standard log entries have a prefix like Oct 12 10:55:20 sogod [1337]: IP 
"GET /SOGo/so/..."

=> the way the date is written differs.

No special debug log setting is active in /etc/sogo/sogo.conf

GCSFolderDebugEnabled = NO;
GCSFolderStoreDebugEnabled = NO;
LDAPDebugEnabled = NO;
MySQL4DebugEnabled = NO;
ImapDebugEnabled = NO;
SMTPDebugEnabled = NO;
OCSFolderManagerSQLDebugEnabled = NO;
SOGoDebugRequests = NO;
SOGoUIxDebugEnabled = NO;
SoDebugBaseURL = NO;
SoDebugObjectTraversal = NO;
SoSecurityManagerDebugEnabled = NO;
WODebugZipResponse = NO;
SOGoDebugLeaks = NO;
SOGoTnefDecoderDebugEnabled = NO;
WODebugHttpTransaction = NO;
WOPageRequestHandlerDebugEnabled = NO;
SoObjectRequestHandlerDebugEnabled = NO;

Dirk

Am 11.10.23 um 12:50 schrieb qhivert (qhiv...@alinto.eu):
> Ok I may have it:
> here ->
> https://github.com/Alinto/sogo/commit/f2df4056161a96da750cba4a083a05ce
> 1390ad55?diff=unified#diff-3b1c62e123667345d23ac0e2c410f68135e00e14545
> a3705c38d2529c7191209R190
> 
> I create new date with day = 0 to put the first day of the month but 
> day start at 1. I will make some tests
> 
> Quentin
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of 
> qhivert
> Sent: mercredi 11 octobre 2023 12:33
> To: users@sogo.nu
> Subject: RE: [SOGo] NSCalendarDate - invalid day given
> 
> Hello,
> 
> For this release there are some corrections for recurrent event. Apart this 
> log is anything normal or some events are missing or not correct?
> 
> Quentin
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of Dirk 
> Schäfer
> Sent: mercredi 11 octobre 2023 10:56
> To: users@sogo.nu
> Subject: [SOGo] NSCalendarDate - invalid day given
> 
> Hi,
> 
> since updating SOGo to version 5.9.0 we have MANY entries in sogo.log of the 
> form:
> 
> "sogod[2741:2741] File NSCalendarDate.m: 1553. In -[NSCalendarDate 
> initWithYear:month:day:hour:minute:second:timeZone:] invalid day given - 0"
> 
> Do you have an idea?
> 
> 

RE: [SOGo] Urgent Security Problem

[qhivert]

Hello Stefan,

Each mail of the mailing list is manually check by an admin. I think the mail 
you attached is flag as a virus because the person copy paste its sogo.conf 
with a lot of url to its database and an url to its own sogo serveur in http. 
But nothing to worry about.

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of "Stefan 
Kladler"
Sent: mardi 7 novembre 2023 20:42
To: users@sogo.nu
Subject: [SOGo] Urgent Security Problem

 

 
Hello,
 i am getting viruses via this mailing list

Please fix it 
regards
Stefan
 

RE: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'

[qhivert]

I've updated the script with the correct value.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of qhivert
Sent: vendredi 3 novembre 2023 11:50
To: users@sogo.nu
Subject: RE: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'

Oh ok,
Maybe this script has not been updated with the correct length value then. I 
will check that.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Boguslaw Juza
Sent: vendredi 3 novembre 2023 11:46
To: users@sogo.nu
Subject: Re: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'

 Hi,

The comment from Scripts/mysql-utf8mb4.sql, from Sogo 5.9 dist:

-- This schema includes some specific table creation
-- parameters needed for complete Unicode coverage
-- (required for emoji character support, for instance).
--
-- Note: SOGo automagically creates those tables on start,
-- but *without* full Unicode compliance.  So this schema
-- must be imported before SOGo runs for the first time.

That's true, that SOGo could create this table dynamically, but there were 
problems with national characters in names.
So I've found this file and run it before SOGo first run.

Boguslaw Juza


W dniu 3.11.2023 o 11:21, qhivert (qhiv...@alinto.eu) pisze:
> Hello,
> Well, I don't know how exactly you build sogo but sogo create dynamically the 
> table with correct length. Look for:
> - (NSString *) createSessionsFolderWithName: (NSString *) tableName {
>static NSString *sqlFolderFormat
>  = (@"CREATE TABLE %@ ("
> @" c_id VARCHAR(255) PRIMARY KEY,"
> @" c_value VARCHAR(4096) NOT NULL,"
> @" c_creationdate INT NOT NULL,"
> @" c_lastseen INT NOT NULL)");
> 
>return [NSString stringWithFormat: sqlFolderFormat, tableName]; }
> 
> Once sogo is build, you don't need to run any script concerning the database 
> except if an older version of sogo was previously used.
> 
> Quentij
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of 
> Boguslaw Juza
> Sent: vendredi 3 novembre 2023 09:39
> To: users@sogo.nu
> Subject: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'
> 
>Hello :)
> 
> SOGo 5.9 installed from sources, RockyLinux9
> 
> SOGo kicks users after 5 min. of inactivity. The error notice apperars in the 
> log:
> 
> Nov 03 09:22:55 sogod [1682]: [ERROR] <...[GCSSessionsFolder]> 
> -[GCSSessionsFolder
> writeRecordForEntryWithID:value:creationDate:lastSeenDate:]: cannot 
> write record:  NAME:ExecutionFailed REASON:Data 
> too long for column 'c_value' at row 1
> 
> There is the database scheme in Scripts/mysql-utf8mb4.sql:
> 
> CREATE TABLE sogo_sessions_folder (
>   c_id   varchar(255) NOT NULL,
>   c_valuevarchar(255) NOT NULL,
>   c_creationdate int(11)  NOT NULL,
>   c_lastseen int(11)  NOT NULL,
>   PRIMARY KEY (c_id)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
> 
> I've increased c_value to varchar(4096), it solved the problem, and the data 
> stored in c_value is 2100 bytes long.
> 
> Is it the mistake in the instalation script or something went wrong while 
> compilation process?
> 
> 
>Boguslaw Juza
> 

RE: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'

[qhivert]

Oh ok,
Maybe this script has not been updated with the correct length value then. I 
will check that.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Boguslaw Juza
Sent: vendredi 3 novembre 2023 11:46
To: users@sogo.nu
Subject: Re: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'

 Hi,

The comment from Scripts/mysql-utf8mb4.sql, from Sogo 5.9 dist:

-- This schema includes some specific table creation
-- parameters needed for complete Unicode coverage
-- (required for emoji character support, for instance).
--
-- Note: SOGo automagically creates those tables on start,
-- but *without* full Unicode compliance.  So this schema
-- must be imported before SOGo runs for the first time.

That's true, that SOGo could create this table dynamically, but there were 
problems with national characters in names.
So I've found this file and run it before SOGo first run.

Boguslaw Juza


W dniu 3.11.2023 o 11:21, qhivert (qhiv...@alinto.eu) pisze:
> Hello,
> Well, I don't know how exactly you build sogo but sogo create dynamically the 
> table with correct length. Look for:
> - (NSString *) createSessionsFolderWithName: (NSString *) tableName {
>static NSString *sqlFolderFormat
>  = (@"CREATE TABLE %@ ("
> @" c_id VARCHAR(255) PRIMARY KEY,"
> @" c_value VARCHAR(4096) NOT NULL,"
> @" c_creationdate INT NOT NULL,"
> @" c_lastseen INT NOT NULL)");
> 
>return [NSString stringWithFormat: sqlFolderFormat, tableName]; }
> 
> Once sogo is build, you don't need to run any script concerning the database 
> except if an older version of sogo was previously used.
> 
> Quentij
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of 
> Boguslaw Juza
> Sent: vendredi 3 novembre 2023 09:39
> To: users@sogo.nu
> Subject: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'
> 
>Hello :)
> 
> SOGo 5.9 installed from sources, RockyLinux9
> 
> SOGo kicks users after 5 min. of inactivity. The error notice apperars in the 
> log:
> 
> Nov 03 09:22:55 sogod [1682]: [ERROR] <...[GCSSessionsFolder]> 
> -[GCSSessionsFolder
> writeRecordForEntryWithID:value:creationDate:lastSeenDate:]: cannot 
> write record:  NAME:ExecutionFailed REASON:Data 
> too long for column 'c_value' at row 1
> 
> There is the database scheme in Scripts/mysql-utf8mb4.sql:
> 
> CREATE TABLE sogo_sessions_folder (
>   c_id   varchar(255) NOT NULL,
>   c_valuevarchar(255) NOT NULL,
>   c_creationdate int(11)  NOT NULL,
>   c_lastseen int(11)  NOT NULL,
>   PRIMARY KEY (c_id)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
> 
> I've increased c_value to varchar(4096), it solved the problem, and the data 
> stored in c_value is 2100 bytes long.
> 
> Is it the mistake in the instalation script or something went wrong while 
> compilation process?
> 
> 
>Boguslaw Juza
> 

RE: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'

[qhivert]

Hello,
Well, I don't know how exactly you build sogo but sogo create dynamically the 
table with correct length. Look for:
- (NSString *) createSessionsFolderWithName: (NSString *) tableName
{
  static NSString *sqlFolderFormat
= (@"CREATE TABLE %@ (" 
   @" c_id VARCHAR(255) PRIMARY KEY,"
   @" c_value VARCHAR(4096) NOT NULL,"
   @" c_creationdate INT NOT NULL,"
   @" c_lastseen INT NOT NULL)");

  return [NSString stringWithFormat: sqlFolderFormat, tableName];
}

Once sogo is build, you don't need to run any script concerning the database 
except if an older version of sogo was previously used.

Quentij

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Boguslaw Juza
Sent: vendredi 3 novembre 2023 09:39
To: users@sogo.nu
Subject: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'

  Hello :)

SOGo 5.9 installed from sources, RockyLinux9

SOGo kicks users after 5 min. of inactivity. The error notice apperars in the 
log:

Nov 03 09:22:55 sogod [1682]: [ERROR] <...[GCSSessionsFolder]> 
-[GCSSessionsFolder
writeRecordForEntryWithID:value:creationDate:lastSeenDate:]: cannot write 
record:  NAME:ExecutionFailed REASON:Data too long for 
column 'c_value' at row 1

There is the database scheme in Scripts/mysql-utf8mb4.sql:

CREATE TABLE sogo_sessions_folder (
 c_id   varchar(255) NOT NULL,
 c_valuevarchar(255) NOT NULL,
 c_creationdate int(11)  NOT NULL,
 c_lastseen int(11)  NOT NULL,
 PRIMARY KEY (c_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

I've increased c_value to varchar(4096), it solved the problem, and the data 
stored in c_value is 2100 bytes long.

Is it the mistake in the instalation script or something went wrong while 
compilation process?


  Boguslaw Juza

[SOGo] Sogo-tool documentation is available

[qhivert]

Hello all,

 

The documentation of sogo-tool is finally available in our website here ->
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_using_sogo_tool
You will find more details of each command and how to use them. The command
sogo-tool alone will also print a link to this documentation.

I've checked the code and tested all the commands by myself to write it but
if you see any irregularities with your own experience, don't hesitate to
tell us.

Quentin

RE: [SOGo] DURATION and DTEND bug ?

[qhivert]

I've enabled it.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of 
gdelafond+sogo.nu
Sent: samedi 28 octobre 2023 01:03
To: users@sogo.nu
Subject: Re: [SOGo] DURATION and DTEND bug ?

I have created the account on the butcracker.
--
Guillaume

> On 28 Oct 2023, at 00:53, [AR] Guillaume de Lafond  
> wrote:
> 
> Hello,
> 
>> More than a bug it seems that's a case that sogo doesn't handle. iCalendar 
>> specs allow a lot of ics configurations, and it seems you found one that is 
>> not properly manage by sogo. The best would be that you open an issue on 
>> https://bugs.sogo.nu/ so we can follow and discuss this issue. If you don't 
>> have an account yet, create one but we have to enable it (we put this 
>> protection to avoid spam), so send an email here to notice me. In this 
>> issue, can you provide an ics so we can reproduce the problem?
> 
> Ok I’ll do that.
> 
>> Also, when you said: " I tested it with Thunderbird and Korganizer on linux 
>> and they accept it." Does at mean those accept the ics with both DURATION 
>> and DTEND or when you do the modification there, the ics is correctly 
>> changed?
> 
> They accept the ICS with both DURATION and DTEND.
> 
> 
> Guillaume

RE: [SOGo] DURATION and DTEND bug ?

[qhivert]

Hello,

More than a bug it seems that's a case that sogo doesn't handle. iCalendar 
specs allow a lot of ics configurations, and it seems you found one that is not 
properly manage by sogo. The best would be that you open an issue on 
https://bugs.sogo.nu/ so we can follow and discuss this issue. If you don't 
have an account yet, create one but we have to enable it (we put this 
protection to avoid spam), so send an email here to notice me. In this issue, 
can you provide an ics so we can reproduce the problem?
Also, when you said: " I tested it with Thunderbird and Korganizer on linux and 
they accept it." Does at mean those accept the ics with both DURATION and DTEND 
or when you do the modification there, the ics is correctly changed?

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of 
gdelafond+sogo.nu
Sent: jeudi 26 octobre 2023 11:18
To: users@sogo.nu
Subject: [SOGo] DURATION and DTEND bug ?

Hello,

Summary: We have a problem when modifying an ICS that contains “DURATION=“.

We have a cal.com instance that is connected to a SOGo caldav server. 
cal.com create events in SOGo calendars with DTSTART & DURATION options.

If we modify the event in SOGo (to add an additional attendee), SOGo adds 
“DTEND” in the ICS but doesn't remove the “DURATION".

At the end, the ICS contains DURATION and DTEND, but the rfc5546 says : 
|   DTEND| 0 or 1   | If present, DURATION MUST NOT be  present
|   DURATION  | 0 or 1   | If present, DTEND MUST NOT be  present

When the ICS contains DTEND & DURATION, the event is not visible on Apple 
Calendar.app (via the caldav connection) and the ICS cannot be manually 
imported (On macOS 13.6, Calendar.app says "No event was added. No valid events 
were found to add to your calendar.").

I tested it with Thunderbird and Korganizer on linux and they accept it.

I think it is a SOGo bug, isn’ t it ?

Thank you.

Regards,
-- 
Guillaume

RE: [SOGo] NSCalendarDate - invalid day given

[qhivert]

The log format is normal as it is a log from GNUStep library and not from Sogo
You can find it here -> 
https://github.com/gnustep/libs-base/blob/f0f841c01f24ec6f118a97a4b0f3618d13d530fa/Source/NSCalendarDate.m#L1553

I'll let you know when I'll fix this. I have to investigate because I made that 
commit to fix a bug that wad indeed fixed, so I have to check if the bug is not 
back again when correcting this warning.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Dirk Schäfer
Sent: jeudi 12 octobre 2023 14:06
To: qhivert (qhiv...@alinto.eu) 
Subject: Re: [SOGo] NSCalendarDate - invalid day given

Hi,

thx for the replies so far.

- "sogo-tool checkup" does not identify misconstructed events
- fortunately no data loss found yet

There is something odd about the log format on that specific kinds of entries.

The "invalid day given" entries have a prefix like
2023-10-12 10:55:19.204 sogod[1335:1335] File NSCalendarDate.m: 1553. In ...

The standard log entries have a prefix like Oct 12 10:55:20 sogod [1337]: IP 
"GET /SOGo/so/..."

=> the way the date is written differs.

No special debug log setting is active in /etc/sogo/sogo.conf

GCSFolderDebugEnabled = NO;
GCSFolderStoreDebugEnabled = NO;
LDAPDebugEnabled = NO;
MySQL4DebugEnabled = NO;
ImapDebugEnabled = NO;
SMTPDebugEnabled = NO;
OCSFolderManagerSQLDebugEnabled = NO;
SOGoDebugRequests = NO;
SOGoUIxDebugEnabled = NO;
SoDebugBaseURL = NO;
SoDebugObjectTraversal = NO;
SoSecurityManagerDebugEnabled = NO;
WODebugZipResponse = NO;
SOGoDebugLeaks = NO;
SOGoTnefDecoderDebugEnabled = NO;
WODebugHttpTransaction = NO;
WOPageRequestHandlerDebugEnabled = NO;
SoObjectRequestHandlerDebugEnabled = NO;

Dirk

Am 11.10.23 um 12:50 schrieb qhivert (qhiv...@alinto.eu):
> Ok I may have it:
> here -> 
> https://github.com/Alinto/sogo/commit/f2df4056161a96da750cba4a083a05ce
> 1390ad55?diff=unified#diff-3b1c62e123667345d23ac0e2c410f68135e00e14545
> a3705c38d2529c7191209R190
> 
> I create new date with day = 0 to put the first day of the month but 
> day start at 1. I will make some tests
> 
> Quentin
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of 
> qhivert
> Sent: mercredi 11 octobre 2023 12:33
> To: users@sogo.nu
> Subject: RE: [SOGo] NSCalendarDate - invalid day given
> 
> Hello,
> 
> For this release there are some corrections for recurrent event. Apart this 
> log is anything normal or some events are missing or not correct?
> 
> Quentin
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of Dirk 
> Schäfer
> Sent: mercredi 11 octobre 2023 10:56
> To: users@sogo.nu
> Subject: [SOGo] NSCalendarDate - invalid day given
> 
> Hi,
> 
> since updating SOGo to version 5.9.0 we have MANY entries in sogo.log of the 
> form:
> 
> "sogod[2741:2741] File NSCalendarDate.m: 1553. In -[NSCalendarDate 
> initWithYear:month:day:hour:minute:second:timeZone:] invalid day given - 0"
> 
> Do you have an idea?
> 
> 

RE: [SOGo] NSCalendarDate - invalid day given

[qhivert]

Ok I may have it:
here -> 
https://github.com/Alinto/sogo/commit/f2df4056161a96da750cba4a083a05ce1390ad55?diff=unified#diff-3b1c62e123667345d23ac0e2c410f68135e00e14545a3705c38d2529c7191209R190

I create new date with day = 0 to put the first day of the month but day start 
at 1. I will make some tests

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of qhivert
Sent: mercredi 11 octobre 2023 12:33
To: users@sogo.nu
Subject: RE: [SOGo] NSCalendarDate - invalid day given

Hello,

For this release there are some corrections for recurrent event. Apart this log 
is anything normal or some events are missing or not correct?

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Dirk Schäfer
Sent: mercredi 11 octobre 2023 10:56
To: users@sogo.nu
Subject: [SOGo] NSCalendarDate - invalid day given

Hi,

since updating SOGo to version 5.9.0 we have MANY entries in sogo.log of the 
form:

"sogod[2741:2741] File NSCalendarDate.m: 1553. In -[NSCalendarDate 
initWithYear:month:day:hour:minute:second:timeZone:] invalid day given - 0"

Do you have an idea?

RE: [SOGo] NSCalendarDate - invalid day given

[qhivert]

Hello,

For this release there are some corrections for recurrent event. Apart this log 
is anything normal or some events are missing or not correct?

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Dirk Schäfer
Sent: mercredi 11 octobre 2023 10:56
To: users@sogo.nu
Subject: [SOGo] NSCalendarDate - invalid day given

Hi,

since updating SOGo to version 5.9.0 we have MANY entries in sogo.log of the 
form:

"sogod[2741:2741] File NSCalendarDate.m: 1553. In -[NSCalendarDate 
initWithYear:month:day:hour:minute:second:timeZone:] invalid day given - 0"

Do you have an idea?

RE: [SOGo] SOGo 5.9.0 could not load product

[qhivert]

Hello,
I'v tried on rocky linux 9 and it worked fine. Did you add ytnef to the exclude 
list of epel repo to use the ones delivered by sogo instead ?

sed -i '/enabled=1/a exclude=gnustep ytnef' /etc/yum.repos.d/epel.repo

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Boguslaw Juza
Sent: dimanche 8 octobre 2023 11:08
To: users@sogo.nu
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

W dniu 8.10.2023 o 09:37, Bogusław Juza pisze:
> Additional information appears, when SOGo is going down:
> Error (objc-load):/usr/local/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: 
> undefined symbol: TNEFParseMemory

I've added "-lytnef" in BUNDLE_LIBS in file 
SOGo-5.9.0/SoObjects/Mailer/GNUmakefile.preamble

It resolved the issue.

  Bogusław Juza

RE: [SOGo] sogod: error while loading shared libraries: libgnustep-base.so.1.24: cannot open shared object file: No such file or directory

[qhivert]

Hello Philippe,
I’ve updated your account on https://bugs.sogo.nu you should be able to open an 
issue now.

 

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of "Philippe 
Eveleigh"
Sent: dimanche 8 octobre 2023 23:31
To: users@sogo.nu
Subject: Re: [SOGo] sogod: error while loading shared libraries: 
libgnustep-base.so.1.24: cannot open shared object file: No such file or 
directory

 

Thanks Marco M. for the quick reply. I do not need version 1.24 anymore. I 
created a user for filling a bug as you suggested but my profile is locked as a 
viewer? So I am hoping that someone on the support team at: 
https://bugs.sogo.nu/login_page.php will see this thread.

Thank you again Marco

On Sunday, October 08, 2023 14:40 EDT, "\"Marco M.\"" (mm+s...@dorfdsl.de 
 ) mailto:users@sogo.nu> > wrote:
 


Am 08.10.2023 um 12:30:59 Uhr schrieb "Philippe Eveleigh":

> [root@penmail ~]# ldd -r /usr/sbin/sogod | grep gnustep
>   libgnustep-base.so.1.28 => /lib64/libgnustep-base.so.1.28
> (0x7f6218c0)
> libgnustep-base.so.1.24 => not found

As long as that is linked to 1.24, it will break. Does you distribution
also offer that old version?
If not, you can't do anything about it and SOGo must be fixed to not
link against that version for RHEL9.
 


 

RE: [SOGo] Deprecated calls in sogo-tool

[qhivert]

Hello,
Sorry I didn't reply earlier and thank you for reporting.
We are aware of this and we're already making test without this constant.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Christian Mack
Sent: jeudi 5 octobre 2023 13:49
To: users@sogo.nu
Subject: Re: [SOGo] Deprecated calls in sogo-tool

Hello

You should open a bug report for this at https://bugs.sogo.nu/


Kind regards,
Christian Mack

Am 02.10.23 um 16:21 schrieb "Juppers" (s...@dahanga.org):
> I've noticed this for a while, but hoped it would have been corrected with the
> release of 5.9.
> Since it is still showing up in my logs, I figured I should share to the list.
> 
> sogo-tool backup /tmp ALL
> WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future
> version.
> <0x0x561a55b88260[SOGoCache]> Cache cleanup interval set every 300.00
> seconds
> <0x0x561a55b88260[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
> WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future
> version.
> WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future
> version.
> WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future
> version.
> WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future
> version.
> WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future
> version.

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

RE: [SOGo] documentation for sogo-tool

[qhivert]

Of I forgot for setting instead of putting the value in the command line you
can write the json in a file and do:
sogo-tool user-preferences set defaults  Forward -f  -p


Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of qhivert
Sent: jeudi 5 octobre 2023 15:38
To: users@sogo.nu
Subject: RE: [SOGo] documentation for sogo-tool

I see, as the doc is not yet ready, I will explain it:

To see if a user has a forwarding rule:
sogo-tool user-preferences get defaults  Forward
result:
Forward:
{"forwardAddress":["sogo-tests2@sogo.alinto"],"enabled":1,"keepCopy":1}
Or can be:
Value for key "Forward" not found in defaults If Forward have never been
set.

-

To unset a forwarding rule:
sogo-tool user-preferences unset defaults  Forward -p 

credfile is a simple one-line file that contains "username:password" of an
admin account of your imap/cyrus server.

-

To set a forwarding rule:
sogo-tool user-preferences set defaults  Forward  -p


values is a json-string as such:
 
{"forwardAddress":["sogo-tests2@sogo.alinto"],"enabled":1,"keepCopy":1,"alwa
ysSend":1}
* forwardAddress: string array of mails where to forward to
* enables: 0/1, 1 to enable 0 to disable the rule
* keepCopy: 0/1, 1 to keep a copy, 0 to not
* alwaysSend: 0/1, 1 to put the forwarding rule at the top of you sieve
script (so no other filters will be applied before), 0 to put it at the
bottom.
keepCopy and alwaysSend are optional cand will be 0 if missing.

Example:
sogo-tool user-preferences set defaults sogo-tests1 Forward
'{"forwardAddress":["sogo-tests2@sogo.alinto"],"enabled":1,"keepCopy":0}' -p
cred

-

Voilà! I've test it on my machine but let me know if you have trouble with
it or if there is unexpected behavior. The order of arguments is very
important.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Marco
Sent: jeudi 5 octobre 2023 13:48
To: users@sogo.nu
Subject: Re: [SOGo] documentation for sogo-tool

Am 05.10.2023 schrieb "qhivert" (qhiv...@alinto.eu) :

> There is no documentation yet but it's in our short todo list.
> For now, you can have more information for each command by typing:
> sogo-tool 
> without any arguments.

Thanks for that suggestion, but that doesn't display all options.

[root@sogo ~]# sogo-tool user-preferences user-preferences get|set|unset
defaults|settings user [-p credentialFile] key [value|-f filename]

 user  the user of whom to set the defaults/settings
 key/value value the JSON-formatted value of the key

  -p credentialFileSpecify the file containing the sieve admin
  credentials The file should contain a single line:
 username:password
  Examples:
   sogo-tool user-preferences get defaults janedoe SOGoLanguage
   sogo-tool user-preferences unset settings janedoe Mail
   sogo-tool user-preferences set defaults janedoe SOGoTimeFormat
   '{"SOGoTimeFormat":"%I:%M %p"}'

I am interested in changing the forwarding rules via sogo-tool.

RE: [SOGo] documentation for sogo-tool

[qhivert]

I see, as the doc is not yet ready, I will explain it:

To see if a user has a forwarding rule:
sogo-tool user-preferences get defaults  Forward
result:
Forward:
{"forwardAddress":["sogo-tests2@sogo.alinto"],"enabled":1,"keepCopy":1}
Or can be:
Value for key "Forward" not found in defaults
If Forward have never been set.

-

To unset a forwarding rule:
sogo-tool user-preferences unset defaults  Forward -p 

credfile is a simple one-line file that contains "username:password" of an
admin account of your imap/cyrus server.

-

To set a forwarding rule:
sogo-tool user-preferences set defaults  Forward  -p


values is a json-string as such:
 
{"forwardAddress":["sogo-tests2@sogo.alinto"],"enabled":1,"keepCopy":1,"alwa
ysSend":1}
* forwardAddress: string array of mails where to forward to
* enables: 0/1, 1 to enable 0 to disable the rule
* keepCopy: 0/1, 1 to keep a copy, 0 to not
* alwaysSend: 0/1, 1 to put the forwarding rule at the top of you sieve
script (so no other filters will be applied before), 0 to put it at the
bottom.
keepCopy and alwaysSend are optional cand will be 0 if missing.

Example:
sogo-tool user-preferences set defaults sogo-tests1 Forward
'{"forwardAddress":["sogo-tests2@sogo.alinto"],"enabled":1,"keepCopy":0}' -p
cred

-

Voilà! I've test it on my machine but let me know if you have trouble with
it or if there is unexpected behavior. The order of arguments is very
important.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Marco
Sent: jeudi 5 octobre 2023 13:48
To: users@sogo.nu
Subject: Re: [SOGo] documentation for sogo-tool

Am 05.10.2023 schrieb "qhivert" (qhiv...@alinto.eu) :

> There is no documentation yet but it's in our short todo list.
> For now, you can have more information for each command by typing:
> sogo-tool 
> without any arguments.

Thanks for that suggestion, but that doesn't display all options.

[root@sogo ~]# sogo-tool user-preferences user-preferences get|set|unset
defaults|settings user [-p credentialFile] key [value|-f filename]

 user  the user of whom to set the defaults/settings
 key/value value the JSON-formatted value of the key

  -p credentialFileSpecify the file containing the sieve admin
  credentials The file should contain a single line:
 username:password
  Examples:
   sogo-tool user-preferences get defaults janedoe SOGoLanguage
   sogo-tool user-preferences unset settings janedoe Mail
   sogo-tool user-preferences set defaults janedoe SOGoTimeFormat
   '{"SOGoTimeFormat":"%I:%M %p"}'

I am interested in changing the forwarding rules via sogo-tool.

RE: [SOGo] documentation for sogo-tool

[qhivert]

Hello Marco,

There is no documentation yet but it's in our short todo list.
For now, you can have more information for each command by typing:
sogo-tool 
without any arguments.

Example:
root@de4b8c9d9ab1:/src/SOGo# sogo-tool backup
backup directory ALL|user1 [user2] ...

   directory  the target directory where backup files will be stored
   user   the user of whom to save the data or ALL for everybody

Example:   sogo-tool backup /tmp/foo ALL

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Marco Moock
Sent: jeudi 5 octobre 2023 11:50
To: users@sogo.nu
Subject: [SOGo] documentation for sogo-tool

Hello!

I cannot find documentation for sogo-tool. -h exists, but doesn't list the
options for user-preferences.
A manpage doesn't exist.

Is there a place where the arguments are all documented?

--
kind regards
Marco Moock

RE: [SOGo] v5.9.0 on Demo Servers?

[qhivert]

Ok done!
I don't know why the cron didn't run.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of qhivert
Sent: vendredi 29 septembre 2023 09:01
To: users@sogo.nu
Subject: RE: [SOGo] v5.9.0 on Demo Servers?

Hello,
It shouldn't be. I'm looking into it.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of nsclick
Sent: vendredi 29 septembre 2023 07:56
To: users@sogo.nu
Subject: [SOGo] v5.9.0 on Demo Servers?

Hi,

SOGo v5.9.0 was released on September, 27th, but the demo servers on sogo.nu 
are still running v5.8.4. Is there an update planned soon?

Thanks.

RE: [SOGo] v5.9.0 on Demo Servers?

[qhivert]

Hello,
It shouldn't be. I'm looking into it.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of nsclick
Sent: vendredi 29 septembre 2023 07:56
To: users@sogo.nu
Subject: [SOGo] v5.9.0 on Demo Servers?

Hi,

SOGo v5.9.0 was released on September, 27th, but the demo servers on sogo.nu 
are still running v5.8.4. Is there an update planned soon?

Thanks.

RE: [SOGo] Bugtracker is broken

[qhivert]

Ok I found out what the problem is, but I don't know why this is problem.
It just because in your description of your issue you write an arrow like
this:
-->
And I don't know why but the double hyphen raise a nerror with apache:
Apache-Error: [file "apache2_util.c"] [line 273] [level 3] [client
212.186.223.9] ModSecurity: Access denied with code 44 (phase 2). Match of
"eq 0" against "MULTIPART_UNMATCHED_BOUNDARY" required. [file
"/etc/httpd/conf.d/mod_security.conf"] [line "30"] [id "23"] [msg
"Multipart parser detected a possible unmatched boundary."] [hostname
"bugs.sogo.nu"] [uri "/bug_report.php"]
Apache-Error: [file "http_request.c"] [line 107] [level 3] AH01579: Invalid
response status 44

Without the arrow/double hyphen no problem. So I suggest you to do that for
now. Meanwhile I will try to understand what happens

Quentin


-Original Message-
From: users-requ...@sogo.nu  On Behalf Of qhivert
Sent: vendredi 15 septembre 2023 10:31
To: users@sogo.nu
Subject: RE: [SOGo] Bugtracker is broken

Well, nothing wrong with me. What is your account?

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of "Ludwig
Ertl"
Sent: jeudi 14 septembre 2023 20:14
To: users@sogo.nu
Subject: [SOGo] Bugtracker is broken

Hi,

When trying to send a bug report to the bugtracker under
https://bugs.sogo.nu, I always receive 500 - Internal server error.
Please fix. Thanks.

Best regards,
L. Ertl

RE: [SOGo] Bugtracker is broken

[qhivert]

Well, nothing wrong with me. What is your account?

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of "Ludwig
Ertl"
Sent: jeudi 14 septembre 2023 20:14
To: users@sogo.nu
Subject: [SOGo] Bugtracker is broken

Hi,

When trying to send a bug report to the bugtracker under
https://bugs.sogo.nu, I always receive 500 - Internal server error.
Please fix. Thanks.

Best regards,
L. Ertl

RE: [SOGo] BUG: Pressing ò char in the Recipient bar

[qhivert]

Hello,
Yes, we are aware of that issue. We have the same problem with german keyboard 
and the letter ü with chrome. The angularJs material used by sogo uses a 
deprecated method to know which keyboard button was hit based on key_code 
instead of directly using the character. The key_code depends of your keyboard 
layout and the browser!
So, with the ü and chrome, sogo receives a keycode which, in English keyboard, 
matches the ; character which is a delimiter for recipients' input and so the 
application ends your input. I guess it's the same happening with your Italian 
keyboard.

Could you test on https://www.toptal.com/developers/keycode what key_code 
appears when you press @ ? Can you test with firefox and chrome too?

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of francis
Sent: mardi 12 septembre 2023 17:40
To: SOGo Users 
Subject: Re: [SOGo] BUG: Pressing ò char in the Recipient bar

Hi Simone

> On Sep 12, 2023, at 08:54, Simone Falcini (s...@magic.sm)  
> wrote:
> 
> When writing the email address in the recipient bar on an Apple wireless 
> keyboard (ITA layout), pressing the @ sign (on the same button that contains 
> òç@ chars) the partial address is saved as complete.

Do you also have the issue when you set the language to Italian in your 
preferences?


Francis

RE: [SOGo] Problems with calendar view

[qhivert]

Glad to help 

 

From: users-requ...@sogo.nu  On Behalf Of "Raoul 
Schroeder"
Sent: lundi 11 septembre 2023 15:31
To: users@sogo.nu
Subject: AW: [SOGo] Problems with calendar view

 

Holy moly.

 

Upon deeper inspection, I noticed some collations where utf8mb4_general_ci and 
some were utf8mb4_bin

No idea how that happened. The only thing I can think of is that SOGo made 
tables before I changed the collation over.

 

In any case, I changed all the collations to utf8mb4_unicode_ci, and now 
everything works.

I have to admit, I am not sure why just having differing collations caused that 
error, as the encoding was always utf8mb4.

 

Thanks for your help! I would have never guessed an encoding issue without the 
debugging session.

 

Von: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > Im Auftrag von qhivert
Gesendet: Montag, 11. September 2023 14:26
An: users@sogo.nu <mailto:users@sogo.nu> 
Betreff: RE: [SOGo] Problems with calendar view

 

Yes there is clearly an encoding problem, when I do the same with the ics you 
gave:
theRecord = {"c_category" = ""; "c_classification" = 0; "c_component" = 
vevent; "c_content" = "BEGIN:VCALENDAR

PRODID:-//Inverse inc./SOGo 5.8.4//EN

VERSION:2.0

BEGIN:VTIMEZONE

TZID:Europe/Berlin

LAST-MODIFIED:20230523T092157Z

X-LIC-LOCATION:Europe/Berlin

BEGIN:DAYLIGHT

TZNAME:CEST

TZOFFSETFROM:+0100

TZOFFSETTO:+0200

DTSTART:19700329T02

RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU

END:DAYLIGHT

BEGIN:STANDARD

TZNAME:CET

TZOFFSETFROM:+0200

TZOFFSETTO:+0100

DTSTART:19701025T03

RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU

END:STANDARD

END:VTIMEZONE

BEGIN:VEVENT

UID:4287-64F86880-1-169365E0

SUMMARY:Test Neu

LOCATION:Test

CLASS:PUBLIC

X-SOGO-SEND-APPOINTMENT-NOTIFICATIONS:NO

TRANSP:OPAQUE

DTSTART;TZID=Europe/Berlin:20230906T14
DTEND;TZID=Europe/Berlin:20230906T15

CREATED:20230906T115528Z

DTSTAMP:20230906T115528Z

LAST-MODIFIED:20230906T115528Z

END:VEVENT

END:VCALENDAR"; "c_creationdate" = 1694433479; "c_cycleinfo" = ""; 
"c_description" = ""; "c_enddate" = 1694005200; "c_folder" = personal; 
"c_isallday" = 0; "c_iscycle" = 0; "c_isopaque" = 1; "c_lastmodified" = 
1694433479; "c_location" = Test; "c_name" = "4287-64F86880-1-169365E0.ics"; 
"c_nextalarm" = 0; "c_orgmail" = ""; "c_owner" = "sogo-tests2"; 
"c_participants" = ""; "c_partmails" = ""; "c_partstates" = ""; "c_priority" = 
0; "c_sequence" = 0; "c_startdate" = 1694001600; "c_status" = 1; "c_title" = 
"Test Neu"; "c_uid" = "4287-64F86880-1-169365E0"; "c_version" = 0; calendarName 
= "Agenda personnel"; editable = 1; endDate = "2023-09-06 15:00:00 +0200"; 
erasable = 1; owner = "<0x0x55e10f10[SOGoUser]: login=sogo-tests2 
roles=Authenticated,Anonymous>"; ownerIsOrganizer = 0; startDate = "2023-09-06 
14:00:00 +0200"; startHour = "14:00"; viewable = 1; }

And:


From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  On Behalf Of "Raoul 
Schroeder"
Sent: lundi 11 septembre 2023 13:11
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: AW: [SOGo] Problems with calendar view

 

Thanks for your help. I have to admit that I am completely out of my depth 
here. Should I maybe open a bug report after all?

 

The database table type:

| c_partmails  | text  | YES  | | NULL|   |

Which is correct as per the current schemes

 

The Record looks really strange:

First of all, c_partmails is just hex-numbers: "c_partmails" = <72616f75 
6c2e7363 68726f65 64657240 6e616365 6c6c652e 6575>;

 

Or is that just the encoding of the database?

Mine is:

+--+--+

| @@character_set_database | @@collation_database |

+--+--+

| utf8mb4  | utf8mb4_bin  |

+--+--+

 

Which I think is the currently preferred collation, although I have also seen: 

utf8mb4_unicode_ci

 

The whole thing looks like this:

Breakpoint 3, -[UIxCalListingActions _fixParticipants:] (self=0x561b05d0, 
_cmd=0x72640230 <_OBJC_SELECTOR_TABLE+1200>, theRecord=0x55d8e700) at 
UIxCalListingActions.m:381

381 UIxCalListingActions.m: No such file or directory.

(gdb) po theRecord

{"c_category" = ""; "c_classification" = 0; "c_component" = vevent; 
"c_content" = <42454

RE: [SOGo] Problems with calendar view

[qhivert]

303061 32326536 63636339 2674656e 
616e7449 643d6561 63656234 37652d37 6430662d 34383237 2d393732 332d3664 
63656463 34393232 62632674 68726561 6449643d 31395f6d 65657469 6e675f4e 
4451774f 54673259 544d744d 444d7a5a 6930304d 446b354c 5746694e 44417459 
6a55315a 5751784f 575a6a59 57593540 74687265 61642e76 32266d65 73736167 
6549643d 30266c61 6e677561 67653d64 652d4445 3e207c20 52656368 746c6963 
68652048 696e7765 6973653c 68747470 733a2f2f 772e 65757261 2d61672e 
64652f6a 2f707269 76616379 3e0a5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 
5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 
5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f0a0a>; 
"c_enddate" = 1694419200; "c_folder" = personal; "c_isallday" = 0; "c_iscycle" 
= 0; "c_isopaque" = 1; "c_lastmodified" = 1694419179; "c_location" = "Microsoft 
Teams-Besprechung"; "c_name" = 
"04008200E00074C5B7101A82E00810D74F4C7EE1D90110006FFB9D0897DDF04BBFC0EB5176669AD5.ics";
 "c_nextalarm" = 1694416500; "c_orgmail" = "CorrectEmailAddress"; "c_owner" = 
aaa; "c_participants" = <72616f75 6c2e7363 68726f65 64657240 6e616365 
6c6c652e 6575>; "c_partmails" = <72616f75 6c2e7363 68726f65 64657240 6e616365 
6c6c652e 6575>; "c_partstates" = <31>; "c_priority" = 5; "c_sequence" = 0; 
"c_startdate" = 1694417400; "c_status" = 1; "c_title" = "CorrectTitle"; "c_uid" 
= 
04008200E00074C5B7101A82E00810D74F4C7EE1D90110006FFB9D0897DDF04BBFC0EB5176669AD5;
 "c_version" = 3; calendarName = "Pers\U00F6nlicher Kalender"; editable = 1; 
endDate = "2023-09-11 10:00:00 +0200"; erasable = 1; owner = 
"<0x0x55e612d0[SOGoUser]: login=aaa roles=Authenticated,Anonymous>"; 
ownerIsOrganizer = 0; startDate = "2023-09-11 09:30:00 +0200"; startHour = 
"09:30"; viewable = 1; }

 

Von: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > Im Auftrag von qhivert
Gesendet: Montag, 11. September 2023 11:52
An: users@sogo.nu <mailto:users@sogo.nu> 
Betreff: RE: [SOGo] Problems with calendar view

 

The problem seems to be here line 381
https://github.com/Alinto/sogo/blob/master/UI/Scheduler/UIxCalListingActions.m


mails = [[theRecord objectForKey: @"c_partmails"] componentsSeparatedByString: 
@"\n"];

 

My guess is the value for c_partmails is not a NSString as expected. You cand 
add a breakpoint there and cheking the value of theRecord:

break UI/Scheduler/UIxCalListingActions.m:381

y

run

Then when stopped :
po theRecord

You could also check in your database the type of column “c_partmails” from 
table “sogo_quick_appointment”.

Regards,
Quentin

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of "Raoul 
Schroeder"
Sent: dimanche 10 septembre 2023 14:25
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: AW: [SOGo] Problems with calendar view

 

Thanks for the gdb instructions.

 

So, when opening the view, once again it happens in alarmlist:

Sep 10 14:06:27 sogod [191697]: 2a01:c22:d4a8:ec00:6919:24c2:ed24:5281 "GET 
/SOGo/so/bb/Calendar/alarmslist?browserTime=1694347587 HTTP/1.1" 200 204/0 
0.007 - - 0 - 12

WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future 
version.

 

Breakpoint 1, -[NSException raise] (self=0x55f62f40, _cmd=0x77339fe0 
<_OBJC_SELECTOR_TABLE+480>) at ./Source/NSException.m:1595

1595./Source/NSException.m: No such file or directory.

 

(Is the “no such file or directory an issue”? I did follow the symbol install 
to the letter)

 

The bt looks like this:

 

(gdb) bt

#0  -[NSException raise] (self=0x55f62f40, _cmd=0x77339fe0 
<_OBJC_SELECTOR_TABLE+480>)

at ./Source/NSException.m:1595

#1  0x76ff593a in +[NSException raise:format:arguments:] 
(self=, _cmd=, 

name=0x7733a990 <_OBJC_INSTANCE_5>, format=, 
argList=0x7fffb610)

at ./Source/NSException.m:1487

#2  0x76ff6639 in +[NSException raise:format:] (self=0x7733a320 
<_OBJC_Class_NSException>, 

_cmd=, name=0x7733a990 <_OBJC_INSTANCE_5>, 

format=0x773753d0 <_OBJC_INSTANCE_11.19>) at ./Source/NSException.m:1472

#3  0x7705ca6e in -[NSObject doesNotRecognizeSelector:] 
(self=0x55721a60, _cmd=, 

aSelector=) at ./Source/NSObject.m:1740

#4  0x7712c288 in GSFFIInvocationCallback (cif=0x55f7cc40, 
retp=0x7fffb950, 

args=, user=) at 
./Source/GSFFIInvocation.m:606

#5  0x75d4e7ec in ?? () from /lib/x86_64-linux-gnu/libffi.so.8

#6  0x00

RE: [SOGo] Problems with calendar view

[qhivert]

848>, 
_rq=0x55a2c070, 

_ctx=0x5621d850, _sn=0x0, app=0x5596e640) at 
SoObjectRequestHandler.m:584

#18 0x7797ab78 in -[WORequestHandler handleRequest:] 
(self=0x55aa1e90, 

_cmd=0x77a941b0 <_OBJC_SELECTOR_TABLE+1616>, _request=0x55a2c070) 
at WORequestHandler.m:240

#19 0x77934304 in -[WOCoreApplication dispatchRequest:usingHandler:] 
(self=0x5596e640, 

_cmd=0x77a94200 <_OBJC_SELECTOR_TABLE+1696>, _request=0x55a2c070, 
handler=0x55aa1e90)

at WOCoreApplication.m:712

#20 0x77934673 in -[WOCoreApplication dispatchRequest:] 
(self=0x5596e640, 

_cmd=0x55567620 <_OBJC_SELECTOR_TABLE+1664>, _request=0x55a2c070) 
at WOCoreApplication.m:752

#21 0xdafb in -[SOGo dispatchRequest:] (self=0x5596e640, 

_cmd=0x77b31d20 <_OBJC_SELECTOR_TABLE+1760>, _request=0x55a2c070) 
at SOGo.m:584

#22 0x779ee44f in -[WOHttpTransaction _run] (self=0x55f237a0, 

_cmd=0x77b31d50 <_OBJC_SELECTOR_TABLE+1808>) at WOHttpTransaction.m:566

#23 0x779ee821 in -[WOHttpTransaction run] (self=0x55f237a0, 

_cmd=0x77b2e270 <_OBJC_SELECTOR_TABLE+1168>) at WOHttpTransaction.m:619

#24 0x779e9d65 in -[WOHttpAdaptor runConnection:] (self=0x5586ebd0, 

_cmd=0x77b2e310 <_OBJC_SELECTOR_TABLE+1328>, _socket=0x55b0d320) at 
WOHttpAdaptor.m:373

#25 0x779e9fc0 in -[WOHttpAdaptor _handleAcceptedConnection:] 
(self=0x5586ebd0, 

_cmd=0x77b2e320 <_OBJC_SELECTOR_TABLE+1344>, 
_connection=0x55b0d320) at WOHttpAdaptor.m:407

#26 0x779ea44d in -[WOHttpAdaptor _handleConnection:] 
(self=0x5586ebd0, 

_cmd=0x77b2e3c0 <_OBJC_SELECTOR_TABLE+1504>, connection=0x55b0d320) 
at WOHttpAdaptor.m:466

#27 0x779ea96a in -[WOHttpAdaptor acceptConnection:] 
(self=0x5586ebd0, 

_cmd=0x77b2e230 <_OBJC_SELECTOR_TABLE+1104>, 
_notification=0x55a192d0) at WOHttpAdaptor.m:527

#28 0x7704da31 in -[NSNotificationCenter _postAndRelease:] 
(self=0x55738f40, 

_cmd=, notification=0x55a192d0) at 
./Source/NSNotificationCenter.m:1198

 

But I do not think the backtrace is usable without the symbols in 
NSExceptions.m – at least I presume this is why it says optimized out?

 

Thanks,

 

Raoul

 

Von: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > Im Auftrag von qhivert
Gesendet: Sonntag, 10. September 2023 13:25
An: users@sogo.nu <mailto:users@sogo.nu> 
Betreff: RE: [SOGo] Problems with calendar view

 

Indeed, nothing wrong with your event.

To debug further you could use gdb to add breakpoint. The process is documented 
here -> https://www.sogo.nu/support/faq/how-do-i-debug-sogo.html
Follow the steps to add a breakpoint when any Exception is raised, then get the 
backtrace to see where in the code it fails.

Regards,
Quentin

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of "Raoul 
Schroeder"
Sent: dimanche 10 septembre 2023 11:28
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: AW: [SOGo] Problems with calendar view

 

Thank you very much. I was worried no one was going to reply, so thanks for 
taking notice.

It is the latter case, and it does not matter if you create it within 
Outlook/Android with ActiveSync, or within SOGo web itself. After you create 
one event, the web view no longer works.

I am not sure it is a bug within SOGo, though. Others would have noticed it. I 
feel like it is an issue with my installation specifically, but there is not 
enough to the error message for me to understand what would be the underlying 
issue.

 

Here is a calendar event export from mysql:

| 4287-64F86880-1-169365E0.ics | BEGIN:VCALENDAR

PRODID:-//Inverse inc./SOGo 5.8.4//EN

VERSION:2.0

BEGIN:VTIMEZONE

TZID:Europe/Berlin

LAST-MODIFIED:20230523T092157Z

X-LIC-LOCATION:Europe/Berlin

BEGIN:DAYLIGHT

TZNAME:CEST

TZOFFSETFROM:+0100

TZOFFSETTO:+0200

DTSTART:19700329T02

RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU

END:DAYLIGHT

BEGIN:STANDARD

TZNAME:CET

TZOFFSETFROM:+0200

TZOFFSETTO:+0100

DTSTART:19701025T03

RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU

END:STANDARD

END:VTIMEZONE

BEGIN:VEVENT

UID:4287-64F86880-1-169365E0

SUMMARY:Test Neu

LOCATION:Test

CLASS:PUBLIC

X-SOGO-SEND-APPOINTMENT-NOTIFICATIONS:NO

TRANSP:OPAQUE

DTSTART;TZID=Europe/Berlin:20230906T14

DTEND;TZID=Europe/Berlin:20230906T15

CREATED:20230906T115528Z

DTSTAMP:20230906T115528Z

LAST-MODIFIED:20230906T115528Z

END:VEVENT

END:VCALENDAR | 1694001328 | 1694001328 | 0 |  NULL |

 

Thanks,

 

Raoul

 

Von: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > Im Auftrag von qhivert
Gesendet: Sonntag, 10. September 2023 09:27
An: users@sogo.nu &

RE: [SOGo] Problems with calendar view

[qhivert]

Indeed, nothing wrong with your event.

To debug further you could use gdb to add breakpoint. The process is documented 
here -> https://www.sogo.nu/support/faq/how-do-i-debug-sogo.html
Follow the steps to add a breakpoint when any Exception is raised, then get the 
backtrace to see where in the code it fails.

Regards,
Quentin

 

From: users-requ...@sogo.nu  On Behalf Of "Raoul 
Schroeder"
Sent: dimanche 10 septembre 2023 11:28
To: users@sogo.nu
Subject: AW: [SOGo] Problems with calendar view

 

Thank you very much. I was worried no one was going to reply, so thanks for 
taking notice.

It is the latter case, and it does not matter if you create it within 
Outlook/Android with ActiveSync, or within SOGo web itself. After you create 
one event, the web view no longer works.

I am not sure it is a bug within SOGo, though. Others would have noticed it. I 
feel like it is an issue with my installation specifically, but there is not 
enough to the error message for me to understand what would be the underlying 
issue.

 

Here is a calendar event export from mysql:

| 4287-64F86880-1-169365E0.ics | BEGIN:VCALENDAR

PRODID:-//Inverse inc./SOGo 5.8.4//EN

VERSION:2.0

BEGIN:VTIMEZONE

TZID:Europe/Berlin

LAST-MODIFIED:20230523T092157Z

X-LIC-LOCATION:Europe/Berlin

BEGIN:DAYLIGHT

TZNAME:CEST

TZOFFSETFROM:+0100

TZOFFSETTO:+0200

DTSTART:19700329T02

RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU

END:DAYLIGHT

BEGIN:STANDARD

TZNAME:CET

TZOFFSETFROM:+0200

TZOFFSETTO:+0100

DTSTART:19701025T03

RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU

END:STANDARD

END:VTIMEZONE

BEGIN:VEVENT

UID:4287-64F86880-1-169365E0

SUMMARY:Test Neu

LOCATION:Test

CLASS:PUBLIC

X-SOGO-SEND-APPOINTMENT-NOTIFICATIONS:NO

TRANSP:OPAQUE

DTSTART;TZID=Europe/Berlin:20230906T14

DTEND;TZID=Europe/Berlin:20230906T15

CREATED:20230906T115528Z

DTSTAMP:20230906T115528Z

LAST-MODIFIED:20230906T115528Z

END:VEVENT

END:VCALENDAR | 1694001328 | 1694001328 | 0 |  NULL |

 

Thanks,

 

Raoul

 

Von: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > Im Auftrag von qhivert
Gesendet: Sonntag, 10. September 2023 09:27
An: users@sogo.nu <mailto:users@sogo.nu> 
Betreff: RE: [SOGo] Problems with calendar view

 

Hello,
Welcome to SOGo 

Very strange behavior. Is the problem when you create an event or when an event 
has been created and then the calendar view fails?

If it’s the first case, check with your browser debug tool the content of the 
request POST “saveAsAppointment”
In the second case, it would be good to see how the event is stored in your 
database.

I strongly suggest you open an issue on https://bugs.sogo.nu. If your account 
is new, then send an email to b...@sogo.nu <mailto:b...@sogo.nu>  with your 
username so we can enable it to report.

Quentin

 

From: users-requ...@sogo.nu mailto:users-requ...@sogo.nu> > On Behalf Of "Raoul Schroeder"
Sent: jeudi 7 septembre 2023 10:10
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] Problems with calendar view

 

Hello all,

 

I am relatively new to SOGo, having used Zarafa/Kopano for over 10 years until 
they stopped all development to it.

It took me a while to figure out the differences between the two systems and 
getting SOGo to work – especially figuring out how the WOWhelper setting gets 
overridden, even though it is stated clearly in the documentation.

 

Anyway, I got a problem now that I cannot figure out. My calendar views work 
perfectly only until there are appointments in it. Then it ends up with request 
failed, but even with debug settings on, there is very little in terms of error 
messages.

It all comes down to exceptions thrown by malloc:

 

"GET /SOGo/so/aaa/Calendar/alarmslist?browserTime=1694071570 HTTP/1.1" 200 
60/0 0.007 - - 0 - 13

2023-09-07 09:26:14.268 sogod[26468:26468] EXCEPTION:  NAME:NSInvalidArgumentException REASON:NSDataMalloc(instance) 
does not recognize componentsSeparatedByString: INFO:(null)

 

Or:

 

"GET /SOGo/so/bbb/Calendar/alarmslist?browserTime=1694071657 HTTP/1.1" 200 
60/0 0.007 - - 0 - 14

2023-09-07 09:27:40.841 sogod[38833:38833] EXCEPTION:  NAME:NSInvalidArgumentException 
REASON:[NSDataMalloc-jsonRepresentation] should be overridden by subclass 
INFO:(null)

 

It seems to be consistently happening with the alarmslist, and it looks like 
NSDataMalloc is getting null pointers?

 

On ActiveSync, I can see the calendar entries on both Outlook 2019 as well as 
Android

 

I am running on the most recent snapshot of 5.8.4 on Ubuntu 22.04 (5.9 is still 
masked in the repository)

 

Thanks,

 

Raoul

RE: [SOGo] Problems with calendar view

[qhivert]

Hello,
Welcome to SOGo 

Very strange behavior. Is the problem when you create an event or when an event 
has been created and then the calendar view fails?

If it’s the first case, check with your browser debug tool the content of the 
request POST “saveAsAppointment”
In the second case, it would be good to see how the event is stored in your 
database.

I strongly suggest you open an issue on https://bugs.sogo.nu. If your account 
is new, then send an email to b...@sogo.nu   with your 
username so we can enable it to report.

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of "Raoul 
Schroeder"
Sent: jeudi 7 septembre 2023 10:10
To: users@sogo.nu
Subject: [SOGo] Problems with calendar view

 

Hello all,

 

I am relatively new to SOGo, having used Zarafa/Kopano for over 10 years until 
they stopped all development to it.

It took me a while to figure out the differences between the two systems and 
getting SOGo to work – especially figuring out how the WOWhelper setting gets 
overridden, even though it is stated clearly in the documentation.

 

Anyway, I got a problem now that I cannot figure out. My calendar views work 
perfectly only until there are appointments in it. Then it ends up with request 
failed, but even with debug settings on, there is very little in terms of error 
messages.

It all comes down to exceptions thrown by malloc:

 

"GET /SOGo/so/aaa/Calendar/alarmslist?browserTime=1694071570 HTTP/1.1" 200 
60/0 0.007 - - 0 - 13

2023-09-07 09:26:14.268 sogod[26468:26468] EXCEPTION:  NAME:NSInvalidArgumentException REASON:NSDataMalloc(instance) 
does not recognize componentsSeparatedByString: INFO:(null)

 

Or:

 

"GET /SOGo/so/bbb/Calendar/alarmslist?browserTime=1694071657 HTTP/1.1" 200 
60/0 0.007 - - 0 - 14

2023-09-07 09:27:40.841 sogod[38833:38833] EXCEPTION:  NAME:NSInvalidArgumentException 
REASON:[NSDataMalloc-jsonRepresentation] should be overridden by subclass 
INFO:(null)

 

It seems to be consistently happening with the alarmslist, and it looks like 
NSDataMalloc is getting null pointers?

 

On ActiveSync, I can see the calendar entries on both Outlook 2019 as well as 
Android

 

I am running on the most recent snapshot of 5.8.4 on Ubuntu 22.04 (5.9 is still 
masked in the repository)

 

Thanks,

 

Raoul

RE: [SOGo] Calendar entry not shown

[qhivert]

Hello Thomas,
Yes, the ticket will be more useful for the follow-up. I've updated your 
account level so you should be able to create one.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of nsclick
Sent: lundi 4 septembre 2023 08:46
To: qhivert" (qhiv...@alinto.eu) 
Subject: Aw: [SOGo] Calendar entry not shown

Hello,

I tried to dig a bit further into the problem and found the following behavior 
in my SOGo version 5.8.4 (as part of my mailcow installation). However, I am 
not absolutely sure at the moment if this is still the issue I have seen 
before, but at least this one here is reproducable.

If importing the attached ICS file into an empty calender, there will be two 
events. "Event A" on September 20th and "Event B" on September, 1st.

In the "month" view for September 2023 (as well as in the list of events on the 
left side in the web UI) I can only see "Event A". "Event B" is not shown on 
September, 1st 2023, but I can see it on September, 1st of the years 2022 or 
2024, for example.

The strange thing is that "Event B" immediately appear on September, 1st 2023 
if I delete "Event A".

The problem only seems to appear in the SOGo Web UI. If I connect to the same 
calendar in Thunderbird via CalDav, everything works fine.

Another strange effect is also that "Event B" immediately appears in the 
calendar if I edit "Event B" in Thunderbird and change the yearly repeating of 
the event from the custom "on each 1st September" to simply "yearly". If I 
change it back to the custom setting, the event immediately disappears again in 
the SOGo Web UI calendar.

Could you please check if you can also see this strange behavior on your setup?
How can I get more debug information from SOGo?

If wanted, I could create a bug ticket.

--- ICS File Content Begin ---
BEGIN:VCALENDAR
PRODID:-//Inverse inc./SOGo 5.8.4//EN
VERSION:2.0
METHOD:PUBLISH
BEGIN:VTIMEZONE
TZID:Greenwich Standard Time
BEGIN:STANDARD
DTSTART:19700101T00
TZNAME:Westafrikanische Normalzeit
TZOFFSETFROM:+
TZOFFSETTO:+
END:STANDARD
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:W. Europe Standard Time
BEGIN:STANDARD
DTSTART:19701025T03
RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU;BYHOUR=3;BYMINUTE=0
TZNAME:Mitteleuropäische Zeit
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:19700329T02
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU;BYHOUR=2;BYMINUTE=0
TZNAME:Mitteleuropäische Sommerzeit
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
ATTENDEE;RSVP=TRUE;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;CN=Foo Bar:m  
ailto:du...@foobar.com CLASS:PUBLIC DTEND;TZID=W. Europe Standard 
Time:20230320T09 DTSTAMP:20230902T200622Z DTSTART;TZID=W. Europe Standard 
Time:20230320T08 EXDATE:20230320T07Z EXDATE:20230420T06Z 
EXDATE:20230520T06Z EXDATE:20230620T06Z EXDATE:20230720T06Z 
ORGANIZER;CN=f...@bar.com:mailto:f...@bar.com
PRIORITY:5
RRULE:FREQ=MONTHLY;COUNT=10;BYMONTHDAY=20
SEQUENCE:0
SUMMARY:Event A
TRANSP:OPAQUE
UID:04008200E00074C5B7101A82E008000
 034004D14C68E6D285940B19A7D3D1DC1F8D261313835313930392D643433652D34646
 5322D616630332D383133323536633530623537
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
X-SOGO-SEND-APPOINTMENT-NOTIFICATIONS:NO
BEGIN:VALARM
ACTION:DISPLAY
DESCRIPTION:This is an event reminder
TRIGGER:-PT10M
END:VALARM
END:VEVENT
BEGIN:VEVENT
CLASS:PUBLIC
DTEND;VALUE=DATE:20140902
DTSTAMP:20230902T190220Z
DTSTART;VALUE=DATE:20140901
PRIORITY:5
RRULE:FREQ=YEARLY;BYMONTH=9;BYMONTHDAY=1
SEQUENCE:0
SUMMARY:Event B
TRANSP:TRANSPARENT
UID:04008200E00074C5B7101A82E008000
 034004D14C68E6D285940B19A7D3D1DC1F8D265366534633734612D306565622D34393
 8612D626466332D623334393465373963336634
X-MICROSOFT-CDO-BUSYSTATUS:FREE
END:VEVENT
X-WR-CALNAME:TEST 4 (Sync)
END:VCALENDAR
--- ICS File Contead End ---

Is it possible to attach file (e.g. the ics file) directly to a mailing list 
mail or would this be rejected?

Thanks a lot in advance,

Thomas


> Gesendet: Samstag, den 02.09.2023 um 10:29 Uhr
> Von: "\"qhivert\" (qhiv...@alinto.eu)" 
> An: users@sogo.nu
> Betreff: RE: [SOGo] Calendar entry not shown
> 
> Hello Thomas,
> I've just tried that on my sogo and the problem does'nt appear. You should 
> report an issue on https://bugs.sogo.nu because I'll need to ask you for logs.
> If you don't have an account already, notice that I will have to update your 
> level since newcomers can't open an issue at first. So tell me when your 
> account has been made.
> 
> Quentin
> 
> -Original Message-
> From: users-requ...@sogo.nu  On Behalf Of 
> nsclick
> Sent: vendredi 1 septembre 2023 20:54
> To: users@sogo.nu
> Subject: [SOGo] Calendar entry not shown
> 
> Hello,
> 
> as yo

RE: [SOGo] SOGO configuration

[qhivert]

Hello François,
- For you first point can you clarify?  I’m not sure I understand what you want 
to do.
- By any chance to you use your os repository for installing sogo ? Or alinto 
repo https://packages.sogo.nu/ ? 5.8.0 is an old version (5.8.4 now) and maybe 
your bug is fixed by then.

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of François Vivet
Sent: vendredi 1 septembre 2023 15:33
To: users@sogo.nu
Subject: [SOGo] SOGO configuration

 

Hi,

I installed a new SOGo server on past July and everything works fine except 
that:

- I'm going mad looking for where I can change the destination EMail 
address to which are sent the notifications of the state changes of the 
autoreply of each user. Right now these mails are sent to sogo@mydomain where I 
would like them to be sent to a dedicated existing address (for instance 
not_autorep@mydomain)

- I encounter trouble with the Personnal Address Book: I can't edit 
entries, I can't even not see them by moment and I get a "Request failed" 
pop-up. My SOGo version is 5.8.0-1

Some help about these two topics would be appreciate.

All the best,

François

-- 
Dr François Vivet
Service Informatique
IMN - UMR6502 CNRS/Nantes Université
2, rue de la Houssinière
BP32229
44322 Nantes cedex 3
Tél.: +332 40 37 39 04
http://www.cnrs-imn.fr

RE: [SOGo] Calendar entry not shown

[qhivert]

Hello Thomas,
I've just tried that on my sogo and the problem does'nt appear. You should 
report an issue on https://bugs.sogo.nu because I'll need to ask you for logs.
If you don't have an account already, notice that I will have to update your 
level since newcomers can't open an issue at first. So tell me when your 
account has been made.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of nsclick
Sent: vendredi 1 septembre 2023 20:54
To: users@sogo.nu
Subject: [SOGo] Calendar entry not shown

Hello,

as you can see in the attached SOGo-Calendar.jpg I have some calendar entries 
(blue, green, red) in my calender which are shown in the calendar view on the 
right side as well as in the list on the left side.
However, there are the two entries (orange, yellow) which are only shown in the 
list on the left side, but not in the calendar view on the right side. Both 
entries do not have times, they are full-time for the day. Do you have any idea 
why?

The calendar entries are configured as shown in SOGo-Calendar-Details.jpg

Thanks a lot in advance,

Thomas

RE: [SOGo] Nightly builds now working?

[qhivert]

Yes for certain distribution, we’re on it. It should be ok asap.

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Jürgen Echter
Sent: mercredi 16 août 2023 14:19
To: SOGo reporter 
Subject: [SOGo] Nightly builds now working?

 

Good day everyone,

is something wrong with the nightly builds?

Last update i got is 5.8.4.20230807.

Cheers

Juergen

RE: [SOGo] pgp keys from pgp.mit.edu

[qhivert]

Hello Kenren,
Yes, the key from openpgp.org should be enough. There was one key for Inverse 
and one for Alinto and we let the two of them just in case.

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Kenren Taisho
Sent: jeudi 10 août 2023 11:38
To: users@sogo.nu
Subject: [SOGo] pgp keys from pgp.mit.edu

 

Hello.
 
Following the installation instruction in  
https://www.sogo.nu/download.html#/backend,
the importing of pgp keys from pgp.mit.edu   does not seem 
to work from some time now.
 
sudo rpm --import "http://pgp.mit.edu/pks/lookup?op=get 
 
=0xCB2D3A2AA0030E2C"
Is this still required? Or the keys from openpgp.org   is 
enough.
Kind regards

RE: [SOGo] Templates

[qhivert]

I suggest you to open an issue then

Regards,
Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Frank Richter
Sent: vendredi 4 août 2023 10:21
To: users@sogo.nu
Subject: Re: [SOGo] Templates

 

Am 04.08.23 um 09:37 schrieb qhivert (qhiv...@alinto.eu 
<mailto:qhiv...@alinto.eu> ):


One an email is in your template folder. Open this folder, and select the mail 
you want to use. You will have a special button to use this mail as a draft. 

Thnaks, that looks useful. But I don’t find this „Create new draft with this 
template“, unfortunately …

 



Thanks,
Frank





 





From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  On Behalf Of Frank Richter
Sent: jeudi 3 août 2023 13:50
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: Re: [SOGo] Templates

 

Am 27.07.23 um 12:54 schrieb "Simon Wilson" (si...@simonandkate.net 
<mailto:si...@simonandkate.net> ):

>From a folder's three-dot menu, select to use for Templates:


On Saturday, July 22, 2023 02:57 AEST, "Hanns Mattes" (ha...@hannsmattes.de 
<mailto:ha...@hannsmattes.de> )  <mailto:users@sogo.nu>  wrote:
 

Hi,

how do I tell sogo, which IMAP-folder is used for templates? Might be
obvious, but I don't get it.

Can someone tell me, how do Templates work SOGo? I have an e-mail in the 
Template folder, now how it can be used?
In Draft folder I see the edit icon (pencil) to continue editing an e-mail. But 
nothing in the Template folder …





-- 
Frank Richter, Chemnitz University of Technology, Germany

RE: [SOGo] How to terminate just a single user session?

[qhivert]

Hello Frank,
As for now, you can't dot that either by sogo-tool nor by db/log.
I agree the -h is tricky. The way to see the information's of different 
sogo-tool command is to leave the arguments empty like this:
sogo-tool cleanup
sogo-tool expire-sessions

By the way, you can add -v to see logs after sogo-tool:
sogo-tool -v expire-sessions 

If you have abuse, you could make a cron that shoot session > 1 days for 
example.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Frank Richter
Sent: jeudi 3 août 2023 15:08
To: users@sogo.nu
Subject: [SOGo] How to terminate just a single user session?

Hello,

is there a possibility to terminate a single user session? I noticed 
sogo-tool expire-sessions … (and painfully detected, that sogo-tool 
expire-sessions -h expires all users immediately).
But in some cases I need to terminate just one session (i .e. account abuse).

Grepping logfiles / database to achieve this would be no problem :-)

Thanks
Frank

-- 
Frank Richter, Chemnitz University of Technology, Germany

RE: [SOGo] undefined symbol: TNEFCheckForSignature

[qhivert]

Ok in that case the best would be to open a issue at https://bugs.sogo.nu. It 
will be better to keep track of this. You can send me your mail in private 
though

 

From: users-requ...@sogo.nu  On Behalf Of Kenren Taisho
Sent: lundi 31 juillet 2023 11:28
To: users@sogo.nu
Subject: Re: [SOGo] undefined symbol: TNEFCheckForSignature

 

Hi Quentin,

Yes, even with the new package. Also, I tried the old ytnef package and it's 
the same.

 

-- sogo.log ---

Jul 31 17:24:41 sogod [467139]: [RM:MailerUI] LOOKUP FAILED: 
UIxMailPartTNEFViewer
Jul 31 17:24:41 sogod [467139]: [RM:MailerUI]   PARENT 
(<0x0x56464aadbfc0[WEResourceManager]:>) SAID: (null)
/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature
Jul 31 17:24:41 sogod [466637]: <0x0x56464ab46c40[WOWatchDogChild]> child 
467139 exited with code 127
Jul 31 17:24:41 sogod [466637]: <0x0x56464aa689b0[WOWatchDog]> child spawned 
with pid 467141

-- sogo.log ---

 

It's only happening on an EL 9.2 install.
On an EL 8.8, it displays the email message with some non-ASCII characters, but 
it does not produce the same error.

 

On Mon, Jul 31, 2023 at 3:58 PM qhivert mailto:users@sogo.nu> > 
wrote:

Hello Kenren,
So even with the new package I gave you it doesn’t work?
There’s still the old package at 
https://packages.sogo.nu/nightly/5/rhel/9/x86_64/RPMS/ytnef-2.0.0-1.x86_64.rpm
Could you give it a go?

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Kenren 
Taisho
Sent: lundi 31 juillet 2023 07:39
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: Re: [SOGo] undefined symbol: TNEFCheckForSignature

 

Hello. Anyone from the list or devs can help solve this problem?
As of now, this is the remaining hurdle that is keeping us to migrate to SOGo.

 

Kind regards

 

On Sat, Jul 29, 2023 at 9:45 AM Kenren Taisho mailto:toushin.tai...@gmail.com> > wrote:

Hello Quentin,

 

It happened again. I thought it was only affecting EAS but the web client also 
errors out on a particular email causing the problem.


--- sogo.log ---
Jul 29 09:02:48 sogod [445678]: [RM:MailerUI] LOOKUP FAILED: 
UIxMailPartTNEFViewer
Jul 29 09:02:48 sogod [445678]: [RM:MailerUI]   PARENT 
(<0x0x55af08853fc0[WEResourceManager]:>) SAID: (null)
/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature

--- sogo.log ---

 

-- eas log ---

/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature

-- eas log ---

 

Interestingly, it affects only our pre-production server running the nightly 
builds on AlmaLinux 9.2.
I test the same using the same version of SOGo on AlmaLinux 8.8 and although it 
is displaying some non-ASCII characters, it's not having the same error.

Both the AlmaLinux 9.2 and 8.8 has the same ytnef version v2.1.2.

 

Is this issue EL 9.x specific?

 

I could provide the eml file in private if this will help solve the issue.

 

 

Kind regards

 

 

 

 

 

 

On Fri, Jul 21, 2023 at 11:35 AM Kenren Taisho mailto:toushin.tai...@gmail.com> > wrote:

Hello Quentin,

Thank you, I have applied the updated ytnef rpm you attached and will monitor 
the results.
Will report the findings later.

 

Kind regards

 

On Thu, Jul 20, 2023 at 10:39 PM qhivert mailto:users@sogo.nu> 
> wrote:

Forget the attachment ><

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of qhivert
Sent: jeudi 20 juillet 2023 16:38
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: RE: [SOGo] undefined symbol: TNEFCheckForSignature

 

Hello again Kenren,
I’ve built another package of ytnef attached to his mail.
Can you test it?

 

First stop the service sogod then remove only the old ytnef without its 
dependencies (or it will remove all sogo):

rpm -e –nodeps ytnef

Then install the package I give you:

yum install ytnef-2.1.2-1.el9.x86_64.rpm

Restart sogod then.

 

Regards,

Quentin

 

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Kenren 
Taisho
Sent: jeudi 20 juillet 2023 09:18
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: Re: [SOGo] undefined symbol: TNEFCheckForSignature

 

Hi Quentin,

Thanks for the reply, I am running on AlmaLinux 9.2.

 

 

Kind regards

 

On Thu, Jul 20, 2023 at 2:35 PM qhivert mailto:users@sogo.nu> > 
wrote:

Hello Kenren,

What OS do you use for SOGo? Maybe there was a problem while building this 
ytnef package.

Quentin

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Kenren 
Taisho
Sent: mercredi 19 juillet 2023 09:04
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] undefined symbol: TNE

RE: [SOGo] undefined symbol: TNEFCheckForSignature

[qhivert]

Hello Kenren,
So even with the new package I gave you it doesn’t work?
There’s still the old package at 
https://packages.sogo.nu/nightly/5/rhel/9/x86_64/RPMS/ytnef-2.0.0-1.x86_64.rpm
Could you give it a go?



 

From: users-requ...@sogo.nu  On Behalf Of Kenren Taisho
Sent: lundi 31 juillet 2023 07:39
To: users@sogo.nu
Subject: Re: [SOGo] undefined symbol: TNEFCheckForSignature

 

Hello. Anyone from the list or devs can help solve this problem?
As of now, this is the remaining hurdle that is keeping us to migrate to SOGo.

 

Kind regards

 

On Sat, Jul 29, 2023 at 9:45 AM Kenren Taisho mailto:toushin.tai...@gmail.com> > wrote:

Hello Quentin,

 

It happened again. I thought it was only affecting EAS but the web client also 
errors out on a particular email causing the problem.


--- sogo.log ---
Jul 29 09:02:48 sogod [445678]: [RM:MailerUI] LOOKUP FAILED: 
UIxMailPartTNEFViewer
Jul 29 09:02:48 sogod [445678]: [RM:MailerUI]   PARENT 
(<0x0x55af08853fc0[WEResourceManager]:>) SAID: (null)
/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature

--- sogo.log ---

 

-- eas log ---

/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature

-- eas log ---

 

Interestingly, it affects only our pre-production server running the nightly 
builds on AlmaLinux 9.2.
I test the same using the same version of SOGo on AlmaLinux 8.8 and although it 
is displaying some non-ASCII characters, it's not having the same error.

Both the AlmaLinux 9.2 and 8.8 has the same ytnef version v2.1.2.

 

Is this issue EL 9.x specific?

 

I could provide the eml file in private if this will help solve the issue.

 

 

Kind regards

 

 

 

 

 

 

On Fri, Jul 21, 2023 at 11:35 AM Kenren Taisho mailto:toushin.tai...@gmail.com> > wrote:

Hello Quentin,

Thank you, I have applied the updated ytnef rpm you attached and will monitor 
the results.
Will report the findings later.

 

Kind regards

 

On Thu, Jul 20, 2023 at 10:39 PM qhivert mailto:users@sogo.nu> 
> wrote:

Forget the attachment ><

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of qhivert
Sent: jeudi 20 juillet 2023 16:38
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: RE: [SOGo] undefined symbol: TNEFCheckForSignature

 

Hello again Kenren,
I’ve built another package of ytnef attached to his mail.
Can you test it?

 

First stop the service sogod then remove only the old ytnef without its 
dependencies (or it will remove all sogo):

rpm -e –nodeps ytnef

Then install the package I give you:

yum install ytnef-2.1.2-1.el9.x86_64.rpm

Restart sogod then.

 

Regards,

Quentin

 

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Kenren 
Taisho
Sent: jeudi 20 juillet 2023 09:18
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: Re: [SOGo] undefined symbol: TNEFCheckForSignature

 

Hi Quentin,

Thanks for the reply, I am running on AlmaLinux 9.2.

 

 

Kind regards

 

On Thu, Jul 20, 2023 at 2:35 PM qhivert mailto:users@sogo.nu> > 
wrote:

Hello Kenren,

What OS do you use for SOGo? Maybe there was a problem while building this 
ytnef package.

Quentin

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Kenren 
Taisho
Sent: mercredi 19 juillet 2023 09:04
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] undefined symbol: TNEFCheckForSignature

 

Dear all,


I am testing IOS client and found a subfolder not syncing or empty using EAS.
The error that I am getting in the sogo.log is:
---
/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature
/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature
---

and in apache.log

---
AH00898: Error reading from remote server returned by 
/Microsoft-Server-ActiveSync
[proxy_http:error] [pid 577548:tid 577610] (20014)Internal error (specific 
information not available): [client xx.xx.xx.xx:25524] AH01102: error reading 
status line from remote server 127.0.0.1:2 <http://127.0.0.1:2> 

---

I am using the updated ytnef package from the sogo repository:
Yerase TNEF Exporter v2.1.2

 

 

Any idea where to look and how to fix this?

 

Thanks in advance

RE: [SOGo] SOGo no longer talking to mysql

[qhivert]

Well, I’m out of idea ☹
Maybe test to change the username of SOGoProfileURL and look at the log to see 
if the name has changed as well, just to be sure the correct sogo.conf file is 
used. You could also send to my address only qhiv...@alinto.eu 
<mailto:qhiv...@alinto.eu>  your sogo.conf file (censor your password) so I can 
see if anything shocks me.

 

From: users-requ...@sogo.nu  On Behalf Of Richard Rosner
Sent: vendredi 21 juillet 2023 13:27
To: qhivert (qhiv...@alinto.eu) 
Subject: Re: [SOGo] SOGo no longer talking to mysql

 

Hi Quentin,

thanks for this, but username is just sogo, password only consists of latin 
alphabet letters (no special letters like ê, ę or others), numbers and simple 
special characters like - or _, nothing that's not ASCII. Is there anything 
else that can/must be done? E.g. in mysql you have to denote usernames, 
passwords or host names in quotes. It's nothing sogo seems to need as it did 
work previously, but is there something similar I could try?

Richard

Am 21.07.2023 um 12:21 schrieb qhivert (qhiv...@alinto.eu 
<mailto:qhiv...@alinto.eu> ):

Hello again Richard,

Just in case, in your sogo.conf the username and password must be “url” encoded 
if you have any special characters -> 
https://www.w3schools.com/tags/ref_urlencode.ASP

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>   
<mailto:users-requ...@sogo.nu>  On Behalf Of Richard 
Rosner
Sent: vendredi 21 juillet 2023 09:44
To: Kenren Taisho (toushin.tai...@gmail.com <mailto:toushin.tai...@gmail.com> ) 
 <mailto:users@sogo.nu> 
Subject: Re: [SOGo] SOGo no longer talking to mysql

 

 Hi Kenren,

skip-name-resolve is alraedy commented out.

Richard

 

Am 21.07.2023 um 02:13 schrieb Kenren Taisho (toushin.tai...@gmail.com 
<mailto:toushin.tai...@gmail.com> ):

Hi Richard, 

 

ERROR: could not open MySQL4 connection to database 'sogo': Access denied for 
user 'sogo'@'localhost' (using password: YES)

 

Could you check if skip-name-resolve is enabled in your MySQL config? And if 
is, remove it, restart MySQL, and see if SOGo is communicating again with MySQL.

 

Kind regards

 

 

 

 

On Fri, Jul 21, 2023 at 12:03 AM Richard Rosner mailto:users@sogo.nu> > wrote:

Hi Quentin,

I didn't only not change the password, I even made double sure the user still 
had all permissions for the database in question. And like I said, I did try 
username and password manually, which did work.

I enabled MySQL4DebugEnabled, but outout doesn't seem to have changed:

 

Jul 20 17:41:15 sogod [79585]: <0x0x7f8a1a4b7340[WOWatchDogChild]> watchdog 
request timeout set to 10 minutes
Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> preparing 3 
children
Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned 
with pid 79586
Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned 
with pid 79587
Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned 
with pid 79588
2023-07-20 17:41:16.020 sogod[79588:79588] ERROR: could not open MySQL4 
connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using 
password: YES)
Jul 20 17:41:16 sogod [79588]: [ERROR] <0x0x55ce03f47520[GCSChannelManager]> 
could not open channel  
for mysql://localhost/sogo/sogo_user_profile
Jul 20 17:41:16 sogod [79588]: [WARN] <0x0x55ce03f47520[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200
2023-07-20 17:41:16.026 sogod[79587:79587] ERROR: could not open MySQL4 
connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using 
password: YES)
Jul 20 17:41:16 sogod [79587]: [ERROR] <0x0x55ce03e5a8c0[GCSChannelManager]> 
could not open channel  
for mysql://localhost/sogo/sogo_user_profile
Jul 20 17:41:16 sogod [79587]: [WARN] <0x0x55ce03e5a8c0[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200
2023-07-20 17:41:16.034 sogod[79586:79586] ERROR: could not open MySQL4 
connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using 
password: YES)
Jul 20 17:41:16 sogod [79586]: [ERROR] <0x0x55ce03e56270[GCSChannelManager]> 
could not open channel  
for mysql://localhost/sogo/sogo_user_profile
Jul 20 17:41:16 sogod [79586]: [WARN] <0x0x55ce03e56270[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200
Jul 20 17:41:16 sogod [79588]: <0x0x55ce04083130[WOHttpAdaptor]> notified the 
watchdog that we are ready
Jul 20 17:41:16 sogod [79587]: <0x0x55ce040840a0[WOHttpAdaptor]> notified the 
watchdog that we are ready
Jul 20 17:41:16 sogod [79586]: <0x0x55ce04087de0[WOHttpAdaptor]> notified the 
watchdog that we are ready

 

Richard

 

Am 20.07.2023 um 17:08 schrieb qhivert (qhiv...@alinto.eu 
<mailto:qhiv...@alinto.eu> ):

Hello Richard,
Strang

RE: [SOGo] SOGo no longer talking to mysql

[qhivert]

Hello again Richard,

Just in case, in your sogo.conf the username and password must be “url” encoded 
if you have any special characters -> 
https://www.w3schools.com/tags/ref_urlencode.ASP

 

From: users-requ...@sogo.nu  On Behalf Of Richard Rosner
Sent: vendredi 21 juillet 2023 09:44
To: Kenren Taisho (toushin.tai...@gmail.com) 
Subject: Re: [SOGo] SOGo no longer talking to mysql

 

 Hi Kenren,

skip-name-resolve is alraedy commented out.

Richard

 

Am 21.07.2023 um 02:13 schrieb Kenren Taisho (toushin.tai...@gmail.com 
<mailto:toushin.tai...@gmail.com> ):

Hi Richard, 

 

ERROR: could not open MySQL4 connection to database 'sogo': Access denied for 
user 'sogo'@'localhost' (using password: YES)

 

Could you check if skip-name-resolve is enabled in your MySQL config? And if 
is, remove it, restart MySQL, and see if SOGo is communicating again with MySQL.

 

Kind regards

 

 

 

 

On Fri, Jul 21, 2023 at 12:03 AM Richard Rosner mailto:users@sogo.nu> > wrote:

Hi Quentin,

I didn't only not change the password, I even made double sure the user still 
had all permissions for the database in question. And like I said, I did try 
username and password manually, which did work.

I enabled MySQL4DebugEnabled, but outout doesn't seem to have changed:

 

Jul 20 17:41:15 sogod [79585]: <0x0x7f8a1a4b7340[WOWatchDogChild]> watchdog 
request timeout set to 10 minutes
Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> preparing 3 
children
Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned 
with pid 79586
Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned 
with pid 79587
Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child spawned 
with pid 79588
2023-07-20 17:41:16.020 sogod[79588:79588] ERROR: could not open MySQL4 
connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using 
password: YES)
Jul 20 17:41:16 sogod [79588]: [ERROR] <0x0x55ce03f47520[GCSChannelManager]> 
could not open channel  
for mysql://localhost/sogo/sogo_user_profile
Jul 20 17:41:16 sogod [79588]: [WARN] <0x0x55ce03f47520[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200
2023-07-20 17:41:16.026 sogod[79587:79587] ERROR: could not open MySQL4 
connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using 
password: YES)
Jul 20 17:41:16 sogod [79587]: [ERROR] <0x0x55ce03e5a8c0[GCSChannelManager]> 
could not open channel  
for mysql://localhost/sogo/sogo_user_profile
Jul 20 17:41:16 sogod [79587]: [WARN] <0x0x55ce03e5a8c0[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200
2023-07-20 17:41:16.034 sogod[79586:79586] ERROR: could not open MySQL4 
connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using 
password: YES)
Jul 20 17:41:16 sogod [79586]: [ERROR] <0x0x55ce03e56270[GCSChannelManager]> 
could not open channel  
for mysql://localhost/sogo/sogo_user_profile
Jul 20 17:41:16 sogod [79586]: [WARN] <0x0x55ce03e56270[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2023-07-20 17:41:15 +0200
Jul 20 17:41:16 sogod [79588]: <0x0x55ce04083130[WOHttpAdaptor]> notified the 
watchdog that we are ready
Jul 20 17:41:16 sogod [79587]: <0x0x55ce040840a0[WOHttpAdaptor]> notified the 
watchdog that we are ready
Jul 20 17:41:16 sogod [79586]: <0x0x55ce04087de0[WOHttpAdaptor]> notified the 
watchdog that we are ready

 

Richard

 

Am 20.07.2023 um 17:08 schrieb qhivert (qhiv...@alinto.eu 
<mailto:qhiv...@alinto.eu> ):

Hello Richard,
Strange indeed. I assume you didn’t change the sogo.conf nor the password 
between?
Is this the log with the param MySQL4DebugEnabled = YES in your sogo.conf? If 
not could you add it and show us the logs?

Regards,
Quentin

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>   
<mailto:users-requ...@sogo.nu>  On Behalf Of Richard 
Rosner
Sent: jeudi 20 juillet 2023 16:23
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] SOGo no longer talking to mysql

 

Hi,

I had to reinstall SOGo because for some strange reason it just refused to 
accept any changes to the config. Now for some reason it can't connect to mysql 
anymore. In the sogo.conf I have e.g. >> SOGoProfileURL = 
"mysql://sogo:password@127.0.0.1:3306/sogo/sogo_user_profile 
<http://127.0.0.1:3306/sogo/sogo_user_profile> "; << and I have verified that 
mariadb is actually listening to 127.0.0.1:3306 <http://127.0.0.1:3306> . But 
when I restart SOGo to activate the config, I get 

 

Jul 20 15:53:10 sogod [73521]: <0x0x7fb00f4b7340[WOWatchDogChild]> watchdog 
request timeout set to 10 minutes
Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> preparing 3 
children
Jul 20 15:53:10 sogod [73521]: <0x0x55bd

RE: [SOGo] SOGo no longer talking to mysql

[qhivert]

Hello Richard,
Strange indeed. I assume you didn’t change the sogo.conf nor the password 
between?
Is this the log with the param MySQL4DebugEnabled = YES in your sogo.conf? If 
not could you add it and show us the logs?

Regards,
Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Richard Rosner
Sent: jeudi 20 juillet 2023 16:23
To: users@sogo.nu
Subject: [SOGo] SOGo no longer talking to mysql

 

Hi,

I had to reinstall SOGo because for some strange reason it just refused to 
accept any changes to the config. Now for some reason it can't connect to mysql 
anymore. In the sogo.conf I have e.g. >> SOGoProfileURL = 
"mysql://sogo:password@127.0.0.1:3306/sogo/sogo_user_profile"; << and I have 
verified that mariadb is actually listening to 127.0.0.1:3306. But when I 
restart SOGo to activate the config, I get 

 

Jul 20 15:53:10 sogod [73521]: <0x0x7fb00f4b7340[WOWatchDogChild]> watchdog 
request timeout set to 10 minutes
Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> preparing 3 
children
Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned 
with pid 73522
Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned 
with pid 73523
Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child spawned 
with pid 73524
2023-07-20 15:53:10.948 sogod[73523:73523] ERROR: could not open MySQL4 
connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using 
password: YES)
Jul 20 15:53:10 sogod [73523]: [ERROR] <0x0x55bdab3912c0[GCSChannelManager]> 
could not open channel  
for mysql://localhost/sogo/sogo_user_profile
Jul 20 15:53:10 sogod [73523]: [WARN] <0x0x55bdab3912c0[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2023-07-20 15:53:10 +0200
2023-07-20 15:53:10.948 sogod[73524:73524] ERROR: could not open MySQL4 
connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using 
password: YES)
2023-07-20 15:53:10.948 sogod[73522:73522] ERROR: could not open MySQL4 
connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using 
password: YES)
Jul 20 15:53:10 sogod [73522]: [ERROR] <0x0x55bdab390df0[GCSChannelManager]> 
could not open channel  
for mysql://localhost/sogo/sogo_user_profile
Jul 20 15:53:10 sogod [73524]: [ERROR] <0x0x55bdab373020[GCSChannelManager]> 
could not open channel  
for mysql://localhost/sogo/sogo_user_profile
Jul 20 15:53:10 sogod [73522]: [WARN] <0x0x55bdab390df0[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2023-07-20 15:53:10 +0200
Jul 20 15:53:10 sogod [73524]: [WARN] <0x0x55bdab373020[GCSChannelManager]>   
will prevent opening of this channel 5 seconds after 2023-07-20 15:53:10 +0200
Jul 20 15:53:11 sogod [73522]: <0x0x55bdab1b0510[WOHttpAdaptor]> notified the 
watchdog that we are ready
Jul 20 15:53:11 sogod [73523]: <0x0x55bdab589fc0[WOHttpAdaptor]> notified the 
watchdog that we are ready
Jul 20 15:53:11 sogod [73524]: <0x0x55bdab589050[WOHttpAdaptor]> notified the 
watchdog that we are ready

So of course I tried logging in manually to mysql, but this succedes without 
any complaints. Now what's the problem with it? I'm using mariadb-server 
10.11.3.

RE: [SOGo] undefined symbol: TNEFCheckForSignature

[qhivert]

Hello again Kenren,
I’ve built another package of ytnef attached to his mail.
Can you test it?

 

First stop the service sogod then remove only the old ytnef without its 
dependencies (or it will remove all sogo):

rpm -e –nodeps ytnef

Then install the package I give you:

yum install ytnef-2.1.2-1.el9.x86_64.rpm

Restart sogod then.

 

Regards,

Quentin

 

 

From: users-requ...@sogo.nu  On Behalf Of Kenren Taisho
Sent: jeudi 20 juillet 2023 09:18
To: users@sogo.nu
Subject: Re: [SOGo] undefined symbol: TNEFCheckForSignature

 

Hi Quentin,

Thanks for the reply, I am running on AlmaLinux 9.2.

 

 

Kind regards

 

On Thu, Jul 20, 2023 at 2:35 PM qhivert mailto:users@sogo.nu> > 
wrote:

Hello Kenren,

What OS do you use for SOGo? Maybe there was a problem while building this 
ytnef package.

Quentin

 

From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>  
mailto:users-requ...@sogo.nu> > On Behalf Of Kenren 
Taisho
Sent: mercredi 19 juillet 2023 09:04
To: users@sogo.nu <mailto:users@sogo.nu> 
Subject: [SOGo] undefined symbol: TNEFCheckForSignature

 

Dear all,


I am testing IOS client and found a subfolder not syncing or empty using EAS.
The error that I am getting in the sogo.log is:
---
/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature
/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature
---

and in apache.log

---
AH00898: Error reading from remote server returned by 
/Microsoft-Server-ActiveSync
[proxy_http:error] [pid 577548:tid 577610] (20014)Internal error (specific 
information not available): [client xx.xx.xx.xx:25524] AH01102: error reading 
status line from remote server 127.0.0.1:2 <http://127.0.0.1:2> 

---

I am using the updated ytnef package from the sogo repository:
Yerase TNEF Exporter v2.1.2

 

 

Any idea where to look and how to fix this?

 

Thanks in advance

RE: [SOGo] undefined symbol: TNEFCheckForSignature

[qhivert]

Hello Kenren,

What OS do you use for SOGo? Maybe there was a problem while building this 
ytnef package.

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Kenren Taisho
Sent: mercredi 19 juillet 2023 09:04
To: users@sogo.nu
Subject: [SOGo] undefined symbol: TNEFCheckForSignature

 

Dear all,


I am testing IOS client and found a subfolder not syncing or empty using EAS.
The error that I am getting in the sogo.log is:
---
/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature
/usr/sbin/sogod: symbol lookup error: 
/usr/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: 
TNEFCheckForSignature
---

and in apache.log

---
AH00898: Error reading from remote server returned by 
/Microsoft-Server-ActiveSync
[proxy_http:error] [pid 577548:tid 577610] (20014)Internal error (specific 
information not available): [client xx.xx.xx.xx:25524] AH01102: error reading 
status line from remote server 127.0.0.1:2  

---

I am using the updated ytnef package from the sogo repository:
Yerase TNEF Exporter v2.1.2

 

 

Any idea where to look and how to fix this?

 

Thanks in advance

RE: [SOGo] Sogo Read Receipts request

[qhivert]

Hello Stefan,

Indeed, there is no way to request receipt by default by now. You can open a 
feature request in our bug tracking system there -> 
https://www.sogo.nu/support.html#/bugs



Regards,

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of "Stefan 
Kladler"
Sent: mercredi 5 juillet 2023 16:22
To: users@sogo.nu
Subject: [SOGo] Sogo Read Receipts request

 

Hello,
My name is Stefan and i am using sogo with mailcow but i have a soge related 
topic. 

in sogo it is possible to activste the option to send red receipts if sogo gets 
one with incomming mail. that is default and so i can choose.

​​​it is also possible to request a read receipt when i compose a new email. so 
i have an user who asked that request read receipt should be chooseable by 
default so the user has not to choose read receipt with every new email 
composed.

Thank you for anny advice
stefan
 
 

RE: [SOGo] Migrating to SOGo

[qhivert]

Hello,
Thanks for your interest in sogo ! Here your answers:

1. Yes, you will just have to change the repo link on your 
/etc/apt/sources.list.d/SOGo.list file.
2. No, you will have a private Bug Tracker System where only you and Alinto 
will be able to see your tickets.
3. No feature differences between the stable and nightly apart the ones that 
are in development.
4. For now, Alinto tries to make a release every 3/4 month. But is has already 
happened that, if a bug is major/blocker, a new release is made as soon as 
possible.

Regards,
Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Kenren Taisho
Sent: mercredi 5 juillet 2023 10:35
To: users@sogo.nu
Subject: [SOGo] Migrating to SOGo

Hello.
We are in the process of migrating our current groupware to SOGo and would like 
to clarify the following:

1. We are currently using the nightly build for testing but will eventually use 
the stable build and will subscribe to premium support service. Is it just a 
matter of switching the repository from nightly to stable and do a package 
manager system update?
2. Is the support portal mentioned on the commercial page this same mailing 
list?
3. Is there no feature difference between the nightly build and the stable 
build?
4. If a bug is fixed in the nightly build, how soon does that fix reflect in 
the stable build?

Apologies for all the questions and thanks in advance for the answers.


Kind regards

RE: [SOGo] SAML login not working / Keycloak 21.1.1 / Debian bookworm

[qhivert]

Hello,
The profile.c if from the lasso module -> 
https://github.com/adieu/lasso/blob/master/lasso/saml-2.0/profile.c

We need to find which lasso function in SOGoSAML2Session.m (I assume, it may be 
another file)  is called and make that error, then check the arguments given.

Quentin

-Original Message-
From: users-requ...@sogo.nu  On Behalf Of Claas Hilbrecht
Sent: mardi 27 juin 2023 20:55
To: users@sogo.nu
Subject: Re: [SOGo] SAML login not working / Keycloak 21.1.1 / Debian bookworm

Hi,

I recompiled the sogo 5.8.4 package from Debian sid and added some NSLog 
outputs. So I can confirm that the SAML response is really ok and the content 
is fine. But it seems something in my setup is wrong.

SOGo writes the current session to the sogo_sessions_folder. This works fine, 
the content in stored in the mysql db. But after storing the session two errors 
get logged:

---
(process:20775): Lasso-CRITICAL **: 20:45:24.648: 2023-06-27 20:45:24  
(profile.c/:913) Trying to unref a non GObject pointer  
file=profile.c:913 pointerbybname=profile->identity  
pointer=0x55c2ab612ec0

(process:20775): Lasso-CRITICAL **: 20:45:24.648: 2023-06-27 20:45:24  
(profile.c/:916) Trying to unref a non GObject pointer  
file=profile.c:916 pointerbybname=profile->session  
pointer=0x55c2ab547c90
---

I can't find the profile.c source code for now but I assumed sogo  
tried to read from the table sogo_user_profile the users profile. But  
even after creating this entry

INSERT INTO `sogo_user_profile` (`c_uid`, `c_defaults`, `c_settings`) VALUES
('claas.hilbre...@example.com', '{}', '{}');

I still get the above error... So what I'm missing?

---
Jun 27 18:45:24 sogod [20775]: 79.140.187.148, 172.27.11.107 "GET  
/SOGo//claas.hilbre...@example.com HTTP/1.1" 302 0/0 0.015 - - 0 - 13
Jun 27 18:45:24 sogod [20775]: |SOGo| starting method 'POST' on uri  
'/SOGo/saml2-signon-post'
2023-06-27 18:45:24.643 sogod[20775:20775] loginA: claas.hilbre...@example.com
2023-06-27 18:45:24.643 sogod[20775:20775] loginB: claas.hilbre...@example.com
2023-06-27 18:45:24.643 sogod[20775:20775] loginC: claas.hilbre...@example.com
2023-06-27 18:45:24.643 sogod[20775:20775] assertionA: https://auth.example.com/realms/masterhttp://www.w3.org/2000/09/xmldsig#;>http://www.w3.org/2001/10/xml-exc-c14n#"/>http://www.w3.org/2001/04/xmldsig-more#rsa-sha256"/>http://www.w3.org/2000/09/xmldsig#enveloped-signature"/>http://www.w3.org/2001/10/xml-exc-c14n#"/>http://www.w3.org/2001/04/xmlenc#sha256"/>KNo7JjLw1k6KyvJCzBkw6firW3TO2IvMr9Z+NiIeJqE=aDvUyS7iFXxi9ILF6byZeh1wbmqu2928G2KNa7zWGGEK0bDTv6udgHtoVnaBJ1+s4JE7G5QCBc/0KdmK+qveGwITcTXLSaSZHZuKfF3Nd1Q8HbA/m7YX9F0E8qFHBQkBCGvbSiR2Jttn2YXkGsxy+T455dV24Fl840KkM9ENiG4e2kHExHdM1aFMQbgBMxdJcWhBTkatnawBvSv5PpTvG8u0bU4UX7RlsdGnK+OnWCCe8tH1aKLUUaDRANuiEzroyVdBLbXEnmiYLru8QIx9ycckrx6NuIw6kNX73g07S5uQUS9fxemYs6BRNcHUHboL/aRPdq1XrgUDdBsTdDiFdQ==lW-L-g3kaWfrc5goQbcyY8W77J3-dWbKGA1joPXW19MMIICmzCCAYMCBgGAiWAFjDANBgkqhkiG9w0BAQsFADARMQ8wDQYDVQQDDAZtYXN0ZXIwHhcNMjIwNTAzMTAwMTUzWhcNMzIwNTAzMTAwMzMzWjARMQ8wDQYDVQQDDAZtYXN0ZXIwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCKbGwTJIDI7FURSwl83/CH15MTTVXN9ieRRcJ6Bd/tXogpNLMpqKCbMT3gdn7mF9XR+xNryKCwPIcDO2TMOE9yXxyLe4SQvj06zR+dK/v63sJk783rRO7APLFmoamQtONDc5nfqz3DpKbTCO0AqIK8Ki44TzQviEYaMzidApMI46bDl0ep5o/zCgzmNlVIZFdah4wp7c1wRw3+RVlrgJonT3dY7C+mHhLYrQ+pZsWb/6hmt1mvglf+Vh6iQrt6/I7uCMHH9LxxdRyaCCLZly6Zdei0qjlmp+VRTm+EMscct6kmeOgAXX5KCSh6n+flx7neL+MlQ0fgtGaBrnaxLzPDAgMBAAEwDQYJKoZIhvcNAQELBQADggEBAGOhSwEHfHPbBk/QmyYfIvvMekDEj6iZCx/mrLRY0QuZzimsGgTFGM4kHH3kBwRvrswiB/VFloUrAtSBK6/NLc7CGNAdZ+pazOYcD/b0FtmoeGNixQluXVPdzsLYLVVvxHC/XrHS7C9Ne2bfwal+OP5c/emuNuV6PSmqo8XZhSP3025TapoDph+07DKRZUiJbCYcKgWrW+/UbaLCi0enf7qY2q7f8ztCwMxkClNN1RxQb/Fh78CG8eIW5hypyP/FLMlcOiDMLynwoSxSuinuIT/pzS8KW5nh8CftevPh8peCrlLv6Xzux7Ys3FANnXOhUEKsgM1c+PTen87Nq3JZ6RM=G-2594070f-2a5d-452d-8a25-97a59350d785https://sogo.example.com/SOGo/saml2-signon-post"/>https://sogo.example.com/SOGo/saml2-metadataurn:oasis:names:tc:SAML:2.0:ac:classes:unspecifiedhttp://www.w3.org/2001/XMLSchema; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance; 
xsi:type="xs:string">claas.hilbre...@example.comhttp://www.w3.org/2001/XMLSchema; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;  
xsi:type="xs:string">clahil
2023-06-27 18:45:24.643 sogod[20775:20775] identifierA:  
G-2594070f-2a5d-452d-8a25-97a59350d785
2023-06-27 18:45:24.645 sogod[20775:20775]  
 SQL:  
BEGIN;
2023-06-27 18:45:24.646 sogod[20775:20775]  
   query  
has no results.
2023-06-27 18:45:24.646 sogod[20775:20775]  
 SQL:  
SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM   
sogo_sessions_folder t1 WHERE t1.c_id='AY9zox6L6tlqhvTT';
2023-06-27 18:45:24.646 sogod[20775:20775]  
   query  
has results, entering fetch-mode.
2023-06-27 18:45:24.646 sogod[20775:20775]  
 SQL:  
ROLLBACK;
2023-06-27 18:45:24.646 sogod[20775:20775]  
   query  
has no results.
2023-06-27 18:45:24.646 sogod[20775:20775]  
 SQL:  
BEGIN;
2023-06-27 18:45:24.646 sogod[20775:20775]