RE: [SOGo] ActiveSync Question ** Update **

2024-01-23 Thread "Robert Himics" 
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 
  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]: <0x0x5609af0cf610[SOGoCache]> an error
o

RE: [SOGo] ActiveSync Question ** Update **

2024-01-23 Thread "Robert Himics" 
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&User=em...@domain.net&Devi
ceId=641E1A9E3AD644BC89A235F3906A60F5&DeviceType=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 
  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 
  r...@himicsfamily.com