Re: [SOGo] SOGO+Samba4 AD - SOGo not finding e-mails - SOLVED
On Sat, 28 Nov 2020 at 15:15, Odhiambo Washington
wrote:
> Bump!
>
>
> I seem to have gotten more debug information:
>
>
> Nov 28 06:24:09 sogod [52594]: |SOGo| request took 0.317055 seconds to
> execute
> Nov 28 06:24:09 sogod [52594]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
> 200 56/84 0.321 - - 5M - 13
> Nov 28 06:24:10 sogod [52594]: |SOGo| starting method 'GET' on uri
> '/SOGo/so/odhiambo@newideatest.local'
> Nov 28 06:24:10 sogod [52594]: |SOGo| traverse(acquire):
> odhiambo@newideatest.local
> Nov 28 06:24:10 sogod [52594]: |SOGo| do traverse name:
> 'odhiambo@newideatest.local'
> Nov 28 06:24:10 sogod [52594]: |SOGo| traverse miss:
> name=odhiambo@newideatest.local, acquire: i=0,count=1
> Nov 28 06:24:10 sogod [52594]: |SOGo| miss is last object.
> Nov 28 06:24:10 sogod [52594]: |SOGo| handle miss error:
> NAME:SoAuthRequired
> REASON:authentication required
> Nov 28 06:24:10 sogod [52594]: |SOGo| request took 0.032842 seconds to
> execute
> Nov 28 06:24:10 sogod [52594]: 172.16.2.104 "GET
> /SOGo/so/odhiambo@newideatest.local HTTP/1.1" 200 7779/0 0.035 29219 73%
> 1M - 13
>
> On further digging, I found this thread:
> https://www.mail-archive.com/users@sogo.nu/msg27988.html
>
>
> I went with a toothcomb into my webserver config and modified some values
> under the proxy settings block, which now contains:
>
> http://127.0.0.1:2/SOGo>
> ## Adjust the following to your configuration
> ## and make sure to enable the 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" "http://%{HTTP_HOST}e";
> env=HTTP_HOST
>
> AddDefaultCharset UTF-8
>
> ## 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"
>
>
> This leads to the web UI beginning to load, but with an error: An error
> occured while communicating with the mail server
>
> Here is what I see in sogo.log:
>
> Nov 28 06:45:46 sogod [53415]: |SOGo| request took 0.031020 seconds to
> execute
> Nov 28 06:45:46 sogod [53415]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
> 403 34/84 0.033 - - 0 - 13
> Nov 28 06:46:04 sogod [53415]: |SOGo| starting method 'POST' on uri
> '/SOGo/connect'
> Nov 28 06:46:04 sogod [53415]: |SOGo| traverse(acquire): SOGo => connect
> Nov 28 06:46:04 sogod [53415]: |SOGo| do traverse name: 'SOGo'
> Nov 28 06:46:04 sogod [53415]: |SOGo| do traverse name: 'connect'
> Nov 28 06:46:04 sogod [53415]: |SOGo| set clientObject:
>
> Nov 28 06:46:04 sogod [53415]: <0x0x557e46588390[NGLdapConnection]> Using
> ldap_initialize for LDAP URL: ldap://127.0.0.1:389
> Nov 28 06:46:04 sogod [53415]: SOGoRootPage successful login from
> '172.16.2.104' for user 'odhiambo@newideatest.local' - expire = -1 grace
> = -1
> Nov 28 06:46:04 sogod [53415]: |SOGo| request took 0.048955 seconds to
> execute
> Nov 28 06:46:04 sogod [53415]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
> 200 56/84 0.051 - - 0 - 13
> Nov 28 06:46:05 sogod [53415]: |SOGo| starting method 'GET' on uri
> '/SOGo/so/odhiambo@newideatest.local'
> Nov 28 06:46:05 sogod [53415]: <0x0x557e464e60e0[NGLdapConnection]> Using
> ldap_initialize for LDAP URL: ldap://127.0.0.1:389
> Nov 28 06:46:05 sogod [53415]: <0x0x557e4658dd60[NGLdapConnection]> Using
> ldap_initialize for LDAP URL: ldap://127.0.0.1:389
> 2020-11-28 06:46:05.991 sogod[53415:53415] -[NGLdapConnection
> _searchAtBaseDN:qualifier:attributes:scope:]: search at base '' filter
> '(objectClass=*)' for attrs 'subschemaSubentry'
> 2020-11-28 06:46:05.992 sogod[53415:53415] -[NGLdapConnection
> _searchAtBaseDN:qualifier:attributes:scope:]: search at base
> 'CN=Aggregate,CN=Schema,CN=Configuration,DC=newideatest,DC=local' filter
> '(objectClass=*)' for attrs 'objectclasses'
> 2020-11-28 06:46:06.004 sogod[53415:53415] -[NGLdapConnection
> _searchAtBaseDN:qualifier:attributes:scope:]: search at base
> 'cn=users,dc=newideatest,dc=local' filter
> '(&(|(sAMAccountName=odhiambo)(mail=odhiambo))(mail=*))' for attrs 'dn'
> Nov 28 06:46:06 sogod [53415]: |SOGo| traverse(acquire):
> odhiambo@newideatest.local
> Nov 28 06:46:06 sogod [53415]: |SOGo| do traverse name:
> 'odhiambo@newideatest.local'
> Nov 28 06:46:06 sogod [53415]: |SOGo| set clientObject:
> <0x557e466aa290[SOGoUserFolder]: name=odhiambo
> container=0x557e460fb210/(null)>
> Nov 28 06:46:06 sogod [53415]: |SOGo| request took 0.057933 seconds to
> execute
> Nov 28 06:46:06 sogod [53415]: 172.16.2.104 "GET
> /SOGo/so/odhiambo@newideatest.local HTTP/1.1" 302 0/0 0.061 - - 916K - 14
> Nov 28 06:46:06 sogod [53415]: |SOGo| starting method 'GET' on uri
> '/SOGo/so/odhiambo@newideatest.local/view'
> Nov 28 06:46:06 sogod [53415]: |SOGo| tra
Re: [SOGo] SOGO+Samba4 AD - SOGo not finding e-mails
Bump!
I seem to have gotten more debug information:
Nov 28 06:24:09 sogod [52594]: |SOGo| request took 0.317055 seconds to
execute
Nov 28 06:24:09 sogod [52594]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
200 56/84 0.321 - - 5M - 13
Nov 28 06:24:10 sogod [52594]: |SOGo| starting method 'GET' on uri
'/SOGo/so/odhiambo@newideatest.local'
Nov 28 06:24:10 sogod [52594]: |SOGo| traverse(acquire):
odhiambo@newideatest.local
Nov 28 06:24:10 sogod [52594]: |SOGo| do traverse name:
'odhiambo@newideatest.local'
Nov 28 06:24:10 sogod [52594]: |SOGo| traverse miss:
name=odhiambo@newideatest.local, acquire: i=0,count=1
Nov 28 06:24:10 sogod [52594]: |SOGo| miss is last object.
Nov 28 06:24:10 sogod [52594]: |SOGo| handle miss error:
NAME:SoAuthRequired
REASON:authentication required
Nov 28 06:24:10 sogod [52594]: |SOGo| request took 0.032842 seconds to
execute
Nov 28 06:24:10 sogod [52594]: 172.16.2.104 "GET
/SOGo/so/odhiambo@newideatest.local HTTP/1.1" 200 7779/0 0.035 29219 73% 1M
- 13
On further digging, I found this thread:
https://www.mail-archive.com/users@sogo.nu/msg27988.html
I went with a toothcomb into my webserver config and modified some values
under the proxy settings block, which now contains:
http://127.0.0.1:2/SOGo>
## Adjust the following to your configuration
## and make sure to enable the 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" "http://%{HTTP_HOST}e";
env=HTTP_HOST
AddDefaultCharset UTF-8
## 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"
This leads to the web UI beginning to load, but with an error: An error
occured while communicating with the mail server
Here is what I see in sogo.log:
Nov 28 06:45:46 sogod [53415]: |SOGo| request took 0.031020 seconds to
execute
Nov 28 06:45:46 sogod [53415]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
403 34/84 0.033 - - 0 - 13
Nov 28 06:46:04 sogod [53415]: |SOGo| starting method 'POST' on uri
'/SOGo/connect'
Nov 28 06:46:04 sogod [53415]: |SOGo| traverse(acquire): SOGo => connect
Nov 28 06:46:04 sogod [53415]: |SOGo| do traverse name: 'SOGo'
Nov 28 06:46:04 sogod [53415]: |SOGo| do traverse name: 'connect'
Nov 28 06:46:04 sogod [53415]: |SOGo| set clientObject:
Nov 28 06:46:04 sogod [53415]: <0x0x557e46588390[NGLdapConnection]> Using
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
Nov 28 06:46:04 sogod [53415]: SOGoRootPage successful login from
'172.16.2.104' for user 'odhiambo@newideatest.local' - expire = -1 grace =
-1
Nov 28 06:46:04 sogod [53415]: |SOGo| request took 0.048955 seconds to
execute
Nov 28 06:46:04 sogod [53415]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
200 56/84 0.051 - - 0 - 13
Nov 28 06:46:05 sogod [53415]: |SOGo| starting method 'GET' on uri
'/SOGo/so/odhiambo@newideatest.local'
Nov 28 06:46:05 sogod [53415]: <0x0x557e464e60e0[NGLdapConnection]> Using
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
Nov 28 06:46:05 sogod [53415]: <0x0x557e4658dd60[NGLdapConnection]> Using
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
2020-11-28 06:46:05.991 sogod[53415:53415] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search at base '' filter
'(objectClass=*)' for attrs 'subschemaSubentry'
2020-11-28 06:46:05.992 sogod[53415:53415] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search at base
'CN=Aggregate,CN=Schema,CN=Configuration,DC=newideatest,DC=local' filter
'(objectClass=*)' for attrs 'objectclasses'
2020-11-28 06:46:06.004 sogod[53415:53415] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search at base
'cn=users,dc=newideatest,dc=local' filter
'(&(|(sAMAccountName=odhiambo)(mail=odhiambo))(mail=*))' for attrs 'dn'
Nov 28 06:46:06 sogod [53415]: |SOGo| traverse(acquire):
odhiambo@newideatest.local
Nov 28 06:46:06 sogod [53415]: |SOGo| do traverse name:
'odhiambo@newideatest.local'
Nov 28 06:46:06 sogod [53415]: |SOGo| set clientObject:
<0x557e466aa290[SOGoUserFolder]: name=odhiambo
container=0x557e460fb210/(null)>
Nov 28 06:46:06 sogod [53415]: |SOGo| request took 0.057933 seconds to
execute
Nov 28 06:46:06 sogod [53415]: 172.16.2.104 "GET
/SOGo/so/odhiambo@newideatest.local HTTP/1.1" 302 0/0 0.061 - - 916K - 14
Nov 28 06:46:06 sogod [53415]: |SOGo| starting method 'GET' on uri
'/SOGo/so/odhiambo@newideatest.local/view'
Nov 28 06:46:06 sogod [53415]: |SOGo| traverse(acquire):
odhiambo@newideatest.local => view
Nov 28 06:46:06 sogod [53415]: |SOGo| do traverse name:
'odhiambo@newideatest.local'
Nov 28 06:46:06 sogod [53415]: |SOGo| do traverse name: 'view'
Nov 28 06:46:06 sogod [53415]: |SOGo| set clientObject:
<0x557e464be
Re: [SOGo] SOGO+Samba4 AD - SOGo not finding e-mails
Bump!
Is anyone able to help me with this issue?
With the following in sogo.conf, I am unable to get the e-mails displayed
on the UI. I am able to login, but then SOGo immediately logs out!
SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
UIDFieldName = sAMAccountName;
baseDN = "cn=users,dc=newideatest,dc=local";
bindDN = "CN=dovecot,CN=users,DC=newideatest,DC=local";
bindPassword = "mi-secreta";
bindFields = (sAMAccountName, mail);
filter = "mail = '*'";
canAuthenticate = YES;
displayName = "NI Users";
hostname = "ldap://127.0.0.1:389";;
id = public_samba4AD;
isAddressBook = YES;
}
);
Here is what I see in sogo.log:
root@adc0:/home/wash# tail -f /var/log/sogo/sogo.log
Nov 28 05:44:01 sogod [51167]: <0x0x5573f3dcb2e0[WOWatchDog]> listening on
127.0.0.1:2
Nov 28 05:44:01 sogod [51167]: <0x0x5573f3dcb2e0[WOWatchDog]> watchdog
process pid: 51167
Nov 28 05:44:01 sogod [51167]: <0x0x7f1d5eb79360[WOWatchDogChild]> watchdog
request timeout set to 10 minutes
Nov 28 05:44:01 sogod [51167]: <0x0x5573f3dcb2e0[WOWatchDog]> preparing 3
children
Nov 28 05:44:01 sogod [51167]: <0x0x5573f3dcb2e0[WOWatchDog]> child spawned
with pid 51169
Nov 28 05:44:01 sogod [51167]: <0x0x5573f3dcb2e0[WOWatchDog]> child spawned
with pid 51170
Nov 28 05:44:01 sogod [51167]: <0x0x5573f3dcb2e0[WOWatchDog]> child spawned
with pid 51171
Nov 28 05:44:01 sogod [51169]: <0x0x5573f3f1daa0[WOHttpAdaptor]> notified
the watchdog that we are ready
Nov 28 05:44:01 sogod [51170]: <0x0x5573f3f10920[WOHttpAdaptor]> notified
the watchdog that we are ready
Nov 28 05:44:01 sogod [51171]: <0x0x5573f3f107e0[WOHttpAdaptor]> notified
the watchdog that we are ready
Nov 28 05:44:37 sogod [51171]: |SOGo| starting method 'POST' on uri
'/SOGo/connect'
Nov 28 05:44:37 sogod [51171]: <0x0x5573f3eb5ea0[SOGoCache]> Cache cleanup
interval set every 300.00 seconds
Nov 28 05:44:37 sogod [51171]: <0x0x5573f3eb5ea0[SOGoCache]> Using host(s)
'localhost' as server(s)
Nov 28 05:44:37 sogod [51171]: [WARN] <0x0x7f1d5eb9af60[WOxElemBuilder]>
could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
Nov 28 05:44:37 sogod [51171]: <0x0x5573f42465b0[NGLdapConnection]> Using
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
Nov 28 05:44:37 sogod [51171]: <0x0x5573f4237c50[NGLdapConnection]> Using
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
2020-11-28 05:44:37.981 sogod[51171:51171] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search at base '' filter
'(objectClass=*)' for attrs 'subschemaSubentry'
2020-11-28 05:44:37.982 sogod[51171:51171] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search at base
'CN=Aggregate,CN=Schema,CN=Configuration,DC=newideatest,DC=local' filter
'(objectClass=*)' for attrs 'objectclasses'
2020-11-28 05:44:38.149 sogod[51171:51171] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search at base
'cn=users,dc=newideatest,dc=local' filter
'(&(|(sAMAccountName=odhiambo@newideatest.local
)(mail=odhiambo@newideatest.local))(mail=*))' for attrs 'dn'
Nov 28 05:44:38 sogod [51171]: SOGoRootPage successful login from
'172.16.2.104' for user 'odhiambo@newideatest.local' - expire = -1 grace =
-1
Nov 28 05:44:38 sogod [51171]: <0x0x5573f434aef0[NGLdapConnection]> Using
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
2020-11-28 05:44:38.225 sogod[51171:51171] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search at base
'cn=users,dc=newideatest,dc=local' filter
'(&(|(samaccountname=odhiambo@newideatest.local
)(mail=odhiambo@newideatest.local))(mail=*))' for attrs '*'
Nov 28 05:44:38 sogod [51171]: <0x0x5573f4362c50[NGLdapConnection]> Using
ldap_initialize for LDAP URL: ldap://127.0.0.1:389
2020-11-28 05:44:38.281 sogod[51171:51171] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search at base
'cn=users,dc=newideatest,dc=local' filter
'(&(|(samaccountname=odhiambo)(mail=odhiambo))(mail=*))' for attrs '*'
Nov 28 05:44:38 sogod [51171]: [WARN]
<0x0x5573f43bd460[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists
in DAV permissions table
Nov 28 05:44:38 sogod [51171]: [WARN]
<0x0x5573f43bd460[SOGoWebDAVAclManager]> entry '{DAV:}write-properties'
already exists in DAV permissions table
Nov 28 05:44:38 sogod [51171]: [WARN]
<0x0x5573f43bd460[SOGoWebDAVAclManager]> entry '{DAV:}write-content'
already exists in DAV permissions table
Nov 28 05:44:38 sogod [51171]: |SOGo| request took 0.462954 seconds to
execute
Nov 28 05:44:38 sogod [51171]: 172.16.2.104 "POST /SOGo/connect HTTP/1.1"
200 56/84 0.476 - - 5M - 13
Nov 28 05:44:39 sogod [51171]: |SOGo| starting method 'GET' on uri
'/SOGo/so/odhiambo@newideatest.local'
Nov 28 05:44:39 sogod [51171]: |SOGo| request took 0.033459 seconds to
execute
Nov 28 05:44:
