[Pkg-sogo-maintainers] Bug#1038647: Sogo : Error at logon

[Joffrey]

Package: sogo
Version: 5.8.0-1Severity: 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-sogo-maintainers/attachments/20230619/8f3fb3ca/attachment.htm>