RE: [SOGo] Active Sync WBXML Issue
Getting the Following from the Microsoft Remote Connectivity Analyzer When Testing the Sync of inbox The Following tests Passed Attempting to send the OPTIONS command to the server. The OPTIONS response was successfully received and is valid. Attempting the FolderSync command on the Exchange ActiveSync session. The FolderSync command completed successfully. Attempting the initial sync to the Inbox folder. This initial sync won't return any data. The Sync command completed successfully. Attempting to test the GetItemEstimate command for the Inbox folder. The Microsoft Connectivity Analyzer successfully received the GetItemEstimate response from the server. The Below Final Sync Request Failed Attempting to test synchronization of the Inbox folder. An error occurred while the Sync command was being tested. Additional Details We received an invalid WBXML response from the server. HTTP Response Headers: Referrer-Policy: same-origin Sogo-Request-Duration: 3.288376 MS-Server-ActiveSync: 14.1 MS-ASProtocolVersions: 2.5,12.0,12.1,14.0,14.1 MS-ASProtocolCommands: Sync,SendMail,SmartForward,SmartReply,GetAttachment,GetHierarchy,CreateColle ction,DeleteCollection, MoveCollection,FolderSync,FolderCreate,FolderDelete,FolderUpdate,MoveItems,G etItemEstimate,MeetingResponse,Search,Settings,Ping,ItemOperations,ResolveRe cipients,ValidateCert Pragma: no-cache Content-Length: 1685 Cache-Control: max-age=0 Cache-Control: no-cache Cache-Control: no-store Cache-Control: must-revalidate Content-Type: application/vnd.ms-sync.wbxml Date: Thu, 22 Feb 2024 04:45:45 GMT Server: Apache/2.4.58 (Fedora Linux) OpenSSL/3.0.9
RE: [SOGo] Activesync Error
Has Anyone Seen this Message when Running the "Microsoft Remote Connection
Analyzer
--
Attempting to test synchronization of the Inbox folder.
An error occurred while the Sync command was being tested.
Additional Details
We received an invalid WBXML response from the server.
HTTP Response Headers:
Referrer-Policy: same-origin
Sogo-Request-Duration: 2.160863
MS-Server-ActiveSync: 14.1
MS-ASProtocolVersions: 2.5,12.0,12.1,14.0,14.1
MS-ASProtocolCommands:
--
If I don't select the option to Sync inbox - Everything Works Fine
If I select Sync - I get the Above Error
Also when Connecting to Microsoft Outlook Client vi ActiveSync - the SOGo
Server repeatedly send the Inbox information
Android Clients Connect via ActiveSync Properly
Rob Himics
r...@himicsfamily.com
-Original Message-
From: "Robert Himics"
Sent: Sunday, February 11, 2024 2:28 PM
To: users@sogo.nu
Subject: RE: [SOGo] Activesync Error
Ok Continuing to get Better – Have Active Sync Woking Mostly
To Fix the Proxy Authentication Issue, I changed
AuthName "SOGo"
AuthType Basic
Require valid-user
SetEnv proxy-nokeepalive 1
Allow from all
To
AuthName "SOGo"
AuthType Basic
AuthBasicProvider dbd
AuthDBDUserPWQuery "select
concat('{SHA}',to_base64(unhex(sha1(c_password as password from sogo_users
where lower(c_uid) = lower(%s)"
Require valid-user
SetEnv proxy-nokeepalive 1
Allow from all
(Thanks for all the Insights – and Help to get through the above)
For Mobile Devices ActiveSync Is working Fine – I can Get Emails / Calendars /
etc)
Here’s the Issue I’m Now having:
For the Microsoft 365 Outlook Client
The Initial Connect / Validation of Account Work, But when Using Microsoft 365
Outlook, Not Synching any Emails or Claendars.
RE: [SOGo] Activesync Error
Ok Continuing to get Better – Have Active Sync Woking Mostly
To Fix the Proxy Authentication Issue, I changed
AuthName "SOGo"
AuthType Basic
Require valid-user
SetEnv proxy-nokeepalive 1
Allow from all
To
AuthName "SOGo"
AuthType Basic
AuthBasicProvider dbd
AuthDBDUserPWQuery "select
concat('{SHA}',to_base64(unhex(sha1(c_password as password from sogo_users
where lower(c_uid) = lower(%s)"
Require valid-user
SetEnv proxy-nokeepalive 1
Allow from all
(Thanks for all the Insights – and Help to get through the above)
For Mobile Devices ActiveSync Is working Fine – I can Get Emails / Calendars /
etc)
Here’s the Issue I’m Now having:
For the Microsoft 365 Outlook Client
The Initial Connect / Validation of Account Work,
But when Using Microsoft 365 Outlook, Not Synching any Emails or Claendars.
RE: [SOGo] Activesync Error
Thanks for the Help So Far - I believe I'm getting very close to having
ActiveSync working. I have validated the apache sogo.conf File on My internal
SOGo Groupware Server with what Raoul Schroeder Provided
As a Recap -- This is what I have
Internet Facing Server Apache 2.4 which Proxies to a separate SOGo groupware
server. (I intend to have a few Different Domains Connecting to the Internal
SOGo Groupware
This is what I see in the Apache Log File
101.11.11.179 - - [04/Feb/2024:21:05:31 -0500] "OPTIONS
/Microsoft-Server-ActiveSync/ HTTP/1.1" 401 381
[Sun Feb 04 21:05:31.249762 2024] [authn_file:error] [pid 8073:tid 8242]
[client 101.11.11.179:48450] AH01619: AuthUserFile not specified in the
configuration
101.11.11.179 - u...@domain.com [04/Feb/2024:21:05:31 -0500] "OPTIONS
/Microsoft-Server-ActiveSync/ HTTP/1.1" 500 533
I believe I'm having an issue with the validation of the user credential the
Internal Apache Server is Blocking the access and It's not getting to the
Internal SOGo Groupware Server
Green Highlighted Section may be the issue
Below are the Two Apache Server's configuration files for SOGo
==
Internet Facing Apache 2.4 Server has the Following:
==
RequestHeader set "x-webobjects-server-port" "443"
RequestHeader set "x-webobjects-server-name" "katherineangela.com"
RequestHeader set "x-webobjects-server-url" "http://katherineangela.com;
## Proxy Additions to enable access to Internal Mail Svr Web Client (SOGo)
Header set Cache-Control "max-age=0, no-cache, no-store, must-revalidate"
Header set Pragma "no-cache"
SetEnv proxy-nokeepalive 1
#SetEnv proxy-initial-not-pooled 1
SSLProxyEngine On
ProxyRequests Off
ProxyPreserveHost On
ProxyTimeout 720
ProxyVia Full
SSLProxyVerify none
SSLProxyCheckPeerCN off
SSLProxyCheckPeerName off
SSLProxyCheckPeerExpire off
CheckSpelling on
RequestHeader edit Transfer-Encoding Chunked chunked early
RequestHeader unset Accept-Encoding
ProxyPass https://vmailsvrint.domain.net/Microsoft-Server-ActiveSync
acquire=3000 retry=60 connectiontimeout=600 timeout=4000
ProxyPassReverse
https://vmailsvrint.domain.net/Microsoft-Server-ActiveSync
SSLRequireSSL
AllowMethods GET POST OPTIONS
#Require all granted ## May Not be needed
Header setifempty MS-Server-ActiveSync "2.5,12.0,12.1,14.0,14.1"
Header setifempty MS-ASProtocolVersions "2.5,12.0,12.1,14.0,14.1"
RequestHeader set "x-webobjects-server-port" "443"
SetEnvIf Host (.*) HTTP_HOST=$1
RequestHeader set "x-webobjects-server-name" "%{HTTP_HOST}e"
env=HTTP_HOST
RequestHeader set "x-webobjects-server-url" "https://%{HTTP_HOST}e;
env=HTTP_HOST
RequestHeader unset "x-webobjects-remote-user"
RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
==
Internal Apache 2.4 Server has the Following:
==
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
# Explicitly allow caching of static content to avoid browser specific
behavior.
# A resource's URL MUST change in order to have the client load the new
version.
ExpiresActive On
ExpiresDefault "access plus 1 year"
# Don't send the Referer header for cross-origin requests
Header always set Referrer-Policy "same-origin"
# Don't cache dynamic content
Header set Cache-Control "max-age=0, no-cache, no-store"
## Uncomment the following to enable proxy-side authentication, you will then
## need to set the "SOGoTrustProxyAuthentication" SOGo user default to YES and
## adjust the "x-webobjects-remote-user" proxy header in the "Proxy" section
## below.
#
## For full proxy-side authentication:
#
# AuthName "SOGo"
# AuthType Basic
# Require valid-user
# SetEnv proxy-nokeepalive 1
# Allow from all
#
#
## For proxy-side authentication only for CardDAV and GroupDAV from external
## clients:
#
# AuthType XXX
# Require valid-user
# SetEnv proxy-nokeepalive 1
# Allow from all
#
ProxyRequests Off
ProxyPreserveHost On
SetEnv proxy-nokeepalive 1
# Uncomment the following lines if you experience "Bad gateway" errors with
mod_proxy
SetEnv proxy-initial-not-pooled 1
SetEnv force-proxy-request-1.0 1
# When using CAS, you should uncomment this and install cas-proxy-validate.py
# in /usr/lib64/cgi-bin to reduce server overloading
#
# ProxyPass
Re: [SOGo] ActiveSync Error
Follow-up question.Is there a working apache SOGo.conf file that I can compare to to make sure everything is set right.Robert Himicsr...@himicsfamily.comOn Jan 31, 2024 4:54 PM, "\\Robert Himics\\" wrote:Yes. I tried Multiple time And I agree that it is strange.I used activeSync from a different mail Env (not SOGo based) with an Apache reverse proxy infront. So not sure the issue.Robert Himicsr...@himicsfamily.comOn Jan 31, 2024 8:45 AM, "\\Raoul Schroeder\\" wrote:Hi Robert, The wstunnel is not needed, that is for a websocket proxy only. Are you sure you gave the ActiveSync Test the proper username and password? The 401 error is strange. BR, Raoul Von: users-requ...@sogo.nu Im Auftrag von "Robert Himics"Gesendet: Mittwoch, 31. Januar 2024 13:47An: users@sogo.nuBetreff: RE: [SOGo] ActiveSync Error Yes using apache and yes have the below line.Will check on the modules. Wstunnel is the ony one not sure.ProxyPass /Microsoft-Server-ActiveSync \http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \retry=60 connectiontimeout=5 timeout=3600 I have the followings in the environment. Apache svr on internet that has Reverse proxy to internal Apache svr where SOGo is running. Robert Himicsr...@himicsfamily.com On Jan 31, 2024 4:34 AM, "\\Raoul Schroeder\\" <users@sogo.nu> wrote:Are you using apache? Do you have proxy enabled on your apache config?If you enter: sudo apachectl -MYou should find the following in the list:proxy_module (shared)proxy_http_module (shared)proxy_wstunnel_module (shared) Do you have the following line in your config?ProxyPass /Microsoft-Server-ActiveSync \http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \retry=60 connectiontimeout=5 timeout=3600 Von: users-requ...@sogo.nu <users-requ...@sogo.nu> Im Auftrag von "Robert Himics"Gesendet: Mittwoch, 31. Januar 2024 08:02An: users@sogo.nuCc: 'Rob Himics' <r...@himicsfamily.com>Betreff: RE: [SOGo] ActiveSync Error I’m Trying to Get ActiveSync to Work Getting this in sogo logsJan 31 01:49:27 sogod [5769]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync/'Jan 31 01:49:27 sogod [5769]: |SOGo| request took 0.000950 seconds to executeJan 31 01:49:27 sogod [5769]: 52.109.8.10, 101.11.11.179 "OPTIONS /SOGo/Microsoft-Server-ActiveSync/ HTTP/1.0" 401 0/0 0.003 - - 0 - 12 Also From The Microsoft ActiveSync testing ToolWhat have I Missed – Other that ActiveSync Everything Looks like it’s Works Rob Himicsr...@himicsfamily.com
Re: [SOGo] ActiveSync Error
Yes. I tried Multiple time And I agree that it is strange.I used activeSync from a different mail Env (not SOGo based) with an Apache reverse proxy infront. So not sure the issue.Robert Himicsr...@himicsfamily.comOn Jan 31, 2024 8:45 AM, "\\Raoul Schroeder\\" wrote:Hi Robert, The wstunnel is not needed, that is for a websocket proxy only. Are you sure you gave the ActiveSync Test the proper username and password? The 401 error is strange. BR, Raoul Von: users-requ...@sogo.nu Im Auftrag von "Robert Himics"Gesendet: Mittwoch, 31. Januar 2024 13:47An: users@sogo.nuBetreff: RE: [SOGo] ActiveSync Error Yes using apache and yes have the below line.Will check on the modules. Wstunnel is the ony one not sure.ProxyPass /Microsoft-Server-ActiveSync \http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \retry=60 connectiontimeout=5 timeout=3600 I have the followings in the environment. Apache svr on internet that has Reverse proxy to internal Apache svr where SOGo is running. Robert Himicsr...@himicsfamily.com On Jan 31, 2024 4:34 AM, "\\Raoul Schroeder\\" <users@sogo.nu> wrote:Are you using apache? Do you have proxy enabled on your apache config?If you enter: sudo apachectl -MYou should find the following in the list:proxy_module (shared)proxy_http_module (shared)proxy_wstunnel_module (shared) Do you have the following line in your config?ProxyPass /Microsoft-Server-ActiveSync \http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \retry=60 connectiontimeout=5 timeout=3600 Von: users-requ...@sogo.nu <users-requ...@sogo.nu> Im Auftrag von "Robert Himics"Gesendet: Mittwoch, 31. Januar 2024 08:02An: users@sogo.nuCc: 'Rob Himics' <r...@himicsfamily.com>Betreff: RE: [SOGo] ActiveSync Error I’m Trying to Get ActiveSync to Work Getting this in sogo logsJan 31 01:49:27 sogod [5769]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync/'Jan 31 01:49:27 sogod [5769]: |SOGo| request took 0.000950 seconds to executeJan 31 01:49:27 sogod [5769]: 52.109.8.10, 101.11.11.179 "OPTIONS /SOGo/Microsoft-Server-ActiveSync/ HTTP/1.0" 401 0/0 0.003 - - 0 - 12 Also From The Microsoft ActiveSync testing ToolWhat have I Missed – Other that ActiveSync Everything Looks like it’s Works Rob Himicsr...@himicsfamily.com
RE: [SOGo] ActiveSync Error
Yes using apache and yes have the below line.Will check on the modules. Wstunnel is the ony one not sure.ProxyPass /Microsoft-Server-ActiveSync \http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \retry=60 connectiontimeout=5 timeout=3600I have the followings in the environment.Apache svr on internet that has Reverse proxy to internal Apache svr where SOGo is running.Robert Himicsr...@himicsfamily.comOn Jan 31, 2024 4:34 AM, "\\Raoul Schroeder\\" wrote:Are you using apache? Do you have proxy enabled on your apache config?If you enter: sudo apachectl -MYou should find the following in the list:proxy_module (shared) proxy_http_module (shared) proxy_wstunnel_module (shared) Do you have the following line in your config?ProxyPass /Microsoft-Server-ActiveSync \ http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \ retry=60 connectiontimeout=5 timeout=3600 Von: users-requ...@sogo.nu Im Auftrag von "Robert Himics"Gesendet: Mittwoch, 31. Januar 2024 08:02An: users@sogo.nuCc: 'Rob Himics' Betreff: RE: [SOGo] ActiveSync Error I’m Trying to Get ActiveSync to Work Getting this in sogo logsJan 31 01:49:27 sogod [5769]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync/'Jan 31 01:49:27 sogod [5769]: |SOGo| request took 0.000950 seconds to executeJan 31 01:49:27 sogod [5769]: 52.109.8.10, 101.11.11.179 "OPTIONS /SOGo/Microsoft-Server-ActiveSync/ HTTP/1.0" 401 0/0 0.003 - - 0 - 12 Also From The Microsoft ActiveSync testing ToolWhat have I Missed – Other that ActiveSync Everything Looks like it’s Works Rob Himicsr...@himicsfamily.com
RE: [SOGo] ActiveSync Error
I'm Trying to Get ActiveSync to Work Getting this in sogo logs Jan 31 01:49:27 sogod [5769]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync/' Jan 31 01:49:27 sogod [5769]: |SOGo| request took 0.000950 seconds to execute Jan 31 01:49:27 sogod [5769]: 52.109.8.10, 101.11.11.179 "OPTIONS /SOGo/Microsoft-Server-ActiveSync/ HTTP/1.0" 401 0/0 0.003 - - 0 - 12 Also From The Microsoft ActiveSync testing Tool What have I Missed - Other that ActiveSync Everything Looks like it's Works Rob Himics r...@himicsfamily.com
RE: [SOGo] ActiveSync Question ** Update **
And Here is another Block with errors
2024-01-22 23:06:25.279 sogod[16188:16188] SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60ea739561d';
2024-01-22 23:06:25.280 sogod[16188:16188]query has results, entering fetch-mode.
2024-01-22 23:06:25.281 sogod[16188:16188] SQL: INSERT INTO sogo_cache_folder (c_path,
c_parent_path, c_type, c_creationdate, c_lastmodified, c_deleted,
c_version, c_content) VALUES
('/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60ea739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'HAJkaXNwbGF5TmFtZQAGSU5CT1gAAA==');
2024-01-22 23:06:25.281 sogod[16188:16188]ERROR: Field 'c_uid' doesn't have a default
value
Jan 22 23:06:25 sogod [16188]: [ERROR]
<0x5609af8ed9b0[SOGoCacheGCSObject]:641E1A9E3AD644BC89A235F3906A60F5+folder8
79a9b26eb22ac65c60ea739561d> could not insert/update record for record
'/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60ea739561d'
in sogo_cache_folder: NAME:ExecutionFailed
REASON:Field 'c_uid' doesn't have a default value
2024-01-22 23:06:25.283 sogod[16188:16188] SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b416a739561d';
2024-01-22 23:06:25.283 sogod[16188:16188]query has results, entering fetch-mode.
2024-01-22 23:06:25.284 sogod[16188:16188] SQL: INSERT INTO sogo_cache_folder (c_path,
c_parent_path, c_type, c_creationdate, c_lastmodified, c_deleted,
c_version, c_content) VALUES
('/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b416a739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'HQJkaXNwbGF5TmFtZQAHRHJhZnRzAAA=');
2024-01-22 23:06:25.285 sogod[16188:16188]ERROR: Field 'c_uid' doesn't have a default
value
Jan 22 23:06:25 sogod [16188]: [ERROR]
<0x5609af748410[SOGoCacheGCSObject]:641E1A9E3AD644BC89A235F3906A60F5+folder7
65ed91e067dac65b416a739561d> could not insert/update record for record
'/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b416a739561d'
in sogo_cache_folder: NAME:ExecutionFailed
REASON:Field 'c_uid' doesn't have a default value
2024-01-22 23:06:25.286 sogod[16188:16188] SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder5871c02a067dac65b416a739561d';
2024-01-22 23:06:25.287 sogod[16188:16188]query has results, entering fetch-mode.
2024-01-22 23:06:25.287 sogod[16188:16188] SQL: INSERT INTO sogo_cache_folder (c_path,
c_parent_path, c_type, c_creationdate, c_lastmodified, c_deleted,
c_version, c_content) VALUES
('/641E1A9E3AD644BC89A235F3906A60F5+folder5871c02a067dac65b416a739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'GwJkaXNwbGF5TmFtZQAFU2VudAAA');
Is Something missing in the Database Cofiguration
or Due to the First Error c_uid is Not being Retrieved right
My sogo User table is a View Based on the Dovecot users table
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| c_uid | varchar(100) | NO | | NULL| |
| c_name | varchar(100) | NO | | NULL| |
| c_cn | varchar(120) | NO | | NULL| |
| c_password | varchar(64) | NO | | NULL| |
| mail | varchar(100) | NO | | NULL| |
++--+--+-+-+---+
Robert Himics
<mailto:r...@himicsfamily.com> r...@himicsfamily.com
From: "Robert Himics"
Sent: Monday, January 22, 2024 11:26 PM
To: users@sogo.nu
Subject: RE: ActiveSync Question ** Update **
After turning on active Sync Logging I see an Error that Repeats
2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]: close channel count[2]
2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]: close channel count[1]
2024-01-22 23:04:28.734 sogod[16189:16189] -- -[MySQL4Channel
primaryCloseChannel]: close channel count[2]
2024-01-22 23:04:28.739 sogod[16188:16188] -- -[MySQL4Channel
primaryCloseChannel]: close channel count[1]
Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'OPTIONS' on uri
'/SOGo/Microsoft-Server-ActiveSync'
2024-01-22 23:06:23.005 sogod[16188:16188] MySQL4 connection established
0x0x5609af69d250
2024-01-22 23:06:23.005 sogod[16188:16188] -- -[MySQL4Channel
openChannel]:
opens channel count[0]
2024-01-22 23:06:23.006 sogod[16188:16188] MySQL4 channel 0x0x5609af7ff600
opened (connection=0x0x5609af69d250,grpware)
2024-01-22 23:06:23.009 sogod[16188:16188] SQL: SELECT * FROM sogo_users_domain WHERE
(c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');
2024-01-22 23:06:23.011 sogod[16188:16188]query has results, entering fetch-mode.
Jan 22 23:06:23 sogod [16188]: <0x0x56
RE: [SOGo] ActiveSync Question ** Update **
After turning on active Sync Logging I see an Error that Repeats 2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel primaryCloseChannel]: close channel count[2] 2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel primaryCloseChannel]: close channel count[1] 2024-01-22 23:04:28.734 sogod[16189:16189] -- -[MySQL4Channel primaryCloseChannel]: close channel count[2] 2024-01-22 23:04:28.739 sogod[16188:16188] -- -[MySQL4Channel primaryCloseChannel]: close channel count[1] Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync' 2024-01-22 23:06:23.005 sogod[16188:16188] MySQL4 connection established 0x0x5609af69d250 2024-01-22 23:06:23.005 sogod[16188:16188] -- -[MySQL4Channel openChannel]: opens channel count[0] 2024-01-22 23:06:23.006 sogod[16188:16188] MySQL4 channel 0x0x5609af7ff600 opened (connection=0x0x5609af69d250,grpware) 2024-01-22 23:06:23.009 sogod[16188:16188] SQL: SELECT * FROM sogo_users_domain WHERE (c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net'); 2024-01-22 23:06:23.011 sogod[16188:16188]query has results, entering fetch-mode. Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error occurred when caching value for key 'em...@domain.net+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY" Jan 22 23:06:23 sogod [16188]: |SOGo| request took 0.009757 seconds to execute Jan 22 23:06:23 sogod [16188]: 000.000.000.000 "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.013 - - 256K - 11 Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync' 2024-01-22 23:06:23.122 sogod[16188:16188] SQL: SELECT * FROM sogo_users_familyhome WHERE (c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net'); 2024-01-22 23:06:23.123 sogod[16188:16188]query has results, entering fetch-mode. 2024-01-22 23:06:23.123 sogod[16188:16188] SQL: SELECT * FROM sogo_users_dmfamilyhome WHERE (c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net'); 2024-01-22 23:06:23.124 sogod[16188:16188]query has results, entering fetch-mode. Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error occurred when caching value for key 'em...@domain.net+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY" Jan 22 23:06:23 sogod [16188]: |SOGo| request took 0.004947 seconds to execute Jan 22 23:06:23 sogod [16188]: 000.000.000.000 "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.007 - - 0 - 11 Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'POST' on uri '/SOGo/Microsoft-Server-ActiveSync?Cmd=FolderSync=em...@domain.net ceId=641E1A9E3AD644BC89A235F3906A60F5=WindowsOutlook15' 2024-01-22 23:06:23.141 sogod[16188:16188] SQL: SELECT * FROM sogo_users_domaine WHERE (c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net'); 2024-01-22 23:06:23.143 sogod[16188:16188]query has results, entering fetch-mode. Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error occurred when caching value for key 'em...@domain.net+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY" 2024-01-22 23:06:23.145 sogod[16188:16188] SQL: SELECT count(*) FROM sogo_cache_folder_email_A_domain_D_net; 2024-01-22 23:06:23.146 sogod[16188:16188]query has results, entering fetch-mode. Jan 22 23:06:23 sogod [16188]: <0x0x5609aef83ac0[SOGoActiveSyncDispatcher]> EAS - request for device 641E1A9E3AD644BC89A235F3906A60F5: http://www.microsoft.com/> 0 I have scrubbed any IP Addresses / Email Addresses from Log Extract Robert Himics <mailto:r...@himicsfamily.com> r...@himicsfamily.com From: "Robert Himics" Sent: Monday, January 22, 2024 10:39 PM To: users@sogo.nu Subject: RE: ActiveSync Question Question: Trying to Configure ActiveSync to connect Through Microsoft Office 365. I don't see any outright Errors in the Log I Can Connect to the SOGo ActiveSync But I am Not getting any Emails Listed from the inbox. I know there are Email Present can Log into the web UI to see emails. I have tried on Multiple PCs Running Microsoft Office 365. Using the nightly build - sogo-activesync-5.9.1.20231220-1.el9.x86_64.rpm Robert Himics <mailto:r...@himicsfamily.com> r...@himicsfamily.com
RE: [SOGo] ActiveSync Question
Question: Trying to Configure ActiveSync to connect Through Microsoft Office 365. I don't see any outright Errors in the Log I Can Connect to the SOGo ActiveSync But I am Not getting any Emails Listed from the inbox. I know there are Email Present can Log into the web UI to see emails. I have tried on Multiple PCs Running Microsoft Office 365. Using the nightly build - sogo-activesync-5.9.1.20231220-1.el9.x86_64.rpm Robert Himics <mailto:r...@himicsfamily.com> r...@himicsfamily.com
RE: [SOGo] Questions Regarding SOGo / before Compliling
Also is there a specific directory SOGo compile process is looking for the libs and headers. When I add the libs and headers the configuration step can't find the libs / headers.Robert Himicsr...@himicsfamily.comOn Dec 11, 2023 3:43 AM, qhivert wrote:Hello,1 – When compiling SOGo / SOPE , Is this a 32bit or 64 Bit Application?It’s for 64 bit2 – Can both (SOGo / SOPE ) be compiled / Run on Fedora 37 ?I can’t say yes for sure as I never dit it but I don’t see why it couldn’t be. Usually the only problems is to find and install the correct package for this OS. 3 - When I first tried to Compile on Fedore 37, It could NOT File the Libraries for MariaDB/mySQL XML2 and possible Others I installed the GNUStep that’s part of the Fedora 37 Yum Repo What is the gnutsep version ? It should be 1.28 for sogo to work. For the others RHEL OS we support, we provide our own package for gnustep. You may try to download them, look at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_software_downloads 4 – and Since the dovecot I’ve setup Uses MariaDB as it’s backend (How do I disable the Need for PostgreSQL and LDAPIn that case sogo parameter SOGoUserSources should be link to the table use by dovecot for the users. https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQLYou may need to make hook/trigger to synchronize your different user table.Quentin From: users-requ...@sogo.nu On Behalf Of "Robert Himics"Sent: samedi 9 décembre 2023 04:18To: users@sogo.nuSubject: RE: [SOGo] Questions Regarding SOGo / before Compliling Hello – Have a Few Questions Regarding SOGo and SOPE1 – When compiling SOGo / SOPE , Is this a 32bit or 64 Bit Application?2 – Can both (SOGo / SOPE ) be compiled / Run on Fedora 37 ?3 - When I first tried to Compile on Fedore 37, It could NOT File the Libraries for MariaDB/mySQL XML2 and possible Others I installed the GNUStep that’s part of the Fedora 37 Yum Repo 4 – and Since the dovecot I’ve setup Uses MariaDB as it’s backend (How do I disable the Need for PostgreSQL and LDAP Rob Himicsr...@himicsfamily.com
RE: [SOGo] Questions Regarding SOGo / before Compliling
Fedora 37 has gnuStep 1.28.0 and ytnef 2.1.2.And your repository require a. ID and password to pull down rpmsFyi Fedora 37 is newer than the base of RH 9. (Fedora 32 equivalent) Robert Himicsrob@himicsfamily.comOn Dec 11, 2023 3:43 AM, qhivert wrote:Hello, 1 When compiling SOGo / SOPE , Is this a 32bit or 64 Bit Application? Its for 64 bit 2 Can both (SOGo / SOPE ) be compiled / Run on Fedora 37 ? I cant say yes for sure as I never dit it but I dont see why it couldnt be. Usually the only problems is to find and install the correct package for this OS. 3 - When I first tried to Compile on Fedore 37, It could NOT File the Libraries for MariaDB/mySQL XML2 and possible Others I installed the GNUStep thats part of the Fedora 37 Yum Repo What is the gnutsep version ? It should be 1.28 for sogo to work. For the others RHEL OS we support, we provide our own package for gnustep. You may try to download them, look at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_software_download s 4 and Since the dovecot Ive setup Uses MariaDB as its backend (How do I disable the Need for PostgreSQL and LDAP In that case sogo parameter SOGoUserSources should be link to the table use by dovecot for the users. https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-usi ng-SQL You may need to make hook/trigger to synchronize your different user table. Quentin From: users-requ...@sogo.nu On Behalf Of "Robert Himics" Sent: samedi 9 décembre 2023 04:18 To: users@sogo.nu Subject: RE: [SOGo] Questions Regarding SOGo / before Compliling Hello Have a Few Questions Regarding SOGo and SOPE 1 When compiling SOGo / SOPE , Is this a 32bit or 64 Bit Application? 2 Can both (SOGo / SOPE ) be compiled / Run on Fedora 37 ? 3 - When I first tried to Compile on Fedore 37, It could NOT File the Libraries for MariaDB/mySQL XML2 and possible Others I installed the GNUStep thats part of the Fedora 37 Yum Repo 4 and Since the dovecot Ive setup Uses MariaDB as its backend (How do I disable the Need for PostgreSQL and LDAP Rob Himics r...@himicsfamily.com <mailto:r...@himicsfamily.com>
RE: [SOGo] Questions Regarding SOGo / before Compliling
Hello - Have a Few Questions Regarding SOGo and SOPE 1 - When compiling SOGo / SOPE , Is this a 32bit or 64 Bit Application? 2 - Can both (SOGo / SOPE ) be compiled / Run on Fedora 37 ? 3 - When I first tried to Compile on Fedore 37, It could NOT File the Libraries for MariaDB/mySQL XML2 and possible Others I installed the GNUStep that's part of the Fedora 37 Yum Repo 4 - and Since the dovecot I've setup Uses MariaDB as it's backend (How do I disable the Need for PostgreSQL and LDAP Rob Himics r...@himicsfamily.com
