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