View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005722SOGoWeb Mailpublic2023-03-31 08:412025-02-27 13:12
Reporterisa.teatr Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status newResolutionopen 
Product Version5.8.0 
Summary0005722: Nothing happens after welcome message (can't log in/connect)
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% -

Steps To Reproduce

cd /usr/ports/www/sogo
make install clean

configure sogo.conf
configure httpd.conf (apache24)
service sogod start

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 = &quot;/var/run/sogo/sogo.pid&quot;;;
  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 &quot;/usr/local/GNUstep&quot;
LimitRequestFieldSize  12392
Alias /SOGo.woa/WebServerResources/ \
      /usr/local/GNUstep/Local/Library/SOGo/WebServerResources/
Alias /SOGo/WebServerResources/ \
      /usr/local/GNUstep/Local/Library/SOGo/WebServerResources/

&lt;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.
    &lt;IfModule expires_module>
      ExpiresActive On
      ExpiresDefault &quot;access plus 1 year&quot;
    &lt;/IfModule>
&lt;/Directory>

# Don't send the Referer header for cross-origin requests
Header always set Referrer-Policy &quot;same-origin&quot;

&lt;Location /SOGo>
  # Don't cache dynamic content
  Header set Cache-Control &quot;max-age=0, no-cache, no-store&quot;
&lt;/Location>

ProxyRequests Off
ProxyPreserveHost On
SetEnv proxy-nokeepalive 1

ProxyPass /SOGo http://127.0.0.1:20000/SOGo retry=0 nocanon

&lt;Proxy http://127.0.0.1:20000/SOGo>
## Adjust the following to your configuration
## and make sure to enable the headers module
  &lt;IfModule headers_module>
    RequestHeader set &quot;x-webobjects-server-port&quot; &quot;80&quot;
    SetEnvIf Host (.*) HTTP_HOST=$1
    RequestHeader set &quot;x-webobjects-server-name&quot; &quot;%{HTTP_HOST}e&quot; env=HTTP_HOST
    RequestHeader set &quot;x-webobjects-server-url&quot; &quot;https://%{HTTP_HOST}e&quot; env=HTTP_HOST

## When using proxy-side autentication, you need to uncomment and
## adjust the following line:
   # RequestHeader unset &quot;x-webobjects-remote-user&quot;
   # RequestHeader set &quot;x-webobjects-remote-user&quot; &quot;%{REMOTE_USER}e&quot; env=REMOTE_USER

    RequestHeader set &quot;x-webobjects-server-protocol&quot; &quot;HTTP/1.0&quot;
  &lt;/IfModule>

  AddDefaultCharset UTF-8

  Order allow,deny
  Allow from all
  Require all granted
&lt;/Proxy>
TagsNo tags attached.

Activities

Christian Mack

Christian Mack

2025-02-27 13:08

developer   ~0018100

Made the config settings readable.
Christian Mack

Christian Mack

2025-02-27 13:12

developer   ~0018101

There is no SOGoUserSources part in your sogo.conf, therefore SOGo does not know how to authenticate an user.
See for LDAP authentication:
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_authentication_using_ldap

See for databse authentication:
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL

Issue History

Date Modified Username Field Change
2023-03-31 08:41 isa.teatr New Issue
2025-02-27 13:08 Christian Mack Additional Information Updated
2025-02-27 13:08 Christian Mack Note Added: 0018100
2025-02-27 13:12 Christian Mack Note Added: 0018101