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 : 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: 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
[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 : 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: 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] Sogo-tool - standard in must be tty
Le Wed, 06 Jul 2011 09:29:05 +0200, Philipp Strobl 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 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 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
[SOGo] script to remove double (or more)
Bonjour, Because of some problems with funambol/android, i need a script to remove events that where synchronized more than one time on sogo. As I didn't found it, I wrote a perl script to fit my needs. I join it, if someone think it can help, please use and modify. I consider a double to have same start date/end date and summary, but may be i missed something, please feedback. 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 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 => "/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), 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] ModulesConstraints in xml GNUstepDefaults
Le Thu, 9 Jun 2011 09:55:37 -0400 (EDT), a écrit : Hi, By using defaults -u sogo write ..., it gives SOGoUserSources <...> ModulesConstraints Mail objectclass nonExistingClass SearchFieldNames <...> > > how could I insert > " ModulesConstraints = { > Mail = { >objectClass = nonExistingClass; >}; >};" > in a new xml style .GNUstepDefaults with defaults write sogod > > or is there any other way to disable mail in Sogo? > > Kind regards, -- 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
[SOGo] Android sync with CLASS:CONFIDENTIAL
Hi, We are using SOGo (1.3.7) with funambol (DS Server v.9.0.0), Funambol Android Sync Client 9.0.3 and the calendar application calendrier 1.1 shipped with the Galaxy S smartphone. When syncing the data, the CLASS info is always public. I tried to trace the dialog (wireshark on the server, log level to trace on the smartphone) and i never see the CLASS:CONFIDENTIAL set while we set it on the smartphone (it doesn't work on the other way either). I think the problem is on the calendar app, but i'm not sure. If the app is the problem, which calendar app are you using ? Thank you for your advises, Pascal -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Calendar events disappearing
Le Tue, 14 Sep 2010 14:38:15 +0900, Jeremy Kiffiak 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
Re: [SOGo] Re: ANN: SOGo v1.2.2
Le Fri, 07 May 2010 14:44:57 -0400, Wolfgang Sourdeau a écrit : Hi Wolfgang, > > > This is definitely a cache problem on your side because the yum metadata > is fine on our servers... I don't know enough of yum to tell you which > command yuou should execute. It was a problem in the yum's config. The proxy was not used even if declared in http_proxy and ftp_proxy environment vars. > It seems your computer does not even > connect to our machine... This give me the way. Thanks a lot, -- P.Bourdais Gie Infagri Rue Albert Einstein Parc Technopole de changé 53061 Laval Cedex 9 Tél: 02.43.49.84.40 « Celui qui est prêt à sacrifier un peu de liberté pour obtenir un peu de sécurité ne mérite vraiment ni l'une, ni l'autre. » ( Benjamin Franklin ) -- users@sogo.nu https://inverse.ca/sogo/lists