Bring this up, hope I could find out a solution. On Thu, Apr 11, 2019 at 10:23 AM luckydog xf <[email protected]> wrote:
> --- > Does anyone have any idea or clue? Thanks. > > On Tue, Apr 9, 2019 at 9:54 AM luckydog xf <[email protected]> wrote: > >> Here is MySQL query logs >> # the 1st statement does return my password. My c_uid is 'hongquan' and >> mail is '[email protected]' 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 <[email protected]> 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: [email protected] >>> >>> # 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 <[email protected]> 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 <[email protected]> >>>> wrote: >>>> >>>>> LoginFieldNames = (c_uid, mail); >>>>> >>>>> Add this optionals, so that either hongquan or [email protected] >>>>> 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 <[email protected]> >>>>> 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： [email protected] >>>>>> username: [email protected] ### 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 *[email protected] >>>>>> <[email protected]>*, NOT hongquan. But EAS use hongquan as query >>>>>> string of SQL statement. >>>>>> >>>>>> Anything I can do to get rid of this ? Thanks. >>>>>> >>>>>> >>>>>> >>>>>> -- [email protected] https://inverse.ca/sogo/lists
