Re: [SOGo] SOGo + PostgreSQL authorization

[Roman]

Thank you, I installed memcached on outside of the docker and thу problem with cache gone. 02.05.2024, 09:49, "smizr...@alinto.eu (smizr...@alinto.eu)" :Hello,Did you enabled and well configured memcached ?The error is not critical and it says that the `admin-motd` value can not be set in cache - it means that the request for retrieving message of the day will always be processed.Sebastien​​Le Jeudi, Mai 02, 2024 04:08 CEST, "adroman" (adro...@yandex.ru)  a écrit:I am trying to authorize in SOGo after installation using Postgres , but this error in the logs?I don't understand what I need to do, can anyone tell m  pr 27 09:33:39 sogod [153]: <0x0x55ea52720590[SOGoCache]> an error occurred when caching value for key 'admin-motd': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"2024-04-27 09:33:39.524 sogod[153:153] PostgreSQL72 connection established: <0x0x55ea528b5e20[PGConnection]:  connection=0x0x55ea5295cab0>2024-04-27 09:33:39.524 sogod[153:153] PostgreSQL72 channel 0x0x55ea527d5580 opened (connection=<0x0x55ea528b5e20[PGConnection]:  connection=0x0x55ea5295cab0>, count=1)2024-04-27 09:33:39.524 sogod[153:153] PG0x0x55ea527d5580 SQL: BEGIN TRANSACTION2024-04-27 09:33:39.525 sogod[153:153] PG0x0x55ea527d5580 SQL: SELECT t1.c_content, t1.c_key FROM  sogo_admin t1 WHERE t1.c_key='motd'2024-04-27 09:33:39.526 sogod[153:153] PG0x0x55ea527d5580 SQL: ROLLBACK TRANSACTION2024-04-27 09:33:39.526 sogod[153:153] PostgreSQL72 connection dropped 0x0x55ea528b5e20 (channel=0x0x55ea527d5580, count=0)Apr 27 09:33:39 sogod [153]: <0x0x55ea52720590[SOGoCache]> an error occurred when caching value for key 'admin-motd': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"2024-04-27 09:33:39.537 sogod[153:153] PostgreSQL72 connection established: <0x0x55ea526bdda0[PGConnection]:  connection=0x0x55ea5295cab0>2024-04-27 09:33:39.537 sogod[153:153] PostgreSQL72 channel 0x0x55ea52916c60 opened (connection=<0x0x55ea526bdda0[PGConnection]:  connection=0x0x55ea5295cab0>, count=1)2024-04-27 09:33:39.537 sogod[153:153] PG0x0x55ea52916c60 SQL: BEGIN TRANSACTION2024-04-27 09:33:39.538 sogod[153:153] PG0x0x55ea52916c60 SQL: SELECT t1.c_content, t1.c_key FROM  sogo_admin t1 WHERE t1.c_key='motd'2024-04-27 09:33:39.539 sogod[153:153] PG0x0x55ea52916c60 SQL: ROLLBACK TRANSACTION2024-04-27 09:33:39.539 sogod[153:153] PostgreSQL72 connection dropped 0x0x55ea526bdda0 (channel=0x0x55ea52916c60, count=0)Apr 27 09:33:39 sogod [153]: <0x0x55ea52720590[SOGoCache]> an error occurred when caching value for key 'admin-motd': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"Apr 27 09:33:39 sogod [153]: |SOGo|   constructed root-url: /SOGo/Apr 27 09:33:39 sogod [153]: |SOGo|   setting root-url in context: /SOGo/Apr 27 09:33:39 sogod [153]: |SOGo| ROOT baseURL(no container, name=(null)):  own: /SOGo/Apr 27 09:33:39 sogod [153]: |SOGo| request took 0.052509 seconds to executeApr 27 09:33:39 sogod [153]: 192.168.5.10 "GET /SOGo/ HTTP/1.1" 200 37030/0 0.053 - - 312K - 10 

Re: [SOGo] SOGo + PostgreSQL authorization

[smizr...@alinto.eu]

Hello,

Did you enabled and well configured memcached ?

The error is not critical and it says that the `admin-motd` value can not be 
set in cache - it means that the request for retrieving message of the day will 
always be processed.

Sebastien
​​

Le Jeudi, Mai 02, 2024 04:08 CEST, "adroman" (adro...@yandex.ru) 
 a écrit:
  

 

 
I am trying to authorize in SOGo after installation using Postgres , but this 
error in the logs?

I don't understand what I need to do, can anyone tell m


 

 

 

 

 

 
pr 27 09:33:39 sogod [153]: <0x0x55ea52720590[SOGoCache]> an error occurred 
when caching value for key 'admin-motd': "SERVER HAS FAILED AND IS DISABLED 
UNTIL TIMED RETRY"

2024-04-27 09:33:39.524 sogod[153:153] PostgreSQL72 connection established: 
<0x0x55ea528b5e20[PGConnection]:  connection=0x0x55ea5295cab0>

2024-04-27 09:33:39.524 sogod[153:153] PostgreSQL72 channel 0x0x55ea527d5580 
opened (connection=<0x0x55ea528b5e20[PGConnection]:  
connection=0x0x55ea5295cab0>, count=1)

2024-04-27 09:33:39.524 sogod[153:153] PG0x0x55ea527d5580 SQL: BEGIN TRANSACTION

2024-04-27 09:33:39.525 sogod[153:153] PG0x0x55ea527d5580 SQL: SELECT 
t1.c_content, t1.c_key FROM  sogo_admin t1 WHERE t1.c_key='motd'

2024-04-27 09:33:39.526 sogod[153:153] PG0x0x55ea527d5580 SQL: ROLLBACK 
TRANSACTION

2024-04-27 09:33:39.526 sogod[153:153] PostgreSQL72 connection dropped 
0x0x55ea528b5e20 (channel=0x0x55ea527d5580, count=0)

Apr 27 09:33:39 sogod [153]: <0x0x55ea52720590[SOGoCache]> an error occurred 
when caching value for key 'admin-motd': "SERVER HAS FAILED AND IS DISABLED 
UNTIL TIMED RETRY"

2024-04-27 09:33:39.537 sogod[153:153] PostgreSQL72 connection established: 
<0x0x55ea526bdda0[PGConnection]:  connection=0x0x55ea5295cab0>

2024-04-27 09:33:39.537 sogod[153:153] PostgreSQL72 channel 0x0x55ea52916c60 
opened (connection=<0x0x55ea526bdda0[PGConnection]:  
connection=0x0x55ea5295cab0>, count=1)

2024-04-27 09:33:39.537 sogod[153:153] PG0x0x55ea52916c60 SQL: BEGIN TRANSACTION

2024-04-27 09:33:39.538 sogod[153:153] PG0x0x55ea52916c60 SQL: SELECT 
t1.c_content, t1.c_key FROM  sogo_admin t1 WHERE t1.c_key='motd'

2024-04-27 09:33:39.539 sogod[153:153] PG0x0x55ea52916c60 SQL: ROLLBACK 
TRANSACTION

2024-04-27 09:33:39.539 sogod[153:153] PostgreSQL72 connection dropped 
0x0x55ea526bdda0 (channel=0x0x55ea52916c60, count=0)

Apr 27 09:33:39 sogod [153]: <0x0x55ea52720590[SOGoCache]> an error occurred 
when caching value for key 'admin-motd': "SERVER HAS FAILED AND IS DISABLED 
UNTIL TIMED RETRY"

Apr 27 09:33:39 sogod [153]: |SOGo|   constructed root-url: /SOGo/

Apr 27 09:33:39 sogod [153]: |SOGo|   setting root-url in context: /SOGo/

Apr 27 09:33:39 sogod [153]: |SOGo| ROOT baseURL(no container, name=(null)):

  own: /SOGo/

Apr 27 09:33:39 sogod [153]: |SOGo| request took 0.052509 seconds to execute

Apr 27 09:33:39 sogod [153]: 192.168.5.10 "GET /SOGo/ HTTP/1.1" 200 37030/0 
0.053 - - 312K - 10


 

[SOGo] SOGo + PostgreSQL authorization

[adroman]

 

 

I am trying to authorize in SOGo after installation using Postgres , but
this error in the logs?

I don't understand what I need to do, can anyone tell m

 

 

 

 

 

 

pr 27 09:33:39 sogod [153]: <0x0x55ea52720590[SOGoCache]> an error occurred
when caching value for key 'admin-motd': "SERVER HAS FAILED AND IS DISABLED
UNTIL TIMED RETRY"

2024-04-27 09:33:39.524 sogod[153:153] PostgreSQL72 connection established:
<0x0x55ea528b5e20[PGConnection]:  connection=0x0x55ea5295cab0>

2024-04-27 09:33:39.524 sogod[153:153] PostgreSQL72 channel 0x0x55ea527d5580
opened (connection=<0x0x55ea528b5e20[PGConnection]:
connection=0x0x55ea5295cab0>, count=1)

2024-04-27 09:33:39.524 sogod[153:153] PG0x0x55ea527d5580 SQL: BEGIN
TRANSACTION

2024-04-27 09:33:39.525 sogod[153:153] PG0x0x55ea527d5580 SQL: SELECT
t1.c_content, t1.c_key FROM  sogo_admin t1 WHERE t1.c_key='motd'

2024-04-27 09:33:39.526 sogod[153:153] PG0x0x55ea527d5580 SQL: ROLLBACK
TRANSACTION

2024-04-27 09:33:39.526 sogod[153:153] PostgreSQL72 connection dropped
0x0x55ea528b5e20 (channel=0x0x55ea527d5580, count=0)

Apr 27 09:33:39 sogod [153]: <0x0x55ea52720590[SOGoCache]> an error occurred
when caching value for key 'admin-motd': "SERVER HAS FAILED AND IS DISABLED
UNTIL TIMED RETRY"

2024-04-27 09:33:39.537 sogod[153:153] PostgreSQL72 connection established:
<0x0x55ea526bdda0[PGConnection]:  connection=0x0x55ea5295cab0>

2024-04-27 09:33:39.537 sogod[153:153] PostgreSQL72 channel 0x0x55ea52916c60
opened (connection=<0x0x55ea526bdda0[PGConnection]:
connection=0x0x55ea5295cab0>, count=1)

2024-04-27 09:33:39.537 sogod[153:153] PG0x0x55ea52916c60 SQL: BEGIN
TRANSACTION

2024-04-27 09:33:39.538 sogod[153:153] PG0x0x55ea52916c60 SQL: SELECT
t1.c_content, t1.c_key FROM  sogo_admin t1 WHERE t1.c_key='motd'

2024-04-27 09:33:39.539 sogod[153:153] PG0x0x55ea52916c60 SQL: ROLLBACK
TRANSACTION

2024-04-27 09:33:39.539 sogod[153:153] PostgreSQL72 connection dropped
0x0x55ea526bdda0 (channel=0x0x55ea52916c60, count=0)

Apr 27 09:33:39 sogod [153]: <0x0x55ea52720590[SOGoCache]> an error occurred
when caching value for key 'admin-motd': "SERVER HAS FAILED AND IS DISABLED
UNTIL TIMED RETRY"

Apr 27 09:33:39 sogod [153]: |SOGo|   constructed root-url: /SOGo/

Apr 27 09:33:39 sogod [153]: |SOGo|   setting root-url in context: /SOGo/

Apr 27 09:33:39 sogod [153]: |SOGo| ROOT baseURL(no container, name=(null)):

  own: /SOGo/

Apr 27 09:33:39 sogod [153]: |SOGo| request took 0.052509 seconds to execute

Apr 27 09:33:39 sogod [153]: 192.168.5.10 "GET /SOGo/ HTTP/1.1" 200 37030/0
0.053 - - 312K - 10