Dependency Graph

View IssueRelationship GraphVerticalShow Summary
Dependency Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005792SOGoPackaging (Debian)public2023-06-16 11:442023-06-20 12:14
Reporterelectro575 Assigned Tosebastien  
PriorityurgentSeverityblockReproducibilityalways
Status closedResolutionreopened 
PlatformServerOSDebian OS VersionBookworm
Product Version5.8.0 
Summary0005792: [DEBIAN Bookworm] : Not arrived to login on Sogo
Description

Hi all,

I have upgrade my debian from Bullseye to Bookworm.

Now i have an error when i try to login into sogo.

postgresql have been upgrade from v13 to v15.
sogo have been upgrade from 5.0.1-4 to 5.8.0-1

The problem is the following.

Isolate 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)

Entier log :

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

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
duplicate of 0005787 closedsebastien [EDIT] Debian 12 "Bookworm" support 

Activities

sebastien

sebastien

2023-06-18 08:02

administrator   ~0017049

Unsupported OS yet, duplicate 0005787
electro575

electro575

2023-06-19 16:12

reporter   ~0017056

It's not the same problem than the other ticket on debian bookworm !

Have you an Idea please ?

Thank you a lot.
SlavekB

SlavekB

2023-06-20 07:39

reporter   ~0017058

It looks like you didn't convert the database column. See the script: /usr/share/doc/sogo/sql-update-5.5.1_to_5.6.0.sh
electro575

electro575

2023-06-20 11:42

reporter   ~0017062

It's good, thanks. With two parameters for nginx.

proxy_buffer_size 8k;
proxy_buffers 4 64k;

Issue History

Date Modified Username Field Change
2023-06-16 11:44 electro575 New Issue
2023-06-18 08:02 sebastien Note Added: 0017049
2023-06-18 08:02 sebastien Relationship added duplicate of 0005787
2023-06-18 08:03 sebastien Assigned To => sebastien
2023-06-18 08:03 sebastien Status new => closed
2023-06-18 08:03 sebastien Resolution open => duplicate
2023-06-19 16:12 electro575 Status closed => feedback
2023-06-19 16:12 electro575 Resolution duplicate => reopened
2023-06-19 16:12 electro575 Note Added: 0017056
2023-06-20 07:39 SlavekB Note Added: 0017058
2023-06-20 11:42 electro575 Note Added: 0017062
2023-06-20 11:42 electro575 Status feedback => assigned
2023-06-20 12:14 sebastien Status assigned => closed