[SOGo] BTS activities for Friday, May 06 2022

2022-05-06 Thread SOGo reporter
Title: BTS activities for Friday, May 06 2022





  
BTS Activities

  Home page: https://sogo.nu/bugs
  Project: SOGo
  For the period covering: Friday, May 06 2022

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5459
	2022-05-06 02:55:22
	updated (open)
	Backend Calendar
	Dismiss calendar events
	
	  
	
5514
	2022-05-06 08:29:57
	updated (open)
	GUI
	Hide user accounts from each other
	
	  
	
5515
	2022-05-06 03:25:47
	updated (open)
	GUI
	dreaded 'Internal server error' returns with 5.6.0
	
	  
	
  
  


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

Re: [SOGo] problems with 5.6.0

2022-05-06 Thread sogo-us...@list-post.ddt-consult.de

Am 06.05.22 um 00:18 schrieb "Carsten Pieper" (i...@carstenpieper.com):


I had the problem with SOGo 5.5.1 on Ubuntu 20.04.4, that I could not get
tot he settings screen after login of a user.

  


I thought it is a good idea to update to 5.6.0 to get rid of it, but anyhow,
no login at all is possible any longer.

  


After login of any user I get „Unbehandelte Fehlerantwort“ unhandled error
response.

  


There is nothing suspicious in var/log/sogo/sogo.log, even though some
Debug-Options are enabled in /etc/sogo/sogo.conf

  


Does anyone have a hint for me where I could solve my problem?


Did you drop or modify the session table as the upgrades notes say?
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_upgrading

--
Regards
  mks

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


Re: [SOGo] problems with 5.6.0

2022-05-06 Thread Adi Kriegisch
Dear Carsten, 

> I thought it is a good idea to update to 5.6.0 to get rid of it, but anyhow,
> no login at all is possible any longer.
> 
> After login of any user I get „Unbehandelte Fehlerantwort“ unhandled error
> response.
I assume, you're using nginx. As I've already written[1], the error
message is a consequence of bigger header data. You'll need to update
the buffer values in your nginx config:

proxy_buffer_size 8k;
proxy_buffers 4 64k;

To find the error message, just check your nginx error log. In my case,
the following got logged to sogo.log:
[ERROR] <0xX[WOHttpTransaction]>
client disconnected during delivery of response for  
(len=50): the socket was shutdown

and nginx' error log:
*123456 upstream sent too big header while reading response
header from upstream, client: ip.add.re.ss, server: sogo.example.com,
request: "POST /SOGo/connect HTTP/1.1", upstream: 
"http://127.0.0.1:2/SOGo/connect;,
host: "sogo.example.com", referrer: https://sogo.example.com/SOGo/; 

After increasing the buffer size and reloading nginx it worked again.
(btw. do not forget to upgrade your database scheme as this is required
for 5.5.1 -> 5.6.0 upgrade).

-- Adi

[1] https://www.mail-archive.com/users%40sogo.nu/msg31359.html



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

RE: [SOGo] strange problem with just one user's personal address book

2022-05-06 Thread Kai-Uwe Rommel - ARS
Ok, running the database upgrade script again probably fixed it ... although it 
complained
"Duplicate column name 'c_hascertificate'" so it already has been there? Hmm.

Kai-Uwe Rommel


From: Kai-Uwe Rommel - ARS
Sent: Friday, May 6, 2022 10:05 AM
To: users@sogo.nu
Subject: strange problem with just one user's personal address book

Hi, I'm running an old 2.4 SOGo server and have a strange problem:
Several users use e-mail, calendar and contacts. They mostly use Thunderbird on 
the PC
with IMAP/CalDAV/CardDAV, some also use the browser interface and most have a
smartphone connected to the same data via ActiveSync. All those work fine but 
for one
user the contacts "do not work":

The user has 76 contacts, created from Thunderbird, originally in Thunderbirds 
local
address book. I have helped the user and exported the contacts, connected the
SOGo personal address book into his Thunderbird via the CardDAV URL and imported
the contacts into this. No error or warnings. The contacts are visible in his 
Thunderbird
in the CardDAV folder and clicking "Synchronize" does not yield any error. But 
when the
user logs in to the SOGo web UI, the personal address book there is just empty.
I tried importing the same contacts vCard file in the web UI as well and again 
had no
error or warning (e.g. "76 contacts imported") but they do not show up.
On the connected smartphone (Android running "BlueMail") the contacts also do 
not
show up (but e-mail and calendar do).
In the user's web UI I then created a "new address book" in addition to the 
standard
personal address book. Imported the vCard file into this and it works fine, all 
contacts
are shown in this new address book.
But, obviously, this does not really work, I need to make the standard "personal
address book" work.

The only error I see in sogo.log (when trying to copy a single contact from the 
"new
address book" to the non-working "personal address book") is:

May 06 10:02:06 sogod [22977]: <0x0x55fffdfb8638[GCSFolder]> ERROR(-[GCSFolder 
writeContent:fromComponent:container:toName:baseVersion:]): cannot insert 
content :  NAME:ExecutionFailed REASON:Unknown 
column 'c_hascertificate' in 'field list'
May 06 10:02:06 sogod [22977]: [ERROR] 
<0xFE07B168[SOGoContactGCSEntry]:59C1-6274D600-B7-49476E80.vcf> write failed: 
 NAME:ExecutionFailed REASON:Unknown column 
'c_hascertificate' in 'field list'

Does anyone have an idea what might be the problem? I have not seen such a 
problem
before ...

Kai-Uwe Rommel

ARS Computer und Consulting GmbH, www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software-Entwicklungsprojekte, Software-Architektur, Cloud-Transformation, 
Mainframe- und Legacy Java-Modernisierung

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://www.ars.de/datenschutz/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] problems with 5.6.0

2022-05-06 Thread "Carsten Pieper"
Hey sogo community,

 

I had the problem with SOGo 5.5.1 on Ubuntu 20.04.4, that I could not get
tot he settings screen after login of a user.

 

I thought it is a good idea to update to 5.6.0 to get rid of it, but anyhow,
no login at all is possible any longer.

 

After login of any user I get „Unbehandelte Fehlerantwort“ unhandled error
response.

 

There is nothing suspicious in var/log/sogo/sogo.log, even though some
Debug-Options are enabled in /etc/sogo/sogo.conf

 

Does anyone have a hint for me where I could solve my problem?

 

Thank you so much in advance,

 

Carsten

 

 

 



CARSTEN PIEPER
Dyckburgheide 1
48157 Münster
Deutschland


Fon:

+49 251 3997257


Fax:

+49 251 3997256


Mobil:

+49 151 46673961


E-Mail:

  i...@carstenpieper.com


Internet:

  www.carstenpieper.com

 

 

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

[SOGo] strange problem with just one user's personal address book

2022-05-06 Thread Kai-Uwe Rommel - ARS
Hi, I'm running an old 2.4 SOGo server and have a strange problem:
Several users use e-mail, calendar and contacts. They mostly use Thunderbird on 
the PC
with IMAP/CalDAV/CardDAV, some also use the browser interface and most have a
smartphone connected to the same data via ActiveSync. All those work fine but 
for one
user the contacts "do not work":

The user has 76 contacts, created from Thunderbird, originally in Thunderbirds 
local
address book. I have helped the user and exported the contacts, connected the
SOGo personal address book into his Thunderbird via the CardDAV URL and imported
the contacts into this. No error or warnings. The contacts are visible in his 
Thunderbird
in the CardDAV folder and clicking "Synchronize" does not yield any error. But 
when the
user logs in to the SOGo web UI, the personal address book there is just empty.
I tried importing the same contacts vCard file in the web UI as well and again 
had no
error or warning (e.g. "76 contacts imported") but they do not show up.
On the connected smartphone (Android running "BlueMail") the contacts also do 
not
show up (but e-mail and calendar do).
In the user's web UI I then created a "new address book" in addition to the 
standard
personal address book. Imported the vCard file into this and it works fine, all 
contacts
are shown in this new address book.
But, obviously, this does not really work, I need to make the standard "personal
address book" work.

The only error I see in sogo.log (when trying to copy a single contact from the 
"new
address book" to the non-working "personal address book") is:

May 06 10:02:06 sogod [22977]: <0x0x55fffdfb8638[GCSFolder]> ERROR(-[GCSFolder 
writeContent:fromComponent:container:toName:baseVersion:]): cannot insert 
content :  NAME:ExecutionFailed REASON:Unknown 
column 'c_hascertificate' in 'field list'
May 06 10:02:06 sogod [22977]: [ERROR] 
<0xFE07B168[SOGoContactGCSEntry]:59C1-6274D600-B7-49476E80.vcf> write failed: 
 NAME:ExecutionFailed REASON:Unknown column 
'c_hascertificate' in 'field list'

Does anyone have an idea what might be the problem? I have not seen such a 
problem
before ...

Kai-Uwe Rommel

ARS Computer und Consulting GmbH, www.ars.de
ein Unternehmen der TIMETOACT Group
Garmischer Straße 7, 80339 München, Deutschland

ARS - The Art of Software Engineering
Software-Entwicklungsprojekte, Software-Architektur, Cloud-Transformation, 
Mainframe- und Legacy Java-Modernisierung

Handelsregister München, HRB 101829, USt-ID: DE 155 068 909
Geschäftsführer: Stefan Schäffer, Michael Arbesmeier
Datenschutzerklärung: https://www.ars.de/datenschutz/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists