Re: [SOGo] everything off by one hour this week ?

2015-10-21 Thread Brigitte Marchiset 

Hello,

I have the same problem with the events of this week.

Does this problem is due to the time change to be held this weekend?

Can we fix it without changing the version?

Thanks in advance,

Best regards,

Brigitte Marchiset



On 10/20/2015 05:13 PM, Aurélien Minet wrote:

On 10/20/2015 03:51 PM, Christian Mack wrote:

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

Solution:
Upgrade to SOGo 2.3.2, then open the events in this week and store them
again.

Hi tanks for the information,

updating to 2.3.2 is ok (and done) but opening all the events of this 
week and save them again for every user isn't :(

sogo-tool can't help ? or an sql update in database ?

regards

Aurélien



--

.  Brigitte MARCHISET.  e-mail : march...@irit.fr  .
.  T: 05 61 55 63 43 . .


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

Re: [SOGo] everything off by one hour this week ?

2015-10-21 Thread Christian Mack 
Hello

Am 21.10.2015 um 09:44 schrieb Brigitte Marchiset:
> 
> I have the same problem with the events of this week.
> 
> Does this problem is due to the time change to be held this weekend?
> 

Yes.

> Can we fix it without changing the version?
> 

No.


> On 10/20/2015 05:13 PM, Aurélien Minet wrote:
>> On 10/20/2015 03:51 PM, Christian Mack wrote:
>>> http://www.sogo.nu/bugs/view.php?id=3344
>>>
>>> Solution:
>>> Upgrade to SOGo 2.3.2, then open the events in this week and store them
>>> again.
>> Hi tanks for the information,
>>
>> updating to 2.3.2 is ok (and done) but opening all the events of this
>> week and save them again for every user isn't :(
>> sogo-tool can't help ? or an sql update in database ?
>>

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] everything off by one hour this week ?

2015-10-21 Thread Christian Mack 
Hello

Am 20.10.2015 um 17:13 schrieb Aurélien Minet:
> On 10/20/2015 03:51 PM, Christian Mack wrote:
>> http://www.sogo.nu/bugs/view.php?id=3344
>>
>> Solution:
>> Upgrade to SOGo 2.3.2, then open the events in this week and store them
>> again.
>
> Hi tanks for the information,
> 
> updating to 2.3.2 is ok (and done) but opening all the events of this
> week and save them again for every user isn't :(
> sogo-tool can't help ? or an sql update in database ?
> 

There is no such thing AFAIK.

We solved it by informing the users after upgrade, which had events in
this week.
You can get those with something like this:
---
#!/bin/bash
export DB_SERVER=databasehost
export DATABASE=sogo
export DB_USER=sogo

rm calendarTables.txt
rm betroffeneTabellen.txt

echo "select c_location from sogo_folder_info where
c_folder_type='Appointment'\g calendarTables.txt"|psql -d ${DATABASE} -h
${DB_SERVER} -q -t -U ${DB_USER} -w -A

cat calendarTables.txt|while read
do
export DB_TABLE=${REPLY##*/}
export NUMBER=`echo -e "select count(*) from ${DB_TABLE} where
c_content like '%DTSTART%:20151018T%' or c_content like
'%DTSTART%:20151019T%' or c_content like '%DTSTART%:20151020T%' or
c_content like '%DTSTART%:20151021T%' or c_content like
'%DTSTART%:20151022T%' or c_content like '%DTSTART%:20151023T%' or
c_content like '%DTSTART%:20151024T%';"|psql -d ${DATABASE} -h
${DB_SERVER} -q -t -U ${DB_USER} -w -A`
if [ ${NUMBER} -ne 0 ]
then
echo ${DB_TABLE} >>betroffeneTabellen.txt
echo -e "select c_path2 from sogo_folder_info where
c_location like '%${DB_TABLE}';"|psql -d ${DATABASE} -h ${DB_SERVER} -q
-t -U ${DB_USER} -w -A >>popIDBetroffen.txt
fi
done

betroffeneTabellen.txt will contain the users.


But yes, there are always some, who can not read emails :-/


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] everything off by one hour this week ?

2015-10-20 Thread Christian Mack 
Am 20.10.2015 um 15:19 schrieb Per Jessen:
> For some reason, all my my calendar entries are listed one hour late,
> but only this week (43). Any ideas? 
> 
> 
http://www.sogo.nu/bugs/view.php?id=3344

Solution:
Upgrade to SOGo 2.3.2, then open the events in this week and store them
again.


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] everything off by one hour this week ?

2015-10-20 Thread Aurélien Minet 

On 10/20/2015 03:51 PM, Christian Mack wrote:

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

Solution:
Upgrade to SOGo 2.3.2, then open the events in this week and store them
again.

Hi tanks for the information,

updating to 2.3.2 is ok (and done) but opening all the events of this 
week and save them again for every user isn't :(

sogo-tool can't help ? or an sql update in database ?

regards

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

Re: [SOGo] everything off by one hour this week ?

2015-10-20 Thread Tanstaafl 
On 10/20/2015 9:51 AM, Christian Mack 
wrote:
> Am 20.10.2015 um 15:19 schrieb Per Jessen:
>> For some reason, all my my calendar entries are listed one hour late,
>> but only this week (43). Any ideas? 

> http://www.sogo.nu/bugs/view.php?id=3344
> 
> Solution:
> Upgrade to SOGo 2.3.2, then open the events in this week and store them
> again.

Wow, this could be a huge issue in larger installations.

Is there a sogo-tool command that could accomplish this for all users at
once?
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] everything off by one hour this week ?

2015-10-20 Thread Per Jessen 
For some reason, all my my calendar entries are listed one hour late,
but only this week (43). Any ideas? 


-- 
Per Jessen, Zürich (10.2°C)
http://www.dns24.ch/ - free dynamic DNS, made in Switzerland.

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