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.
Im 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 all 0.0.0.0/0 md5 to pg_hba.conf
This is my config:
{
SOGoProfileURL =
"postgresql://postgres:[email protected]:5432/sogo/sogo_user_profile";
OCSFolderInfoURL =
"postgresql://postgres:[email protected]:5432/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"postgresql://postgres:[email protected]:5432/sogo/sogo_sessions_folder";
OCSAdminURL =
"postgresql://postgres:[email protected]: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:[email protected]: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;
rv:125.0) Gecko/20100101 Firefox/125.0"
192.168.5.10 - - [02/May/2024:04:07:33 +0200] "GET
/SOGo.woa/WebServerResources/fonts/FiraSans-Book.woff HTTP/1.1" 200 186
223
"http://192.168.5.229/SOGo.woa/WebServerResources/css/styles.css?lm=17141789
79" "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/img/sogo.ico?lm=1714178979 HTTP/1.1" 200 5
218 "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:37 +0200] "POST
/SOGo/so/passwordRecoveryEnabled HTTP/1.1" 403 319 "http://192.168.5.2
29/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:37 +0200] "POST /SOGo/connect HTTP/1.1"
403 420 "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:39 +0200] "POST
/SOGo/so/passwordRecoveryEnabled HTTP/1.1" 403 319 "http://192.168.5.2
29/SOGo/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:125.0)
Gecko/20100101 Firefox/125.0"
root@vm-nas:~docker exec --user="root" -it sogo /bin/bash -c "tail -f
/var/log/apache2/error.log"g"
[Thu May 02 03:40:58.296332 2024] [core:notice] [pid 24:tid 139746324837888]
AH00094: Command line: '/usr/sbin/apache2 -D NO_DETACH'
[Thu May 02 03:41:39.884741 2024] [core:warn] [pid 24:tid 140641298138624]
AH00098: pid file /var/run/apache2/apache2.pid overwritten
-- Unclean shutdown of previous Apache run?
[Thu May 02 03:41:39.885525 2024] [mpm_event:notice] [pid 24:tid
140641298138624] AH00489: Apache/2.4.58 (Ubuntu) OpenSSL/
3.0.13 configured -- resuming normal operations
[Thu May 02 03:41:39.885544 2024] [core:notice] [pid 24:tid 140641298138624]
AH00094: Command line: '/usr/sbin/apache2 -D NO_DETACH'
[Thu May 02 03:47:15.180056 2024] [core:warn] [pid 25:tid 140167282669056]
AH00098: pid file /var/run/apache2/apache2.pid overwritten
-- Unclean shutdown of previous Apache run?
[Thu May 02 03:47:15.180831 2024] [mpm_event:notice] [pid 25:tid
140167282669056] AH00489: Apache/2.4.58 (Ubuntu) OpenSSL/
3.0.13 configured -- resuming normal operations
[Thu May 02 03:47:15.180851 2024] [core:notice] [pid 25:tid 140167282669056]
AH00094: Command line: '/usr/sbin/apache2 -D NO_DETACH'
[Thu May 02 04:12:22.958902 2024] [core:warn] [pid 24:tid 139852572730880]
AH00098: pid file /var/run/apache2/apache2.pid overwritten
-- Unclean shutdown of previous Apache run?
[Thu May 02 04:12:22.959695 2024] [mpm_event:notice] [pid 24:tid
139852572730880] AH00489: Apache/2.4.58 (Ubuntu) OpenSSL/
3.0.13 configured -- resuming normal operations
[Thu May 02 04:12:22.959715 2024] [core:notice] [pid 24:tid 139852572730880]
AH00094: Command line: '/usr/sbin/apache2 -D NO_DETACH'
