Re: [SOGo] SOGo 2->3: A significant number of calendar events are missing

2016-08-28 Thread "Laz C. Peterson" 
Awesome, thanks Ludovic!

Will send shortly.

~ Laz Peterson
Paravis, LLC
Ph: 951.319.3240 x201

> On Aug 25, 2016, at 10:32 AM, Ludovic Marcotte (lmarco...@inverse.ca) 
>  wrote:
> 
> On 2016-08-24 6:58 PM, "Laz C. Peterson" (l...@paravis.net) wrote:
> 
>> Any suggestions?  Anyone?
> 
> Export a calendar that exposes the issue using sogo-tool and send it to me. 
> I'll try it with v2/v3.
> 
> -- 
> Ludovic Marcotte
> lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
> Inverse inc. :: Leaders behind SOGo (http://sogo.nu), PacketFence 
> (http://packetfence.org) and Fingerbank (http://fingerbank.org)
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

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

Re: [SOGo] SOGo 2->3: A significant number of calendar events are missing

2016-08-25 Thread Ludovic Marcotte 

On 2016-08-24 6:58 PM, "Laz C. Peterson" (l...@paravis.net) wrote:


Any suggestions?  Anyone?


Export a calendar that exposes the issue using sogo-tool and send it to 
me. I'll try it with v2/v3.


--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu), PacketFence 
(http://packetfence.org) and Fingerbank (http://fingerbank.org)

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

Re: [SOGo] SOGo 2->3: A significant number of calendar events are missing

2016-08-24 Thread "Laz C. Peterson" 
Any suggestions?  Anyone?

We would love to upgrade to SOGo v3.  But if 80-90% of all calendar events 
disappear when accessing from the v3 interface, it doesn’t leave us with any 
option.

Whatever the issue is, it is happening in-between the SQL query and the XHR 
data.  So something in the SOGo backend … And I do not have the technical skill 
to debug that on my own.

Is there anything anyone can suggest that might help narrow down the source of 
this issue?

~ Laz Peterson
Paravis, LLC

> On Aug 22, 2016, at 9:26 AM, Laz C. Peterson (l...@paravis.net) 
>  wrote:
> 
> Comparing the XHR data between v2 and v3 is very interesting.
> 
> They both have the exact same request URL, for example 
> https://webmail.domain.com/SOGo/so/u...@domain.com/Calendar/eventsblocks?sd=20160731=20160903=monthview
>  
> 
> 
> However, the JSON data is structured differently and very incomplete between 
> the two versions.  Because the SQL queries are also the same, and both return 
> the exact same information (from the SQL debugging), there must be some sort 
> of major change in the way that data is processed.  Which, in our case, 
> removes 95% (or more) of the existing calendar data before sending the JSON 
> data to the client.
> 
> Any of the developers have insight on what could be causing this, or any 
> further troubleshooting steps?
> 
> ~ Laz Peterson
> Paravis, LLC
> 
>> On Aug 20, 2016, at 7:47 AM, Laz C. Peterson (l...@paravis.net 
>> ) > wrote:
>> 
>> I should also add that these calendar events do not appear in both the web 
>> UI and also the CalDAV client.
>> 
>> As said before, the SQL queries are pulling 100% of the records, same as in 
>> SOGo v2, but that data is not being 100% parsed or processed.  Something 
>> seems to be “disqualifying” some of these calendar entries from being served 
>> out by SOGo.
>> 
>> I wish I could offer more information — please tell me if there is a 
>> specific troubleshooting I can do to help.
>> 
>> Thanks Ludovic.
>> 
>> ~ Laz Peterson
>> Paravis, LLC
>> 
>>> On Aug 19, 2016, at 3:27 PM, Laz C. Peterson (l...@paravis.net 
>>> ) > wrote:
>>> 
>>> Hello there Ludovic,
>>> 
>>> There are actually no errors at all, even with debug mode on.
>>> 
>>> What has changed with the SQL select statements between SOGo 2 to SOGo 3?
>>> 
>>> For one of these calendars in question, we have hundreds of events in there 
>>> just this year alone.  But SOGo 3 does not actually show any events for 
>>> this year.
>>> 
>>> The SQL query that loads this data which is not shown pulls up 49 rows that 
>>> should appear in the August calendar.  But not one item is shown.  The same 
>>> query in SOGo v2 pulls up the exact same 49 rows of data, and all items are 
>>> shown in the calendar.
>>> 
>>> I don’t have much to go with here aside from that — there are no apparent 
>>> errors in the logs.  Could the SQL results possibly have an item missing 
>>> that SOGo v3 requires to place them on the calendar that SOGo v2 does not?
>>> 
>>> ~ Laz Peterson
>>> Paravis, LLC
>>> 
 On Aug 19, 2016, at 12:05 PM, Ludovic Marcotte (lmarco...@inverse.ca 
 ) > 
 wrote:
 
 On 2016-08-19 10:59 AM, "Laz C. Peterson" (l...@paravis.net 
 ) wrote:
 
> When logging in as a specific user on SOGo v2, we get all expected 
> calendar events.  At the same time, logging into the SOGo v3 server, only 
> a fraction of those events are there — in some cases, there are no 
> calendar events at all when we would expect dozens.
 Any errors in the sogo.log file for these users and calendars?
 
 -- 
 Ludovic Marcotte
 lmarco...@inverse.ca   ::  +1.514.755.3630  
 ::  http://inverse.ca 
 Inverse inc. :: Leaders behind SOGo (http://sogo.nu ), 
 PacketFence (http://packetfence.org ) and 
 Fingerbank (http://fingerbank.org )
 
 -- 
 users@sogo.nu 
 https://inverse.ca/sogo/lists 
>>> 
>>> -- 
>>> users@sogo.nu 
>>> https://inverse.ca/sogo/lists 
>> -- 
>> users@sogo.nu 
>> https://inverse.ca/sogo/lists
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

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

Re: [SOGo] SOGo 2->3: A significant number of calendar events are missing

2016-08-22 Thread "Laz C. Peterson" 
Comparing the XHR data between v2 and v3 is very interesting.

They both have the exact same request URL, for example 
https://webmail.domain.com/SOGo/so/u...@domain.com/Calendar/eventsblocks?sd=20160731=20160903=monthview

However, the JSON data is structured differently and very incomplete between 
the two versions.  Because the SQL queries are also the same, and both return 
the exact same information (from the SQL debugging), there must be some sort of 
major change in the way that data is processed.  Which, in our case, removes 
95% (or more) of the existing calendar data before sending the JSON data to the 
client.

Any of the developers have insight on what could be causing this, or any 
further troubleshooting steps?

~ Laz Peterson
Paravis, LLC

> On Aug 20, 2016, at 7:47 AM, Laz C. Peterson (l...@paravis.net) 
>  wrote:
> 
> I should also add that these calendar events do not appear in both the web UI 
> and also the CalDAV client.
> 
> As said before, the SQL queries are pulling 100% of the records, same as in 
> SOGo v2, but that data is not being 100% parsed or processed.  Something 
> seems to be “disqualifying” some of these calendar entries from being served 
> out by SOGo.
> 
> I wish I could offer more information — please tell me if there is a specific 
> troubleshooting I can do to help.
> 
> Thanks Ludovic.
> 
> ~ Laz Peterson
> Paravis, LLC
> 
>> On Aug 19, 2016, at 3:27 PM, Laz C. Peterson (l...@paravis.net 
>> ) > wrote:
>> 
>> Hello there Ludovic,
>> 
>> There are actually no errors at all, even with debug mode on.
>> 
>> What has changed with the SQL select statements between SOGo 2 to SOGo 3?
>> 
>> For one of these calendars in question, we have hundreds of events in there 
>> just this year alone.  But SOGo 3 does not actually show any events for this 
>> year.
>> 
>> The SQL query that loads this data which is not shown pulls up 49 rows that 
>> should appear in the August calendar.  But not one item is shown.  The same 
>> query in SOGo v2 pulls up the exact same 49 rows of data, and all items are 
>> shown in the calendar.
>> 
>> I don’t have much to go with here aside from that — there are no apparent 
>> errors in the logs.  Could the SQL results possibly have an item missing 
>> that SOGo v3 requires to place them on the calendar that SOGo v2 does not?
>> 
>> ~ Laz Peterson
>> Paravis, LLC
>> 
>>> On Aug 19, 2016, at 12:05 PM, Ludovic Marcotte (lmarco...@inverse.ca 
>>> ) > wrote:
>>> 
>>> On 2016-08-19 10:59 AM, "Laz C. Peterson" (l...@paravis.net 
>>> ) wrote:
>>> 
 When logging in as a specific user on SOGo v2, we get all expected 
 calendar events.  At the same time, logging into the SOGo v3 server, only 
 a fraction of those events are there — in some cases, there are no 
 calendar events at all when we would expect dozens.
>>> Any errors in the sogo.log file for these users and calendars?
>>> 
>>> -- 
>>> Ludovic Marcotte
>>> lmarco...@inverse.ca   ::  +1.514.755.3630  :: 
>>>  http://inverse.ca 
>>> Inverse inc. :: Leaders behind SOGo (http://sogo.nu ), 
>>> PacketFence (http://packetfence.org ) and 
>>> Fingerbank (http://fingerbank.org )
>>> 
>>> -- 
>>> users@sogo.nu 
>>> https://inverse.ca/sogo/lists 
>> 
>> -- 
>> users@sogo.nu 
>> https://inverse.ca/sogo/lists
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

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

Re: [SOGo] SOGo 2->3: A significant number of calendar events are missing

2016-08-20 Thread "Laz C. Peterson" 
I should also add that these calendar events do not appear in both the web UI 
and also the CalDAV client.

As said before, the SQL queries are pulling 100% of the records, same as in 
SOGo v2, but that data is not being 100% parsed or processed.  Something seems 
to be “disqualifying” some of these calendar entries from being served out by 
SOGo.

I wish I could offer more information — please tell me if there is a specific 
troubleshooting I can do to help.

Thanks Ludovic.

~ Laz Peterson
Paravis, LLC

> On Aug 19, 2016, at 3:27 PM, Laz C. Peterson (l...@paravis.net) 
>  wrote:
> 
> Hello there Ludovic,
> 
> There are actually no errors at all, even with debug mode on.
> 
> What has changed with the SQL select statements between SOGo 2 to SOGo 3?
> 
> For one of these calendars in question, we have hundreds of events in there 
> just this year alone.  But SOGo 3 does not actually show any events for this 
> year.
> 
> The SQL query that loads this data which is not shown pulls up 49 rows that 
> should appear in the August calendar.  But not one item is shown.  The same 
> query in SOGo v2 pulls up the exact same 49 rows of data, and all items are 
> shown in the calendar.
> 
> I don’t have much to go with here aside from that — there are no apparent 
> errors in the logs.  Could the SQL results possibly have an item missing that 
> SOGo v3 requires to place them on the calendar that SOGo v2 does not?
> 
> ~ Laz Peterson
> Paravis, LLC
> 
>> On Aug 19, 2016, at 12:05 PM, Ludovic Marcotte (lmarco...@inverse.ca 
>> ) > wrote:
>> 
>> On 2016-08-19 10:59 AM, "Laz C. Peterson" (l...@paravis.net 
>> ) wrote:
>> 
>>> When logging in as a specific user on SOGo v2, we get all expected calendar 
>>> events.  At the same time, logging into the SOGo v3 server, only a fraction 
>>> of those events are there — in some cases, there are no calendar events at 
>>> all when we would expect dozens.
>> Any errors in the sogo.log file for these users and calendars?
>> 
>> -- 
>> Ludovic Marcotte
>> lmarco...@inverse.ca   ::  +1.514.755.3630  ::  
>> http://inverse.ca 
>> Inverse inc. :: Leaders behind SOGo (http://sogo.nu ), 
>> PacketFence (http://packetfence.org ) and 
>> Fingerbank (http://fingerbank.org )
>> 
>> -- 
>> users@sogo.nu 
>> https://inverse.ca/sogo/lists
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

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

Re: [SOGo] SOGo 2->3: A significant number of calendar events are missing

2016-08-19 Thread Ludovic Marcotte 

On 2016-08-19 10:59 AM, "Laz C. Peterson" (l...@paravis.net) wrote:

When logging in as a specific user on SOGo v2, we get all expected 
calendar events.  At the same time, logging into the SOGo v3 server, 
only a fraction of those events are there — in some cases, there are 
no calendar events at all when we would expect dozens.

Any errors in the sogo.log file for these users and calendars?

--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu), PacketFence 
(http://packetfence.org) and Fingerbank (http://fingerbank.org)

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

[SOGo] SOGo 2->3: A significant number of calendar events are missing

2016-08-19 Thread "Laz C. Peterson" 
Hello SOGo users:

I am sure hoping someone has seen this issue before … We are in the process of 
upgrading from SOGo v2 to v3, and we took it for a production test run 
yesterday.  Immediately received complaints about empty calendars.

We are running SOGo v3.1.5 nightly build 201608190704, and have not updated our 
database schema.

When logging in as a specific user on SOGo v2, we get all expected calendar 
events.  At the same time, logging into the SOGo v3 server, only a fraction of 
those events are there — in some cases, there are no calendar events at all 
when we would expect dozens.

Any help will be very greatly appreciated.  Thank you!

~ Laz Peterson
Paravis, LLC

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