OK I did a lot of testing with the domain and username settings in two email clients on Android, Bluemail and Vmware Boxer. Most of the tweaks do not even trigger a user lookup in the MySQL DB. It looks like the clients can't seem to generate the correct domain/username combo to log in. The one setting that APPEARS to be the one that COULD generate the correct combo can't connect to the server for some reason.
Below are the domain and username settings I used in the clients and the lines they generated in the sogo.log file. There were no other log lines generated. I've posted above all the lines generated prior to attempting a connection.
BTW, I cannot try to connect Outlook from windows at all since it doesn't let me edit any of the connection settings. I'm pretty sure it's forcing auto-discovery and there's no chance I've named my server what Outlook is expecting.
Gotta get this solved as I'm pretty much stuck without any contacts and calendar on my phone...
Bluemail Android Email Client
Domain\Username = user1@mydomain.net
Apr 22 13:31:53 sogod [9451]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 22 13:31:53 sogod [9451]: |SOGo| request took 0.001112 seconds to execute
Apr 22 13:31:53 sogod [9451]: mx.mydomain.net "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.002 - - 0
Error: You typed an incorrect server address or the server requires a protocol that Email doesn't support
Domain\Username = mydomain.net\user1@mydomain.net
Apr 22 13:24:57 sogod [9451]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 22 13:24:57 sogod [9451]: |SOGo| request took 0.000964 seconds to execute
Apr 22 13:24:57 sogod [9451]: mx.mydomain.net "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.002 - - 0
Error: You typed an incorrect server address or the server requires a protocol that Email doesn't support
Domain\Username = mydomain.net\user1
Apr 22 13:26:42 sogod [9451]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
2020-04-22 13:26:42.759 sogod[9451:9451] <MySQL4Channel[0x0x55743c9361c0] connection=0x0x55743cfbd8b0> SQL: SELECT c_password FROM users WHERE c_uid = 'user1';
2020-04-22 13:26:42.759 sogod[9451:9451] <MySQL4Channel[0x0x55743c9361c0] connection=0x0x55743cfbd8b0> query has results, entering fetch-mode.
Apr 22 13:26:42 sogod [9451]: <0x0x55743cc97c60[SOGoDAVAuthenticator]> tried wrong password for user 'user1'!
Apr 22 13:26:42 sogod [9451]: |SOGo| request took 0.000924 seconds to execute
Apr 22 13:26:42 sogod [9451]: mx.mydomain.net "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 401 12/0 0.002 - - 0
Error: Username or password is incorrect
Domain\Username = mydomain.net
Apr 22 13:28:02 sogod [9451]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
2020-04-22 13:28:02.985 sogod[9451:9451] <MySQL4Channel[0x0x55743c93af30] connection=0x0x55743cf6d6a0> SQL: SELECT c_password FROM users WHERE c_uid = 'mydomain.net';
2020-04-22 13:28:02.986 sogod[9451:9451] <MySQL4Channel[0x0x55743c93af30] connection=0x0x55743cf6d6a0> query has results, entering fetch-mode.
Apr 22 13:28:02 sogod [9451]: <0x0x55743cc97c60[SOGoDAVAuthenticator]> tried wrong password for user 'mydomain.net'!
Apr 22 13:28:02 sogod [9451]: |SOGo| request took 0.001116 seconds to execute
Apr 22 13:28:02 sogod [9451]: mx.mydomain.net "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 401 12/0 0.002 - - 0
Error: Username or password is incorrect
Boxer Android Email Client
Username = user1@mydomain.net, Domain = user1@mydomain.net, email address = user1@mydomain.net
no log entries made
Error: Can't connect to server
Username = user1@mydomain.net, Domain = mydomain.net, email address = user1@mydomain.net
Apr 22 13:37:28 sogod [9451]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 22 13:37:28 sogod [9451]: |SOGo| request took 0.001342 seconds to execute
Apr 22 13:37:28 sogod [9451]: mx.mydomain.net "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.002 - - 0
Error: Can't connect to server
Username = user1@mydomain.net, Domain = mx.mydomain.net, email address = user1@mydomain.net
Apr 22 13:38:28 sogod [9451]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
Apr 22 13:38:28 sogod [9451]: |SOGo| request took 0.001060 seconds to execute
Apr 22 13:38:28 sogod [9451]: mx.mydomain.net "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.002 - - 0
Error: Can't connect to server
Username = user1@mydomain.net, Domain = mydomain.net\user1@mydomain.net, email address = user1@mydomain.net
Apr 22 13:40:15 sogod [9451]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
2020-04-22 13:40:15.508 sogod[9451:9451] <MySQL4Channel[0x0x55743c7f7f50] connection=0x0x55743cf80ac0> SQL: SELECT c_password FROM users WHERE c_uid = 'user1@mydomain.net\user1@mydomain.net';
2020-04-22 13:40:15.509 sogod[9451:9451] <MySQL4Channel[0x0x55743c7f7f50] connection=0x0x55743cf80ac0> query has results, entering fetch-mode.
Apr 22 13:40:15 sogod [9451]: <0x0x55743cc97c60[SOGoDAVAuthenticator]> tried wrong password for user 'user1@mydomain.net\user1@mydomain.net'!
Apr 22 13:40:15 sogod [9451]: |SOGo| request took 0.001028 seconds to execute
Apr 22 13:40:15 sogod [9451]: mx.mydomain.net "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 401 12/0 0.002 - - 0
Error: Username or password is incorrect
Username = user1@mydomain.net, Domain = mydomain.net\, email address = user1@mydomain.net
Apr 22 13:42:24 sogod [9451]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync'
2020-04-22 13:42:24.466 sogod[9451:9451] <MySQL4Channel[0x0x55743c7f7f50] connection=0x0x55743cf80ac0> SQL: SELECT c_password FROM users WHERE c_uid = '\user1@mydomain.net';
2020-04-22 13:42:24.466 sogod[9451:9451] <MySQL4Channel[0x0x55743c7f7f50] connection=0x0x55743cf80ac0> query has results, entering fetch-mode.
2020-04-22 13:42:24.467 sogod[9451:9451] <MySQL4Channel[0x0x55743c936150] connection=0x0x55743cfbd8b0> SQL: SELECT * FROM users WHERE (c_uid = '\user1@mydomain.net') OR (mail = '\user1@mydomain.net');
2020-04-22 13:42:24.467 sogod[9451:9451] <MySQL4Channel[0x0x55743c936150] connection=0x0x55743cfbd8b0> query has results, entering fetch-mode.
Apr 22 13:42:24 sogod [9451]: |SOGo| request took 0.003176 seconds to execute
Apr 22 13:42:24 sogod [9451]: mx.mydomain.net "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.004 - - 0
Error: Can't connect to server
UPDATE FYI: The one promising Bluemail entry that looks like it SHOULD generate the correct login combos produced this line in the ngnix log:
172.58.21.66 - mydomain.net\x5Cuser1@mydomain.net [22/Apr/2020:11:26:00 -0700] "OPTIONS /Microsoft-Server-ActiveSync HTTP/1.1" 200 0 "-" "BlueMail/9-EAS-2.0"