| Description | setup: FreeBSD 13.1, sogo 5.8.0, pgsql 13.10
issue: Users are unable to login after welcome message, again login screen, sogod reporting:
Mar 31 04:15:28 sogod [79266]: |SOGo| starting method 'POST' on uri '/SOGo/so/passwordRecoveryEnabled'
Mar 31 04:15:28 sogod [79266]: |SOGo| traverse(acquire): passwordRecoveryEnabled
Mar 31 04:15:28 sogod [79266]: |SOGo| do traverse name: 'passwordRecoveryEnabled'
Mar 31 04:15:28 sogod [79266]: |SOGo| request took 0.001672 seconds to execute
Mar 31 04:15:28 sogod [79266]: 192.168.61.250 "POST /SOGo/so/passwordRecoveryEnabled HTTP/1.0" 403 0/33 0.007 - - -
Mar 31 04:15:30 sogod [79266]: |SOGo| starting method 'POST' on uri '/SOGo/so/passwordRecoveryEnabled'
Mar 31 04:15:30 sogod [79266]: |SOGo| traverse(acquire): passwordRecoveryEnabled
Mar 31 04:15:30 sogod [79266]: |SOGo| do traverse name: 'passwordRecoveryEnabled'
Mar 31 04:15:30 sogod [79266]: |SOGo| request took 0.001111 seconds to execute
Mar 31 04:15:30 sogod [79266]: 192.168.61.250 "POST /SOGo/so/passwordRecoveryEnabled HTTP/1.0" 403 0/33 0.003 - - -
Mar 31 04:15:33 sogod [79266]: |SOGo| starting method 'POST' on uri '/SOGo/connect'
Mar 31 04:15:33 sogod [79266]: |SOGo| traverse(acquire): SOGo => connect
Mar 31 04:15:33 sogod [79266]: |SOGo| do traverse name: 'SOGo'
Mar 31 04:15:33 sogod [79266]: |SOGo| do traverse name: 'connect'
Mar 31 04:15:33 sogod [79266]: |SOGo| set clientObject: <SOGo[0x0x80447d5c8]: name=SOGo>
2023-03-31 04:15:33.429 sogod[79266:101188] PostgreSQL72 connection established: <0x0x80455c828[PGConnection]: connection=0x0x804ff4000>
2023-03-31 04:15:33.429 sogod[79266:101188] PostgreSQL72 channel 0x0x804ed4668 opened (connection=<0x0x80455c828[PGConnection]: connection=0x0x804ff4000>, count=2)
2023-03-31 04:15:33.429 sogod[79266:101188] PG0x0x804ed4668 SQL: SELECT c_password FROM sogo_view WHERE c_uid = 'user'
Mar 31 04:15:33 sogod [79266]: SOGoRootPage successful login from '192.168.61.250' for user 'user' - expire = -1 grace = -1
2023-03-31 04:15:33.432 sogod[79266:101188] PG0x0x804ed4668 SQL: SELECT * FROM sogo_view WHERE (c_uid = 'user') OR (mail = 'user')
2023-03-31 04:15:33.434 sogod[79266:101188] PG0x0x804ed22c8 SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'user'
2023-03-31 04:15:33.435 sogod[79266:101188] PG0x0x804ed22c8 SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'user'
2023-03-31 04:15:33.440 sogod[79266:101188] PostgreSQL72 connection established: <0x0x804fef2c8[PGConnection]: connection=0x0x804ff4c00>
2023-03-31 04:15:33.440 sogod[79266:101188] PostgreSQL72 channel 0x0x805006368 opened (connection=<0x0x804fef2c8[PGConnection]: connection=0x0x804ff4c00>, count=3)
2023-03-31 04:15:33.441 sogod[79266:101188] PG0x0x805006368 SQL: BEGIN TRANSACTION
2023-03-31 04:15:33.442 sogod[79266:101188] PG0x0x805006368 SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='j6NsNBxJaiKNFj5Q'
2023-03-31 04:15:33.443 sogod[79266:101188] PG0x0x805006368 SQL: ROLLBACK TRANSACTION
2023-03-31 04:15:33.443 sogod[79266:101188] PG0x0x804ed22c8 SQL: BEGIN TRANSACTION
2023-03-31 04:15:33.444 sogod[79266:101188] PG0x0x804ed22c8 SQL: INSERT INTO sogo_sessions_folder (c_lastseen, c_creationdate, c_value, c_id) VALUES (1680250533, 1680250533,
----deleted---
2023-03-31 04:15:33.445 sogod[79266:101188] PG0x0x804ed22c8 SQL: COMMIT TRANSACTION
Mar 31 04:15:33 sogod [79266]: |SOGo| request took 0.035540 seconds to execute
Mar 31 04:15:33 sogod [79266]: 192.168.61.250 "POST /SOGo/connect HTTP/1.0" 200 36/73 0.037 - - -
Mar 31 04:15:34 sogod [79266]: |SOGo| starting method 'GET' on uri '/SOGo/user'
Mar 31 04:15:34 sogod [79266]: |SOGo| traverse(acquire): SOGo => user
Mar 31 04:15:34 sogod [79266]: |SOGo| do traverse name: 'SOGo'
Mar 31 04:15:34 sogod [79266]: |SOGo| do traverse name: 'user'
Mar 31 04:15:34 sogod [79266]: |SOGo| traverse miss: name=user, acquire: i=1,count=2
Mar 31 04:15:34 sogod [79266]: |SOGo| miss is last object.
Mar 31 04:15:34 sogod [79266]: |SOGo| handle miss error: <SoAuthRequiredException: 0x805d7dc08> NAME:SoAuthRequired REASON:authentication required
Mar 31 04:15:34 sogod [79266]: |SOGo| request took 0.021508 seconds to execute
Mar 31 04:15:34 sogod [79266]: 192.168.61.250 "GET /SOGo/user HTTP/1.0" 200 11981/0 0.023 42404 71% - |
|---|
| Additional Information | sogo.conf
/ Web Interface /
SOGoPageTitle = SOGo-mail;
SOGoVacationEnabled = NO;
SOGoForwardEnabled = NO;
SOGoSieveScriptsEnabled = NO;
SOGoMailAuxiliaryUserAccountsEnabled = NO;
SOGoTrustProxyAuthentication = NO;
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
SOGoXSRFValidationEnabled = NO;
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
/ General - SOGoTimeZone MUST be defined /
SOGoLanguage = English;
SOGoTimeZone = America/Montreal;
SOGoCalendarDefaultRoles = (
PublicDAndTViewer,
ConfidentialDAndTViewer
);
SOGoSuperUsernames = (user, sogo1, sogo2); // This is an array - keep the parens!
SxVMemLimit = 384;
WOPidFile = "/var/run/sogo/sogo.pid";;
SOGoMemcachedHost = 127.0.0.1;
/ Debug /
GCSFolderDebugEnabled = YES;
GCSFolderStoreDebugEnabled = YES;
SoDebugObjectTraversal = YES;
SOGoDebugRequests = YES;
SoDebugBaseURL = YES;
ImapDebugEnabled = YES;
//LDAPDebugEnabled = YES;
PGDebugEnabled = YES;
//MySQL4DebugEnabled = YES;
SOGoUIxDebugEnabled = YES;
//WODontZipResponse = YES;
WOLogFile = /var/log/sogo/sogo.log;
httpd.conf:
DocumentRoot "/usr/local/GNUstep"
LimitRequestFieldSize 12392
Alias /SOGo.woa/WebServerResources/ \
/usr/local/GNUstep/Local/Library/SOGo/WebServerResources/
Alias /SOGo/WebServerResources/ \
/usr/local/GNUstep/Local/Library/SOGo/WebServerResources/
<Directory /usr/local/GNUstep/Local/Library/SOGo/>
AllowOverride None
Require all granted
Explicitly allow caching of static content to avoid browser specific behavior.
# A resource's URL MUST change in order to have the client load the new version.
<IfModule expires_module>
ExpiresActive On
ExpiresDefault "access plus 1 year"
</IfModule>
</Directory>
Don't send the Referer header for cross-origin requests
Header always set Referrer-Policy "same-origin"
<Location /SOGo>
Don't cache dynamic content
Header set Cache-Control "max-age=0, no-cache, no-store"
</Location>
ProxyRequests Off
ProxyPreserveHost On
SetEnv proxy-nokeepalive 1
ProxyPass /SOGo http://127.0.0.1:20000/SOGo retry=0 nocanon
<Proxy http://127.0.0.1:20000/SOGo>
Adjust the following to your configuration
and make sure to enable the headers module
<IfModule headers_module>
RequestHeader set "x-webobjects-server-port" "80"
SetEnvIf Host (.*) HTTP_HOST=$1
RequestHeader set "x-webobjects-server-name" "%{HTTP_HOST}e" env=HTTP_HOST
RequestHeader set "x-webobjects-server-url" "https://%{HTTP_HOST}e" env=HTTP_HOST
When using proxy-side autentication, you need to uncomment and
adjust the following line:
RequestHeader unset "x-webobjects-remote-user"
RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e" env=REMOTE_USER
RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
</IfModule>
AddDefaultCharset UTF-8
Order allow,deny
Allow from all
Require all granted
</Proxy> |
|---|
