General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?


Chronological Thread 
  • From: "luckydog xf" ( ) < >
  • To:
  • Subject: Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?
  • Date: Tue, 9 Apr 2019 09:54:57 +0800
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca E0F941DE51A7

Here is MySQL query logs
# the 1st statement does return my password.  My c_uid is 'hongquan' and mail is ' ' in table views.
#  the 2nd statement return the entire fied of this record.

2019-04-09 09:51:25.255 sogod[5853:5853] <MySQL4Channel[0x0x560c316190c0] connection=0x0x560c33120f68> SQL: SELECT c_password FROM views WHERE (c_uid = 'hongquan') OR (mail = 'hongquan');
2019-04-09 09:51:25.256 sogod[5853:5853] <MySQL4Channel[0x0x560c316190c0] connection=0x0x560c33120f68>   query has results, entering fetch-mode.
2019-04-09 09:51:25.261 sogod[5853:5853] MySQL4 connection established 0x0x560c3311ff08
2019-04-09 09:51:25.261 sogod[5853:5853] MySQL4 channel 0x0x560c311f0ad0 opened (connection=0x0x560c3311ff08,sogo)
2019-04-09 09:51:25.261 sogod[5853:5853] <MySQL4Channel[0x0x560c311f0ad0] connection=0x0x560c3311ff08> SQL: SELECT * FROM views WHERE (c_uid = 'hongquan') OR (mail = 'hongquan') OR (mail = 'hongquan');
2019-04-09 09:51:25.262 sogod[5853:5853] <MySQL4Channel[0x0x560c311f0ad0] connection=0x0x560c3311ff08>   query has results, entering fetch-mode.
Apr 09 09:51:25 sogod [5853]: |SOGo| request took 0.008609 seconds to execute
Apr 09 09:51:25 sogod [5853]: 172.16.234.223 "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.009 - - 4K



On Tue, Apr 9, 2019 at 9:51 AM luckydog xf < > wrote:
Here is my settings.

-------------

 Desktop,  open Outlook2016,   New account, --->manual setup or addtional server types --->Outlook.com or Exchange ActiveSync compatible service.

  # user information
   Your Name: hongquan
  
  # server information
  mail Server: mail.ad.pthl.hk
  
  # logon information
   Username: hongquan
  Password: <xxxxx>


# sogo.log

Apr 09 09:47:10 sogod [5853]: 172.16.234.223 "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.007 - - 32K

Seeing from above log, authentication is OK.

Test account settings takes a while and raises an error that "Log onto Exchange ActiveSync mail server(EAS): the server cannot be found"

--- IMAP seting is fine and I can receive and send email ------


I visit http://mail.ad.pthl.hk//Microsoft-Server-ActiveSync is a bland page and access log is 200, so I assume ActiveSync is correct.


 What's wrong ?   Thanks.


On Mon, Apr 8, 2019 at 5:37 PM luckydog xf < > wrote:
Here is logs:


Apr 08 17:25:18 sogod [16322]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 08 17:25:18 sogod [16322]: |SOGo| request took 0.001262 seconds to execute
Apr 08 17:25:18 sogod [16322]: 172.16.234.223 "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.002 - - 0
Apr 08 17:26:36 sogod [16322]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 08 17:26:36 sogod [16322]: |SOGo| request took 0.001592 seconds to execute
Apr 08 17:26:36 sogod [16322]: 172.16.234.223 "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.003 - - 0
Apr 08 17:27:40 sogod [16322]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 08 17:27:40 sogod [16322]: |SOGo| request took 0.000844 seconds to execute
Apr 08 17:27:40 sogod [16322]: 172.16.234.223 "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.001 - - 0

Anything wrong?


On Mon, Apr 8, 2019 at 3:15 PM luckydog xf < > wrote:
        LoginFieldNames = (c_uid, mail);

Add this optionals, so that either hongquan or works. But http access log is
172.16.81.56 - - [08/Apr/2019:14:14:47 +0800] "OPTIONS /Microsoft-Server-ActiveSync HTTP/1.1" 200 - "-" "Android/5.1-EAS-1.3"
while it's probably due to App version, it still cannot sync email.etc.

On Mon, Apr 8, 2019 at 12:49 PM luckydog xf < > wrote:
# logs

Apr 08 12:30:52 sogod [15247]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
2019-04-08 12:30:52.697 sogod[15247:15247] <MySQL4Channel[0x0x557eeed170f0] connection=0x0x557eeee23bc8> SQL: SELECT c_password FROM view WHERE c_uid = 'hongquan';
2019-04-08 12:30:52.698 sogod[15247:15247] <MySQL4Channel[0x0x557eeed170f0] connection=0x0x557eeee23bc8>   query has results, entering fetch-mode.
Apr 08 12:30:52 sogod [15247]: <0x0x557eeeafec40[SOGoDAVAuthenticator]> tried wrong password for user 'hongquan'!
Apr 08 12:30:52 sogod [15247]: |SOGo| request took 0.001318 seconds to execute

# exchange client setup
username:   ### I check that sogo reads account name specified here ###
domain name: ad.pthl.hk
password: XXXX
......

Actually in MariadDB c_uid is , NOT hongquan. But EAS use hongquan as query string of SQL statement.

Anything I can do to get rid of this ? Thanks.






Archive powered by MHonArc 2.6.18.

Top of page