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