Re: some issues with sogo 5.7.1 in 7.2

On Mon, Nov 28, 2022 at 02:57:07PM +0100, Landry Breuil wrote:
> Hi,
>
> finally upgraded my work sogo instance, hit two distinct issues
> unrelated to the WOPort one, both seen when trying to login:
>
> [GCSSessionsFolder
> writeRecordForEntryWithID:value:creationDate:lastSeenDate:]: cannot
> write record: <PostgreSQL72Exception: 0x313372437c8>
> NAME:PostgreSQL72FatalError REASON:fatal pgsql error
> (channel=<0x0x31374da1608[PostgreSQL72Channel]:
> connection=<0x0x3135d728468[PGConnection]:
> connection=0x0x313651c3800>>): ERROR: value too long for type character
> varying(255)
>
> found https://bugs.sogo.nu/view.php?id=5491 - from what i can see,
> https://github.com/Alinto/sogo/blob/master/Scripts/sql-update-5.5.1_to_5.6.0.sh
> isnt packaged in /usr/local/share/doc/sogo/. Maybe the PLIST should be
> updated ? anyway, solved it locally with psql:
>
> sogo=> ALTER TABLE sogo_sessions_folder ALTER COLUMN c_value TYPE
> VARCHAR(4096);
>
> but also 'upstream sent too big header while reading response header
> from upstream' in nginx error logs, cf
> https://www.sogo.nu/support/faq/errors-in-nginx-regarding-header-too-big.html#/faq
>
> i already had some proxy buffers config in nginx (coming from the
> pkg-readme), had to bump them and could login just fine.
>
> so .. maybe also update the pkg-readme with the values recommended
> upstream ?
>
this diff works for me with Mariadb (nginx part untested).
ok ? What about 7.2 ?
Cheers
Giovanni

Index: Makefile
===================================================================
RCS file: /cvs/ports/www/sogo/Makefile,v
retrieving revision 1.102
diff -u -p -r1.102 Makefile
--- Makefile 8 Nov 2022 11:17:20 -0000 1.102
+++ Makefile 29 Nov 2022 23:35:11 -0000
@@ -1,7 +1,7 @@
COMMENT = web based groupware server

VERSION = 5.7.1
-REVISION = 1
+REVISION = 2
DISTNAME = SOGo-${VERSION}
PKGNAME = sogo-${VERSION}

@@ -52,7 +52,7 @@ SUBST_VARS += SOGOLIBDIR VARBASE
SCRIPTS = cas-proxy-validate.py sql-update-2.2.17_to_2.3.0.sh \
sql-update-3.2.10_to_4.0.0.sh sql-update-2.2.17_to_2.3.0-mysql.sh \
sql-update-3.2.10_to_4.0.0-mysql.sh sql-update-3.0.0-to-combined.sh \
- sql-update-3.0.0-to-combined-mysql.sh updates.php
+ sql-update-3.0.0-to-combined-mysql.sh sql-update-5.5.1_to_5.6.0.sh updates.php

post-install:
${INSTALL_DATA_DIR} ${PREFIX}/share/doc/sogo
Index: pkg/PLIST
===================================================================
RCS file: /cvs/ports/www/sogo/pkg/PLIST,v
retrieving revision 1.54
diff -u -p -r1.54 PLIST
--- pkg/PLIST 8 Nov 2022 11:17:20 -0000 1.54
+++ pkg/PLIST 29 Nov 2022 23:35:11 -0000
@@ -2875,6 +2875,7 @@ share/doc/sogo/sql-update-3.0.0-to-combi
share/doc/sogo/sql-update-3.0.0-to-combined.sh
share/doc/sogo/sql-update-3.2.10_to_4.0.0-mysql.sh
share/doc/sogo/sql-update-3.2.10_to_4.0.0.sh
+share/doc/sogo/sql-update-5.5.1_to_5.6.0.sh
share/doc/sogo/updates.php
share/examples/login.conf.d/sogod
@sample ${SYSCONFDIR}/login.conf.d/sogod
Index: pkg/README
===================================================================
RCS file: /cvs/ports/www/sogo/pkg/README,v
retrieving revision 1.25
diff -u -p -r1.25 README
--- pkg/README 19 Sep 2022 07:01:08 -0000 1.25
+++ pkg/README 29 Nov 2022 23:35:11 -0000
@@ -109,8 +109,8 @@ server {
proxy_connect_timeout 90;
proxy_send_timeout 90;
proxy_read_timeout 90;
- proxy_buffer_size 4k;
- proxy_buffers 4 32k;
+ proxy_buffer_size 64k;
+ proxy_buffers 8 64k;
proxy_busy_buffers_size 64k;
proxy_temp_file_write_size 64k;
client_max_body_size 50m;