[SOGo] BTS activities for Monday, May 30 2016

[SOGo reporter]

Title: BTS activities for Monday, May 30 2016





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Monday, May 30 2016

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
3703
	2016-05-30 04:03:58
	updated (open)
	with SOGo
	Adaptors-4.9/MySQL.gdladaptor/stamp.make: No such file or directory >> *** Error code 74
	
	  
	
3693
	2016-05-30 04:04:38
	feedback (reopened)
	ActiveSync
	Outlook 2013 does not show (all) Elements
	
	  
	
3109
	2016-05-30 11:45:19
	resolved (fixed)
	Backend General
	Sogo group error on new install (Debian - amd64)
	
	  
	
2339
	2016-05-30 12:46:07
	resolved (fixed)
	Documentation
	Incomplete description of IMAPHostFieldName and SieveHostFieldName parameters
	
	  
	
  
  


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

Re: [SOGo] Updating...

[Patrice Levesque]

> It seems a critical bug : if this is the result expected, a big
> warning should be printed before the execution, otherwise a patch is
> needed to keep user data safe.

For each of those “combined” migration scripts I just added a big fat
warning that prompts the user, to ensure nobody runs them by mistake
again.

Let me restate, the “combined” data model is *optional* and is not part
of any standard upgrade routine.



-- 
Patrice Levesque
pleves...@inverse.ca  ::  +1.514.447.4918 *140  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)



signature.asc
Description: Digital signature

Re: [SOGo] SQL and MailFieldNames

[Christian Mack]

Hello

Am 30.05.2016 um 15:40 schrieb Jesse Schlüter (je...@helix360.de):
> Hello everybody,
> 
> I understand that it is possible to use MailFieldNames for an SQL
> UserSource to add additional fields, that each contain one address.
> Unfortunately a user may have an undefined number of aliases and I
> want each user to be able to use all of his aliases.
> 
> So I looked for a way to combine all aliases residing in a certain
> table to be CONCATENATED in one field of the users view. Using
> GROUP_CONCAT, I now have a field containg all aliases, but I cannot
> find any way SOGo actually uses this single field as an array.
> 
> Is there any way to get this working?
> 

Not with Database as authentication source.
This is always possible with LDAP or AD as authentication source, as
these specify mail as multivalue attribute.


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] SQL and MailFieldNames

[je...@helix360.de]

Hello everybody,

I understand that it is possible to use MailFieldNames for an SQL UserSource to 
add additional fields, that each contain one address. Unfortunately a user may 
have an undefined number of aliases and I want each user to be able to use all 
of his aliases.

So I looked for a way to combine all aliases residing in a certain table to be 
CONCATENATED in one field of the users view. Using GROUP_CONCAT, I now have a 
field containg all aliases, but I cannot find any way SOGo actually uses this 
single field as an array.

Is there any way to get this working?

Best regards,
Jesse

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

Re: [SOGo] Updating...

[Pierre Fumet]

Hello,
i had the same problem, with postgres script : db update removes all user 
tables.
It seems a critical bug : if this is the result expected, a big warning should 
be printed before the execution, otherwise a patch is needed to keep user data 
safe.

On 30 May 2016 at 12:00, from Christian Mack :

Hello

Those db scripts are only neccessary, if you want to change your db schema to 9 
Tables.

After doing so, you have to change your SOGo config accordingly.

Am 28.05.2016 um 19:21 schrieb Azam Premji (blueb...@gmail.com):

Thanks André.

After the upgrade I got the following message:
SOGo database schemas are _not_ automatically upgraded by the packaging system.

So I guessed the script to run after the install. And from the directory list 
there were two maybe possible for my install:
sql-update-3.0.0-to-combined-mysql.sh
sql-update-3.0.0-to-combined.sh

I checked MariaDB and SOGo had 53 tables. After running the script it has 9.

Since I’m using MariaDB I ran sql-update-3.0.0-to-combined-mysql.sh which gave 
the the output:
Merging tables
Patching /etc/sogo/sogo.conf….

Now no users have any Calendar items though the Calendars themselves exist. And 
for most users they have lost their address books.

Our users are drawn from LDAP and they are able to login using the Web UI but 
nothing shows up in the Global Address List. Before we could search users in 
this Global Address List. Does this mean there is a new method to enter user 
sources in SOGo.conf/defaults?

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

Re: [SOGo] SOGo 2.3.11 ngactivesocket problem

[Christian Mack]

Am 27.05.2016 um 14:41 schrieb Maxime RUBINO
(maxime.rub...@sfproduction.fr):
> Hi all,
> 
> i use nightly build of SOGo 2.3.11 and in my sogo.log i have strange
> errors :
> 
> May 27 14:37:10 sogod [25481]: [ERROR]
> <0x0x7fcda1794818[WOWatchDogChild]> FAILURE receiving status for child
> 14934
> May 27 14:37:10 sogod [25481]: [ERROR]
> <0x0x7fcda1794818[WOWatchDogChild]>   socket:
>  connectedTo=<0x0x7fcda1726e88[NGLocalSocketAddress]: /tmp/_ngsoc
> ket_25481_0x7fcda14d2f08_000> receive-timeout=1.000s>
> May 27 14:37:10 sogod [25481]: [ERROR]
> <0x0x7fcda1794818[WOWatchDogChild]>   exception:
> 
> NAME:NGSocketTimedOutException REASON:the socket was shutdown INFO:{errno =
>  11; error = "Resource temporarily unavailable"; stream = "{object =
>  connectedTo=<0x0x7fcda1726e88[NGLocalSocketAddress]:
> /tmp/_ngsocket_25481_0x7fcd
> a14d2f08_000> receive-timeout=1.000s>;}"; }
> May 27 14:37:10 sogod [25481]: <0x0x7fcda1794818[WOWatchDogChild]>
> sending terminate signal to pid 14934
> May 27 14:37:10 sogod [25481]: [ERROR]
> <0x0x7fcda1794818[WOWatchDogChild]> FAILURE notifying child 14934
> May 27 14:37:10 sogod [25481]: <0x0x7fcda1794818[WOWatchDogChild]>
> sending terminate signal to pid 14934
> 2016-05-27 14:37:10.097 sogod[14934] Forcing termination of EAS loop.
> 
> All services is OK, mysql/samba/sogo/... do you have an idea ?
> 

This means, that the SOGo watchdog can not talk to one of your SOGo workers.
That seems to be an ActiveSync one.
The watchdog will kill that worker, if it does not respond in time, in
order to prevent hanging processes.

Perhaps that is an initial sync with a big account via ActiveSync.
They can take some time and eat resources.
Check the corresponding settings in sogo.conf (and apache/nginx conf).


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] Shared Calendars via Active Sync

[Cristian Mammoli]

I filed a bug for this like 1 year ago...


http://sogo.nu/bugs/view.php?id=3180


Il 20/05/2016 09:16, Communication (communicat...@open-dsi.fr) ha scritto:

Hi

You have to grant full permission to the user you shared the calendar 
in order to have it via ActiveSync

http://permalink.gmane.org/gmane.comp.groupware.sogo.user/22341

Works for me on SOGo 3.0.2 / Debian 8 / Outlook 2013

Regards

Philippe

Le 20/05/2016 08:40, Thomas (aon) Fuehrer (t...@aon.at) a écrit :

Hi Keith,
have you enabled the synchronization via EAS in the calendar folder 
properties?

Regards,
Thomas

On Thursday, May 19, 2016 20:29 CEST, "Keith Williams" 
(ke...@blue-hat.co.za)  wrote:



 Hi everyone,


 I am testing SOGo v3.1 and created a user with a test calendar.
 Shared that calendar to another user and subscribed the user to 
the

 shared calendar.


 On the second user's SOGo web interface the shared calendar 
displays

 and works fine. Setting up the calendar in Thunderbird with DAV
 works 100%. When setting up Active Sync (Outlook 2016 and 
iPhone 5)

 the shared calendar is not displayed as it did when the same was
 done with SOGo v2.3.x


 I have a stock standard setup from packages installed via yum on
 CentOS 7.


 Nothing concerning the calendar are displayed in the logs. Any 
hints

 where I might start looking, perhaps a setting that needs to be
 enabled in sogo.conf?


 Thanks for any assistance,


 Regards









--
Mammoli Cristian
System administrator
T. +39 0731 22911
Via Brodolini 6 | 60035 Jesi (an)

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

Re: [SOGo] Shared Calendars via Active Sync

[Christian Mack]

Am 29.05.2016 um 17:33 schrieb Rolf Schirmacher (rolf_schirmac...@web.de):
> Hi Philippe,
> 
> thanks for the tip - works well for me now, too.
> 
> I just have one remaining issue:
> 
> As I use sogo just as a small family-wide installation I currenly only
> have 4 users and myself declared as superuser / admin within my sogo.conf
> As a result, I can administrate the accounts / calendars of all the
> other 3 family members, but not mine through the web interface, so I
> cannot give them access to my calendar. The search function on the web
> interface simply does not find myself... neither my user name nor the
> family name or whatever. It works well for all the others though...
> 
> Thanks in advance for any hint,
> 
< cut >

You can not manage your privileges through the administration interface,
but you can manage those by normal means.

BTW:
I would advice to use an additional account for administration because
of possible security issues.


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] Updating...

[Christian Mack]

Hello

Those db scripts are only neccessary, if you want to change your db
schema to 9 Tables.

After doing so, you have to change your SOGo config accordingly.

Am 28.05.2016 um 19:21 schrieb Azam Premji (blueb...@gmail.com):
> Thanks André.
> 
> After the upgrade I got the following message:
> SOGo database schemas are _not_ automatically upgraded by the packaging 
> system.
> 
> So I guessed the script to run after the install. And from the directory list 
> there were two maybe possible for my install:
> sql-update-3.0.0-to-combined-mysql.sh
> sql-update-3.0.0-to-combined.sh
> 
> I checked MariaDB and SOGo had 53 tables. After running the script it has 9.
> 
> Since I’m using MariaDB I ran sql-update-3.0.0-to-combined-mysql.sh which 
> gave the the output:
> Merging tables
> Patching /etc/sogo/sogo.conf….
> 
> Now no users have any Calendar items though the Calendars themselves exist. 
> And for most users they have lost their address books.
> 
> Our users are drawn from LDAP and they are able to login using the Web UI but 
> nothing shows up in the Global Address List. Before we could search users in 
> this Global Address List. Does this mean there is a new method to enter user 
> sources in SOGo.conf/defaults?
> 
> Couple of other things…
> - When installing the update I was asked if I want to allow the overwriting 
> of SOGo.conf and sogo.conf. Since I had them set the way I like I said ‘no’. 
> Since that didn’t work, I reverted the snapshot of the Virtual machine 
> (thankfully I’m able to revert). The second time I upgraded I allowed it to 
> overwrite SOGo.conf but not sogo.conf. That didn’t work.
> - Also I noticed that there were a couple of new entries in my sogo.conf for 
> OCSStoreURL and OCSAclURL. I updated them with the appropriate mysql password 
> each time I applied the upgrade. I also applied the same using the defaults 
> command and checked the files.
> 
> I’ve verified that the services are running (samba. etc).
> 
> I don’t know what else to try. Any ideas?
> 
> 
> Azam
> 
> 
> 
> 
>> On May 28, 2016, at 5:06 AM, André Schild (an...@schild.ws)  
>> wrote:
>>
>> apt-get upgrade for debian kind of systems...
>>
>> Am 27.05.2016 um 19:09 schrieb Azam Premji (blueb...@gmail.com):
>>> Hi guys,
>>>
>>> I just downloaded the latest manual and looked thru it to see if I could 
>>> find the procedure to update my existing installation from 3.0.2 to the 
>>> latest/greatest. I don’t see anything in there. It has instruction for the 
>>> 2.x versions. The FAQs don’t show anything either.
>>>
>>> Maybe I’m missing something.
>>>
>>> Can anyone point me in the right direction?
>>>
>>> Thanks!
>>>
>>> Azam
>>
>> -- 
>> users@sogo.nu
>> https://inverse.ca/sogo/lists
> 


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature