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;
signature.asc
Description: PGP signature
