[SOGo] BTS activities for Friday, July 25 2014
Title: BTS activities for Friday, July 25 2014 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Friday, July 25 2014 idlast updatestatus (resolution)categorysummary 2511 2014-07-25 12:32:59 updated (open) Apple iPhone OS r letter appended to every item: names, numbers, etc 2281 2014-07-25 10:29:01 updated (open) Backend Address Book "\r" in Vcard after import from LDIF 69 2014-07-25 09:16:26 updated (open) Web Calendar Repeating events are not shown in "All Events" or "All Future Events" 430 2014-07-25 09:16:26 updated (open) Web Calendar view all and view all future events should list the master instance of recurring events 2812 2014-07-25 06:38:44 updated (open) Web Mail Can not delete mail when over quota 2767 2014-07-25 12:37:10 feedback (reopened) Backend Calendar Users should be able to prevent being invited to appointments 893 2014-07-25 09:35:06 assigned (open) Backend General sogo-tool ability to cleanup old calendar sync tags 272 2014-07-25 09:35:06 resolved (fixed) Backend Calendar Calendar sync tag names are not released when a calendar is deleted
Re: [SOGo] Possibility to clean up old events
Hello Christian Reischl Am 2014-07-25 12:11, schrieb Christian Reischl: > > is there an easy way to clean up old events while keeping the recurring > ones? > > Especially Thunderbird gets very slow with thousands of events. Usually > you want to keep the recurring events, but it can be very difficult to > sort all of them out. > There is no automated way to do this in SOGo. See following related bug: http://www.sogo.nu/bugs/view.php?id=766 With this bug active you can manually delete non-repeating events only: http://www.sogo.nu/bugs/view.php?id=69 Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Sogo 2.2.2: sieve connection does not work
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 25.07.2014 um 15:33 schrieb Christian Mack: > Am 2014-07-25 15:08, schrieb Rasca Gmelch: >> Hi Christian, >> >> Am 25.07.2014 um 14:19 schrieb Christian Mack: >>> Hello Rasca Gmelch >> >>> Am 2014-07-23 14:38, schrieb Rasca Gmelch: sogo is installed under debian 7. I put the intermediate cert to /etc/ssl/certs and checked that also the toplevel CA cert is included in /etc/ssl/certs/. And did a "c_rehash". >> >>> On Debian and Ubuntu systems you should use >>> update-ca-certificates (packages ca-certificates). IIRC there >>> are 2 different hashing algorithms used nowaday. >>> update-ca-certificates will pick both or the correct one for >>> your system. >> >>> I don't know if that fixes your problem though. >> >> Thank you for these notes. But I think using the c_rehash >> command should also be fine, because it creates two hash links >> for every certificate. >> >> But it didn't help. It looks like debuging SSL in sogo is nearly imposibble. No usefull messages in the logfiles - I had the same bad experiance with openldap. >> >>> What does your sieve server say on this STARTTLS sessions? >> >> I see in the sogo logfile: >> >> Mar 28 15:00:21 sogod [12226]: <0x0x7f0d49d18fa0[NGSieveClient]> >> TLS started successfully. >> >> On the cyrus server logfile I see: >> >> cyrus/sieve[26762]: starttls: TLSv1 with cipher AES256-SHA >> (256/256 bits new) no authentication >> > > So STARTTLS is working fine. Which error do you get afterwards on > the sieve server? On both sides nothing happens and the webbrowser window for the sogo preferences stays empty. After some seconds a timeout occures and I see in the logfile of the sogo server: sogod [28461]: [WARN] <0x0x7fe5ed343180[WOWatchDogChild]> pid 28479 has been hanging in the same request for 1 minutes [..] sogod [28461]: [WARN] <0x0x7fe5ed343180[WOWatchDogChild]> pid 28479 has been hanging in the same request for 7 minutes The web client (firefox) returns an error - here it's a proxy error because we have an apache reverse proxy in front of the sogo service: Proxy Error: Reason: Error reading from remote server The sieve server does not give any additional lines in the logfile. Regards, Rasca - -- Rasca Gmelch | IT | JabberID: rasca.gme...@artcom.de OpenPGP Key ID: 8168E925, Key server: pool.sks-keyservers.net Fingerprint 1FD0 3199 13B7 7ADC 5DF1 A8EF FA4C 4AC0 8168 E925 ART+COM AG | Kleiststr. 23-26 | 10787 Berlin | Germany Fon: +49.30.21001-466 | Fax: +49.30.21001-555 http://www.artcom.de/ HRB 68308 | Amtsgericht Charlottenburg Vorstand: Andreas Wiek, Prof. Joachim Sauter Aufsichtsratsvorsitzender: Volker Tietgens USt-IdNr.: DE811998328 -BEGIN PGP SIGNATURE- iQIcBAEBAgAGBQJT0mAdAAoJEPpMSsCBaOklH0gQAIrFbeTIFCCQM4PG68ILSW/9 +Ojw/Mjfmrhbuugb78Rn8GCRjq90QSNJctczXi+DQm8cKt44oexD1RkVzgXmQ5ZP af2JyX8t7Ra4hCybLEAioF6I8izuKZYv8jveVVKSLdrJ86p76zFCJpUbfb8uLcCF hD0Eaom1h8iR1TKySNX9/IRabV0GbRPhaztNxyf9RgbDsGLrDOCuM65aMPy94G2a D4n2e2B6N1mfoNzXFo7Nw9u0ZGH1+pIEMsKCbP4VeXxx3eW928iswrUW3KcVP8Rs DYxODN6Q1rggjIwdvLokn5Ib44XopYfLvx9JiE5bo5FnhLbME2DE7L+iDPT1TWlk Dwpuv2NwqWO7qNPZ77xyPWQhzYS8DamT7O+aw2kMtnbkL7rt9B0b3IKg4AeIQN6p JXhvBdIFMLm/aVCuitbacUc3Zdu5M8uskpbn6R+AU3foKR7ddJXbWZqJND1LulCG j4hznc4jWYOh97p0dsn5P2C89djQ4ZmzYV9UL/Gty+Cgl4zdA1s0gdWr/zpqxaIS oavq+a46Af2WJ3xb4QrQhFx4DYrN2pmWAACHJ5SnAviE9JKr55PEWfgbhs1PJWhA iikZ20zlR8Z5kJW+VsPFihFVZ3qEuAsatyZo5P1zZ5THk5BIY/2XWPVi52SUsztb CSXThzeUAUlhRUrqsRsG =t2r4 -END PGP SIGNATURE- -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Outlook FreeBusy lookups
Hi, On 25 Jul 2014, at 14:30, Christian Mack wrote: > Hello Martin Simovic > > Am 2014-07-25 11:59, schrieb Martin Simovic: >> On 24 Jul 2014, at 17:15, Martin Simovic wrote: >> >>> Hi, >>> >>> I am trying to implement FreeBusy lookups for Outlook 2010 for meeting >>> scheduling. We are using SOGo without Openchange layer, email is accessed >>> via IMAP and calendars / contacts are synced with SOGo server via iCal4OL >>> software. >>> >>> I read in SOGo documentation that: >>> - freebusy lookups are supported using the Internet Free/Busy feature of >>> Outlook >>> - URL to use must be of the following format: >>> http:///SOGo/dav/public/%NAME%/freebusy.ifb >>> - SOGoEnablePublicAccess must be set to YES >>> >>> This works, with one limitation: Each user’s calendar ACL’s have to be >>> updated for public access (View Date and Time). Whilst there is a setting >>> SOGoCalendarDefaultRoles, this is ignored for public access. Is there >>> another way of enabling FreeBusy lookups for Outlook other than granting >>> public calendar access on user-by-user basis? >>> >>> Many thanks for any hints >>> >> >> There are at least two ways this could be achieved: >> >> 1. Have a setting like “SOGoCalendarDefaultRoles” that applies for public >> calendars >> > > This should definitely be another setting, as internal and public access > are different after all. Sure, I should have said similar setting, that does the same thing for non-authenticated users (public). > > >> 2. Embed username / password in SOGo URL, something like >> "http:///SOGo/dav/public/%NAME%/freebusy.ifb?Login=Login&Password=PW >> > Did you try the following? > http://Login:Password@/SOGo/dav/%NAME%/freebusy.ifb This unfortunately does not work, I believe because Outlook uses IE as it’s engine for http(s) access and username:password@ in URL is no more allowed for IE. So far I did not find the way to make it work old way for IE 11. Best, Martin Simovic-- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo 2.2.2: sieve connection does not work
Am 2014-07-25 15:08, schrieb Rasca Gmelch: > Hi Christian, > > Am 25.07.2014 um 14:19 schrieb Christian Mack: >> Hello Rasca Gmelch > >> Am 2014-07-23 14:38, schrieb Rasca Gmelch: >>> >>> sogo is installed under debian 7. I put the intermediate cert to >>> /etc/ssl/certs and checked that also the toplevel CA cert is >>> included in /etc/ssl/certs/. And did a "c_rehash". >>> > >> On Debian and Ubuntu systems you should use update-ca-certificates >> (packages ca-certificates). IIRC there are 2 different hashing >> algorithms used nowaday. update-ca-certificates will pick both or >> the correct one for your system. > >> I don't know if that fixes your problem though. > > Thank you for these notes. But I think using the c_rehash command > should also be fine, because it creates two hash links for every > certificate. > > >>> But it didn't help. It looks like debuging SSL in sogo is nearly >>> imposibble. No usefull messages in the logfiles - I had the same >>> bad experiance with openldap. >>> > >> What does your sieve server say on this STARTTLS sessions? > > I see in the sogo logfile: > > Mar 28 15:00:21 sogod [12226]: <0x0x7f0d49d18fa0[NGSieveClient]> TLS > started successfully. > > On the cyrus server logfile I see: > > cyrus/sieve[26762]: starttls: TLSv1 with cipher AES256-SHA (256/256 > bits new) no authentication > So STARTTLS is working fine. Which error do you get afterwards on the sieve server? Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Sogo 2.2.2: sieve connection does not work
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Christian, Am 25.07.2014 um 14:19 schrieb Christian Mack: > Hello Rasca Gmelch > > Am 2014-07-23 14:38, schrieb Rasca Gmelch: >> >> sogo is installed under debian 7. I put the intermediate cert to >> /etc/ssl/certs and checked that also the toplevel CA cert is >> included in /etc/ssl/certs/. And did a "c_rehash". >> > > On Debian and Ubuntu systems you should use update-ca-certificates > (packages ca-certificates). IIRC there are 2 different hashing > algorithms used nowaday. update-ca-certificates will pick both or > the correct one for your system. > > I don't know if that fixes your problem though. Thank you for these notes. But I think using the c_rehash command should also be fine, because it creates two hash links for every certificate. > >> But it didn't help. It looks like debuging SSL in sogo is nearly >> imposibble. No usefull messages in the logfiles - I had the same >> bad experiance with openldap. >> > > What does your sieve server say on this STARTTLS sessions? I see in the sogo logfile: Mar 28 15:00:21 sogod [12226]: <0x0x7f0d49d18fa0[NGSieveClient]> TLS started successfully. On the cyrus server logfile I see: cyrus/sieve[26762]: starttls: TLSv1 with cipher AES256-SHA (256/256 bits new) no authentication Regards, Rasca - -- Rasca Gmelch | IT | JabberID: rasca.gme...@artcom.de OpenPGP Key ID: 8168E925, Key server: pool.sks-keyservers.net Fingerprint 1FD0 3199 13B7 7ADC 5DF1 A8EF FA4C 4AC0 8168 E925 ART+COM AG | Kleiststr. 23-26 | 10787 Berlin | Germany Fon: +49.30.21001-466 | Fax: +49.30.21001-555 http://www.artcom.de/ HRB 68308 | Amtsgericht Charlottenburg Vorstand: Andreas Wiek, Prof. Joachim Sauter Aufsichtsratsvorsitzender: Volker Tietgens USt-IdNr.: DE811998328 -BEGIN PGP SIGNATURE- iQIcBAEBAgAGBQJT0laxAAoJEPpMSsCBaOklcsAQAJH69PrEF6NTWSByAxkt9/F0 WvfgBVaT8ys0qBz/PiaD/SGNu2PQBT74M1QDkrhamP4yg9lRP9GF1lAP2BUy7XVq ojZvYNQweuKcwZ965ZF9+4Ir4uTMIHQUicQDwi6BwQN25ZGiR8uLXTexKtC7ZMCz RLsq7UJ/ingvuE4wjfpZrSbpIpQueRmB/olNv6OTNQEh8JIg5AsZLe132CWC7z/5 qSjuv+jusmS6rBOOgu3gnn44yiDc9md8O80lO0vSr24chJPqWnFp5KWN/P+0/s6M bhPrBe9UShyeehWtE/cKFWUI5omXV3HnS6YRNo6AZ1MSSgyPYpctqBYo+r0+xKiY 7IT3mLzhPOoWtMm6y6rpKNq3IwM/Q1/PWylP4nsSTkgc8Qz13uEGL/T/Fm/hebNl 6Mytkli9Ds8IFNhCCE8NZzFZqOJ8ZfY6Dnztqr7+8sHAA4/XbpSSOz4dTOqldI+d snOxccyYCzDeLpP4wJvDxfxQVDHX0em95VTX11j3dQ39I290r5DNOdweb4Q/ixN6 YB6wAd6zMgPM1bTWBMuKiTofx+71QszzwM6MOsdwNlzcGViYAoHl1oac3TPrt4LN 94KGG+yWdKtF02zTTI/F9to1VQW6AsHrNCDSoZ9Ayddk0O0blF+u45aN68Z6BvES zJeXRy1lHUvdmPygAE8x =PnxT -END PGP SIGNATURE- -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Outlook FreeBusy lookups
If you need to set the properties (e.g. View Date and Time) for each
user, that could be done with sogo-tool (I hope so). I think it can be
achived in this way:
1. First export all sogo user into one folder:
sogo-tool backup my_backup_folder ALL
In that way you will get one file per sogo user in my_bacup_folder.
2. Write and execute script that will read all file names (users name)
from backup folder and set the properties for each of them. Something
like following:
for i in $( ls /home/sogo/my_backup_folder/); do
echo "Processing $i user..."
sudo -u sogo sogo-tool user-preferences set defaults %i
SOGoTimeFormat '{"SOGoTimeFormat": "%H:%M"}'
done
You will need to change SOGoTimeFormat settings to
SOGoCalendarDefaultRoles or something else you would like to set.
Regards,
Igor
Martin Simovic wrote on 25/07/2014 11:59:
On 24 Jul 2014, at 17:15, Martin Simovic > wrote:
Hi,
I am trying to implement FreeBusy lookups for Outlook 2010 for
meeting scheduling. We are using SOGo without Openchange layer, email
is accessed via IMAP and calendars / contacts are synced with SOGo
server via iCal4OL software.
I read in SOGo documentation that:
- freebusy lookups are supported using the Internet Free/Busy feature
of Outlook
- URL to use must be of the following format:
http:///SOGo/dav/public/%NAME%/freebusy.ifb
- SOGoEnablePublicAccess must be set to YES
This works, with one limitation: Each user’s calendar ACL’s have to
be updated for public access (View Date and Time). Whilst there is a
setting SOGoCalendarDefaultRoles, this is ignored for public access.
Is there another way of enabling FreeBusy lookups for Outlook other
than granting public calendar access on user-by-user basis?
Many thanks for any hints
There are at least two ways this could be achieved:
1. Have a setting like “SOGoCalendarDefaultRoles” that applies for
public calendars
OR
2. Embed username / password in SOGo URL, something like
"http:///SOGo/dav/public/%NAME%/freebusy.ifb?Login=Login&Password=PW
Is any of the above possible?
Regards
Martin.
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] Outlook FreeBusy lookups
Hello Martin Simovic Am 2014-07-25 11:59, schrieb Martin Simovic: > On 24 Jul 2014, at 17:15, Martin Simovic wrote: > >> Hi, >> >> I am trying to implement FreeBusy lookups for Outlook 2010 for meeting >> scheduling. We are using SOGo without Openchange layer, email is accessed >> via IMAP and calendars / contacts are synced with SOGo server via iCal4OL >> software. >> >> I read in SOGo documentation that: >> - freebusy lookups are supported using the Internet Free/Busy feature of >> Outlook >> - URL to use must be of the following format: >> http:///SOGo/dav/public/%NAME%/freebusy.ifb >> - SOGoEnablePublicAccess must be set to YES >> >> This works, with one limitation: Each user’s calendar ACL’s have to be >> updated for public access (View Date and Time). Whilst there is a setting >> SOGoCalendarDefaultRoles, this is ignored for public access. Is there >> another way of enabling FreeBusy lookups for Outlook other than granting >> public calendar access on user-by-user basis? >> >> Many thanks for any hints >> > > There are at least two ways this could be achieved: > > 1. Have a setting like “SOGoCalendarDefaultRoles” that applies for public > calendars > This should definitely be another setting, as internal and public access are different after all. > 2. Embed username / password in SOGo URL, something like > "http:///SOGo/dav/public/%NAME%/freebusy.ifb?Login=Login&Password=PW > Did you try the following? http://Login:Password@/SOGo/dav/%NAME%/freebusy.ifb Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Sogo 2.2.2: sieve connection does not work
Hello Rasca Gmelch Am 2014-07-23 14:38, schrieb Rasca Gmelch: > > sogo is installed under debian 7. I put the > intermediate cert to /etc/ssl/certs and > checked that also the toplevel CA cert is > included in /etc/ssl/certs/. And did a > "c_rehash". > On Debian and Ubuntu systems you should use update-ca-certificates (packages ca-certificates). IIRC there are 2 different hashing algorithms used nowaday. update-ca-certificates will pick both or the correct one for your system. I don't know if that fixes your problem though. > But it didn't help. It looks like debuging > SSL in sogo is nearly imposibble. No usefull > messages in the logfiles - I had > the same bad experiance with openldap. > What does your sieve server say on this STARTTLS sessions? > Anyway for now I use stunnel4 to pass it > over the net. > Yes, that's an easy workaround. Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
[SOGo] Possibility to clean up old events
Hi, is there an easy way to clean up old events while keeping the recurring ones? Especially Thunderbird gets very slow with thousands of events. Usually you want to keep the recurring events, but it can be very difficult to sort all of them out. Regards, Christian -- __ Christian Reischl Fraunhofer Institut für Verfahrenstechnik und Verpackung Giggenhauser Str. 35 85354 Freising Tel.: +49 8161 491-704 mailto:christian.reis...@ivv.fraunhofer.de http://www.ivv.fraunhofer.de/ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Outlook FreeBusy lookups
On 24 Jul 2014, at 17:15, Martin Simovic wrote: > Hi, > > I am trying to implement FreeBusy lookups for Outlook 2010 for meeting > scheduling. We are using SOGo without Openchange layer, email is accessed via > IMAP and calendars / contacts are synced with SOGo server via iCal4OL > software. > > I read in SOGo documentation that: > - freebusy lookups are supported using the Internet Free/Busy feature of > Outlook > - URL to use must be of the following format: > http:///SOGo/dav/public/%NAME%/freebusy.ifb > - SOGoEnablePublicAccess must be set to YES > > This works, with one limitation: Each user’s calendar ACL’s have to be > updated for public access (View Date and Time). Whilst there is a setting > SOGoCalendarDefaultRoles, this is ignored for public access. Is there another > way of enabling FreeBusy lookups for Outlook other than granting public > calendar access on user-by-user basis? > > Many thanks for any hints > There are at least two ways this could be achieved: 1. Have a setting like “SOGoCalendarDefaultRoles” that applies for public calendars OR 2. Embed username / password in SOGo URL, something like "http:///SOGo/dav/public/%NAME%/freebusy.ifb?Login=Login&Password=PW Is any of the above possible? Regards Martin. -- users@sogo.nu https://inverse.ca/sogo/lists
