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
