Hi everybody,

I'm using Sogo for two month now and it' working well beside the multi domain which is making me crazy. To explain it quickly, they are 3 domains hosted on the same server with a mysql backend. The first domain two are able to login/logout. But after a few try, I can see in the address book that contact from an other domain is suggested. The third (and also the fourth) are having more difficulties: after a few login/logout, I can't login anymore.

Even a sogo-tool restore doesn't seems to find the user back, after some times it may works again.
sogo-tool restore -f ALL . j...@domain3.org
<0x0x28eff00[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
<0x0x28eff00[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
2016-06-24 13:19:18.488 sogo-tool[2135] user 'j...@domain3.org' not found

Does anybody is having an idea? I've checked the sogo config many times, updated yesterday to version 3.1.3-1, disabled memcached, changed password for the users, i'm still stucked.

Here are the details:

Log detail after  a failed login
----------------------------------------
Jun 24 13:21:32 sogod [885]: <0x0x7ff004ab7d60[SOGoActiveSyncDispatcher]> Sleeping 25 seconds while detecting changes in Ping... Jun 24 13:21:37 sogod [885]: <0x0x7ff004ab7d60[SOGoActiveSyncDispatcher]> Sleeping 20 seconds while detecting changes in Ping... Jun 24 13:21:42 sogod [885]: <0x0x7ff004ab7d60[SOGoActiveSyncDispatcher]> Sleeping 15 seconds while detecting changes in Ping... 2016-06-24 13:21:44.996 sogod[886] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2016-06-24 13:21:44.997 sogod[886] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! Jun 24 13:21:45 sogod [886]: SOGoRootPage Login from '109.134.5.125' for user 'j...@domain3.org' might not have worked - password policy: 65535 grace: -1 expire: -1 boun$

Log detail after a failed login (different answer: login succesfully then bad password)
-----------------------------------------------------------------------------------------------------------------
2016-06-24 13:25:27.058 sogod[2337] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2016-06-24 13:25:27.059 sogod[2337] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2016-06-24 13:25:27.061 sogod[2337] ERROR(-[NSNull(misc) forwardInvocation:]): called selector setObject:forKey: on NSNull !
2016-06-24 13:25:27.061 sogod[2337]   didn't set return value for type 'v'
Jun 24 13:25:27 sogod [2337]: SOGoRootPage successful login from '109.134.5.125' for user 'j...@domain3.org' - expire = -1 grace = -1 Jun 24 13:25:27 sogod [2337]: 109.134.5.125 "POST /SOGo/connect HTTP/1.1" 200 27/80 0.019 - - 0 2016-06-24 13:25:27.105 sogod[2337] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! 2016-06-24 13:25:27.107 sogod[2337] ERROR(-[NSNull(misc) forwardInvocation:]): called selector objectForKey: on NSNull ! Jun 24 13:25:27 sogod [2337]: <0x0x7fad9379a750[SOGoWebAuthenticator]> tried wrong password for user 'blablabla$ Jun 24 13:25:27 sogod [2337]: 109.134.5.125 "GET /SOGo/so/SOGo/j...@domain3.org HTTP/1.1" 200 7633/0 0.039 24599 68% 1M



Multidomain related config in the sogo.conf
----------------------------------------------------------
   SOGoEnableDomainBasedUID = YES;

    domains = {
       domain1.be = {
               SOGoMailDomain = domain1.be;
               SOGoDraftsFolderName = Drafts;
               SOGoJunkFolderName = Spam;
               SOGoUserSources = (
                    {
                       canAuthenticate = YES;
                       displayName = "Utilisateurs domain1.be";
                       id = users1;
                       isAddressBook = YES;
                       type = sql;
                       userPasswordAlgorithm = sha512;
                       LoginFieldNames = ( "c_name" );
viewURL ="mysql://sogo:password@127.0.0.1:3306/vimbadmin/sogo_users";
                       IMAPLoginFieldName = "mail";
                        DomainFieldName = "domain";
                    }
                );
               };
       domain2.be = {
               SOGoMailDomain = domain2.be;
               SOGoDraftsFolderName = Drafts;
               SOGoJunkFolderName = Spam;
               SOGoUserSources = (
                       {
                        canAuthenticate = YES;
                       displayName = "Utilisateurs domain2.be";
                       id = users2;
                      isAddressBook = YES;
                       type = sql;
                       userPasswordAlgorithm = sha512;
                       LoginFieldNames = ( "c_name" );
viewURL ="mysql://sogo:password@127.0.0.1:3306/vimbadmin/sogo_users";
                       IMAPLoginFieldName = "mail";
                       DomainFieldName = "domain";
                }
                );
               };
       domain3.org = {
               SOGoMailDomain = domain3.org;
               SOGoDraftsFolderName = Drafts;
               SOGoJunkFolderName = Spam;
               SOGoUserSources = (
                       {
                        canAuthenticate = YES;
                       displayName = "Utilisateurs domain3.org";
                       id = users3;
                       isAddressBook = YES;
                       type = sql;
                       userPasswordAlgorithm = sha512;
                       LoginFieldNames = ( "c_name" );
viewURL ="mysql://sogo:password@127.0.0.1:3306/vimbadmin/sogo_users";
                       IMAPLoginFieldName = "mail";
                       DomainFieldName = "domain";
                }
                );
               };
        };


Installed version
----------------------
dpkg -l | grep sogo
ii sogo:amd64 3.1.3-1 amd64 a modern and scalable groupware ii sogo-activesync 3.1.3-1 amd64 a modern and scalable groupware - ActiveSync module

dpkg -l | grep sope
ii libsope-appserver4.9 4.9.r1664.20160622 amd64 SOPE application server libraries ii libsope-core4.9 4.9.r1664.20160622 amd64 Core libraries of the SOPE application server ii libsope-gdl1-4.9 4.9.r1664.20160622 amd64 GNUstep database libraries for SOPE ii libsope-ldap4.9 4.9.r1664.20160622 amd64 SOPE libraries for LDAP access ii libsope-mime4.9 4.9.r1664.20160622 amd64 SOPE libraries for MIME processing ii libsope-xml4.9 4.9.r1664.20160622 amd64 SOPE libraries for XML processing ii sope4.9-gdl1-mysql 4.9.r1664.20160622 amd64 MySQL connector for SOPE's fork of the GNUstep database environment ii sope4.9-libxmlsaxdriver 4.9.r1664.20160622 amd64 XML Parser for SOPE's SAX engine


Operating system
------------------------
Debian jessie


Mysql table
---------------
mysql> select * from sogo_users;
+------------------+------------------+------------------+--------------+------------------+-----------------+
| c_uid | c_name | c_password | c_cn | mail | domain |
+------------------+------------------+------------------+--------------+------------------+-----------------+
| j...@domain1.be | j...@domain1.be | sha512pw_removed | john xx | j...@domain1.be | domain1.be | | to...@domain1.be | to...@domain1.be | sha512pw_removed | tonio xx | to...@domain1.be | domain1.be | | j...@domain2.be | j...@domain2.be | sha512pw_removed | | j...@domain2.be | domain2.be | | to...@domain2.be | to...@domain2.be | sha512pw_removed | tonio xx | to...@domain2.be | domain2.be | | j...@domain3.org | j...@domain3.org | sha512pw_removed | john xx | j...@domain3.org | domain3.org | | j...@domain3.org | j...@domain3.org | sha512pw_removed | jack xx | j...@domain3.org | domain3.org | | j...@test.zz | j...@test.zz | sha512pw_removed | | j...@test.zz | test.zz |
+------------------+------------------+------------------+--------------+------------------+-----------------+

Regards
Vincent
--
users@sogo.nu
https://inverse.ca/sogo/lists

Reply via email to