<html><div>Package: sogo<br />Version: 5.8.0-1</div><pre class="message">Severity: important</pre><br /><br />Objet : Sogo error at logon<br /><br />Paquet : sogo<br />Version : 5.8.0-1<br /><br />Hi all,<br /><br />I have upgrade my debian from Bullseye to Bookworm.<br /><br />Now i have an error when i try to logon on sogo.<br /><br />Versions :<br />sogo have been upgrade from 5.0.1-4 to 5.8.0-1<br />postgresql have been upgrade from v13 to v15.<br />php have been upgrade from 7.4 to 8.2<br /><br />I have passed my question on the bug page project but with no serious response.<br /><br />https://bugs.sogo.nu/view.php?id=5792<br /><br /><br />Today i run the bullseye version which is not really good thing.<br /><br /><br />The problem is the following.<br /><br />Error log :<br /><br />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)<br /><br /><br />Full log at logon :<br /><br />Jun 15 21:27:59 sogod [2397]: |SOGo| starting method 'POST' on uri '/SOGo/connect'<br />Jun 15 21:27:59 sogod [2397]: |SOGo| traverse(acquire): SOGo => connect<br />Jun 15 21:27:59 sogod [2397]: |SOGo| do traverse name: 'SOGo'<br />Jun 15 21:27:59 sogod [2397]: |SOGo| do traverse name: 'connect'<br />Jun 15 21:27:59 sogod [2397]: |SOGo| set clientObject: <SOGo[0x0x5568f142aab0]: name=SOGo><br />2023-06-15 21:27:59.664 sogod[2397:2397] PG0x0x5568f1834420 SQL: SELECT c_password FROM sogo_users WHERE c_uid = 'MYUSERRRR'<br />Jun 15 21:27:59 sogod [2397]: SOGoRootPage successful login from '127.0.0.1' for user 'MYUSERRRR' - expire = -1 grace = -1<br />2023-06-15 21:27:59.667 sogod[2397:2397] PG0x0x5568f1834420 SQL: BEGIN TRANSACTION<br />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'<br />2023-06-15 21:27:59.667 sogod[2397:2397] PG0x0x5568f1834420 SQL: ROLLBACK TRANSACTION<br />2023-06-15 21:27:59.667 sogod[2397:2397] PG0x0x5568f1811b40 SQL: BEGIN TRANSACTION<br />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<br />......................................................................................................................................................................................................................................................................................................................................................................................................................................................................bKiocLsHDdUkPHhC9TFkWeqU86ObVzKQrkOPcpVq1RdSZwPAXkJh2dHGyI3SEoUPf8Kt8Y7D5IjdBgkxvvaMadP9uU+/Ki6DhS4Ut/VC5PQH0TdkHS0diwMdJmkeHD6rH7IFJmGFM5wZJBaJCiBMCedgDesqFj+wVsXv7QZOAGMqOpatZlRzc8bVTwZjkH2pOTEB7JGzY=', 'Ih+0ExE6IXxvI4SP')<br />2023-06-15 21:27:59.668 sogod[2397:2397] PG0x0x5568f1811b40 SQL: ROLLBACK TRANSACTION<br />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)<br /><br />Jun 15 21:27:59 sogod [2397]: |SOGo| request took 0.005227 seconds to execute<br />Jun 15 21:27:59 sogod [2397]: <0x0x5568f1898d50[WOResponse]> Zipping of response disabled<br />Jun 15 21:27:59 sogod [2397]: 127.0.0.1 "POST /SOGo/connect HTTP/1.1" 200 39/77 0.006 - - 0 - 14<br />Jun 15 21:27:59 sogod [2397]: |SOGo| starting method 'POST' on uri '/SOGo/so/passwordRecoveryEnabled'<br />Jun 15 21:27:59 sogod [2397]: |SOGo| traverse(acquire): passwordRecoveryEnabled<br />Jun 15 21:27:59 sogod [2397]: |SOGo| do traverse name: 'passwordRecoveryEnabled'<br />Jun 15 21:27:59 sogod [2397]: |SOGo| request took 0.000506 seconds to execute<br />Jun 15 21:27:59 sogod [2397]: <0x0x5568f1762e70[WOResponse]> Zipping of response disabled<br />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<br /><br /><br />Thank you a lot</html>