[SOGo] Error when marking tasks as done
Hi, When I wan't to mark a task as done, those errors are logged : Dec 08 16:23:59 sogod [27637]: 0x0x39c0110[GCSFolder] ERROR(-[GCSFolder writeContent:toName:baseVersion:]): cannot update content : MySQL4Exception: 0x36d20c0 NAME:ExecutionFailed REASON:Unknown column 'NO' in 'field list' Dec 08 16:23:59 sogod [27637]: [ERROR] 0x0240D710[SOGoTaskObject]:3AD4-4B7C1380-317-944590 write failed: MySQL4Exception: 0x36d20c0 NAME:ExecutionFailed REASON:Unknown column 'NO' in 'field list' What did I missed ? Sogo 1.3.9 / ubuntu 10.04 Pascal. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Error when marking tasks as done
Le 08/12/2011 17:05, Julian Robbins a écrit : On 08/12/11 15:29, Pascal Bourdais wrote: Hi, When I wan't to mark a task as done, those errors are logged : Dec 08 16:23:59 sogod [27637]: 0x0x39c0110[GCSFolder] ERROR(-[GCSFolder writeContent:toName:baseVersion:]): cannot update content : MySQL4Exception: 0x36d20c0 NAME:ExecutionFailed REASON:Unknown column 'NO' in 'field list' Dec 08 16:23:59 sogod [27637]: [ERROR] 0x0240D710[SOGoTaskObject]:3AD4-4B7C1380-317-944590 write failed: MySQL4Exception: 0x36d20c0 NAME:ExecutionFailed REASON:Unknown column 'NO' in 'field list' What did I missed ? There was a bug in 1.3.9 when using Mysql as the field name expects a 0 instead of a Null, or similar. It was fixed in 1.3.10, but that has some additional issues to content with. Best wait for 1.3.11 coming very soon OK, thank you for the reply. Julian Sogo 1.3.9 / ubuntu 10.04 Pascal. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sogo-tool - standard in must be tty
Le Wed, 06 Jul 2011 09:29:05 +0200, Philipp Strobl phil...@pilarkto.net a écrit : Hi, i have a script that execute the sogo-backup tool. For some reason it exits with an error: standard in must be a tty ? What does this mean ? The backup seems to be OK. It is not possible to run the sogo-tool from script ? I run it in a script with sudo -u sogo /usr/sbin/sogo-tool backup /home/sauve ALL and it works like a charm with the good config of sudo. I think su -u ... redirects tty and that's why you have this error. An other way is to run the script as user sogo, but you have to change the rights of /home/sogo/Backup. ... Regards, Pascal -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] script to remove double (or more)
Le Sun, 26 Jun 2011 21:22:39 +0200, Dominique dco...@hotmail.com a écrit : Hi, Great script idea, but I have a few questions: 1. what module to install in ubuntu 10.04 server to get the data::ical::datetime module installed correctly ? No luck so far. I'am on slackware for the scripts, so i use cpan. I have been asked to install this on ubuntu, and i used cpan again. 2. does the url needs to be https? In my case it is a simple http, and the script 'dies' at line 52 with an 'unauthorized' error. Since I am using a working account, is there something else to look for ? Can the https be change in the script for http only ? No need to be https, and no reference to it in the script (except comments). Check user and password, I test with http and it's ok for me. The module Net::SSLeay is needed for https to work. 3. what does the # of days refer to for the --doit variable? Thank copy/paste :( doit doesn't need anything else. HTH Pascal -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] script to remove double (or more)
Le Fri, 24 Jun 2011 13:30:12 +0200, Christian Mack christian.m...@uni-konstanz.de a écrit : Hi Pascal Bourdais ... I've just an enhancement request for it :-) At the moment you only check the default / personal calendar. It would be nice if you could also specify the calendar to check at the command line. Easy to do and useful. Done. Pascal -- users@sogo.nu https://inverse.ca/sogo/lists sup-double.pl Description: Perl program
Re: [SOGo] Mass events modify
Le Tue, 21 Jun 2011 10:35:54 +0200, Alessio Fattorini alessio.fattor...@nethesis.it a écrit : Hi, How can i modify more events at the same times Specifically i should make private some events (50/60) adding this field on vcalendar: CLASS=PRIVATE Can anyone suggest a way to do it? I'm working on something like this. It's just a try for now, but if it can help, modify and use -+-+-+-+ CUT +-+-+-+- #! /usr/bin/perl #use strict; use warnings; use Data::ICal; use Data::ICal::DateTime; use DateTime; use HTTP::DAV my ($url, $d, $cal, $calcontent); $url = http://xx/SOGo/dav;; $d = new HTTP::DAV(); # log with admin user. $d-credentials( -user='admin', -pass ='xxx', -url = $url); $d-open( -url= $url ) or die(Couldn't open $url: .$d-message . \n); $d-get(-url = usercode/Calendar/personal.ics, -to = \$calcontent); $cal = Data::ICal-new(data = $calcontent); my @events = $cal-events(); foreach my $event (@events) { if ($event-property('uid') eq 1845-4DF78B00-62E1-31B97100) { #if ($event-start $event-end) { #print uid:, $event-property('uid')-[0]-value, \n; #print summary:, $event-property('summary')-[0]-value, \n; #print dtstart:, $event-start, \n; #print dtend:, $event-end, \n; #print correction : ; $o = $event-end; $o-add(days=1); $event-end($o); #print dtend:, $event-end, \n; #print \n; print $event-as_string; print \n; #$d-delete($event-property('uid')-[0]-value); #$d-put(-local = \$event-as_string, -url = $event-property('uid')); } #exit; } -+-+-+-+ CUT +-+-+-+- -- P.Bourdais Infagri Rue Albert Einstein Parc Technopole de changé Bp 26116 53061 Laval Cedex 9 Tél: 02.43.49.84.40 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] EMail reminders
Le Fri, 10 Jun 2011 06:38:53 -0400 (EDT), ad...@locean-ipsl.upmc.fr a écrit : Bonjour, We have set-up Sogo on a server, everything is working fine. Some users asked me if it was possible to received events reminders via mail, instead of a pop-up via web sogo interface (in case they are connected through thunderbird). I saw on the installation guide the EMail reminders section and I had apply the following option on the configuration file: SOGoEnableEMailAlarms = YES; OCSEMailAlarmsFolderURL = mysql://user:password@host:port/sogo/sogo_alarms_folder; I add * * * * * /usr/sbin/sogo-ealarms-notify to the sogo's user crontab. and restarted sogo daemon. The problem is that nothing has changed, reminders still appears as pop-ups and not as email alerts. What could be wrong with my setup ? This config allow the use of mail as reminder. The users have to configure the event : rappel - personnalisé - choisir une action pour le rappel -- P.Bourdais Infagri Rue Albert Einstein Parc Technopole de changé Bp 26116 53061 Laval Cedex 9 Tél: 02.43.49.84.40 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Calendar events disappearing
Le Tue, 14 Sep 2010 14:38:15 +0900, Jeremy Kiffiak takod...@gmail.com a écrit : Hi, I experienced this problem with one of my users and found the reason why : The username is lowercase and the user log in with uppercase. The authentification was correct, but the function is curious and leads to lose of event. I have to open a bug for this. Pascal Hello everyone, Currently I have SOGo installed and running in a testing environment for a client. The main tester has been experiencing a troubling situation where anI have some users who are complaining about disappearing events in the SOGo calendars. I have just finished watching one of the users demo this problem for me and am at a complete loss as to why this would be happening. I hope someone can help me to solve this troubling issue. We are using SOGo 1.3.1 on a Ubuntu 10.04 virtual machine (using KVM). Additionally the SOGo VM is running Postgres 8.4 and Apache 2.2.14. OpenLDAP is running on a separate eBox VM. The clients are Firefox 3.6.8 (running on both Mac OS X and Windows) and Safari 5.0.1 on OS X. Everything appears to function correctly until an event is modified. Typically the first edit (changing the name of the event, adding to the description, etc) will have no adverse affect. However, subsequent modifications will often cause the event to disappear completely from the calendar. Logging out of the account and logging back in does not fix the problem. I have created additional LDAP accounts to test this problem in SOGo with mixed success. Some accounts have no problem at all with the disappearing calendar events and others also have experienced this issue. I would like to figure out what is causing this problem though my next idea is to simply drop the current Postres DB and start fresh. HELP! Please let me know what additional information would be useful. Thanks in advance, Jeremy -- P.Bourdais Infagri Rue Albert Einstein Parc Technopole de changé Bp 26116 53061 Laval Cedex 9 Tél: 02.43.49.84.40 -- users@sogo.nu https://inverse.ca/sogo/lists