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 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;