Re: [SOGo] Anyway to work around Chinese Character in sogo.conf
Does anyone have any idea? Thanks, guys. On Wed, May 29, 2019 at 11:58 AM luckydog xf wrote: > # sogo.conf > > { > .. > baseDN = "OU=IT服务部,OU=董事会,OU=互太高专,OU=互太纺织印染集团,DC=ms,DC=com" > > . > } > > SOGo cannot startup with an error, > > Parsing '/etc/sogo/sogo.conf' - bad char '\U670d' at 3993 > > Any way to work arount this error? > > Is it a must to use Non-Ascii code in sogo.conf? > > Thanks, > > -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Anyway to work around Chinese Character in sogo.conf
# sogo.conf { .. baseDN = "OU=IT服务部,OU=董事会,OU=互太高专,OU=互太纺织印染集团,DC=ms,DC=com" . } SOGo cannot startup with an error, Parsing '/etc/sogo/sogo.conf' - bad char '\U670d' at 3993 Any way to work arount this error? Is it a must to use Non-Ascii code in sogo.conf? Thanks, -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] What kind of license does it require if we use SOGo Exchange ActiveSync( EAS)
Hi, We're gonna use SOGo as EAS and I read SOGo doc where it writes: --- In order to use SOGo ActiveSync support code in production environments, you need to get a proper usage license from Microsoft. Please contact them directly to negotiate the fees associated to your user base. To contact Microsoft, please visit: http://www.microsoft.com/en-us/legal/intellectualproperty/ and send an email to iplic...@microsoft.com We provides this software for free, but is not responsible for anything related to its usage. -- I sent an email to iplic...@microsoft.com but I have not received any response yet. And I searched license of EAS, but it does not state clearly. So does anyone who uses EAS know how to handle this situation? Which license and price mode does it apply to? Thanks for your sharing. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Does
Thanks guys. I'll read docs as you suggest. On Tue, Apr 30, 2019 at 7:49 PM Markus Winkler wrote: > Hi luckydog, > > On Tue, 30 Apr 2019 at 12:40:07PM +0800, luckydog xf wrote: > >But I didn't congure https, does anyone share me that how to > >configure https? > > there are tons of how-to's regarding Apache and https like this one > (specific for SOGo): > > https://wiki.debian.org/SOGo > > But as you wrote: > > >yum install ... > ^^^ > you may prefer: > > > https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-centos-7 > https://linuxize.com/post/secure-apache-with-let-s-encrypt-on-centos-7/ > > HTH and regards, > Markus > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Does
it's my bad, I type a WRONG server name. After I fixed the server name, I used wireshark/tcpdump to capture packets, turns out outlook requests https( port 443). 172.16.232.24.49264 > 172.16.234.11.https: Flags [S], cksum 0x001f (correct), seq 3855978681, win 8192, options [mss 1460,nop,nop,sackOK], length 0 But I didn't congure https, does anyone share me that how to configure https? On Tue, Apr 30, 2019 at 11:36 AM luckydog xf wrote: > I use outlook 2016, here is my conf: > > 1. Add an Email Account -->Manual setup or addtional server types --> > outlook.com or Exachange ActiveSync compatible service. > 2. Your name : test > email address: t...@ad.pthl.hk > >mail server: mail.ad.pthl.hk >user name : test >password: > > --- > > it raised : > > Log onto Exchange ActiveSync mail server (EAS): The server cannot be found. > > I traced /etc/sogo/sogod.conf and /etc/httpd/logs/access_log, nothing is > up. > > > On Tue, Apr 30, 2019 at 8:16 AM luckydog xf wrote: > >> Here is my sogod.conf >> - >> { >> >> MySQL4Encoding = "utf8mb4"; >> SOGoProfileURL = "mysql://sogo:sogo%23123%21@localhost >> :3306/sogo/sogo_user_profile"; >> OCSFolderInfoURL = "mysql://sogo:sogo%23123%21@localhost >> :3306/sogo/sogo_folder_info"; >> OCSSessionsFolderURL = "mysql://sogo:sogo%23123%21@localhost >> :3306/sogo/sogo_sessions_folder"; >> OCSEMailAlarmsFolderURL = "mysql:// >> sogo:sogo%23123%21@127.0.0.1:3306/sogo/sogo_alarms_folder"; >> >> OCSCacheFolderURL = "mysql:// >> sogo:sogo%23123%21@127.0.0.1:3306/sogo/sogo_cache_folder"; >> OCSStoreURL = "mysql:// >> sogo:sogo%23123%21@127.0.0.1:3306/sogo/sogo_store"; >> OCSAclURL = "mysql://sogo:sogo%23123%21@127.0.0.1:3306/sogo/sogo_acl"; >> >> SOGoLoginModule = Calendar; >> >> SOGoForceExternalLoginWithEmail = yes; >> >> SOGoDraftsFolderName = Drafts; >> SOGoSentFolderName = Sent; >> SOGoTrashFolderName = Trash; >> SOGoIMAPServer = imaps://172.16.234.11:993; >> //SOGoSieveServer = sieve://127.0.0.1:4190; >> SOGoSMTPServer = 172.16.234.11; >> SOGoMailDomain = ad.pthl.hk; >> SOGoMailingMechanism = smtp; >> SOGoMailSpoolPath = /var/spool/sogo; >> //NGImap4ConnectionStringSeparator = "/"; >> >> /* Authentication */ >> //SOGoPasswordChangeEnabled = YES; >> >> /* LDAP authentication example */ >> SOGoUserSources = ( >> { >> type = ldap; >> CNFieldName = cn; >> UIDFieldName = uid; >> IDFieldName = uid; // first field of the DN for direct binds >> bindFields = (uid, mail); // array of fields to use for indirect >> binds >> baseDN = "ou=people,dc=ad,dc=pthl,dc=hk"; >> bindDN = "cn=Manager,dc=ad,dc=pthl,dc=hk"; >> bindPassword = "Abc#123!"; >> canAuthenticate = YES; >> displayName = "Shared Addresses"; >> hostname = ldap://127.0.0.1:389; >> id = public; >> isAddressBook = YES; >> } >> ); >> >> /* EAS optimization */ >> >> WOWorkersCount = 15; >> SOGoMaximumPingInterval = 3540; >> SOGoMaximumSyncInterval = 3540; >> SOGoInternalSyncInterval = 30; >> >> /* Web Interface */ >> SOGoPageTitle = SOGo; >> SOGoVacationEnabled = YES; >> SOGoForwardEnabled = YES; >> SOGoSieveScriptsEnabled = YES; >> SOGoMailAuxiliaryUserAccountsEnabled = YES; >> SOGoTrustProxyAuthentication = NO; >> SOGoXSRFValidationEnabled = YES; >> >> /* General - SOGoTimeZone *MUST* be defined */ >> SOGoLanguage = English; >> SOGoTimeZone = Asia/Shanghai; >> SOGoCalendarDefaultRoles = ( >> PublicDAndTViewer, >> ConfidentialDAndTViewer >> ); >> SOGoSuperUsernames = (sogo1, sogo2); // This is an array - keep the >> parens! >> SxVMemLimit = 768; >> WOPidFile = "/var/run/sogo/sogo.pid"; >> SOGoMemcachedHost = 127.0.0.1; >> >> /* Debug */ >> // SOGoDebugRequests = YES; >> //SoDebugBaseURL = YES; >> //ImapDebugEnabled = YES; >> //LDAPDebugEnabled = YES; >> //PGDebugEnabled = YES; >> //MySQL4DebugEnabled = YES; >> //SOGoUIxDebugEnabled = YES; >> //WODontZipResponse = YES; >> SOGoEASDebugEnabled = YES; >> WOLogFile = /var/log/sogo/sogo.log; >> } >> --
Re: [SOGo] Does
I use outlook 2016, here is my conf: 1. Add an Email Account -->Manual setup or addtional server types --> outlook.com or Exachange ActiveSync compatible service. 2. Your name : test email address: t...@ad.pthl.hk mail server: mail.ad.pthl.hk user name : test password: --- it raised : Log onto Exchange ActiveSync mail server (EAS): The server cannot be found. I traced /etc/sogo/sogod.conf and /etc/httpd/logs/access_log, nothing is up. On Tue, Apr 30, 2019 at 8:16 AM luckydog xf wrote: > Here is my sogod.conf > - > { > > MySQL4Encoding = "utf8mb4"; > SOGoProfileURL = "mysql://sogo:sogo%23123%21@localhost > :3306/sogo/sogo_user_profile"; > OCSFolderInfoURL = "mysql://sogo:sogo%23123%21@localhost > :3306/sogo/sogo_folder_info"; > OCSSessionsFolderURL = "mysql://sogo:sogo%23123%21@localhost > :3306/sogo/sogo_sessions_folder"; > OCSEMailAlarmsFolderURL = "mysql:// > sogo:sogo%23123%21@127.0.0.1:3306/sogo/sogo_alarms_folder"; > > OCSCacheFolderURL = "mysql:// > sogo:sogo%23123%21@127.0.0.1:3306/sogo/sogo_cache_folder"; > OCSStoreURL = "mysql://sogo:sogo%23123%21@127.0.0.1:3306/sogo/sogo_store > "; > OCSAclURL = "mysql://sogo:sogo%23123%21@127.0.0.1:3306/sogo/sogo_acl"; > > SOGoLoginModule = Calendar; > > SOGoForceExternalLoginWithEmail = yes; > > SOGoDraftsFolderName = Drafts; > SOGoSentFolderName = Sent; > SOGoTrashFolderName = Trash; > SOGoIMAPServer = imaps://172.16.234.11:993; > //SOGoSieveServer = sieve://127.0.0.1:4190; > SOGoSMTPServer = 172.16.234.11; > SOGoMailDomain = ad.pthl.hk; > SOGoMailingMechanism = smtp; > SOGoMailSpoolPath = /var/spool/sogo; > //NGImap4ConnectionStringSeparator = "/"; > > /* Authentication */ > //SOGoPasswordChangeEnabled = YES; > > /* LDAP authentication example */ > SOGoUserSources = ( > { > type = ldap; > CNFieldName = cn; > UIDFieldName = uid; > IDFieldName = uid; // first field of the DN for direct binds > bindFields = (uid, mail); // array of fields to use for indirect > binds > baseDN = "ou=people,dc=ad,dc=pthl,dc=hk"; > bindDN = "cn=Manager,dc=ad,dc=pthl,dc=hk"; > bindPassword = "Abc#123!"; > canAuthenticate = YES; > displayName = "Shared Addresses"; > hostname = ldap://127.0.0.1:389; > id = public; > isAddressBook = YES; > } > ); > > /* EAS optimization */ > > WOWorkersCount = 15; > SOGoMaximumPingInterval = 3540; > SOGoMaximumSyncInterval = 3540; > SOGoInternalSyncInterval = 30; > > /* Web Interface */ > SOGoPageTitle = SOGo; > SOGoVacationEnabled = YES; > SOGoForwardEnabled = YES; > SOGoSieveScriptsEnabled = YES; > SOGoMailAuxiliaryUserAccountsEnabled = YES; > SOGoTrustProxyAuthentication = NO; > SOGoXSRFValidationEnabled = YES; > > /* General - SOGoTimeZone *MUST* be defined */ > SOGoLanguage = English; > SOGoTimeZone = Asia/Shanghai; > SOGoCalendarDefaultRoles = ( > PublicDAndTViewer, > ConfidentialDAndTViewer > ); > SOGoSuperUsernames = (sogo1, sogo2); // This is an array - keep the > parens! > SxVMemLimit = 768; > WOPidFile = "/var/run/sogo/sogo.pid"; > SOGoMemcachedHost = 127.0.0.1; > > /* Debug */ > // SOGoDebugRequests = YES; > //SoDebugBaseURL = YES; > //ImapDebugEnabled = YES; > //LDAPDebugEnabled = YES; > //PGDebugEnabled = YES; > //MySQL4DebugEnabled = YES; > //SOGoUIxDebugEnabled = YES; > //WODontZipResponse = YES; > SOGoEASDebugEnabled = YES; > WOLogFile = /var/log/sogo/sogo.log; > } > -- > > I followed the docs https://sogo.nu/files/docs/SOGoInstallationGuide.html and > installed required packages by > > yum install sogo-activesync libwbxml > > Here is /etc/httpd/conf.d/SOGo.conf > Alias /SOGo.woa/WebServerResources/ \ > /usr/lib64/GNUstep/SOGo/WebServerResources/ > Alias /SOGo/WebServerResources/ \ > /usr/lib64/GNUstep/SOGo/WebServerResources/ > > > AllowOverride None > > > Order deny,allow > Allow from all > > = 2.4> > Require all granted > > > > ExpiresActive On > ExpiresDefault "access plus 1 year" > > > > > ProxyRequests Off > SetEnv proxy-nokeepalive 1 > ProxyPreserveHost On > > > > ProxyPass /Microsoft-Server-ActiveSync \ > http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \ > retry=60
Re: [SOGo] Does
quot;exchange rpc server is unavailable". What did I do wrong? Thanks, On Mon, Apr 29, 2019 at 10:56 PM lists wrote: > Hi, > > I'm unsure on using thunderbird with activesync, normally you would use > outlook (or a mobile device) to test this. > > But in principle: when using activesync, openchange and samba are not > required, you just need to install the sogo activesync package. (that > should be in the docs) > > EAS works beautifully here. > > MJ > > On 29-4-2019 11:00, luckydog xf (luckydo...@gmail.com) wrote: > > I followed the latest docs and it's ok via web page. But when I > > configure client like Thunderbird , > > > > Type: exchange > > username: x...@xxx.com <mailto:x...@xxx.com> > > password: > > exchange server: > > > > it raises an error, "exchange rpc server is unavailable". > > > > So what did I do wrong? An old doc says openchange and samba need to be > > configured. But it does not mention in latest doc. > > > > I want to user could use mail APP to receive email, calendar, > > contact.etc with their smartphone. So EAS must be configured. > > > > Thanks guys. > > > > > > On Mon, Apr 29, 2019 at 3:28 PM luckydog xf > <mailto:luckydo...@gmail.com>> wrote: > > > > Sorry, hit 'send' to fast, the subject should be 'is the latest doc > > completed for ActiveSync'? > > > > > > > > On Mon, Apr 29, 2019 at 3:27 PM luckydog xf > <mailto:luckydo...@gmail.com>> wrote: > > > > Hi, list, > > > > > > I have configured SOGo with LDAP and MariaDB, it works. But for > > Microsoft ActiveySync, it never works. > > > > I read and followed this doc, > > > https://sogo.nu/files/docs/SOGoInstallationGuide.html#_microsoft_enterprise_activesync > > > > I found a outdated docs which include openchange and samba > > installation, see below. > > > https://sogo.nu/files/docs/SOGoNativeOutlookConfigurationGuide.html > > > > It occurs to me that it said RPC is N/A when I configure email > > via MS exchange, > > > > So is the Active Sync partial in the 1st link ? I didn't see > > openchange and samba are included there. > > > > Thanks, > > > > > > > > > > > > -- > > users@sogo.nu > > https://inverse.ca/sogo/lists > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Does
Sorry, hit 'send' to fast, the subject should be 'is the latest doc completed for ActiveSync'? On Mon, Apr 29, 2019 at 3:27 PM luckydog xf wrote: > Hi, list, > > > I have configured SOGo with LDAP and MariaDB, it works. But for Microsoft > ActiveySync, it never works. > > I read and followed this doc, > https://sogo.nu/files/docs/SOGoInstallationGuide.html#_microsoft_enterprise_activesync > > I found a outdated docs which include openchange and samba installation, > see below. > https://sogo.nu/files/docs/SOGoNativeOutlookConfigurationGuide.html > > It occurs to me that it said RPC is N/A when I configure email via MS > exchange, > > So is the Active Sync partial in the 1st link ? I didn't see openchange > and samba are included there. > > Thanks, > > > > > > -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Does
I followed the latest docs and it's ok via web page. But when I configure client like Thunderbird , Type: exchange username: x...@xxx.com password: exchange server: it raises an error, "exchange rpc server is unavailable". So what did I do wrong? An old doc says openchange and samba need to be configured. But it does not mention in latest doc. I want to user could use mail APP to receive email, calendar, contact.etc with their smartphone. So EAS must be configured. Thanks guys. On Mon, Apr 29, 2019 at 3:28 PM luckydog xf wrote: > Sorry, hit 'send' to fast, the subject should be 'is the latest doc > completed for ActiveSync'? > > > > On Mon, Apr 29, 2019 at 3:27 PM luckydog xf wrote: > >> Hi, list, >> >> >> I have configured SOGo with LDAP and MariaDB, it works. But for Microsoft >> ActiveySync, it never works. >> >> I read and followed this doc, >> https://sogo.nu/files/docs/SOGoInstallationGuide.html#_microsoft_enterprise_activesync >> >> I found a outdated docs which include openchange and samba installation, >> see below. >> https://sogo.nu/files/docs/SOGoNativeOutlookConfigurationGuide.html >> >> It occurs to me that it said RPC is N/A when I configure email via MS >> exchange, >> >> So is the Active Sync partial in the 1st link ? I didn't see openchange >> and samba are included there. >> >> Thanks, >> >> >> >> >> >> > -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Does
Hi, list, I have configured SOGo with LDAP and MariaDB, it works. But for Microsoft ActiveySync, it never works. I read and followed this doc, https://sogo.nu/files/docs/SOGoInstallationGuide.html#_microsoft_enterprise_activesync I found a outdated docs which include openchange and samba installation, see below. https://sogo.nu/files/docs/SOGoNativeOutlookConfigurationGuide.html It occurs to me that it said RPC is N/A when I configure email via MS exchange, So is the Active Sync partial in the 1st link ? I didn't see openchange and samba are included there. Thanks, -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?
Bring this up, hope I could find out a solution. On Thu, Apr 11, 2019 at 10:23 AM luckydog xf wrote: > --- > Does anyone have any idea or clue? Thanks. > > On Tue, Apr 9, 2019 at 9:54 AM luckydog xf 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] > 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] > 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] > 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] > 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 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: >>> >>> >>> # 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 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 >>>> 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/
Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?
--- Does anyone have any idea or clue? Thanks. On Tue, Apr 9, 2019 at 9:54 AM luckydog xf 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] 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] 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] 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] 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 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: >> >> >> # 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 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 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 >>>> wrote: >>>> >>>>> # logs >>>>> >>>>> Apr 08 12:30:52 sogod [15247]: |SOGo| starting method 'OPTIONS' on uri >>>>> '/SOGo/Microsoft-Server-ActiveSync' >&
Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?
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: # 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 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 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 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] >>> SQL: *SELECT >>> c_password FROM view WHERE c_uid = 'hongquan';* >>> 2019-04-08 12:30:52.698 sogod[15247:15247] >>>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: >>> server: mail.ad.pthl.hk >>> .. >>> >>> Actually in MariadDB c_uid is *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
Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?
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] SQL:* SELECT c_password FROM views WHERE (c_uid = 'hongquan') OR (mail = 'hongquan');* 2019-04-09 09:51:25.256 sogod[5853:5853]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] *SQL: SELECT * FROM views WHERE (c_uid = 'hongquan') OR (mail = 'hongquan') OR (mail = 'hongquan');* 2019-04-09 09:51:25.262 sogod[5853:5853]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 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: > > > # 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 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 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 >>> 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] >>>> SQL: *SELECT >>>> c_password FROM view WHERE c_uid = 'hongquan';* >>>> 2019-04-08 12:30:52.698 sogod[15247:15247] >>>>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: >>>> server: mail.ad.pthl.hk >>>> .. >>>> >>>> Actually in MariadDB c_uid is *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
Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?
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 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 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] >> SQL: *SELECT >> c_password FROM view WHERE c_uid = 'hongquan';* >> 2019-04-08 12:30:52.698 sogod[15247:15247] >>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: >> server: mail.ad.pthl.hk >> .. >> >> Actually in MariadDB c_uid is *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
Re: [SOGo] Why does EAS(exchange active sync) use wrong account name?
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 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] > SQL: *SELECT > c_password FROM view WHERE c_uid = 'hongquan';* > 2019-04-08 12:30:52.698 sogod[15247:15247] >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: > server: mail.ad.pthl.hk > .. > > Actually in MariadDB c_uid is *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
[SOGo] Why does EAS(exchange active sync) use wrong account name?
# 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] SQL: *SELECT c_password FROM view WHERE c_uid = 'hongquan';* 2019-04-08 12:30:52.698 sogod[15247:15247]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: server: mail.ad.pthl.hk .. Actually in MariadDB c_uid is *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