And Here is another Block with errors
2024-01-22 23:06:25.279 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60e0000a739561d';
2024-01-22 23:06:25.280 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> query has results, entering fetch-mode.
2024-01-22 23:06:25.281 sogod[16188:16188] <MySQL4Channel[0x0x5609af710130]
connection=0x0x5609af811a60> 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+folder879a9b26eb22ac65c60e0000a739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'HAAAAAJkaXNwbGF5TmFtZQAGAAAASU5CT1gAAA==');
2024-01-22 23:06:25.281 sogod[16188:16188] <MySQL4Channel[0x0x5609af710130]
connection=0x0x5609af811a60> ERROR: Field 'c_uid' doesn't have a default
value
Jan 22 23:06:25 sogod [16188]: [ERROR]
<0x5609af8ed9b0[SOGoCacheGCSObject]:641E1A9E3AD644BC89A235F3906A60F5+folder8
79a9b26eb22ac65c60e0000a739561d> could not insert/update record for record
'/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60e0000a739561d'
in sogo_cache_folder: <MySQL4Exception: 0x5609af74d260> NAME:ExecutionFailed
REASON:Field 'c_uid' doesn't have a default value
2024-01-22 23:06:25.283 sogod[16188:16188] <MySQL4Channel[0x0x5609af710130]
connection=0x0x5609af811a60> SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b4160000a739561d';
2024-01-22 23:06:25.283 sogod[16188:16188] <MySQL4Channel[0x0x5609af710130]
connection=0x0x5609af811a60> query has results, entering fetch-mode.
2024-01-22 23:06:25.284 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> 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+folder765ed91e067dac65b4160000a739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'HQAAAAJkaXNwbGF5TmFtZQAHAAAARHJhZnRzAAA=');
2024-01-22 23:06:25.285 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> ERROR: Field 'c_uid' doesn't have a default
value
Jan 22 23:06:25 sogod [16188]: [ERROR]
<0x5609af748410[SOGoCacheGCSObject]:641E1A9E3AD644BC89A235F3906A60F5+folder7
65ed91e067dac65b4160000a739561d> could not insert/update record for record
'/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b4160000a739561d'
in sogo_cache_folder: <MySQL4Exception: 0x5609af771570> NAME:ExecutionFailed
REASON:Field 'c_uid' doesn't have a default value
2024-01-22 23:06:25.286 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder5871c02a067dac65b4160000a739561d';
2024-01-22 23:06:25.287 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> query has results, entering fetch-mode.
2024-01-22 23:06:25.287 sogod[16188:16188] <MySQL4Channel[0x0x5609af710130]
connection=0x0x5609af811a60> 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+folder5871c02a067dac65b4160000a739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'GwAAAAJkaXNwbGF5TmFtZQAFAAAAU2VudAAA');
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:[email protected]> [email protected]
From: "Robert Himics"
<[email protected]>
Sent: Monday, January 22, 2024 11:26 PM
To: [email protected]
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]: <MySQL4Channel[0x0x5609aef525d0]
connection=0x0x5609af26d2e0> close channel count[2]
2024-01-22 23:04:28.722 sogod[16190:16190] ---------- -[MySQL4Channel
primaryCloseChannel]: <MySQL4Channel[0x0x5609aef310d0]
connection=0x0x5609af2cc1b0> close channel count[1]
2024-01-22 23:04:28.734 sogod[16189:16189] ---------- -[MySQL4Channel
primaryCloseChannel]: <MySQL4Channel[0x0x5609af523ef0]
connection=0x0x5609af55f7f0> close channel count[2]
2024-01-22 23:04:28.739 sogod[16188:16188] ---------- -[MySQL4Channel
primaryCloseChannel]: <MySQL4Channel[0x0x5609af1aaf80]
connection=0x0x5609aef691c0> 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]: <MySQL4Channel[0x0x5609af7ff600] connection=0x0x5609af69d250>
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] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> SQL: SELECT * FROM sogo_users_domain WHERE
(c_uid = '[email protected]') OR (mail = '[email protected]');
2024-01-22 23:06:23.011 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> query has results, entering fetch-mode.
Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
occurred when caching value for key '[email protected]+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] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> SQL: SELECT * FROM sogo_users_familyhome WHERE
(c_uid = '[email protected]') OR (mail = '[email protected]');
2024-01-22 23:06:23.123 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> query has results, entering fetch-mode.
2024-01-22 23:06:23.123 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> SQL: SELECT * FROM sogo_users_dmfamilyhome
WHERE (c_uid = '[email protected]') OR (mail = '[email protected]');
2024-01-22 23:06:23.124 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> query has results, entering fetch-mode.
Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
occurred when caching value for key '[email protected]+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&[email protected]&Devi
ceId=641E1A9E3AD644BC89A235F3906A60F5&DeviceType=WindowsOutlook15'
2024-01-22 23:06:23.141 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> SQL: SELECT * FROM sogo_users_domaine WHERE
(c_uid = '[email protected]') OR (mail = '[email protected]');
2024-01-22 23:06:23.143 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> query has results, entering fetch-mode.
Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
occurred when caching value for key '[email protected]+attributes': "SERVER
HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
2024-01-22 23:06:23.145 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> SQL: SELECT count(*) FROM
sogo_cache_folder_email_A_domain_D_net;
2024-01-22 23:06:23.146 sogod[16188:16188] <MySQL4Channel[0x0x5609af7ff600]
connection=0x0x5609af69d250> query has results, entering fetch-mode.
Jan 22 23:06:23 sogod [16188]: <0x0x5609aef83ac0[SOGoActiveSyncDispatcher]>
EAS - request for device 641E1A9E3AD644BC89A235F3906A60F5: <?xml
version="1.0"?>
<!DOCTYPE ActiveSync PUBLIC "-//MICROSOFT//DTD ActiveSync//EN"
http://www.microsoft.com/>
<FolderSync xmlns="FolderHierarchy:">
<SyncKey>0</SyncKey>
</FolderSync>
I have scrubbed any IP Addresses / Email Addresses from Log Extract
Robert Himics
<mailto:[email protected]> [email protected]
From: "Robert Himics"
<[email protected]>
Sent: Monday, January 22, 2024 10:39 PM
To: [email protected] <mailto:[email protected]>
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:[email protected]> [email protected]
