Hi.
It sounds like your SOGo config is not matching your user backend, take
a look at the values of MailFieldNames & SOGoForceExternalLoginWithEmail
See:
https://sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL
If you can login to SOGo web, then maybe it's the mail client that is
sending user the user part of the e-mail and not the full email.
That's just my 2 cents.
On 24-04-2019 12:02, luckydog xf (luckydo...@gmail.com) wrote:
Bring this up, hope I could find out a solution.
On Thu, Apr 11, 2019 at 10:23 AM luckydog xf <luckydo...@gmail.com
<mailto:luckydo...@gmail.com>> wrote:
---
Does anyone have any idea or clue? Thanks.
On Tue, Apr 9, 2019 at 9:54 AM luckydog xf <luckydo...@gmail.com
<mailto: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
<mailto: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 <mailto: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
<mailto:hongq...@ad.pthl.hk>
# server information
mail Server: mail.ad.pthl.hk <http://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 <mailto: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 <mailto:luckydo...@gmail.com>>
wrote:
LoginFieldNames = (c_uid, mail);
Add this optionals, so that either hongquan or
hongq...@ad.pthl.hk <mailto: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
<mailto: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
<mailto:hongq...@ad.pthl.hk>
username: hongq...@ad.pthl.hk
<mailto:hongq...@ad.pthl.hk> ### I check that
sogo reads account name specified here ###
domain name: ad.pthl.hk <http://ad.pthl.hk>
password: XXXX
server: mail.ad.pthl.hk <http://mail.ad.pthl.hk>
......
Actually in MariadDB c_uid is
*hongq...@ad.pthl.hk
<mailto: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
--
Hilsen/Regards
Christian M. Jensen
--
users@sogo.nu
https://inverse.ca/sogo/lists