Re: [SOGo] outlook 2016 / EAS / debug mode sync issues

[mj]

Hi Thomas,

The posted samples were actually from sogo.conf :-)

I just pasted the much smaller replies in between these requests.

See:
https://pad.ceph.com/p/response1
https://pad.ceph.com/p/response2
https://pad.ceph.com/p/response3
https://pad.ceph.com/p/response4

There has not been a larger reply during the whole sync day than the 
samples above.


Do these reveil anything interesting..?

MJ

Op 10/6/20 om 11:46 PM schreef Thomas Führer (t...@aon.at):
Hi, the samples you provided don't really help, they just contain what 
is requested by OL. You have to check what is logged in sogo.log 
 when such requests are processed.


Regards, Thomas



 mj schrieb 



Op 10/6/20 om 8:59 PM schreef mj (li...@merit.unu.edu):
 > I am currently reading this
 > 
(https://techcommunity.microsoft.com/t5/exchange-team-blog/under-the-hood-exchange-activesync-mailbox-log-analysis/ba-p/591224) 


 > to hopefully better understand what I am looking at.

On that page, it says:

"Typically you will see items being added to the device in the Sync
response. You can see detailed information including the sender and
subject if verbose logging has been enabled on the CAS servers."

It seems that compared to microsoft, SOGo's SOGoEASDebugEnabled mode is
very verbose, but still not verbose enough.

It would make our lives so much easier, of SOGo would also log things
like sender and subject...

MJ
--
users@sogo.nu
https://inverse.ca/sogo/lists
--
users@sogo.nu
https://inverse.ca/sogo/lists

--
users@sogo.nu
https://inverse.ca/sogo/lists

AW: [SOGo] outlook 2016 / EAS / debug mode sync issues

[t...@aon.at]

Hi, the samples you provided don't really help, they just contain what is requested by OL. You have to check what is logged in sogo.log when such requests are processed.
Regards, Thomas 
 mj schrieb Op 10/6/20 om 8:59 PM schreef mj (li...@merit.unu.edu):> I am currently reading this > (https://techcommunity.microsoft.com/t5/exchange-team-blog/under-the-hood-exchange-activesync-mailbox-log-analysis/ba-p/591224) > to hopefully better understand what I am looking at.On that page, it says:"Typically you will see items being added to the device in the Sync response. You can see detailed information including the sender and subject if verbose logging has been enabled on the CAS servers."It seems that compared to microsoft, SOGo's SOGoEASDebugEnabled mode is very verbose, but still not verbose enough.It would make our lives so much easier, of SOGo would also log things like sender and subject...MJ-- users@sogo.nuhttps://inverse.ca/sogo/lists
-- users@sogo.nuhttps://inverse.ca/sogo/lists

Re: [SOGo] outlook 2016 / EAS / debug mode sync issues

[mj]

Op 10/6/20 om 8:59 PM schreef mj (li...@merit.unu.edu):
I am currently reading this 
(https://techcommunity.microsoft.com/t5/exchange-team-blog/under-the-hood-exchange-activesync-mailbox-log-analysis/ba-p/591224) 
to hopefully better understand what I am looking at.


On that page, it says:

"Typically you will see items being added to the device in the Sync 
response. You can see detailed information including the sender and 
subject if verbose logging has been enabled on the CAS servers."


It seems that compared to microsoft, SOGo's SOGoEASDebugEnabled mode is 
very verbose, but still not verbose enough.


It would make our lives so much easier, of SOGo would also log things 
like sender and subject...


MJ
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] outlook 2016 / EAS / debug mode sync issues

[mj]

Hi Thomas,

Thanks for taking the time to respond!

I was running with SOGoEASDebugEnabled = YES, and now I uploaded three 
EAS samples here:


https://pad.ceph.com/p/sample1
https://pad.ceph.com/p/sample2
https://pad.ceph.com/p/sample3

Listfolders for this particular user is this:


sogo-tool manage-eas listfolders username AB2CD7F43DD84143A658BC0D19857D0A

listfolders for AB2CD7F43DD84143A658BC0D19857D0A

Folder Key: 
AB2CD7F43DD84143A658BC0D19857D0A+folder422e6327b3c558517874e2e67d9a
   Folder Name: INBOX

Folder Key: 
AB2CD7F43DD84143A658BC0D19857D0A+folder4e2e6327b3c558517874e2e67d9a
   Folder Name: Sent Items

Folder Key: 
AB2CD7F43DD84143A658BC0D19857D0A+folder502e6327b3c558517874e2e67d9a
   Folder Name: Deleted Items


But the logs remain cryptic to me. Outlook could so easily report WHAT 
email/calendar item it is currently requesting, and so could SOGo.


The above logs are with SOGoMaximumSyncWindowSize = 1

Grepping (-i) the SOGoEASDebugEnabled logs for "warn" or "error" gives 
no (relevant) results.


Our inverse support contract has expired (we are currently renewing it, 
but with without support until somewhere next week) so any help here is 
very much appreciated. :-)


I am currently reading this 
(https://techcommunity.microsoft.com/t5/exchange-team-blog/under-the-hood-exchange-activesync-mailbox-log-analysis/ba-p/591224) 
to hopefully better understand what I am looking at.


All the best,
MJ

Op 10/5/20 om 6:53 PM schreef Thomas Führer (t...@aon.at):

Hi, are there any errors in sogo.log?

Running sogo with
SOGoEASDebugEnabled = YES
can give more details in sogo.log

Regarding collectionid check:
sogo-tool -v manage-eas listdevices 
sogo-tool -v manage-eas listfolders  

Regards, Thomas



 mj schrieb 

Hi,

We're having an issue where outlook 2016 in EAS mode doesn't seem to
sync to SOGo anymore, and usually shows "Waiting for server response -
Connected" and occasionally says "All folders are up to date" - but all
folders are NOT up to date.

Outlook in debug mode creates endless copies of virtually identical two
kinds of files in %temp%\EASLogFiles:

* eas{2020-10-05-11-21-59-825}_2761.xml (48KB)
* eas{2020-10-05-11-21-59-825}_2760.info.xml (1KB)

The .info.xml files (1500 of them by now) are all identical:
 >
 > 
 > 0
 > MoreAvailable
 > outlook\pstprx\storeas\eascontentdownloader.cpp
 > 128
 > 

and the .xml files (48KB) differ only in three specific lines:

new transaction ID:
 > X-TransactionID: {3271F3C5-27C8-403C-9AE7-04D8A49588F7}

The first half of the SyncKey: (127916-296532 vs 127901-296532)
 > 127901-296532

And the ServerId seems to increment +1 for each next file:
 > 48430

It looks as if the process is stuck on a particular item, and is trying
again and again. (and failing..?)

So, is there a way to find out WHAT item is causing this issue?

Is there a way to translate things like  into actual
plain text items?

The outlook "Sync Issues" folder is empty.

Clues, anyone?

MJ
--
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] mass-edit sogo_folder_info for database connection details

[mj]

Hi,

I think what happened with us:

In sogo.conf we used to have mysql creds userorig/passorig, with 
matching user in mysql: 'userorig'@'localhost'


A year ago, we added a user in mysql: 'usernew'@'*' with rights granted 
on the sogo database, and changed sogo.conf to use that new user, but 
did NOT remove the old user.


Everything continued to work fine.

Recently we decided to remove that original 'userorig'@'localhost' from 
mysql, and then suddenly problems arose. Checking the database contents, 
we noticed that recently added users had the 'newusernew'@'* connection 
details in their sogo_folder_info, but older users were still using the 
(now deleted) 'userorig'@'localhost'


I cannot explain why it seemed to work for you, and did not work for us.

MJ

Op 10/6/20 om 8:23 AM schreef c...@brain-biotech.de:

Hello all,
as I have recently changed the DB Password without knowing that it needs 
to be changed in the DB as well I ask myself what is the impact of the 
wrong password there? I had no reports that something is not working. I 
am a bit confused.


Regards

Christian


On 05.10.20 17:59, Francis Lachapelle (flachape...@inverse.ca) wrote:

Hi mj

On Oct 2, 2020, at 8:26 AM, mj (li...@merit.unu.edu)  
wrote:


For security reasons (more stringent password requirements) we would 
like to change the sogo database connection credentials.


However, to do that, we don't only need edit sogo.conf, but also the 
saved credentials in the database, per user in the sogo_folder_info.


Is there a supported nice way (sogo-tool?) to do that for users that 
are already in the database?


We're runing mysql, btw, and SOGo V5.


Exactly, you need to modify three columns of the sogo_folder_info 
table. If you want to change the password, you would do something like 
this:


   update sogo_folder_info set \
 c_location = replace(c_location, 'YOUR_OLD_PASSWORD', 
'YOUR_NEW_PASSWORD'), \
 c_quick_location = replace(c_quick_location, 'YOUR_OLD_PASSWORD', 
'YOUR_NEW_PASSWORD'), \
 c_acl_location = replace(c_acl_location, 'YOUR_OLD_PASSWORD', 
'YOUR_NEW_PASSWORD');



Francis




--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] mass-edit sogo_folder_info for database connection details

[lists]

Hi Francis!

Op 5-10-2020 om 17:59 schreef Francis Lachapelle (flachape...@inverse.ca):

Exactly, you need to modify three columns of the sogo_folder_info table. If you 
want to change the password, you would do something like this:

   update sogo_folder_info set \
 c_location = replace(c_location, 'YOUR_OLD_PASSWORD', 
'YOUR_NEW_PASSWORD'), \
 c_quick_location = replace(c_quick_location, 'YOUR_OLD_PASSWORD', 
'YOUR_NEW_PASSWORD'), \
 c_acl_location = replace(c_acl_location, 'YOUR_OLD_PASSWORD', 
'YOUR_NEW_PASSWORD');


Thank you very much!

Perhaps a small chapter on changing the database password could be added 
to the docs? As it is a bit more involved than you would normally 
expect, with credentials stored in multiple locations...


Again thanks for the update sogo_folder_info command, will try on our 
test server!


MJ
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] mass-edit sogo_folder_info for database connection details

[c...@brain-biotech.de]

Hello all,
as I have recently changed the DB Password without knowing that it needs 
to be changed in the DB as well I ask myself what is the impact of the 
wrong password there? I had no reports that something is not working. I 
am a bit confused.


Regards

Christian


On 05.10.20 17:59, Francis Lachapelle (flachape...@inverse.ca) wrote:

Hi mj


On Oct 2, 2020, at 8:26 AM, mj (li...@merit.unu.edu)  wrote:

For security reasons (more stringent password requirements) we would like to 
change the sogo database connection credentials.

However, to do that, we don't only need edit sogo.conf, but also the saved 
credentials in the database, per user in the sogo_folder_info.

Is there a supported nice way (sogo-tool?) to do that for users that are 
already in the database?

We're runing mysql, btw, and SOGo V5.


Exactly, you need to modify three columns of the sogo_folder_info table. If you 
want to change the password, you would do something like this:

   update sogo_folder_info set \
 c_location = replace(c_location, 'YOUR_OLD_PASSWORD', 
'YOUR_NEW_PASSWORD'), \
 c_quick_location = replace(c_quick_location, 'YOUR_OLD_PASSWORD', 
'YOUR_NEW_PASSWORD'), \
 c_acl_location = replace(c_acl_location, 'YOUR_OLD_PASSWORD', 
'YOUR_NEW_PASSWORD');


Francis



--
Dr. Christian Naumer
Unit Head Bioprocess Development

B.R.A.I.N Aktiengesellschaft
Darmstaedter Str. 34-36, D-64673 Zwingenberg
e-mail c...@brain-biotech.com, homepage www.brain-biotech.com
fon +49-6251-9331-30  /   fax +49-6251-9331-11

Sitz der Gesellschaft: Zwingenberg/Bergstrasse
Registergericht AG Darmstadt, HRB 24758
Vorstand: Adriaan Moelker (Vorstandsvorsitzender), 
Lukas Linnig

Aufsichtsratsvorsitzender: Dr. Georg Kellinghusen
--
users@sogo.nu
https://inverse.ca/sogo/lists