Bug#1038647: Sogo : Error at logon

[Joffrey]

Package: sogo
Version: 5.8.0-1

Severity: important

Objet : Sogo error at logon

Paquet : sogo
Version : 5.8.0-1

Hi all,

I have upgrade my debian from Bullseye to Bookworm.

Now i have an error when i try to logon on sogo.

Versions :
sogo have been upgrade from 5.0.1-4 to 5.8.0-1
postgresql have been upgrade from v13 to v15.
php have been upgrade from 7.4 to 8.2

I have passed my question on the bug page project but with no serious response.

https://bugs.sogo.nu/view.php?id=5792


Today i run the bullseye version which is not really good thing.


The problem is the following.

Error log :

Jun 15 21:27:59 sogod [2397]: [ERROR] <0x0x5568f192b8f0[GCSSessionsFolder]> -[GCSSessionsFolder writeRecordForEntryWithID:value:creationDate:lastSeenDate:]: cannot write record: <PostgreSQL72Exception: 0x5568f19c5a00> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x5568f1811b40[PostgreSQL72Channel]: connection=<0x0x5568f1770da0[PGConnection]:  connection=0x0x5568f17a3dd0>>): ERREUR:  valeur trop longue pour le type character varying(255)


Full log at logon :

Jun 15 21:27:59 sogod [2397]: |SOGo| starting method 'POST' on uri '/SOGo/connect'
Jun 15 21:27:59 sogod [2397]: |SOGo| traverse(acquire): SOGo => connect
Jun 15 21:27:59 sogod [2397]: |SOGo|   do traverse name: 'SOGo'
Jun 15 21:27:59 sogod [2397]: |SOGo|   do traverse name: 'connect'
Jun 15 21:27:59 sogod [2397]: |SOGo| set clientObject: <SOGo[0x0x5568f142aab0]: name=SOGo>
2023-06-15 21:27:59.664 sogod[2397:2397] PG0x0x5568f1834420 SQL: SELECT c_password FROM sogo_users WHERE c_uid = 'MYUSERRRR'
Jun 15 21:27:59 sogod [2397]: SOGoRootPage successful login from '127.0.0.1' for user 'MYUSERRRR' - expire = -1  grace = -1
2023-06-15 21:27:59.667 sogod[2397:2397] PG0x0x5568f1834420 SQL: BEGIN TRANSACTION
2023-06-15 21:27:59.667 sogod[2397:2397] PG0x0x5568f1834420 SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM  sogo_sessions_folder t1 WHERE t1.c_id='Ih+0ExE6IXxvI4SP'
2023-06-15 21:27:59.667 sogod[2397:2397] PG0x0x5568f1834420 SQL: ROLLBACK TRANSACTION
2023-06-15 21:27:59.667 sogod[2397:2397] PG0x0x5568f1811b40 SQL: BEGIN TRANSACTION
2023-06-15 21:27:59.668 sogod[2397:2397] PG0x0x5568f1811b40 SQL: INSERT INTO sogo_sessions_folder (c_lastseen, c_creationdate, c_value, c_id) VALUES (1686857279, 1686857279, '6XyPpjOma6hzKi9D2zEKtaBCfq5HalKWnZwOWR/l6q9QwsWbTy1YzNbzg5RpDpbSKCM4OnyEcM2VnwE2QKQrxHqDD87XI1ZG+JkJ5dKeBmiZ/xN4aKbSQZ30XcUHu8z4jTcOKwfNjgufX9F/xAiqTgmQcEx7sZoVy9+uag3P8haYHnQJXk18giBrg3CrWskj7QKJjN0f7f0XINaiwPZMTOM1el+WwIP1e2sKBzE0A6Ght0luvaS5ykqWG4Qo+56tOrkw6/G4BP1Jt41ytVPV6dcy2rGxu5ilcDYsMhVvy4IUfEuCRebuJzg1yivBjx1WeJqhGai/DCzi8HXE8oTLG/NfpH2sGTeVEhYBSr5DPfNHHfzgePzGAJNp5KO6vyZ3n6/0JXrXktTZjE40hw6iygeK3DvLqpkvR5Aj/DYaE/Vj2sk0UAhvvMCiQ9sCfeu28eWZDhUuicq3ZnQlOkMTlS8YtB8UUeXAfM5sCzhG4CFRvG+TBLMNy7nGXb/ZjXFxqXHZ+LHcPVB/mHgX8pKE7PQogWQoYijlK+7inKt5fhnTZ8UKnLBl72h97HLrYu4Pwx5ZRZuqqoXfo34elUy8s/2uKteZfS76JbgaMoIoAks0ozc2WacJcS0gZ/jnNQeHlIwBAfCJ7ixTOak
......................................................................................................................................................................................................................................................................................................................................................................................................................................................................bKiocLsHDdUkPHhC9TFkWeqU86ObVzKQrkOPcpVq1RdSZwPAXkJh2dHGyI3SEoUPf8Kt8Y7D5IjdBgkxvvaMadP9uU+/Ki6DhS4Ut/VC5PQH0TdkHS0diwMdJmkeHD6rH7IFJmGFM5wZJBaJCiBMCedgDesqFj+wVsXv7QZOAGMqOpatZlRzc8bVTwZjkH2pOTEB7JGzY=', 'Ih+0ExE6IXxvI4SP')
2023-06-15 21:27:59.668 sogod[2397:2397] PG0x0x5568f1811b40 SQL: ROLLBACK TRANSACTION
Jun 15 21:27:59 sogod [2397]: [ERROR] <0x0x5568f192b8f0[GCSSessionsFolder]> -[GCSSessionsFolder writeRecordForEntryWithID:value:creationDate:lastSeenDate:]: cannot write record: <PostgreSQL72Exception: 0x5568f19c5a00> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x5568f1811b40[PostgreSQL72Channel]: connection=<0x0x5568f1770da0[PGConnection]:  connection=0x0x5568f17a3dd0>>): ERREUR:  valeur trop longue pour le type character varying(255)

Jun 15 21:27:59 sogod [2397]: |SOGo| request took 0.005227 seconds to execute
Jun 15 21:27:59 sogod [2397]: <0x0x5568f1898d50[WOResponse]> Zipping of response disabled
Jun 15 21:27:59 sogod [2397]: 127.0.0.1 "POST /SOGo/connect HTTP/1.1" 200 39/77 0.006 - - 0 - 14
Jun 15 21:27:59 sogod [2397]: |SOGo| starting method 'POST' on uri '/SOGo/so/passwordRecoveryEnabled'
Jun 15 21:27:59 sogod [2397]: |SOGo| traverse(acquire): passwordRecoveryEnabled
Jun 15 21:27:59 sogod [2397]: |SOGo|   do traverse name: 'passwordRecoveryEnabled'
Jun 15 21:27:59 sogod [2397]: |SOGo| request took 0.000506 seconds to execute
Jun 15 21:27:59 sogod [2397]: <0x0x5568f1762e70[WOResponse]> Zipping of response disabled
Jun 15 21:27:59 sogod [2397]: 127.0.0.1 "POST /SOGo/so/passwordRecoveryEnabled HTTP/1.1" 403 0/39 0.001 - - 0 - 14


Thank you a lot

[Jordi Mallach]

El dl. 19 de 06 de 2023 a les 18:06 +0200, en/na Joffrey va escriure:

> Now i have an error when i try to logon on sogo.
>
> Versions :
> sogo have been upgrade from 5.0.1-4 to 5.8.0-1

> connection=0x0x5568f17a3dd0>>): ERREUR:  valeur trop longue pour le
> type character varying(255)

You're missing a schema update. Have a look at
/usr/share/doc/sogo/NEWS.Debian,
and make sure you execute the corresponding upgrade script as described
there.

If you use nginx, make sure you also update your config.

Please ack if this fixes your issues.

Jordi

--
Jordi Mallach <jo...@mallach.net>

[Joffrey]

Thank you a lot for your answer.

It work now !

On Tue, 20 Jun 2023 10:18:52 +0200 Jordi Mallach <jo...@mallach.net> wrote:

> El dl. 19 de 06 de 2023 a les 18:06 +0200, en/na Joffrey va escriure:

> > Now i have an error when i try to logon on sogo.
> >
> > Versions :
> > sogo have been upgrade from 5.0.1-4 to 5.8.0-1

> > connection=0x0x5568f17a3dd0>>): ERREUR:  valeur trop longue pour le
> > type character varying(255)
>