--- Does anyone have any idea or clue? Thanks. On Tue, Apr 9, 2019 at 9:54 AM luckydog xf <luckydo...@gmail.com> wrote:
> Here is MySQL query logs > # the 1st statement does return my password. My c_uid is 'hongquan' and > mail is 'hongq...@ad.pthl.hk' 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 <luckydo...@gmail.com> 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 >> Email Address: hongq...@ad.pthl.hk >> >> # 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 <luckydo...@gmail.com> 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 <luckydo...@gmail.com> wrote: >>> >>>> LoginFieldNames = (c_uid, mail); >>>> >>>> Add this optionals, so that either hongquan or hongq...@ad.pthl.hk >>>> 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 <luckydo...@gmail.com> >>>> 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 >>>>> email addr: hongq...@ad.pthl.hk >>>>> username: hongq...@ad.pthl.hk ### I check that sogo reads account >>>>> name specified here ### >>>>> domain name: ad.pthl.hk >>>>> password: XXXX >>>>> server: mail.ad.pthl.hk >>>>> ...... >>>>> >>>>> Actually in MariadDB c_uid is *hongq...@ad.pthl.hk >>>>> <hongq...@ad.pthl.hk>*, NOT hongquan. But EAS use hongquan as query >>>>> string of SQL statement. >>>>> >>>>> Anything I can do to get rid of this ? Thanks. >>>>> >>>>> >>>>> >>>>> -- users@sogo.nu https://inverse.ca/sogo/lists