[SOGo] BTS activities for Thursday, July 06 2017

2017-07-06 Thread SOGo reporter 
Title: BTS activities for Thursday, July 06 2017





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Thursday, July 06 2017

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
4217
	2017-07-06 10:27:56
	updated (open)
	ActiveSync
	EAS - Android contact sync
	
	  
	
4216
	2017-07-06 02:50:20
	updated (open)
	Backend Calendar
	Modification of event using admin account is impossible
	
	  
	
4218
	2017-07-06 15:07:15
	updated (open)
	Backend Calendar
	Calendar: missed notifications cannot be cancelled
	
	  
	
3636
	2017-07-06 11:59:13
	updated (open)
	Backend Mail
	SOGo Sieve architecture weird
	
	  
	
4215
	2017-07-06 09:04:05
	updated (open)
	Packaging (Debian)
	Debian 9: Cannot install sogo-activesync due to package dependence issue
	
	  
	
4210
	2017-07-06 19:16:40
	updated (open)
	Web Mail
	WEb mail not displaying when INBOX has many messages ( 15000)
	
	  
	
4220
	2017-07-06 20:25:29
	updated (open)
	Web Mail
	Link of attachment in web mail editor points to the sogo app server IP/port behind webserver
	
	  
	
4221
	2017-07-06 17:23:29
	updated (open)
	Web Mail
	in FF, mail editor, when mail gets larger than editor window, mail jumps on nearly every character
	
	  
	
4222
	2017-07-06 22:45:04
	updated (open)
	Web Mail
	MySQL based setup does not allow select-able e-mail From addresses
	
	  
	
4219
	2017-07-06 10:29:00
	updated (open)
	Web Preferences
	Web: Unable to save settings
	
	  
	
4008
	2017-07-06 20:31:33
	feedback (reopened)
	GUI
	Can't scroll in the window where mail content is displayed on Firefox
	
	  
	
  
  


-- users@sogo.nuhttps://inverse.ca/sogo/lists

[SOGo] Web: Unable to save settings

2017-07-06 Thread Ralf Cirksena 
Hello,

today we updated SOGo from 3.2.9 to 3.2.10. Now $USER cannot save
preferences. Error message: "Service temporarily unavailable".
 

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

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

2017-07-06 Thread Christian Mack 
Hello

Am 06.07.2017 um 09:01 schrieb Götz Reinicke - IT Koordinator
(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:]): >> 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?
> 

Those error message says:
In calendar with UID "55E-52EA2480-D-48140300" from user "snicke" is a
recurring event (uid 1086db3a-0456-4c71-93a5-8b72d33d794c) with
exeptions, where exeption at "2016-09-26 11:00:00 +" is missing.

So those are broken recurring events.

As it is only one user, you should delete him and restore from backup.


Kind regrds,
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] Problem after power failure - MySQL4Channel primaryFetchAttributes:withZone

2017-07-06 Thread 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:]): > 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

Re: [SOGo] free busy information

2017-07-06 Thread Christian Mack 
Am 05.07.2017 um 15:26 schrieb Ralf Cirksena (c...@holmco.de):
> Hello,
> 
> if a MS-Outlook user subscribes an other user's calendar from the web
> interface the setting "include in free/busy" is preselected.
> That's what the users here don't expect. Events in a subscribed
> calendar keeps blocking available time slots in the user's calender
> who subscribed it.
> 
> Is there a way to change this from "opt out" to "opt in"? E.g. it's
> unset when subscribing the calendar?
> 

Are you using the newest SOGo version?
There was a bug, that did that.
In the newest versions 2 + 3 that is fixed, and subscribed calendars are
not included in free/busy per default.

> How can we reset the option in all user's subscriptions (batch,
> script, whatever)?
>

You could do that via sogo-tool in a script.
It is a bit tricky, because you need to change the "FreeBusyExclusions"
part of "Calendar".
Therefore I would make a backup of all accounts, change the free busy
exclusion and restore the settings again (restore option -p).

> Btw: What *exactly* is the intended effect of "include in free/busy"?
>

Free/busy is shown, when you invite other peoples to an event.
With that you can see, if the invited person has already an appointment
or not at this date and time.

If you use resource accounts, they will only accept appointments, when
free at that time (or there are less appointments as defined as max)

For subscribed calendars:
Some of our users for example have a department meeting calendar.
Everyone from that department has change privileges on it,
That one contains meetings, where everyone in that department will be
participating.
Therefore all of them have it subscribed and selected to include it in
their free/busy.
When a meeting is stored in that calendar, everyone from that department
will be shown as busy at its duration.

You could do that by using one person and invite all other paticipants.
But the down side of that is, that only this owner could change that
event, without having change permissions in the owners (personal) calendar.
And if you do not provide groups, the owner would have to add all
department members to each meeting.

For own calendars:
You can create a calendar, which only gives you hints, like birthdays of
your friends.
You will not be busy the whole day, but you need to know when they are.
Because of that you mark that birthday calendar as free by excluding it
from your free/busy.

So it depends on your users workflows and preferences, if you need that
or not.


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