Re: [SOGo] EAS not synching any mail items for one account

2022-09-01 Thread Sam Durbin

Thank you Christian

I tried that:

xxx@mail:~$ sudo /usr/sbin/sogo-tool manage-eas listdevices 
linc...@whiteintl.net
<0x0x558302c2ce20[SOGoCache]> Cache cleanup interval set every 
300.00 seconds

<0x0x558302c2ce20[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
3cbc5b84bf9b4393aeb16e8be8040010
760c15c05bc349b7b3425853085438ee

xxx@mail:~$ sudo /usr/sbin/sogo-tool manage-eas resetdevice 
linc...@whiteintl.net 3cbc5b84bf9b4393aeb16e8be8040010
<0x0x564712dfc7b0[SOGoCache]> Cache cleanup interval set every 
300.00 seconds

<0x0x564712dfc7b0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)

xxx@mail:~$ sudo /usr/sbin/sogo-tool manage-eas resetdevice 
linc...@whiteintl.net 760c15c05bc349b7b3425853085438ee
<0x0x55d5e92787b0[SOGoCache]> Cache cleanup interval set every 
300.00 seconds

<0x0x55d5e92787b0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)

xxx@mail:~$ sudo /usr/sbin/sogo-tool manage-eas listdevices 
linc...@whiteintl.net
<0x0x5600e8e9ce20[SOGoCache]> Cache cleanup interval set every 
300.00 seconds

<0x0x5600e8e9ce20[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
3cbc5b84bf9b4393aeb16e8be8040010
760c15c05bc349b7b3425853085438ee


I can't see any issues here but im not sure whaat the expected output 
is?


The user shut their outlook pc app and removed their account from their 
android device (where the issue is), but still having the same problem 
-- the inbox has no items, but the subfolders under the inbox and other 
folders like sent items are synching without issue.


Any thoughts on what's next?

Thank you!

sam


On 2022-09-01 04:17, Christian Mack wrote:


Hello

As ActiveSync broke for that user, you should reset it on the SOGo side
for that user.
Check for syntax with:
/usr/sbin/sogo-tool manage-eas

When doing so, the MS Outlook client has to be shut down.
Then use "listdevices" and "resetdevice".
Afterwards start MS Outlook again.

Kind regards,
Christian Mack

Am 31.08.22 um 10:14 schrieb Sam Durbin (s...@staccum.co.nz):


Hi there,

I am running iredmail  with sogo version 5.7.1 (@sogo-build.alinto.int
202208300100) on ubuntu 18.04.6. The box hosts a few different domains
and users, but im having an issue with one user in particular.

When I add to outlook via EAS it doesnt download any email items when
running the Outlook app - it will synch the folders (for example a few
folders under the inbox folder) but nothing else.

I did a search on the iredmail forums and the internet and one of the
solutions seemed to be increasing the SOGoMaximumSyncResponseSize so I
put that to 10240, and SOGoMaximumSyncWindowSize which I set to 256.

This made no difference.

I have tried it on two different devices - a Samsung device which is 
the
main user of the account, and on my own iPhone. Same result with 
outlook

on both.

No other users seem to be affected, I've got my own mail running on 
the

box and I tried it out as a test and it worked fine.

User's mailbox is only about 200mb large too.

I've worked with Zhang at iredmail directly who has wasnt sure so
suggested contacting the developers via this email list to progress
troubleshooting.

I would appreciate any assistance you're able to provide.

Thank you

Sam


Re: [SOGo] Set Animation Level and other things on sogo.conf -file

2022-09-01 Thread Odhiambo Washington
On Thu, Sep 1, 2022 at 3:22 PM francis  wrote:

> Hi
>
> > On Sep 1, 2022, at 04:46, Christian Mack (christian.m...@uni-konstanz.de)
>  wrote:
> >
> > Hello
> >
> > Am 01.09.22 um 10:31 schrieb Odhiambo Washington (odhia...@gmail.com):
> >> On Wed, Aug 31, 2022 at 7:46 PM Christian Mack  wrote:
> >>> Hello
> >>>
> >>> Am 31.08.22 um 14:06 schrieb International Security Providers
> >>> (internationalsecurityprovid...@proton.me):
>  I would love to set the "Animation level globally for all users to
>  “None”. is this somehow possible?
> >>>
> >>> Sure you can :-)
> >>>
> >>> /etc/sogo/sogo.conf:
> >>> [...]
> >>> SOGoAnimationMode = none;
> >>> [...]
> >>>
>  also enabling “Enable Desktop
>  Notifications” and “When sending mail, add unknown recipients to my”
>  -> “Personal Address Book”
> >>>
> >>> [...]
> >>> SOGoDesktopNotifications = <*I1>;
> >>> [...]
> >>> SOGoMailAddOutgoingAddresses = <*I1>;
> >>> SOGoSelectedAddressBook = "personal";
> >>> [cut]
> >>>
> >>>
> >> Looking at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html,
> I did
> >> not find these SOGoAnimationMode and SOGoDesktopNotifications.
> >> Is there other documentation elsewhere? :)
> >
> > No, there is no other documentation.
> > I got the settings from an user backup.
> > All "User Preferences" can be preset in sogo.conf.
> > They will be fetched and used when creating a new account in SOGo, when
> the user first logs in.
> >
> > But you are right, they should be documented in the "SOGo Installation
> and Configuration Guide".
> > Will open a bug report for it later.
>
> You can also refer to SOGoDefaults.plist for some of the default values
> that you can overwrite in sogo.conf:
>
>
> https://github.com/Alinto/sogo/blob/master/SoObjects/SOGo/SOGoDefaults.plist
>
>
> Francis


Looking at that does not tell me what other options exist for a config
param.
For example, SOGoAnimationMode = "normal";
What are the other options for this parameter? Complete documentation is
necessary.

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)


Re: [SOGo] Set Animation Level and other things on sogo.conf -file

2022-09-01 Thread francis
Hi

> On Sep 1, 2022, at 04:46, Christian Mack (christian.m...@uni-konstanz.de) 
>  wrote:
> 
> Hello
> 
> Am 01.09.22 um 10:31 schrieb Odhiambo Washington (odhia...@gmail.com):
>> On Wed, Aug 31, 2022 at 7:46 PM Christian Mack  wrote:
>>> Hello
>>> 
>>> Am 31.08.22 um 14:06 schrieb International Security Providers
>>> (internationalsecurityprovid...@proton.me):
 I would love to set the "Animation level globally for all users to
 “None”. is this somehow possible?
>>> 
>>> Sure you can :-)
>>> 
>>> /etc/sogo/sogo.conf:
>>> [...]
>>> SOGoAnimationMode = none;
>>> [...]
>>> 
 also enabling “Enable Desktop
 Notifications” and “When sending mail, add unknown recipients to my”
 -> “Personal Address Book”
>>> 
>>> [...]
>>> SOGoDesktopNotifications = <*I1>;
>>> [...]
>>> SOGoMailAddOutgoingAddresses = <*I1>;
>>> SOGoSelectedAddressBook = "personal";
>>> [cut]
>>> 
>>> 
>> Looking at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html, I did
>> not find these SOGoAnimationMode and SOGoDesktopNotifications.
>> Is there other documentation elsewhere? :)
> 
> No, there is no other documentation.
> I got the settings from an user backup.
> All "User Preferences" can be preset in sogo.conf.
> They will be fetched and used when creating a new account in SOGo, when the 
> user first logs in.
> 
> But you are right, they should be documented in the "SOGo Installation and 
> Configuration Guide".
> Will open a bug report for it later.

You can also refer to SOGoDefaults.plist for some of the default values that 
you can overwrite in sogo.conf:

  https://github.com/Alinto/sogo/blob/master/SoObjects/SOGo/SOGoDefaults.plist


Francis

Re: [SOGo] Wrong table name

2022-09-01 Thread Paul van der Vlis

Hello Christian and others,

Thanks for your responce!

Op 31-08-2022 om 18:30 schreef Christian Mack 
(christian.m...@uni-konstanz.de):

Hello


Am 31.08.22 um 13:39 schrieb Paul van der Vlis (p...@vandervlis.nl):

Hello Christian, hello group,

Op 31-08-2022 om 11:28 schreef Christian Mack
(christian.m...@uni-konstanz.de):

Hello

  From which version did you upgrade?
Perhaps you have to run:
/usr/share/doc/sogo/sql-update-3.2.10_to_4.0.0-mysql.sh


I did run that script so far I know, and I see it in my bash_history,
but it is possible something went wrong with it.

Would it be a problem to run it twice?

Does the script rename the name of excisting tables?



It will change some tables, but not rename them.
You can safely run it as often as you like, it will change nothing after
the first run.


This is a very small server, I think there is only one active user left 
at the moment. He had problems on his phone, but after reinstalling 
DAVx⁵ that problem seems to be gone. But I still saw errors in the log.


I did run the script again. I saw some errors:
-
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1146 (42S02) at line 1: Table 'sogo.sogojk0013c1348af_quick' 
doesn't exist
ERROR 1146 (42S02) at line 1: Table 'sogo.sogojk0013c1348af_quick' 
doesn't exist

-

After this, I see some errors about that table in the logs, it seems to 
be the only table what gives errors:

---
Sep 01 10:39:53 sogod [2336490]: <0x0x55f7d4deeb60[GCSFolder]> 
ERROR(-[GCSFolder 
writeContent:fromComponent:container:toName:baseVersion:]): cannot 
insert content :  NAME:ExecutionFailed 
REASON:Table 'sogo.sogojk0013c1348af_quick' doesn't exist

---

What could point at that table-name?
There is also no "sogojk0013c1348af" or "sogojk0013c1348af_acl" table.


Sorry, I misread your error message.
You don't have that table altogether, instead of "just" missing a column.
I never had that myself.


With regards,
Paul van der Vlis


--
Paul van der Vlis Linux systeembeheer Groningen
https://vandervlis.nl/


Re: [SOGo] Set Animation Level and other things on sogo.conf -file

2022-09-01 Thread Christian Mack

Hello

Am 01.09.22 um 10:31 schrieb Odhiambo Washington (odhia...@gmail.com):

On Wed, Aug 31, 2022 at 7:46 PM Christian Mack  wrote:


Hello

Am 31.08.22 um 14:06 schrieb International Security Providers
(internationalsecurityprovid...@proton.me):

I would love to set the "Animation level globally for all users to
“None”. is this somehow possible?


Sure you can :-)

/etc/sogo/sogo.conf:
[...]
 SOGoAnimationMode = none;
[...]


also enabling “Enable Desktop
Notifications” and “When sending mail, add unknown recipients to my”
-> “Personal Address Book”


[...]
 SOGoDesktopNotifications = <*I1>;
[...]
 SOGoMailAddOutgoingAddresses = <*I1>;
 SOGoSelectedAddressBook = "personal";
[cut]



Looking at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html, I did
not find these SOGoAnimationMode and SOGoDesktopNotifications.
Is there other documentation elsewhere? :)



No, there is no other documentation.
I got the settings from an user backup.
All "User Preferences" can be preset in sogo.conf.
They will be fetched and used when creating a new account in SOGo, when 
the user first logs in.


But you are right, they should be documented in the "SOGo Installation 
and Configuration Guide".

Will open a bug report for it later.


Kind regards,
Christian Mack

--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung, Lehre, Infrastruktur
78457 Konstanz
+49 7531 88-4416


smime.p7s
Description: S/MIME Cryptographic Signature


Re: [SOGo] Set Animation Level and other things on sogo.conf -file

2022-09-01 Thread Odhiambo Washington
On Wed, Aug 31, 2022 at 7:46 PM Christian Mack  wrote:

> Hello
>
> Am 31.08.22 um 14:06 schrieb International Security Providers
> (internationalsecurityprovid...@proton.me):
> > I would love to set the "Animation level globally for all users to
> > “None”. is this somehow possible?
>
> Sure you can :-)
>
> /etc/sogo/sogo.conf:
> [...]
> SOGoAnimationMode = none;
> [...]
>
> > also enabling “Enable Desktop
> > Notifications” and “When sending mail, add unknown recipients to my”
> > -> “Personal Address Book”
>
> [...]
> SOGoDesktopNotifications = <*I1>;
> [...]
> SOGoMailAddOutgoingAddresses = <*I1>;
> SOGoSelectedAddressBook = "personal";
> [cut]
>
>
> Kind regards,
> Christian Mack
>
>
Looking at https://www.sogo.nu/files/docs/SOGoInstallationGuide.html, I did
not find these SOGoAnimationMode and SOGoDesktopNotifications.
Is there other documentation elsewhere? :)


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)