[SOGo] BTS activities for Thursday, May 02 2024

2024-05-02 Thread SOGo reporter 
Title: BTS activities for Thursday, May 02 2024





  
BTS Activities

  Home page: https://bugs.sogo.nu
  Project: SOGo
  For the period covering: Thursday, May 02 2024

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5965
	2024-05-02 16:01:49
	updated (open)
	GUI
	Show TOTP Key in addition to the Barcode

Re: [SOGo] SOGo + PostgreSQL authorization

2024-05-02 Thread 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 

[SOGo] [SPAM] Re: [SPAM] SOGoRootPage Login from '192.168.5.10' for user 'postrges' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0

2024-05-02 Thread Roman 
Thank you, I can't put into words how much you helped : ) 02.05.2024, 10:32, "Marco Moock (m...@dorfdsl.de)" :Am 02.05.2024 schrieb "adroman" (adro...@yandex.ru) :  Please help to fix this error - SOGoRootPage Login from '192.168.5.10' for user 'postrges' might not have worked - password   ^^ policy: 65535 grace: -1 expire: -1 bound: 0Look exactly at the spelling of that username.

Re: [SOGo] [SPAM] SOGoRootPage Login from '192.168.5.10' for user 'postrges' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0

2024-05-02 Thread Marco Moock 
Am 02.05.2024 schrieb "adroman" (adro...@yandex.ru) :

> Please help to fix this error - SOGoRootPage Login from
> '192.168.5.10' for user 'postrges' might not have worked - password
   ^^
> policy: 65535  grace: -1 expire: -1  bound: 0

Look exactly at the spelling of that username.

Re: [SOGo] SOGo + PostgreSQL authorization

2024-05-02 Thread 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] [SPAM] SOGoRootPage Login from '192.168.5.10' for user 'postrges' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0

2024-05-02 Thread adroman 
 

 

Hi everyone,

Please help to fix this error - SOGoRootPage Login from '192.168.5.10' for
user 'postrges' might not have worked - password policy: 65535  grace: -1
expire: -1  bound: 0

Any insights or suggestions would be greatly appreciated! Thank you very
much for your precious time and help.

 

 

I’m using PostgreSQL, I have created table sogo_view with command:

 

CREATE TABLE sogo_view (

c_uid VARCHAR(255) PRIMARY KEY,

c_name VARCHAR(255) NOT NULL,

c_password VARCHAR(255) NOT NULL,

c_cn VARCHAR(255),

mail VARCHAR(255)

);

 

and added a user with command: INSERT INTO sogo_view VALUES ('postgres',
'postgres', MD5('mypass'), 'Postgres Example', 'postgres'@mail.con');

than added “host   all   all0.0.0.0/0  md5” to pg_hba.conf

 

This is my config:

 

{

SOGoProfileURL =
"postgresql://postgres:Mypass@192.168.5.229:5432/sogo/sogo_user_profile";

OCSFolderInfoURL =
"postgresql://postgres:Mypass@192.168.5.229:5432/sogo/sogo_folder_info";

OCSSessionsFolderURL =
"postgresql://postgres:Mypass@192.168.5.229:5432/sogo/sogo_sessions_folder";

 OCSAdminURL =
"postgresql://postgres:Mypass@192.168.5.229:5432/sogo/sogo_admin_data";

SOGoLanguage = English;

SOGoPageTitle = "Webmail";

SOGoAppointmentSendEMailNotifications = NO;

SOGoMailingMechanism = smtp;

SOGoSMTPServer = smtp-server.localdomain.local;

SOGoTimeZone = UTC;

SOGoSentFolderName = Sent;

SOGoTrashFolderName = Trash;

SOGoDraftsFolderName = Drafts;

SOGoIMAPServer = "imaps://imap-server.localdomain.local:143/?tls=YES";

SOGoIMAPAclConformsToIMAPExt = NO;

SOGoVacationEnabled = NO;

SOGoForwardEnabled = NO;

SOGoSieveScriptsEnabled = NO;

SOGoFirstDayOfWeek = 0;

SOGoMailMessageCheck = manually;

SOGoMailAuxiliaryUserAccountsEnabled = NO;

SOGoMemcachedHost = 192.168.5.229;

WOWorkersCount = 8;

 SOGoSuperUsernames = ( postgres);

 

/*  authentication example */

SOGoUserSources = (

 {

   type = sql;

   id = directory;

   viewURL =
"postgresql://postgres:Mypass@192.168.5.229:5432/sogo/sogo_view";

   canAuthenticate = YES;

   isAddressBook = YES;

   displayName = "Shared Addresses";

   userPasswordAlgorithm = md5;

 }  

);

 

 // Paramètres de journalisation

SOGoDebugRequests = YES;

SOGoDebugBaseURL = YES;

SOGoVacationEnabled = YES;

SOGoRefreshViewCheck = every_1_minutes;

SOGoRefreshViewOnForeground = YES;

SOGoMailReplyPlacement = below;

SOGoMailSignaturePlacement = below;

SOGoMailMessageForwarding = inline;

SOGoLoggingLevel = debug;

 

 

}

 

 

This is my log:

 

May 02 02:07:37 sogod [160]: 192.168.5.10 "POST
/SOGo/so/passwordRecoveryEnabled HTTP/1.1" 403 0/37 0.001 - - 0 - 11

May 02 02:07:37 sogod [160]: |SOGo| starting method 'POST' on uri
'/SOGo/connect'

May 02 02:07:37 sogod [160]: SOGoRootPage Login from '192.168.5.10' for user
'postrges' might not have worked - password policy: 65535  grace: -1
expire: -1  bound: 0

May 02 02:07:37 sogod [160]: |SOGo| request took 0.010718 seconds to execute

May 02 02:07:37 sogod [160]: 192.168.5.10 "POST /SOGo/connect HTTP/1.1" 403
33/78 0.011 - - 0 - 12

May 02 02:07:39 sogod [160]: |SOGo| starting method 'POST' on uri
'/SOGo/so/passwordRecoveryEnabled'

May 02 02:07:39 sogod [160]: |SOGo| request took 0.000294 seconds to execute

May 02 02:07:39 sogod [160]: 192.168.5.10 "POST
/SOGo/so/passwordRecoveryEnabled HTTP/1.1" 403 0/37 0.001 - - 0 – 12

 

 

Apache logs:

docker exec --user="root" -it sogo /bin/bash -c  "tail -f
/var/log/apache2/access.log"

192.168.5.10 - - [02/May/2024:04:07:33 +0200] "GET
/SOGo.woa/WebServerResources/img/sogo-full.svg?lm=1714178979 HTTP/1.1"
200 4846 "http://192.168.5.229/SOGo/; "Mozilla/5.0 (Windows NT 10.0; Win64;
x64; rv:125.0) Gecko/20100101 Firefox/125.0"

192.168.5.10 - - [02/May/2024:04:07:33 +0200] "GET
/SOGo.woa/WebServerResources/js/vendor/angular-material.min.js?lm=17141
78979 HTTP/1.1" 200 111030 "http://192.168.5.229/SOGo/; "Mozilla/5.0
(Windows NT 10.0; Win64; x64; rv:125.0) Gecko/2010010 1
Firefox/125.0"

192.168.5.10 - - [02/May/2024:04:07:33 +0200] "GET
/SOGo.woa/WebServerResources/js/vendor/angular-ui-router.min.js?lm=1714
178979 HTTP/1.1" 200 35736 "http://192.168.5.229/SOGo/; "Mozilla/5.0
(Windows NT 10.0; Win64; x64; rv:125.0) Gecko/2010010 1
Firefox/125.0"

192.168.5.10 - - [02/May/2024:04:07:33 +0200] "GET
/SOGo.woa/WebServerResources/js/Main.js?lm=1714178979 HTTP/1.1" 200 249
8 "http://192.168.5.229/SOGo/; "Mozilla/5.0 (Windows NT 10.0; Win64; x64;
rv:125.0) Gecko/20100101 Firefox/125.0"

192.168.5.10 - - [02/May/2024:04:07:33 +0200] "GET
/SOGo.woa/WebServerResources/js/Common.js?lm=1714178979 HTTP/1.1" 200 2
6458 "http://192.168.5.229/SOGo/; "Mozilla/5.0 (Windows NT 10.0; Win64; x64;

[SOGo] SOGo + PostgreSQL authorization

2024-05-02 Thread 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