[SOGo] migrating sogo (db) to utf8mb4

[goetz.reini...@filmakademie.de]

Hello all,

What is the most practicable way to migrate an utf8 sogo db environment to 
utf8mb4?

Is adding „MySQL4Encoding = „utf8mb4“ to sogo.conf and running the following on 
the DB server enough? Doing a DB backup dump first. ;)

ALTER DATABASE sogo_DB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE  sogo_DB.* CONVERT TO CHARACTER SET utf8mb4 COLLATE 
utf8mb4_unicode_ci;

Thanks for hints and suggestions . Regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Can't save e-mail signature any more - SOGo 5.8.2 - solved

[goetz.reini...@filmakademie.de]

> Am 08.05.2023 um 11:51 schrieb Götz Reinicke (goetz.reini...@filmakademie.de) 
> :
> 
> Hi,
> 
> I can’t save the e-mail-signature in the web interface. The OK button is 
> greyed out . Did I may be missed a change in the config or settings?
> 

Forgot to enter the required full name. 


/G

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Can't save e-mail signature any more - SOGo 5.8.2

[goetz.reini...@filmakademie.de]

Hi,

I can’t save the e-mail-signature in the web interface. The OK button is greyed 
out . Did I may be missed a change in the config or settings?

Any suggestion? Thanks & regards . Götz

 

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] personal calendar missing in Apple Calendar after SOGOside renaiming

[goetz.reini...@filmakademie.de]

Hi,

One user renamed his personal calender in SOGo, and after that it dose not show 
up in apple calendar (any more).

I removed the account in apple calendar, renamed the calendar in SOGo and 
readded the account in apple calendar, but the personal calendar is still gone.

AFAIK  there was an solution for that, but I can’t find it anymore …

Thanks for hints and suggestions . Best regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Problem with calendar selection after update sogo-5.7.0 => sogo-5.7.1

[goetz.reini...@filmakademie.de]

Thanks a lot !! looks like it works for us!

/Götz

> Am 20.09.2022 um 08:28 schrieb smizrahi@alinto . eu (smizr...@alinto.eu) 
> :
> 
> Hi Götz,
> 
> Apologize for the too late delivery date.
> The following procedure should fix the issue :
> service sogo stop
> mv /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Common.js 
> /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Common.js.bak
> mv /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Common.js.map 
> /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Common.js.map.bak
> mv /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Scheduler.services.js 
> /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Scheduler.services.js.bak
> mv 
> /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Scheduler.services.js.map 
> /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Scheduler.services.js.map.bak
> wget 
> https://raw.githubusercontent.com/Alinto/sogo/master/UI/WebServerResources/js/Common.js
>  
> 
>  -O /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Common.js
> wget 
> https://raw.githubusercontent.com/Alinto/sogo/master/UI/WebServerResources/js/Common.js.map
>  
> 
>  -O /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Common.js.map
> wget 
> https://raw.githubusercontent.com/Alinto/sogo/master/UI/WebServerResources/js/Scheduler.services.js
>  
> 
>  -O /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Scheduler.services.js
> wget 
> https://raw.githubusercontent.com/Alinto/sogo/master/UI/WebServerResources/js/Scheduler.services.js.map
>  
> 
>  -O 
> /usr/local/lib/GNUstep/SOGo/WebServerResources/js/Scheduler.services.js.map
> service sogo start
> 
> When the release will be out, do not forget to delete .bak files.
> You also need to clear your browser cache.
> 
> Sebastien

<…>




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Problem with calendar selection after update sogo-5.7.0 => sogo-5.7.1

[goetz.reini...@filmakademie.de]

Hi Sebastian,

thanks…. so is there a short term workaround for that bug? Currently for us the 
WebUI is unusable in daily business.

Regards . Götz

> Am 19.09.2022 um 08:24 schrieb smizrahi@alinto . eu (smizr...@alinto.eu) 
> :
> 
> Hi Götz,
> 
> We plan to do a new release in October.
> 
> Sebastien
> 
> Le Lundi, Septembre 19, 2022 08:14 CEST, Götz Reinicke 
> (goetz.reini...@filmakademie.de)  a écrit:
>  
>> 
>>  
> Hi any news on a release?
>  
> That bug is a total show stopper for us right now … :(
>  
> Regards . Götz
>  
>> 
>> Am 30.08.2022 um 12:15 schrieb Slávek Banko (slavek.ba...@axis.cz 
>> <mailto:slavek.ba...@axis.cz>) mailto:users@sogo.nu>>:
>>  
>> Hi,
>> 
>> it seem that problem is already reported:
>> https://bugs.sogo.nu/view.php?id=5581 <https://bugs.sogo.nu/view.php?id=5581>
>> 
>> ...and already resolved in master branch:
>> https://github.com/Alinto/sogo/commit/3eeebbc83b
>> 
>> This seems useful to do a backport of commit into a stable release. I will
>> do it in the packages of stable release that I provide in community
>> repository.
>> 
>> Cheers
>> --
>> Slávek
>> 
>> Dne po 29. srpna 2022 Christian Mack napsal(a):
>>> 
>>> Hello
>>> 
>>> Seems to be a new bug.
>>> Please report it at https://bugs.sogo.nu/
>>> 
>>> 
>>> Kind regards,
>>> Christian Mack
>>> 
>>> Am 29.08.22 um 14:17 schrieb Götz Reinicke
>> (goetz.reini...@filmakademie.de):
>>> 
>>>> Hi,
>>>> 
>>>> After the update to SOGo 5.7.1 I can only select my personal Calendar
>>>> for appointments. Even new created calendars can’t be selected.
>>>> 
>>>> Any idea?
>>>> 
>>>> Regards . Götz

  <http://www.filmakademie.de/>   

Götz Reinicke 
IT-Koordination
IT-OfficeNet
+49 7141 969 82420 
goetz.reini...@filmakademie.de <mailto:goetz.reini...@filmakademie.de>
Filmakademie Baden-Württemberg GmbH 
Akademiehof 10
71638 Ludwigsburg 
http://www.filmakademie.de <http://www.filmakademie.de/>
   <https://twitter.com/filmakademiebw>
<https://de-de.facebook.com/filmakademiebw> 
<https://www.youtube.com/user/TheFilmakademie>  
<https://vimeo.com/filmakademiebw> 

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrates:
Petra Olschowski
Staatssekretärin im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg
Geschäftsführer:
Prof. Thomas Schadt

Datenschutzerklärung 
<https://www.filmakademie.de/de/meta/datenschutz/datenschutzerklaerung/> | 
Transparenzinformation 
<https://www.filmakademie.de/de/meta/datenschutz/transparenzinformationen/>
Data privacy statement 
<https://www.filmakademie.de/en/meta/data-privacy/data-privacy-statement/> | 
Transparency information 
<https://www.filmakademie.de/en/meta/data-privacy/transparency-information/>



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Problem with calendar selection after update sogo-5.7.0 => sogo-5.7.1

[goetz.reini...@filmakademie.de]

Hi any news on a release?

That bug is a total show stopper for us right now … :(

Regards . Götz

> Am 30.08.2022 um 12:15 schrieb Slávek Banko (slavek.ba...@axis.cz) 
> :
> 
> Hi,
> 
> it seem that problem is already reported: 
> https://bugs.sogo.nu/view.php?id=5581
> 
> ...and already resolved in master branch:
> https://github.com/Alinto/sogo/commit/3eeebbc83b
> 
> This seems useful to do a backport of commit into a stable release. I will 
> do it in the packages of stable release that I provide in community 
> repository.
> 
> Cheers
> -- 
> Slávek
> 
> Dne po 29. srpna 2022 Christian Mack napsal(a):
>> Hello
>> 
>> Seems to be a new bug.
>> Please report it at https://bugs.sogo.nu/
>> 
>> 
>> Kind regards,
>> Christian Mack
>> 
>> Am 29.08.22 um 14:17 schrieb Götz Reinicke 
> (goetz.reini...@filmakademie.de):
>>> Hi,
>>> 
>>> After the update to SOGo 5.7.1 I can only select my personal Calendar
>>> for appointments. Even new created calendars can’t be selected.
>>> 
>>> Any idea?
>>> 
>>> Regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Problem with calendar selection after update sogo-5.7.0 => sogo-5.7.1

[goetz.reini...@filmakademie.de]

Hi Christian,

https://bugs.sogo.nu/view.php?id=5592 <https://bugs.sogo.nu/view.php?id=5592> 
is opend.

Regards from LB . Götz

> Am 29.08.2022 um 15:14 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) :
> 
> Hello
> 
> Seems to be a new bug.
> Please report it at https://bugs.sogo.nu/
> 
> 
> Kind regards,
> Christian Mack
> 
> Am 29.08.22 um 14:17 schrieb Götz Reinicke (goetz.reini...@filmakademie.de):
>> Hi,
>> After the update to SOGo 5.7.1 I can only select my personal Calendar for 
>> appointments. Even new created calendars can’t be selected.
>> Any idea?
>> Regards . Götz
> 
> 
> -- 
> Christian Mack
> Universität Konstanz
> Kommunikations-, Informations-, Medienzentrum (KIM)
> Abteilung IT-Dienste Forschung, Lehre, Infrastruktur
> 78457 Konstanz
> +49 7531 88-4416

  <http://www.filmakademie.de/>   

Götz Reinicke 
IT-Koordination
IT-OfficeNet
+49 7141 969 82420 
goetz.reini...@filmakademie.de <mailto:goetz.reini...@filmakademie.de>
Filmakademie Baden-Württemberg GmbH 
Akademiehof 10
71638 Ludwigsburg 
http://www.filmakademie.de <http://www.filmakademie.de/>
   <https://twitter.com/filmakademiebw>
<https://de-de.facebook.com/filmakademiebw> 
<https://www.youtube.com/user/TheFilmakademie>  
<https://vimeo.com/filmakademiebw> 

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrates:
Petra Olschowski
Staatssekretärin im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg
Geschäftsführer:
Prof. Thomas Schadt

Datenschutzerklärung 
<https://www.filmakademie.de/de/meta/datenschutz/datenschutzerklaerung/> | 
Transparenzinformation 
<https://www.filmakademie.de/de/meta/datenschutz/transparenzinformationen/>
Data privacy statement 
<https://www.filmakademie.de/en/meta/data-privacy/data-privacy-statement/> | 
Transparency information 
<https://www.filmakademie.de/en/meta/data-privacy/transparency-information/>



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Problem with calendar selection after update sogo-5.7.0 => sogo-5.7.1

[goetz.reini...@filmakademie.de]

Hi,

After the update to SOGo 5.7.1 I can only select my personal Calendar for 
appointments. Even new created calendars can’t be selected.

Any idea?

Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] /usr/sbin/sogo-tool update-autoreply - "removing" enabled autoreplies

[goetz.reini...@filmakademie.de]

Hi,

The output of the sogo-tool shows some „Removed auto-reply of user“ for users 
who still have (and want) the autoreply enabled.

Is that a false log-message?

Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] caldav URl reset wit iOS 15.4.1 - strange bahaviour

[goetz.reini...@filmakademie.de]

Hi,

Recently a coworker and I noticed, that our accountsettings URL within the 
iPhone has changed from https://url/SOGo/dav/UID to just https://url/ - the 
dav-part is gone.

That happened after the upgrade to iOS 15.4.1 I could reenter the full URL and 
since then it is working.

Has anyone else seen such a behaviour or has any idea what might have happen?

Thanks & Regards . Götz 




smime.p7s
Description: S/MIME cryptographic signature

[SOGo] sogo-tool update-autoreply and IMAP4 socket was shut down by server

[goetz.reini...@filmakademie.de]

Hi,

we notice some strange errors when the „ sogo-tool update-autoreply“ sieve is 
executed.

For the same 20 accounts regularly an auto reply is enabled - which shouldn’t 
be. And we get the error:

<0x0x43dc920[NGImap4Client]> ERROR(-[NGImap4Client 
_handleShutdownDuringCommandException:]): IMAP4 socket was shut down by server 
NGSocketShutdownDuringReadException: the socket was shutdown
2022-02-17 00:00:08.528 sogo-tool[24535] ERROR(-[NSException(NGMiscellaneous) 
initWithFormat:]): missing format!
2022-02-17 00:00:08.798 sogo-tool[24535] Enabled auto-reply of user 
blabla_username


Any hints/ideas/suggestion? Thanks & best . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] use https for shared DAV-links - how to ?

[goetz.reini...@filmakademie.de]

Thanks Christian,

Beside our sogo runs on localhost:2, the config is the same: http://127.0.0.1:2/SOGo> ….

Do I have to change that ? Thx for suggestions. /Götz




> Am 31.01.2022 um 07:52 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) :
> 
> Hello
> 
> Check your reverse proxy settings.
> 
> In Apache you need:
> [...]
>  http://your-sogo.server.name:2/SOGo>
>RequestHeader set "x-webobjects-server-port" "443"
>RequestHeader set "x-webobjects-server-name" "%{HTTP_HOST}s"
>RequestHeader set "x-webobjects-server-url" "https://%{HTTP_HOST}s;
>RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
> [...]
> 
> This will tell SOGo to use https and the given/received server for all
> generated URLs.
> 
> 
> 
> Kind regards,
> Christian Mack
> 
> Am 28.01.22 um 18:02 schrieb Götz Reinicke (goetz.reini...@filmakademie.de):
>> Hi,
>> 
>> we noticed, that the URLs for sharing calendars or addressbooks are „still“ 
>> http only without „s“ :)
>> 
>> Is it possible to set this by default? If so, how and where?
>> 
>> Thanks and regards . Götz
>> 
>> 
> 
> 
> -- 
> Christian Mack
> Universität Konstanz
> Kommunikations-, Informations-, Medienzentrum (KIM)
> Abteilung IT-Dienste Forschung und Lehre
> 78457 Konstanz
> +49 7531 88-4416
> 

  <http://www.filmakademie.de/>   

Götz Reinicke 
IT-Koordination
IT-OfficeNet
+49 7141 969 82420 
goetz.reini...@filmakademie.de <mailto:goetz.reini...@filmakademie.de>
Filmakademie Baden-Württemberg GmbH 
Akademiehof 10
71638 Ludwigsburg 
http://www.filmakademie.de <http://www.filmakademie.de/>
   <https://twitter.com/filmakademiebw>
<https://de-de.facebook.com/filmakademiebw> 
<https://www.youtube.com/user/TheFilmakademie>  
<https://vimeo.com/filmakademiebw> 

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrates:
Petra Olschowski
Staatssekretärin im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg
Geschäftsführer:
Prof. Thomas Schadt

Datenschutzerklärung 
<https://www.filmakademie.de/de/meta/datenschutz/datenschutzerklaerung/> | 
Transparenzinformation 
<https://www.filmakademie.de/de/meta/datenschutz/transparenzinformationen/>
Data privacy statement 
<https://www.filmakademie.de/en/meta/data-privacy/data-privacy-statement/> | 
Transparency information 
<https://www.filmakademie.de/en/meta/data-privacy/transparency-information/>



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] use https for shared DAV-links - how to ?

[goetz.reini...@filmakademie.de]

Hi,

we noticed, that the URLs for sharing calendars or addressbooks are „still“ 
http only without „s“ :)

Is it possible to set this by default? If so, how and where?

Thanks and regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Problem activating/using two-factor authentification - solved

[goetz.reini...@filmakademie.de]

there was an old/obsolete file still present from a previous installation …. 
moved, 2fe works.

Thx to SOGo Support!

regards . Götz

> Am 09.03.2021 um 17:57 schrieb Götz Reinicke (goetz.reini...@filmakademie.de) 
> :
> 
> Hi,
> 
> I checked the two-factor auth option for an user and scanned the qrcode on my 
> smartphone.
> 
> When I try to login top SOGo again, I get an error in the server log:
> 
> SOGoRootPage Missing Google Authenticator key for ‚…..' asking it..
> 
> and the user is stuck at a blanke page with a big green bar.
> 
> ITs firefox 86 on Mac and sogo 5.0.1
> 
> May be I did missed to configure something?
> 
> 
>   Thanks for hints and regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Problem activating/using two-factor authentification

[goetz.reini...@filmakademie.de]

Hi,

I checked the two-factor auth option for an user and scanned the qrcode on my 
smartphone.

When I try to login top SOGo again, I get an error in the server log:

SOGoRootPage Missing Google Authenticator key for ‚…..' asking it..

and the user is stuck at a blanke page with a big green bar.

ITs firefox 86 on Mac and sogo 5.0.1

May be I did missed to configure something?


Thanks for hints and regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Some calendars lost the name, but show the ID

[goetz.reini...@filmakademie.de]

Hi Christian,

> Am 05.02.2021 um 16:03 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) :
> 
> Hello
> 
> Am 05.02.21 um 11:19 schrieb Götz Reinicke (goetz.reini...@filmakademie.de):
>> Hi,
>> 
>> we have one central user with about 20+ calendars. Recently some „lost“ 
>> their name like and just show the ID.
>> 
>> Any Idea how that might have happen and how to get the names back? Or do I 
>> have to rename the calendars hand by hand?
>> 
> 
> I had that once, and could never reproduce it.
> I had to restore the settings of that account from sogo-tool backup.
> 
> /usr/sbin/sogo-tool restore -p backup-folder/ ${username}


thanks for the hint; I did a restore with the -p option, but the labels where 
not set. So I restored with -f ALL, which restored the labels as well.

Is that the normal behaviour? 

Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Some calendars lost the name, but show the ID

[goetz.reini...@filmakademie.de]

Hi,

we have one central user with about 20+ calendars. Recently some „lost“ their 
name like and just show the ID.

Any Idea how that might have happen and how to get the names back? Or do I have 
to rename the calendars hand by hand?

Thanks for feedback and suggestions.

/Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Updating SOGo account after changes in AD/LDAP

[goetz.reini...@filmakademie.de]

Hi,

we have had an user with a typo error in his name and e-mail-address which we 
corrected. But in SOGo there is still the wrong mailaddress showing up. The 
name is correct now ….

How may that happen? Any ideas/hints?

regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Sogo is terrible slow / bumpy sometimes - some errors - since upgrade to 5.x

[goetz.reini...@filmakademie.de]

Hi,

since a couple of days, users complain about SOGo Webinterface being very 
„slow“ in loading mailboxes and showing folder contents.

Today I also got a mixet picture, and opening my trash folder by example took 
about +- 25 seconds. There are 3400 mails in it.

In the sogo log I just see something like: "request took 24.152952 seconds to 
execute"


Furthermore I do see a few Microsoft-Server-ActiveSync Connects, which take 
over 40 Seconds.

And from time to time "No child available to handle incoming request messages.“ 
As well "IMAP4 login failed“


But I’d say 95 % of log messages are calendar requests with less than 0.1 
Second.

Currently I don’t see any high load or problems on the map server, but the 
Samba AD backend gets some load. But as there where no changes beside the 5.x 
upgrade I don’t find a clue why the errors started.



Any hints and suggestions are welcome!


Thanks and Regards . Götz





 

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Setting up SOGo e-mail account on iPhone Mail app

[goetz.reini...@filmakademie.de]

Hi,

you don’t configure a SOGo e-mail-address, you configure your mailserver 
account for SMTP and IMAP.

SOGo is „just“ an other e-mail client.

Regards . Götz

> Am 02.11.2020 um 19:23 schrieb Vittorio (vittorio.govah...@student.unamur.be) 
> :
> 
> Hi,
>  
> I was wondering how one could set up a SOGo e-mail adress on the iPhone Mail 
> app. I’ve tried to manage by myself but the specs are too difficult for me to 
> handle. I would appreciate if you could guide me through the process.
>  
> Please find enclosed screenshots of the procedure to follow.
>  
> Many thanks,
>  
> Vittorio
> -- 
> users@sogo.nu 
> https://inverse.ca/sogo/lists 
> <3.jpg><2.jpg><1.jpg>



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

[goetz.reini...@filmakademie.de]

> Am 15.10.2020 um 17:30 schrieb Michael Hekeler (mich...@hekeler.com) 
> :
> 
> On 12.10.20 16:00, Götz Reinicke wrote:
>> (...)
>> I guess you talk about the database dump? As the database server name will
>> change, I can’t use the „old“ dump anymore I think.
> 
> When dumping your database with mysqldump then there is no hostname of
> the database server in the dump because the hostname is set when
> mysqldump establishes the connecion, e.g. `mysqldump -h hostname dbname`
> 
> So you are safe to import this dumpfile on another host.

But in the sogo database there is the for some entries the database URL saved, 
which is set in the sogo.conf.

So dumping the database on host „mysql-server01“ and importing it at 
„new-mysqlserver“ will break all entries!

This would only work, if the database server dose not has an other name. (I 
should have created an DNS alias for it in the past)

Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

[goetz.reini...@filmakademie.de]

Hi,

> Am 12.10.2020 um 13:47 schrieb Odhiambo Washington (odhia...@gmail.com) 
> :
> 
> 
> 
> On Mon, 12 Oct 2020 at 13:39, Götz Reinicke  > wrote:
> Hi,
> 
> what are the right steps to migrate the SOGo database to a new database 
> server (with new server name):
> 
> - dump/backup all user data
> - shutdown sogo
> - add a new database to the new server
> - edit the sogo.conf database serve name/user/password
> 
> It's easier to just reuse the creds from sogo.conf so no need to edit 
> sogo.conf (dbname, username, password):
> MySQL>CREATE USER 'username'@'hostname OR IP' IDENTIFIED WITH 
> mysql_native_password BY 'the_password';
> MYSQL>GRANT ALL ON dbname.* TO  'username'@'hostname OR IP‘;


true@credentials. I’m used to set new ones, so I can be 100% sure I’m 
connecting to the new db.


> 
> - restart sogo
> - restore the user data from the backup
> 
> Did I miss something?
> 
> Yes. move the dump to the new server :-)

I guess you talk about the database dump? As the database server name will 
change, I can’t use the „old“ dump anymore I think.

By dumping the user data I was referring to the pogo-tool backup. May be I was 
a bit confusing, or did misunderstand you.

>  
> 
> Are there known problems with the DB version upgrade?
> 
> I did not encounter any when I migrated from 5.7 to 8.0.

Good to hear. thx.

Regards. . Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

[goetz.reini...@filmakademie.de]

Hi,

what are the right steps to migrate the SOGo database to a new database server 
(with new server name):

- dump/backup all user data
- shutdown sogo
- add a new database to the new server
- edit the sogo.conf database serve name/user/password
- restart sogo
- restore the user data from the backup

Did I miss something?

Are there known problems with the DB version upgrade?


Thanks for hints and suggestions. Regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] SOGO Clalenders

[goetz.reini...@filmakademie.de]

Check the calendar setting on the iPhone; may be the view is just disabled for 
other calendars?

/Götz

> Am 10.08.2020 um 16:59 schrieb William Bowden (will...@jmrit.co.uk) 
> :
> 
> Hi 
> I have a client running the latest SOGO on the web interface they have all 
> their calendars on there client software Apple Calendar they
> See all their calendars but on iPhone just the personal one 
> Any ideas
> Also used Exchange to install it on phone
> 



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] AD Groups and ACL

[goetz.reini...@filmakademie.de]

Hi,

I try to use AD groups for ACLs for calendars and can’t get it to work right 
now. I added a mail attribute and in SOGo I find the group by its name to set 
an ACL.

But the users of the group don't get the calendar subscribed if I check that 
button.

Furthermore, the notification mail for subscribing and adding is send to the 
groups mal address, which is not recognised by our mailserver.

I guess, there are some more requirements than in that FAQ:

https://sogo.nu/support/faq/how-are-groups-handled-in-sogo-.html


Thanks for any help, hints and suggestions . Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] AD Groups and ACL

[goetz.reini...@filmakademie.de]

> Am 26.06.2020 um 15:08 schrieb Götz Reinicke :
> 
> Hi,
> 
> I try to use AD groups for ACLs for calendars and can’t get it to work right 
> now. I added a mail attribute and in SOGo I find the group by its name to set 
> an ACL.
> 
> But the users of the group don't get the calendar subscribed if I check that 
> button.
> 
> Furthermore, the notification mail for subscribing and adding is send to the 
> groups mal address, which is not recognised by our mailserver.
> 
> I guess, there are some more requirements than in that FAQ:
> 
> https://sogo.nu/support/faq/how-are-groups-handled-in-sogo-.html 
> 

O.k.. got a hint; the FAQ uses groupOfNames, while the AD group I tried hasn’t 
that objectless set.


Any hints on resolving that? Workarounds?

Regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Login Problems since update. SOGoRootPage Login from ... might not have worked - password policy: 65535 grace ...

[goetz.reini...@filmakademie.de]

Hi Christian,

> Am 12.05.2020 um 11:57 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) :
> 
> Hello
> 
> Am 11.05.20 um 12:51 schrieb Götz Reinicke (goetz.reini...@filmakademie.de):
>> Hi,
>> 
>> a user informed me, he could not login to sogo any more , that might be 
>> since we updated to sogo 4.3.1 from 4.2 …. He had no accurate time.
>> 
>> SOGoRootPage Login from ‚xxx.xxx.xxx.xxx' for user ‚myuser' might not have 
>> worked - password policy: 65535  grace: -1  expire: -1  bound: 0
>> 
>> Checking the SOGo log, I can see a couple of that message also for different 
>> users.
>> 
>> The calling user can login to imap, smtp, wifi and some other services with 
>> the same credentials without a problem.
>> 
>> May be something has changed … ?
>> 
> 
> Do you see an error message above the "Login ... might not have worked"
> message?

I do see the ldap search request and filter …. 

> Did your user clear his browser cache after the upgrade?


Yes, but … the user was not sure that he ever used SOGo with that account …. 
And I was pointed into a different false direction:

I found, that the account had one attribute missing, which I use in the search 
filter :-/ so from my POV the user could NEVER use SOGo … ;)

May be the error message could also be a bit more specific, if a user tries to 
login and could not be found in the LDAP …

Thx for taking your time and regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Login Problems since update. SOGoRootPage Login from ... might not have worked - password policy: 65535 grace ...

[goetz.reini...@filmakademie.de]

Hi,

a user informed me, he could not login to sogo any more , that might be since 
we updated to sogo 4.3.1 from 4.2 …. He had no accurate time.

SOGoRootPage Login from ‚xxx.xxx.xxx.xxx' for user ‚myuser' might not have 
worked - password policy: 65535  grace: -1  expire: -1  bound: 0

Checking the SOGo log, I can see a couple of that message also for different 
users.

The calling user can login to imap, smtp, wifi and some other services with the 
same credentials without a problem.

May be something has changed … ?

Thanks for feedback and hints . Regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Problems sending over SMTP on localhost

[goetz.reini...@filmakademie.de]

> Am 17.03.2020 um 11:52 schrieb Lars Liedtke (lied...@punkt.de) 
> :
> 
> Hey,
> 
> I set up a new mail server and now I have Problems sending mail. SOGo and 
> postfix are on the same machine (vpro0612.proserver.punkt.de)
> 
> SOGo complains that it can't send mail over SMTP and I find the following in 
> the logs:
> 
> Mar 17 11:45:52 sogod [62256]: <0x0x8125aff08[NGImap4Client]> TLS started 
> successfully.
> C: connect to <0x0x811082468[NGInternetSocketAddress]: 
> host=vpro0610.proserver.punkt.de not-filled>
> Mar 17 11:45:53 sogod [62256]: [ERROR] <0x0x8110811a8[SOGoMailer]> Could not 
> connect to the SMTP server vpro0610.proserver.punkt.de on port 25

Is the machine really listening for smtp on port 25? No firewall, no other ACL?


/Götz



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Sieve admin account not working anymore

[goetz.reini...@filmakademie.de]

Hi,

may be „the same issue“ as we had with dovecot. We need the sieve user do be 
ALSO able to login to imap.  So you have „two“ logins: one for sieve, one for 
imap.

Check, if your sieve admin is also able to authenticate to imap.

May be that works.

regards . Götz

> Am 12.02.2020 um 11:43 schrieb Rainer Ruprechtsberger 
> (rruprechtsberger+s...@volkshilfe-ooe.at) :
> 
> Hi,
> this is not a SOGo issue as such, but related:
> We upgraded our Cyrus Imap from 2.4 to 3.0 recently and it broke our
> sieve admin account used by SOGo to expire vaccation messages.
> 
> The account may login to sieve but isn't recogniced as an admin account
> anymore (PLAIN authentication failure when it tries to administer other
> users sieve scripts).
> 
> Maybe somebody else here encountered this problem or has any idea how I
> could work around this.
> 
> /rupi
> 
> -- 
> Rainer Ruprechtsberger
> Volkshilfe Oberösterreich
> IT
> 4020 Linz, Glimpfingerstrasse 48
> Tel.: +43 732 3405 123
> Mobil.: +43 676 8734 1123
> 
> ZVR Zahl: 064371505
> 
> Volkshilfe. Wir sind für die Menschen da.
> 

  <http://www.filmakademie.de/>   

Götz Reinicke 
IT-Koordination
IT-OfficeNet
+49 7141 969 82420 
goetz.reini...@filmakademie.de <mailto:goetz.reini...@filmakademie.de>
Filmakademie Baden-Württemberg GmbH 
Akademiehof 10
71638 Ludwigsburg 
http://www.filmakademie.de <http://www.filmakademie.de/>
   <https://twitter.com/filmakademiebw>
<https://de-de.facebook.com/filmakademiebw> 
<https://www.youtube.com/user/TheFilmakademie>  
<https://vimeo.com/filmakademiebw> 

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrates:
Petra Olschowski
Staatssekretärin im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg
Geschäftsführer:
Prof. Thomas Schadt

Datenschutzerklärung 
<https://www.filmakademie.de/de/meta/datenschutz/datenschutzerklaerung/> | 
Transparenzinformation 
<https://www.filmakademie.de/de/meta/datenschutz/transparenzinformationen/>
Data privacy statement 
<https://www.filmakademie.de/en/meta/data-privacy/data-privacy-statement/> | 
Transparency information 
<https://www.filmakademie.de/en/meta/data-privacy/transparency-information/>



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] SOGo 4.2.0 - An error occured while removing auto-reply

[goetz.reini...@filmakademie.de]

> Am 16.01.2020 um 15:26 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> :
> 
> On 2020-01-16 2:36 a.m., Götz Reinicke (goetz.reini...@filmakademie.de) wrote:
> 
>> Like a normal (imap) user?
> Yes, it normally should and in SOGo's case, must to be able to grab the IMAP 
> separator.

Did this behaviour changed from SOGo 4.1.x to SOGo 4.2.0 ? We did not change 
any user / LDAP / AD / auth settings recently and with SOGo 4.1.x there had 
been not such a problem ….

A /usr/sbin/sogo-tool update-autoreply -p /pathto/credentials can be executes.

But gives errors:

<0x0x4eab860[SOGoSieveManager]> Could not delete Sieve script: Sieve script 
`sogo' not found
2020-01-16 15:46:36.562 sogo-tool[30619] An error occured while removing 
auto-reply of user NAME


>> SOGo executes/triggers some sieve action as when a vacation responder is to 
>> be disabled, my scripts are modified that way, that any folder separators 
>> „/„ are removed.
>> 
>> e.g. it changes from Mailinglisten/FOOBAR to MailinglistenFOOBAR and the 
>> filters do not work any more.
> Likely because it can't grab the separator.






smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] SOGo 4.2.0 - An error occured while removing auto-reply

[goetz.reini...@filmakademie.de]

Hi Ludovic,

> Am 15.01.2020 um 14:20 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> :
> 
> Hi Götz,
> 
> On 2020-01-15 3:13 a.m., Götz Reinicke (goetz.reini...@filmakademie.de 
> <mailto:goetz.reini...@filmakademie.de>) wrote:
>> is there any news or need of debug help/feedback as this is still very bad, 
>> if your sieve filters get messed up … our first users start to complain….
>> 
> Which IMAP server are you using?
> 
Recent dovecot.
> Also, can you make sure your Sieve "admin" can also log in on the IMAP server?
> 
Like a normal (imap) user?

SOGo executes/triggers some sieve action as when a vacation responder is to be 
disabled, my scripts are modified that way, that any folder separators „/„ are 
removed.

e.g. it changes from Mailinglisten/FOOBAR to MailinglistenFOOBAR and the 
filters do not work any more.

Regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] SOGo 4.2.0 - An error occured while removing auto-reply

[goetz.reini...@filmakademie.de]

Hi,

is there any news or need of debug help/feedback as this is still very bad, if 
your sieve filters get messed up … our first users start to complain….

Regards . Götz


> Am 10.01.2020 um 07:16 schrieb Valdas Žiūraitis (val...@ziuraitis.lt) 
> :
> 
> Hi
> 2020-01-09 00:00:03.229 sogo-tool[17248] An error occured while enabling 
> auto-reply of user u...@dom.com <mailto:ruta.dapki...@celsis.lt>2020-01-10 
> 00:00:03.368 sogo-tool[20635] An error occured while enabling auto-reply of 
> u...@dom.com <mailto:u...@dom.com>
> 
> sieve script starts working, and i get vacation reply.
> 
> after 2020-01-15 the sieve script will stop working and i will not get 
> vacation reply, but i will get error:
> An error occured while removing auto-reply of user...
> 
> 
> 
> 2020.01.09 11:34, Christian Mack (christian.m...@uni-konstanz.de 
> <mailto:christian.m...@uni-konstanz.de>) rašė:
>> Hello 
>> 
>> That error messages state, that there was no SIEVE scripts on the email 
>> server for that users. 
>> 
>> Did the auto-reply for those users work? 
>> 
>> 
>> Kind regards, 
>> Christian Mack 
>> 
>> Am 08.01.20 um 13:10 schrieb Valdas Žiūraitis (val...@ziuraitis.lt 
>> <mailto:val...@ziuraitis.lt>): 
>>> the same: 
>>> 
>>> <0x0x14a3580[SOGoCache]> Cache cleanup interval set every 300.00 
>>> seconds 
>>> <0x0x14a3580[SOGoCache]> Using host(s) '127.0.0.1:11211' as server(s) 
>>> <0x0x1584e20[NGSieveClient]> TLS started successfully. 
>>> 2020-01-08 00:00:03.360 sogo-tool[31942] An error occured while removing 
>>> auto-reply of use...@d1.com <mailto:use...@d1.com> 
>>> <0x0x19fad90[NGSieveClient]> TLS started successfully. 
>>> <0x0x19fa3a0[SOGoSieveManager]> Could not delete Sieve script: Script does 
>>> not exist. 
>>> 2020-01-08 00:00:09.573 sogo-tool[31942] An error occured while removing 
>>> auto-reply of use...@d1.com <mailto:use...@d1.com> 
>>> <0x0x1b58dc0[NGSieveClient]> TLS started successfully. 
>>> <0x0x1b583d0[SOGoSieveManager]> Could not delete Sieve script: Script does 
>>> not exist. 
>>> 2020-01-08 00:00:11.566 sogo-tool[31942] An error occured while removing 
>>> auto-reply of user u...@d1.com <mailto:u...@d1.com> 
>>> <0x0x1e4e720[NGSieveClient]> TLS started successfully. 
>>> <0x0x1e4dcb0[SOGoSieveManager]> Could not delete Sieve script: Script does 
>>> not exist. 
>>> 2020-01-08 00:00:13.661 sogo-tool[31942] An error occured while enabling 
>>> auto-reply of use...@d1.com <mailto:use...@d1.com> 
>>> <0x0x1edcff0[NGSieveClient]> TLS started successfully. 
>>> 2020-01-08 00:00:15.586 sogo-tool[31942] An error occured while removing 
>>> auto-reply of use...@d1.com <mailto:use...@d1.com> 
>>> <0x0x223ef20[NGSieveClient]> TLS started successfully. 
>>> <0x0x223e550[SOGoSieveManager]> Could not delete Sieve script: Script does 
>>> not exist. 
>>> 2020-01-08 00:00:17.580 sogo-tool[31942] An error occured while removing 
>>> auto-reply of user u...@d1.com <mailto:u...@d1.com> 
>>> <0x0x231b4c0[NGSieveClient]> TLS started successfully. 
>>> <0x0x231aad0[SOGoSieveManager]> Could not delete Sieve script: Script does 
>>> not exist. 
>>> 2020-01-08 00:00:19.582 sogo-tool[31942] An error occured while removing 
>>> auto-reply of user u...@d1.com <mailto:u...@d1.com> 
>>> 
>>> 
>>> 
>>> 2020.01.08 09:32, Götz Reinicke (goetz.reini...@filmakademie.de 
>>> <mailto:goetz.reini...@filmakademie.de>) rašė: 
>>>> Hi, after updating to the recent SOGo 4.2.0 I see „An error occured while 
>>>> removing auto-reply“ from the cron job. 
>>>> 
>>>> But I don’t see yet what is wrong. …. 
>>>> 
>>>> Any hints? 
>>>> 
>>>> Regards . Götz 
>>>> 


smime.p7s
Description: S/MIME cryptographic signature

[SOGo] SOGo 4.2.0 - An error occured while removing auto-reply

[goetz.reini...@filmakademie.de]

Hi, after updating to the recent SOGo 4.2.0 I see „An error occured while 
removing auto-reply“ from the cron job.

But I don’t see yet what is wrong. ….

Any hints?

Regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] iCal Error fixed

[goetz.reini...@filmakademie.de]

Thumbs up. Thanks!!

/Götz


> Am 29.10.2019 um 00:48 schrieb Sam W. Klambour (klamb...@macsmb.com) 
> :
> 
> That's great, Ludovic!
> 
> Thanks
> Sam
> 
> MacSMB
> Sam W. Klambour
> klamb...@macsmb.com 
> voice: +4179-602-
> skype: klambour1
> Zurich - Switzerland
> 
> 
> On 2019/10/28 19:45, Ludovic Marcotte (lmarco...@inverse.ca 
> ) wrote:
>> On 2019-10-17 10:23 a.m., "Sam W. Klambour" (klamb...@macsmb.com 
>> ) wrote:
>> 
>>> 
>>> can we do something to motivate the SOGo Team to fix this bug?
>>> 
>>> https://sogo.nu/bugs/view.php?id=4813 
>>> 
>>> 
>>> It's kind of odd to have to tell users that they can not create/delete 
>>> calendars in iCal (aka Calendar.app)
>> This bug has been fixed.
>> 
>> Thanks,
>> 



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] iCal Error when creating new calendar in macOS 10.14

[goetz.reini...@filmakademie.de]

Hi,

that’s a known problem, without no solution yet AFAIK. I’d noticed the same in 
Februar / May  2019 as some users had 100++ of calendar duplicates.

Ludovic was on it, but somehow we stuck in debugging that …. I guess.

/Götz


> Am 17.09.2019 um 15:59 schrieb Sam W. Klambour (klamb...@macsmb.com) 
> :
> 
> I have verified with a another SOGo server and another Mac client that 
> deleting a calendar does indeed not work from within iCal, at least for macOS 
> 10.14.5 and 10.14.6
> 
> …
> 
> 3) When trying to delete a calendar in iCal, the calendar is being duplicated 
> each time one choses to delete it. So you will end up with more and more 
> calendars you can't delete.
> 
> 4) Yet, when going to the SOGo webmail on the same Mac, 
> one can delete these calendars



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] sogo-tool remove explained ... :) I do remove, tables deleted, user get's Data

[goetz.reini...@filmakademie.de]

Hi,

I removed an user with „ sogo-tool remove username“. The mysql shows no tables 
for that user any more.

When that user logs in again, Calendar subscriptions and e-mail signature do 
still exist ….

II thought, that the user and his data is removed immediately from the DB …

Can someone explain that behavior? Cahcing? Memcached ….

Regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Creating of Calendars from Apple Calendar causes problems - multiplying the calendars

[goetz.reini...@filmakademie.de]

Hi,

I had two users which could tell me how they added calendars and had that 
recreation / multiplying problem.

I could reproduce it on my Mac:

Working caldav account with different privat and subscribed calendars from SOGo

Adding a new Calendar in Apple Calendar throws an error: „The Server reported 
an Error“ „Retry“ „OK“

In the SOGo logs I do get at that time:

May 10 15:21:28 sogod [25734]: |SOGo| starting method 'MKCALENDAR' on uri 
'/SOGo/dav/greinick/Calendar/B0634B0A-AF9D-480B-8B19-E26401EE7FD2/'
May 10 15:21:28 sogod [25734]: |SOGo| request took 0.000593 seconds to execute
May 10 15:21:28 sogod [25734]: 172.17.22.155 "MKCALENDAR 
/SOGo/dav/greinick/Calendar/B0634B0A-AF9D-480B-8B19-E26401EE7FD2/ HTTP/1.1" 401 
0/1217 0.001 - - 0
May 10 15:21:28 sogod [25734]: |SOGo| starting method 'MKCALENDAR' on uri 
'/SOGo/dav/greinick/Calendar/B0634B0A-AF9D-480B-8B19-E26401EE7FD2/'
2019-05-10 15:21:28.552 sogod[25734] EXCEPTION:  
NAME:NSInvalidArgumentException REASON:That name already exists INFO:(null)



Quit Apple Calendar and it COULD happen, that I do get the same error as above: 
 „The Server reported an Error“ „Retry“ „OK“

and than the created calendar gest doubled …. 

Or: try to delete the calendar from Apple Calendar, I do get the error and the 
calendar gets copied once more.

Furthermore I see this message in Apple Calendar as Error:

Antwort des Servers
„502“
an Vorgang CalDAVCalendarSplitDualTypeCalendarQueueableOperation.



Within a few clicks adding, try to remove I have generated about 10 Copies ….


HTH for debugging … and resolving … or what would be the solution?

As a workaround I can suggest the user not to create calendars or delete them 
by Apple Calendar, but that could not be the solution at the end of the day 
….Or may be I did miss some config or feature? …



Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] A calendar got created about 500 times for one user and can't be deleted

[goetz.reini...@filmakademie.de]

> Am 06.05.2019 um 08:35 schrieb Götz Reinicke (goetz.reini...@filmakademie.de) 
> :
> 
> Hi Ludovic,
> 
>> Am 03.05.2019 um 14:51 schrieb Ludovic Marcotte (lmarco...@inverse.ca 
>> <mailto:lmarco...@inverse.ca>) mailto:users@sogo.nu>>:
>> 
>> On 2019-05-03 3:28 a.m., Götz Reinicke (goetz.reini...@filmakademie.de 
>> <mailto:goetz.reini...@filmakademie.de>) wrote:
>> 
>>> This problem escalates …. I got more users telling me about that problem; 
>>> in one case there are 2.837 Calendars added to an user account.
>>> 
>>> Dose anyone has an idea?
>> 
>> Can you see the DAV requests in the sogo.log when the calendars are created? 
>> If so, what is the request/response.
> 
> Within the current logs I don’t see any requests, as we had daily log 
> rotation and the last time the user noticed the problem is about one week ago 
> +-.
> 
> Which Debug/Log option may I activate for logging the creation and may be 
> misbehavior?

Hi,

I do have two more users with n*100 new calendars and feel a bit lost in 
debugging that case.

Regards Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] A calendar got created about 500 times for one user and can't be deleted

[goetz.reini...@filmakademie.de]

Hi Ludovic,

> Am 03.05.2019 um 14:51 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> :
> 
> On 2019-05-03 3:28 a.m., Götz Reinicke (goetz.reini...@filmakademie.de) wrote:
> 
>> This problem escalates …. I got more users telling me about that problem; in 
>> one case there are 2.837 Calendars added to an user account.
>> 
>> Dose anyone has an idea?
> 
> Can you see the DAV requests in the sogo.log when the calendars are created? 
> If so, what is the request/response.

Within the current logs I don’t see any requests, as we had daily log rotation 
and the last time the user noticed the problem is about one week ago +-.

Which Debug/Log option may I activate for logging the creation and may be 
misbehavior?

Thanks and regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] A calendar got created about 500 times for one user and can't be deleted

[goetz.reini...@filmakademie.de]

Hi,

> Am 19.02.2019 um 17:06 schrieb Götz Reinicke (goetz.reini...@filmakademie.de 
> <mailto:goetz.reini...@filmakademie.de>)  <mailto:users@sogo.nu>>:
> 
> 
> 
>> Am 18.02.2019 um 15:24 schrieb Christian Mack 
>> (christian.m...@uni-konstanz.de <mailto:christian.m...@uni-konstanz.de>) 
>> mailto:users@sogo.nu>>:
>> 
>> Hello
>> 
>> Am 18.02.19 um 13:19 schrieb Götz Reinicke (goetz.reini...@filmakademie.de 
>> <mailto:goetz.reini...@filmakademie.de>):
>>> Hi,
>>> 
>>> may be someone has an idea or explanation, why a calendar was created about 
>>> 500 times for an user. She told me, she added one instance by mistake and 
>>> deleted the calendar. But it did not disappear, instead it got „magically“ 
>>> created more than 500 times over the last couple of days.
>>> 
>>> And she can’t delete the calendars.
>>> 
>> 
>> Are there any special characters in the calendars name?
>> Do you see those 500 entries/calendars also in the backup with sogo-tool?
>> Did she get additional privileges for that calendar from the owner?
>> 
> 
> Hi Christian,
> 
> no, there are no special characters in the name and she is the owner of the 
> calendar, had created it in the first place in SOGo not in icloud.
> 
> The entries are in the backup.
> 
> e.g. always with different Calendar/
> 
> "/Users/USERSID/Calendar/054F1B71-9E28-4CA5-9ACB-8027D595CE51" = {
> acl = {
> };
> displayname = "Anderswo Unterwegs";
> records = (
> );
> };

This problem escalates …. I got more users telling me about that problem; in 
one case there are 2.837 Calendars added to an user account.

Dose anyone has an idea? 

Regards . Götz




  <http://www.filmakademie.de/>   
Götz Reinicke 
IT-Koordinator
IT-OfficeNet
+49 7141 969 82420 
goetz.reini...@filmakademie.de <mailto:goetz.reini...@filmakademie.de>
Filmakademie Baden-Württemberg GmbH 
Akademiehof 10
71638 Ludwigsburg 
http://www.filmakademie.de <http://www.filmakademie.de/>
   <https://twitter.com/filmakademiebw>
<https://de-de.facebook.com/filmakademiebw> 
<https://www.youtube.com/user/TheFilmakademie>  
<https://vimeo.com/filmakademiebw> 
Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrates:
Petra Olschowski
Staatssekretärin im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg
Geschäftsführer:
Prof. Thomas Schadt

Datenschutzerklärung 
<https://www.filmakademie.de/de/meta/datenschutz/datenschutzerklaerung/> | 
Transparenzinformation 
<https://www.filmakademie.de/de/meta/datenschutz/transparenzinformationen/>
Data privacy statement 
<https://www.filmakademie.de/en/meta/data-privacy/data-privacy-statement/> | 
Transparency information 
<https://www.filmakademie.de/en/meta/data-privacy/transparency-information/>



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Deleting users which are already removed from AD/LDAP

[goetz.reini...@filmakademie.de]

Hi,

I have a bunch of SOGo users which are already removed from our User directory. 
Is there an easy way to remove them from SOGo as well?

Is „sogo-tool cleanup USERID“ the right way?

And is there still a way to do a backup of the users SOGo data?

Thanks for feedback and suggestion . Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] A calendar got created about 500 times for one user and can't be deleted

[goetz.reini...@filmakademie.de]

> Am 18.02.2019 um 15:24 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) :
> 
> Hello
> 
> Am 18.02.19 um 13:19 schrieb Götz Reinicke (goetz.reini...@filmakademie.de):
>> Hi,
>> 
>> may be someone has an idea or explanation, why a calendar was created about 
>> 500 times for an user. She told me, she added one instance by mistake and 
>> deleted the calendar. But it did not disappear, instead it got „magically“ 
>> created more than 500 times over the last couple of days.
>> 
>> And she can’t delete the calendars.
>> 
> 
> Are there any special characters in the calendars name?
> Do you see those 500 entries/calendars also in the backup with sogo-tool?
> Did she get additional privileges for that calendar from the owner?
> 

Hi Christian,

no, there are no special characters in the name and she is the owner of the 
calendar, had created it in the first place in SOGo not in icloud.

The entries are in the backup.

e.g. always with different Calendar/

"/Users/USERSID/Calendar/054F1B71-9E28-4CA5-9ACB-8027D595CE51" = {
acl = {
};
displayname = "Anderswo Unterwegs";
records = (
);
};


/Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] A calendar got created about 500 times for one user and can't be deleted

[goetz.reini...@filmakademie.de]

Hi,

may be someone has an idea or explanation, why a calendar was created about 500 
times for an user. She told me, she added one instance by mistake and deleted 
the calendar. But it did not disappear, instead it got „magically“ created more 
than 500 times over the last couple of days.

And she can’t delete the calendars.

Any idea :) ? Regdars . Götz



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Bugging null in FoldersOrder - reapearing - sogo 4.0.5

[goetz.reini...@filmakademie.de]

Hi,

again an user had problem accessing the calendars from the WebUI and in the 
users backup the FoldersOrder had a  entry.

In the past I could remove that line and restore the backup but today I see, 
that the user still can’t login.

So I pulled again a backup and the  is there again. As if the backup was 
not restored.

I also restarted sogo and memcached.

Any hints/suggestions/ideas? Thanks for feedback . Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] AD LDAP SOGoUserSources

[goetz.reini...@filmakademie.de]

Hi,

> Am 24.01.2019 um 22:28 schrieb Matthew Valdez (maval...@ludlums.com) 
> :
> 
> Hello,
> 
> I am trying to setup the SOGoUserSources by using Active Directory and LDAP 
> and for some reason I cannot seem to get it to work. I am able to login if I 
> use the type SQL, but cannot seem to get it to work with ldap. Any help would 
> be appreciate, this is what I have for SOGoUserSources, of course modified a 
> little to share with you all.
> 
> 
> SOGoUserSources = (
> {
> type = ldap;
> CNFieldName = cn;
> IDFieldName = uid;
> UIDFieldName = uid;
> baseDN= "cn=Users,dc=domain,dc=local";
> bindDN   = "cn=sogo,cn=Users,dc=domain,dc=local";
> bindPassword= password;
> canAuthenticate = YES;
> displayName= "Shared Addresses";
> hostname= "ldap://dns.dc.local:389;;
> id = public;
> isAddressBook   = YES;
> }
> );
> 

May be your AD is using SSL/starttls on port 389?

hostname = "ldap://dns.dc.local:389/!StartTLS 
“;

And I have a filter set:

filter = "mail = '*‘"

Regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Strange sorting

[goetz.reini...@filmakademie.de]

Hi,

one user got some mails sorted in a strange order. Mails from one sender with 
the same subject title (different content and sending dates) get listed one 
after an other while other mails are sorted correctly in the inbox.

Sorting is set to „by date“. 

The inbox looks like that:

Mail from Santat date 01.12.2018
Mail from Marta date 08.11.2018
Mail from Peter date 10.09.2018
Mail from Albert date 08.09.2018
Sender Anna subject Workshop A date 10.11.2018
Sender Anna subject Workshop A date 10.10.2018
Sender Anna subject Workshop A date 10.09.2018
Sender Anna subject Workshop A date 10.08.2018
Mail from Peter date 01.07.2018
….

Has anyone ever had such a behavior?

Accessing the Mailacount from thunderbird shows mail sorted by date in the 
right order. Same within google.meil, where the user has subscribed to that 
account too


Thanks for any hints or suggestion. May be some dovecot index is broken on the 
mailserver side?

Regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Calendar shows ID instead of Name

[goetz.reini...@filmakademie.de]

Hi,

> Am 17.12.2018 um 18:07 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) :
> 
> Am 17.12.18 um 15:39 schrieb Götz Reinicke (goetz.reini...@filmakademie.de):
>> Hi,
>> 
>> since some days Users tell me, that some subscribed or own calendars show up 
>> as an ID like 7399-12312312-12312333 instead of „Cooking Class“.
>> 
>> This happens in Apple Calendar and SOGO Web Userinterface.
>> 
>> I guess some linking between Names and the IDs got lost somewhere; but where?
>> 
>>  Any hints and suggestions are welcome . Regards . Götz
>> 
> 
> Did you check in the sogo-tool backup file of that user, if the calendar
> folder name is still set?
> 
> If yes I would try to fix it with a restore of that calendar.
> If no, I would add it to the backup file and restore.


The bad news: The backup script is not running any more for a few days and I 
have no clew why? May be you?

The other cronjobs lick Vacation messages expiration are running fine.

A backup from CLI with sogo-tools  for an user works as well.

That backup dose not contain the calendar names, just the ID.

The question for me is: How did the names get lost in first place? Doing a 
backup edit the file and restore ist not a good option…. Some users are not 
amused about loosing the names.

Any ideas?

Thanks and Regards . Götz

 

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Calendar shows ID instead of Name

[goetz.reini...@filmakademie.de]

Hi,

since some days Users tell me, that some subscribed or own calendars show up as 
an ID like 7399-12312312-12312333 instead of „Cooking Class“.

This happens in Apple Calendar and SOGO Web Userinterface.

I guess some linking between Names and the IDs got lost somewhere; but where?

Any hints and suggestions are welcome . Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Tuning SOGo environment

[goetz.reini...@filmakademie.de]

r dispatchInContext:] 
(self=0x555fcfbd93c0, _cmd=0x7f3fc7130500 <_OBJC_SELECTOR_TABLE+1536>, 
_ctx=0x555fc91a1260)
at SoObjectMethodDispatcher.m:191
#29 0x7f3fc6df6287 in -[SoObjectRequestHandler 
handleRequest:inContext:session:application:] (self=0x555fc8188e20, 
_cmd=0x7f3fc70b6830 <_OBJC_SELECTOR_TABLE+848>, _rq=0x555fc9197cb0, 
_ctx=0x555fc91a1260, _sn=0x0, app=0x555fc8152390) at 
SoObjectRequestHandler.m:584
#30 0x7f3fc6d7c8e7 in -[WORequestHandler handleRequest:] 
(self=0x555fc8188e20, _cmd=0x7f3fc7080df0 <_OBJC_SELECTOR_TABLE+1616>, 
_request=0x555fc9197cb0) at WORequestHandler.m:237
#31 0x7f3fc6d3e0fc in -[WOCoreApplication dispatchRequest:usingHandler:] 
(self=0x555fc8152390, _cmd=0x7f3fc7080e40 <_OBJC_SELECTOR_TABLE+1696>, 
_request=0x555fc9197cb0, 
handler=0x555fc8188e20) at WOCoreApplication.m:712
#32 0x7f3fc6d3e3ff in -[WOCoreApplication dispatchRequest:] 
(self=0x555fc8152390, _cmd=0x555fc7b634a0 <_OBJC_SELECTOR_TABLE+1664>, 
_request=0x555fc9197cb0) at WOCoreApplication.m:752
#33 0x555fc795af4c in -[SOGo dispatchRequest:] (self=0x555fc8152390, 
_cmd=0x7f3fc7119080 <_OBJC_SELECTOR_TABLE+1760>, _request=0x555fc9197cb0) at 
SOGo.m:584
#34 0x7f3fc6de4e50 in -[WOHttpTransaction _run] (self=0x555fcdce0570, 
_cmd=0x7f3fc71190b0 <_OBJC_SELECTOR_TABLE+1808>) at WOHttpTransaction.m:566
#35 0x7f3fc6de51b0 in -[WOHttpTransaction run] (self=0x555fcdce0570, 
_cmd=0x7f3fc7116df0 <_OBJC_SELECTOR_TABLE+1168>) at WOHttpTransaction.m:619
#36 0x7f3fc6de0f64 in -[WOHttpAdaptor runConnection:] (self=0x555fc842d5c0, 
_cmd=0x7f3fc7116e90 <_OBJC_SELECTOR_TABLE+1328>, _socket=0x555fcfba5840) at 
WOHttpAdaptor.m:373
#37 0x7f3fc6de1182 in -[WOHttpAdaptor _handleAcceptedConnection:] 
(self=0x555fc842d5c0, _cmd=0x7f3fc7116ea0 <_OBJC_SELECTOR_TABLE+1344>, 
_connection=0x555fcfba5840) at WOHttpAdaptor.m:407
---Type  to continue, or q  to quit---
#38 0x7f3fc6de1577 in -[WOHttpAdaptor _handleConnection:] 
(self=0x555fc842d5c0, _cmd=0x7f3fc7116f40 <_OBJC_SELECTOR_TABLE+1504>, 
connection=0x555fcfba5840) at WOHttpAdaptor.m:466
#39 0x7f3fc6de1843 in -[WOHttpAdaptor acceptControlMessage:] 
(self=0x555fc842d5c0, _cmd=0x7f3fc7116c90 <_OBJC_SELECTOR_TABLE+816>, 
aNotification=0x555fd2137cc0) at WOHttpAdaptor.m:505
#40 0x7f3fc551895f in -[NSNotificationCenter _postAndRelease:] 
(self=0x555fc7f26410, _cmd=, notification=0x555fd2137cc0) at 
NSNotificationCenter.m:1191
#41 0x7f3fc61a811d in -[NSObject(FileObjectWatcher) 
receivedEvent:type:extra:forMode:] (self=0x555fc81ec100, _cmd=0x7f3fc5a6deb0 
<_OBJC_SELECTOR_TABLE+304>, _fdData=0x7, _type=ET_RDESC, 
_extra=0x7, _mode=0x7f3fc5a00350 <_OBJC_INSTANCE_2>) at 
NSRunLoop+FileObjects.m:58
#42 0x7f3fc562284a in -[GSRunLoopCtxt pollUntil:within:] (self=, _cmd=0x7f3fc59ff540 <_OBJC_SELECTOR_TABLE+1216>, milliseconds=, contexts=)
at GSRunLoopCtxt.m:642
#43 0x7f3fc5561030 in -[NSRunLoop acceptInputForMode:beforeDate:] 
(self=0x555fc8220c10, _cmd=0x7f3fc59ff580 <_OBJC_SELECTOR_TABLE+1280>, 
mode=0x7f3fc5a00350 <_OBJC_INSTANCE_2>, 
limit_date=) at NSRunLoop.m:1214
#44 0x7f3fc55614a9 in -[NSRunLoop runMode:beforeDate:] 
(self=0x555fc8220c10, _cmd=0x7f3fc7080ce0 <_OBJC_SELECTOR_TABLE+1344>, 
mode=0x7f3fc5a00350 <_OBJC_INSTANCE_2>, date=0x555fcf793000)
at NSRunLoop.m:1275
#45 0x7f3fc6d3d954 in -[WOCoreApplication run] (self=0x555fc8152390, 
_cmd=0x555fc7b63200 <_OBJC_SELECTOR_TABLE+992>) at WOCoreApplication.m:584
#46 0x555fc795a0d4 in -[SOGo run] (self=0x555fc8152390, _cmd=0x7f3fc70bedb0 
<_OBJC_SELECTOR_TABLE+624>) at SOGo.m:337
#47 0x7f3fc6d85e4d in -[WOWatchDog _runChildWithControlSocket:] 
(self=0x555fc8294c10, _cmd=0x7f3fc70bee50 <_OBJC_SELECTOR_TABLE+784>, 
controlSocket=0x555fc81ec100)
at WOWatchDogApplicationMain.m:523
#48 0x7f3fc6d862e0 in -[WOWatchDog _spawnChild:] (self=0x555fc8294c10, 
_cmd=0x7f3fc70bef20 <_OBJC_SELECTOR_TABLE+992>, child=0x555fc81b0c20) at 
WOWatchDogApplicationMain.m:600
#49 0x7f3fc6d869d6 in -[WOWatchDog _ensureChildren] (self=0x555fc8294c10, 
_cmd=0x7f3fc70bf0e0 <_OBJC_SELECTOR_TABLE+1440>) at 
WOWatchDogApplicationMain.m:690
#50 0x7f3fc6d87a1e in -[WOWatchDog run:argc:argv:] (self=0x555fc8294c10, 
_cmd=0x7f3fc70bf1f0 <_OBJC_SELECTOR_TABLE+1712>, newAppName=0x555fc7b61160 
<_OBJC_INSTANCE_0>, newArgC=7, 
newArgV=0x7ffecf17a308) at WOWatchDogApplicationMain.m:942
#51 0x7f3fc6d88149 in WOWatchDogApplicationMain (appName=0x555fc7b61160 
<_OBJC_INSTANCE_0>, argc=7, argv=0x7ffecf17a308) at 
WOWatchDogApplicationMain.m:1051
#52 0x555fc7958ce1 in main (argc=7, argv=0x7ffecf17a308, 
env=0x7ffecf17a348) at sogod.m:51


  <http://www.filmakademie.de/>   
Götz Reinicke 
IT-Koordinator
IT-OfficeNet
+49 7141 969 82420 
goetz.reini...@filmakademie.de <mailto:goetz.rein

Re: [SOGo] Tuning SOGo environment

[goetz.reini...@filmakademie.de]

> Am 21.11.2018 um 14:30 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> :
> 
> On 2018-11-21 8:28 AM, Götz Reinicke (goetz.reini...@filmakademie.de 
> <mailto:goetz.reini...@filmakademie.de>) wrote:
>> I don’t get it …
>> 
>> In the logs I have „sogod [9256]: [ERROR] <0x0x559d2ea51c00[WOWatchDog]> No 
>> child available to handle incoming request!“
>> 
>> I did use the PID 9256 of process  gdb -p 9256 and hit „bt“. The output are 
>> the lines above.
>> 
>> What am I missing?
> Look for messages like "process has been hanging for X minutes.." and grab 
> the pid. Use that pid for gd.
> 
> 

Got one - hopefully the right one :)

#0  0x7f3fc0ceef0d in poll () from /lib64/libc.so.6
#1  0x7f3fc5621e36 in poll (__timeout=6536, __nfds=, 
__fds=) at /usr/include/bits/poll2.h:46
#2  -[GSRunLoopCtxt pollUntil:within:] (self=, 
_cmd=0x7f3fc59ff540 <_OBJC_SELECTOR_TABLE+1216>, milliseconds=6536, 
contexts=) at GSRunLoopCtxt.m:430
#3  0x7f3fc5561030 in -[NSRunLoop acceptInputForMode:beforeDate:] 
(self=0x555fc8220c10, _cmd=0x7f3fc59ff580 <_OBJC_SELECTOR_TABLE+1280>, 
mode=0x7f3fc5a00350 <_OBJC_INSTANCE_2>, 
limit_date=) at NSRunLoop.m:1214
#4  0x7f3fc55614a9 in -[NSRunLoop runMode:beforeDate:] 
(self=0x555fc8220c10, _cmd=0x7f3fc7080ce0 <_OBJC_SELECTOR_TABLE+1344>, 
mode=0x7f3fc5a00350 <_OBJC_INSTANCE_2>, date=0x555fd5c51910)
at NSRunLoop.m:1275
#5  0x7f3fc6d3d954 in -[WOCoreApplication run] (self=0x555fc8152390, 
_cmd=0x555fc7b63200 <_OBJC_SELECTOR_TABLE+992>) at WOCoreApplication.m:584
#6  0x555fc795a0d4 in -[SOGo run] (self=0x555fc8152390, _cmd=0x7f3fc70bedb0 
<_OBJC_SELECTOR_TABLE+624>) at SOGo.m:337
#7  0x7f3fc6d85e4d in -[WOWatchDog _runChildWithControlSocket:] 
(self=0x555fc8294c10, _cmd=0x7f3fc70bee50 <_OBJC_SELECTOR_TABLE+784>, 
controlSocket=0x555fc80fd5b0)
at WOWatchDogApplicationMain.m:523
#8  0x7f3fc6d862e0 in -[WOWatchDog _spawnChild:] (self=0x555fc8294c10, 
_cmd=0x7f3fc70bef20 <_OBJC_SELECTOR_TABLE+992>, child=0x555fc81da5a0) at 
WOWatchDogApplicationMain.m:600
#9  0x7f3fc6d869d6 in -[WOWatchDog _ensureChildren] (self=0x555fc8294c10, 
_cmd=0x7f3fc70bf0e0 <_OBJC_SELECTOR_TABLE+1440>) at 
WOWatchDogApplicationMain.m:690
#10 0x7f3fc6d87a1e in -[WOWatchDog run:argc:argv:] (self=0x555fc8294c10, 
_cmd=0x7f3fc70bf1f0 <_OBJC_SELECTOR_TABLE+1712>, newAppName=0x555fc7b61160 
<_OBJC_INSTANCE_0>, newArgC=7, 
newArgV=0x7ffecf17a308) at WOWatchDogApplicationMain.m:942
#11 0x7f3fc6d88149 in WOWatchDogApplicationMain (appName=0x555fc7b61160 
<_OBJC_INSTANCE_0>, argc=7, argv=0x7ffecf17a308) at 
WOWatchDogApplicationMain.m:1051
#12 0x555fc7958ce1 in main (argc=7, argv=0x7ffecf17a308, 
env=0x7ffecf17a348) at sogod.m:51


thx. Regards . Götz 



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Tuning SOGo environment

[goetz.reini...@filmakademie.de]

> Am 21.11.2018 um 13:14 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> :
> 
> On 2018-11-21 5:10 AM, Götz Reinicke (goetz.reini...@filmakademie.de 
> <mailto:goetz.reini...@filmakademie.de>) wrote:
>> 
>> <…>
>> 
>> #0  0x7f21b3284ef0 in __poll_nocancel () from /lib64/libc.so.6
>> #1  0x7f21b7bb7e36 in poll (__timeout=499, __nfds=, 
>> __fds=) at /usr/include/bits/poll2.h:46
>> #2  -[GSRunLoopCtxt pollUntil:within:] (self=, 
>> _cmd=0x7f21b7f95540 <_OBJC_SELECTOR_TABLE+1216>, milliseconds=499, 
>> contexts=) at GSRunLoopCtxt.m:430
>> #3  0x7f21b7af7030 in -[NSRunLoop acceptInputForMode:beforeDate:] 
>> (self=0x559d2e9ddc10, _cmd=0x7f21b7f95580 <_OBJC_SELECTOR_TABLE+1280>, 
>> mode=0x7f21b7f96350 <_OBJC_INSTANCE_2>, limit_date=) at 
>> NSRunLoop.m:1214
>> #4  0x7f21b7af74a9 in -[NSRunLoop runMode:beforeDate:] 
>> (self=0x559d2e9ddc10, _cmd=0x7f21b9655100 <_OBJC_SELECTOR_TABLE+1472>, 
>> mode=0x7f21b7f96350 <_OBJC_INSTANCE_2>, date=0x559d2e8c76f0) at 
>> NSRunLoop.m:1275
>> #5  0x7f21b931da8b in -[WOWatchDog run:argc:argv:] (self=0x559d2ea51c00, 
>> _cmd=0x7f21b96551f0 <_OBJC_SELECTOR_TABLE+1712>, newAppName=0x559d2d3bc160 
>> <_OBJC_INSTANCE_0>, newArgC=7, newArgV=0x7ffcefa4e2d8) at 
>> WOWatchDogApplicationMain.m:945
>> #6  0x7f21b931e149 in WOWatchDogApplicationMain (appName=0x559d2d3bc160 
>> <_OBJC_INSTANCE_0>, argc=7, argv=0x7ffcefa4e2d8) at 
>> WOWatchDogApplicationMain.m:1051
>> #7  0x559d2d1b3ce1 in main (argc=7, argv=0x7ffcefa4e2d8, 
>> env=0x7ffcefa4e318) at sogod.m:51
>> 
> That's the master sogod process, not a child doing work.

I don’t get it …

In the logs I have „sogod [9256]: [ERROR] <0x0x559d2ea51c00[WOWatchDog]> No 
child available to handle incoming request!“

I did use the PID 9256 of process  gdb -p 9256 and hit „bt“. The output are the 
lines above.

What am I missing?

/Götz 



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Tuning SOGo environment

[goetz.reini...@filmakademie.de]

Hi,

> Am 20.11.2018 um 20:54 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> :
> 
> On 2018-11-20 5:10 AM, Götz Reinicke (goetz.reini...@filmakademie.de 
> <mailto:goetz.reini...@filmakademie.de>) wrote:
>> 
>> Checking the sogo log I can currently only see the old friend „No child 
>> available to handle incoming request!“ … but no other clues.
> When you see this, try to attach to the process using gdb (so "gdb -p 
> PID_OF_THE_PROCESS") and produce a stacktrace (by typing "bt"). Quit gdb 
> after and send us the stacktrace. It'll tell us where it's stuck. Install 
> SOPE/SOGo/GNUstep debugging symbols before doing that. See 
> https://sogo.nu/support/faq/how-do-i-debug-sogo.html 
> <https://sogo.nu/support/faq/how-do-i-debug-sogo.html> for all nice details.

I’ll try to have a closer look ASAP.

>> 
>> That error shows up from time to time and than all sogod processes are using 
>> from 40 to 100% of cpu  …. 
>> 
>> My PREFORK is at 12, the server is a 12 GB 4 CPU VM. MySQL and Dovecot are 
>> on different VMs.
> My wild guess based on the symptoms you mention is your IMAP server is 
> running out of available connections. Or, you have EAS clients consuming all 
> sogod workers.

Hm, I’ll check the IMAP server too. 

As I currently don’t know how might use Active Sync (EAS), is there a easy way 
to see the clients in SOGo logs ?

Thx. Götz





smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Tuning SOGo environment

[goetz.reini...@filmakademie.de]

Hi,

we are faced with some complains from different users which I can partly 
reproduce or understand.

E.G. they log in to the mail Web Userinterface and try to open a mail, which 
takes 5 - 10 seconds, sometimes the mail will not be loaded at all.

Sometimes I can reproduce that for a mail with +- 10kb in size with my account. 
Klick on it… it loads … klick some minutes later on the same mail … it will not 
load at all.

Some users told me, that opening mails, writing some or add calendars is very 
slow while opening the modules or entries in the browser.

This is independent from chrome to firefox or safari on modern new devices and 
some folders….

e.g. my sandbox has about 25.000 mails and shows up from my POV quit quick on 
an iPhones and in safari on my macbook.

Otter users have to wait a few seconds till the list shows up in mailbox 
folders with about 1.000 mails ...

Native mailclients do not show such a „strange“ behavior.



Checking the sogo log I can currently only see the old friend „No child 
available to handle incoming request!“ … but no other clues.

That error shows up from time to time and than all sogod processes are using 
from 40 to 100% of cpu  …. 

My PREFORK is at 12, the server is a 12 GB 4 CPU VM. MySQL and Dovecot are on 
different VMs.


Where and how may I start to get better performance or debug and find the 
„real“ bottleneck?

E.g. what is a special sogo process doing with 100% cpu time?


Thanks for hints and suggestions. Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Files in /var/spool/sogo - purpose?

[goetz.reini...@filmakademie.de]

Hi,

I see a lot of user named folders with „newDraft-Files“ under /var/spool/sogo.

Some a re a couple of month old … As this is slowly eating the disk space, the 
question is: How to handle that? What are the files used for? How to clean up 
the disk space?

Thanks for feedback and suggestions. Regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] SOGo4 Web Interface: mark messages as unread

[goetz.reini...@filmakademie.de]

> Am 31.10.2018 um 14:16 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> :
> 
> On 2018-10-30 12:19 PM, Götz Reinicke (goetz.reini...@filmakademie.de) wrote:
> 
>> Hi,
>> 
>> as far as I see it is not possible to set messages unread in SOGo 4. Or is 
>> there a special option/hidden feature?
> Over the "gravatar icon" to select messages, check them. From the toolbar, 
> click on the vertical "..." and select the option.

Thanks. works.

Cheers . Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] SOGo4 Web Interface: mark messages as unread

[goetz.reini...@filmakademie.de]

Hi,

as far as I see it is not possible to set messages unread in SOGo 4. Or is 
there a special option/hidden feature?

Would bee cool to have that feature back.

Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Multiple Usersources for round-robin / failover ?

[goetz.reini...@filmakademie.de]

Thanks for the feedback … true. 

I took a much closer look at the SOGo doc and found: „hostname: A 
space-delimited list of LDAP URLs or LDAP hostnames."

Regards . Götz

> Am 26.09.2018 um 16:18 schrieb Alexandre Blanc (alexandre.bl...@mayahtt.com) 
> :
> 
> Hi,
> 
> Something like that could work :
> 
>   SOGoUserSources = (
> {
>   type = ldap;
>   CNFieldName = cn;
>   IDFieldName = cn;
>   UIDFieldName = sAMAccountName;
>   //baseDN = "CN=Users,dc=my,dc=domain,dc=ext";
>   baseDN = "dc=my,dc=domain,dc=ext";
>   bindDN = "CN=userloginforquery,CN=Users,DC=my,DC=domain,DC=ext";
>   bindFields = (sAMAccountName);
>   bindPassword = TheuserP4ssword;
>   canAuthenticate = YES;
>   displayName = "Active Directory";
>   hostname = "ldap://ip-of-server-1:389 <ldap://ip-of-server-1:389> 
> ldap://ip-of-server-2:389 <ldap://ip-of-server-2:389>";
>   id = directory;
>   isAddressBook = YES;
> }
>   );
> 
> I hope it helps. Just add many with a space in between :)
> 
> Alexandre
> 
>  
> On 09/26/2018 03:11 AM, Götz Reinicke wrote:
>> Hi,
>> 
>> is it possible to use multiple LDAP sources / ADs for failover and/or 
>> round-robin load balancing?
>> 
>> Thanks for feedback und regards . Götz
>> 
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

  <http://www.filmakademie.de/>   
Götz Reinicke 
IT-Koordinator
IT-OfficeNet
+49 7141 969 82420 
goetz.reini...@filmakademie.de <mailto:goetz.reini...@filmakademie.de>
Filmakademie Baden-Württemberg GmbH 
Akademiehof 10
71638 Ludwigsburg 
http://www.filmakademie.de <http://www.filmakademie.de/>
   <https://twitter.com/filmakademiebw>
<https://de-de.facebook.com/filmakademiebw> 
<https://www.youtube.com/user/TheFilmakademie>  
<https://vimeo.com/filmakademiebw> 
Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrates:
Petra Olschowski
Staatssekretärin im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg
Geschäftsführer:
Prof. Thomas Schadt




smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Automatic Caldav config with Apple and SOGo 4 problem

[goetz.reini...@filmakademie.de]

Hi,

we noticed that the manual configuration of an CALDav Account on macOS is not 
working anymore since we moved from SOGo 2 to a new server with SOGo4

Currently I do have to use the extended configuration with entering the URL, 
path and port. That works and accesses all my calendars.

I guess some redirect „httpd-magic“ is missing :) but I can’t see the 
difference with the old setup.

In the https logs I do see some messages like that:

/var/log/httpd/ssl_access_log:192.168.5.81 - - [26/Sep/2018:10:51:32 +0200] 
"PROPFIND /.well-known/caldav HTTP/1.1" 405 244, 
/var/log/httpd/ssl_access_log:192.168.5.81 - - [26/Sep/2018:10:51:32 +0200] 
"HEAD /.well-known/caldav HTTP/1.1" 404 -
/var/log/httpd/ssl_access_log:192.168.5.81 - - [26/Sep/2018:10:51:32 +0200] 
"PROPFIND / HTTP/1.1" 405 236
/var/log/httpd/ssl_access_log:192.168.5.81 - - [26/Sep/2018:10:51:32 +0200] 
"PROPFIND /caldav/v2 HTTP/1.1" 405 235
/var/log/httpd/ssl_access_log:192.168.5.81 - - [26/Sep/2018:10:51:32 +0200] 
"PROPFIND /principals/users/greinick/ HTTP/1.1" 405 252
/var/log/httpd/ssl_access_log:192.168.5.81 - - [26/Sep/2018:10:51:32 +0200] 
"PROPFIND /principals/ HTTP/1.1" 405 237
/var/log/httpd/ssl_access_log:192.168.5.81 - - [26/Sep/2018:10:51:32 +0200] 
"PROPFIND /dav/principals/ HTTP/1.1" 405 241


Any hints / suggestions . Thanks and regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Multiple Usersources for round-robin / failover ?

[goetz.reini...@filmakademie.de]

Hi,

is it possible to use multiple LDAP sources / ADs for failover and/or 
round-robin load balancing?

Thanks for feedback und regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Upgrade V 2 to V 4 - No child available to handle incoming request!

[goetz.reini...@filmakademie.de]

Dear Ludovic,

> Am 17.09.2018 um 19:13 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> :
> 
> Hi Götz,
> 
> On 2018-09-17 4:08 AM, Götz Reinicke (goetz.reini...@filmakademie.de) wrote:
>> Hi,
>> 
>> I get a lot of „ No child available to handle incoming request!„ on my v4 
>> installation.
>> 
> Do you have ActiveSync clients?

Currently only I know of Active sync, so just one client at the moment.

> If you see hung processes ("child has been hanging for ..." in the sogo.log 
> file), you can always attach to the process using gdb and produce a stack 
> trace. See https://sogo.nu/support/faq/how-do-i-debug-sogo.html for details.


I do see a few „hangings“ … +- 2 a day since we switched LIVE to V4…. I 
increased the WOWorkersCount and the „available“ messages reduced in noticeable 
way.

I keep an eye on the messages and if it pops up more, I’ll collect a debug.

Regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Upgrade V 2 to V 4 - No child available to handle incoming request!

[goetz.reini...@filmakademie.de]

Hi,

I get a lot of „ No child available to handle incoming request!„ on my v4 
installation.

Workers in /etc/sysconfig/sogo is on 10 in sogo.conf WOWorkersCount = 10, 
WOListenQueueSize = 10.

As with our V2 installation where I did not get that message in the logs.

It’s on centos 7.5, Active Sync enabled wit samba AD as backend.

Any hints/suggestions? Thanks and regards . Götz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] How to add a Custom Logo/Branding to the login page - SOGo 4

[goetz.reini...@filmakademie.de]

Hi,

I followed the link from 
https://sogo.nu/support/faq/how-to-customize-the-html.html 
 and added a custom 
logo (png) to the front-page and removed the original SOGo Logo.

After a page reload the original logo is still there and my custom logo is not 
loaded.

What steps are may be missing? 

Thanks for Hints and Feedback . Götz

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

[SOGo] Confusing search in sogo 2 and 4

[goetz.reini...@filmakademie.de]

Hi,

I was asked why SOGo2 is not finding mails and so I tried to search in some of 
my folders too.

Surprise: If I search for the subject „istop“ no mail at all shows up.

Searching just for „stop“ finds mails with „stop" and even „istop“ in the 
subject.

I tested SOGo2 and 4

Any hints? Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Global carddav contact directory with samba AD, sogo4 and iOS

[goetz.reini...@filmakademie.de]

Hi,

I have SOGo 4 installed and a central adressbook is configured. From the Web FE 
I can search users and see the contact information like email address or phone 
number.

Now I’d like to use that global address book on my iOS devices too, is that 
possible? Our stuff likes to hav access to all members of our academy from a 
central directory.

I configured a card dav account on my phone but the currently only my private 
adressbook shows up.

Not the global.

Thanks for hints and suggestions. Regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Free Busy lookups from ldap Groups not expanded in Web UI SOGo 4

[goetz.reini...@filmakademie.de]

Hi Chris,

> Am 26.04.2018 um 20:38 schrieb Chris (chris2...@postbox.xyz) <users@sogo.nu>:
> 
> On Sat, 24 Mar 2018 10:30:22 +0100
> Götz Reinicke (goetz.reini...@filmakademie.de) wrote:
> 
>> adding a ldap group to the attendees for an entry dose not expands or
>> shows the users of that group. Only my timeline shows up (I m member
>> of that group). So I don’t see the free/busy time of the other group
>> members.
> 
> You're long time sogo user so you probably know this already.
> Nevertheless for the sake of completeness: LDAP groups can't be nested.
> Sogo shows only people that are directly member of the particular group.

Using SOGo for a couple of years is not a proof for knowing all features and 
options, especially if you upgrade / move from V2 to V4 … Things might change 
or improve.

Not seeing the time slots for group-members at invitation / planing time is a 
bit sad, so you first have to save the event and than you can plan it.

So maybe we have to change the workflow.

Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Free Busy lookups from ldap Groups not expanded in Web UI SOGo 4

[goetz.reini...@filmakademie.de]

Hi,

adding a ldap group to the attendees for an entry dose not expands or shows the 
users of that group. Only my timeline shows up (I m member of that group). So I 
don’t see the free/busy time of the other group members.

May be once again a little setup missing?

Thanks for hints and suggestions.

Regards . Götz


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

Re: [SOGo] Sogo and samba 4 AD authentification - SOLVED

[goetz.reini...@filmakademie.de]

Thanks to all, I got it up and running. (For now with TLS_REQCERT never).

Regards . Götz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] SOGo4, LDAP Groups and Free/Busy Time - Web UI not showing up as expected

[goetz.reini...@filmakademie.de]

Hi,

I configured LDAP groups and wanted to check the invitation and free/busy time 
visual web interface. The group shows up.

As I’m and a college are in that group too I can confirm that I’m busy at that 
time slot in question for the new event. So is the college.

But in the Web UI for the group it shows no busy at that time for the group and 
expands just me to the attendees list. If I remove the group (-)-button my name 
is also removed.

Any hints/suggestions? Regards . Götz


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

[SOGo] Sogo and samba 4 AD authentification

[goetz.reini...@filmakademie.de]

Hi,

I try to use our samba 4 ad as the user source but looks like I miss an point 
or option.

I have added a dedicated user to the ad, edited the config and restarted 
SOGo

From the logs so far I guess it’s a SSL problem.

May be someone has already a working set and can share the hints and doc how to 
use that?

Thanks & Regards . Götz


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

Re: [SOGo] SOGo V2, sieve and German umlauts - suuggestions

[goetz.reini...@filmakademie.de]

Hi Christian,

> Am 16.03.2018 um 09:30 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) <users@sogo.nu>:
> 
> Am 13.03.2018 um 13:56 schrieb Götz Reinicke
> (goetz.reini...@filmakademie.de <mailto:goetz.reini...@filmakademie.de>):
>> 
>> 
>>> Am 13.03.2018 um 13:12 schrieb Götz Reinicke 
>>> (goetz.reini...@filmakademie.de) <users@sogo.nu>:
>>> 
>>> Hi Christian,
>>> 
>>>> Am 13.03.2018 um 11:12 schrieb Christian Mack 
>>>> (christian.m...@uni-konstanz.de) <users@sogo.nu>:
>>>> 
>>>> Hello Götz
>>>> 
>>>> Am 12.03.2018 um 15:20 schrieb Götz Reinicke
>>>> (goetz.reini...@filmakademie.de):
>>>>> Hi,
>>>>> 
>>>>> an user has some mail folders with German Umlauts in the name and adding 
>>>>> sieve filters will not work.
>>>>> 
>>>>> I found some bug reports and the suggestion to change 
>>>>> „SOGoSieveFolderEncoding = UTF-8“.
>>>>> 
>>>>> https://sogo.nu/bugs/view.php?id=3904 
>>>>> <https://sogo.nu/bugs/view.php?id=3904>
>>>>> 
>>>>> Can I change that on my livesystem which is on the latest SOGo V2 without 
>>>>> breaking something? Dose the user has to recreate the filter?
>>>>> 
>>>>> On the dovecot side the folder is „Verb &- Institutionen“ so may 
>>>>> be the „&“ in the middle is a problem too?
>>>>> 
>>>>> 
>>>> 
>>>> The setting of SOGoSieveFolderEncoding must match your dovecot setting
>>>> in mail_location.
>>>> Default in Dovecot is mUTF-7-encoding
>>>> If there is a ":UTF-8" in mail_location, then you have UTF-8-encoding in
>>>> dovecot.
>>>> 
>>>> If changed in SOGo on an already productive server, you have to change
>>>> the encoding of all folders created with SOGo and non-ASCII characters
>>>> to UTF-8 with:
>>>> doveadm mailbox mutf7 -7 ${WRONG_FOLDER_NAME}
>>>> Best to do that in a script ;-)
>>> 
>>> 
>>> Hm. ok. I checked and dovecot and SOGo are configured/using utf-7 (no 
>>> :UTF-8 in dovecot conf) so the sieve filter should work by default ?!
>> 
>> More reading revealed, that pigeonhole uses UTF-8 …. already …. 
>> https://wiki.dovecot.org/Pigeonhole/Sieve/Troubleshooting 
>> <https://wiki.dovecot.org/Pigeonhole/Sieve/Troubleshooting> 
>> <https://wiki.dovecot.org/Pigeonhole/Sieve/Troubleshooting 
>> <https://wiki.dovecot.org/Pigeonhole/Sieve/Troubleshooting>>
>> 
>> So, may be it would be cool to have an pigeonhole option to set the encoding 
>> for systems which are using UTF-7 for a lng time …?
>> 
>> Or I do have to convert everything to uff-8 …
>> 
> 
> Sorry, my fault :-/
> 
> I mixed it up with changing the coding on the dovecot side in a
> production setup.
> 
> As pigeonhole already does the conversion to mUTF-7 from UTF-8 if
> needed, you have to provide folder names in sieve rules in UTF-8.
> 
> This means setting SOGoSieveFolderEncoding to "UTF-8" and afterwards
> changing (saving) again all sieve rules in SOGo, which use special
> character folders.
> 
> Sorry for the confusion.
> 

No problem, it sounded reasonable, as character encoding is always some sort of 
confusing and work especially if you run setups for a couple of years without 
doing every minor and major tweak over time. My current challenge is mysql utf8 
:( vrs. Utf8mb4 for other applications we run …. 

BTW: setting UTF-8 for SOGoSieveFolderEncoding and saving the rules 
again works!

Thanks and regards . Götz

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

Re: [SOGo] SOGo V2, sieve and German umlauts - suuggestions

[goetz.reini...@filmakademie.de]

> Am 13.03.2018 um 13:12 schrieb Götz Reinicke (goetz.reini...@filmakademie.de) 
> <users@sogo.nu>:
> 
> Hi Christian,
> 
>> Am 13.03.2018 um 11:12 schrieb Christian Mack 
>> (christian.m...@uni-konstanz.de) <users@sogo.nu>:
>> 
>> Hello Götz
>> 
>> Am 12.03.2018 um 15:20 schrieb Götz Reinicke
>> (goetz.reini...@filmakademie.de):
>>> Hi,
>>> 
>>> an user has some mail folders with German Umlauts in the name and adding 
>>> sieve filters will not work.
>>> 
>>> I found some bug reports and the suggestion to change 
>>> „SOGoSieveFolderEncoding = UTF-8“.
>>> 
>>> https://sogo.nu/bugs/view.php?id=3904 
>>> <https://sogo.nu/bugs/view.php?id=3904>
>>> 
>>> Can I change that on my livesystem which is on the latest SOGo V2 without 
>>> breaking something? Dose the user has to recreate the filter?
>>> 
>>> On the dovecot side the folder is „Verb &- Institutionen“ so may be 
>>> the „&“ in the middle is a problem too?
>>> 
>>> 
>> 
>> The setting of SOGoSieveFolderEncoding must match your dovecot setting
>> in mail_location.
>> Default in Dovecot is mUTF-7-encoding
>> If there is a ":UTF-8" in mail_location, then you have UTF-8-encoding in
>> dovecot.
>> 
>> If changed in SOGo on an already productive server, you have to change
>> the encoding of all folders created with SOGo and non-ASCII characters
>> to UTF-8 with:
>> doveadm mailbox mutf7 -7 ${WRONG_FOLDER_NAME}
>> Best to do that in a script ;-)
> 
> 
> Hm. ok. I checked and dovecot and SOGo are configured/using utf-7 (no :UTF-8 
> in dovecot conf) so the sieve filter should work by default ?!

More reading revealed, that pigeonhole uses UTF-8 …. already …. 
https://wiki.dovecot.org/Pigeonhole/Sieve/Troubleshooting 
<https://wiki.dovecot.org/Pigeonhole/Sieve/Troubleshooting>

So, may be it would be cool to have an pigeonhole option to set the encoding 
for systems which are using UTF-7 for a lng time …?

Or I do have to convert everything to uff-8 …

Regards . Götz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo V2, sieve and German umlauts - suuggestions

[goetz.reini...@filmakademie.de]

Hi Christian,

> Am 13.03.2018 um 11:12 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) <users@sogo.nu>:
> 
> Hello Götz
> 
> Am 12.03.2018 um 15:20 schrieb Götz Reinicke
> (goetz.reini...@filmakademie.de):
>> Hi,
>> 
>> an user has some mail folders with German Umlauts in the name and adding 
>> sieve filters will not work.
>> 
>> I found some bug reports and the suggestion to change 
>> „SOGoSieveFolderEncoding = UTF-8“.
>> 
>> https://sogo.nu/bugs/view.php?id=3904 <https://sogo.nu/bugs/view.php?id=3904>
>> 
>> Can I change that on my livesystem which is on the latest SOGo V2 without 
>> breaking something? Dose the user has to recreate the filter?
>> 
>> On the dovecot side the folder is „Verb &- Institutionen“ so may be 
>> the „&“ in the middle is a problem too?
>> 
>> 
> 
> The setting of SOGoSieveFolderEncoding must match your dovecot setting
> in mail_location.
> Default in Dovecot is mUTF-7-encoding
> If there is a ":UTF-8" in mail_location, then you have UTF-8-encoding in
> dovecot.
> 
> If changed in SOGo on an already productive server, you have to change
> the encoding of all folders created with SOGo and non-ASCII characters
> to UTF-8 with:
> doveadm mailbox mutf7 -7 ${WRONG_FOLDER_NAME}
> Best to do that in a script ;-)


Hm. ok. I checked and dovecot and SOGo are configured/using utf-7 (no :UTF-8 in 
dovecot conf) so the sieve filter should work by default ?!

I’m confused @-) Any hints?

Regards . Götz


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

Re: [SOGo] Sieve and subfolders

[goetz.reini...@filmakademie.de]

Hi,

> Am 11.03.2018 um 11:35 schrieb Daniel - Infosoft Proyectos Informáticos 
> (dan...@infosoft.es) :
> 
> Version Sogo :  4
>  
> I use the "." as a folder separator in my Dovecot configuration.
>  
> The .sieve file that SOGO does, uses the "/" symbol for the subfolders.
>  
> Can I change the configuration to use ".“?


do you notice any problem using that setup? An user whose setup looks like 
yours told me that it works for him.


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

[SOGo] SOGo V2, sieve and German umlauts - suuggestions

[goetz.reini...@filmakademie.de]

Hi,

an user has some mail folders with German Umlauts in the name and adding sieve 
filters will not work.

I found some bug reports and the suggestion to change „SOGoSieveFolderEncoding 
= UTF-8“.

https://sogo.nu/bugs/view.php?id=3904 

Can I change that on my livesystem which is on the latest SOGo V2 without 
breaking something? Dose the user has to recreate the filter?

On the dovecot side the folder is „Verb &- Institutionen“ so may be the 
„&“ in the middle is a problem too?

Thanks for feedback and suggestions. Regards . Götz


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

[SOGo] SOGo 4 for Test on new server with SOGo 2 Database from live system

[goetz.reini...@filmakademie.de]

Hi,

for some system maintenance I’d like to install SOGo on a new server and as V4 
is released it sounds good to give it a try.

But I’d like to use the V2 for some time too as this is the productive system 
we currently use.

As far as I understand the upgrade notes (online at inverse homepage and from 
mailings in the past), I can install a new server from scratch, point the 
Database connection to the V2-used DB and run the upgrade mysql script for 
using the 6-tables-per-user script which is provided with the V4 installation.

True?

BTW: What is the biggest benefit to move to the lean 9 table DB layout? Can I 
migrate later the multi table layout to the lean one?

Thanks for hints, feedback and suggestion! Regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Invitation reminders pop up - Calendar is already removed

[goetz.reini...@filmakademie.de]

Hi,

we have the problem that for a group of users the invitation for an appointment 
pops up regularly, although the calendar is deleted. How can we stop the 
appointment showing up?

Regards . Götz




smime.p7s
Description: S/MIME cryptographic signature

[SOGo] One-Day Recurring event shows up on Saturday and Sunday

[goetz.reini...@filmakademie.de]

Hi,

an user has a birthday calendar with yearly recurring entries. For one entry we 
noticed, that it shows up correct in 2016 and 2018. But this year (2017) the 
birthday is on Saturday and also shows up on Sunday.

Any hints? 

Regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] Private personal calendar shows up twice for one user

[goetz.reini...@filmakademie.de]

Hi,

one user told me, she had the private personal calendar twice showing up in 
SOGo one time normal labeled in black letters, the other in light grey letters.

She can add and edit entries in the black labeled one and the changes show up 
too in the grey lettered one.

That calendar can’t be deleted.

Any hints?

Thanks and regards . Götz

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Problem after power failure - MySQL4Channel primaryFetchAttributes:withZone

[goetz.reini...@filmakademie.de]

Am 05.07.17 um 14:04 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Am 05.07.2017 um 11:15 schrieb Götz Reinicke - IT Koordinator
> (goetz.reini...@filmakademie.de):
>> Hi,
>>
>> some time ago we had a server crash because of a power failure. Today I
>> noticed, that there are some error messages in the SOGo-Log like:
>>
>> 2017-07-05 11:09:07.458 sogod[3690] ERROR(-[MySQL4Channel
>> primaryFetchAttributes:withZone:]): <MySQL4Channel[0x0x7f2baa443a98]
>> connection=0x0x7f2baa4441a0>: got no value for column:
>>   attribute=c_foldername
>>   valueClass=NSString
>>   type=VARCHAR
>>
>>
>>
>> BTW I noticed, that one of my test-calendars hast changed his name to an
>> ID number from a given name.
>>
>>
>> Any hints ?? I bet there are some more problems users did not report yet.
>>
> You should check your data with sogo-tool:
> /usr/sbin/sogo-tool checkup ALL
>
> This will show you, which users have defect data.
> Then you can then restore their data from backups

Hi Christian, thanks for your feedback.

The Tool only shows one user with problems, and I do see a lot of this
message. Also some other errors too:

Jul 06 08:58:58 sogod [24401]: [ERROR]
<0x42E80498[SOGoAppointmentFolder]:snicke_55E-52EA2480-D-48140300>
missing exception record for recurrence-id 2016-09-26 11:00:00 +
(uid 1086db3a-0456-4c71-93a5-8b72d33d794c)


Strange ... Any ideas?

Regards . Götz





smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] Problem after power failure - MySQL4Channel primaryFetchAttributes:withZone

[goetz.reini...@filmakademie.de]

Hi,

some time ago we had a server crash because of a power failure. Today I
noticed, that there are some error messages in the SOGo-Log like:

2017-07-05 11:09:07.458 sogod[3690] ERROR(-[MySQL4Channel
primaryFetchAttributes:withZone:]): : got no value for column:
  attribute=c_foldername
  valueClass=NSString
  type=VARCHAR



BTW I noticed, that one of my test-calendars hast changed his name to an
ID number from a given name.


Any hints ?? I bet there are some more problems users did not report yet.

Regards . Götz





smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] Searching / subscribing to a simple posix user calendar

[goetz.reini...@filmakademie.de]

Hi,

we have some posix user accounts for e.g. some departements. No E-Mail,
no Phone, no first name etc.

What might be the best way to subscribe to the shared calendar from such
accounts? I can't search them in the SOGO web UI.

May be I can just use the URL?

Thanks for suggestions. Regards . Götz





smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] How to debug "Invalid credentials (0x31) INFO:{"error_code" = 49"

[goetz.reini...@filmakademie.de]

Hi,

an user told me he cant login to SOGo and gets an error ""

In the SOGo logs I do see a lot of "Invalid credentials (0x31) 
INFO:{"error_code" = 49" from different users, which never spoke to me 
about a problem.


May be they did not realise it yet :)

As far as I know the users can login to all other systems, like WIFI, 
WIKI, PCs etc with the same credentials. The user backend is OpenLdap.



Any ideas what and how to debug?

Thanks and regards . Götz



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Getting an E-Mail notification when an entry is changed in a subscribed calendar?

[goetz.reini...@filmakademie.de]

Hi,

Am 21.03.17 um 11:55 schrieb Christian Mack 
(christian.m...@uni-konstanz.de):

Hello

Am 21.03.2017 um 08:38 schrieb Götz Reinicke - IT Koordinator
(goetz.reini...@filmakademie.de):

Hi,

we got asked, if it is possible that a subscriber can get an E-Mail
notification for new/changed entries in calendars?

E.g. a student is subscribed to "Lecturs first year". The calendar owner
edits an entry. The student get's an E-Mail.


That is possible, but the owner of the calendar has to configure it.
He can set an email in calendar "Properties" -> "Notifications" -> "When
I modify my calendar, send a mail to" and activate that option.

That is restricted to one email address.
Therefore I would use a mailinglist, where all students are members in
your case.

as always: Thanks for that suggestion! I'll try to figure something out.

cheers . Götz




smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] Getting an E-Mail notification when an entry is changed in a subscribed calendar?

[goetz.reini...@filmakademie.de]

Hi,

we got asked, if it is possible that a subscriber can get an E-Mail 
notification for new/changed entries in calendars?


E.g. a student is subscribed to "Lecturs first year". The calendar owner 
edits an entry. The student get's an E-Mail.


Thnaks for hints and feedback . Greetings Götz





smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] OGo*tmp files in /tmp - leftovers?

[goetz.reini...@filmakademie.de]

Hi,

Am 06.03.17 um 14:29 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Am 06.03.2017 um 10:53 schrieb Götz Reinicke - IT Koordinator
> (goetz.reini...@filmakademie.de):
>> Hi,
>>
>> I see a lot of up to 1GB big files in /tmp like OGo49B058BD278A0B.tmp
>>
>> As they consumed all disk space we had some problems, so i was searching
>> for an answer what are the files for and can they removed at some point?
>>
> Those files will be created, when someone uploads files to SOGo.
> Which means when someone attaches a file to her email or imports address
> books or calendars those files will be created.
> Normally those will be removed after usage.
> But sometimes they will be left behind.
> Therefore we at the University of Konstanz have added the following to
> /etc/cron.daily/sogo-tmpwatch
>
> # Remove files in /tmp which are older than 7 days and starting with "OGo".
> # Those are uploaded attachments not already send.
> find /tmp -maxdepth 1 -type f -atime +7 -name 'OGo*' -delete
>
>
> Be aware, that installing a new sogo version, will overwrite that file.
> Because of that you have to add that again after updates, or you could
> add it to /etc/cron.d/sogo
>
Thanks Christian, I'll check my cron settings.

For curiosity, why might a file get 1GB big? Are our students trying to
upload so big files? I hope not :)

Regards . Götz

-- 

Filmakademie Baden Württemberg <http://www.filmakademie.de/>

Götz Reinicke
IT-Koordinator
IT-OfficeNet
+49 7141 969 82420
goetz.reini...@filmakademie.de <mailto:goetz.reini...@filmakademie.de>

Filmakademie Baden-Württemberg GmbH
Akademiehof 10 71638 Ludwigsburg
http://www.filmakademie.de

Twitter <https://twitter.com/filmakademiebw>Facebook
<https://de-de.facebook.com/filmakademiebw> Youtube
<https://www.youtube.com/user/TheFilmakademie>  Vimeo
<https://vimeo.com/filmakademiebw>

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrates:
Petra Olschowski
Staatssekretärin im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg

Geschäftsführer:
Prof. Thomas Schadt



smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] OGo*tmp files in /tmp - leftovers?

[goetz.reini...@filmakademie.de]

Hi,

I see a lot of up to 1GB big files in /tmp like OGo49B058BD278A0B.tmp

As they consumed all disk space we had some problems, so i was searching
for an answer what are the files for and can they removed at some point?

Thanks for feedback and regards . Götz









smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Calendar Event is duplicated when moved between calendars on iOS devices

[goetz.reini...@filmakademie.de]

Hi Andy,

thanks, so I can cross check with my devices.

I started with created on iPhone moved on iPhone -> duplicated

and in the sogo log i have:


Nov 30 16:22:05 sogod [12489]: [ERROR]
<0x4E90F588[SOGoAppointmentFolder]:4B7-51C1B080-3-72BFEC00> DAV property
'{http://calendarserver.org/ns/}created-by' has no matching SQL field,
response could be incomplete
Nov 30 16:22:05 sogod [12489]: [ERROR]
<0x4E90F588[SOGoAppointmentFolder]:4B7-51C1B080-3-72BFEC00> DAV property
'{http://calendarserver.org/ns/}updated-by' has no matching SQL field,
response could be incomplete
Nov 30 16:22:05 sogod [12489]: [ERROR]
<0x4E90F588[SOGoAppointmentFolder]:4B7-51C1B080-3-72BFEC00> DAV property
'{urn:ietf:params:xml:ns:caldav}schedule-tag' has no matching SQL field,
response could be incomplete




May be that is a hint?

Regards . Götz

Am 30.11.16 um 12:59 schrieb "Andreas Blaha" (andr...@blaha.at):
>
> Hello Götz,
>
> I have tried to move one appointment created in the WebGUI, one
> created in Outlook / ActiveSync and one each on my IOS devices, one
> being an iPad 3, IOS 9.3.5, one an iPhone 6 on IOS 10.1.1. All
> appointments can be moved on both devices without being duplicated.
>
> Hope this helps?
>
>  
>
> Regards
>
> Andy
>
>  
>
> *Von:*users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] *Im Auftrag
> von *Götz Reinicke - IT Koordinator
> *Gesendet:* Mittwoch, 30. November 2016 09:45
> *An:* users@sogo.nu
> *Betreff:* Re: [SOGo] Calendar Event is duplicated when moved between
> calendars on iOS devices
>
>  
>
> Hi Andy,
>
> can you tell me how you tried that? so where did you add the Event at
> first? on the phone?
> What is your iOS device and version?
>
> I try to figure out in what constelation that happens.
>
> Thanks a lot! /Götz
>
<...>


smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Calendar Event is duplicated when moved between calendars on iOS devices

[goetz.reini...@filmakademie.de]

Hi Andy,

can you tell me how you tried that? so where did you add the Event at
first? on the phone?
What is your iOS device and version?

I try to figure out in what constelation that happens.

Thanks a lot! /Götz


Am 29.11.16 um 18:41 schrieb "Andreas Blaha" (andr...@blaha.at):
> Hello Götz,
> I tried, I cannot reproduce this behaviour. I am running 2.3.17 though.
> Best
> Andy
>
> -Ursprüngliche Nachricht-
> Von: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Im Auftrag von Götz 
> Reinicke - IT Koordinator
> Gesendet: Dienstag, 29. November 2016 16:05
> An: users <users@sogo.nu>
> Betreff: [SOGo] Calendar Event is duplicated when moved between calendars on 
> iOS devices
>
> Hi,
>
> can someone with an iOS device reproduce that or is it just our
> installation?
>
> https://sogo.nu/bugs/view.php?id=3776
>
> Thanks for feedback and regards . Götz
>
>
>
>


-- 

Filmakademie Baden Württemberg <http://www.filmakademie.de/>

Götz Reinicke
IT-Koordinator
IT-OfficeNet
+49 7141 969 82420
goetz.reini...@filmakademie.de <mailto:goetz.reini...@filmakademie.de>

Filmakademie Baden-Württemberg GmbH
Akademiehof 10 71638 Ludwigsburg
http://www.filmakademie.de

Twitter <https://twitter.com/filmakademiebw>Facebook
<https://de-de.facebook.com/filmakademiebw> Youtube
<https://www.youtube.com/user/TheFilmakademie>  Vimeo
<https://vimeo.com/filmakademiebw>

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrates:
Petra Olschowski
Staatssekretärin im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg

Geschäftsführer:
Prof. Thomas Schadt



smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] Calendar Event is duplicated when moved between calendars on iOS devices

[goetz.reini...@filmakademie.de]

Hi,

can someone with an iOS device reproduce that or is it just our
installation?

https://sogo.nu/bugs/view.php?id=3776

Thanks for feedback and regards . Götz





smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] can't change calendar - appointment get's copied

[goetz.reini...@filmakademie.de]

Hi,

I have two calendars and I can't move an appointment from one calendar
to the other; the appointment get's duplicated.

This happends on my iphone ios 10.1.1 tested.

Any hints? Regards . Götz



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] SOGo Webinterface timeout

[goetz.reini...@filmakademie.de]

Am 21.11.16 um 16:42 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Am 21.11.2016 um 11:57 schrieb Götz Reinicke - IT Koordinator
> (goetz.reini...@filmakademie.de):
>> Hi,
>>
>> where/how set I the time out for a web session? Is that possible for
>> single users individually?
>>
> You set it in your sogo cron job.
<..>

One more question; would the "Refresh View" preference in SOGo extend
the session? Or is the session based on the last "click" of an user?

regards . Götz




smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] SOGo Webinterface timeout

[goetz.reini...@filmakademie.de]

Am 21.11.16 um 16:42 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Am 21.11.2016 um 11:57 schrieb Götz Reinicke - IT Koordinator
> (goetz.reini...@filmakademie.de):
>> Hi,
>>
>> where/how set I the time out for a web session? Is that possible for
>> single users individually?
>>
> You set it in your sogo cron job.
> Check /etc/cron.d/sogo
> There is a line with
> "... /usr/sbin/sogo-tool expire-sessions ..."
> Normally you want to run this every minute.
> The number at the end defines the time in minutes a session can exist.
>
> This works for all users.
> If you want to kill the session of one user only, you have to go to the
> session table defined by OCSSessionsFolderURL and delete the entry for
> that user by hand.
Hi Mark,

So simple :) As always: Thanks!

cheers . Götz




smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] SOGo Webinterface timeout

[goetz.reini...@filmakademie.de]

Hi,

where/how set I the time out for a web session? Is that possible for
single users individually?

Thanks for hints and suggestions . Regards . Götz





smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] Foldernames with Brackets dont show up

[goetz.reini...@filmakademie.de]

Hi,

an user has renamend a folder with brackets () to a new name also with
brackets, and now the renamed folder dose not show up in SOGo,

Any hint? Suggestions?


Thanks . Götz




smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Cannot read configuration from ... Urgent - SOLVED

[goetz.reini...@filmakademie.de]

Thanks all, permisions where wrong. True :-/

/Götz



smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] Cannot read configuration from ... Urgent

[goetz.reini...@filmakademie.de]

Hi,

I tried to add the config for ldap groups to /etc/sogo/sogo.conf and got
on a restart:

<0x0x7fdc09659188[SOGoStartupLogger]> Cannot read configuration from
'/etc/sogo/sogo.conf'. Aborting

I revert the changes and used my backup config  and do get the same
error.

Now sogo is offline. Any suggestions? Hints?


Thanks and Regards . Götz





smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] Disabling auto reply to some adresses?

[goetz.reini...@filmakademie.de]

Hi,

I was wondering, if it is possible to disable auto replies to some
addresses? E.g. notifications from monitoring systems, voicemail
forwards etc.

May be that is a manual edit job for the sieve file? ... Would it be
owerwritten if SOGo changes something?

Regards . Götz



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Sogo upgrade from V2.3.0 to V3

[goetz.reini...@filmakademie.de]

Hi,

If you run something „special“ like the Zentyal system and they offer packages 
for SOGo V2, it might be a god idea to ask them to release an update and doc on 
how to use SOGo V3….

As Chris noted, there might be an other stop for you regarding the open change 
part.

If you update SOGo from the sources … you might break you Zentyal installation 
etc ….

my2cents.

Götz


> Am 25.05.2016 um 18:35 schrieb Amit Armoogum (armoo...@silkan.net) 
> :
> 
> Hi Christian
> 
>Many thanks for your reply.
> 
>Well on zentyal, things do not work with repos,
> 
>I mean there are specific repos for Zentyal and as Sogo is considered as a 
> Zentyal module it doesn't upgrade on zentyal repos because Sogo V3 has not 
> been included on Zentyal repos yet
> 
>Yes I am also using OpenChange, Webmail, Samba, Spamassassin, Clamav, 
> Amavis all of them bundled in Zentyal modules.
> 
>Oh I wasn't aware of this new release. thanks for the info.
> 
>I guess I will have to run a classical update by adding the Sogo V3 repos 
> to my apt list.
> 
>I hope and I pray I will not get into trouble! (I've backuped my VM by 
> snapshotting it ... )
> 
>I'll keep you all updated...
> 
> Amen :)
> 
> 
> 
> 
> 
> 
> 
> On 25/05/2016 18:10, Christian Mack (christian.m...@uni-konstanz.de) wrote:
>> Hello
>> 
>> Which repos do you use?
>> You have to switch to the v3 ones.
>> Then update sogo via apt and reinstall sope.
>> That is all.
>> 
>> But if you also use openchange, you better should wait for the announced
>> update of that to the new samba version.
>> 
>> 
>> Kind regards,
>> Christian Mack
<…>
 

smime.p7s
Description: S/MIME cryptographic signature