Hello jacek burghardt

Am 2014-12-04 um 04:37 schrieb jacek burghardt:
> I having an issue login into sogo  I get this errors
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key
> 'jacek+dn': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key
> 'jacek+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key
> 'jacek+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key '
> ja...@hebe.us+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED
> RETRY"
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key
> 'session:947K+RGQflZ1Ja4fxH2RVA==': "SERVER HAS FAILED AND IS DISABLED
> UNTIL TIMED RETRY"
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key
> 'jacek+settings': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key
> 'jacek@+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key
> 'jacek+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key '
> ja...@hebe.us+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED
> RETRY"
> Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]:
> <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key
> 'session:947K+RGQflZ1Ja4fxH2RVA==': "SERVER HAS FAILED AND IS DISABLED
> UNTIL TIMED RETRY"
> [root@zafire ~]#
> It seems like sogo_sesion_folder was not created
> Dec 03 18:20:58 zafire postgres[2903]: STATEMENT:  CREATE TABLE
> sogo_sessions_folder ( c_id VARCHAR(255) PRIMARY KEY, c_value VARCHAR(255)
> NOT NULL, c_crea... NOT NULL)
> Dec 03 18:20:58 zafire postgres[2903]: ERROR:  duplicate key value violates
> unique constraint "pg_type_typname_nsp_index"
> Dec 03 18:20:58 zafire postgres[2903]: DETAIL:  Key (typname,
> typnamespace)=(sogo_sessions_folder, 2200) already exists.
> Dec 03 18:20:58 zafire postgres[2903]: STATEMENT:  CREATE TABLE
> sogo_sessions_folder ( c_id VARCHAR(255) PRIMARY KEY, c_value VARCHAR(255)
> NOT NULL, c_crea... NOT NULL)
> Dec 03 18:20:58 zafire postgres[2903]: ERROR:  duplicate key value violates
> unique constraint "pg_type_typname_nsp_index"
> Dec 03 18:20:58 zafire postgres[2903]: DETAIL:  Key (typname,
> typnamespace)=(sogo_sessions_folder, 2200) already exists.
> Dec 03 18:20:58 zafire postgres[2903]: STATEMENT:  CREATE TABLE
> sogo_sessions_folder ( c_id VARCHAR(255) PRIMARY KEY, c_value VARCHAR(255)
> NOT NULL, c_crea... NOT NULL)
> Dec 03 18:20:58 zafire postgres[2903]: ERROR:  duplicate key value violates
> unique constraint "pg_type_typname_nsp_index"
> Dec 03 18:20:58 zafire postgres[2903]: DETAIL:  Key (typname,
> typnamespace)=(sogo_sessions_folder, 2200) already exists.
> Dec 03 18:20:58 zafire postgres[2903]: STATEMENT:  CREATE TABLE
> sogo_sessions_folder ( c_id VARCHAR(255) PRIMARY KEY, c_value VARCHAR(255)
> NOT NULL, c_crea... NOT NULL)
> Hint: Some lines were ellipsized, use -l to show in full.
> [root@zafire ~]#
> How I can fixe the errors so I can login into sogo?
> 

Your seeion table is corrupt.
Do the following.

Stop sogod.
Stop memcached.
Drop sogo_session_folder in postgres.
start memcached.
Start sogod.

This should fix it, as sogod will create an empty session table
automatically.
And you will not lose any user data, only all users with working
sessions have to login again.


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to