Hi List, since one of the last upgrade from stable sources, login through the web-frontend is not possible any more. All other functionality (such as IMAP, CalDAV and CardDAV) works properly.
Running on Debian 8.3 (Jessie) with apache 2.4.10-10+deb8u4. DB is MySQL and is being managed by a web hosting software using a MySQL view. Log shows: Feb 06 16:49:12 sogod [24985]: |SOGo| starting method 'POST' on uri '/SOGo/connect' 2016-02-06 16:49:12.119 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> SQL: SELECT c_password FROM sogo_users WHERE c_uid = 'my_user@my_domain.com'; 2016-02-06 16:49:12.119 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> query has results, entering fetch-mode. Feb 06 16:49:12 sogod [24985]: SOGoRootPage successful login from ‚my_client_ip' for user ‚my_user@my_domain.com' - expire = -1 grace = -1 2016-02-06 16:49:12.120 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> SQL: BEGIN; 2016-02-06 16:49:12.121 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> query has no results. 2016-02-06 16:49:12.121 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='kY52T2m+dsiUZjgQqMTEGg=='; 2016-02-06 16:49:12.121 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> query has results, entering fetch-mode. 2016-02-06 16:49:12.122 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> SQL: ROLLBACK; 2016-02-06 16:49:12.122 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> query has no results. 2016-02-06 16:49:12.122 sogod[24985] <MySQL4Channel[0x0x7fc906520250] connection=0x0x7fc9065fed10> SQL: BEGIN; 2016-02-06 16:49:12.122 sogod[24985] <MySQL4Channel[0x0x7fc906520250] connection=0x0x7fc9065fed10> query has no results. 2016-02-06 16:49:12.122 sogod[24985] <MySQL4Channel[0x0x7fc906520250] connection=0x0x7fc9065fed10> SQL: INSERT INTO sogo_sessions_folder (c_lastseen, c_creationdate, c_value, c_id) VALUES (1454773752, 1454773752, 'G9q4/99BuvBnXWeGwuN3ZqiMJGg1uUXNGEEWIXtIgBhMyRxueZrz8IvEBX8Ey5CmWG+GvSdFb7ykHU/a+NeOXUTJHbXLG29jxJalVqjP4YGxHp1qYe+FSTRW8ot70rPlw6grkRcCBByb6qiF8Ct3Jm6dTNKeKLPFk8VG/seJ97U77kD8UtOVFafbGzTvp0BF2Q+JgIBOcQj9s8YxXPOAcg==', 'kY52T2m+dsiUZjgQqMTEGg=='); 2016-02-06 16:49:12.122 sogod[24985] <MySQL4Channel[0x0x7fc906520250] connection=0x0x7fc9065fed10> query has no results. 2016-02-06 16:49:12.122 sogod[24985] <MySQL4Channel[0x0x7fc906520250] connection=0x0x7fc9065fed10> SQL: COMMIT; 2016-02-06 16:49:12.122 sogod[24985] <MySQL4Channel[0x0x7fc906520250] connection=0x0x7fc9065fed10> query has no results. Feb 06 16:49:12 sogod [24985]: |SOGo| request took 0.004051 seconds to execute Feb 06 16:49:12 sogod [24985]: my_client_ip "POST /SOGo/connect HTTP/1.1" 200 27/59 0.005 - - 0 Feb 06 16:49:12 sogod [24985]: |SOGo| starting method 'GET' on uri '/SOGo/my_user@my_domain.com' 2016-02-06 16:49:12.177 sogod[24985] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2016-02-06 16:49:12.177 sogod[24985] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2016-02-06 16:49:12.177 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> SQL: SELECT c_password FROM sogo_users WHERE c_uid = ‚my_user@my_domain.com@'; 2016-02-06 16:49:12.177 sogod[24985] <MySQL4Channel[0x0x7fc9065bfa70] connection=0x0x7fc906423d00> query has results, entering fetch-mode. Feb 06 16:49:12 sogod [24985]: <0x0x7fc906151390[SOGoWebAuthenticator]> tried wrong password for user 'b7Xalr4y+pwOMxL+74QCFN2iRwdY+X+nfXFhURR79BhMyRxueZrz8IvEBX8Ey5CmWG+GvSdFb7ykHU/a+NeOXUTJHbXLG29jxJalVqjP4YGxHp1qYe+FSTRW8ot70rPlw6grkRcCBByb6qiF8Ct3Jm6dTNKeKLPFk8VG/seJ97U77kD8UtOVFafbGzTvp0BF2Q+JgIBOcQj9s8YxXPOAcg=='! Feb 06 16:49:12 sogod [24985]: |SOGo| constructed root-url: /SOGo/ Feb 06 16:49:12 sogod [24985]: |SOGo| setting root-url in context: /SOGo/ Feb 06 16:49:12 sogod [24985]: |SOGo| ROOT baseURL(no container, name=(null)): own: /SOGo/ Feb 06 16:49:12 sogod [24985]: |SOGo| request took 0.006288 seconds to execute Feb 06 16:49:12 sogod [24985]: my_client_ip "GET /SOGo/my_user@my_domain.com HTTP/1.1" 200 13702/0 0.009 - - 0 /etc/sogo/sogo.conf shows: { NGImap4ConnectionStringSeparator = "/"; OCSFolderInfoURL = "mysql://my_db_user:my_db_pw@127.0.0.1:3306/sogo/sogo_folder_info"; OCSSessionsFolderURL = "mysql://my_db_user:my_db_pw@127.0.0.1:3306/sogo/sogo_sessions_folder"; SOGoAppointmentSendEMailNotifications = YES; SOGoDraftsFolderName = Drafts; SOGoEnableDomainBasedUID = YES; SOGoFirstDayOfWeek = 1; SOGoForceIMAPLoginWithEmail = YES; SOGoForwardEnabled = NO; SOGoIMAPServer = localhost; SOGoLanguage = German; SOGoLoginModule = Mail; SOGoMailAuxiliaryUserAccountsEnabled = YES; SOGoMailCustomFromEnabled = YES; SOGoMailDomain = „my_domain.com"; SOGoMailMessageCheck = "every_5_minutes"; SOGoMailingMechanism = smtp; "SOGoMailingMechanism$" = smtp; SOGoMemcachedHost = "127.0.0.1"; SOGoProfileURL = "mysql://my_db_user:my_db_pw@127.0.0.1:3306/sogo/sogo_user_profile"; SOGoSMTPServer = localhost; SOGoSentFolderName = "Sent Messages"; SOGoSieveScriptsEnabled = NO; SOGoSieveServer = "sieve://localhost:4190"; SOGoSuperUsernames = ( „my_user@my_domain.com" ); SOGoTimeZone = "Europe/Zurich"; SOGoTrashFolderName = Trash; SOGoUserSources = ( { canAuthenticate = YES; displayName = "SOGo Users"; id = users; isAddressBook = NO; type = sql; userPasswordAlgorithm = "md5-crypt"; viewURL = "mysql://my_db_user:my_db_pw@127.0.0.1:3306/sogo/sogo_users"; } ); SOGoVacationEnabled = NO; /* Debug */ SOGoDebugRequests = YES; SoDebugBaseURL = YES; ImapDebugEnabled = NO; LDAPDebugEnabled = YES; PGDebugEnabled = YES; MySQL4DebugEnabled = YES; SOGoUIxDebugEnabled = YES; WODontZipResponse = YES; WOLogFile = /var/log/sogo/sogo.log; } DB infos: mysql> show tables\G *************************** 1. row *************************** Tables_in_sogo: sogo_folder_info *************************** 2. row *************************** Tables_in_sogo: sogo_sessions_folder *************************** 3. row *************************** Tables_in_sogo: sogo_user_profile *************************** 4. row *************************** Tables_in_sogo: sogo_users a lot more tables, where e.g. *************************** 50. row *************************** Tables_in_sogo: sogoXXXXXXXX0012f15891e *************************** 51. row *************************** Tables_in_sogo: sogoXXXXXXXX0012f15891e_acl *************************** 52. row *************************** Tables_in_sogo: sogoXXXXXXXX0012f15891e_quick *************************** 53. row *************************** Tables_in_sogo: sogoXXXXXXXX0015c3f3c7f *************************** 54. row *************************** Tables_in_sogo: sogoXXXXXXXX0015c3f3c7f_acl *************************** 55. row *************************** Tables_in_sogo: sogoXXXXXXXX0015c3f3c7f_quick *************************** 56. row *************************** Tables_in_sogo: sogoXXXXXXXX0016c0568e9 *************************** 57. row *************************** Tables_in_sogo: sogoXXXXXXXX0016c0568e9_acl *************************** 58. row *************************** Tables_in_sogo: sogoXXXXXXXX0016c0568e9_quick *************************** 59. row *************************** Tables_in_sogo: sogoXXXXXXXX0026c191568 *************************** 60. row *************************** Tables_in_sogo: sogoXXXXXXXX0026c191568_acl *************************** 61. row *************************** Tables_in_sogo: sogoXXXXXXXX0026c191568_quick *************************** 62. row *************************** Tables_in_sogo: sogoXXXXXXXX0036e3c0a16 *************************** 63. row *************************** Tables_in_sogo: sogoXXXXXXXX0036e3c0a16_acl *************************** 64. row *************************** Tables_in_sogo: sogoXXXXXXXX0036e3c0a16_quick *************************** 65. row *************************** Tables_in_sogo: sogoXXXXXXXX004234ad723 *************************** 66. row *************************** Tables_in_sogo: sogoXXXXXXXX004234ad723_acl *************************** 67. row *************************** Tables_in_sogo: sogoXXXXXXXX004234ad723_quick 67 rows in set (0.00 sec) where XXXXXXXX is my_user (all 6 characters) directly followed by first two letters of my_domain. Other tables do look similar. mysql> describe sogo_users\G *************************** 1. row *************************** Field: c_uid Type: varchar(255) Null: NO Key: Default: Extra: *************************** 2. row *************************** Field: c_name Type: varchar(255) Null: NO Key: Default: Extra: *************************** 3. row *************************** Field: c_password Type: varchar(255) Null: NO Key: Default: Extra: *************************** 4. row *************************** Field: c_cn Type: varchar(255) Null: NO Key: Default: Extra: *************************** 5. row *************************** Field: mail Type: varchar(255) Null: NO Key: Default: Extra: 5 rows in set (0.00 sec) Passwords in sogo_users.c_password do all start with "$1$“, so I assume md5-crypt is ok (I did not change anything for the last 5 or so years). Does anybody have an idea, what could be the issue for this kind of problem and maybe has a solution for it? Thanks in advance for any help. Cheers Tobias-- users@sogo.nu https://inverse.ca/sogo/lists